-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.js
122 lines (97 loc) · 2.78 KB
/
main.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
// this runs when page is finished loading
$(document).ready(function () {
createTables();
insertWithTransaction();
insertNoTransaction();
tableInfo();
version();
});
function tableInfo() {
$.ajax({
url: "api.php",
method: "POST",
data: {
action: 'tableInfo'
},
dataType: "json",
success: function (response) {
$out = '<li> Table info: <br>';
$out += 'executionTimeSeconds: ' + response.executionTimeSeconds + '<br>';
$out += '</li>';
$('#output').append($out);
}
});
}
function version() {
$.ajax({
url: "api.php",
method: "POST",
data: {
action: 'version'
},
dataType: "json",
success: function (response) {
$out = '<li> Sqlite version: <br>';
$out += response.result[0]['sqlite_version()'] + "<br>";
$out += 'executionTimeSeconds: ' + response.executionTimeSeconds + '<br>';
$out += '</li>';
$('#output').append($out);
}
});
}
function insertWithTransaction() {
rowCount = 100;
$.ajax({
url: "api.php",
method: "POST",
data: {
rowCount: rowCount,
action: 'insertWithTransaction'
},
dataType: "json",
success: function (response) {
$out = '<li> Insert with Transactionn: <br>';
$out += 'rows inserted: ' + rowCount + "<br>";
$out += 'lastInsertId: ' + response.result + '<br>';
$out += 'executionTimeSeconds: ' + response.executionTimeSeconds + '<br>';
$out += '</li>';
$('#output').append($out);
}
});
}
function insertNoTransaction() {
rowCount = 100;
$.ajax({
url: "api.php",
method: "POST",
data: {
rowCount: rowCount,
action: 'insertNoTransaction'
},
dataType: "json",
success: function (response) {
$out = '<li> Insert no Transactionn: <br>';
$out += 'rows inserted: ' + rowCount + "<br>";
$out += 'lastInsertId: ' + response.result + '<br>';
$out += 'executionTimeSeconds: ' + response.executionTimeSeconds + '<br>';
$out += '</li>';
$('#output').append($out);
}
});
}
function createTables() {
$.ajax({
url: "api.php",
method: "POST",
data: {
action: 'createTables'
},
dataType: "json",
success: function (response) {
$out = '<li> Create tables: <br>';
$out += 'executionTimeSeconds: ' + response.executionTimeSeconds + '<br>';
$out += '</li>';
$('#output').append($out);
}
});
}