PouchDB compatibility

[robobit]

I'm trying to make this work with PouchDB. So far I made a couple of fixes to PouchDB, specifically to pass the encryption key in. Also pouch caches database objects on their name only, changed this to use the full options, ie. also the encryption key.
Now a have basic operation with pouch and sqlcipher working (can put and get objects), however queries fail (both temporary and persistent). Any ideas how to make this work or hints how to fix it?

[brodycj]

Unfortunately I am not so experienced with running PouchDB and cannot promise when I will have a chance to look at this issue.

[robobit]

Thanks for your quick response. I'm still investigating the issue, it doesn't seem to be sqlcipher specific, I get the same problem when using the normal sqlite plugin.

In my log I get this error:

Error in Success callbackId: SQLitePlugin238116064 : TypeError: undefined is not an object (evaluating 'r.type')

Which occurs in the mycb callback in SQLitePlugin.js (~ line 407).

[brodycj]

I think this is caused by the problem reported in storesafe/cordova-sqlite-storage/issues/409. A quick fix is to edit www/SQLitePlugin.js as follows:

$ git diff -U7 www
diff --git a/www/SQLitePlugin.js b/www/SQLitePlugin.js
index c9e2c88..e0a00b8 100644
--- a/www/SQLitePlugin.js
+++ b/www/SQLitePlugin.js
@@ -118,15 +118,15 @@
   };

   SQLitePlugin.prototype.readTransaction = function(fn, error, success) {
     if (!this.openDBs[this.dbname]) {
       error(newSQLError('database not open'));
       return;
     }
-    this.addTransaction(new SQLitePluginTransaction(this, fn, error, success, false, true));
+    this.addTransaction(new SQLitePluginTransaction(this, fn, error, success, true, true));
   };

   SQLitePlugin.prototype.startNextTransaction = function() {
     var self;
     self = this;
     nextTick((function(_this) {
       return function() {

[robobit]

I can confirm that this indeed fixes the issue.

Thank you so much!

[brodycj]

A workaround fix is now integrated and covered by the test suite.