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
|
/* -*- 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 = ["a", "b", "c"];
let index = 0;
for (let name in stmt.params) {
if (name == "QueryInterface")
continue;
do_check_eq(name, expected[index++]);
}
}
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;
do_check_eq(stmt.params.test, 2);
stmt.finalize();
}
function test_row_prototype()
{
let stmt = createStatement(
"SELECT * FROM sqlite_master"
);
do_check_true(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;
do_check_eq(stmt.row.test, 2);
// Clean up after ourselves.
delete Object.getPrototypeOf(stmt.row).test;
stmt.finalize();
}
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_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 " +
")"
);
// Run the tests.
tests.forEach(test => test());
}
|
