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






film izle

hd film izle

film sitesi

takipci kazanma sitesi

takipci kazanma sitesi

güzel olan herşey

takipci alma sitesi

komik eğlenceli videolar