Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(437)

Side by Side Diff: chrome/test/data/History/url_history_provider_test.db.txt

Issue 10837244: Replace HistoryQuickProvider protobuf-based caching with an SQLite-based database. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src/
Patch Set: Tweak suppression. Created 8 years, 4 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch | Annotate | Revision Log
OLDNEW
1 /* 1 /*
2 The schema of the database is defined by HISTORY_URL_ROW_FIELDS found in 2 The schema of the database is defined by HISTORY_URL_ROW_FIELDS found in
3 url_database.h and is equivalent to: 3 url_database.h and is equivalent to:
4 4
5 CREATE TABLE urls(id INTEGER PRIMARY KEY, 5 CREATE TABLE urls(id INTEGER PRIMARY KEY,
6 url LONGVARCHAR, 6 url LONGVARCHAR,
7 title LONGVARCHAR, 7 title LONGVARCHAR,
8 visit_count INTEGER DEFAULT 0 NOT NULL, 8 visit_count INTEGER DEFAULT 0 NOT NULL,
9 typed_count INTEGER DEFAULT 0 NOT NULL, 9 typed_count INTEGER DEFAULT 0 NOT NULL,
10 last_visit_time INTEGER NOT NULL, 10 last_visit_time INTEGER NOT NULL,
11 hidden INTEGER DEFAULT 0 NOT NULL, 11 hidden INTEGER DEFAULT 0 NOT NULL,
12 favicon_id INTEGER DEFAULT 0 NOT NULL); 12 favicon_id INTEGER DEFAULT 0 NOT NULL);
13 13
14 The quick history autocomplete provider filters out history items that: 14 The quick history autocomplete provider filters out history items that:
15 1) have not been visited in kLowQualityMatchAgeLimitInDays, AND 15 1) have not been visited in kLowQualityMatchAgeLimitInDays, AND
16 2) for which the URL was not explicitly typed at least 16 2) for which the URL was not explicitly typed at least
17 kLowQualityMatchTypedLimit + 1 times, AND 17 kLowQualityMatchTypedLimit + 1 times, AND
18 3) have not been visited at least kLowQualityMatchVisitLimit + 1 times. 18 3) have not been visited at least kLowQualityMatchVisitLimit + 1 times.
19 So we create history items in all of those combinations. 19 So we create history items in all of those combinations.
20 20
21 Note that the last_visit_time column for this test table represents the 21 Note that the last_visit_time column for this test table represents the
22 relative number of days prior to 'today' to which the final column 22 relative number of days prior to 'today' to which the final column
23 value will be set during test setup. Beware: Do not set this number 23 value will be set during test setup. Beware: Do not set this number
24 to be equal to kLowQualityMatchAgeLimitInDays. 24 to be equal to kLowQualityMatchAgeLimitInDays.
25 25
26 The ordering, URLs and titles must be kept in sync with the unit tests found 26 The ordering, URLs and titles must be kept in sync with the unit tests found
27 in in_memory_url_index_unittest.cc. 27 in in_memory_url_index_unittest.cc.
28 */ 28 */
29 INSERT INTO "urls" VALUES(1,'http://www.reuters.com/article/idUSN083988062010070 8','UPDATE 1-US 30-yr mortgage rate drops to new record low | Reuters',3,1,2,0,2 9); // Qualifies 29 INSERT INTO "urls" VALUES(1,'http://www.reuters.com/article/idUSN083988062010070 8','UPDATE 1-US 30-yr mortgage rate drops to new record low | Reuters',3,1,2,0,2 9); /* Qualifies */
30 INSERT INTO "urls" VALUES(2,'http://www.golfweek.com/news/2010/jul/08/goydos-ope ns-john-deere-classic-59/','Goydos opens John Deere Classic with 59',3,1,4,0,27) ; // Qualifies 30 INSERT INTO "urls" VALUES(2,'http://www.golfweek.com/news/2010/jul/08/goydos-ope ns-john-deere-classic-59/','Goydos opens John Deere Classic with 59',3,1,4,0,27) ; /* Qualifies */
31 INSERT INTO "urls" VALUES(3,'http://www.businessandmedia.org/articles/2010/20100 708120415.aspx','LeBronomics: Could High Taxes Influence James'' Team Decision?' ,4,1,2,0,28); // Qualifies 31 INSERT INTO "urls" VALUES(3,'http://www.businessandmedia.org/articles/2010/20100 708120415.aspx','LeBronomics: Could High Taxes Influence James'' Team Decision?' ,4,1,2,0,28); /* Qualifies */
32 INSERT INTO "urls" VALUES(4,'http://www.realclearmarkets.com/articles/2010/07/08 /diversity_in_the_financial_sector_98562.html','RealClearMarkets - Racial, Gende r Quotas in the Financial Bill?',4,1,4,0,0); // Qualifies 32 INSERT INTO "urls" VALUES(4,'http://www.realclearmarkets.com/articles/2010/07/08 /diversity_in_the_financial_sector_98562.html','RealClearMarkets - Racial, Gende r Quotas in the Financial Bill?',4,1,4,0,0); /* Qualifies */
33 INSERT INTO "urls" VALUES(5,'http://drudgereport.com/','DRUDGE REPORT 2010',3,2, 2,0,0); // Qualifies 33 INSERT INTO "urls" VALUES(5,'http://drudgereport.com/','DRUDGE REPORT 2010',3,2, 2,0,0); /* Qualifies */
34 INSERT INTO "urls" VALUES(6,'http://totalfinder.binaryage.com/','TotalFinder bri ngs tabs to your native Finder and more!',3,2,4,0,26); // Qualifies 34 INSERT INTO "urls" VALUES(6,'http://totalfinder.binaryage.com/','TotalFinder bri ngs tabs to your native Finder and more!',3,2,4,0,26); /* Qualifies */
35 INSERT INTO "urls" VALUES(7,'http://getsharekit.com/','ShareKit : Drop-in Share Features for all iOS Apps',4,2,4,0,20); // Qualifies 35 INSERT INTO "urls" VALUES(7,'http://getsharekit.com/','ShareKit : Drop-in Share Features for all iOS Apps',4,2,4,0,20); /* Qualifies */
36 INSERT INTO "urls" VALUES(8,'http://getsharekit.com/index.html','ShareKit : Drop -in Share Features for all iOS Apps',3,0,4,0,20); 36 INSERT INTO "urls" VALUES(8,'http://getsharekit.com/index.html','ShareKit : Drop -in Share Features for all iOS Apps',3,0,4,0,20);
37 INSERT INTO "urls" VALUES(9,'http://en.wikipedia.org/wiki/Control-Z','Control-Z - Wikipedia, the free encyclopedia',0,0,6,0,0); 37 INSERT INTO "urls" VALUES(9,'http://en.wikipedia.org/wiki/Control-Z','Control-Z - Wikipedia, the free encyclopedia',0,0,6,0,0);
38 INSERT INTO "urls" VALUES(10,'http://vmware.com/info?id=724','VMware Account Man agement Login',1,0,6,0,0); 38 INSERT INTO "urls" VALUES(10,'http://vmware.com/info?id=724','VMware Account Man agement Login',1,0,6,0,0);
39 INSERT INTO "urls" VALUES(11,'http://www.tech-recipes.com/rx/2621/os_x_change_pa th_environment_variable/','OS X: Change your PATH environment variable | Mac sys tem administration | Tech-Recipes',0,1,6,0,14); // Qualifies 39 INSERT INTO "urls" VALUES(11,'http://www.tech-recipes.com/rx/2621/os_x_change_pa th_environment_variable/','OS X: Change your PATH environment variable | Mac sys tem administration | Tech-Recipes',0,1,6,0,14); /* Qualifies */
40 INSERT INTO "urls" VALUES(12,'http://view.atdmt.com/PPJ/iview/194841301/direct;w i.160;hi.600/01?click=','',6,6,0,1,0); // Qualifies 40 INSERT INTO "urls" VALUES(12,'http://view.atdmt.com/PPJ/iview/194841301/direct;w i.160;hi.600/01?click=','',6,6,0,1,0); /* Qualifies */
41 INSERT INTO "urls" VALUES(15,'http://www.cnn.com/','CNN.com International - Brea king, World, Business, Sports, Entertainment and Video News',6,6,0,0,89); // Qu alifies 41 INSERT INTO "urls" VALUES(15,'http://www.cnn.com/','CNN.com International - Brea king, World, Business, Sports, Entertainment and Video News',6,6,0,0,89); /* Qu alifies */
42 INSERT INTO "urls" VALUES(16,'http://www.zdnet.com/','Technology News, Analysis, Comments and Product Reviews for IT Professionals | ZDNet',6,6,0,0,652); // Qu alifies 42 INSERT INTO "urls" VALUES(16,'http://www.zdnet.com/','Technology News, Analysis, Comments and Product Reviews for IT Professionals | ZDNet',6,6,0,0,652); /* Qu alifies */
43 INSERT INTO "urls" VALUES(17,'http://www.crash.net/','Crash.Net | Formula 1 & Mo toGP | Motorsport News',6,6,0,0,239); // Qualifies 43 INSERT INTO "urls" VALUES(17,'http://www.crash.net/','Crash.Net | Formula 1 & Mo toGP | Motorsport News',6,6,0,0,239); /* Qualifies */
44 INSERT INTO "urls" VALUES(18,'http://www.theinquirer.net/','THE INQUIRER - Micro processor, Server, Memory, PCS, Graphics, Networking, Storage',6,6,0,0,79); // Qualifies 44 INSERT INTO "urls" VALUES(18,'http://www.theinquirer.net/','THE INQUIRER - Micro processor, Server, Memory, PCS, Graphics, Networking, Storage',6,6,0,0,79); /* Qualifies */
45 INSERT INTO "urls" VALUES(19,'http://www.theregister.co.uk/','The Register: Sci/ Tech News for the World',6,6,0,0,74); // Qualifies 45 INSERT INTO "urls" VALUES(19,'http://www.theregister.co.uk/','The Register: Sci/ Tech News for the World',6,6,0,0,74); /* Qualifies */
46 INSERT INTO "urls" VALUES(20,'http://blogs.technet.com/markrussinovich/','Mark'' s Blog - Site Home - TechNet Blogs',6,6,0,0,685); // Qualifies 46 INSERT INTO "urls" VALUES(20,'http://blogs.technet.com/markrussinovich/','Mark'' s Blog - Site Home - TechNet Blogs',6,6,0,0,685); /* Qualifies */
47 INSERT INTO "urls" VALUES(21,'http://www.icu-project.org/','ICU Home Page (ICU - International Components for Unicode)',6,6,0,0,445); // Qualifies 47 INSERT INTO "urls" VALUES(21,'http://www.icu-project.org/','ICU Home Page (ICU - International Components for Unicode)',6,6,0,0,445); /* Qualifies */
48 INSERT INTO "urls" VALUES(22,'http://site.icu-project.org/','ICU Home Page (ICU - International Components for Unicode)',6,6,0,0,445); // Qualifies 48 INSERT INTO "urls" VALUES(22,'http://site.icu-project.org/','ICU Home Page (ICU - International Components for Unicode)',6,6,0,0,445); /* Qualifies */
49 INSERT INTO "urls" VALUES(23,'http://icu-project.org/apiref/icu4c/','ICU 4.2: Ma in Page',6,6,0,0,212); // Qualifies 49 INSERT INTO "urls" VALUES(23,'http://icu-project.org/apiref/icu4c/','ICU 4.2: Ma in Page',6,6,0,0,212); /* Qualifies */
50 INSERT INTO "urls" VALUES(24,'http://www.danilatos.com/event-test/ExperimentTest .html','Experimentation Harness',6,6,0,0,0); // Qualifies 50 INSERT INTO "urls" VALUES(24,'http://www.danilatos.com/event-test/ExperimentTest .html','Experimentation Harness',6,6,0,0,0); /* Qualifies */
51 INSERT INTO "urls" VALUES(25,'http://www.codeguru.com/','CodeGuru : codeguru',6, 6,0,0,110); // Qualifies 51 INSERT INTO "urls" VALUES(25,'http://www.codeguru.com/','CodeGuru : codeguru',6, 6,0,0,110); /* Qualifies */
52 INSERT INTO "urls" VALUES(26,'http://www.codeproject.com/','Your Development Res ource - CodeProject',6,6,0,0,369); // Qualifies 52 INSERT INTO "urls" VALUES(26,'http://www.codeproject.com/','Your Development Res ource - CodeProject',6,6,0,0,369); /* Qualifies */
53 INSERT INTO "urls" VALUES(27,'http://www.tomshardware.com/us/#redir','Tom''s Har dware: Hardware News, Tests and Reviews',6,6,0,0,65); // Qualifies 53 INSERT INTO "urls" VALUES(27,'http://www.tomshardware.com/us/#redir','Tom''s Har dware: Hardware News, Tests and Reviews',6,6,0,0,65); /* Qualifies */
54 INSERT INTO "urls" VALUES(28,'http://www.ddj.com/windows/184416623','Dr. ABRACAD ABRA''s | Avoiding the Visual C++ Runtime Library | 2 1, 2003',6,6,0,0,0); // Q ualifies 54 INSERT INTO "urls" VALUES(28,'http://www.ddj.com/windows/184416623','Dr. ABRACAD ABRA''s | Avoiding the Visual C++ Runtime Library | 2 1, 2003',6,6,0,0,0); /* Q ualifies */
55 INSERT INTO "urls" VALUES(29,'http://svcs.cnn.com/weather/getForecast?time=34&mo de=json_html&zipCode=336736767676&locCode=EGLL&celcius=true&csiID=csi2','',6,6,0 ,1,0); // Qualifies 55 INSERT INTO "urls" VALUES(29,'http://svcs.cnn.com/weather/getForecast?time=34&mo de=json_html&zipCode=336736767676&locCode=EGLL&celcius=true&csiID=csi2','',6,6,0 ,1,0); /* Qualifies */
56 INSERT INTO "urls" VALUES(30,'http://www.drudgery.com/Dogs%20and%20Mice','Life i n the Slow Lane',8,2,2,0,0); // Qualifies 56 INSERT INTO "urls" VALUES(30,'http://www.drudgery.com/Dogs%20and%20Mice','Life i n the Slow Lane',8,2,2,0,0); /* Qualifies */
57 INSERT INTO "urls" VALUES(31,'http://www.redrudgerydo.com/','Music of the Wild L andscape',0,0,6,0,0); 57 INSERT INTO "urls" VALUES(31,'http://www.redrudgerydo.com/','Music of the Wild L andscape',0,0,6,0,0);
58 INSERT INTO "urls" VALUES(32,'https://NearlyPerfectResult.com/','Practically Per fect Search Result',99,99,0,0,0); // Qualifies 58 INSERT INTO "urls" VALUES(32,'https://NearlyPerfectResult.com/','Practically Per fect Search Result',99,99,0,0,0); /* Qualifies */
59 INSERT INTO "urls" VALUES(33,'http://QuiteUselessSearchResultxyz.com/','Practica lly Useless Search Result',4,0,99,0,0); // Qualifies 59 INSERT INTO "urls" VALUES(33,'http://QuiteUselessSearchResultxyz.com/','Practica lly Useless Search Result',4,0,99,0,0); /* Qualifies */
60 INSERT INTO "urls" VALUES(34,'http://FubarFubarAndFubar.com/','Situation Normal -- FUBARED',99,99,0,0,0); // Qualifies 60 INSERT INTO "urls" VALUES(34,'http://FubarFubarAndFubar.com/','Situation Normal -- FUBARED',99,99,0,0,0); /* Qualifies */
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698