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

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

Issue 6652008: Implemented substring matching within page titles. Fixed bug where URL was be... (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src/
Patch Set: '' Created 9 years, 9 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 This test file contains 4 items which should not pass the quick history 26 The ordering, URLs and titles must be kept in sync with the unit tests found
27 provider filter: 1, 9-11. 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); 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);
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) ; 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) ;
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); 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);
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); 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);
33 INSERT INTO "urls" VALUES(5,'http://drudgereport.com/','DRUDGE REPORT 2010®',3,2 ,2,0,0); 33 INSERT INTO "urls" VALUES(5,'http://drudgereport.com/','DRUDGE REPORT 2010',3,2, 2,0,0);
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); 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);
35 INSERT INTO "urls" VALUES(7,'http://www.clickgamer.com/products/pid_5269/screens hots/j2me/large/ingame5.png','ingame5.png 176×208 pixels',4,2,2,0,21); 35 INSERT INTO "urls" VALUES(7,'http://www.clickgamer.com/products/pid_5269/screens hots/j2me/large/ingame5.png','ingame5.png 176×208 pixels',4,2,2,0,21);
36 INSERT INTO "urls" VALUES(8,'http://getsharekit.com/','ShareKit : Drop-in Share Features for all iOS Apps',4,2,4,0,20); 36 INSERT INTO "urls" VALUES(8,'http://getsharekit.com/','ShareKit : Drop-in Share Features for all iOS Apps',4,2,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); 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);
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); 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);
41 INSERT INTO "urls" VALUES(13,'http://www.itmedia.co.jp/news/','ITmedia News/ITの今 が見える、明日が分かる',6,6,0,0,25); 41 INSERT INTO "urls" VALUES(13,'http://www.itmedia.co.jp/news/','ITmedia News/ITの今 が見える、明日が分かる',6,6,0,0,25);
42 INSERT INTO "urls" VALUES(14,'http://www.nikkei.co.jp/','NIKKEI NET(日経ネット)は日本経済新 聞 電子版に生まれ変わりました',6,6,0,0,73); 42 INSERT INTO "urls" VALUES(14,'http://www.nikkei.co.jp/','NIKKEI NET(日経ネット)は日本経済新 聞 電子版に生まれ変わりました',6,6,0,0,73);
43 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); 43 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);
44 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); 44 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);
45 INSERT INTO "urls" VALUES(17,'http://www.crash.net/','Crash.Net | Formula 1 & Mo toGP | Motorsport News',6,6,0,0,239); 45 INSERT INTO "urls" VALUES(17,'http://www.crash.net/','Crash.Net | Formula 1 & Mo toGP | Motorsport News',6,6,0,0,239);
46 INSERT INTO "urls" VALUES(18,'http://www.theinquirer.net/','THE INQUIRER - Micro processor, Server, Memory, PCS, Graphics, Networking, Storage',6,6,0,0,79); 46 INSERT INTO "urls" VALUES(18,'http://www.theinquirer.net/','THE INQUIRER - Micro processor, Server, Memory, PCS, Graphics, Networking, Storage',6,6,0,0,79);
47 INSERT INTO "urls" VALUES(19,'http://www.theregister.co.uk/','The Register: Sci/ Tech News for the World',6,6,0,0,74); 47 INSERT INTO "urls" VALUES(19,'http://www.theregister.co.uk/','The Register: Sci/ Tech News for the World',6,6,0,0,74);
48 INSERT INTO "urls" VALUES(20,'http://blogs.technet.com/markrussinovich/','Mark'' s Blog - Site Home - TechNet Blogs',6,6,0,0,685); 48 INSERT INTO "urls" VALUES(20,'http://blogs.technet.com/markrussinovich/','Mark'' s Blog - Site Home - TechNet Blogs',6,6,0,0,685);
49 INSERT INTO "urls" VALUES(21,'http://www.icu-project.org/','ICU Home Page (ICU - International Components for Unicode)',6,6,0,0,445); 49 INSERT INTO "urls" VALUES(21,'http://www.icu-project.org/','ICU Home Page (ICU - International Components for Unicode)',6,6,0,0,445);
50 INSERT INTO "urls" VALUES(22,'http://site.icu-project.org/','ICU Home Page (ICU - International Components for Unicode)',6,6,0,0,445); 50 INSERT INTO "urls" VALUES(22,'http://site.icu-project.org/','ICU Home Page (ICU - International Components for Unicode)',6,6,0,0,445);
51 INSERT INTO "urls" VALUES(23,'http://icu-project.org/apiref/icu4c/','ICU 4.2: Ma in Page',6,6,0,0,212); 51 INSERT INTO "urls" VALUES(23,'http://icu-project.org/apiref/icu4c/','ICU 4.2: Ma in Page',6,6,0,0,212);
52 INSERT INTO "urls" VALUES(24,'http://www.danilatos.com/event-test/ExperimentTest .html','Experimentation Harness',6,6,0,0,0); 52 INSERT INTO "urls" VALUES(24,'http://www.danilatos.com/event-test/ExperimentTest .html','Experimentation Harness',6,6,0,0,0);
53 INSERT INTO "urls" VALUES(25,'http://www.codeguru.com/','CodeGuru : codeguru',6, 6,0,0,110); 53 INSERT INTO "urls" VALUES(25,'http://www.codeguru.com/','CodeGuru : codeguru',6, 6,0,0,110);
54 INSERT INTO "urls" VALUES(26,'http://www.codeproject.com/','Your Development Res ource - CodeProject',6,6,0,0,369); 54 INSERT INTO "urls" VALUES(26,'http://www.codeproject.com/','Your Development Res ource - CodeProject',6,6,0,0,369);
55 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); 55 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);
56 INSERT INTO "urls" VALUES(28,'http://www.ddj.com/windows/184416623','Dr. Dobb''s | Avoiding the Visual C++ Runtime Library | 2 1, 2003',6,6,0,0,0); 56 INSERT INTO "urls" VALUES(28,'http://www.ddj.com/windows/184416623','Dr. Dobb''s | Avoiding the Visual C++ Runtime Library | 2 1, 2003',6,6,0,0,0);
57 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); 57 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);
58 INSERT INTO "urls" VALUES(30,'http://www.drudgery.com/','Life in the Slow Lane', 3,2,2,0,0); 58 INSERT INTO "urls" VALUES(30,'http://www.drudgery.com/','Life in the Slow Lane', 3,2,2,0,0);
59 INSERT INTO "urls" VALUES(31,'http://www.redrudgerydo.com/','Music of the Wild L andscape',0,0,6,0,0); 59 INSERT INTO "urls" VALUES(31,'http://www.redrudgerydo.com/','Music of the Wild L andscape',0,0,6,0,0);
60 INSERT INTO "urls" VALUES(32,'http://NearlyPerfectResult.com/','Practically Perf ect Search Result',99,99,0,0,0); 60 INSERT INTO "urls" VALUES(32,'https://NearlyPerfectResult.com/','Practically Per fect Search Result',99,99,0,0,0);
61 INSERT INTO "urls" VALUES(33,'http://QuiteUselessSearchResultxyz.com/','Practica lly Useless Search Result',4,0,99,0,0); 61 INSERT INTO "urls" VALUES(33,'http://QuiteUselessSearchResultxyz.com/','Practica lly Useless Search Result',4,0,99,0,0);
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698