178UxS7F

1function defaultQuerySuccess(tx, res) {
2    console.log('Query Success');
3    console.log(res);
4};
5
6function defaultQueryError(tx, res) {
7    console.log('Query Error');
8    console.log(tx);
9    console.log(res);
10};
11
12function executeQuery(query, params, successHandler, errorHandler) {
13
14    console.log("QUERY: " + query);
15
16    if (!params) params = [];
17    if (!successHandler) successHandler = defaultQuerySuccess;
18    if (!errorHandler) errorHandler = defaultQueryError;
19
20    _db.transaction(function(tx) {
21        tx.executeSql(query, params, successHandler, errorHandler);
22    });
23
24}
25
26function initDB() {
27
28    //use webSQL if deviceReady not fired i.e. for Chrome
29    if (!_isDeviceReadyFired) {
30        _dbHandler = window;
31        _db = _dbHandler.openDatabase('aceApp', '1.0', 'Test DB', 2 * 1024 * 1024);
32    } else {
33        _db = _dbHandler.openDB("aceApp.db");
34    }
35
36    createLeadsTable();
37
38}
39
40function createLeadsTable() {
41
42    var createLeads = "CREATE TABLE IF NOT EXISTS leads (leadsObject text)";
43
44    executeQuery(createLeads, null, function(res) {
45        addLeads();
46        defaultQuerySuccess(res);
47    });
48
49}
50
51function addLeads() {
52
53    var insertQuery = "INSERT INTO leads (leadsObject) VALUES (?)";
54    var leads = [{
55        "name": "Harmon Butler",
56        "email": "harmonbutler@medifax.com",
57        "mobileNumber": "+91 825-416-3338",
58        "progress": 5
59    }, {
60        "name": "Mooney Roman",
61        "email": "mooneyroman@medifax.com",
62        "mobileNumber": "+91 825-554-2012",
63        "progress": 6
64    }, {
65        "name": "Janis Valenzuela",
66        "email": "janisvalenzuela@medifax.com",
67        "mobileNumber": "+91 825-450-2392",
68        "progress": 7
69    }, {
70        "name": "Juliana Nash",
71        "email": "juliananash@medifax.com",
72        "mobileNumber": "+91 825-591-3992",
73        "progress": 8
74    }, {
75        "name": "Rich Jenkins",
76        "email": "richjenkins@medifax.com",
77        "mobileNumber": "+91 825-412-3007",
78        "progress": 9
79    }, {
80        "name": "Mosley Daugherty",
81        "email": "mosleydaugherty@medifax.com",
82        "mobileNumber": "+91 825-546-3739",
83        "progress": 10
84    }, {
85        "name": "Ora Mckay",
86        "email": "oramckay@medifax.com",
87        "mobileNumber": "+91 825-484-3302",
88        "progress": 11
89    }];;
90    var param = [];
91    param.push(JSON.stringify(leads));
92    executeQuery(insertQuery, param);
93
94}