Lines Matching refs:db
60 // Get a temporary directory for the test DB files.
63 file_name_ = temp_dir_.path().AppendASCII("TestThumbnails.db");
64 new_file_name_ = temp_dir_.path().AppendASCII("TestFavicons.db");
65 history_db_name_ = temp_dir_.path().AppendASCII("TestHistory.db");
114 ThumbnailDatabase db;
115 ASSERT_EQ(sql::INIT_OK, db.Init(file_name_, NULL, NULL));
116 db.BeginTransaction();
122 FaviconID id = db.AddFavicon(url, FAVICON);
124 db.SetFavicon(id, favicon, time);
125 EXPECT_TRUE(db.RenameAndDropThumbnails(file_name_, new_file_name_));
130 EXPECT_TRUE(db.GetFavicon(id, &time_out, &favicon_out, &url_out));
140 ThumbnailDatabase db;
141 ASSERT_EQ(sql::INIT_OK, db.Init(file_name_, NULL, NULL));
142 db.BeginTransaction();
148 FaviconID id = db.AddFavicon(url, TOUCH_ICON);
151 db.SetFavicon(id, favicon, time);
153 EXPECT_NE(0, db.AddIconMapping(url, id));
155 EXPECT_TRUE(db.GetIconMappingsForPageURL(url, &icon_mapping));
162 ThumbnailDatabase db;
163 ASSERT_EQ(sql::INIT_OK, db.Init(file_name_, NULL, NULL));
164 db.BeginTransaction();
170 FaviconID id = db.AddFavicon(url, TOUCH_ICON);
172 db.SetFavicon(id, favicon, time);
174 EXPECT_TRUE(0 < db.AddIconMapping(url, id));
176 EXPECT_TRUE(db.GetIconMappingsForPageURL(url, &icon_mapping));
182 FaviconID new_id = db.AddFavicon(url1, TOUCH_ICON);
183 EXPECT_TRUE(db.UpdateIconMapping(icon_mapping.front().mapping_id, new_id));
186 EXPECT_TRUE(db.GetIconMappingsForPageURL(url, &icon_mapping));
194 ThumbnailDatabase db;
195 ASSERT_EQ(sql::INIT_OK, db.Init(file_name_, NULL, NULL));
196 db.BeginTransaction();
202 FaviconID id = db.AddFavicon(url, TOUCH_ICON);
204 db.SetFavicon(id, favicon, time);
205 EXPECT_TRUE(0 < db.AddIconMapping(url, id));
207 FaviconID id2 = db.AddFavicon(url, FAVICON);
208 db.SetFavicon(id2, favicon, time);
209 EXPECT_TRUE(0 < db.AddIconMapping(url, id2));
213 EXPECT_TRUE(db.GetIconMappingsForPageURL(url, &icon_mapping));
216 EXPECT_TRUE(db.GetIconMappingForPageURL(url, FAVICON, NULL));
218 db.DeleteIconMappings(url);
220 EXPECT_FALSE(db.GetIconMappingsForPageURL(url, NULL));
221 EXPECT_FALSE(db.GetIconMappingForPageURL(url, FAVICON, NULL));
225 ThumbnailDatabase db;
226 ASSERT_EQ(sql::INIT_OK, db.Init(file_name_, NULL, NULL));
227 db.BeginTransaction();
234 FaviconID id1 = db.AddFavicon(url, TOUCH_ICON);
236 db.SetFavicon(id1, favicon, time);
237 EXPECT_TRUE(0 < db.AddIconMapping(url, id1));
239 FaviconID id2 = db.AddFavicon(url, FAVICON);
241 db.SetFavicon(id2, favicon, time);
242 EXPECT_TRUE(0 < db.AddIconMapping(url, id2));
245 EXPECT_TRUE(db.GetIconMappingsForPageURL(url, &icon_mapping));
252 ThumbnailDatabase db;
253 ASSERT_EQ(sql::INIT_OK, db.Init(file_name_, NULL, NULL));
254 db.BeginTransaction();
260 EXPECT_TRUE(db.db_.Execute(sql.c_str()));
270 EXPECT_TRUE(db.db_.Execute(sql.c_str()));
272 EXPECT_TRUE(db.UpgradeToVersion4());
278 FaviconID id = db.AddFavicon(url, TOUCH_ICON);
280 db.SetFavicon(id, favicon, time);
282 EXPECT_TRUE(0 < db.AddIconMapping(url, id));
284 EXPECT_TRUE(db.GetIconMappingForPageURL(url, TOUCH_ICON, &icon_mapping));
290 ThumbnailDatabase db;
292 ASSERT_EQ(sql::INIT_OK, db.Init(file_name_, NULL, NULL));
294 db.BeginTransaction();
296 EXPECT_TRUE(db.InitTemporaryIconMappingTable());
302 FaviconID id = db.AddFavicon(url, FAVICON);
304 db.SetFavicon(id, favicon, time);
306 db.AddToTemporaryIconMappingTable(url, id);
307 db.CommitTemporaryIconMappingTable();
309 EXPECT_TRUE(db.GetIconMappingForPageURL(url, FAVICON, &icon_mapping));
315 ThumbnailDatabase db;
316 ASSERT_EQ(sql::INIT_OK, db.Init(file_name_, NULL, NULL));
317 db.BeginTransaction();
324 FaviconID id = db.AddFavicon(url, FAVICON);
326 db.SetFavicon(id, favicon, time);
328 EXPECT_NE(0, db.AddIconMapping(url, id));
330 EXPECT_TRUE(db.GetIconMappingsForPageURL(url, &icon_mapping));
340 FaviconID id2 = db.AddFavicon(url, TOUCH_ICON);
341 db.SetFavicon(id2, favicon2, time);
342 EXPECT_NE(0, db.AddIconMapping(url, id2));
345 EXPECT_TRUE(db.GetIconMappingsForPageURL(url, &icon_mapping));
354 FaviconID id3 = db.AddFavicon(url, TOUCH_PRECOMPOSED_ICON);
355 db.SetFavicon(id3, favicon3, time);
356 EXPECT_NE(0, db.AddIconMapping(url, id3));
359 EXPECT_TRUE(db.GetIconMappingsForPageURL(url, &icon_mapping));
367 ThumbnailDatabase db;
368 ASSERT_EQ(sql::INIT_OK, db.Init(file_name_, NULL, NULL));
369 db.BeginTransaction();
375 FaviconID id1 = db.AddFavicon(GURL("http://google.com"), FAVICON);
378 db.SetFavicon(id1, favicon, time);
381 FaviconID id2 = db.AddFavicon(GURL("http://www.google.com/icon"), TOUCH_ICON);
384 db.SetFavicon(id2, favicon, time);
387 FaviconID id3 = db.AddFavicon(GURL("http://www.google.com/icon"), TOUCH_ICON);
390 db.SetFavicon(id3, favicon, time);
394 EXPECT_TRUE(db.AddIconMapping(page_url, id1));
395 EXPECT_TRUE(db.AddIconMapping(page_url, id2));
397 EXPECT_TRUE(db.HasMappingFor(id1));
398 EXPECT_TRUE(db.HasMappingFor(id2));
399 EXPECT_FALSE(db.HasMappingFor(id3));
402 db.DeleteIconMappings(page_url);
403 EXPECT_FALSE(db.HasMappingFor(id1));
404 EXPECT_FALSE(db.HasMappingFor(id2));
405 EXPECT_FALSE(db.HasMappingFor(id3));
416 ThumbnailDatabase db;
417 ASSERT_EQ(sql::INIT_OK, db.Init(thumbnail_db_name_, NULL, &history_db));
418 db.BeginTransaction();
424 EXPECT_TRUE(db.GetIconMappingsForPageURL(page_url1, &icon_mappings));
432 ASSERT_TRUE(db.GetFavicon(
439 EXPECT_TRUE(db.GetIconMappingsForPageURL(page_url3, &icon_mappings));
448 EXPECT_TRUE(db.GetIconMappingsForPageURL(page_url2, &icon_mappings));
453 ASSERT_TRUE(db.GetFavicon(
459 EXPECT_FALSE(db.GetIconMappingsForPageURL(page_url4, NULL));
