GCC Code Coverage Report


Directory: cvmfs/
File: cvmfs/history_sql.cc
Date: 2025-07-13 02:35:07
Exec Total Coverage
Lines: 163 179 91.1%
Branches: 489 1012 48.3%

Line Branch Exec Source
1 /**
2 * This file is part of the CernVM File System.
3 */
4
5 #include "history_sql.h"
6
7 #include <cassert>
8
9 #include "util/string.h"
10
11 namespace history {
12
13 const float HistoryDatabase::kLatestSchema = 1.0;
14 const float HistoryDatabase::kLatestSupportedSchema = 1.0;
15 const unsigned HistoryDatabase::kLatestSchemaRevision = 3;
16
17 /**
18 * Database Schema ChangeLog:
19 *
20 * Schema Version 1.0
21 * -> Revision 3: deprecate (flush) table 'recycle_bin'
22 * add table 'branches'
23 * add column 'branch' to table tags
24 * -> Revision 2: add table 'recycle_bin'
25 * -> Revision 1: add field 'size'
26 *
27 */
28
29 const std::string HistoryDatabase::kFqrnKey = "fqrn";
30
31
32 /**
33 * This method creates a new database file and initializes the database schema.
34 */
35 1268 bool HistoryDatabase::CreateEmptyDatabase() {
36
1/2
✗ Branch 1 not taken.
✓ Branch 2 taken 1268 times.
1268 assert(read_write());
37
38
3/6
✓ Branch 2 taken 1268 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 1268 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 1268 times.
✗ Branch 9 not taken.
2536 sqlite::Sql sql_foreign_keys(sqlite_db(), "PRAGMA foreign_keys = ON;");
39
2/4
✓ Branch 1 taken 1268 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 1268 times.
1268 if (!sql_foreign_keys.Execute())
40 return false;
41
42
6/13
✓ Branch 1 taken 1268 times.
✗ Branch 2 not taken.
✓ Branch 3 taken 1268 times.
✗ Branch 4 not taken.
✗ Branch 5 not taken.
✓ Branch 6 taken 1268 times.
✗ Branch 7 not taken.
✓ Branch 8 taken 1268 times.
✗ Branch 9 not taken.
✓ Branch 11 taken 1268 times.
✗ Branch 12 not taken.
✓ Branch 13 taken 1268 times.
✗ Branch 14 not taken.
1268 return CreateBranchesTable() && CreateTagsTable() && CreateRecycleBinTable();
43 1268 }
44
45
46 1268 bool HistoryDatabase::CreateTagsTable() {
47
1/2
✗ Branch 1 not taken.
✓ Branch 2 taken 1268 times.
1268 assert(read_write());
48
3/6
✓ Branch 2 taken 1268 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 1268 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 1268 times.
✗ Branch 9 not taken.
2536 return sqlite::Sql(
49 sqlite_db(),
50 "CREATE TABLE tags (name TEXT, hash TEXT, revision INTEGER, "
51 " timestamp INTEGER, channel INTEGER, description TEXT, size "
52 "INTEGER, "
53 " branch TEXT, CONSTRAINT pk_tags PRIMARY KEY (name), "
54 " FOREIGN KEY (branch) REFERENCES branches (branch));")
55
1/2
✓ Branch 1 taken 1268 times.
✗ Branch 2 not taken.
2536 .Execute();
56 }
57
58
59 1288 bool HistoryDatabase::CreateRecycleBinTable() {
60
1/2
✗ Branch 1 not taken.
✓ Branch 2 taken 1288 times.
1288 assert(read_write());
61
3/6
✓ Branch 2 taken 1288 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 1288 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 1288 times.
✗ Branch 9 not taken.
2576 return sqlite::Sql(sqlite_db(),
62 "CREATE TABLE recycle_bin (hash TEXT, flags INTEGER, "
63 " CONSTRAINT pk_hash PRIMARY KEY (hash))")
64
1/2
✓ Branch 1 taken 1288 times.
✗ Branch 2 not taken.
2576 .Execute();
65 }
66
67
68 1298 bool HistoryDatabase::CreateBranchesTable() {
69
1/2
✗ Branch 1 not taken.
✓ Branch 2 taken 1298 times.
1298 assert(read_write());
70
71 sqlite::Sql sql_create(sqlite_db(),
72 "CREATE TABLE branches (branch TEXT, parent TEXT, "
73 "initial_revision INTEGER,"
74 " CONSTRAINT pk_branch PRIMARY KEY (branch), "
75 " FOREIGN KEY (parent) REFERENCES branches (branch), "
76 " CHECK ((branch <> '') OR (parent IS NULL)), "
77
3/6
✓ Branch 2 taken 1298 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 1298 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 1298 times.
✗ Branch 9 not taken.
2596 " CHECK ((branch = '') OR (parent IS NOT NULL)));");
78
1/2
✓ Branch 1 taken 1298 times.
✗ Branch 2 not taken.
1298 bool retval = sql_create.Execute();
79
1/2
✗ Branch 0 not taken.
✓ Branch 1 taken 1298 times.
1298 if (!retval)
80 return false;
81
82 sqlite::Sql sql_init(
83 sqlite_db(),
84 "INSERT INTO branches (branch, parent, initial_revision) "
85
3/6
✓ Branch 2 taken 1298 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 1298 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 1298 times.
✗ Branch 9 not taken.
2596 "VALUES ('', NULL, 0);");
86
1/2
✓ Branch 1 taken 1298 times.
✗ Branch 2 not taken.
1298 retval = sql_init.Execute();
87 1298 return retval;
88 1298 }
89
90
91 1268 bool HistoryDatabase::InsertInitialValues(const std::string &repository_name) {
92
1/2
✗ Branch 1 not taken.
✓ Branch 2 taken 1268 times.
1268 assert(read_write());
93
1/2
✓ Branch 2 taken 1268 times.
✗ Branch 3 not taken.
1268 return this->SetProperty(kFqrnKey, repository_name);
94 }
95
96
97 1674 bool HistoryDatabase::ContainsRecycleBin() const {
98
3/4
✓ Branch 1 taken 1674 times.
✗ Branch 2 not taken.
✓ Branch 4 taken 1634 times.
✓ Branch 5 taken 40 times.
1674 return schema_version() >= 1.0 - kSchemaEpsilon && schema_revision() >= 2;
99 }
100
101
102 276 bool HistoryDatabase::CheckSchemaCompatibility() {
103
1/2
✓ Branch 1 taken 276 times.
✗ Branch 2 not taken.
552 return !((schema_version() < kLatestSupportedSchema - kSchemaEpsilon)
104
1/2
✓ Branch 1 taken 276 times.
✗ Branch 2 not taken.
552 || (schema_version() > kLatestSchema + kSchemaEpsilon));
105 }
106
107
108 80 bool HistoryDatabase::LiveSchemaUpgradeIfNecessary() {
109
1/2
✗ Branch 1 not taken.
✓ Branch 2 taken 80 times.
80 assert(read_write());
110
1/2
✗ Branch 2 not taken.
✓ Branch 3 taken 80 times.
80 assert(IsEqualSchema(schema_version(), 1.0));
111
112
3/6
✓ Branch 2 taken 80 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 80 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 80 times.
✗ Branch 9 not taken.
160 sqlite::Sql sql_foreign_keys(sqlite_db(), "PRAGMA foreign_keys = ON;");
113
2/4
✓ Branch 1 taken 80 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 80 times.
80 if (!sql_foreign_keys.Execute())
114 return false;
115
2/2
✓ Branch 1 taken 50 times.
✓ Branch 2 taken 30 times.
80 if (schema_revision() == kLatestSchemaRevision) {
116 50 return true;
117 }
118
119
1/2
✓ Branch 2 taken 30 times.
✗ Branch 3 not taken.
60 LogCvmfs(kLogHistory, kLogDebug,
120 "upgrading history schema revision "
121 "%.2f (Rev: %d) to %.2f (Rev: %d)",
122 30 schema_version(), schema_revision(), kLatestSchema,
123 kLatestSchemaRevision);
124
125
1/2
✓ Branch 1 taken 30 times.
✗ Branch 2 not taken.
30 const bool success = UpgradeSchemaRevision_10_1()
126
2/4
✓ Branch 1 taken 30 times.
✗ Branch 2 not taken.
✓ Branch 3 taken 30 times.
✗ Branch 4 not taken.
30 && UpgradeSchemaRevision_10_2()
127
3/6
✓ Branch 0 taken 30 times.
✗ Branch 1 not taken.
✓ Branch 3 taken 30 times.
✗ Branch 4 not taken.
✓ Branch 5 taken 30 times.
✗ Branch 6 not taken.
60 && UpgradeSchemaRevision_10_3();
128
129
3/6
✓ Branch 0 taken 30 times.
✗ Branch 1 not taken.
✓ Branch 3 taken 30 times.
✗ Branch 4 not taken.
✓ Branch 5 taken 30 times.
✗ Branch 6 not taken.
30 return success && StoreSchemaRevision();
130 80 }
131
132
133 30 bool HistoryDatabase::UpgradeSchemaRevision_10_1() {
134
2/2
✓ Branch 1 taken 20 times.
✓ Branch 2 taken 10 times.
30 if (schema_revision() > 0) {
135 20 return true;
136 }
137
138
3/6
✓ Branch 2 taken 10 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 10 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 10 times.
✗ Branch 9 not taken.
20 sqlite::Sql sql_upgrade(sqlite_db(), "ALTER TABLE tags ADD size INTEGER;");
139
2/4
✓ Branch 1 taken 10 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 10 times.
10 if (!sql_upgrade.Execute()) {
140 LogCvmfs(kLogHistory, kLogStderr, "failed to upgrade tags table");
141 return false;
142 }
143
144 10 set_schema_revision(1);
145 10 return true;
146 10 }
147
148
149 30 bool HistoryDatabase::UpgradeSchemaRevision_10_2() {
150
2/2
✓ Branch 1 taken 10 times.
✓ Branch 2 taken 20 times.
30 if (schema_revision() > 1) {
151 10 return true;
152 }
153
154
1/2
✗ Branch 1 not taken.
✓ Branch 2 taken 20 times.
20 if (!CreateRecycleBinTable()) {
155 LogCvmfs(kLogHistory, kLogStderr, "failed to upgrade history database");
156 return false;
157 }
158
159 20 set_schema_revision(2);
160 20 return true;
161 }
162
163
164 30 bool HistoryDatabase::UpgradeSchemaRevision_10_3() {
165
1/2
✗ Branch 1 not taken.
✓ Branch 2 taken 30 times.
30 if (schema_revision() > 2) {
166 return true;
167 }
168
169
2/4
✓ Branch 1 taken 30 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 30 times.
30 if (!CreateBranchesTable()) {
170 LogCvmfs(kLogHistory, kLogStderr, "failed to create branches table");
171 return false;
172 }
173
174 sqlite::Sql sql_upgrade(
175 sqlite_db(),
176
3/6
✓ Branch 2 taken 30 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 30 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 30 times.
✗ Branch 9 not taken.
60 "ALTER TABLE tags ADD branch TEXT REFERENCES branches (branch);");
177
2/4
✓ Branch 1 taken 30 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 30 times.
30 if (!sql_upgrade.Execute()) {
178 LogCvmfs(kLogHistory, kLogStderr, "failed to upgrade tags table");
179 return false;
180 }
181
182
3/6
✓ Branch 2 taken 30 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 30 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 30 times.
✗ Branch 9 not taken.
60 sqlite::Sql sql_fill(sqlite_db(), "UPDATE tags SET branch = '';");
183
2/4
✓ Branch 1 taken 30 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 30 times.
30 if (!sql_fill.Execute()) {
184 LogCvmfs(kLogHistory, kLogStderr, "failed to set branch default value");
185 return false;
186 }
187
188 // We keep the table in the schema for backwards compatibility
189
3/6
✓ Branch 2 taken 30 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 30 times.
✗ Branch 6 not taken.
✓ Branch 8 taken 30 times.
✗ Branch 9 not taken.
60 sqlite::Sql sql_flush(sqlite_db(), "DELETE FROM recycle_bin; VACUUM;");
190
2/4
✓ Branch 1 taken 30 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 30 times.
30 if (!sql_flush.Execute()) {
191 LogCvmfs(kLogHistory, kLogStderr, "failed to flush recycle bin table");
192 return false;
193 }
194
195 30 set_schema_revision(3);
196 30 return true;
197 30 }
198
199
200 //------------------------------------------------------------------------------
201
202 #define DB_FIELDS_V1R0 \
203 "name, hash, revision, timestamp, channel, " \
204 "description, 0, ''"
205 #define DB_FIELDS_V1R1 \
206 "name, hash, revision, timestamp, channel, " \
207 "description, size, ''"
208 #define DB_FIELDS_V1R3 \
209 "name, hash, revision, timestamp, channel, " \
210 "description, size, branch"
211 #define DB_PLACEHOLDERS \
212 ":name, :hash, :revision, :timestamp, :channel, " \
213 ":description, :size, :branch"
214 #define ROLLBACK_COND \
215 "(revision > :target_rev OR " \
216 " name = :target_name) " \
217 "AND branch = ''"
218
219 #define MAKE_STATEMENT(STMT_TMPL, REV) \
220 static const std::string REV = ReplaceAll( \
221 ReplaceAll(ReplaceAll(STMT_TMPL, "@DB_FIELDS@", DB_FIELDS_##REV), \
222 "@DB_PLACEHOLDERS@", DB_PLACEHOLDERS), \
223 "@ROLLBACK_COND@", ROLLBACK_COND)
224
225 #define MAKE_STATEMENTS(STMT_TMPL) \
226 MAKE_STATEMENT(STMT_TMPL, V1R0); \
227 MAKE_STATEMENT(STMT_TMPL, V1R1); \
228 MAKE_STATEMENT(STMT_TMPL, V1R3)
229
230 #define DEFERRED_INIT(DB, REV) DeferredInit((DB)->sqlite_db(), (REV).c_str())
231
232 #define DEFERRED_INITS(DB) \
233 if ((DB)->IsEqualSchema((DB)->schema_version(), 1.0f) \
234 && (DB)->schema_revision() == 0) { \
235 DEFERRED_INIT((DB), V1R0); \
236 } else if ((DB)->schema_revision() < 3) { \
237 DEFERRED_INIT((DB), V1R1); \
238 } else { \
239 DEFERRED_INIT((DB), V1R3); \
240 }
241
242 1348 SqlInsertTag::SqlInsertTag(const HistoryDatabase *database) {
243
39/81
✓ Branch 0 taken 49 times.
✓ Branch 1 taken 1299 times.
✓ Branch 3 taken 49 times.
✗ Branch 4 not taken.
✓ Branch 7 taken 49 times.
✗ Branch 8 not taken.
✓ Branch 11 taken 49 times.
✗ Branch 12 not taken.
✓ Branch 15 taken 49 times.
✗ Branch 16 not taken.
✓ Branch 19 taken 49 times.
✗ Branch 20 not taken.
✓ Branch 23 taken 49 times.
✗ Branch 24 not taken.
✓ Branch 27 taken 49 times.
✗ Branch 28 not taken.
✓ Branch 31 taken 49 times.
✗ Branch 32 not taken.
✓ Branch 34 taken 49 times.
✗ Branch 35 not taken.
✓ Branch 37 taken 49 times.
✗ Branch 38 not taken.
✓ Branch 40 taken 49 times.
✗ Branch 41 not taken.
✗ Branch 43 not taken.
✗ Branch 44 not taken.
✓ Branch 60 taken 49 times.
✓ Branch 61 taken 1299 times.
✓ Branch 63 taken 49 times.
✗ Branch 64 not taken.
✓ Branch 67 taken 49 times.
✗ Branch 68 not taken.
✓ Branch 71 taken 49 times.
✗ Branch 72 not taken.
✓ Branch 75 taken 49 times.
✗ Branch 76 not taken.
✓ Branch 79 taken 49 times.
✗ Branch 80 not taken.
✗ Branch 81 not taken.
✓ Branch 83 taken 49 times.
✗ Branch 84 not taken.
✓ Branch 87 taken 49 times.
✗ Branch 88 not taken.
✓ Branch 91 taken 49 times.
✗ Branch 92 not taken.
✓ Branch 94 taken 49 times.
✗ Branch 95 not taken.
✓ Branch 97 taken 49 times.
✗ Branch 98 not taken.
✓ Branch 100 taken 49 times.
✗ Branch 101 not taken.
✓ Branch 120 taken 49 times.
✓ Branch 121 taken 1299 times.
✓ Branch 123 taken 49 times.
✗ Branch 124 not taken.
✓ Branch 127 taken 49 times.
✗ Branch 128 not taken.
✓ Branch 131 taken 49 times.
✗ Branch 132 not taken.
✓ Branch 135 taken 49 times.
✗ Branch 136 not taken.
✓ Branch 139 taken 49 times.
✗ Branch 140 not taken.
✓ Branch 143 taken 49 times.
✗ Branch 144 not taken.
✓ Branch 147 taken 49 times.
✗ Branch 148 not taken.
✓ Branch 151 taken 49 times.
✗ Branch 152 not taken.
✓ Branch 154 taken 49 times.
✗ Branch 155 not taken.
✓ Branch 157 taken 49 times.
✗ Branch 158 not taken.
✓ Branch 160 taken 49 times.
✗ Branch 161 not taken.
✗ Branch 196 not taken.
✗ Branch 197 not taken.
✗ Branch 215 not taken.
✗ Branch 216 not taken.
✗ Branch 234 not taken.
✗ Branch 235 not taken.
1348 MAKE_STATEMENTS("INSERT INTO tags (@DB_FIELDS@) VALUES (@DB_PLACEHOLDERS@);");
244
6/21
✓ Branch 2 taken 1348 times.
✗ Branch 3 not taken.
✗ Branch 5 not taken.
✓ Branch 6 taken 1348 times.
✗ Branch 7 not taken.
✓ Branch 8 taken 1348 times.
✗ Branch 11 not taken.
✗ Branch 12 not taken.
✗ Branch 13 not taken.
✗ Branch 14 not taken.
✗ Branch 15 not taken.
✗ Branch 17 not taken.
✓ Branch 18 taken 1348 times.
✗ Branch 21 not taken.
✗ Branch 22 not taken.
✗ Branch 24 not taken.
✗ Branch 25 not taken.
✓ Branch 28 taken 1348 times.
✗ Branch 29 not taken.
✓ Branch 31 taken 1348 times.
✗ Branch 32 not taken.
1348 DEFERRED_INITS(database);
245 1348 }
246
247
248 42898 bool SqlInsertTag::BindTag(const History::Tag &tag) {
249
3/9
✓ Branch 1 taken 42898 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 42898 times.
✗ Branch 5 not taken.
✓ Branch 6 taken 42898 times.
✗ Branch 7 not taken.
✗ Branch 9 not taken.
✗ Branch 10 not taken.
85796 return BindText(1, tag.name) && BindTextTransient(2, tag.root_hash.ToString())
250
0/2
✗ Branch 0 not taken.
✗ Branch 1 not taken.
42898 && // temporary (ToString)
251
4/9
✓ Branch 1 taken 42898 times.
✗ Branch 2 not taken.
✓ Branch 3 taken 42898 times.
✗ Branch 4 not taken.
✗ Branch 5 not taken.
✓ Branch 6 taken 42898 times.
✗ Branch 7 not taken.
✓ Branch 8 taken 42898 times.
✗ Branch 9 not taken.
42898 BindInt64(3, tag.revision) && BindInt64(4, tag.timestamp) &&
252 // Channels are no longer supported: store 0 (i.e. kChannelTrunk)
253 // for backwards compatibility with existing databases
254 //
255
4/8
✓ Branch 1 taken 42898 times.
✗ Branch 2 not taken.
✓ Branch 3 taken 42898 times.
✗ Branch 4 not taken.
✓ Branch 6 taken 42898 times.
✗ Branch 7 not taken.
✓ Branch 8 taken 42898 times.
✗ Branch 9 not taken.
42898 BindInt64(5, 0) && BindText(6, tag.description)
256
7/16
✓ Branch 1 taken 42898 times.
✗ Branch 2 not taken.
✓ Branch 3 taken 42898 times.
✗ Branch 4 not taken.
✗ Branch 5 not taken.
✓ Branch 6 taken 42898 times.
✗ Branch 7 not taken.
✓ Branch 8 taken 42898 times.
✗ Branch 9 not taken.
✗ Branch 10 not taken.
✓ Branch 11 taken 42898 times.
✗ Branch 12 not taken.
✓ Branch 13 taken 42898 times.
✗ Branch 14 not taken.
✓ Branch 15 taken 42898 times.
✗ Branch 16 not taken.
128694 && BindInt64(7, tag.size) && BindText(8, tag.branch);
257 }
258
259
260 //------------------------------------------------------------------------------
261
262
263 1348 SqlRemoveTag::SqlRemoveTag(const HistoryDatabase *database) {
264
2/4
✓ Branch 1 taken 1348 times.
✗ Branch 2 not taken.
✓ Branch 4 taken 1348 times.
✗ Branch 5 not taken.
1348 DeferredInit(database->sqlite_db(), "DELETE FROM tags WHERE name = :name;");
265 1348 }
266
267 120 bool SqlRemoveTag::BindName(const std::string &name) {
268 120 return BindText(1, name);
269 }
270
271
272 //------------------------------------------------------------------------------
273
274
275 1544 SqlFindTag::SqlFindTag(const HistoryDatabase *database) {
276
39/81
✓ Branch 0 taken 49 times.
✓ Branch 1 taken 1495 times.
✓ Branch 3 taken 49 times.
✗ Branch 4 not taken.
✓ Branch 7 taken 49 times.
✗ Branch 8 not taken.
✓ Branch 11 taken 49 times.
✗ Branch 12 not taken.
✓ Branch 15 taken 49 times.
✗ Branch 16 not taken.
✓ Branch 19 taken 49 times.
✗ Branch 20 not taken.
✓ Branch 23 taken 49 times.
✗ Branch 24 not taken.
✓ Branch 27 taken 49 times.
✗ Branch 28 not taken.
✓ Branch 31 taken 49 times.
✗ Branch 32 not taken.
✓ Branch 34 taken 49 times.
✗ Branch 35 not taken.
✓ Branch 37 taken 49 times.
✗ Branch 38 not taken.
✓ Branch 40 taken 49 times.
✗ Branch 41 not taken.
✗ Branch 43 not taken.
✗ Branch 44 not taken.
✓ Branch 60 taken 49 times.
✓ Branch 61 taken 1495 times.
✓ Branch 63 taken 49 times.
✗ Branch 64 not taken.
✓ Branch 67 taken 49 times.
✗ Branch 68 not taken.
✓ Branch 71 taken 49 times.
✗ Branch 72 not taken.
✓ Branch 75 taken 49 times.
✗ Branch 76 not taken.
✓ Branch 79 taken 49 times.
✗ Branch 80 not taken.
✗ Branch 81 not taken.
✓ Branch 83 taken 49 times.
✗ Branch 84 not taken.
✓ Branch 87 taken 49 times.
✗ Branch 88 not taken.
✓ Branch 91 taken 49 times.
✗ Branch 92 not taken.
✓ Branch 94 taken 49 times.
✗ Branch 95 not taken.
✓ Branch 97 taken 49 times.
✗ Branch 98 not taken.
✓ Branch 100 taken 49 times.
✗ Branch 101 not taken.
✓ Branch 120 taken 49 times.
✓ Branch 121 taken 1495 times.
✓ Branch 123 taken 49 times.
✗ Branch 124 not taken.
✓ Branch 127 taken 49 times.
✗ Branch 128 not taken.
✓ Branch 131 taken 49 times.
✗ Branch 132 not taken.
✓ Branch 135 taken 49 times.
✗ Branch 136 not taken.
✓ Branch 139 taken 49 times.
✗ Branch 140 not taken.
✓ Branch 143 taken 49 times.
✗ Branch 144 not taken.
✓ Branch 147 taken 49 times.
✗ Branch 148 not taken.
✓ Branch 151 taken 49 times.
✗ Branch 152 not taken.
✓ Branch 154 taken 49 times.
✗ Branch 155 not taken.
✓ Branch 157 taken 49 times.
✗ Branch 158 not taken.
✓ Branch 160 taken 49 times.
✗ Branch 161 not taken.
✗ Branch 196 not taken.
✗ Branch 197 not taken.
✗ Branch 215 not taken.
✗ Branch 216 not taken.
✗ Branch 234 not taken.
✗ Branch 235 not taken.
1544 MAKE_STATEMENTS("SELECT @DB_FIELDS@ FROM tags WHERE name = :name;");
277
13/21
✓ Branch 2 taken 1544 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 10 times.
✓ Branch 6 taken 1534 times.
✓ Branch 7 taken 10 times.
✓ Branch 8 taken 1534 times.
✓ Branch 11 taken 10 times.
✗ Branch 12 not taken.
✗ Branch 13 not taken.
✓ Branch 14 taken 10 times.
✗ Branch 15 not taken.
✓ Branch 17 taken 20 times.
✓ Branch 18 taken 1514 times.
✓ Branch 21 taken 20 times.
✗ Branch 22 not taken.
✓ Branch 24 taken 20 times.
✗ Branch 25 not taken.
✓ Branch 28 taken 1514 times.
✗ Branch 29 not taken.
✓ Branch 31 taken 1514 times.
✗ Branch 32 not taken.
1544 DEFERRED_INITS(database);
278 1544 }
279
280 588 bool SqlFindTag::BindName(const std::string &name) { return BindText(1, name); }
281
282
283 //------------------------------------------------------------------------------
284
285
286 1544 SqlFindTagByDate::SqlFindTagByDate(const HistoryDatabase *database) {
287 // figure out the tag that was HEAD to a given point in time
288 //
289 // conceptually goes back in the revision history | ORDER BY revision DESC
290 // and picks the first tag | LIMIT 1
291 // that is older than the given timestamp | WHICH timestamp <= :ts
292
39/81
✓ Branch 0 taken 49 times.
✓ Branch 1 taken 1495 times.
✓ Branch 3 taken 49 times.
✗ Branch 4 not taken.
✓ Branch 7 taken 49 times.
✗ Branch 8 not taken.
✓ Branch 11 taken 49 times.
✗ Branch 12 not taken.
✓ Branch 15 taken 49 times.
✗ Branch 16 not taken.
✓ Branch 19 taken 49 times.
✗ Branch 20 not taken.
✓ Branch 23 taken 49 times.
✗ Branch 24 not taken.
✓ Branch 27 taken 49 times.
✗ Branch 28 not taken.
✓ Branch 31 taken 49 times.
✗ Branch 32 not taken.
✓ Branch 34 taken 49 times.
✗ Branch 35 not taken.
✓ Branch 37 taken 49 times.
✗ Branch 38 not taken.
✓ Branch 40 taken 49 times.
✗ Branch 41 not taken.
✗ Branch 43 not taken.
✗ Branch 44 not taken.
✓ Branch 60 taken 49 times.
✓ Branch 61 taken 1495 times.
✓ Branch 63 taken 49 times.
✗ Branch 64 not taken.
✓ Branch 67 taken 49 times.
✗ Branch 68 not taken.
✓ Branch 71 taken 49 times.
✗ Branch 72 not taken.
✓ Branch 75 taken 49 times.
✗ Branch 76 not taken.
✓ Branch 79 taken 49 times.
✗ Branch 80 not taken.
✗ Branch 81 not taken.
✓ Branch 83 taken 49 times.
✗ Branch 84 not taken.
✓ Branch 87 taken 49 times.
✗ Branch 88 not taken.
✓ Branch 91 taken 49 times.
✗ Branch 92 not taken.
✓ Branch 94 taken 49 times.
✗ Branch 95 not taken.
✓ Branch 97 taken 49 times.
✗ Branch 98 not taken.
✓ Branch 100 taken 49 times.
✗ Branch 101 not taken.
✓ Branch 120 taken 49 times.
✓ Branch 121 taken 1495 times.
✓ Branch 123 taken 49 times.
✗ Branch 124 not taken.
✓ Branch 127 taken 49 times.
✗ Branch 128 not taken.
✓ Branch 131 taken 49 times.
✗ Branch 132 not taken.
✓ Branch 135 taken 49 times.
✗ Branch 136 not taken.
✓ Branch 139 taken 49 times.
✗ Branch 140 not taken.
✓ Branch 143 taken 49 times.
✗ Branch 144 not taken.
✓ Branch 147 taken 49 times.
✗ Branch 148 not taken.
✓ Branch 151 taken 49 times.
✗ Branch 152 not taken.
✓ Branch 154 taken 49 times.
✗ Branch 155 not taken.
✓ Branch 157 taken 49 times.
✗ Branch 158 not taken.
✓ Branch 160 taken 49 times.
✗ Branch 161 not taken.
✗ Branch 196 not taken.
✗ Branch 197 not taken.
✗ Branch 215 not taken.
✗ Branch 216 not taken.
✗ Branch 234 not taken.
✗ Branch 235 not taken.
1544 MAKE_STATEMENTS("SELECT @DB_FIELDS@ FROM tags "
293 "WHERE (branch = '') AND (timestamp <= :timestamp) "
294 "ORDER BY revision DESC LIMIT 1;");
295
13/21
✓ Branch 2 taken 1544 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 10 times.
✓ Branch 6 taken 1534 times.
✓ Branch 7 taken 10 times.
✓ Branch 8 taken 1534 times.
✓ Branch 11 taken 10 times.
✗ Branch 12 not taken.
✗ Branch 13 not taken.
✓ Branch 14 taken 10 times.
✗ Branch 15 not taken.
✓ Branch 17 taken 20 times.
✓ Branch 18 taken 1514 times.
✓ Branch 21 taken 20 times.
✗ Branch 22 not taken.
✓ Branch 24 taken 20 times.
✗ Branch 25 not taken.
✓ Branch 28 taken 1514 times.
✗ Branch 29 not taken.
✓ Branch 31 taken 1514 times.
✗ Branch 32 not taken.
1544 DEFERRED_INITS(database);
296 1544 }
297
298 48 bool SqlFindTagByDate::BindTimestamp(const time_t timestamp) {
299 48 return BindInt64(1, timestamp);
300 }
301
302
303 //------------------------------------------------------------------------------
304
305
306 1348 SqlFindBranchHead::SqlFindBranchHead(const HistoryDatabase *database) {
307 // One of the tags with the highest revision on a given branch
308 // Doesn't work on older database revisions
309
39/81
✓ Branch 0 taken 49 times.
✓ Branch 1 taken 1299 times.
✓ Branch 3 taken 49 times.
✗ Branch 4 not taken.
✓ Branch 7 taken 49 times.
✗ Branch 8 not taken.
✓ Branch 11 taken 49 times.
✗ Branch 12 not taken.
✓ Branch 15 taken 49 times.
✗ Branch 16 not taken.
✓ Branch 19 taken 49 times.
✗ Branch 20 not taken.
✓ Branch 23 taken 49 times.
✗ Branch 24 not taken.
✓ Branch 27 taken 49 times.
✗ Branch 28 not taken.
✓ Branch 31 taken 49 times.
✗ Branch 32 not taken.
✓ Branch 34 taken 49 times.
✗ Branch 35 not taken.
✓ Branch 37 taken 49 times.
✗ Branch 38 not taken.
✓ Branch 40 taken 49 times.
✗ Branch 41 not taken.
✗ Branch 43 not taken.
✗ Branch 44 not taken.
✓ Branch 60 taken 49 times.
✓ Branch 61 taken 1299 times.
✓ Branch 63 taken 49 times.
✗ Branch 64 not taken.
✓ Branch 67 taken 49 times.
✗ Branch 68 not taken.
✓ Branch 71 taken 49 times.
✗ Branch 72 not taken.
✓ Branch 75 taken 49 times.
✗ Branch 76 not taken.
✓ Branch 79 taken 49 times.
✗ Branch 80 not taken.
✗ Branch 81 not taken.
✓ Branch 83 taken 49 times.
✗ Branch 84 not taken.
✓ Branch 87 taken 49 times.
✗ Branch 88 not taken.
✓ Branch 91 taken 49 times.
✗ Branch 92 not taken.
✓ Branch 94 taken 49 times.
✗ Branch 95 not taken.
✓ Branch 97 taken 49 times.
✗ Branch 98 not taken.
✓ Branch 100 taken 49 times.
✗ Branch 101 not taken.
✓ Branch 120 taken 49 times.
✓ Branch 121 taken 1299 times.
✓ Branch 123 taken 49 times.
✗ Branch 124 not taken.
✓ Branch 127 taken 49 times.
✗ Branch 128 not taken.
✓ Branch 131 taken 49 times.
✗ Branch 132 not taken.
✓ Branch 135 taken 49 times.
✗ Branch 136 not taken.
✓ Branch 139 taken 49 times.
✗ Branch 140 not taken.
✓ Branch 143 taken 49 times.
✗ Branch 144 not taken.
✓ Branch 147 taken 49 times.
✗ Branch 148 not taken.
✓ Branch 151 taken 49 times.
✗ Branch 152 not taken.
✓ Branch 154 taken 49 times.
✗ Branch 155 not taken.
✓ Branch 157 taken 49 times.
✗ Branch 158 not taken.
✓ Branch 160 taken 49 times.
✗ Branch 161 not taken.
✗ Branch 196 not taken.
✗ Branch 197 not taken.
✗ Branch 215 not taken.
✗ Branch 216 not taken.
✗ Branch 234 not taken.
✗ Branch 235 not taken.
1348 MAKE_STATEMENTS("SELECT @DB_FIELDS@ FROM tags "
310 "WHERE (branch = :branch) "
311 "ORDER BY revision DESC LIMIT 1;");
312
6/21
✓ Branch 2 taken 1348 times.
✗ Branch 3 not taken.
✗ Branch 5 not taken.
✓ Branch 6 taken 1348 times.
✗ Branch 7 not taken.
✓ Branch 8 taken 1348 times.
✗ Branch 11 not taken.
✗ Branch 12 not taken.
✗ Branch 13 not taken.
✗ Branch 14 not taken.
✗ Branch 15 not taken.
✗ Branch 17 not taken.
✓ Branch 18 taken 1348 times.
✗ Branch 21 not taken.
✗ Branch 22 not taken.
✗ Branch 24 not taken.
✗ Branch 25 not taken.
✓ Branch 28 taken 1348 times.
✗ Branch 29 not taken.
✓ Branch 31 taken 1348 times.
✗ Branch 32 not taken.
1348 DEFERRED_INITS(database);
313 1348 }
314
315 30 bool SqlFindBranchHead::BindBranchName(const std::string &branch_name) {
316 30 return BindText(1, branch_name);
317 }
318
319
320 //------------------------------------------------------------------------------
321
322
323 1544 SqlCountTags::SqlCountTags(const HistoryDatabase *database) {
324
2/4
✓ Branch 1 taken 1544 times.
✗ Branch 2 not taken.
✓ Branch 4 taken 1544 times.
✗ Branch 5 not taken.
1544 DeferredInit(database->sqlite_db(), "SELECT count(*) FROM tags;");
325 1544 }
326
327 290 unsigned SqlCountTags::RetrieveCount() const {
328 290 const int64_t count = RetrieveInt64(0);
329
1/2
✗ Branch 0 not taken.
✓ Branch 1 taken 290 times.
290 assert(count >= 0);
330 290 return static_cast<uint64_t>(count);
331 }
332
333
334 //------------------------------------------------------------------------------
335
336
337 1544 SqlListTags::SqlListTags(const HistoryDatabase *database) {
338
39/81
✓ Branch 0 taken 49 times.
✓ Branch 1 taken 1495 times.
✓ Branch 3 taken 49 times.
✗ Branch 4 not taken.
✓ Branch 7 taken 49 times.
✗ Branch 8 not taken.
✓ Branch 11 taken 49 times.
✗ Branch 12 not taken.
✓ Branch 15 taken 49 times.
✗ Branch 16 not taken.
✓ Branch 19 taken 49 times.
✗ Branch 20 not taken.
✓ Branch 23 taken 49 times.
✗ Branch 24 not taken.
✓ Branch 27 taken 49 times.
✗ Branch 28 not taken.
✓ Branch 31 taken 49 times.
✗ Branch 32 not taken.
✓ Branch 34 taken 49 times.
✗ Branch 35 not taken.
✓ Branch 37 taken 49 times.
✗ Branch 38 not taken.
✓ Branch 40 taken 49 times.
✗ Branch 41 not taken.
✗ Branch 43 not taken.
✗ Branch 44 not taken.
✓ Branch 60 taken 49 times.
✓ Branch 61 taken 1495 times.
✓ Branch 63 taken 49 times.
✗ Branch 64 not taken.
✓ Branch 67 taken 49 times.
✗ Branch 68 not taken.
✓ Branch 71 taken 49 times.
✗ Branch 72 not taken.
✓ Branch 75 taken 49 times.
✗ Branch 76 not taken.
✓ Branch 79 taken 49 times.
✗ Branch 80 not taken.
✗ Branch 81 not taken.
✓ Branch 83 taken 49 times.
✗ Branch 84 not taken.
✓ Branch 87 taken 49 times.
✗ Branch 88 not taken.
✓ Branch 91 taken 49 times.
✗ Branch 92 not taken.
✓ Branch 94 taken 49 times.
✗ Branch 95 not taken.
✓ Branch 97 taken 49 times.
✗ Branch 98 not taken.
✓ Branch 100 taken 49 times.
✗ Branch 101 not taken.
✓ Branch 120 taken 49 times.
✓ Branch 121 taken 1495 times.
✓ Branch 123 taken 49 times.
✗ Branch 124 not taken.
✓ Branch 127 taken 49 times.
✗ Branch 128 not taken.
✓ Branch 131 taken 49 times.
✗ Branch 132 not taken.
✓ Branch 135 taken 49 times.
✗ Branch 136 not taken.
✓ Branch 139 taken 49 times.
✗ Branch 140 not taken.
✓ Branch 143 taken 49 times.
✗ Branch 144 not taken.
✓ Branch 147 taken 49 times.
✗ Branch 148 not taken.
✓ Branch 151 taken 49 times.
✗ Branch 152 not taken.
✓ Branch 154 taken 49 times.
✗ Branch 155 not taken.
✓ Branch 157 taken 49 times.
✗ Branch 158 not taken.
✓ Branch 160 taken 49 times.
✗ Branch 161 not taken.
✗ Branch 196 not taken.
✗ Branch 197 not taken.
✗ Branch 215 not taken.
✗ Branch 216 not taken.
✗ Branch 234 not taken.
✗ Branch 235 not taken.
1544 MAKE_STATEMENTS(
339 "SELECT @DB_FIELDS@ FROM tags ORDER BY timestamp DESC, revision DESC;");
340
13/21
✓ Branch 2 taken 1544 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 10 times.
✓ Branch 6 taken 1534 times.
✓ Branch 7 taken 10 times.
✓ Branch 8 taken 1534 times.
✓ Branch 11 taken 10 times.
✗ Branch 12 not taken.
✗ Branch 13 not taken.
✓ Branch 14 taken 10 times.
✗ Branch 15 not taken.
✓ Branch 17 taken 20 times.
✓ Branch 18 taken 1514 times.
✓ Branch 21 taken 20 times.
✗ Branch 22 not taken.
✓ Branch 24 taken 20 times.
✗ Branch 25 not taken.
✓ Branch 28 taken 1514 times.
✗ Branch 29 not taken.
✓ Branch 31 taken 1514 times.
✗ Branch 32 not taken.
1544 DEFERRED_INITS(database);
341 1544 }
342
343
344 //------------------------------------------------------------------------------
345
346
347 1544 SqlGetHashes::SqlGetHashes(const HistoryDatabase *database) {
348
2/4
✓ Branch 1 taken 1544 times.
✗ Branch 2 not taken.
✓ Branch 4 taken 1544 times.
✗ Branch 5 not taken.
1544 DeferredInit(database->sqlite_db(), "SELECT DISTINCT hash FROM tags "
349 "ORDER BY timestamp, revision ASC");
350 1544 }
351
352 20010 shash::Any SqlGetHashes::RetrieveHash() const {
353
1/2
✓ Branch 3 taken 20010 times.
✗ Branch 4 not taken.
40020 return shash::MkFromHexPtr(shash::HexPtr(RetrieveString(0)),
354 40020 shash::kSuffixCatalog);
355 }
356
357
358 //------------------------------------------------------------------------------
359
360
361 1348 SqlRollbackTag::SqlRollbackTag(const HistoryDatabase *database) {
362
39/81
✓ Branch 0 taken 49 times.
✓ Branch 1 taken 1299 times.
✓ Branch 3 taken 49 times.
✗ Branch 4 not taken.
✓ Branch 7 taken 49 times.
✗ Branch 8 not taken.
✓ Branch 11 taken 49 times.
✗ Branch 12 not taken.
✓ Branch 15 taken 49 times.
✗ Branch 16 not taken.
✓ Branch 19 taken 49 times.
✗ Branch 20 not taken.
✓ Branch 23 taken 49 times.
✗ Branch 24 not taken.
✓ Branch 27 taken 49 times.
✗ Branch 28 not taken.
✓ Branch 31 taken 49 times.
✗ Branch 32 not taken.
✓ Branch 34 taken 49 times.
✗ Branch 35 not taken.
✓ Branch 37 taken 49 times.
✗ Branch 38 not taken.
✓ Branch 40 taken 49 times.
✗ Branch 41 not taken.
✗ Branch 43 not taken.
✗ Branch 44 not taken.
✓ Branch 60 taken 49 times.
✓ Branch 61 taken 1299 times.
✓ Branch 63 taken 49 times.
✗ Branch 64 not taken.
✓ Branch 67 taken 49 times.
✗ Branch 68 not taken.
✓ Branch 71 taken 49 times.
✗ Branch 72 not taken.
✓ Branch 75 taken 49 times.
✗ Branch 76 not taken.
✓ Branch 79 taken 49 times.
✗ Branch 80 not taken.
✗ Branch 81 not taken.
✓ Branch 83 taken 49 times.
✗ Branch 84 not taken.
✓ Branch 87 taken 49 times.
✗ Branch 88 not taken.
✓ Branch 91 taken 49 times.
✗ Branch 92 not taken.
✓ Branch 94 taken 49 times.
✗ Branch 95 not taken.
✓ Branch 97 taken 49 times.
✗ Branch 98 not taken.
✓ Branch 100 taken 49 times.
✗ Branch 101 not taken.
✓ Branch 120 taken 49 times.
✓ Branch 121 taken 1299 times.
✓ Branch 123 taken 49 times.
✗ Branch 124 not taken.
✓ Branch 127 taken 49 times.
✗ Branch 128 not taken.
✓ Branch 131 taken 49 times.
✗ Branch 132 not taken.
✓ Branch 135 taken 49 times.
✗ Branch 136 not taken.
✓ Branch 139 taken 49 times.
✗ Branch 140 not taken.
✓ Branch 143 taken 49 times.
✗ Branch 144 not taken.
✓ Branch 147 taken 49 times.
✗ Branch 148 not taken.
✓ Branch 151 taken 49 times.
✗ Branch 152 not taken.
✓ Branch 154 taken 49 times.
✗ Branch 155 not taken.
✓ Branch 157 taken 49 times.
✗ Branch 158 not taken.
✓ Branch 160 taken 49 times.
✗ Branch 161 not taken.
✗ Branch 196 not taken.
✗ Branch 197 not taken.
✗ Branch 215 not taken.
✗ Branch 216 not taken.
✗ Branch 234 not taken.
✗ Branch 235 not taken.
1348 MAKE_STATEMENTS("DELETE FROM tags WHERE @ROLLBACK_COND@;");
363
6/21
✓ Branch 2 taken 1348 times.
✗ Branch 3 not taken.
✗ Branch 5 not taken.
✓ Branch 6 taken 1348 times.
✗ Branch 7 not taken.
✓ Branch 8 taken 1348 times.
✗ Branch 11 not taken.
✗ Branch 12 not taken.
✗ Branch 13 not taken.
✗ Branch 14 not taken.
✗ Branch 15 not taken.
✗ Branch 17 not taken.
✓ Branch 18 taken 1348 times.
✗ Branch 21 not taken.
✗ Branch 22 not taken.
✗ Branch 24 not taken.
✗ Branch 25 not taken.
✓ Branch 28 taken 1348 times.
✗ Branch 29 not taken.
✓ Branch 31 taken 1348 times.
✗ Branch 32 not taken.
1348 DEFERRED_INITS(database);
364 1348 }
365
366
367 //------------------------------------------------------------------------------
368
369
370 1544 SqlListRollbackTags::SqlListRollbackTags(const HistoryDatabase *database) {
371
39/81
✓ Branch 0 taken 49 times.
✓ Branch 1 taken 1495 times.
✓ Branch 3 taken 49 times.
✗ Branch 4 not taken.
✓ Branch 7 taken 49 times.
✗ Branch 8 not taken.
✓ Branch 11 taken 49 times.
✗ Branch 12 not taken.
✓ Branch 15 taken 49 times.
✗ Branch 16 not taken.
✓ Branch 19 taken 49 times.
✗ Branch 20 not taken.
✓ Branch 23 taken 49 times.
✗ Branch 24 not taken.
✓ Branch 27 taken 49 times.
✗ Branch 28 not taken.
✓ Branch 31 taken 49 times.
✗ Branch 32 not taken.
✓ Branch 34 taken 49 times.
✗ Branch 35 not taken.
✓ Branch 37 taken 49 times.
✗ Branch 38 not taken.
✓ Branch 40 taken 49 times.
✗ Branch 41 not taken.
✗ Branch 43 not taken.
✗ Branch 44 not taken.
✓ Branch 60 taken 49 times.
✓ Branch 61 taken 1495 times.
✓ Branch 63 taken 49 times.
✗ Branch 64 not taken.
✓ Branch 67 taken 49 times.
✗ Branch 68 not taken.
✓ Branch 71 taken 49 times.
✗ Branch 72 not taken.
✓ Branch 75 taken 49 times.
✗ Branch 76 not taken.
✓ Branch 79 taken 49 times.
✗ Branch 80 not taken.
✗ Branch 81 not taken.
✓ Branch 83 taken 49 times.
✗ Branch 84 not taken.
✓ Branch 87 taken 49 times.
✗ Branch 88 not taken.
✓ Branch 91 taken 49 times.
✗ Branch 92 not taken.
✓ Branch 94 taken 49 times.
✗ Branch 95 not taken.
✓ Branch 97 taken 49 times.
✗ Branch 98 not taken.
✓ Branch 100 taken 49 times.
✗ Branch 101 not taken.
✓ Branch 120 taken 49 times.
✓ Branch 121 taken 1495 times.
✓ Branch 123 taken 49 times.
✗ Branch 124 not taken.
✓ Branch 127 taken 49 times.
✗ Branch 128 not taken.
✓ Branch 131 taken 49 times.
✗ Branch 132 not taken.
✓ Branch 135 taken 49 times.
✗ Branch 136 not taken.
✓ Branch 139 taken 49 times.
✗ Branch 140 not taken.
✓ Branch 143 taken 49 times.
✗ Branch 144 not taken.
✓ Branch 147 taken 49 times.
✗ Branch 148 not taken.
✓ Branch 151 taken 49 times.
✗ Branch 152 not taken.
✓ Branch 154 taken 49 times.
✗ Branch 155 not taken.
✓ Branch 157 taken 49 times.
✗ Branch 158 not taken.
✓ Branch 160 taken 49 times.
✗ Branch 161 not taken.
✗ Branch 196 not taken.
✗ Branch 197 not taken.
✗ Branch 215 not taken.
✗ Branch 216 not taken.
✗ Branch 234 not taken.
✗ Branch 235 not taken.
1544 MAKE_STATEMENTS("SELECT @DB_FIELDS@ FROM tags "
372 "WHERE @ROLLBACK_COND@ "
373 "ORDER BY revision DESC;");
374
13/21
✓ Branch 2 taken 1544 times.
✗ Branch 3 not taken.
✓ Branch 5 taken 10 times.
✓ Branch 6 taken 1534 times.
✓ Branch 7 taken 10 times.
✓ Branch 8 taken 1534 times.
✓ Branch 11 taken 10 times.
✗ Branch 12 not taken.
✗ Branch 13 not taken.
✓ Branch 14 taken 10 times.
✗ Branch 15 not taken.
✓ Branch 17 taken 20 times.
✓ Branch 18 taken 1514 times.
✓ Branch 21 taken 20 times.
✗ Branch 22 not taken.
✓ Branch 24 taken 20 times.
✗ Branch 25 not taken.
✓ Branch 28 taken 1514 times.
✗ Branch 29 not taken.
✓ Branch 31 taken 1514 times.
✗ Branch 32 not taken.
1544 DEFERRED_INITS(database);
375 1544 }
376
377
378 //------------------------------------------------------------------------------
379
380
381 1544 SqlListBranches::SqlListBranches(const HistoryDatabase *database) {
382
2/2
✓ Branch 1 taken 30 times.
✓ Branch 2 taken 1514 times.
1544 if (database->schema_revision() < 3)
383
2/4
✓ Branch 1 taken 30 times.
✗ Branch 2 not taken.
✓ Branch 4 taken 30 times.
✗ Branch 5 not taken.
30 DeferredInit(database->sqlite_db(), "SELECT '', NULL, 0;");
384 else
385
2/4
✓ Branch 1 taken 1514 times.
✗ Branch 2 not taken.
✓ Branch 4 taken 1514 times.
✗ Branch 5 not taken.
1514 DeferredInit(database->sqlite_db(),
386 "SELECT branch, parent, initial_revision FROM branches;");
387 1544 }
388
389
390 270 History::Branch SqlListBranches::RetrieveBranch() const {
391
1/2
✓ Branch 1 taken 270 times.
✗ Branch 2 not taken.
270 const std::string branch = RetrieveString(0);
392
1/2
✓ Branch 1 taken 270 times.
✗ Branch 2 not taken.
270 const std::string parent = (RetrieveType(1) == SQLITE_NULL)
393 ? ""
394
6/11
✓ Branch 0 taken 100 times.
✓ Branch 1 taken 170 times.
✓ Branch 4 taken 100 times.
✗ Branch 5 not taken.
✗ Branch 6 not taken.
✓ Branch 7 taken 170 times.
✗ Branch 8 not taken.
✓ Branch 9 taken 100 times.
✓ Branch 10 taken 170 times.
✗ Branch 11 not taken.
✗ Branch 12 not taken.
270 : RetrieveString(1);
395
1/2
✓ Branch 1 taken 270 times.
✗ Branch 2 not taken.
270 const unsigned initial_revision = RetrieveInt64(2);
396
1/2
✓ Branch 1 taken 270 times.
✗ Branch 2 not taken.
540 return History::Branch(branch, parent, initial_revision);
397 270 }
398
399
400 //------------------------------------------------------------------------------
401
402
403 1348 SqlInsertBranch::SqlInsertBranch(const HistoryDatabase *database) {
404
2/4
✓ Branch 1 taken 1348 times.
✗ Branch 2 not taken.
✓ Branch 4 taken 1348 times.
✗ Branch 5 not taken.
1348 DeferredInit(database->sqlite_db(),
405 "INSERT INTO branches (branch, parent, initial_revision) "
406 "VALUES (:branch, :parent, :initial_revision);");
407 1348 }
408
409
410 180 bool SqlInsertBranch::BindBranch(const History::Branch &branch) {
411
1/2
✓ Branch 2 taken 170 times.
✗ Branch 3 not taken.
350 return BindText(1, branch.branch) && BindText(2, branch.parent)
412
3/4
✓ Branch 0 taken 170 times.
✓ Branch 1 taken 10 times.
✓ Branch 3 taken 170 times.
✗ Branch 4 not taken.
350 && BindInt64(3, branch.initial_revision);
413 }
414
415
416 //------------------------------------------------------------------------------
417
418
419 2872 bool SqlRecycleBin::CheckSchema(const HistoryDatabase *database) const {
420 2872 return (database->IsEqualSchema(database->schema_version(), 1.0))
421
2/4
✓ Branch 0 taken 2872 times.
✗ Branch 1 not taken.
✓ Branch 3 taken 2872 times.
✗ Branch 4 not taken.
2872 && (database->schema_revision() >= 2);
422 }
423
424
425 //------------------------------------------------------------------------------
426
427
428 1524 SqlRecycleBinList::SqlRecycleBinList(const HistoryDatabase *database) {
429
2/4
✓ Branch 1 taken 1524 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 1524 times.
1524 assert(CheckSchema(database));
430
2/4
✓ Branch 1 taken 1524 times.
✗ Branch 2 not taken.
✓ Branch 4 taken 1524 times.
✗ Branch 5 not taken.
1524 DeferredInit(database->sqlite_db(), "SELECT hash, flags FROM recycle_bin;");
431 1524 }
432
433
434 10 shash::Any SqlRecycleBinList::RetrieveHash() {
435 10 const unsigned int flags = RetrieveInt64(1);
436 10 shash::Suffix suffix = shash::kSuffixNone;
437
1/2
✓ Branch 0 taken 10 times.
✗ Branch 1 not taken.
10 if (flags & SqlRecycleBin::kFlagCatalog) {
438 10 suffix = shash::kSuffixCatalog;
439 }
440
441
1/2
✓ Branch 3 taken 10 times.
✗ Branch 4 not taken.
10 return shash::MkFromHexPtr(shash::HexPtr(RetrieveString(0)), suffix);
442 }
443
444
445 //------------------------------------------------------------------------------
446
447
448 1348 SqlRecycleBinFlush::SqlRecycleBinFlush(const HistoryDatabase *database) {
449
2/4
✓ Branch 1 taken 1348 times.
✗ Branch 2 not taken.
✗ Branch 3 not taken.
✓ Branch 4 taken 1348 times.
1348 assert(CheckSchema(database));
450
2/4
✓ Branch 1 taken 1348 times.
✗ Branch 2 not taken.
✓ Branch 4 taken 1348 times.
✗ Branch 5 not taken.
1348 DeferredInit(database->sqlite_db(), "DELETE FROM recycle_bin;");
451 1348 }
452
453
454 }; /* namespace history */
455