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
|
/* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/. */
/*
* This file tests the functionality of
* mozIStorageAsyncConnection::executeSimpleSQLAsync.
*/
const INTEGER = 1;
const TEXT = "this is test text";
const REAL = 3.23;
add_task(function* test_create_and_add() {
let adb = yield openAsyncDatabase(getTestDB());
let completion = yield executeSimpleSQLAsync(adb,
"CREATE TABLE test (id INTEGER, string TEXT, number REAL)");
do_check_eq(Ci.mozIStorageStatementCallback.REASON_FINISHED, completion);
completion = yield executeSimpleSQLAsync(adb,
"INSERT INTO test (id, string, number) " +
"VALUES (" + INTEGER + ", \"" + TEXT + "\", " + REAL + ")");
do_check_eq(Ci.mozIStorageStatementCallback.REASON_FINISHED, completion);
let result = null;
completion = yield executeSimpleSQLAsync(adb,
"SELECT string, number FROM test WHERE id = 1",
function (aResultSet) {
result = aResultSet.getNextRow();
do_check_eq(2, result.numEntries);
do_check_eq(TEXT, result.getString(0));
do_check_eq(REAL, result.getDouble(1));
}
);
do_check_eq(Ci.mozIStorageStatementCallback.REASON_FINISHED, completion);
do_check_neq(result, null);
result = null;
yield executeSimpleSQLAsync(adb, "SELECT COUNT(0) FROM test",
function (aResultSet) {
result = aResultSet.getNextRow();
do_check_eq(1, result.getInt32(0));
});
do_check_neq(result, null);
yield asyncClose(adb);
});
add_task(function* test_asyncClose_does_not_complete_before_statement() {
let adb = yield openAsyncDatabase(getTestDB());
let executed = false;
let reason = yield executeSimpleSQLAsync(adb, "SELECT * FROM test",
function (aResultSet) {
let result = aResultSet.getNextRow();
do_check_neq(result, null);
do_check_eq(3, result.numEntries);
do_check_eq(INTEGER, result.getInt32(0));
do_check_eq(TEXT, result.getString(1));
do_check_eq(REAL, result.getDouble(2));
executed = true;
}
);
do_check_eq(Ci.mozIStorageStatementCallback.REASON_FINISHED, reason);
// Ensure that the statement executed to completion.
do_check_true(executed);
yield asyncClose(adb);
});
|
