1. #21
    Sencha User tomalex0's Avatar
    Join Date
    Apr 2009
    Location
    San Jose, CA
    Posts
    589
    Vote Rating
    16
    tomalex0 will become famous soon enough

      0  

    Default


    It looks likes stores and models are defined before db connection. Can you define dbconnection outside

    regApplication before store and model.
    Sencha Touch Demos

    IosToggleField Forum - Github
    Form Validation
    Forum - Github
    Iphone Settings Menu
    Forum
    Sqlite Storage & Login Manifest
    Forum
    KitchenSink MVC
    Forum - Github
    SqliteProxy-v1 Forum - Github
    SqliteProxy-v2
    Forum - Github
    Arshaw Fullcalendar Forum - Github






  2. #22
    Sencha User
    Join Date
    Sep 2011
    Posts
    6
    Vote Rating
    0
    disy_schmidt is on a distinguished road

      0  

    Default SqliteProxy License?

    SqliteProxy License?


    @ tomalex(): I would also like to use your SqliteProxy in my app based on PhoneGap and Sencha Touch. Which license is your SqliteProxy? My app I create will be eventually a commercial product some day. That's why I'm asking.
    Thanks for your answer!

  3. #23
    Sencha User tomalex0's Avatar
    Join Date
    Apr 2009
    Location
    San Jose, CA
    Posts
    589
    Vote Rating
    16
    tomalex0 will become famous soon enough

      0  

    Default


    Quote Originally Posted by disy_schmidt View Post
    @ tomalex(): I would also like to use your SqliteProxy in my app based on PhoneGap and Sencha Touch. Which license is your SqliteProxy? My app I create will be eventually a commercial product some day. That's why I'm asking.
    Thanks for your answer!
    Actually i haven't took time to understand those license . You are free to use this, it will be always open.
    Sencha Touch Demos

    IosToggleField Forum - Github
    Form Validation
    Forum - Github
    Iphone Settings Menu
    Forum
    Sqlite Storage & Login Manifest
    Forum
    KitchenSink MVC
    Forum - Github
    SqliteProxy-v1 Forum - Github
    SqliteProxy-v2
    Forum - Github
    Arshaw Fullcalendar Forum - Github






  4. #24
    Sencha User
    Join Date
    Sep 2011
    Posts
    6
    Vote Rating
    0
    disy_schmidt is on a distinguished road

      0  

    Default


    @tomalex() That's really great! Thank you!

  5. #25
    Sencha User
    Join Date
    Nov 2011
    Location
    León, Spain
    Posts
    77
    Vote Rating
    3
    diesalher is on a distinguished road

      0  

    Default


    Thanks! I was exactly looking for this.

    I'm gonna try your plugin in my app.

  6. #26
    Ext JS Premium Member
    Join Date
    Aug 2010
    Posts
    4
    Vote Rating
    0
    goeast is on a distinguished road

      0  

    Question Mysql to Sqlite

    Mysql to Sqlite


    Hi,

    great Plugin tomalex0.

    Is there a way to put data from a webserver (ajax) into the sqlite database on first startup of the app?
    After, i want to use the app offline and check only for updates when the phone is online.

    Thank you for your response.
    Regards, Adrian

  7. #27
    Sencha User
    Join Date
    Sep 2011
    Posts
    23
    Vote Rating
    0
    eryx is on a distinguished road

      0  

    Thumbs up UNIQUE KEYS

    UNIQUE KEYS


    Hey there really appreciate your work. I'm using your code for some time and it really helps me.
    At the moment I try to create a table where to fields together build an Unique key

    Code:
    CREATE TABLE test(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, Content TEXT, groupid INTEGER, leaguecode INTEGER, leaguetext TEXT, leaguetype TEXT, wertungsmodus TEXT, UNIQUE (groupid, leaguecode) ON CONFLICT REPLACE);
    This is my sql to create the table but I don't know how I can do this like it is intended with an sqlitestorage.

    PHP Code:
    var dbconnval = {
        
    dbName"app24",
        
    dbDescription"app24_db",
    };
    Ext.DbConnection = new Ext.Sqlite.Connection(dbconnval);

    Ext.regModel('othergroups', {
        
    fields: [
            {
                
    name'id',
                
    type'int',
                
    fieldOption'NOT NULL PRIMARY KEY AUTOINCREMENT'
            
    }, {
                
    name'content',
                
    type'string'
            
    }, {
                
    name'groupid',
                
    type'int'
            
    }, {
                
    name'leaguecode',
                
    type'int'
            
    }, {
                
    name'leaguetext',
                
    type'string'
            
    }, {
                
    name'leaguetype',
                
    type'string'
            
    }, {
                
    name'wertungsmodus',
                
    type'string'
            
    }
        ],
        
    proxy: {
            
    type'sqlitestorage',
            
    dbConfig: {
                
    tablename'othergroups',
                
    dbConnExt.DbConnection.dbConn
            
    },
            
    reader: {
                
    idProperty'ID'
            
    }
        },
        
    writer: {
            
    type'json'
        
    }
    }); 
    Normally I build it like the one above and I know I can set fieldOption to 'UNIQUE'. This works perfectly. But this time the field groupdid and leaguecode build together a UNIQUE key.

    I hope you can help me point me to the right point. Thanks for any help

  8. #28
    Sencha User tomalex0's Avatar
    Join Date
    Apr 2009
    Location
    San Jose, CA
    Posts
    589
    Vote Rating
    16
    tomalex0 will become famous soon enough

      0  

    Default


    @goeast
    Sorry for late reply, i also thought to implement a feature like that. I will update you once it is finished.

    @eryx

    I haven't came across situation like this
    Code:
    UNIQUE (groupid, leaguecode) ON CONFLICT REPLACE
    . Probably we need to change the way query is build in create section. Let me check and will let you
    Sencha Touch Demos

    IosToggleField Forum - Github
    Form Validation
    Forum - Github
    Iphone Settings Menu
    Forum
    Sqlite Storage & Login Manifest
    Forum
    KitchenSink MVC
    Forum - Github
    SqliteProxy-v1 Forum - Github
    SqliteProxy-v2
    Forum - Github
    Arshaw Fullcalendar Forum - Github






  9. #29
    Sencha User
    Join Date
    Sep 2011
    Posts
    23
    Vote Rating
    0
    eryx is on a distinguished road

      0  

    Talking Thanks!

    Thanks!


    Thanks that would be amazing if you could implement something like that.

    Greetings Eryx

  10. #30
    Sencha User tomalex0's Avatar
    Join Date
    Apr 2009
    Location
    San Jose, CA
    Posts
    589
    Vote Rating
    16
    tomalex0 will become famous soon enough

      0  

    Default


    Hi,

    For time being can you try something like below mentioned field options and it is based on query that you have shown, its not a proper way but will do the trick.

    Code:
    fields: [{
    				name: 'ID',
    				type: 'int',
    				fieldOption: 'NOT NULL PRIMARY KEY AUTOINCREMENT'
    			},{
    				name: 'Content',
    				type: 'string'
    			}, {
    				name: 'groupid',
    				type: 'int'
    			},{
    				name: 'leaguecode',
    				type: 'int'
    			},{
    				name : 'leaguetext',
    				type: 'string'
    			},{
    				name : 'wertungsmodus',
    				type : 'string',
    				fieldOption : ',UNIQUE (groupid, leaguecode) ON CONFLICT REPLACE'
    			}]
    Sencha Touch Demos

    IosToggleField Forum - Github
    Form Validation
    Forum - Github
    Iphone Settings Menu
    Forum
    Sqlite Storage & Login Manifest
    Forum
    KitchenSink MVC
    Forum - Github
    SqliteProxy-v1 Forum - Github
    SqliteProxy-v2
    Forum - Github
    Arshaw Fullcalendar Forum - Github






Turkiyenin en sevilen filmlerinin yer aldigi xnxx internet sitemiz olan ve porn sex tarzi bir site olan mobil porno izle sitemiz gercekten dillere destan bir durumda herkesin sevdigi bir site olarak tarihe gececege benziyor. Sitenin en belirgin ozelliklerinden birisi de Turkiyede gercekten kaliteli ve muntazam, duzenli porno izle siteleri olmamasidir. Bu yuzden iste. Ayrica en net goruntu kalitesine sahip adresinde yayinlanmaktadir. Mesela diğer sitelerimizden bahsedecek olursak, en iyi hd porno video arşivine sahip bir siteyiz. "The Best anal porn videos and slut anus, big asses movies set..."