Advertisement
Guest User

Untitled

a guest
Jun 30th, 2015
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function onDeviceReady() {
  2.         document.addEventListener("backbutton", onBackKeyDown, false);
  3.         db = window.openDatabase("myLocalDB", "1.0", "Users", 200000);
  4.         db.transaction(populateDB, errorCB, successCB);
  5.     }
  6.  
  7.     function errorCB(tx, error) {
  8.         console.log("In Error Function");
  9.      alert("Database Error: " + error);
  10.     }
  11.        
  12.     function successCB() {
  13.      dbCreated = true;
  14.      console.log("Successfully inserted");
  15.     }
  16.  
  17. function populateDB(tx) {
  18.     var sql1 = 'CREATE TABLE IF NOT EXISTS Users (id INTEGER PRIMARY KEY, idNumber, uName varchar(255))';
  19.     var sql2 = 'CREATE TABLE IF NOT EXISTS Sample1 (id INTEGER PRIMARY KEY, dId INTEGER, Name varchar(255), desc varchar(255), imgPath varchar(255))';
  20.     var sql3 = 'CREATE TABLE IF NOT EXISTS Sample2 (id INTEGER PRIMARY KEY, storeId INTEGER, storeName varchar(255))';
  21.     tx.executeSql(sql1);
  22.  
  23.         var test =  new Array();
  24.         for(var i = 0; i < 10; i++) {
  25.             (function(i){
  26.                 test[i]="INSERT INTO Users (id, idNumber, uName) VALUES (i,i,'test')";
  27.             })(i);
  28.            
  29.         }
  30.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement