ujjwalguptaofficial / JsStore

Simplifying IndexedDB with SQL like syntax and promises
http://jsstore.net/
MIT License
858 stars 110 forks source link

JSStore Encrypt Data issues #329

Closed shaangidwani closed 1 year ago

shaangidwani commented 1 year ago

JSStore Encrypt Data issues

We have implemented JSStore with encrypt but we have some issues in that

  1. When we try to set encrypt date-time time fields it gives the error below : err message: Invalid array length

  2. When any data is null and that column is set as encrypted then it gives the error: err message : Cannot read properties of undefined (reading 'encrypt')

Try to select data with decrypt attribute but sometime its gives decrypt data and sometime its gives encrypt data

ex :

getPatient() { return await this.connection.select({ from: this.tableName, decrypt: true })

sometimes Its gives decrypts data but most of the time its gives encrypts data.

  1. When selecting the data with join table and join table having encrypted value then its not decrypted any data.

{ with: TableNames.Patients,
on: TableNames.Visits + ".PatientID=" + TableNames.Patients+".PatientID", as: { OLPatientID: TableNames.Visits + "_OLPatientID", FacilityID: TableNames.Facility + "_FacilityID", PracticeID: TableNames.Patients + "_PracticeID",

                }
            },

in the above example, if the patient table has encrypted values like first name and last name, it does not always give decrypted values.

I have already submitted issues on jsstore-encrypt repository but I have not gotten any help.

Please anyone who can help on this will be highly appreciated.

ujjwalguptaofficial commented 1 year ago

Hey

I am traveling, will take a look as soon as I can.

On Wed, 5 Jul 2023, 11:54 am shaangidwani, @.***> wrote:

Assigned #329 https://github.com/ujjwalguptaofficial/JsStore/issues/329 to @ujjwalguptaofficial https://github.com/ujjwalguptaofficial.

— Reply to this email directly, view it on GitHub https://github.com/ujjwalguptaofficial/JsStore/issues/329#event-9727281878, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACTOR53ZWTX7FJWQ5XH6OYTXOUCDPANCNFSM6AAAAAAZ6PFFQA . You are receiving this because you were assigned.Message ID: @.***>

shaangidwani commented 1 year ago

thanks @ujjwalguptaofficial

shaangidwani commented 1 year ago

We have modify datetime to intiger with date value and its encrypt the data