The Tor Browser / file comparison

comparison: mobile/android/base/tests/testBrowserProvider.java

mobile/android/base/tests/testBrowserProvider.java

changeset 0
6474c204b198
equal deleted inserted replaced
-1:000000000000 0:0bc272bb4e0f
1 package org.mozilla.gecko.tests;
2
3 import java.util.ArrayList;
4 import java.util.Random;
5
6 import org.mozilla.gecko.db.BrowserContract;
7
8 import android.content.ContentProviderOperation;
9 import android.content.ContentProviderResult;
10 import android.content.ContentUris;
11 import android.content.ContentValues;
12 import android.content.OperationApplicationException;
13 import android.database.Cursor;
14 import android.net.Uri;
15 import android.os.Build;
16 import android.util.Log;
17
18 /*
19 * This test is meant to exercise all operations exposed by Fennec's
20 * history and bookmarks content provider. It does so in an isolated
21 * environment (see ContentProviderTest) without affecting any UI-related
22 * code.
23 */
24 public class testBrowserProvider extends ContentProviderTest {
25 private long mMobileFolderId;
26
27 private void loadMobileFolderId() throws Exception {
28 Cursor c = null;
29 try {
30 c = getBookmarkByGuid(BrowserContract.Bookmarks.MOBILE_FOLDER_GUID);
31 mAsserter.is(c.moveToFirst(), true, "Mobile bookmarks folder is present");
32
33 mMobileFolderId = c.getLong(c.getColumnIndex(BrowserContract.Bookmarks._ID));
34 } finally {
35 if (c != null) {
36 c.close();
37 }
38 }
39 }
40
41 private void ensureEmptyDatabase() throws Exception {
42 Cursor c = null;
43
44 String guid = BrowserContract.Bookmarks.GUID;
45
46 mProvider.delete(appendUriParam(BrowserContract.Bookmarks.CONTENT_URI, BrowserContract.PARAM_IS_SYNC, "1"),
47 guid + " != ? AND " +
48 guid + " != ? AND " +
49 guid + " != ? AND " +
50 guid + " != ? AND " +
51 guid + " != ? AND " +
52 guid + " != ? AND " +
53 guid + " != ?",
54 new String[] { BrowserContract.Bookmarks.PLACES_FOLDER_GUID,
55 BrowserContract.Bookmarks.MOBILE_FOLDER_GUID,
56 BrowserContract.Bookmarks.MENU_FOLDER_GUID,
57 BrowserContract.Bookmarks.TAGS_FOLDER_GUID,
58 BrowserContract.Bookmarks.TOOLBAR_FOLDER_GUID,
59 BrowserContract.Bookmarks.UNFILED_FOLDER_GUID,
60 BrowserContract.Bookmarks.READING_LIST_FOLDER_GUID });
61
62 c = mProvider.query(appendUriParam(BrowserContract.Bookmarks.CONTENT_URI, BrowserContract.PARAM_SHOW_DELETED, "1"), null, null, null, null);
63 assertCountIsAndClose(c, 7, "All non-special bookmarks and folders were deleted");
64
65 mProvider.delete(appendUriParam(BrowserContract.History.CONTENT_URI, BrowserContract.PARAM_IS_SYNC, "1"), null, null);
66 c = mProvider.query(appendUriParam(BrowserContract.History.CONTENT_URI, BrowserContract.PARAM_SHOW_DELETED, "1"), null, null, null, null);
67 assertCountIsAndClose(c, 0, "All history entries were deleted");
68
69 /**
70 * There's no reason why the following two parts should fail.
71 * But sometimes they do, and I'm not going to spend the time
72 * to figure out why in an unrelated bug.
73 */
74
75 mProvider.delete(appendUriParam(BrowserContract.Favicons.CONTENT_URI, BrowserContract.PARAM_IS_SYNC, "1"), null, null);
76 c = mProvider.query(appendUriParam(BrowserContract.Favicons.CONTENT_URI,
77 BrowserContract.PARAM_SHOW_DELETED, "1"),
78 null, null, null, null);
79
80 if (c.getCount() > 0) {
81 mAsserter.dumpLog("Unexpected favicons in ensureEmptyDatabase.");
82 }
83 c.close();
84
85 mAsserter.dumpLog("ensureEmptyDatabase: Favicon deletion completed."); // Bug 968951 debug.
86 // assertCountIsAndClose(c, 0, "All favicons were deleted");
87
88 mProvider.delete(appendUriParam(BrowserContract.Thumbnails.CONTENT_URI, BrowserContract.PARAM_IS_SYNC, "1"), null, null);
89 c = mProvider.query(appendUriParam(BrowserContract.Thumbnails.CONTENT_URI,
90 BrowserContract.PARAM_SHOW_DELETED, "1"),
91 null, null, null, null);
92
93 if (c.getCount() > 0) {
94 mAsserter.dumpLog("Unexpected thumbnails in ensureEmptyDatabase.");
95 }
96 c.close();
97
98 mAsserter.dumpLog("ensureEmptyDatabase: Thumbnail deletion completed."); // Bug 968951 debug.
99 // assertCountIsAndClose(c, 0, "All thumbnails were deleted");
100 }
101
102 private ContentValues createBookmark(String title, String url, long parentId,
103 int type, int position, String tags, String description, String keyword) throws Exception {
104 ContentValues bookmark = new ContentValues();
105
106 bookmark.put(BrowserContract.Bookmarks.TITLE, title);
107 bookmark.put(BrowserContract.Bookmarks.URL, url);
108 bookmark.put(BrowserContract.Bookmarks.PARENT, parentId);
109 bookmark.put(BrowserContract.Bookmarks.TYPE, type);
110 bookmark.put(BrowserContract.Bookmarks.POSITION, position);
111 bookmark.put(BrowserContract.Bookmarks.TAGS, tags);
112 bookmark.put(BrowserContract.Bookmarks.DESCRIPTION, description);
113 bookmark.put(BrowserContract.Bookmarks.KEYWORD, keyword);
114
115 return bookmark;
116 }
117
118 private ContentValues createOneBookmark() throws Exception {
119 return createBookmark("Example", "http://example.com", mMobileFolderId,
120 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
121 }
122
123 private Cursor getBookmarksByParent(long parent) throws Exception {
124 // Order by position.
125 return mProvider.query(BrowserContract.Bookmarks.CONTENT_URI, null,
126 BrowserContract.Bookmarks.PARENT + " = ?",
127 new String[] { String.valueOf(parent) },
128 BrowserContract.Bookmarks.POSITION);
129 }
130
131 private Cursor getBookmarkByGuid(String guid) throws Exception {
132 return mProvider.query(BrowserContract.Bookmarks.CONTENT_URI, null,
133 BrowserContract.Bookmarks.GUID + " = ?",
134 new String[] { guid },
135 null);
136 }
137
138 private Cursor getBookmarkById(long id) throws Exception {
139 return getBookmarkById(BrowserContract.Bookmarks.CONTENT_URI, id, null);
140 }
141
142 private Cursor getBookmarkById(long id, String[] projection) throws Exception {
143 return getBookmarkById(BrowserContract.Bookmarks.CONTENT_URI, id, projection);
144 }
145
146 private Cursor getBookmarkById(Uri bookmarksUri, long id) throws Exception {
147 return getBookmarkById(bookmarksUri, id, null);
148 }
149
150 private Cursor getBookmarkById(Uri bookmarksUri, long id, String[] projection) throws Exception {
151 return mProvider.query(bookmarksUri, projection,
152 BrowserContract.Bookmarks._ID + " = ?",
153 new String[] { String.valueOf(id) },
154 null);
155 }
156
157 private ContentValues createHistoryEntry(String title, String url, int visits, long lastVisited) throws Exception {
158 ContentValues historyEntry = new ContentValues();
159
160 historyEntry.put(BrowserContract.History.TITLE, title);
161 historyEntry.put(BrowserContract.History.URL, url);
162 historyEntry.put(BrowserContract.History.VISITS, visits);
163 historyEntry.put(BrowserContract.History.DATE_LAST_VISITED, lastVisited);
164
165 return historyEntry;
166 }
167
168 private ContentValues createFaviconEntry(String pageUrl, String data) throws Exception {
169 ContentValues faviconEntry = new ContentValues();
170
171 faviconEntry.put(BrowserContract.Favicons.PAGE_URL, pageUrl);
172 faviconEntry.put(BrowserContract.Favicons.URL, pageUrl + "/favicon.ico");
173 faviconEntry.put(BrowserContract.Favicons.DATA, data.getBytes("UTF8"));
174
175 return faviconEntry;
176 }
177
178 private ContentValues createThumbnailEntry(String pageUrl, String data) throws Exception {
179 ContentValues thumbnailEntry = new ContentValues();
180
181 thumbnailEntry.put(BrowserContract.Thumbnails.URL, pageUrl);
182 thumbnailEntry.put(BrowserContract.Thumbnails.DATA, data.getBytes("UTF8"));
183
184 return thumbnailEntry;
185 }
186
187 private ContentValues createOneHistoryEntry() throws Exception {
188 return createHistoryEntry("Example", "http://example.com", 10, System.currentTimeMillis());
189 }
190
191 private Cursor getHistoryEntryById(long id) throws Exception {
192 return getHistoryEntryById(BrowserContract.History.CONTENT_URI, id, null);
193 }
194
195 private Cursor getHistoryEntryById(long id, String[] projection) throws Exception {
196 return getHistoryEntryById(BrowserContract.History.CONTENT_URI, id, projection);
197 }
198
199 private Cursor getHistoryEntryById(Uri historyUri, long id) throws Exception {
200 return getHistoryEntryById(historyUri, id, null);
201 }
202
203 private Cursor getHistoryEntryById(Uri historyUri, long id, String[] projection) throws Exception {
204 return mProvider.query(historyUri, projection,
205 BrowserContract.History._ID + " = ?",
206 new String[] { String.valueOf(id) },
207 null);
208 }
209
210 private Cursor getFaviconsByUrl(String url) throws Exception {
211 return mProvider.query(BrowserContract.Combined.CONTENT_URI, null,
212 BrowserContract.Combined.URL + " = ?",
213 new String[] { url },
214 null);
215 }
216
217 private Cursor getThumbnailByUrl(String url) throws Exception {
218 return mProvider.query(BrowserContract.Thumbnails.CONTENT_URI, null,
219 BrowserContract.Thumbnails.URL + " = ?",
220 new String[] { url },
221 null);
222 }
223
224 @Override
225 public void setUp() throws Exception {
226 super.setUp(sBrowserProviderCallable, BrowserContract.AUTHORITY, "browser.db");
227
228 mTests.add(new TestSpecialFolders());
229
230 mTests.add(new TestInsertBookmarks());
231 mTests.add(new TestInsertBookmarksFavicons());
232 mTests.add(new TestDeleteBookmarks());
233 mTests.add(new TestDeleteBookmarksFavicons());
234 mTests.add(new TestUpdateBookmarks());
235 mTests.add(new TestUpdateBookmarksFavicons());
236 mTests.add(new TestPositionBookmarks());
237
238 mTests.add(new TestInsertHistory());
239 mTests.add(new TestInsertHistoryFavicons());
240 mTests.add(new TestDeleteHistory());
241 mTests.add(new TestDeleteHistoryFavicons());
242 mTests.add(new TestUpdateHistory());
243 mTests.add(new TestUpdateHistoryFavicons());
244 mTests.add(new TestUpdateOrInsertHistory());
245 mTests.add(new TestInsertHistoryThumbnails());
246 mTests.add(new TestUpdateHistoryThumbnails());
247 mTests.add(new TestDeleteHistoryThumbnails());
248
249 mTests.add(new TestBatchOperations());
250
251 mTests.add(new TestCombinedView());
252 mTests.add(new TestCombinedViewDisplay());
253 mTests.add(new TestCombinedViewWithDeletedBookmark());
254 mTests.add(new TestCombinedViewWithDeletedReadingListItem());
255 mTests.add(new TestExpireHistory());
256
257 mTests.add(new TestBrowserProviderNotifications());
258 }
259
260 public void testBrowserProvider() throws Exception {
261 loadMobileFolderId();
262
263 for (int i = 0; i < mTests.size(); i++) {
264 Runnable test = mTests.get(i);
265
266 final String testName = test.getClass().getSimpleName();
267 setTestName(testName);
268 ensureEmptyDatabase();
269 mAsserter.dumpLog("testBrowserProvider: Database empty - Starting " + testName + ".");
270 test.run();
271 }
272 }
273
274 private class TestBatchOperations extends TestCase {
275 static final int TESTCOUNT = 100;
276
277 public void testApplyBatch() throws Exception {
278 ArrayList<ContentProviderOperation> mOperations
279 = new ArrayList<ContentProviderOperation>();
280
281 // Test a bunch of inserts with applyBatch
282 ContentValues values = new ContentValues();
283 ContentProviderOperation.Builder builder = null;
284
285 for (int i = 0; i < TESTCOUNT; i++) {
286 values.clear();
287 values.put(BrowserContract.History.VISITS, i);
288 values.put(BrowserContract.History.TITLE, "Test" + i);
289 values.put(BrowserContract.History.URL, "http://www.test.org/" + i);
290
291 // Insert
292 builder = ContentProviderOperation.newInsert(BrowserContract.History.CONTENT_URI);
293 builder.withValues(values);
294 // Queue the operation
295 mOperations.add(builder.build());
296 }
297
298 ContentProviderResult[] applyResult =
299 mProvider.applyBatch(mOperations);
300
301 boolean allFound = true;
302 for (int i = 0; i < TESTCOUNT; i++) {
303 Cursor cursor = mProvider.query(BrowserContract.History.CONTENT_URI,
304 null,
305 BrowserContract.History.URL + " = ?",
306 new String[] { "http://www.test.org/" + i },
307 null);
308
309 if (!cursor.moveToFirst())
310 allFound = false;
311 cursor.close();
312 }
313 mAsserter.is(allFound, true, "Found all batchApply entries");
314 mOperations.clear();
315
316 // Update all visits to 1
317 values.clear();
318 values.put(BrowserContract.History.VISITS, 1);
319 for (int i = 0; i < TESTCOUNT; i++) {
320 builder = ContentProviderOperation.newUpdate(BrowserContract.History.CONTENT_URI);
321 builder.withSelection(BrowserContract.History.URL + " = ?",
322 new String[] {"http://www.test.org/" + i});
323 builder.withValues(values);
324 builder.withExpectedCount(1);
325 // Queue the operation
326 mOperations.add(builder.build());
327 }
328
329 boolean seenException = false;
330 try {
331 applyResult = mProvider.applyBatch(mOperations);
332 } catch (OperationApplicationException ex) {
333 seenException = true;
334 }
335 mAsserter.is(seenException, false, "Batch updating succeded");
336 mOperations.clear();
337
338 // Delete all visits
339 for (int i = 0; i < TESTCOUNT; i++) {
340 builder = ContentProviderOperation.newDelete(BrowserContract.History.CONTENT_URI);
341 builder.withSelection(BrowserContract.History.URL + " = ?",
342 new String[] {"http://www.test.org/" + i});
343 builder.withExpectedCount(1);
344 // Queue the operation
345 mOperations.add(builder.build());
346 }
347 try {
348 applyResult = mProvider.applyBatch(mOperations);
349 } catch (OperationApplicationException ex) {
350 seenException = true;
351 }
352 mAsserter.is(seenException, false, "Batch deletion succeeded");
353 }
354
355 // Force a Constraint error, see if later operations still apply correctly
356 public void testApplyBatchErrors() throws Exception {
357 ArrayList<ContentProviderOperation> mOperations
358 = new ArrayList<ContentProviderOperation>();
359
360 // Test a bunch of inserts with applyBatch
361 ContentProviderOperation.Builder builder = null;
362 ContentValues values = createFaviconEntry("http://www.test.org", "FAVICON");
363 builder = ContentProviderOperation.newInsert(BrowserContract.Favicons.CONTENT_URI);
364 builder.withValues(values);
365 mOperations.add(builder.build());
366
367 // Make a duplicate, this will fail because of a UNIQUE constraint
368 builder = ContentProviderOperation.newInsert(BrowserContract.Favicons.CONTENT_URI);
369 builder.withValues(values);
370 mOperations.add(builder.build());
371
372 // This is valid and should be in the table afterwards
373 values.put(BrowserContract.Favicons.URL, "http://www.test.org/valid.ico");
374 builder = ContentProviderOperation.newInsert(BrowserContract.Favicons.CONTENT_URI);
375 builder.withValues(values);
376 mOperations.add(builder.build());
377
378 boolean seenException = false;
379
380 try {
381 ContentProviderResult[] applyResult =
382 mProvider.applyBatch(mOperations);
383 } catch (OperationApplicationException ex) {
384 seenException = true;
385 }
386
387 // This test may need to go away if Bug 717428 is fixed.
388 mAsserter.is(seenException, true, "Expected failure in favicons table");
389
390 boolean allFound = true;
391 Cursor cursor = mProvider.query(BrowserContract.Favicons.CONTENT_URI,
392 null,
393 BrowserContract.Favicons.URL + " = ?",
394 new String[] { "http://www.test.org/valid.ico" },
395 null);
396
397 if (!cursor.moveToFirst())
398 allFound = false;
399 cursor.close();
400
401 mAsserter.is(allFound, true, "Found all applyBatch (with error) entries");
402 }
403
404 public void testBulkInsert() throws Exception {
405 // Test a bunch of inserts with bulkInsert
406 ContentValues allVals[] = new ContentValues[TESTCOUNT];
407 for (int i = 0; i < TESTCOUNT; i++) {
408 allVals[i] = new ContentValues();
409 allVals[i].put(BrowserContract.History.URL, i);
410 allVals[i].put(BrowserContract.History.TITLE, "Test" + i);
411 allVals[i].put(BrowserContract.History.URL, "http://www.test.org/" + i);
412 }
413
414 int inserts = mProvider.bulkInsert(BrowserContract.History.CONTENT_URI, allVals);
415 mAsserter.is(inserts, TESTCOUNT, "Excepted number of inserts matches");
416
417 boolean allFound = true;
418 for (int i = 0; i < TESTCOUNT; i++) {
419 Cursor cursor = mProvider.query(BrowserContract.History.CONTENT_URI,
420 null,
421 BrowserContract.History.URL + " = ?",
422 new String[] { "http://www.test.org/" + i },
423 null);
424
425 if (!cursor.moveToFirst())
426 allFound = false;
427 cursor.close();
428 }
429 mAsserter.is(allFound, true, "Found all bulkInsert entries");
430 }
431
432 @Override
433 public void test() throws Exception {
434 testApplyBatch();
435 // Clean up
436 ensureEmptyDatabase();
437
438 testBulkInsert();
439 ensureEmptyDatabase();
440
441 testApplyBatchErrors();
442 }
443 }
444
445 private class TestSpecialFolders extends TestCase {
446 @Override
447 public void test() throws Exception {
448 Cursor c = mProvider.query(BrowserContract.Bookmarks.CONTENT_URI,
449 new String[] { BrowserContract.Bookmarks._ID,
450 BrowserContract.Bookmarks.GUID,
451 BrowserContract.Bookmarks.PARENT },
452 BrowserContract.Bookmarks.GUID + " = ? OR " +
453 BrowserContract.Bookmarks.GUID + " = ? OR " +
454 BrowserContract.Bookmarks.GUID + " = ? OR " +
455 BrowserContract.Bookmarks.GUID + " = ? OR " +
456 BrowserContract.Bookmarks.GUID + " = ? OR " +
457 BrowserContract.Bookmarks.GUID + " = ? OR " +
458 BrowserContract.Bookmarks.GUID + " = ?",
459 new String[] { BrowserContract.Bookmarks.PLACES_FOLDER_GUID,
460 BrowserContract.Bookmarks.MOBILE_FOLDER_GUID,
461 BrowserContract.Bookmarks.MENU_FOLDER_GUID,
462 BrowserContract.Bookmarks.TAGS_FOLDER_GUID,
463 BrowserContract.Bookmarks.TOOLBAR_FOLDER_GUID,
464 BrowserContract.Bookmarks.UNFILED_FOLDER_GUID,
465 BrowserContract.Bookmarks.READING_LIST_FOLDER_GUID },
466 null);
467
468 mAsserter.is(c.getCount(), 7, "Right number of special folders");
469
470 int rootId = BrowserContract.Bookmarks.FIXED_ROOT_ID;
471 int readingListId = BrowserContract.Bookmarks.FIXED_READING_LIST_ID;
472
473 while (c.moveToNext()) {
474 int id = c.getInt(c.getColumnIndex(BrowserContract.Bookmarks._ID));
475 String guid = c.getString(c.getColumnIndex(BrowserContract.Bookmarks.GUID));
476 int parentId = c.getInt(c.getColumnIndex(BrowserContract.Bookmarks.PARENT));
477
478 if (guid.equals(BrowserContract.Bookmarks.PLACES_FOLDER_GUID)) {
479 mAsserter.is(new Integer(id), new Integer(rootId), "The id of places folder is correct");
480 } else if (guid.equals(BrowserContract.Bookmarks.READING_LIST_FOLDER_GUID)) {
481 mAsserter.is(new Integer(id), new Integer(readingListId), "The id of reading list folder is correct");
482 }
483
484 mAsserter.is(new Integer(parentId), new Integer(rootId),
485 "The PARENT of the " + guid + " special folder is correct");
486 }
487
488 c.close();
489 }
490 }
491
492 private class TestInsertBookmarks extends TestCase {
493 private long insertWithNullCol(String colName) throws Exception {
494 ContentValues b = createOneBookmark();
495 b.putNull(colName);
496 long id = -1;
497
498 try {
499 id = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
500 } catch (Exception e) {}
501
502 return id;
503 }
504
505 @Override
506 public void test() throws Exception {
507 ContentValues b = createOneBookmark();
508 long id = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
509 Cursor c = getBookmarkById(id);
510
511 mAsserter.is(c.moveToFirst(), true, "Inserted bookmark found");
512
513 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.TITLE)), b.getAsString(BrowserContract.Bookmarks.TITLE),
514 "Inserted bookmark has correct title");
515 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.URL)), b.getAsString(BrowserContract.Bookmarks.URL),
516 "Inserted bookmark has correct URL");
517 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.TAGS)), b.getAsString(BrowserContract.Bookmarks.TAGS),
518 "Inserted bookmark has correct tags");
519 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.KEYWORD)), b.getAsString(BrowserContract.Bookmarks.KEYWORD),
520 "Inserted bookmark has correct keyword");
521 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.DESCRIPTION)), b.getAsString(BrowserContract.Bookmarks.DESCRIPTION),
522 "Inserted bookmark has correct description");
523 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.POSITION)), b.getAsString(BrowserContract.Bookmarks.POSITION),
524 "Inserted bookmark has correct position");
525 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.TYPE)), b.getAsString(BrowserContract.Bookmarks.TYPE),
526 "Inserted bookmark has correct type");
527 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.PARENT)), b.getAsString(BrowserContract.Bookmarks.PARENT),
528 "Inserted bookmark has correct parent ID");
529 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.IS_DELETED)), String.valueOf(0),
530 "Inserted bookmark has correct is-deleted state");
531
532 id = insertWithNullCol(BrowserContract.Bookmarks.POSITION);
533 mAsserter.is(new Long(id), new Long(-1),
534 "Should not be able to insert bookmark with null position");
535
536 id = insertWithNullCol(BrowserContract.Bookmarks.TYPE);
537 mAsserter.is(new Long(id), new Long(-1),
538 "Should not be able to insert bookmark with null type");
539
540 if (Build.VERSION.SDK_INT >= 8 &&
541 Build.VERSION.SDK_INT < 16) {
542 b = createOneBookmark();
543 b.put(BrowserContract.Bookmarks.PARENT, -1);
544 id = -1;
545
546 try {
547 id = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
548 } catch (Exception e) {}
549
550 mAsserter.is(new Long(id), new Long(-1),
551 "Should not be able to insert bookmark with invalid parent");
552 }
553
554 b = createOneBookmark();
555 b.remove(BrowserContract.Bookmarks.TYPE);
556 id = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
557 c = getBookmarkById(id);
558
559 mAsserter.is(c.moveToFirst(), true, "Inserted bookmark found");
560
561 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.TYPE)), String.valueOf(BrowserContract.Bookmarks.TYPE_BOOKMARK),
562 "Inserted bookmark has correct default type");
563 c.close();
564 }
565 }
566
567 private class TestInsertBookmarksFavicons extends TestCase {
568 @Override
569 public void test() throws Exception {
570 ContentValues b = createOneBookmark();
571
572 final String favicon = "FAVICON";
573 final String pageUrl = b.getAsString(BrowserContract.Bookmarks.URL);
574
575 long id = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
576
577 // Insert the favicon into the favicons table
578 mProvider.insert(BrowserContract.Favicons.CONTENT_URI, createFaviconEntry(pageUrl, favicon));
579
580 Cursor c = getBookmarkById(id, new String[] { BrowserContract.Bookmarks.FAVICON });
581
582 mAsserter.is(c.moveToFirst(), true, "Inserted bookmark found");
583
584 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Bookmarks.FAVICON)), "UTF8"),
585 favicon, "Inserted bookmark has corresponding favicon image");
586 c.close();
587
588 c = getFaviconsByUrl(pageUrl);
589 mAsserter.is(c.moveToFirst(), true, "Inserted favicon found");
590
591 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Combined.FAVICON)), "UTF8"),
592 favicon, "Inserted favicon has corresponding favicon image");
593 c.close();
594 }
595 }
596
597 private class TestDeleteBookmarks extends TestCase {
598 private long insertOneBookmark() throws Exception {
599 ContentValues b = createOneBookmark();
600 long id = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
601
602 Cursor c = getBookmarkById(id);
603 mAsserter.is(c.moveToFirst(), true, "Inserted bookmark found");
604 c.close();
605
606 return id;
607 }
608
609 @Override
610 public void test() throws Exception {
611 long id = insertOneBookmark();
612
613 int deleted = mProvider.delete(BrowserContract.Bookmarks.CONTENT_URI,
614 BrowserContract.Bookmarks._ID + " = ?",
615 new String[] { String.valueOf(id) });
616
617 mAsserter.is((deleted == 1), true, "Inserted bookmark was deleted");
618
619 Cursor c = getBookmarkById(appendUriParam(BrowserContract.Bookmarks.CONTENT_URI, BrowserContract.PARAM_SHOW_DELETED, "1"), id);
620 mAsserter.is(c.moveToFirst(), true, "Deleted bookmark was only marked as deleted");
621 c.close();
622
623 deleted = mProvider.delete(appendUriParam(BrowserContract.Bookmarks.CONTENT_URI, BrowserContract.PARAM_IS_SYNC, "1"),
624 BrowserContract.Bookmarks._ID + " = ?",
625 new String[] { String.valueOf(id) });
626
627 mAsserter.is((deleted == 1), true, "Inserted bookmark was deleted");
628
629 c = getBookmarkById(appendUriParam(BrowserContract.Bookmarks.CONTENT_URI, BrowserContract.PARAM_SHOW_DELETED, "1"), id);
630 mAsserter.is(c.moveToFirst(), false, "Inserted bookmark is now actually deleted");
631 c.close();
632
633 id = insertOneBookmark();
634
635 deleted = mProvider.delete(ContentUris.withAppendedId(BrowserContract.Bookmarks.CONTENT_URI, id), null, null);
636 mAsserter.is((deleted == 1), true,
637 "Inserted bookmark was deleted using URI with id");
638
639 c = getBookmarkById(id);
640 mAsserter.is(c.moveToFirst(), false,
641 "Inserted bookmark can't be found after deletion using URI with ID");
642 c.close();
643
644 if (Build.VERSION.SDK_INT >= 8 &&
645 Build.VERSION.SDK_INT < 16) {
646 ContentValues b = createBookmark("Folder", null, mMobileFolderId,
647 BrowserContract.Bookmarks.TYPE_FOLDER, 0, "folderTags", "folderDescription", "folderKeyword");
648
649 long parentId = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
650 c = getBookmarkById(parentId);
651 mAsserter.is(c.moveToFirst(), true, "Inserted bookmarks folder found");
652 c.close();
653
654 b = createBookmark("Example", "http://example.com", parentId,
655 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
656
657 id = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
658 c = getBookmarkById(id);
659 mAsserter.is(c.moveToFirst(), true, "Inserted bookmark found");
660 c.close();
661
662 deleted = 0;
663 try {
664 Uri uri = ContentUris.withAppendedId(BrowserContract.Bookmarks.CONTENT_URI, parentId);
665 deleted = mProvider.delete(appendUriParam(uri, BrowserContract.PARAM_IS_SYNC, "1"), null, null);
666 } catch(Exception e) {}
667
668 mAsserter.is((deleted == 0), true,
669 "Should not be able to delete folder that causes orphan bookmarks");
670 }
671 }
672 }
673
674 private class TestDeleteBookmarksFavicons extends TestCase {
675 @Override
676 public void test() throws Exception {
677 ContentValues b = createOneBookmark();
678
679 final String pageUrl = b.getAsString(BrowserContract.Bookmarks.URL);
680 long id = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
681
682 // Insert the favicon into the favicons table
683 mProvider.insert(BrowserContract.Favicons.CONTENT_URI, createFaviconEntry(pageUrl, "FAVICON"));
684
685 Cursor c = getFaviconsByUrl(pageUrl);
686 mAsserter.is(c.moveToFirst(), true, "Inserted favicon found");
687 c.close();
688
689 mProvider.delete(ContentUris.withAppendedId(BrowserContract.Bookmarks.CONTENT_URI, id), null, null);
690
691 c = getFaviconsByUrl(pageUrl);
692 mAsserter.is(c.moveToFirst(), false, "Favicon is deleted with last reference to it");
693 c.close();
694 }
695 }
696
697 private class TestUpdateBookmarks extends TestCase {
698 private int updateWithNullCol(long id, String colName) throws Exception {
699 ContentValues u = new ContentValues();
700 u.putNull(colName);
701
702 int updated = 0;
703
704 try {
705 updated = mProvider.update(BrowserContract.Bookmarks.CONTENT_URI, u,
706 BrowserContract.Bookmarks._ID + " = ?",
707 new String[] { String.valueOf(id) });
708 } catch (Exception e) {}
709
710 return updated;
711 }
712
713 @Override
714 public void test() throws Exception {
715 ContentValues b = createOneBookmark();
716 long id = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b));
717
718 Cursor c = getBookmarkById(id);
719 mAsserter.is(c.moveToFirst(), true, "Inserted bookmark found");
720
721 long dateCreated = c.getLong(c.getColumnIndex(BrowserContract.Bookmarks.DATE_CREATED));
722 long dateModified = c.getLong(c.getColumnIndex(BrowserContract.Bookmarks.DATE_MODIFIED));
723
724 ContentValues u = new ContentValues();
725 u.put(BrowserContract.Bookmarks.TITLE, b.getAsString(BrowserContract.Bookmarks.TITLE) + "CHANGED");
726 u.put(BrowserContract.Bookmarks.URL, b.getAsString(BrowserContract.Bookmarks.URL) + "/more/stuff");
727 u.put(BrowserContract.Bookmarks.TAGS, b.getAsString(BrowserContract.Bookmarks.TAGS) + "CHANGED");
728 u.put(BrowserContract.Bookmarks.DESCRIPTION, b.getAsString(BrowserContract.Bookmarks.DESCRIPTION) + "CHANGED");
729 u.put(BrowserContract.Bookmarks.KEYWORD, b.getAsString(BrowserContract.Bookmarks.KEYWORD) + "CHANGED");
730 u.put(BrowserContract.Bookmarks.TYPE, BrowserContract.Bookmarks.TYPE_FOLDER);
731 u.put(BrowserContract.Bookmarks.POSITION, 10);
732
733 int updated = mProvider.update(BrowserContract.Bookmarks.CONTENT_URI, u,
734 BrowserContract.Bookmarks._ID + " = ?",
735 new String[] { String.valueOf(id) });
736
737 mAsserter.is((updated == 1), true, "Inserted bookmark was updated");
738 c.close();
739
740 c = getBookmarkById(id);
741 mAsserter.is(c.moveToFirst(), true, "Updated bookmark found");
742
743 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.TITLE)), u.getAsString(BrowserContract.Bookmarks.TITLE),
744 "Inserted bookmark has correct title");
745 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.URL)), u.getAsString(BrowserContract.Bookmarks.URL),
746 "Inserted bookmark has correct URL");
747 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.TAGS)), u.getAsString(BrowserContract.Bookmarks.TAGS),
748 "Inserted bookmark has correct tags");
749 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.KEYWORD)), u.getAsString(BrowserContract.Bookmarks.KEYWORD),
750 "Inserted bookmark has correct keyword");
751 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.DESCRIPTION)), u.getAsString(BrowserContract.Bookmarks.DESCRIPTION),
752 "Inserted bookmark has correct description");
753 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.POSITION)), u.getAsString(BrowserContract.Bookmarks.POSITION),
754 "Inserted bookmark has correct position");
755 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.TYPE)), u.getAsString(BrowserContract.Bookmarks.TYPE),
756 "Inserted bookmark has correct type");
757
758 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Bookmarks.DATE_CREATED))),
759 new Long(dateCreated),
760 "Updated bookmark has same creation date");
761
762 mAsserter.isnot(new Long(c.getLong(c.getColumnIndex(BrowserContract.Bookmarks.DATE_MODIFIED))),
763 new Long(dateModified),
764 "Updated bookmark has new modification date");
765
766 updated = updateWithNullCol(id, BrowserContract.Bookmarks.POSITION);
767 mAsserter.is((updated > 0), false,
768 "Should not be able to update bookmark with null position");
769
770 updated = updateWithNullCol(id, BrowserContract.Bookmarks.TYPE);
771 mAsserter.is((updated > 0), false,
772 "Should not be able to update bookmark with null type");
773
774 u = new ContentValues();
775 u.put(BrowserContract.Bookmarks.URL, "http://examples2.com");
776
777 updated = mProvider.update(ContentUris.withAppendedId(BrowserContract.Bookmarks.CONTENT_URI, id), u, null, null);
778 c.close();
779
780 c = getBookmarkById(id);
781 mAsserter.is(c.moveToFirst(), true, "Updated bookmark found");
782
783 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Bookmarks.URL)), u.getAsString(BrowserContract.Bookmarks.URL),
784 "Updated bookmark has correct URL using URI with id");
785 c.close();
786 }
787 }
788
789 private class TestUpdateBookmarksFavicons extends TestCase {
790 @Override
791 public void test() throws Exception {
792 ContentValues b = createOneBookmark();
793
794 final String favicon = "FAVICON";
795 final String newFavicon = "NEW_FAVICON";
796 final String pageUrl = b.getAsString(BrowserContract.Bookmarks.URL);
797
798 mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, b);
799
800 // Insert the favicon into the favicons table
801 ContentValues f = createFaviconEntry(pageUrl, favicon);
802 long faviconId = ContentUris.parseId(mProvider.insert(BrowserContract.Favicons.CONTENT_URI, f));
803
804 Cursor c = getFaviconsByUrl(pageUrl);
805 mAsserter.is(c.moveToFirst(), true, "Inserted favicon found");
806
807 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Combined.FAVICON)), "UTF8"),
808 favicon, "Inserted favicon has corresponding favicon image");
809
810 ContentValues u = createFaviconEntry(pageUrl, newFavicon);
811 mProvider.update(BrowserContract.Favicons.CONTENT_URI, u, null, null);
812 c.close();
813
814 c = getFaviconsByUrl(pageUrl);
815 mAsserter.is(c.moveToFirst(), true, "Updated favicon found");
816
817 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Combined.FAVICON)), "UTF8"),
818 newFavicon, "Updated favicon has corresponding favicon image");
819 c.close();
820 }
821 }
822
823 /**
824 * Create a folder of one thousand and one bookmarks, then impose an order
825 * on them.
826 *
827 * Verify that the reordering worked by querying.
828 */
829 private class TestPositionBookmarks extends TestCase {
830
831 public String makeGUID(final long in) {
832 String part = String.valueOf(in);
833 return "aaaaaaaaaaaa".substring(0, (12 - part.length())) + part;
834 }
835
836 public void compareCursorToItems(final Cursor c, final String[] items, final int count) {
837 mAsserter.is(c.moveToFirst(), true, "Folder has children.");
838
839 int posColumn = c.getColumnIndex(BrowserContract.Bookmarks.POSITION);
840 int guidColumn = c.getColumnIndex(BrowserContract.Bookmarks.GUID);
841 int i = 0;
842
843 while (!c.isAfterLast()) {
844 String guid = c.getString(guidColumn);
845 long pos = c.getLong(posColumn);
846 if ((pos != i) || (guid == null) || (!guid.equals(items[i]))) {
847 mAsserter.is(pos, (long) i, "Position matches sequence.");
848 mAsserter.is(guid, items[i], "GUID matches sequence.");
849 }
850 ++i;
851 c.moveToNext();
852 }
853
854 mAsserter.is(i, count, "Folder has the right number of children.");
855 c.close();
856 }
857
858 public static final int NUMBER_OF_CHILDREN = 1001;
859 @Override
860 public void test() throws Exception {
861 // Create the containing folder.
862 ContentValues folder = createBookmark("FolderFolder", "", mMobileFolderId,
863 BrowserContract.Bookmarks.TYPE_FOLDER, 0, "",
864 "description", "keyword");
865 folder.put(BrowserContract.Bookmarks.GUID, "folderfolder");
866 long folderId = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, folder));
867
868 mAsserter.dumpLog("TestPositionBookmarks: Folder inserted"); // Bug 968951 debug.
869
870 // Create the children.
871 String[] items = new String[NUMBER_OF_CHILDREN];
872
873 // Reuse the same ContentValues.
874 ContentValues item = createBookmark("Test Bookmark", "http://example.com", folderId,
875 BrowserContract.Bookmarks.TYPE_FOLDER, 0, "",
876 "description", "keyword");
877
878 for (int i = 0; i < NUMBER_OF_CHILDREN; ++i) {
879 String guid = makeGUID(i);
880 items[i] = guid;
881 item.put(BrowserContract.Bookmarks.GUID, guid);
882 item.put(BrowserContract.Bookmarks.POSITION, i);
883 item.put(BrowserContract.Bookmarks.URL, "http://example.com/" + guid);
884 item.put(BrowserContract.Bookmarks.TITLE, "Test Bookmark " + guid);
885 mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, item);
886 }
887
888 mAsserter.dumpLog("TestPositionBookmarks: Bookmarks inserted"); // Bug 968951 debug.
889
890 Cursor c;
891
892 // Verify insertion.
893 c = getBookmarksByParent(folderId);
894 mAsserter.dumpLog("TestPositionBookmarks: Got bookmarks by parent"); // Bug 968951 debug.
895 compareCursorToItems(c, items, NUMBER_OF_CHILDREN);
896 c.close();
897
898 // Now permute the items array.
899 Random rand = new Random();
900 for (int i = 0; i < NUMBER_OF_CHILDREN; ++i) {
901 final int newPosition = rand.nextInt(NUMBER_OF_CHILDREN);
902 final String switched = items[newPosition];
903 items[newPosition] = items[i];
904 items[i] = switched;
905 }
906
907 // Impose the positions.
908 long updated = mProvider.update(BrowserContract.Bookmarks.POSITIONS_CONTENT_URI, null, null, items);
909 mAsserter.is(updated, (long) NUMBER_OF_CHILDREN, "Updated " + NUMBER_OF_CHILDREN + " positions.");
910
911 // Verify that the database was updated.
912 c = getBookmarksByParent(folderId);
913 compareCursorToItems(c, items, NUMBER_OF_CHILDREN);
914 c.close();
915 }
916 }
917
918 private class TestInsertHistory extends TestCase {
919 private long insertWithNullCol(String colName) throws Exception {
920 ContentValues h = createOneHistoryEntry();
921 h.putNull(colName);
922 long id = -1;
923
924 try {
925 id = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, h));
926 } catch (Exception e) {}
927
928 return id;
929 }
930
931 @Override
932 public void test() throws Exception {
933 ContentValues h = createOneHistoryEntry();
934 long id = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, h));
935 Cursor c = getHistoryEntryById(id);
936
937 mAsserter.is(c.moveToFirst(), true, "Inserted history entry found");
938
939 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.TITLE)), h.getAsString(BrowserContract.History.TITLE),
940 "Inserted history entry has correct title");
941 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.URL)), h.getAsString(BrowserContract.History.URL),
942 "Inserted history entry has correct URL");
943 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.VISITS)), h.getAsString(BrowserContract.History.VISITS),
944 "Inserted history entry has correct number of visits");
945 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.DATE_LAST_VISITED)), h.getAsString(BrowserContract.History.DATE_LAST_VISITED),
946 "Inserted history entry has correct last visited date");
947 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.IS_DELETED)), String.valueOf(0),
948 "Inserted history entry has correct is-deleted state");
949
950 id = insertWithNullCol(BrowserContract.History.URL);
951 mAsserter.is(new Long(id), new Long(-1),
952 "Should not be able to insert history with null URL");
953
954 id = insertWithNullCol(BrowserContract.History.VISITS);
955 mAsserter.is(new Long(id), new Long(-1),
956 "Should not be able to insert history with null number of visits");
957 c.close();
958 }
959 }
960
961 private class TestInsertHistoryFavicons extends TestCase {
962 @Override
963 public void test() throws Exception {
964 ContentValues h = createOneHistoryEntry();
965
966 final String favicon = "FAVICON";
967 final String pageUrl = h.getAsString(BrowserContract.History.URL);
968
969 long id = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, h));
970
971 // Insert the favicon into the favicons table
972 mProvider.insert(BrowserContract.Favicons.CONTENT_URI, createFaviconEntry(pageUrl, favicon));
973
974 Cursor c = getHistoryEntryById(id, new String[] { BrowserContract.History.FAVICON });
975
976 mAsserter.is(c.moveToFirst(), true, "Inserted history entry found");
977
978 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.History.FAVICON)), "UTF8"),
979 favicon, "Inserted history entry has corresponding favicon image");
980 c.close();
981
982 c = getFaviconsByUrl(pageUrl);
983 mAsserter.is(c.moveToFirst(), true, "Inserted favicon found");
984
985 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Combined.FAVICON)), "UTF8"),
986 favicon, "Inserted favicon has corresponding favicon image");
987 c.close();
988 }
989 }
990
991 private class TestDeleteHistory extends TestCase {
992 private long insertOneHistoryEntry() throws Exception {
993 ContentValues h = createOneHistoryEntry();
994 long id = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, h));
995
996 Cursor c = getHistoryEntryById(id);
997 mAsserter.is(c.moveToFirst(), true, "Inserted history entry found");
998 c.close();
999
1000 return id;
1001 }
1002
1003 @Override
1004 public void test() throws Exception {
1005 long id = insertOneHistoryEntry();
1006
1007 int deleted = mProvider.delete(BrowserContract.History.CONTENT_URI,
1008 BrowserContract.History._ID + " = ?",
1009 new String[] { String.valueOf(id) });
1010
1011 mAsserter.is((deleted == 1), true, "Inserted history entry was deleted");
1012
1013 Cursor c = getHistoryEntryById(appendUriParam(BrowserContract.History.CONTENT_URI, BrowserContract.PARAM_SHOW_DELETED, "1"), id);
1014 mAsserter.is(c.moveToFirst(), true, "Deleted history entry was only marked as deleted");
1015
1016 deleted = mProvider.delete(appendUriParam(BrowserContract.History.CONTENT_URI, BrowserContract.PARAM_IS_SYNC, "1"),
1017 BrowserContract.History._ID + " = ?",
1018 new String[] { String.valueOf(id) });
1019
1020 mAsserter.is((deleted == 1), true, "Inserted history entry was deleted");
1021 c.close();
1022
1023 c = getHistoryEntryById(appendUriParam(BrowserContract.History.CONTENT_URI, BrowserContract.PARAM_SHOW_DELETED, "1"), id);
1024 mAsserter.is(c.moveToFirst(), false, "Inserted history is now actually deleted");
1025
1026 id = insertOneHistoryEntry();
1027
1028 deleted = mProvider.delete(ContentUris.withAppendedId(BrowserContract.History.CONTENT_URI, id), null, null);
1029 mAsserter.is((deleted == 1), true,
1030 "Inserted history entry was deleted using URI with id");
1031 c.close();
1032
1033 c = getHistoryEntryById(id);
1034 mAsserter.is(c.moveToFirst(), false,
1035 "Inserted history entry can't be found after deletion using URI with ID");
1036 c.close();
1037 }
1038 }
1039
1040 private class TestDeleteHistoryFavicons extends TestCase {
1041 @Override
1042 public void test() throws Exception {
1043 ContentValues h = createOneHistoryEntry();
1044
1045 long id = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, h));
1046 final String pageUrl = h.getAsString(BrowserContract.History.URL);
1047
1048 // Insert the favicon into the favicons table
1049 mProvider.insert(BrowserContract.Favicons.CONTENT_URI, createFaviconEntry(pageUrl, "FAVICON"));
1050
1051 Cursor c = getFaviconsByUrl(pageUrl);
1052 mAsserter.is(c.moveToFirst(), true, "Inserted favicon found");
1053
1054 mProvider.delete(ContentUris.withAppendedId(BrowserContract.History.CONTENT_URI, id), null, null);
1055 c.close();
1056
1057 c = getFaviconsByUrl(pageUrl);
1058 mAsserter.is(c.moveToFirst(), false, "Favicon is deleted with last reference to it");
1059 c.close();
1060 }
1061 }
1062
1063 private class TestUpdateHistory extends TestCase {
1064 private int updateWithNullCol(long id, String colName) throws Exception {
1065 ContentValues u = new ContentValues();
1066 u.putNull(colName);
1067
1068 int updated = 0;
1069
1070 try {
1071 updated = mProvider.update(BrowserContract.History.CONTENT_URI, u,
1072 BrowserContract.History._ID + " = ?",
1073 new String[] { String.valueOf(id) });
1074 } catch (Exception e) {}
1075
1076 return updated;
1077 }
1078
1079 @Override
1080 public void test() throws Exception {
1081 ContentValues h = createOneHistoryEntry();
1082 long id = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, h));
1083
1084 Cursor c = getHistoryEntryById(id);
1085 mAsserter.is(c.moveToFirst(), true, "Inserted history entry found");
1086
1087 long dateCreated = c.getLong(c.getColumnIndex(BrowserContract.History.DATE_CREATED));
1088 long dateModified = c.getLong(c.getColumnIndex(BrowserContract.History.DATE_MODIFIED));
1089
1090 ContentValues u = new ContentValues();
1091 u.put(BrowserContract.History.VISITS, h.getAsInteger(BrowserContract.History.VISITS) + 1);
1092 u.put(BrowserContract.History.DATE_LAST_VISITED, System.currentTimeMillis());
1093 u.put(BrowserContract.History.TITLE, h.getAsString(BrowserContract.History.TITLE) + "CHANGED");
1094 u.put(BrowserContract.History.URL, h.getAsString(BrowserContract.History.URL) + "/more/stuff");
1095
1096 int updated = mProvider.update(BrowserContract.History.CONTENT_URI, u,
1097 BrowserContract.History._ID + " = ?",
1098 new String[] { String.valueOf(id) });
1099
1100 mAsserter.is((updated == 1), true, "Inserted history entry was updated");
1101 c.close();
1102
1103 c = getHistoryEntryById(id);
1104 mAsserter.is(c.moveToFirst(), true, "Updated history entry found");
1105
1106 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.TITLE)), u.getAsString(BrowserContract.History.TITLE),
1107 "Updated history entry has correct title");
1108 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.URL)), u.getAsString(BrowserContract.History.URL),
1109 "Updated history entry has correct URL");
1110 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.VISITS)), u.getAsString(BrowserContract.History.VISITS),
1111 "Updated history entry has correct number of visits");
1112 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.DATE_LAST_VISITED)), u.getAsString(BrowserContract.History.DATE_LAST_VISITED),
1113 "Updated history entry has correct last visited date");
1114
1115 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.DATE_CREATED))),
1116 new Long(dateCreated),
1117 "Updated history entry has same creation date");
1118
1119 mAsserter.isnot(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.DATE_MODIFIED))),
1120 new Long(dateModified),
1121 "Updated history entry has new modification date");
1122
1123 updated = updateWithNullCol(id, BrowserContract.History.URL);
1124 mAsserter.is((updated > 0), false,
1125 "Should not be able to update history with null URL");
1126
1127 updated = updateWithNullCol(id, BrowserContract.History.VISITS);
1128 mAsserter.is((updated > 0), false,
1129 "Should not be able to update history with null number of visits");
1130
1131 u = new ContentValues();
1132 u.put(BrowserContract.History.URL, "http://examples2.com");
1133
1134 updated = mProvider.update(ContentUris.withAppendedId(BrowserContract.History.CONTENT_URI, id), u, null, null);
1135 c.close();
1136
1137 c = getHistoryEntryById(id);
1138 mAsserter.is(c.moveToFirst(), true, "Updated history entry found");
1139
1140 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.URL)), u.getAsString(BrowserContract.History.URL),
1141 "Updated history entry has correct URL using URI with id");
1142 c.close();
1143 }
1144 }
1145
1146 private class TestUpdateHistoryFavicons extends TestCase {
1147 @Override
1148 public void test() throws Exception {
1149 ContentValues h = createOneHistoryEntry();
1150
1151 final String favicon = "FAVICON";
1152 final String newFavicon = "NEW_FAVICON";
1153 final String pageUrl = h.getAsString(BrowserContract.History.URL);
1154
1155 mProvider.insert(BrowserContract.History.CONTENT_URI, h);
1156
1157 // Insert the favicon into the favicons table
1158 mProvider.insert(BrowserContract.Favicons.CONTENT_URI, createFaviconEntry(pageUrl, favicon));
1159
1160 Cursor c = getFaviconsByUrl(pageUrl);
1161 mAsserter.is(c.moveToFirst(), true, "Inserted favicon found");
1162
1163 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Combined.FAVICON)), "UTF8"),
1164 favicon, "Inserted favicon has corresponding favicon image");
1165
1166 ContentValues u = createFaviconEntry(pageUrl, newFavicon);
1167
1168 mProvider.update(BrowserContract.Favicons.CONTENT_URI, u, null, null);
1169 c.close();
1170
1171 c = getFaviconsByUrl(pageUrl);
1172 mAsserter.is(c.moveToFirst(), true, "Updated favicon found");
1173
1174 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Combined.FAVICON)), "UTF8"),
1175 newFavicon, "Updated favicon has corresponding favicon image");
1176 c.close();
1177 }
1178 }
1179
1180 private class TestUpdateOrInsertHistory extends TestCase {
1181 private final String TEST_URL_1 = "http://example.com";
1182 private final String TEST_URL_2 = "http://example.org";
1183 private final String TEST_TITLE = "Example";
1184
1185 private long getHistoryEntryIdByUrl(String url) {
1186 Cursor c = mProvider.query(BrowserContract.History.CONTENT_URI,
1187 new String[] { BrowserContract.History._ID },
1188 BrowserContract.History.URL + " = ?",
1189 new String[] { url },
1190 null);
1191 c.moveToFirst();
1192 long id = c.getLong(0);
1193 c.close();
1194
1195 return id;
1196 }
1197
1198 @Override
1199 public void test() throws Exception {
1200 Uri updateHistoryUri = BrowserContract.History.CONTENT_URI.buildUpon().
1201 appendQueryParameter("increment_visits", "true").build();
1202 Uri updateOrInsertHistoryUri = BrowserContract.History.CONTENT_URI.buildUpon().
1203 appendQueryParameter("insert_if_needed", "true").
1204 appendQueryParameter("increment_visits", "true").build();
1205
1206 // Update a non-existent history entry, without specifying visits or title
1207 ContentValues values = new ContentValues();
1208 values.put(BrowserContract.History.URL, TEST_URL_1);
1209
1210 int updated = mProvider.update(updateHistoryUri, values,
1211 BrowserContract.History.URL + " = ?",
1212 new String[] { TEST_URL_1 });
1213 mAsserter.is((updated == 0), true, "History entry was not updated");
1214 Cursor c = mProvider.query(BrowserContract.History.CONTENT_URI, null, null, null, null);
1215 mAsserter.is(c.moveToFirst(), false, "History entry was not inserted");
1216 c.close();
1217
1218 // Now let's try with update-or-insert.
1219 updated = mProvider.update(updateOrInsertHistoryUri, values,
1220 BrowserContract.History.URL + " = ?",
1221 new String[] { TEST_URL_1 });
1222 mAsserter.is((updated == 1), true, "History entry was inserted");
1223
1224 long id = getHistoryEntryIdByUrl(TEST_URL_1);
1225 c = getHistoryEntryById(id);
1226 mAsserter.is(c.moveToFirst(), true, "History entry was inserted");
1227
1228 long dateCreated = c.getLong(c.getColumnIndex(BrowserContract.History.DATE_CREATED));
1229 long dateModified = c.getLong(c.getColumnIndex(BrowserContract.History.DATE_MODIFIED));
1230
1231 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.VISITS))), new Long(1),
1232 "Inserted history entry has correct default number of visits");
1233 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.TITLE)), TEST_URL_1,
1234 "Inserted history entry has correct default title");
1235
1236 // Update the history entry, without specifying an additional visit count
1237 values = new ContentValues();
1238 values.put(BrowserContract.History.DATE_LAST_VISITED, System.currentTimeMillis());
1239 values.put(BrowserContract.History.TITLE, TEST_TITLE);
1240
1241 updated = mProvider.update(updateOrInsertHistoryUri, values,
1242 BrowserContract.History._ID + " = ?",
1243 new String[] { String.valueOf(id) });
1244 mAsserter.is((updated == 1), true, "Inserted history entry was updated");
1245 c.close();
1246
1247 c = getHistoryEntryById(id);
1248 mAsserter.is(c.moveToFirst(), true, "Updated history entry found");
1249
1250 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.TITLE)), TEST_TITLE,
1251 "Updated history entry has correct title");
1252 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.VISITS))), new Long(2),
1253 "Updated history entry has correct number of visits");
1254 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.DATE_CREATED))), new Long(dateCreated),
1255 "Updated history entry has same creation date");
1256 mAsserter.isnot(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.DATE_MODIFIED))), new Long(dateModified),
1257 "Updated history entry has new modification date");
1258
1259 // Create a new history entry, specifying visits and history
1260 values = new ContentValues();
1261 values.put(BrowserContract.History.URL, TEST_URL_2);
1262 values.put(BrowserContract.History.TITLE, TEST_TITLE);
1263 values.put(BrowserContract.History.VISITS, 10);
1264
1265 updated = mProvider.update(updateOrInsertHistoryUri, values,
1266 BrowserContract.History.URL + " = ?",
1267 new String[] { values.getAsString(BrowserContract.History.URL) });
1268 mAsserter.is((updated == 1), true, "History entry was inserted");
1269
1270 id = getHistoryEntryIdByUrl(TEST_URL_2);
1271 c.close();
1272
1273 c = getHistoryEntryById(id);
1274 mAsserter.is(c.moveToFirst(), true, "History entry was inserted");
1275
1276 dateCreated = c.getLong(c.getColumnIndex(BrowserContract.History.DATE_CREATED));
1277 dateModified = c.getLong(c.getColumnIndex(BrowserContract.History.DATE_MODIFIED));
1278
1279 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.VISITS))), new Long(10),
1280 "Inserted history entry has correct specified number of visits");
1281 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.TITLE)), TEST_TITLE,
1282 "Inserted history entry has correct specified title");
1283
1284 // Update the history entry, specifying additional visit count
1285 values = new ContentValues();
1286 values.put(BrowserContract.History.VISITS, 10);
1287
1288 updated = mProvider.update(updateOrInsertHistoryUri, values,
1289 BrowserContract.History._ID + " = ?",
1290 new String[] { String.valueOf(id) });
1291 mAsserter.is((updated == 1), true, "Inserted history entry was updated");
1292 c.close();
1293
1294 c = getHistoryEntryById(id);
1295 mAsserter.is(c.moveToFirst(), true, "Updated history entry found");
1296
1297 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.TITLE)), TEST_TITLE,
1298 "Updated history entry has correct unchanged title");
1299 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.History.URL)), TEST_URL_2,
1300 "Updated history entry has correct unchanged URL");
1301 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.VISITS))), new Long(20),
1302 "Updated history entry has correct number of visits");
1303 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.DATE_CREATED))), new Long(dateCreated),
1304 "Updated history entry has same creation date");
1305 mAsserter.isnot(new Long(c.getLong(c.getColumnIndex(BrowserContract.History.DATE_MODIFIED))), new Long(dateModified),
1306 "Updated history entry has new modification date");
1307 c.close();
1308
1309 }
1310 }
1311
1312 private class TestInsertHistoryThumbnails extends TestCase {
1313 @Override
1314 public void test() throws Exception {
1315 ContentValues h = createOneHistoryEntry();
1316
1317 final String thumbnail = "THUMBNAIL";
1318 final String pageUrl = h.getAsString(BrowserContract.History.URL);
1319
1320 long id = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, h));
1321
1322 // Insert the thumbnail into the thumbnails table
1323 mProvider.insert(BrowserContract.Thumbnails.CONTENT_URI, createThumbnailEntry(pageUrl, thumbnail));
1324
1325 Cursor c = getThumbnailByUrl(pageUrl);
1326 mAsserter.is(c.moveToFirst(), true, "Inserted thumbnail found");
1327
1328 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Thumbnails.DATA)), "UTF8"),
1329 thumbnail, "Inserted thumbnail has corresponding thumbnail image");
1330 c.close();
1331 }
1332 }
1333
1334 private class TestUpdateHistoryThumbnails extends TestCase {
1335 @Override
1336 public void test() throws Exception {
1337 ContentValues h = createOneHistoryEntry();
1338
1339 final String thumbnail = "THUMBNAIL";
1340 final String newThumbnail = "NEW_THUMBNAIL";
1341 final String pageUrl = h.getAsString(BrowserContract.History.URL);
1342
1343 mProvider.insert(BrowserContract.History.CONTENT_URI, h);
1344
1345 // Insert the thumbnail into the thumbnails table
1346 mProvider.insert(BrowserContract.Thumbnails.CONTENT_URI, createThumbnailEntry(pageUrl, thumbnail));
1347
1348 Cursor c = getThumbnailByUrl(pageUrl);
1349 mAsserter.is(c.moveToFirst(), true, "Inserted thumbnail found");
1350
1351 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Thumbnails.DATA)), "UTF8"),
1352 thumbnail, "Inserted thumbnail has corresponding thumbnail image");
1353
1354 ContentValues u = createThumbnailEntry(pageUrl, newThumbnail);
1355
1356 mProvider.update(BrowserContract.Thumbnails.CONTENT_URI, u, null, null);
1357 c.close();
1358
1359 c = getThumbnailByUrl(pageUrl);
1360 mAsserter.is(c.moveToFirst(), true, "Updated thumbnail found");
1361
1362 mAsserter.is(new String(c.getBlob(c.getColumnIndex(BrowserContract.Thumbnails.DATA)), "UTF8"),
1363 newThumbnail, "Updated thumbnail has corresponding thumbnail image");
1364 c.close();
1365 }
1366 }
1367
1368 private class TestDeleteHistoryThumbnails extends TestCase {
1369 @Override
1370 public void test() throws Exception {
1371 ContentValues h = createOneHistoryEntry();
1372
1373 long id = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, h));
1374 final String pageUrl = h.getAsString(BrowserContract.History.URL);
1375
1376 // Insert the thumbnail into the thumbnails table
1377 mProvider.insert(BrowserContract.Thumbnails.CONTENT_URI, createThumbnailEntry(pageUrl, "THUMBNAIL"));
1378
1379 Cursor c = getThumbnailByUrl(pageUrl);
1380 mAsserter.is(c.moveToFirst(), true, "Inserted thumbnail found");
1381
1382 mProvider.delete(ContentUris.withAppendedId(BrowserContract.History.CONTENT_URI, id), null, null);
1383 c.close();
1384
1385 c = getThumbnailByUrl(pageUrl);
1386 mAsserter.is(c.moveToFirst(), false, "Thumbnail is deleted with last reference to it");
1387 c.close();
1388 }
1389 }
1390
1391 private class TestCombinedView extends TestCase {
1392 @Override
1393 public void test() throws Exception {
1394 final String TITLE_1 = "Test Page 1";
1395 final String TITLE_2 = "Test Page 2";
1396 final String TITLE_3_HISTORY = "Test Page 3 (History Entry)";
1397 final String TITLE_3_BOOKMARK = "Test Page 3 (Bookmark Entry)";
1398 final String TITLE_3_BOOKMARK2 = "Test Page 3 (Bookmark Entry 2)";
1399
1400 final String URL_1 = "http://example1.com";
1401 final String URL_2 = "http://example2.com";
1402 final String URL_3 = "http://example3.com";
1403
1404 final int VISITS = 10;
1405 final long LAST_VISITED = System.currentTimeMillis();
1406
1407 // Create a basic history entry
1408 ContentValues basicHistory = createHistoryEntry(TITLE_1, URL_1, VISITS, LAST_VISITED);
1409 long basicHistoryId = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, basicHistory));
1410
1411 // Create a basic bookmark entry
1412 ContentValues basicBookmark = createBookmark(TITLE_2, URL_2, mMobileFolderId,
1413 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
1414 long basicBookmarkId = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, basicBookmark));
1415
1416 // Create a history entry and bookmark entry with the same URL to
1417 // represent a visited bookmark
1418 ContentValues combinedHistory = createHistoryEntry(TITLE_3_HISTORY, URL_3, VISITS, LAST_VISITED);
1419 long combinedHistoryId = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, combinedHistory));
1420
1421
1422 ContentValues combinedBookmark = createBookmark(TITLE_3_BOOKMARK, URL_3, mMobileFolderId,
1423 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
1424 long combinedBookmarkId = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, combinedBookmark));
1425
1426 ContentValues combinedBookmark2 = createBookmark(TITLE_3_BOOKMARK2, URL_3, mMobileFolderId,
1427 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
1428 long combinedBookmarkId2 = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, combinedBookmark2));
1429
1430 // Create a bookmark folder to make sure it _doesn't_ show up in the results
1431 ContentValues folderBookmark = createBookmark("", "", mMobileFolderId,
1432 BrowserContract.Bookmarks.TYPE_FOLDER, 0, "tags", "description", "keyword");
1433 mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, folderBookmark);
1434
1435 // Sort entries by url so we can check them individually
1436 Cursor c = mProvider.query(BrowserContract.Combined.CONTENT_URI, null, "", null, BrowserContract.Combined.URL);
1437
1438 mAsserter.is(c.getCount(), 3, "3 combined entries found");
1439
1440 // First combined entry is basic history entry
1441 mAsserter.is(c.moveToFirst(), true, "Found basic history entry");
1442 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined._ID))), new Long(0),
1443 "Combined _id column should always be 0");
1444 // TODO: Should we change BrowserProvider to make this return -1, not 0?
1445 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.BOOKMARK_ID))), new Long(0),
1446 "Bookmark id should be 0 for basic history entry");
1447 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.HISTORY_ID))), new Long(basicHistoryId),
1448 "Basic history entry has correct history id");
1449 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Combined.TITLE)), TITLE_1,
1450 "Basic history entry has correct title");
1451 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Combined.URL)), URL_1,
1452 "Basic history entry has correct url");
1453 mAsserter.is(c.getInt(c.getColumnIndex(BrowserContract.Combined.VISITS)), VISITS,
1454 "Basic history entry has correct number of visits");
1455 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.DATE_LAST_VISITED))), new Long(LAST_VISITED),
1456 "Basic history entry has correct last visit time");
1457
1458 // Second combined entry is basic bookmark entry
1459 mAsserter.is(c.moveToNext(), true, "Found basic bookmark entry");
1460 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined._ID))), new Long(0),
1461 "Combined _id column should always be 0");
1462 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.BOOKMARK_ID))), new Long(basicBookmarkId),
1463 "Basic bookmark entry has correct bookmark id");
1464 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.HISTORY_ID))), new Long(-1),
1465 "History id should be -1 for basic bookmark entry");
1466 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Combined.TITLE)), TITLE_2,
1467 "Basic bookmark entry has correct title");
1468 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Combined.URL)), URL_2,
1469 "Basic bookmark entry has correct url");
1470 mAsserter.is(c.getInt(c.getColumnIndex(BrowserContract.Combined.VISITS)), -1,
1471 "Visits should be -1 for basic bookmark entry");
1472 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.DATE_LAST_VISITED))), new Long(-1),
1473 "Basic entry has correct last visit time");
1474
1475 // Third combined entry is a combined history/bookmark entry
1476 mAsserter.is(c.moveToNext(), true, "Found third combined entry");
1477 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined._ID))), new Long(0),
1478 "Combined _id column should always be 0");
1479 // The bookmark data (bookmark_id and title) associated with the combined entry is non-deterministic,
1480 // it might end up with data coming from any of the matching bookmark entries.
1481 mAsserter.is(c.getLong(c.getColumnIndex(BrowserContract.Combined.BOOKMARK_ID)) == combinedBookmarkId ||
1482 c.getLong(c.getColumnIndex(BrowserContract.Combined.BOOKMARK_ID)) == combinedBookmarkId2, true,
1483 "Combined entry has correct bookmark id");
1484 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Combined.TITLE)).equals(TITLE_3_BOOKMARK) ||
1485 c.getString(c.getColumnIndex(BrowserContract.Combined.TITLE)).equals(TITLE_3_BOOKMARK2), true,
1486 "Combined entry has title corresponding to bookmark entry");
1487 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.HISTORY_ID))), new Long(combinedHistoryId),
1488 "Combined entry has correct history id");
1489 mAsserter.is(c.getString(c.getColumnIndex(BrowserContract.Combined.URL)), URL_3,
1490 "Combined entry has correct url");
1491 mAsserter.is(c.getInt(c.getColumnIndex(BrowserContract.Combined.VISITS)), VISITS,
1492 "Combined entry has correct number of visits");
1493 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.DATE_LAST_VISITED))), new Long(LAST_VISITED),
1494 "Combined entry has correct last visit time");
1495 c.close();
1496 }
1497 }
1498
1499 private class TestCombinedViewDisplay extends TestCase {
1500 @Override
1501 public void test() throws Exception {
1502 final String TITLE_1 = "Test Page 1";
1503 final String TITLE_2 = "Test Page 2";
1504 final String TITLE_3_HISTORY = "Test Page 3 (History Entry)";
1505 final String TITLE_3_BOOKMARK = "Test Page 3 (Bookmark Entry)";
1506 final String TITLE_4 = "Test Page 4";
1507
1508 final String URL_1 = "http://example.com";
1509 final String URL_2 = "http://example.org";
1510 final String URL_3 = "http://examples2.com";
1511 final String URL_4 = "http://readinglist.com";
1512
1513 final int VISITS = 10;
1514 final long LAST_VISITED = System.currentTimeMillis();
1515
1516 // Create a basic history entry
1517 ContentValues basicHistory = createHistoryEntry(TITLE_1, URL_1, VISITS, LAST_VISITED);
1518 ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, basicHistory));
1519
1520 // Create a basic bookmark entry
1521 ContentValues basicBookmark = createBookmark(TITLE_2, URL_2, mMobileFolderId,
1522 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
1523 mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, basicBookmark);
1524
1525 // Create a history entry and bookmark entry with the same URL to
1526 // represent a visited bookmark
1527 ContentValues combinedHistory = createHistoryEntry(TITLE_3_HISTORY, URL_3, VISITS, LAST_VISITED);
1528 mProvider.insert(BrowserContract.History.CONTENT_URI, combinedHistory);
1529
1530 ContentValues combinedBookmark = createBookmark(TITLE_3_BOOKMARK, URL_3, mMobileFolderId,
1531 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
1532 mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, combinedBookmark);
1533
1534 // Create a reading list entries
1535 int readingListId = BrowserContract.Bookmarks.FIXED_READING_LIST_ID;
1536 ContentValues readingListItem = createBookmark(TITLE_3_BOOKMARK, URL_3, readingListId,
1537 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
1538 long readingListItemId = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, readingListItem));
1539
1540 ContentValues readingListItem2 = createBookmark(TITLE_4, URL_4, readingListId,
1541 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
1542 long readingListItemId2 = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, readingListItem2));
1543
1544 Cursor c = mProvider.query(BrowserContract.Combined.CONTENT_URI, null, "", null, null);
1545 mAsserter.is(c.getCount(), 4, "4 combined entries found");
1546
1547 while (c.moveToNext()) {
1548 long id = c.getLong(c.getColumnIndex(BrowserContract.Combined.BOOKMARK_ID));
1549
1550 int display = c.getInt(c.getColumnIndex(BrowserContract.Combined.DISPLAY));
1551 int expectedDisplay = (id == readingListItemId || id == readingListItemId2 ? BrowserContract.Combined.DISPLAY_READER : BrowserContract.Combined.DISPLAY_NORMAL);
1552
1553 mAsserter.is(new Integer(display), new Integer(expectedDisplay),
1554 "Combined display column should always be DISPLAY_READER for the reading list item");
1555 }
1556 c.close();
1557 }
1558 }
1559
1560 private class TestCombinedViewWithDeletedBookmark extends TestCase {
1561 @Override
1562 public void test() throws Exception {
1563 final String TITLE = "Test Page 1";
1564 final String URL = "http://example.com";
1565 final int VISITS = 10;
1566 final long LAST_VISITED = System.currentTimeMillis();
1567
1568 // Create a combined history entry
1569 ContentValues combinedHistory = createHistoryEntry(TITLE, URL, VISITS, LAST_VISITED);
1570 mProvider.insert(BrowserContract.History.CONTENT_URI, combinedHistory);
1571
1572 // Create a combined bookmark entry
1573 ContentValues combinedBookmark = createBookmark(TITLE, URL, mMobileFolderId,
1574 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
1575 long combinedBookmarkId = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, combinedBookmark));
1576
1577 Cursor c = mProvider.query(BrowserContract.Combined.CONTENT_URI, null, "", null, null);
1578 mAsserter.is(c.getCount(), 1, "1 combined entry found");
1579
1580 mAsserter.is(c.moveToFirst(), true, "Found combined entry with bookmark id");
1581 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.BOOKMARK_ID))), new Long(combinedBookmarkId),
1582 "Bookmark id should be set correctly on combined entry");
1583
1584 int deleted = mProvider.delete(BrowserContract.Bookmarks.CONTENT_URI,
1585 BrowserContract.Bookmarks._ID + " = ?",
1586 new String[] { String.valueOf(combinedBookmarkId) });
1587
1588 mAsserter.is((deleted == 1), true, "Inserted combined bookmark was deleted");
1589 c.close();
1590
1591 c = mProvider.query(BrowserContract.Combined.CONTENT_URI, null, "", null, null);
1592 mAsserter.is(c.getCount(), 1, "1 combined entry found");
1593
1594 mAsserter.is(c.moveToFirst(), true, "Found combined entry without bookmark id");
1595 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.BOOKMARK_ID))), new Long(0),
1596 "Bookmark id should not be set to removed bookmark id");
1597 c.close();
1598 }
1599 }
1600
1601 private class TestCombinedViewWithDeletedReadingListItem extends TestCase {
1602 @Override
1603 public void test() throws Exception {
1604 final String TITLE = "Test Page 1";
1605 final String URL = "http://example.com";
1606 final int VISITS = 10;
1607 final long LAST_VISITED = System.currentTimeMillis();
1608
1609 // Create a combined history entry
1610 ContentValues combinedHistory = createHistoryEntry(TITLE, URL, VISITS, LAST_VISITED);
1611 mProvider.insert(BrowserContract.History.CONTENT_URI, combinedHistory);
1612
1613 // Create a combined bookmark entry
1614 int readingListId = BrowserContract.Bookmarks.FIXED_READING_LIST_ID;
1615 ContentValues combinedReadingListItem = createBookmark(TITLE, URL, readingListId,
1616 BrowserContract.Bookmarks.TYPE_BOOKMARK, 0, "tags", "description", "keyword");
1617 long combinedReadingListItemId = ContentUris.parseId(mProvider.insert(BrowserContract.Bookmarks.CONTENT_URI, combinedReadingListItem));
1618
1619 Cursor c = mProvider.query(BrowserContract.Combined.CONTENT_URI, null, "", null, null);
1620 mAsserter.is(c.getCount(), 1, "1 combined entry found");
1621
1622 mAsserter.is(c.moveToFirst(), true, "Found combined entry with bookmark id");
1623 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.BOOKMARK_ID))), new Long(combinedReadingListItemId),
1624 "Bookmark id should be set correctly on combined entry");
1625 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.DISPLAY))), new Long(BrowserContract.Combined.DISPLAY_READER),
1626 "Combined entry should have reader display type");
1627
1628 int deleted = mProvider.delete(BrowserContract.Bookmarks.CONTENT_URI,
1629 BrowserContract.Bookmarks._ID + " = ?",
1630 new String[] { String.valueOf(combinedReadingListItemId) });
1631
1632 mAsserter.is((deleted == 1), true, "Inserted combined reading list item was deleted");
1633 c.close();
1634
1635 c = mProvider.query(BrowserContract.Combined.CONTENT_URI, null, "", null, null);
1636 mAsserter.is(c.getCount(), 1, "1 combined entry found");
1637
1638 mAsserter.is(c.moveToFirst(), true, "Found combined entry without bookmark id");
1639 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.BOOKMARK_ID))), new Long(0),
1640 "Bookmark id should not be set to removed bookmark id");
1641 mAsserter.is(new Long(c.getLong(c.getColumnIndex(BrowserContract.Combined.DISPLAY))), new Long(BrowserContract.Combined.DISPLAY_NORMAL),
1642 "Combined entry should have reader display type");
1643 c.close();
1644 }
1645 }
1646
1647 private class TestExpireHistory extends TestCase {
1648 private void createFakeHistory(long timeShift, int count) {
1649 // Insert a bunch of very new entries
1650 ContentValues[] allVals = new ContentValues[count];
1651 long time = System.currentTimeMillis() - timeShift;
1652 for (int i = 0; i < count; i++) {
1653 allVals[i] = new ContentValues();
1654 allVals[i].put(BrowserContract.History.TITLE, "Test " + i);
1655 allVals[i].put(BrowserContract.History.URL, "http://www.test.org/" + i);
1656 allVals[i].put(BrowserContract.History.VISITS, i);
1657 allVals[i].put(BrowserContract.History.DATE_LAST_VISITED, time);
1658 }
1659
1660 int inserts = mProvider.bulkInsert(BrowserContract.History.CONTENT_URI, allVals);
1661 mAsserter.is(inserts, count, "Expected number of inserts matches");
1662
1663 // inserting a new entry sets the date created and modified automatically
1664 // reset all of them
1665 for (int i = 0; i < count; i++) {
1666 ContentValues cv = new ContentValues();
1667 cv.put(BrowserContract.History.DATE_CREATED, time);
1668 cv.put(BrowserContract.History.DATE_MODIFIED, time);
1669 mProvider.update(BrowserContract.History.CONTENT_URI, cv, BrowserContract.History.URL + " = ?",
1670 new String[] { "http://www.test.org/" + i });
1671 }
1672
1673 Cursor c = mProvider.query(BrowserContract.History.CONTENT_URI, null, "", null, null);
1674
1675 assertCountIsAndClose(c, count, count + " history entries found");
1676
1677 // add thumbnails for each entry
1678 allVals = new ContentValues[count];
1679 for (int i = 0; i < count; i++) {
1680 allVals[i] = new ContentValues();
1681 allVals[i].put(BrowserContract.Thumbnails.DATA, i);
1682 allVals[i].put(BrowserContract.Thumbnails.URL, "http://www.test.org/" + i);
1683 }
1684
1685 inserts = mProvider.bulkInsert(BrowserContract.Thumbnails.CONTENT_URI, allVals);
1686 mAsserter.is(inserts, count, "Expected number of inserts matches");
1687
1688 c = mProvider.query(BrowserContract.Thumbnails.CONTENT_URI, null, null, null, null);
1689 assertCountIsAndClose(c, count, count + " thumbnails entries found");
1690 }
1691
1692 @Override
1693 public void test() throws Exception {
1694 final int count = 3000;
1695 final int thumbCount = 15;
1696
1697 // insert a bunch of new entries
1698 createFakeHistory(0, count);
1699
1700 // expiring with a normal priority should not delete new entries
1701 Uri url = appendUriParam(BrowserContract.History.CONTENT_OLD_URI, BrowserContract.PARAM_EXPIRE_PRIORITY, "NORMAL");
1702 mProvider.delete(url, null, null);
1703 Cursor c = mProvider.query(BrowserContract.History.CONTENT_URI, null, "", null, null);
1704 assertCountIsAndClose(c, count, count + " history entries found");
1705
1706 // expiring with a normal priority should delete all but 10 thumbnails
1707 c = mProvider.query(BrowserContract.Thumbnails.CONTENT_URI, null, null, null, null);
1708 assertCountIsAndClose(c, thumbCount, thumbCount + " thumbnails found");
1709
1710 ensureEmptyDatabase();
1711
1712 // Insert a bunch of new entries.
1713 createFakeHistory(0, count);
1714
1715 // Expiring with a aggressive priority should leave 500 entries.
1716 url = appendUriParam(BrowserContract.History.CONTENT_OLD_URI, BrowserContract.PARAM_EXPIRE_PRIORITY, "AGGRESSIVE");
1717 mProvider.delete(url, null, null);
1718
1719 c = mProvider.query(BrowserContract.History.CONTENT_URI, null, "", null, null);
1720 assertCountIsAndClose(c, 500, "500 history entries found");
1721
1722 // Expiring with a aggressive priority should delete all but 10 thumbnails.
1723 c = mProvider.query(BrowserContract.Thumbnails.CONTENT_URI, null, null, null, null);
1724 assertCountIsAndClose(c, thumbCount, thumbCount + " thumbnails found");
1725
1726 ensureEmptyDatabase();
1727
1728 // Insert a bunch of entries with an old time created/modified.
1729 long time = 1000L * 60L * 60L * 24L * 30L * 3L;
1730 createFakeHistory(time, count);
1731
1732 // Expiring with an normal priority should remove at most 1000 entries,
1733 // entries leaving at least 2000.
1734 url = appendUriParam(BrowserContract.History.CONTENT_OLD_URI, BrowserContract.PARAM_EXPIRE_PRIORITY, "NORMAL");
1735 mProvider.delete(url, null, null);
1736
1737 c = mProvider.query(BrowserContract.History.CONTENT_URI, null, "", null, null);
1738 assertCountIsAndClose(c, 2000, "2000 history entries found");
1739
1740 // Expiring with a normal priority should delete all but 10 thumbnails.
1741 c = mProvider.query(BrowserContract.Thumbnails.CONTENT_URI, null, null, null, null);
1742 assertCountIsAndClose(c, thumbCount, thumbCount + " thumbnails found");
1743
1744 ensureEmptyDatabase();
1745 // insert a bunch of entries with an old time created/modified
1746 time = 1000L * 60L * 60L * 24L * 30L * 3L;
1747 createFakeHistory(time, count);
1748
1749 // Expiring with an aggressive priority should remove old
1750 // entries, leaving at least 500.
1751 url = appendUriParam(BrowserContract.History.CONTENT_OLD_URI, BrowserContract.PARAM_EXPIRE_PRIORITY, "AGGRESSIVE");
1752 mProvider.delete(url, null, null);
1753 c = mProvider.query(BrowserContract.History.CONTENT_URI, null, "", null, null);
1754 assertCountIsAndClose(c, 500, "500 history entries found");
1755
1756 // expiring with an aggressive priority should delete all but 10 thumbnails
1757 c = mProvider.query(BrowserContract.Thumbnails.CONTENT_URI, null, null, null, null);
1758 assertCountIsAndClose(c, thumbCount, thumbCount + " thumbnails found");
1759 }
1760 }
1761
1762 /*
1763 * Verify that insert, update, delete, and bulkInsert operations
1764 * notify the ambient content resolver. Each operation calls the
1765 * content resolver notifyChange method synchronously, so it is
1766 * okay to test sequentially.
1767 */
1768 private class TestBrowserProviderNotifications extends TestCase {
1769 public static final String LOGTAG = "TestBPNotifications";
1770
1771 protected void ensureOnlyChangeNotifiedStartsWith(Uri expectedUri, String operation) {
1772 if (expectedUri == null) {
1773 throw new IllegalArgumentException("expectedUri must not be null");
1774 }
1775
1776 if (mResolver.notifyChangeList.size() != 1) {
1777 // Log to help post-mortem debugging
1778 Log.w(LOGTAG, "after operation, notifyChangeList = " + mResolver.notifyChangeList);
1779 }
1780
1781 mAsserter.is(Long.valueOf(mResolver.notifyChangeList.size()),
1782 Long.valueOf(1),
1783 "Content observer was notified exactly once by " + operation);
1784
1785 Uri uri = mResolver.notifyChangeList.poll();
1786
1787 mAsserter.isnot(uri,
1788 null,
1789 "Notification from " + operation + " was valid");
1790
1791 mAsserter.ok(uri.toString().startsWith(expectedUri.toString()),
1792 "Content observer was notified exactly once by " + operation,
1793 uri.toString() + " starts with expected prefix " + expectedUri);
1794 }
1795
1796 @Override
1797 public void test() throws Exception {
1798 // Insert
1799 final ContentValues h = createOneHistoryEntry();
1800
1801 mResolver.notifyChangeList.clear();
1802 long id = ContentUris.parseId(mProvider.insert(BrowserContract.History.CONTENT_URI, h));
1803
1804 mAsserter.isnot(Long.valueOf(id),
1805 Long.valueOf(-1),
1806 "Inserted item has valid id");
1807
1808 ensureOnlyChangeNotifiedStartsWith(BrowserContract.History.CONTENT_URI, "insert");
1809
1810 // Update
1811 mResolver.notifyChangeList.clear();
1812 h.put(BrowserContract.History.TITLE, "http://newexample.com");
1813
1814 long numUpdated = mProvider.update(BrowserContract.History.CONTENT_URI, h,
1815 BrowserContract.History._ID + " = ?",
1816 new String[] { String.valueOf(id) });
1817
1818 mAsserter.is(Long.valueOf(numUpdated),
1819 Long.valueOf(1),
1820 "Correct number of items are updated");
1821
1822 ensureOnlyChangeNotifiedStartsWith(BrowserContract.History.CONTENT_URI, "update");
1823
1824 // Delete
1825 mResolver.notifyChangeList.clear();
1826 long numDeleted = mProvider.delete(BrowserContract.History.CONTENT_URI, null, null);
1827
1828 mAsserter.is(Long.valueOf(numDeleted),
1829 Long.valueOf(1),
1830 "Correct number of items are deleted");
1831
1832 ensureOnlyChangeNotifiedStartsWith(BrowserContract.History.CONTENT_URI, "delete");
1833
1834 // Bulk insert
1835 final ContentValues[] hs = new ContentValues[] { createOneHistoryEntry() };
1836
1837 mResolver.notifyChangeList.clear();
1838 long numBulkInserted = mProvider.bulkInsert(BrowserContract.History.CONTENT_URI, hs);
1839
1840 mAsserter.is(Long.valueOf(numBulkInserted),
1841 Long.valueOf(1),
1842 "Correct number of items are bulkInserted");
1843
1844 ensureOnlyChangeNotifiedStartsWith(BrowserContract.History.CONTENT_URI, "bulkInsert");
1845 }
1846 }
1847
1848 /**
1849 * Assert that the provided cursor has the expected number of rows,
1850 * closing the cursor afterwards.
1851 */
1852 private void assertCountIsAndClose(Cursor c, int expectedCount, String message) {
1853 try {
1854 mAsserter.is(c.getCount(), expectedCount, message);
1855 } finally {
1856 c.close();
1857 }
1858 }
1859 }

Mercurial Repository: The Tor Browser

Europalab SCM Repository Server

mercurial