Cross Reference: /external/chromium_org/chrome/browser/history/android/urls_sql_handler

Lines Matching refs:row
52 // Insert a row only has URL to verify the visit count and last visit time
55   HistoryAndBookmarkRow row;
56   row.set_raw_url("http://google.com");
57   row.set_url(GURL("http://google.com"));
59   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
61   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
62   EXPECT_EQ(row.url(), url_row.url());
66   // The new row's id was set in url_row correctly.
67   EXPECT_EQ(row.url_id(), url_row.id());
70 // Insert a row with last visit time to verify the visit count is set to 1 by
73   HistoryAndBookmarkRow row;
74   row.set_raw_url("http://google.com");
75   row.set_url(GURL("http://google.com"));
76   row.set_last_visit_time(Time::Now());
78   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
80   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
81   EXPECT_EQ(row.url_id(), url_row.id());
82   EXPECT_EQ(row.url(), url_row.url());
85   EXPECT_EQ(row.last_visit_time(), url_row.last_visit());
88 // Insert a row with different last visit time and created time to verify the
91   HistoryAndBookmarkRow row;
92   row.set_raw_url("http://google.com");
93   row.set_url(GURL("http://google.com"));
94   row.set_last_visit_time(Time::Now());
95   row.set_created(Time::Now() - TimeDelta::FromDays(1));
97   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
99   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
100   EXPECT_EQ(row.url_id(), url_row.id());
101   EXPECT_EQ(row.url(), url_row.url());
104   EXPECT_EQ(row.last_visit_time(), url_row.last_visit());
107 // Insert a row with created time to verify the visit count is also set to 1
110   HistoryAndBookmarkRow row;
111   row.set_raw_url("http://google.com");
112   row.set_url(GURL("http://google.com"));
113   row.set_title(base::UTF8ToUTF16("Google"));
114   row.set_created(Time::Now());
116   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
118   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
119   EXPECT_EQ(row.url_id(), url_row.id());
120   EXPECT_EQ(row.url(), url_row.url());
124   EXPECT_EQ(row.created(), url_row.last_visit());
125   EXPECT_EQ(row.title(), url_row.title());
128 // Insert a row with the visit count as 1 to verify the last visit
131   HistoryAndBookmarkRow row;
132   row.set_raw_url("http://google.com");
133   row.set_url(GURL("http://google.com"));
134   row.set_visit_count(1);
136   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
138   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
139   EXPECT_EQ(row.url_id(), url_row.id());
140   EXPECT_EQ(row.url(), url_row.url());
146 // Insert a row with all columns set.
148   HistoryAndBookmarkRow row;
149   row.set_raw_url("http://google.com");
150   row.set_url(GURL("http://google.com"));
151   row.set_visit_count(10);
152   row.set_last_visit_time(Time::Now());
153   row.set_title(base::UTF8ToUTF16("Google"));
155   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
157   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
158   EXPECT_EQ(row.url_id(), url_row.id());
159   EXPECT_EQ(row.url(), url_row.url());
161   EXPECT_EQ(row.last_visit_time(), url_row.last_visit());
162   EXPECT_EQ(row.title(), url_row.title());
167   HistoryAndBookmarkRow row;
168   row.set_raw_url("http://google.com");
169   row.set_url(GURL("http://google.com"));
170   row.set_title(base::UTF8ToUTF16("Google"));
171   row.set_visit_count(10);
172   row.set_last_visit_time(Time::Now() - TimeDelta::FromDays(10));
174   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
175   ASSERT_TRUE(visit_sql_handler_.Insert(&row));
177   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
178   EXPECT_EQ(row.url(), url_row.url());
180   EXPECT_EQ(row.last_visit_time(), url_row.last_visit());
191   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
200   HistoryAndBookmarkRow row;
201   row.set_raw_url("http://google.com");
202   row.set_url(GURL("http://google.com"));
203   row.set_title(base::UTF8ToUTF16("Google"));
204   row.set_visit_count(10);
205   row.set_last_visit_time(Time::Now() - TimeDelta::FromDays(10));
207   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
208   ASSERT_TRUE(visit_sql_handler_.Insert(&row));
210   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
211   EXPECT_EQ(row.url(), url_row.url());
213   EXPECT_EQ(row.last_visit_time(), url_row.last_visit());
224   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
231   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
239   HistoryAndBookmarkRow row;
240   row.set_raw_url("http://google.com");
241   row.set_url(GURL("http://google.com"));
242   row.set_visit_count(100);
243   row.set_last_visit_time(Time::Now() - TimeDelta::FromDays(10));
245   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
246   ASSERT_TRUE(visit_sql_handler_.Insert(&row));
248   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
249   EXPECT_EQ(row.url(), url_row.url());
251   EXPECT_EQ(row.last_visit_time(), url_row.last_visit());
260   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
269   HistoryAndBookmarkRow row;
270   row.set_raw_url("http://google.com");
271   row.set_url(GURL("http://google.com"));
272   row.set_visit_count(100);
273   row.set_last_visit_time(Time::Now() - TimeDelta::FromDays(10));
275   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
276   ASSERT_TRUE(visit_sql_handler_.Insert(&row));
278   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
279   EXPECT_EQ(row.url(), url_row.url());
281   EXPECT_EQ(row.last_visit_time(), url_row.last_visit());
294   HistoryAndBookmarkRow row;
295   row.set_raw_url("http://google.com");
296   row.set_url(GURL("http://google.com"));
297   row.set_visit_count(10);
298   row.set_last_visit_time(Time::Now() - TimeDelta::FromDays(10));
300   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
301   ASSERT_TRUE(visit_sql_handler_.Insert(&row));
303   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
304   EXPECT_EQ(row.url(), url_row.url());
306   EXPECT_EQ(row.last_visit_time(), url_row.last_visit());
315   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
316   EXPECT_EQ(row.url(), url_row.url());
318   EXPECT_LT(row.last_visit_time(), url_row.last_visit());
322   HistoryAndBookmarkRow row;
323   row.set_raw_url("http://google.com");
324   row.set_url(GURL("http://google.com"));
325   row.set_visit_count(10);
326   row.set_last_visit_time(Time::Now() - TimeDelta::FromDays(10));
328   ASSERT_TRUE(urls_sql_handler_.Insert(&row));
330   ASSERT_TRUE(history_db_.GetURLRow(row.url_id(), &url_row));
331   EXPECT_EQ(row.url(), url_row.url());
333   EXPECT_EQ(row.last_visit_time(), url_row.last_visit());
340   EXPECT_FALSE(history_db_.GetURLRow(row.url_id(), &url_row));