[ST2.1 RC2] SQL Proxy accessing incorrect Filter property

You need to access the getter for the anyMatch filter config.

Not sure if this is planned for 2.1 release, but it'd be nice to get this patch applied.

Here is a patch

Code:

---

diff --git a/vendor/sencha/touch/src/data/proxy/SQL.js b/vendor/sencha/touch/src/data/proxy/SQL.js
index 1df2d47..c6978bd 100644
--- a/vendor/sencha/touch/src/data/proxy/SQL.js
+++ b/vendor/sencha/touch/src/data/proxy/SQL.js
@@ -272,7 +272,7 @@ Ext.define('Ext.data.proxy.SQL', {
                    property = filter.getProperty();
                    value = filter.getValue();
                    if (property !== null) {
-                        sql += filterStatement + property + ' ' + (filter.anyMatch ? ('LIKE \'%' + value + '%\'') : ('= \'' + value + '\''));
+                        sql += filterStatement + property + ' ' + (filter.getAnyMatch() ? ('LIKE \'%' + value + '%\'') : ('= \'' + value + '\''));
                        filterStatement = ' AND ';
                    }
                }

---

I have problems with line 268 !

ln = params.filters.length;

When there are no filters setup in the proxy config...

Thanks for the report! I have opened a bug in our bug tracker.

Me too. I just pass empty arrays for now. And I've been using #load to setup new ones.

However, Im having larger issues getting inserts to work, so I've ended up doing all the executeSql by hand.

Quote:

---

Originally Posted by rkraus

I have problems with line 268 !

ln = params.filters.length;

When there are no filters setup in the proxy config...

---

I've fixed the issues with filters.

@wprater Can you tell me what particular issues you are having with inserts?

Quote:

---

Originally Posted by TommyMaintz

I've fixed the issues with filters.

@wprater Can you tell me what particular issues you are having with inserts?

---

I haven't been able to dig into your callback chain, but it's stalling out Chrome when I #sync the store that's using the SQL proxy. I am, however, doing a very large set of inserts. I'll do another test today, but I was checking the raw sqlite database and it was not growing.

This is just a one time setup/import and Im inserting ~80k records into the table.

Inserting the records manually with executeSql takes a bit of time, but will succeed. After which new selects are fast, which is relieving.

@Tommy

When I try to save a datamodel with an ARRAY in it I ran into problem.
After I load the record from WebSQL I am gettings objects instead of an ARRAY :-(

Is this a bug or will I have to EnCode and DeCode this array in JSON (for example).

Greets,

Ralf Kraus