1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
add_task(async function test_get_query_param_sql_function() {
let db = await PlacesUtils.promiseDBConnection();
await Assert.rejects(
db.execute(`SELECT get_query_param()`),
/wrong number of arguments/
);
let rows = await db.execute(`SELECT
get_query_param('a=b&c=d', 'a'),
get_query_param('a=b&c=d', 'c'),
get_query_param('a=b&a=c', 'a'),
get_query_param('a=b&c=d', 'e'),
get_query_param('a', 'a'),
get_query_param(NULL, NULL),
get_query_param('a=b&c=d', NULL),
get_query_param(NULL, 'a')`);
let results = ["b", "d", "b", null, "", null, null, null];
equal(rows[0].numEntries, results.length);
for (let i = 0; i < results.length; ++i) {
equal(rows[0].getResultByIndex(i), results[i]);
}
});
|