samedi 23 avril 2016

I want to create a sample project using Sqlite plugin (Cordova) in Hybrid Mobile Apllication?

I referred the code mentioned in http://ift.tt/1O3yCJy Link. Database file is not generated. Any help should be appreciated.

document.addEventListener('deviceready', onDeviceReady, false);

function onDeviceReady() { var db = window.sqlitePlugin.openDatabase({name: 'my.db', location: 'default'});

db.transaction(function(tx) { tx.executeSql('DROP TABLE IF EXISTS test_table'); tx.executeSql('CREATE TABLE IF NOT EXISTS test_table (id integer primary key, data text, data_num integer)');

// demonstrate PRAGMA:
db.executeSql("pragma table_info (test_table);", [], function(res) {
  console.log("PRAGMA res: " + JSON.stringify(res));
});

tx.executeSql("INSERT INTO test_table (data, data_num) VALUES (?,?)", ["test", 100], function(tx, res) {
  console.log("insertId: " + res.insertId + " -- probably 1");
  console.log("rowsAffected: " + res.rowsAffected + " -- should be 1");

  db.transaction(function(tx) {
    tx.executeSql("select count(id) as cnt from test_table;", [], function(tx, res) {
      console.log("res.rows.length: " + res.rows.length + " -- should be 1");
      console.log("res.rows.item(0).cnt: " + res.rows.item(0).cnt + " -- should be 1");
    });
  });

}, function(e) {
  console.log("ERROR: " + e.message);
});

}); }

Aucun commentaire:

Enregistrer un commentaire