samedi 27 juin 2015

How to fetch and send sqlite data stored on device one by one to web server?

I am completely a new developer in terms of Structured Query Language. Since from last 1.5 years i have been working on MongoDb which is NoSql db and hence facing above problem. I am developing one cordova application in ionic framework. User usually fill the data into the form which is stored in the local sqlite database of mobile when internet is offline. When the device got connection the data present in the sqlite db should be sent to server one by one and at the same time that should be deleted on success. I dont have any idea of sqlite looping structure & didnt get any matching solution

My database is this:

document.addEventListener("deviceready", function () {

            db = $cordovaSQLite.openDB("myDb.db");
            $cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS formData (id integer primary key,form_id text, data text)");

I am using ngCordova for sqlite access. Any help would be appreciated.

Aucun commentaire:

Enregistrer un commentaire