tests/src/com/android/photos/data/PhotoDatabaseUtils.java

/*
 * Copyright (C) 2013 The Android Open Source Project
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.android.photos.data;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import com.android.photos.data.PhotoProvider.Accounts;
import com.android.photos.data.PhotoProvider.Albums;
import com.android.photos.data.PhotoProvider.Metadata;
import com.android.photos.data.PhotoProvider.Photos;

import junit.framework.AssertionFailedError;

public class PhotoDatabaseUtils {
    public static String[] PROJECTION_ALBUMS = {
        Albums._ID,
        Albums.ACCOUNT_ID,
        Albums.PARENT_ID,
        Albums.VISIBILITY,
        Albums.LOCATION_STRING,
        Albums.TITLE,
        Albums.SUMMARY,
        Albums.DATE_PUBLISHED,
        Albums.DATE_MODIFIED,
    };

    public static String[] PROJECTION_METADATA = {
        Metadata.PHOTO_ID,
        Metadata.KEY,
        Metadata.VALUE,
    };

    public static String[] PROJECTION_PHOTOS = {
        Photos._ID,
        Photos.ACCOUNT_ID,
        Photos.WIDTH,
        Photos.HEIGHT,
        Photos.DATE_TAKEN,
        Photos.ALBUM_ID,
        Photos.MIME_TYPE,
        Photos.TITLE,
        Photos.DATE_MODIFIED,
        Photos.ROTATION,
    };

    public static String[] PROJECTION_ACCOUNTS = {
        Accounts._ID,
        Accounts.ACCOUNT_NAME,
    };

    private static String SELECTION_ALBUM_PARENT_ID = Albums.PARENT_ID + " = ?";
    private static String SELECTION_PHOTO_ALBUM_ID = Photos.ALBUM_ID + " = ?";
    private static String SELECTION_ACCOUNT_ID = Accounts.ACCOUNT_NAME + " = ?";

    public static long queryAlbumIdFromParentId(SQLiteDatabase db, long parentId) {
        return queryId(db, Albums.TABLE, PROJECTION_ALBUMS, SELECTION_ALBUM_PARENT_ID, parentId);
    }

    public static long queryPhotoIdFromAlbumId(SQLiteDatabase db, long albumId) {
        return queryId(db, Photos.TABLE, PROJECTION_PHOTOS, SELECTION_PHOTO_ALBUM_ID, albumId);
    }

    public static long queryAccountIdFromName(SQLiteDatabase db, String accountName) {
        return queryId(db, Accounts.TABLE, PROJECTION_ACCOUNTS, SELECTION_ACCOUNT_ID, accountName);
    }

    public static long queryId(SQLiteDatabase db, String table, String[] projection,
            String selection, Object parameter) {
        String paramString = parameter == null ? null : parameter.toString();
        String[] selectionArgs = {
            paramString,
        };
        Cursor cursor = db.query(table, projection, selection, selectionArgs, null, null, null);
        try {
            if (cursor.getCount() != 1 || !cursor.moveToNext()) {
                throw new AssertionFailedError("Couldn't find item in table");
            }
            long id = cursor.getLong(0);
            return id;
        } finally {
            cursor.close();
        }
    }

    public static boolean insertPhoto(SQLiteDatabase db, Integer width, Integer height,
            Long dateTaken, Long albumId, String mimeType, Long accountId) {
        ContentValues values = new ContentValues();
        values.put(Photos.WIDTH, width);
        values.put(Photos.HEIGHT, height);
        values.put(Photos.DATE_TAKEN, dateTaken);
        values.put(Photos.ALBUM_ID, albumId);
        values.put(Photos.MIME_TYPE, mimeType);
        values.put(Photos.ACCOUNT_ID, accountId);
        return db.insert(Photos.TABLE, null, values) != -1;
    }

    public static boolean insertAlbum(SQLiteDatabase db, Long parentId, String title,
            Integer privacy, Long accountId) {
        ContentValues values = new ContentValues();
        values.put(Albums.PARENT_ID, parentId);
        values.put(Albums.TITLE, title);
        values.put(Albums.VISIBILITY, privacy);
        values.put(Albums.ACCOUNT_ID, accountId);
        return db.insert(Albums.TABLE, null, values) != -1;
    }

    public static boolean insertMetadata(SQLiteDatabase db, Long photosId, String key, String value) {
        ContentValues values = new ContentValues();
        values.put(Metadata.PHOTO_ID, photosId);
        values.put(Metadata.KEY, key);
        values.put(Metadata.VALUE, value);
        return db.insert(Metadata.TABLE, null, values) != -1;
    }

    public static boolean insertAccount(SQLiteDatabase db, String name) {
        ContentValues values = new ContentValues();
        values.put(Accounts.ACCOUNT_NAME, name);
        return db.insert(Accounts.TABLE, null, values) != -1;
    }
}