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
|
/* Any copyright is dedicated to the Public Domain.
http://creativecommons.org/publicdomain/zero/1.0/ */
"use strict";
/**
* This file tests that a missing root folder is correctly fixed when the
* database is loaded.
*/
const ALL_ROOT_GUIDS = [
PlacesUtils.bookmarks.menuGuid,
PlacesUtils.bookmarks.unfiledGuid,
PlacesUtils.bookmarks.toolbarGuid,
PlacesUtils.bookmarks.tagsGuid,
PlacesUtils.bookmarks.mobileGuid,
];
add_task(async function setup() {
await setupPlacesDatabase([
"migration",
`places_v${Ci.nsINavHistoryService.DATABASE_SCHEMA_VERSION}.sqlite`,
]);
// Prepare database contents by removing the root folder.
let path = PathUtils.join(PathUtils.profileDir, DB_FILENAME);
let db = await Sqlite.openConnection({ path });
await db.execute(
`
DELETE FROM moz_bookmarks WHERE guid = :guid
`,
{
guid: PlacesUtils.bookmarks.rootGuid,
}
);
await db.close();
});
add_task(async function test_database_recreates_roots() {
Assert.ok(
PlacesUtils.history.databaseStatus ==
PlacesUtils.history.DATABASE_STATUS_OK ||
PlacesUtils.history.databaseStatus ==
PlacesUtils.history.DATABASE_STATUS_UPGRADED,
"Should successfully access the database for the first time"
);
let db = await PlacesUtils.promiseDBConnection();
let rows = await db.execute(
`
SELECT id, parent, type FROM moz_bookmarks
WHERE guid = :guid
`,
{ guid: PlacesUtils.bookmarks.rootGuid }
);
Assert.equal(rows.length, 1, "Should have added exactly one root");
Assert.greaterOrEqual(
rows[0].getResultByName("id"),
1,
"Should have a valid root Id"
);
Assert.equal(
rows[0].getResultByName("parent"),
0,
"Should have a parent of id 0"
);
Assert.equal(
rows[0].getResultByName("type"),
PlacesUtils.bookmarks.TYPE_FOLDER,
"Should have a type of folder"
);
let id = rows[0].getResultByName("id");
Assert.equal(
await PlacesTestUtils.promiseItemId(PlacesUtils.bookmarks.rootGuid),
id,
"Should return the correct id from promiseItemId"
);
Assert.equal(
await PlacesTestUtils.promiseItemGuid(id),
PlacesUtils.bookmarks.rootGuid,
"Should return the correct guid from promiseItemGuid"
);
// Note: Currently we do not fix the parent of the folders on initial startup.
// There is a maintenance task that will do it, hence we don't check the parents
// here, just that the built-in folders correctly exist and haven't been
// duplicated.
for (let guid of ALL_ROOT_GUIDS) {
rows = await db.execute(
`
SELECT id FROM moz_bookmarks
WHERE guid = :guid
`,
{ guid }
);
Assert.equal(rows.length, 1, "Should have exactly one row for the root");
let root = await PlacesUtils.bookmarks.fetch(guid);
Assert.equal(root.guid, guid, "GUIDs should match");
}
});
|
