e7DJSdmg

1jQuery promise deferred
2var dbo = openDatabase('dbName','1.0','Description goes here', 1048576);
3
4console.log(jQuery.fn.jquery); // 1.7.1
5var myPromise1 = dbo.transaction(function(myTrans) {
6    myTrans.executeSql('drop table myTable;');
7}).promise();
8myPromise1.done(function() {
9    var myPromise2 = dbo.transaction(function(myTrans) {
10        myTrans.executeSql(
11            'CREATE TABLE IF NOT EXISTS myTable' 
12            + '(FieldID Integer NOT NULL PRIMARY KEY'
13            + ',FieldName Text'
14            + ');'
15        );
16    }).promise();
17    myPromise2.done(function() {
18        dbo.transaction(function(myTrans) {
19            myTrans.executeSql("INSERT INTO myTable(FieldID,FieldName) VALUES(1,'A'");
20            myTrans.executeSql("INSERT INTO myTable(FieldID,FieldName) VALUES(2,'B'");
21            myTrans.executeSql("INSERT INTO myTable(FieldID,FieldName) VALUES(3,'C'");
22        });
23    });
24});