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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
/* -*- indent-tabs-mode: nil; js-indent-level: 2 -*- */
/* vim: set sw=2 ts=2 sts=2 et : */
/**
* Any copyright is dedicated to the Public Domain.
* http://creativecommons.org/publicdomain/zero/1.0/
*/
/**
* This file tests that the JS language helpers in various ways.
*/
// Test Functions
function test_params_enumerate() {
let stmt = createStatement("SELECT * FROM test WHERE id IN (:a, :b, :c)");
// Make sure they are right.
let expected = [0, 1, 2, "a", "b", "c", "length"];
let index = 0;
for (let name in stmt.params) {
if (name == "QueryInterface") {
continue;
}
Assert.equal(name, expected[index++]);
}
Assert.equal(index, 7);
}
function test_params_prototype() {
let stmt = createStatement("SELECT * FROM sqlite_master");
// Set a property on the prototype and make sure it exist (will not be a
// bindable parameter, however).
Object.getPrototypeOf(stmt.params).test = 2;
Assert.equal(stmt.params.test, 2);
delete Object.getPrototypeOf(stmt.params).test;
stmt.finalize();
}
function test_row_prototype() {
let stmt = createStatement("SELECT * FROM sqlite_master");
Assert.ok(stmt.executeStep());
// Set a property on the prototype and make sure it exists (will not be in the
// results, however).
Object.getPrototypeOf(stmt.row).test = 2;
Assert.equal(stmt.row.test, 2);
// Clean up after ourselves.
delete Object.getPrototypeOf(stmt.row).test;
stmt.finalize();
}
function test_row_enumerate() {
let stmt = createStatement("SELECT * FROM test");
Assert.ok(stmt.executeStep());
let expected = ["id", "string"];
let expected_values = [123, "foo"];
let index = 0;
for (let name in stmt.row) {
Assert.equal(name, expected[index]);
Assert.equal(stmt.row[name], expected_values[index]);
index++;
}
Assert.equal(index, 2);
// Save off the row helper, then forget the statement and trigger a GC. We
// want to ensure that if the row helper is retained but the statement is
// destroyed, that no crash occurs and that the late access attempt simply
// throws an error.
let savedOffRow = stmt.row;
stmt = null;
Cu.forceGC();
Assert.throws(
() => {
return savedOffRow.string;
},
/NS_ERROR_NOT_INITIALIZED/,
"GC'ed statement should throw"
);
}
function test_params_gets_sync() {
// Added for bug 562866.
/*
let stmt = createStatement(
"SELECT * FROM test WHERE id IN (:a, :b, :c)"
);
// Make sure we do not assert in getting the value.
let originalCount = Object.getOwnPropertyNames(stmt.params).length;
let expected = ["a", "b", "c"];
for (let name of expected) {
stmt.params[name];
}
// Now make sure we didn't magically get any additional properties.
let finalCount = Object.getOwnPropertyNames(stmt.params).length;
do_check_eq(originalCount + expected.length, finalCount);
*/
}
function test_params_gets_async() {
// Added for bug 562866.
/*
let stmt = createAsyncStatement(
"SELECT * FROM test WHERE id IN (:a, :b, :c)"
);
// Make sure we do not assert in getting the value.
let originalCount = Object.getOwnPropertyNames(stmt.params).length;
let expected = ["a", "b", "c"];
for (let name of expected) {
stmt.params[name];
}
// Now make sure we didn't magically get any additional properties.
let finalCount = Object.getOwnPropertyNames(stmt.params).length;
do_check_eq(originalCount + expected.length, finalCount);
*/
}
// Test Runner
var tests = [
test_params_enumerate,
test_params_prototype,
test_row_enumerate,
test_row_prototype,
test_params_gets_sync,
test_params_gets_async,
];
function run_test() {
cleanup();
// Create our database.
getOpenedDatabase().executeSimpleSQL(
"CREATE TABLE test (id INTEGER PRIMARY KEY, string TEXT)"
);
getOpenedDatabase().executeSimpleSQL(
"INSERT INTO test (id, string) VALUES (123, 'foo')"
);
// Run the tests.
tests.forEach(test => test());
}
|
