/*
* Tint Browser for Android
*
* Copyright (C) 2012 - to infinity and beyond J. Devauchelle and contributors.
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* version 3 as published by the Free Software Foundation.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*/
package com.seal.providers;
import java.io.ByteArrayOutputStream;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import android.content.ContentResolver;
import android.content.ContentValues;
import android.content.Context;
import android.content.CursorLoader;
import android.database.Cursor;
import android.database.DatabaseUtils;
import android.graphics.Bitmap;
import android.net.Uri;
import android.preference.PreferenceManager;
import android.util.Log;
import com.seal.model.BookmarkHistoryItem;
import com.seal.model.FolderItem;
import com.seal.utils.Constants;
public class BookmarksWrapper {
public static String[] HISTORY_BOOKMARKS_PROJECTION = new String[] { BookmarksProvider.Columns._ID, BookmarksProvider.Columns.TITLE,
BookmarksProvider.Columns.URL, BookmarksProvider.Columns.VISITS, BookmarksProvider.Columns.CREATION_DATE, BookmarksProvider.Columns.VISITED_DATE,
BookmarksProvider.Columns.BOOKMARK, BookmarksProvider.Columns.IS_FOLDER, BookmarksProvider.Columns.PARENT_FOLDER_ID,
BookmarksProvider.Columns.FAVICON, BookmarksProvider.Columns.THUMBNAIL };
public static CursorLoader getCursorLoaderForStartPage(Context context, int limit) {
Calendar c = Calendar.getInstance();
c.setTime(new Date());
c.set(Calendar.HOUR_OF_DAY, 0);
c.set(Calendar.MINUTE, 0);
c.set(Calendar.SECOND, 0);
c.set(Calendar.MILLISECOND, 0);
c.add(Calendar.DAY_OF_YEAR, -14);
String whereClause = BookmarksProvider.Columns.VISITED_DATE + " > " + Long.toString(c.getTimeInMillis());
String orderClause = BookmarksProvider.Columns.VISITS + " DESC, " + BookmarksProvider.Columns.VISITED_DATE + " DESC LIMIT " + Integer.toString(limit);
return new CursorLoader(context, BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, orderClause);
}
public static CursorLoader getCursorLoaderForBookmarks(Context context, long parentFolderId) {
int sortMode = PreferenceManager.getDefaultSharedPreferences(context).getInt(Constants.PREFERENCE_BOOKMARKS_SORT_MODE, 0);
String whereClause = BookmarksProvider.Columns.PARENT_FOLDER_ID + " = " + parentFolderId + " AND (" + BookmarksProvider.Columns.BOOKMARK + " = 1 OR "
+ BookmarksProvider.Columns.IS_FOLDER + " = 1)";
String orderClause;
switch (sortMode) {
case 0:
orderClause = BookmarksProvider.Columns.IS_FOLDER + " DESC, " + BookmarksProvider.Columns.VISITS + " DESC, " + BookmarksProvider.Columns.TITLE
+ " COLLATE NOCASE";
break;
case 1:
orderClause = BookmarksProvider.Columns.IS_FOLDER + " DESC, " + BookmarksProvider.Columns.TITLE + " COLLATE NOCASE, "
+ BookmarksProvider.Columns.VISITS + " DESC";
break;
case 2:
orderClause = BookmarksProvider.Columns.IS_FOLDER + " DESC, " + BookmarksProvider.Columns.VISITED_DATE + " DESC, "
+ BookmarksProvider.Columns.TITLE + " COLLATE NOCASE";
break;
default:
orderClause = BookmarksProvider.Columns.IS_FOLDER + " DESC, " + BookmarksProvider.Columns.VISITS + " DESC, " + BookmarksProvider.Columns.TITLE
+ " COLLATE NOCASE";
break;
}
return new CursorLoader(context, BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, orderClause);
}
public static CursorLoader getCursorLoaderForHistory(Context context) {
String whereClause = BookmarksProvider.Columns.VISITS + " > 0 AND " + BookmarksProvider.Columns.IS_FOLDER + " = 0";
String orderClause = BookmarksProvider.Columns.VISITED_DATE + " DESC";
return new CursorLoader(context, BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, orderClause);
}
public static Cursor getAllHistoryBookmarks(ContentResolver contentResolver) {
return contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, null, null, null);
}
public static BookmarkHistoryItem getBookmarkById(ContentResolver contentResolver, long id) {
BookmarkHistoryItem result = null;
String whereClause = BookmarksProvider.Columns._ID + " = " + id;
Cursor c = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, null);
if (c != null) {
if (c.moveToFirst()) {
String title = c.getString(c.getColumnIndex(BookmarksProvider.Columns.TITLE));
String url = c.getString(c.getColumnIndex(BookmarksProvider.Columns.URL));
boolean isBookmarks = c.getInt(c.getColumnIndex(BookmarksProvider.Columns.BOOKMARK)) > 0 ? true : false;
boolean isFolder = c.getInt(c.getColumnIndex(BookmarksProvider.Columns.IS_FOLDER)) > 0 ? true : false;
long folderId = c.getLong(c.getColumnIndex(BookmarksProvider.Columns.PARENT_FOLDER_ID));
byte[] favIcon = c.getBlob(c.getColumnIndex(BookmarksProvider.Columns.FAVICON));
result = new BookmarkHistoryItem(id, title, url, isBookmarks, isFolder, folderId, favIcon);
}
c.close();
}
return result;
}
/**
* Clear the history/bookmarks table.
*
* @param contentResolver
* The content resolver.
* @param clearHistory
* If true, history items will be cleared.
* @param clearBookmarks
* If true, bookmarked items will be cleared.
*/
public static void clearHistoryAndOrBookmarks(ContentResolver contentResolver, boolean clearHistory, boolean clearBookmarks) {
if (!clearHistory && !clearBookmarks) {
return;
}
String whereClause = null;
if (clearHistory && clearBookmarks) {
whereClause = null;
} else if (clearHistory) {
whereClause = "((" + BookmarksProvider.Columns.BOOKMARK + " = 0) OR (" + BookmarksProvider.Columns.BOOKMARK + " IS NULL)) AND ("
+ BookmarksProvider.Columns.IS_FOLDER + " = 0)";
} else if (clearBookmarks) {
whereClause = "(" + BookmarksProvider.Columns.BOOKMARK + " = 1) OR (" + BookmarksProvider.Columns.IS_FOLDER + " = 1)";
}
contentResolver.delete(BookmarksProvider.BOOKMARKS_URI, whereClause, null);
}
public static List<FolderItem> getFirstLevelFoldersList(ContentResolver contentResolver) {
List<FolderItem> result = new ArrayList<FolderItem>();
String whereClause = BookmarksProvider.Columns.IS_FOLDER + " = 1 AND " + BookmarksProvider.Columns.PARENT_FOLDER_ID + " = -1";
String orderClause = BookmarksProvider.Columns.TITLE;
Cursor c = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, orderClause);
if ((c != null) && (c.moveToFirst())) {
int idIndex = c.getColumnIndex(BookmarksProvider.Columns._ID);
int titleIndex = c.getColumnIndex(BookmarksProvider.Columns.TITLE);
do {
result.add(new FolderItem(c.getLong(idIndex), c.getString(titleIndex)));
} while (c.moveToNext());
c.close();
}
return result;
}
public static long getFolderId(ContentResolver contentResolver, String folderName, boolean createIfNotPresent) {
String escapedFolderName = DatabaseUtils.sqlEscapeString(folderName);
String whereClause = BookmarksProvider.Columns.TITLE + " = " + escapedFolderName + " AND " + BookmarksProvider.Columns.IS_FOLDER + " = 1";
Cursor c = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, null);
if ((c != null) && (c.moveToFirst())) {
return c.getLong(c.getColumnIndex(BookmarksProvider.Columns._ID));
} else {
if (createIfNotPresent) {
ContentValues values = new ContentValues();
values.put(BookmarksProvider.Columns.TITLE, folderName);
values.putNull(BookmarksProvider.Columns.URL);
values.put(BookmarksProvider.Columns.BOOKMARK, 0);
values.put(BookmarksProvider.Columns.IS_FOLDER, 1);
Uri result = contentResolver.insert(BookmarksProvider.BOOKMARKS_URI, values);
Cursor inserted = contentResolver.query(result, HISTORY_BOOKMARKS_PROJECTION, null, null, null);
if ((inserted != null) && (inserted.moveToFirst())) {
return inserted.getLong(inserted.getColumnIndex(BookmarksProvider.Columns._ID));
} else {
return -1;
}
} else {
return -1;
}
}
}
/**
* Modify a bookmark/history record. If an id is provided, it look for it and update its values. If not, values will be inserted. If no id is provided, it look for a record with the given url. It found, its values are updated. If not, values will be inserted.
*
* @param contentResolver
* The content resolver.
* @param id
* The record id to look for.
* @param folderId
* The id of the folder in which this bookmarks is.
* @param title
* The record title.
* @param url
* The record url.
* @param isBookmark
* If True, the record will be a bookmark.
*/
public static void setAsBookmark(ContentResolver contentResolver, long id, long folderId, String title, String url, boolean isBookmark) {
boolean bookmarkExist = false;
if (id != -1) {
String[] colums = new String[] { BookmarksProvider.Columns._ID };
String whereClause = BookmarksProvider.Columns._ID + " = " + id;
Cursor cursor = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, colums, whereClause, null, null);
bookmarkExist = (cursor != null) && (cursor.moveToFirst());
} else {
String[] colums = new String[] { BookmarksProvider.Columns._ID };
String escapedUrl = DatabaseUtils.sqlEscapeString(url);
String whereClause = BookmarksProvider.Columns.URL + " = " + escapedUrl;
Cursor cursor = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, colums, whereClause, null, null);
bookmarkExist = (cursor != null) && (cursor.moveToFirst());
if (bookmarkExist) {
id = cursor.getLong(cursor.getColumnIndex(BookmarksProvider.Columns._ID));
}
}
ContentValues values = new ContentValues();
if (title != null) {
values.put(BookmarksProvider.Columns.TITLE, title);
}
if (url != null) {
values.put(BookmarksProvider.Columns.URL, url);
}
if (isBookmark) {
values.put(BookmarksProvider.Columns.BOOKMARK, 1);
values.put(BookmarksProvider.Columns.PARENT_FOLDER_ID, folderId);
values.put(BookmarksProvider.Columns.CREATION_DATE, new Date().getTime());
} else {
values.put(BookmarksProvider.Columns.BOOKMARK, 0);
values.put(BookmarksProvider.Columns.PARENT_FOLDER_ID, -1);
values.putNull(BookmarksProvider.Columns.CREATION_DATE);
}
if (bookmarkExist) {
contentResolver.update(BookmarksProvider.BOOKMARKS_URI, values, BookmarksProvider.Columns._ID + " = " + id, null);
} else {
contentResolver.insert(BookmarksProvider.BOOKMARKS_URI, values);
}
}
public static void deleteBookmark(ContentResolver contentResolver, long id) {
String whereClause = BookmarksProvider.Columns._ID + " = " + id;
Cursor c = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, null);
if (c != null) {
if (c.moveToFirst()) {
if (c.getInt(c.getColumnIndex(BookmarksProvider.Columns.BOOKMARK)) == 1) {
if (c.getInt(c.getColumnIndex(BookmarksProvider.Columns.VISITS)) > 0) {
// If this record has been visited, keep it in history, but remove its bookmark flag.
ContentValues values = new ContentValues();
values.put(BookmarksProvider.Columns.BOOKMARK, 0);
values.put(BookmarksProvider.Columns.PARENT_FOLDER_ID, -1);
values.putNull(BookmarksProvider.Columns.CREATION_DATE);
contentResolver.update(BookmarksProvider.BOOKMARKS_URI, values, whereClause, null);
} else {
// never visited, it can be deleted.
contentResolver.delete(BookmarksProvider.BOOKMARKS_URI, whereClause, null);
}
}
}
c.close();
}
}
public static void deleteFolder(ContentResolver contentResolver, long id) {
BookmarksProvider provider = (BookmarksProvider) contentResolver.acquireContentProviderClient(BookmarksProvider.BOOKMARKS_URI)
.getLocalContentProvider();
provider.setNotifyChanges(false);
// Delete child folders.
Cursor c = getChildrenFolders(contentResolver, id);
if (c != null) {
if (c.moveToFirst()) {
int idIndex = c.getColumnIndex(BookmarksProvider.Columns._ID);
do {
long childId = c.getLong(idIndex);
deleteFolder(contentResolver, childId);
} while (c.moveToNext());
}
c.close();
}
// Delete content of the folder.
String whereClause = BookmarksProvider.Columns.PARENT_FOLDER_ID + " = " + id + " AND " + BookmarksProvider.Columns.BOOKMARK + " > 0";
c = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, null);
if (c != null) {
if (c.moveToFirst()) {
int idIndex = c.getColumnIndex(BookmarksProvider.Columns._ID);
int visitsIndex = c.getColumnIndex(BookmarksProvider.Columns.VISITS);
do {
long bookmarkId = c.getLong(idIndex);
if (c.getInt(visitsIndex) > 0) {
// If this record has been visited, keep it in history, but remove its bookmark flag and its folder id.
ContentValues values = new ContentValues();
values.put(BookmarksProvider.Columns.BOOKMARK, 0);
values.put(BookmarksProvider.Columns.PARENT_FOLDER_ID, -1);
values.putNull(BookmarksProvider.Columns.CREATION_DATE);
contentResolver.update(BookmarksProvider.BOOKMARKS_URI, values, BookmarksProvider.Columns._ID + " = " + bookmarkId, null);
} else {
contentResolver.delete(BookmarksProvider.BOOKMARKS_URI, BookmarksProvider.Columns._ID + " = " + bookmarkId, null);
}
} while (c.moveToNext());
}
c.close();
}
// Finally delete the folder.
contentResolver.delete(BookmarksProvider.BOOKMARKS_URI, BookmarksProvider.Columns._ID + " = " + id, null);
provider.setNotifyChanges(true);
}
public static void deleteHistoryRecord(ContentResolver contentResolver, long id) {
String whereClause = BookmarksProvider.Columns._ID + " = " + id;
Cursor c = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, null);
if (c != null) {
if (c.moveToFirst()) {
if (c.getInt(c.getColumnIndex(BookmarksProvider.Columns.BOOKMARK)) > 0) {
// This is a bookmark, we cannot delete it. Instead, set visits count to 0 and visited date to null.
ContentValues values = new ContentValues();
values.put(BookmarksProvider.Columns.VISITS, 0);
values.putNull(BookmarksProvider.Columns.VISITED_DATE);
contentResolver.update(BookmarksProvider.BOOKMARKS_URI, values, whereClause, null);
} else {
// Not a bookmark, it can be deleted.
contentResolver.delete(BookmarksProvider.BOOKMARKS_URI, whereClause, null);
}
}
c.close();
}
}
/**
* Update the history: visit count and last visited date.
*
* @param contentResolver
* The content resolver.
* @param title
* The title.
* @param url
* The url.
* @param originalUrl
* The original url
*/
public static void updateHistory(ContentResolver contentResolver, String title, String url, String originalUrl) {
String[] colums = new String[] { BookmarksProvider.Columns._ID, BookmarksProvider.Columns.URL, BookmarksProvider.Columns.BOOKMARK,
BookmarksProvider.Columns.VISITS };
String escapedUrl = url != null ? DatabaseUtils.sqlEscapeString(url) : "";
String escapedOriginalUrl = originalUrl != null ? DatabaseUtils.sqlEscapeString(originalUrl) : "";
String whereClause = BookmarksProvider.Columns.URL + " = " + escapedUrl + " OR " + BookmarksProvider.Columns.URL + " = " + escapedOriginalUrl;
Cursor cursor = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, colums, whereClause, null, null);
if (cursor != null) {
if (cursor.moveToFirst()) {
long id = cursor.getLong(cursor.getColumnIndex(BookmarksProvider.Columns._ID));
int visits = cursor.getInt(cursor.getColumnIndex(BookmarksProvider.Columns.VISITS)) + 1;
ContentValues values = new ContentValues();
// If its not a bookmark, we can update the title. If we were doing it on bookmarks, we would override the title choosen by the user.
if (cursor.getInt(cursor.getColumnIndex(BookmarksProvider.Columns.BOOKMARK)) != 1) {
values.put(BookmarksProvider.Columns.TITLE, title);
}
values.put(BookmarksProvider.Columns.VISITED_DATE, new Date().getTime());
values.put(BookmarksProvider.Columns.VISITS, visits);
contentResolver.update(BookmarksProvider.BOOKMARKS_URI, values, BookmarksProvider.Columns._ID + " = " + id, null);
} else {
ContentValues values = new ContentValues();
values.put(BookmarksProvider.Columns.TITLE, title);
values.put(BookmarksProvider.Columns.URL, url);
values.put(BookmarksProvider.Columns.VISITED_DATE, new Date().getTime());
values.put(BookmarksProvider.Columns.VISITS, 1);
values.put(BookmarksProvider.Columns.BOOKMARK, 0);
contentResolver.insert(BookmarksProvider.BOOKMARKS_URI, values);
}
cursor.close();
}
}
private static final String TRUNCATE_HISTORY_DELETE_WHERE_PATTERN = "(" + BookmarksProvider.Columns.BOOKMARK + " = 0 OR "
+ BookmarksProvider.Columns.BOOKMARK + " IS NULL) AND " + BookmarksProvider.Columns.VISITED_DATE + " < %s";
private static final String TRUNCATE_HISTORY_UPDATE_WHERE_PATTERN = BookmarksProvider.Columns.BOOKMARK + " = 1 AND "
+ BookmarksProvider.Columns.VISITED_DATE + " < %s";
/**
* Remove from history values prior to now minus the number of days defined in preferences. Only delete history items. For bookmarks, reset their visited value date and visits count.
*
* @param contentResolver
* The content resolver.
*/
public static void truncateHistory(ContentResolver contentResolver, String prefHistorySize) {
int historySize;
try {
historySize = Integer.parseInt(prefHistorySize);
} catch (NumberFormatException e) {
historySize = 90;
}
Calendar c = Calendar.getInstance();
c.setTime(new Date());
c.set(Calendar.HOUR_OF_DAY, 0);
c.set(Calendar.MINUTE, 0);
c.set(Calendar.SECOND, 0);
c.set(Calendar.MILLISECOND, 0);
c.add(Calendar.DAY_OF_YEAR, -historySize);
String whereClauseDelete = String.format(TRUNCATE_HISTORY_DELETE_WHERE_PATTERN, c.getTimeInMillis());
String whereClauseUpdate = String.format(TRUNCATE_HISTORY_UPDATE_WHERE_PATTERN, c.getTimeInMillis());
ContentValues updateValues = new ContentValues();
updateValues.putNull(BookmarksProvider.Columns.VISITED_DATE);
updateValues.put(BookmarksProvider.Columns.VISITS, 0);
try {
contentResolver.delete(BookmarksProvider.BOOKMARKS_URI, whereClauseDelete, null);
contentResolver.update(BookmarksProvider.BOOKMARKS_URI, updateValues, whereClauseUpdate, null);
} catch (Exception e) {
e.printStackTrace();
Log.w("BookmarksWrapper", "Unable to truncate history: " + e.getMessage());
}
}
private static final String UPDATE_FAVICON_WHERE_PATTERN_1 = BookmarksProvider.Columns.URL + " = %s OR " + BookmarksProvider.Columns.URL + " = %s";
private static final String UPDATE_FAVICON_WHERE_PATTERN_2 = BookmarksProvider.Columns.URL + " = %s";
/**
* Update the favicon in history/bookmarks database.
*
* @param contentResolver
* The content resolver.
* @param url
* The url.
* @param originalUrl
* The original url.
* @param favicon
* The favicon.
*/
public static void updateFavicon(ContentResolver contentResolver, String url, String originalUrl, Bitmap favicon) {
if ((url != null) && (favicon != null) && (contentResolver != null)) {
String whereClause;
if ((originalUrl != null) && !url.equals(originalUrl)) {
url = DatabaseUtils.sqlEscapeString(url);
originalUrl = DatabaseUtils.sqlEscapeString(originalUrl);
whereClause = String.format(UPDATE_FAVICON_WHERE_PATTERN_1, url, originalUrl);
} else {
url = DatabaseUtils.sqlEscapeString(url);
whereClause = String.format(UPDATE_FAVICON_WHERE_PATTERN_2, url);
}
ByteArrayOutputStream os = new ByteArrayOutputStream();
favicon.compress(Bitmap.CompressFormat.PNG, 100, os);
ContentValues values = new ContentValues();
values.put(BookmarksProvider.Columns.FAVICON, os.toByteArray());
try {
contentResolver.update(BookmarksProvider.BOOKMARKS_URI, values, whereClause, null);
} catch (Exception e) {
e.printStackTrace();
Log.w("BookmarksWrapper", "Unable to update favicon: " + e.getMessage());
}
}
}
private static final String BOOKMARK_BY_URL_WHERE_PATTERN_1 = "(" + BookmarksProvider.Columns.URL + " = %s OR " + BookmarksProvider.Columns.URL
+ " = %s) AND " + BookmarksProvider.Columns.BOOKMARK + " = 1";
private static final String BOOKMARK_BY_URL_WHERE_PATTERN_2 = BookmarksProvider.Columns.URL + " = %s AND " + BookmarksProvider.Columns.BOOKMARK + " = 1";
public static void updateThumbnail(ContentResolver contentResolver, String url, String originalUrl, Bitmap thumbnail) {
if ((url != null) && (thumbnail != null) && (contentResolver != null)) {
String whereClause;
if ((originalUrl != null) && !url.equals(originalUrl)) {
url = DatabaseUtils.sqlEscapeString(url);
originalUrl = DatabaseUtils.sqlEscapeString(originalUrl);
whereClause = String.format(BOOKMARK_BY_URL_WHERE_PATTERN_1, url, originalUrl);
} else {
url = DatabaseUtils.sqlEscapeString(url);
whereClause = String.format(BOOKMARK_BY_URL_WHERE_PATTERN_2, url);
}
ByteArrayOutputStream os = new ByteArrayOutputStream();
thumbnail.compress(Bitmap.CompressFormat.PNG, 100, os);
ContentValues values = new ContentValues();
values.put(BookmarksProvider.Columns.THUMBNAIL, os.toByteArray());
try {
contentResolver.update(BookmarksProvider.BOOKMARKS_URI, values, whereClause, null);
} catch (Exception e) {
e.printStackTrace();
Log.w("BookmarksWrapper", "Unable to update thumbnail: " + e.getMessage());
}
}
}
public static boolean urlHasBookmark(ContentResolver contentResolver, String url, String originalUrl) {
if ((url != null) && (contentResolver != null)) {
String whereClause;
if ((originalUrl != null) && !url.equals(originalUrl)) {
url = DatabaseUtils.sqlEscapeString(url);
originalUrl = DatabaseUtils.sqlEscapeString(originalUrl);
whereClause = String.format(BOOKMARK_BY_URL_WHERE_PATTERN_1, url, originalUrl);
} else {
url = DatabaseUtils.sqlEscapeString(url);
whereClause = String.format(BOOKMARK_BY_URL_WHERE_PATTERN_2, url);
}
Cursor c = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, null);
return c != null && c.getCount() > 0;
} else {
return false;
}
}
private static final String TOGGLE_BOOKMARK_WHERE_PATTERN = BookmarksProvider.Columns._ID + " = %s";
public static void toggleBookmark(ContentResolver contentResolver, long id, boolean bookmark) {
String[] colums = new String[] { BookmarksProvider.Columns._ID };
String whereClause = String.format(TOGGLE_BOOKMARK_WHERE_PATTERN, id);
Cursor cursor = contentResolver.query(BookmarksProvider.BOOKMARKS_URI, colums, whereClause, null, null);
boolean recordExists = (cursor != null) && (cursor.moveToFirst());
if (recordExists) {
ContentValues values = new ContentValues();
values.put(BookmarksProvider.Columns.BOOKMARK, bookmark);
values.put(BookmarksProvider.Columns.PARENT_FOLDER_ID, -1);
if (bookmark) {
values.put(BookmarksProvider.Columns.CREATION_DATE, new Date().getTime());
} else {
values.putNull(BookmarksProvider.Columns.CREATION_DATE);
values.putNull(BookmarksProvider.Columns.THUMBNAIL);
}
contentResolver.update(BookmarksProvider.BOOKMARKS_URI, values, whereClause, null);
}
}
/**
* Insert a full record in history/bookmarks database.
*
* @param contentResolver
* The content resolver.
* @param title
* The record title.
* @param url
* The record url.
* @param visits
* The record visit count.
* @param visitedDate
* The record last visit date.
* @param creationDate
* The record bookmark creation date.
* @param bookmark
* The bookmark flag.
*/
public static void insertRawRecord(ContentResolver contentResolver, String title, String url, int visits, long visitedDate, long creationDate, int bookmark) {
ContentValues values = new ContentValues();
values.put(BookmarksProvider.Columns.TITLE, title);
values.put(BookmarksProvider.Columns.URL, url);
values.put(BookmarksProvider.Columns.VISITS, visits);
if (visitedDate > 0) {
values.put(BookmarksProvider.Columns.VISITED_DATE, visitedDate);
} else {
values.putNull(BookmarksProvider.Columns.VISITED_DATE);
}
if (creationDate > 0) {
values.put(BookmarksProvider.Columns.CREATION_DATE, creationDate);
} else {
values.putNull(BookmarksProvider.Columns.CREATION_DATE);
}
if (bookmark > 0) {
values.put(BookmarksProvider.Columns.BOOKMARK, 1);
} else {
values.put(BookmarksProvider.Columns.BOOKMARK, 0);
}
contentResolver.insert(BookmarksProvider.BOOKMARKS_URI, values);
}
public static void fillDefaultBookmaks(ContentResolver contentResolver, String[] titles, String[] urls) {
int size = Math.min(titles.length, urls.length);
long currentDate = new Date().getTime();
for (int i = 0; i < size; i++) {
insertRawRecord(contentResolver, titles[i], urls[i], 0, currentDate, currentDate, 1);
}
}
private static final String SUGGESTIONS_PATTERN = "%%%s%%";
private static final String SUGGESTIONS_WHERE_PATTERN = BookmarksProvider.Columns.TITLE + " LIKE %s OR " + BookmarksProvider.Columns.URL + " LIKE %s";
private static final String SUGGESTIONS_ORDER = BookmarksProvider.Columns.VISITED_DATE + " DESC, " + BookmarksProvider.Columns.BOOKMARK + " DESC, "
+ BookmarksProvider.Columns.TITLE + " ASC";
/**
* Get a cursor for suggestions, given a search pattern. Search on history and bookmarks, on title and url.
*
* @param contentResolver
* The content resolver.
* @param pattern
* The pattern to search for.
* @return A cursor of suggestions.
*/
public static Cursor getUrlSuggestions(ContentResolver contentResolver, String pattern) {
if ((pattern != null) && (pattern.length() > 0)) {
String sqlPattern = DatabaseUtils.sqlEscapeString(String.format(SUGGESTIONS_PATTERN, pattern));
String whereClause = String.format(SUGGESTIONS_WHERE_PATTERN, sqlPattern, sqlPattern);
return contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, SUGGESTIONS_ORDER);
}
return null;
}
private static final String CHILDREN_FOLDERS_WHERE_PATTERN = BookmarksProvider.Columns.IS_FOLDER + " > 0 AND " + BookmarksProvider.Columns.PARENT_FOLDER_ID
+ " = %S";
private static Cursor getChildrenFolders(ContentResolver contentResolver, long folderId) {
String whereClause = String.format(CHILDREN_FOLDERS_WHERE_PATTERN, folderId);
return contentResolver.query(BookmarksProvider.BOOKMARKS_URI, HISTORY_BOOKMARKS_PROJECTION, whereClause, null, null);
}
}