The Tor Browser / file comparison

comparison: storage/test/unit/test_storage_value_array.js

storage/test/unit/test_storage_value_array.js

branch
TOR_BUG_9701
changeset 8
97036ab72558
equal deleted inserted replaced
-1:000000000000 0:aa3e21fade4a
1 /* This Source Code Form is subject to the terms of the Mozilla Public
2 * License, v. 2.0. If a copy of the MPL was not distributed with this
3 * file, You can obtain one at http://mozilla.org/MPL/2.0/. */
4
5 // This file tests the functions of mozIStorageValueArray
6
7 function setup()
8 {
9 getOpenedDatabase().createTable("test", "id INTEGER PRIMARY KEY, name TEXT," +
10 "number REAL, nuller NULL, blobber BLOB");
11
12 var stmt = createStatement("INSERT INTO test (name, number, blobber) " +
13 "VALUES (?1, ?2, ?3)");
14 stmt.bindByIndex(0, "foo");
15 stmt.bindByIndex(1, 2.34);
16 stmt.bindBlobByIndex(2, [], 0);
17 stmt.execute();
18
19 stmt.bindByIndex(0, "");
20 stmt.bindByIndex(1, 1.23);
21 stmt.bindBlobByIndex(2, [1, 2], 2);
22 stmt.execute();
23
24 stmt.reset();
25 stmt.finalize();
26 }
27
28 function test_getIsNull_for_null()
29 {
30 var stmt = createStatement("SELECT nuller, blobber FROM test WHERE id = ?1");
31 stmt.bindByIndex(0, 1);
32 do_check_true(stmt.executeStep());
33
34 do_check_true(stmt.getIsNull(0)); // null field
35 do_check_true(stmt.getIsNull(1)); // data is null if size is 0
36 stmt.reset();
37 stmt.finalize();
38 }
39
40 function test_getIsNull_for_non_null()
41 {
42 var stmt = createStatement("SELECT name, blobber FROM test WHERE id = ?1");
43 stmt.bindByIndex(0, 2);
44 do_check_true(stmt.executeStep());
45
46 do_check_false(stmt.getIsNull(0));
47 do_check_false(stmt.getIsNull(1));
48 stmt.reset();
49 stmt.finalize();
50 }
51
52 function test_value_type_null()
53 {
54 var stmt = createStatement("SELECT nuller FROM test WHERE id = ?1");
55 stmt.bindByIndex(0, 1);
56 do_check_true(stmt.executeStep());
57
58 do_check_eq(Ci.mozIStorageValueArray.VALUE_TYPE_NULL,
59 stmt.getTypeOfIndex(0));
60 stmt.reset();
61 stmt.finalize();
62 }
63
64 function test_value_type_integer()
65 {
66 var stmt = createStatement("SELECT id FROM test WHERE id = ?1");
67 stmt.bindByIndex(0, 1);
68 do_check_true(stmt.executeStep());
69
70 do_check_eq(Ci.mozIStorageValueArray.VALUE_TYPE_INTEGER,
71 stmt.getTypeOfIndex(0));
72 stmt.reset();
73 stmt.finalize();
74 }
75
76 function test_value_type_float()
77 {
78 var stmt = createStatement("SELECT number FROM test WHERE id = ?1");
79 stmt.bindByIndex(0, 1);
80 do_check_true(stmt.executeStep());
81
82 do_check_eq(Ci.mozIStorageValueArray.VALUE_TYPE_FLOAT,
83 stmt.getTypeOfIndex(0));
84 stmt.reset();
85 stmt.finalize();
86 }
87
88 function test_value_type_text()
89 {
90 var stmt = createStatement("SELECT name FROM test WHERE id = ?1");
91 stmt.bindByIndex(0, 1);
92 do_check_true(stmt.executeStep());
93
94 do_check_eq(Ci.mozIStorageValueArray.VALUE_TYPE_TEXT,
95 stmt.getTypeOfIndex(0));
96 stmt.reset();
97 stmt.finalize();
98 }
99
100 function test_value_type_blob()
101 {
102 var stmt = createStatement("SELECT blobber FROM test WHERE id = ?1");
103 stmt.bindByIndex(0, 2);
104 do_check_true(stmt.executeStep());
105
106 do_check_eq(Ci.mozIStorageValueArray.VALUE_TYPE_BLOB,
107 stmt.getTypeOfIndex(0));
108 stmt.reset();
109 stmt.finalize();
110 }
111
112 function test_numEntries_one()
113 {
114 var stmt = createStatement("SELECT blobber FROM test WHERE id = ?1");
115 stmt.bindByIndex(0, 2);
116 do_check_true(stmt.executeStep());
117
118 do_check_eq(1, stmt.numEntries);
119 stmt.reset();
120 stmt.finalize();
121 }
122
123 function test_numEntries_all()
124 {
125 var stmt = createStatement("SELECT * FROM test WHERE id = ?1");
126 stmt.bindByIndex(0, 2);
127 do_check_true(stmt.executeStep());
128
129 do_check_eq(5, stmt.numEntries);
130 stmt.reset();
131 stmt.finalize();
132 }
133
134 function test_getInt()
135 {
136 var stmt = createStatement("SELECT id FROM test WHERE id = ?1");
137 stmt.bindByIndex(0, 2);
138 do_check_true(stmt.executeStep());
139
140 do_check_eq(2, stmt.getInt32(0));
141 do_check_eq(2, stmt.getInt64(0));
142 stmt.reset();
143 stmt.finalize();
144 }
145
146 function test_getDouble()
147 {
148 var stmt = createStatement("SELECT number FROM test WHERE id = ?1");
149 stmt.bindByIndex(0, 2);
150 do_check_true(stmt.executeStep());
151
152 do_check_eq(1.23, stmt.getDouble(0));
153 stmt.reset();
154 stmt.finalize();
155 }
156
157 function test_getUTF8String()
158 {
159 var stmt = createStatement("SELECT name FROM test WHERE id = ?1");
160 stmt.bindByIndex(0, 1);
161 do_check_true(stmt.executeStep());
162
163 do_check_eq("foo", stmt.getUTF8String(0));
164 stmt.reset();
165 stmt.finalize();
166 }
167
168 function test_getString()
169 {
170 var stmt = createStatement("SELECT name FROM test WHERE id = ?1");
171 stmt.bindByIndex(0, 2);
172 do_check_true(stmt.executeStep());
173
174 do_check_eq("", stmt.getString(0));
175 stmt.reset();
176 stmt.finalize();
177 }
178
179 function test_getBlob()
180 {
181 var stmt = createStatement("SELECT blobber FROM test WHERE id = ?1");
182 stmt.bindByIndex(0, 2);
183 do_check_true(stmt.executeStep());
184
185 var count = { value: 0 };
186 var arr = { value: null };
187 stmt.getBlob(0, count, arr);
188 do_check_eq(2, count.value);
189 do_check_eq(1, arr.value[0]);
190 do_check_eq(2, arr.value[1]);
191 stmt.reset();
192 stmt.finalize();
193 }
194
195 var tests = [test_getIsNull_for_null, test_getIsNull_for_non_null,
196 test_value_type_null, test_value_type_integer,
197 test_value_type_float, test_value_type_text, test_value_type_blob,
198 test_numEntries_one, test_numEntries_all, test_getInt,
199 test_getDouble, test_getUTF8String, test_getString, test_getBlob];
200
201 function run_test()
202 {
203 setup();
204
205 for (var i = 0; i < tests.length; i++)
206 tests[i]();
207
208 cleanup();
209 }
210

Mercurial Repository: The Tor Browser

Europalab SCM Repository Server

mercurial