how to store data from rest service to local database.

[pritu patel]

I am trying to store data in my local database.
But I store data to local storage from Rest service.
I want to insert data in local database from my rest service.
How to do it to insert directly in local database.???

[Maryna Brodina]

Hello!

Please take a look here http://docs.appery.io/tutorials/build...

[pritu patel]

I tried this url.But I can't insert in my database.
I can't understand that where to write js code Because I want to store data from rest service.
so can you explain how to do that in appery??
I share my app also with appery.The name of the app is"test".

[Maryna Brodina]

This link should help http://docs.appery.io/tutorials/build...
Here is more information http://dev.w3.org/html5/webdatabase/
Example for saving data in localStorage prefunction populateDB(tx) {
tx.executeSql('DROP TABLE IF EXISTS DEMO');
tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")');
}

function errorCB(err) {
alert("Error processing SQL: "+err.code);
}

function successCB() {
alert("success!");
}

var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
db.transaction(populateDB, errorCB, successCB);/preYou can add such code on service success event.

[pritu patel]

above idea not working.
I can't insert in database.
Query not working on application

[Maryna Brodina]

Hello!

Here is how to view localDatabase in chrome: http://docs.appery.io/tutorials/build...
Here is how to build small application to work with local Database:
1) create new application
2) place button to page
3) create event for button on "Click" event for action "Run javascript"
4) enter the following code in javascript functionprefunction populateDB(tx) {
tx.executeSql('DROP TABLE IF EXISTS DEMO');
tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")');
}

function errorCB(err) {
alert("Error processing SQL: "+err.code);
}

function successCB() {
alert("success!");
}
var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
db.transaction(populateDB, errorCB, successCB);/pre5) test Application and make sure that local database with data appeared

Please keep in mind not every browser supports Web SQL databases.

[Balázs Kisgadó]

Hello,

The tutorial links above are not working. Could you please give an updated link?

Thank you!

[Illya Stepanov]

Hi Balázs - We've removed this tutorial, such app logic should be implemented by you now.