2ZYcugyx

1// Form values
2var formValues = [{
3    tablename: "table_1",
4    id: "id_1",
5    desc: "desc_1",
6    dataType: "TEXT"
7}, {
8    tablename: "table_2",
9    id: "id_2",
10    desc: "desc_2",
11    dataType: "TEXT"
12}, {
13    ...
14    ...
15    ...
16    ...
17}, {
18    tablename: "table_28",
19    id: "id_28",
20    desc: "desc_28",
21    dataType: "TEXT"
22}];
23	
24function onDeviceReady() {
25    for (var i = 0; i < formValues.length; i++) {
26        var createFormValues = 'CREATE TABLE IF NOT EXISTS ' + formValues[i].tablename + ' (' + formValues[i].id + ' INTEGER, ' + formValues[i].desc + ' ' + formValues[i].dataType + ')';
27        alert("SQL: " + createFormValues +
28            "nnForm: " + formValues +
29            "nName: " + formValues[i].tablename +
30            "nID: " + formValues[i].id +
31            "nDesc: " + formValues[i].desc +
32            "nType: " + formValues[i].dataType);
33
34        db.transaction(function (tx) { tx.executeSql(createFormValues); });
35    }
36};
37	
38createFormTables("table_1", "id_1", "desc_1", "TEXT");
39createFormTables("table_2", "id_2", "desc_2", "TEXT");
40createFormTables("...", "...", "...", "...");
41createFormTables("table_28", "id_28", "desc_28", "TEXT");
42	
43createFormTables: function (tableName, id, description, dataType) {
44    var sql = 'CREATE TABLE IF NOT EXISTS ' + tableName + ' (' + id + ' INTEGER, ' + description + ' ' + dataType + ')';
45    alert("Create Form Field SQL: " + sql);
46    db.transaction(function (tx) { tx.executeSql(sql); });
47},