tidev / appcelerator.encrypteddatabase Goto Github PK

Problem:

• I recently started using this module, I was able to encrypt the db and make it work but then all the null values in the database , when fetched from the collection are shown as 127.
• For example
  with sqlcipher-cli, when I do

> select * from Action where id=22;
[
  {
    uuid: '1f699926-68fc-4069-921d-873de4fcf93e',
    id: 22,
    application_id: 4,
    action_text: 'Action for regulatory notification 1',
    actionee_id: 1,
    due_date: '2028-04-28',
    closed_date: null,
    status: 'Open',
    created_at: '2022-02-01 07:48:00',
    updated_at: '2022-02-01 07:48:00',
    created_by: null,
    modified_by: null,
    form_record_id: null,
    form_record_uuid: null,
    requires_sync: null,
    deleted: null,
    linked_form_version_id: null,
    linked_form_record_id: null,
    linked_form_record_uuid: null,
    inform_question_uuid: null,
    is_inform_inline_action: null
  }
]

but same when I fetch from collection as

 var actionCollection = Alloy.createCollection("Action");
 unsyncActionCollection.fetch({
        query: "SELECT * FROM Action where id=22"
 });
console.warn(unsyncActionCollection.models);

I get this instead
attributes: { uuid: '1f699926-68fc-4069-921d-873de4fcf93e', id: 22, application_id: 4, action_text: 'Action for regulatory notification 1', actionee_id: 1, due_date: '2028-04-28', closed_date: 127, status: 'Open', created_at: '2022-02-01 07:48:00', updated_at: '2022-02-01 07:48:00', created_by: 127, modified_by: 127, form_record_id: 127, form_record_uuid: 127, requires_sync: 127, deleted: 127, linked_form_version_id: 127, linked_form_record_id: 127, linked_form_record_uuid: 127, inform_question_uuid: 127, is_inform_inline_action: 127 }

So, there is conflict datas, Any thoughts whats the issue here ?