SqliteProxy

[tomalex0]

I used to work with sqlite storage for while but didn't thought to write down a separate proxy until i came across http://www.sencha.com/forum/showthre...roxy.IndexedDB by grgur . So heavily depending on his code set and help from Lisimba I tried to write down another sqliteproxy for sencha touch. This is just in initial stage.

I write down the proxy based on implementing a Demo Functionality and it works fine for it. Usecase of others will be different. So please have a look and let me know your feed back.

You can find code and demo implementation under
SqliteProxy-Github

Note : Sencha guys already planned for this.

[temolesto]

Thanks a lot, i'm just starting with Sencha and this is the first thing that i was looking into.

[tomalex0]

Nice to know that this turned out to be helpful for you. If you come across any issues please let me know

[temolesto]

how can i change the Proxy.dbConfig.dbQuery of a sqliteproxy after definition of the store or model

i want to press a button and change the criteria of the selected rows of the table, i have tried this when updating

var p = myStore.getProxy();
p.queryDB(p.dbConfig.dbConn, 'Update table set column=300;');

successfully executing the update query or select some data

function querySuccess(tx, results) {
    document.getElementById('total').innerHTML=results.rows.item(0).Num+' Total';
    }
    var p = this.store.getProxy();
    p.queryDB(p.dbConfig.dbConn, 'select count(*) as Num FROM table;',querySuccess);

but now i want to change the dbquery of the storage and i cant find how to do this

var p = this.store.getProxy();
p.dbconfig.dbQuery = 'Select * from table order by column desc Limit 30';

im just starting with sencha and js in general, thanks for your help

[tomalex0]

Can you try

this.store.load();

after setting the dbQuery

[temolesto]

thanks, my error was actually dbconfig should be dbConfig

var p = this.store.getProxy();
p.dbConfig.dbQuery = 'Select * from table order by column desc Limit 30';
this.store.load();

thanks for your help