chrome/android/javatests/src/org/chromium/chrome/browser/test/ProviderBookmarksUriTest.java

// Copyright 2012 The Chromium Authors. All rights reserved.
// Use of this source code is governed by a BSD-style license that can be
// found in the LICENSE file.

package org.chromium.chrome.browser.test;

import android.content.ContentValues;
import android.database.Cursor;
import android.net.Uri;
import android.provider.Browser.BookmarkColumns;

import org.chromium.base.test.util.DisabledTest;
import org.chromium.chrome.browser.ChromeBrowserProvider;
import org.chromium.chrome.browser.test.util.BookmarkUtils;

import java.util.Date;

/**
 * Tests the use of the Bookmark URI as part of the Android provider public API.
 */
public class ProviderBookmarksUriTest extends ProviderTestBase {
    private static final String TAG = "ProviderBookmarkUriTest";
    private static final String ICON_PATH = "chrome/provider/icon1.png";

    private Uri mBookmarksUri;

    @Override
    protected void setUp() throws Exception {
        super.setUp();
        mBookmarksUri = ChromeBrowserProvider.getBookmarksApiUri(getActivity());
        getContentResolver().delete(mBookmarksUri, null, null);
    }

    @Override
    protected void tearDown() throws Exception {
        getContentResolver().delete(mBookmarksUri, null, null);
        super.tearDown();
    }

    private Uri addBookmark(String url, String title, long lastVisitTime, long created, int visits,
            byte[] icon, int isBookmark) {
        ContentValues values = new ContentValues();
        values.put(BookmarkColumns.BOOKMARK, isBookmark);
        values.put(BookmarkColumns.DATE, lastVisitTime);
        values.put(BookmarkColumns.CREATED, created);
        values.put(BookmarkColumns.FAVICON, icon);
        values.put(BookmarkColumns.URL, url);
        values.put(BookmarkColumns.VISITS, visits);
        values.put(BookmarkColumns.TITLE, title);
        return getContentResolver().insert(mBookmarksUri, values);
    }

    /**
     * @MediumTest
     * @Feature({"Android-ContentProvider"})
     * BUG 154683
     */
    @DisabledTest
    public void testAddBookmark() {
        final long lastUpdateTime = System.currentTimeMillis();
        final long createdTime = lastUpdateTime - 1000 * 60 * 60;
        final String url = "http://www.google.com/";
        final int visits = 2;
        final String title = "Google";
        ContentValues values = new ContentValues();
        values.put(BookmarkColumns.BOOKMARK, 0);
        values.put(BookmarkColumns.DATE, lastUpdateTime);
        values.put(BookmarkColumns.CREATED, createdTime);
        values.put(BookmarkColumns.FAVICON, BookmarkUtils.getIcon(ICON_PATH));
        values.put(BookmarkColumns.URL, url);
        values.put(BookmarkColumns.VISITS, visits);
        values.put(BookmarkColumns.TITLE, title);
        Uri uri = getContentResolver().insert(mBookmarksUri, values);
        Cursor cursor = getContentResolver().query(uri, null, null, null, null);
        assertEquals(1, cursor.getCount());
        assertTrue(cursor.moveToNext());
        int index = cursor.getColumnIndex(BookmarkColumns.BOOKMARK);
        assertTrue(-1 != index);
        assertEquals(0, cursor.getInt(index));
        index = cursor.getColumnIndex(BookmarkColumns.CREATED);
        assertTrue(-1 != index);
        assertEquals(createdTime, cursor.getLong(index));
        index = cursor.getColumnIndex(BookmarkColumns.DATE);
        assertTrue(-1 != index);
        assertEquals(lastUpdateTime, cursor.getLong(index));
        index = cursor.getColumnIndex(BookmarkColumns.FAVICON);
        assertTrue(-1 != index);
        assertTrue(BookmarkUtils.byteArrayEqual(BookmarkUtils.getIcon(ICON_PATH),
                cursor.getBlob(index)));
        index = cursor.getColumnIndex(BookmarkColumns.URL);
        assertTrue(-1 != index);
        assertEquals(url, cursor.getString(index));
        index = cursor.getColumnIndex(BookmarkColumns.VISITS);
        assertTrue(-1 != index);
        assertEquals(visits, cursor.getInt(index));
    }

    /**
     * @MediumTest
     * @Feature({"Android-ContentProvider"})
     * BUG 154683
     */
    @DisabledTest
    public void testQueryBookmark() {
        final long now = System.currentTimeMillis();
        final long lastUpdateTime[] = { now, now - 1000 * 60 };
        final long createdTime[] = { now - 1000 * 60 * 60, now - 1000 * 60 * 60 * 60 };
        final String url[] = { "http://www.google.com/", "http://mail.google.com/" };
        final int visits[] = { 2, 20 };
        final String title[] = { "Google", "Mail" };
        final int isBookmark[] = { 1, 0 };
        Uri[] uris = new Uri[2];
        byte[][] icons = { BookmarkUtils.getIcon(ICON_PATH), null };
        for (int i = 0; i < uris.length; i++) {
            uris[i] = addBookmark(url[i], title[i], lastUpdateTime[i], createdTime[i], visits[i],
                    icons[i], isBookmark[i]);
            assertNotNull(uris[i]);
        }

        // Query the 1st row.
        String[] selectionArgs = { url[0], String.valueOf(lastUpdateTime[0]),
                String.valueOf(visits[0]), String.valueOf(isBookmark[0]) };
        Cursor cursor = getContentResolver().query(mBookmarksUri, null,
                "url = ? AND date = ? AND visits = ? AND bookmark = ? AND favicon IS NOT NULL",
                selectionArgs, null);
        assertNotNull(cursor);
        assertEquals(1, cursor.getCount());
        assertTrue(cursor.moveToNext());
        int index = cursor.getColumnIndex(BookmarkColumns.BOOKMARK);
        assertTrue(-1 != index);
        assertEquals(isBookmark[0], cursor.getInt(index));
        index = cursor.getColumnIndex(BookmarkColumns.CREATED);
        assertTrue(-1 != index);
        assertEquals(createdTime[0], cursor.getLong(index));
        index = cursor.getColumnIndex(BookmarkColumns.DATE);
        assertTrue(-1 != index);
        assertEquals(lastUpdateTime[0], cursor.getLong(index));
        index = cursor.getColumnIndex(BookmarkColumns.FAVICON);
        assertTrue(-1 != index);
        assertTrue(BookmarkUtils.byteArrayEqual(icons[0], cursor.getBlob(index)));
        index = cursor.getColumnIndex(BookmarkColumns.URL);
        assertTrue(-1 != index);
        assertEquals(url[0], cursor.getString(index));
        index = cursor.getColumnIndex(BookmarkColumns.VISITS);
        assertTrue(-1 != index);
        assertEquals(visits[0], cursor.getInt(index));

        // Query the 2nd row.
        String[] selectionArgs2 = { url[1], String.valueOf(lastUpdateTime[1]),
                String.valueOf(visits[1]), String.valueOf(isBookmark[1]) };
        cursor = getContentResolver().query(mBookmarksUri, null,
                "url = ? AND date = ? AND visits = ? AND bookmark = ? AND favicon IS NULL",
                selectionArgs2, null);
        assertNotNull(cursor);
        assertEquals(1, cursor.getCount());
        assertTrue(cursor.moveToNext());
        index = cursor.getColumnIndex(BookmarkColumns.BOOKMARK);
        assertTrue(-1 != index);
        assertEquals(isBookmark[1], cursor.getInt(index));
        index = cursor.getColumnIndex(BookmarkColumns.CREATED);
        assertTrue(-1 != index);
        assertEquals(createdTime[1], cursor.getLong(index));
        index = cursor.getColumnIndex(BookmarkColumns.DATE);
        assertTrue(-1 != index);
        assertEquals(lastUpdateTime[1], cursor.getLong(index));
        index = cursor.getColumnIndex(BookmarkColumns.FAVICON);
        assertTrue(-1 != index);
        assertTrue(BookmarkUtils.byteArrayEqual(icons[1], cursor.getBlob(index)));
        index = cursor.getColumnIndex(BookmarkColumns.URL);
        assertTrue(-1 != index);
        assertEquals(url[1], cursor.getString(index));
        index = cursor.getColumnIndex(BookmarkColumns.VISITS);
        assertTrue(-1 != index);
        assertEquals(visits[1], cursor.getInt(index));
    }

    /**
     * @MediumTest
     * @Feature({"Android-ContentProvider"})
     * BUG 154683
     */
    @DisabledTest
    public void testUpdateBookmark() {
        final long now = System.currentTimeMillis();
        final long lastUpdateTime[] = { now, now - 1000 * 60 };
        final long createdTime[] = { now - 1000 * 60 * 60, now - 1000 * 60 * 60 * 60 };
        final String url[] = { "http://www.google.com/", "http://mail.google.com/" };
        final int visits[] = { 2, 20 };
        final String title[] = { "Google", "Mail" };
        final int isBookmark[] = { 1, 0 };

        byte[][] icons = { BookmarkUtils.getIcon(ICON_PATH), null };
        Uri uri = addBookmark(url[0], title[0], lastUpdateTime[0], createdTime[0], visits[0],
                icons[0], isBookmark[0]);
        assertNotNull(uri);

        ContentValues values = new ContentValues();
        values.put(BookmarkColumns.BOOKMARK, isBookmark[1]);
        values.put(BookmarkColumns.DATE, lastUpdateTime[1]);
        values.put(BookmarkColumns.URL, url[1]);
        values.putNull(BookmarkColumns.FAVICON);
        values.put(BookmarkColumns.TITLE, title[1]);
        values.put(BookmarkColumns.VISITS, visits[1]);
        String[] selectionArgs = { String.valueOf(lastUpdateTime[0]),
                String.valueOf(isBookmark[0]) };
        getContentResolver().update(uri, values, BookmarkColumns.FAVICON +  " IS NOT NULL AND " +
                BookmarkColumns.DATE + "= ? AND " + BookmarkColumns.BOOKMARK + " = ?",
                selectionArgs);
        Cursor cursor = getContentResolver().query(uri, null, null, null, null);
        assertEquals(1, cursor.getCount());
        assertTrue(cursor.moveToNext());
        int index = cursor.getColumnIndex(BookmarkColumns.BOOKMARK);
        assertTrue(-1 != index);
        assertEquals(isBookmark[1], cursor.getInt(index));
        index = cursor.getColumnIndex(BookmarkColumns.CREATED);
        assertTrue(-1 != index);
        assertEquals(createdTime[0], cursor.getLong(index));
        index = cursor.getColumnIndex(BookmarkColumns.DATE);
        assertTrue(-1 != index);
        assertEquals(lastUpdateTime[1], cursor.getLong(index));
        index = cursor.getColumnIndex(BookmarkColumns.FAVICON);
        assertTrue(-1 != index);
        assertTrue(BookmarkUtils.byteArrayEqual(icons[1], cursor.getBlob(index)));
        index = cursor.getColumnIndex(BookmarkColumns.URL);
        assertTrue(-1 != index);
        assertEquals(url[1], cursor.getString(index));
        index = cursor.getColumnIndex(BookmarkColumns.VISITS);
        assertTrue(-1 != index);
        assertEquals(visits[1], cursor.getInt(index));
    }

    /**
     * @MediumTest
     * @Feature({"Android-ContentProvider"})
     * BUG 154683
     */
    @DisabledTest
    public void testDeleteBookmark() {
        final long now = System.currentTimeMillis();
        final long lastUpdateTime[] = { now, now - 1000 * 60 };
        final long createdTime[] = { now - 1000 * 60 * 60, now - 1000 * 60 * 60 * 60 };
        final String url[] = { "http://www.google.com/", "http://mail.google.com/" };
        final int visits[] = { 2, 20 };
        final String title[] = { "Google", "Mail" };
        final int isBookmark[] = { 1, 0 };
        Uri[] uris = new Uri[2];
        byte[][] icons = { BookmarkUtils.getIcon(ICON_PATH), null };
        for (int i = 0; i < uris.length; i++) {
            uris[i] = addBookmark(url[i], title[i], lastUpdateTime[i], createdTime[i], visits[i],
                    icons[i], isBookmark[i]);
            assertNotNull(uris[i]);
        }

        String[] selectionArgs = { String.valueOf(lastUpdateTime[0]),
                String.valueOf(isBookmark[0]) };
        getContentResolver().delete(mBookmarksUri, BookmarkColumns.FAVICON +  " IS NOT NULL AND " +
                BookmarkColumns.DATE + "= ? AND " + BookmarkColumns.BOOKMARK + " = ?",
                selectionArgs);
        Cursor cursor = getContentResolver().query(uris[0], null, null, null, null);
        assertNotNull(cursor);
        assertEquals(0, cursor.getCount());
        cursor = getContentResolver().query(uris[1], null, null, null, null);
        assertNotNull(cursor);
        assertEquals(1, cursor.getCount());
        String[] selectionArgs1 = { String.valueOf(lastUpdateTime[1]),
                String.valueOf(isBookmark[1]) };
        getContentResolver().delete(mBookmarksUri, BookmarkColumns.FAVICON +  " IS NULL AND " +
                BookmarkColumns.DATE + "= ? AND " + BookmarkColumns.BOOKMARK + " = ?",
                selectionArgs1);
        cursor = getContentResolver().query(uris[1], null, null, null, null);
        assertNotNull(cursor);
        assertEquals(0, cursor.getCount());
    }

    /*
     * Copied from CTS test with minor adaptations.
     */
    /**
     * @MediumTest
     * @Feature({"Android-ContentProvider"})
     * BUG 154683
     */
    @DisabledTest
    public void testBookmarksTable() {
        final String[] BOOKMARKS_PROJECTION = new String[] {
                BookmarkColumns._ID, BookmarkColumns.URL, BookmarkColumns.VISITS,
                BookmarkColumns.DATE, BookmarkColumns.CREATED, BookmarkColumns.BOOKMARK,
                BookmarkColumns.TITLE, BookmarkColumns.FAVICON };
        final int ID_INDEX = 0;
        final int URL_INDEX = 1;
        final int VISITS_INDEX = 2;
        final int DATE_INDEX = 3;
        final int CREATED_INDEX = 4;
        final int BOOKMARK_INDEX = 5;
        final int TITLE_INDEX = 6;
        final int FAVICON_INDEX = 7;

        final String insertBookmarkTitle = "bookmark_insert";
        final String insertBookmarkUrl = "www.bookmark_insert.com";

        final String updateBookmarkTitle = "bookmark_update";
        final String updateBookmarkUrl = "www.bookmark_update.com";

        // Test: insert.
        ContentValues value = new ContentValues();
        long createDate = new Date().getTime();
        value.put(BookmarkColumns.TITLE, insertBookmarkTitle);
        value.put(BookmarkColumns.URL, insertBookmarkUrl);
        value.put(BookmarkColumns.VISITS, 0);
        value.put(BookmarkColumns.DATE, createDate);
        value.put(BookmarkColumns.CREATED, createDate);
        value.put(BookmarkColumns.BOOKMARK, 0);

        Uri insertUri = getContentResolver().insert(mBookmarksUri, value);
        Cursor cursor = getContentResolver().query(
                mBookmarksUri,
                BOOKMARKS_PROJECTION,
                BookmarkColumns.TITLE + " = ?",
                new String[] { insertBookmarkTitle },
                BookmarkColumns.DATE);
        assertTrue(cursor.moveToNext());
        assertEquals(insertBookmarkTitle, cursor.getString(TITLE_INDEX));
        assertEquals(insertBookmarkUrl, cursor.getString(URL_INDEX));
        assertEquals(0, cursor.getInt(VISITS_INDEX));
        assertEquals(createDate, cursor.getLong(DATE_INDEX));
        assertEquals(createDate, cursor.getLong(CREATED_INDEX));
        assertEquals(0, cursor.getInt(BOOKMARK_INDEX));
        // TODO(michaelbai): according to the test this should be null instead of an empty byte[].
        // BUG 6288508
        // assertTrue(cursor.isNull(FAVICON_INDEX));
        int Id = cursor.getInt(ID_INDEX);
        cursor.close();

        // Test: update.
        value.clear();
        long updateDate = new Date().getTime();
        value.put(BookmarkColumns.TITLE, updateBookmarkTitle);
        value.put(BookmarkColumns.URL, updateBookmarkUrl);
        value.put(BookmarkColumns.VISITS, 1);
        value.put(BookmarkColumns.DATE, updateDate);

        getContentResolver().update(mBookmarksUri, value,
                BookmarkColumns.TITLE + " = ?",
                new String[] { insertBookmarkTitle });
        cursor = getContentResolver().query(
                mBookmarksUri,
                BOOKMARKS_PROJECTION,
                BookmarkColumns._ID + " = " + Id,
                null, null);
        assertTrue(cursor.moveToNext());
        assertEquals(updateBookmarkTitle, cursor.getString(TITLE_INDEX));
        assertEquals(updateBookmarkUrl, cursor.getString(URL_INDEX));
        assertEquals(1, cursor.getInt(VISITS_INDEX));
        assertEquals(updateDate, cursor.getLong(DATE_INDEX));
        assertEquals(createDate, cursor.getLong(CREATED_INDEX));
        assertEquals(0, cursor.getInt(BOOKMARK_INDEX));
        // TODO(michaelbai): according to the test this should be null instead of an empty byte[].
        // BUG 6288508
        // assertTrue(cursor.isNull(FAVICON_INDEX));
        assertEquals(Id, cursor.getInt(ID_INDEX));

        // Test: delete.
        getContentResolver().delete(insertUri, null, null);
        cursor = getContentResolver().query(
                mBookmarksUri,
                BOOKMARKS_PROJECTION,
                BookmarkColumns._ID + " = " + Id,
                null, null);
        assertEquals(0, cursor.getCount());
    }
}