SqliteProxy for ST2

[ThisIsCool]

Hello

I tried the SqliteProxy , both ST1 & ST2.

ST1 runs perfect, really nice, just what I'm looking for, thank you very much.

But when running the demo for the ST2 version, I got Type Error, on SqliteProxy.js 137.

I'm using the ST2 RC, is SqliteProxy v2 broken under this ST2 RC?

Thank you very much.

[tomalex0]

Hi All,

I was quite busy with my works, i'm working on this proxy compatible for STRC2, there were some roadblocks while porting. Hopefully i can finish it in couple of days. But i'm not sure how good it gonna work.

One limitation as of for now is
if we have table field name as "id" which is a primary key, we will have to mention a dummy name(not a field in table) as idProperty of model and clientIdProperty as "id". The issue is that default idProperty of model is "id" which will always have value like this "ext-record-x". If mentioned config options are not specified in model, id value in table will be like ext-record-1,2,3. But we expect it as integer.

http://docs.sencha.com/touch/2-0/sou...Ext-data-Model look for setId this actual adds idProperty("id") to model even if we are not specifying id as field option.

I'm looking into possibility to avoid this config dependency.

[ThisIsCool]

Hi tomalex

Thank you for your reply. Looking forward to your update.

For now as a temporary fix, I used what anhnt3 posted, to init dbConn again, and somehow got it to work.

Thanks.

[tomalex0]

Hi

I have updated github with latest change, please have a look

[MauiRa]

When I run your sample app in Safari 5.1.2, which is what the latest IOS uses, I get this error:

TypeError: Type error SqliteProxy.js:128

Here is where it errors:

The native code seems to reject the callback function. This works in this browser with Sencha Touch 1.1.

me.dbConfig.dbConn.transaction(function(tx) {

var onError = function(tx, err) {
me.throwDbError(tx, err);
};

var onSucess = function(tx, results) {
console.log("success");
}

var createTable = function() {
var createsql = 'CREATE TABLE IF NOT EXISTS ' + me.dbConfig.tablename + '('+me.constructFields()+')';
tx.executeSql(createsql,[],onSucess,onError);
}
var tablesql = 'SELECT * FROM '+ me.dbConfig.tablename+' LIMIT 1';
tx.executeSql(tablesql,[], Ext.emptyFn, createTable);
});[IMG]file:///C:/Program%20Files%20(x86)/Common%20Files/Apple/Apple%20Application%20Support/WebKit.resources/inspector/Images/errorIcon.png[/IMG]SqliteProxy.js:128TypeError: Type error

[die_for_rock_vn]

Does anyone try Sqlite proxy + phonegap 1.5 in iOS? I make it works in android but doesn't work in iOS.

[tomalex0]

Hi
I have looked into the issue with proxy not working in safari 5, somehow the reference to database object in safari is changed, Can anyone test sqliteproxy in safari 4 ?


If you look into below two images, where ""Reference" is database object passed with model
and "Freshly Created" is new database created using openDatabase function inside the proxy . Comparing both objects its seen that the passed database config is considered only as a simple object in safari 5, but it should be a database object.


I'm not sure where it is going wrong,

Safari
safari.jpg


Chrome
chrome.jpg

[tomalex0]

Hi,
Please get latest code from github, issue related to safari is fixed.

[die_for_rock_vn]

working in safari and iOS with Phonegap.
Best regards.

[MauiRa]

It works perfectly with Safari 5.X now. Thanks for your quick solution!