| /* |
| * 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.gallery3d.filtershow.data; |
| |
| import android.content.Context; |
| import android.database.sqlite.SQLiteDatabase; |
| import android.database.sqlite.SQLiteOpenHelper; |
| |
| public class FilterPresetDBHelper extends SQLiteOpenHelper { |
| |
| public static final int DATABASE_VERSION = 1; |
| public static final String DATABASE_NAME = "filterspreset.db"; |
| private static final String SQL_CREATE_TABLE = "CREATE TABLE "; |
| |
| public static interface FilterPreset { |
| /** The row uid */ |
| public static final String _ID = "_id"; |
| /** The table name */ |
| public static final String TABLE = "filterspreset"; |
| /** The preset name */ |
| public static final String PRESET_ID = "preset_id"; |
| /** A serialized preset of filters. */ |
| public static final String FILTER_PRESET= "preset"; |
| } |
| |
| private static final String[][] CREATE_FILTER_PRESET = { |
| { FilterPreset._ID, "INTEGER PRIMARY KEY AUTOINCREMENT" }, |
| { FilterPreset.PRESET_ID, "TEXT" }, |
| { FilterPreset.FILTER_PRESET, "Uri" }, |
| }; |
| |
| public FilterPresetDBHelper(Context context, String name, int version) { |
| super(context, name, null, version); |
| } |
| |
| public FilterPresetDBHelper(Context context, String name) { |
| this(context, name, DATABASE_VERSION); |
| } |
| |
| public FilterPresetDBHelper(Context context) { |
| this(context, DATABASE_NAME); |
| } |
| |
| |
| @Override |
| public void onCreate(SQLiteDatabase db) { |
| createTable(db, FilterPreset.TABLE, CREATE_FILTER_PRESET); |
| } |
| |
| @Override |
| public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { |
| dropTable(db, FilterPreset.TABLE); |
| onCreate(db); |
| } |
| |
| protected static void createTable(SQLiteDatabase db, String table, String[][] columns) { |
| StringBuilder create = new StringBuilder(SQL_CREATE_TABLE); |
| create.append(table).append('('); |
| boolean first = true; |
| for (String[] column : columns) { |
| if (!first) { |
| create.append(','); |
| } |
| first = false; |
| for (String val : column) { |
| create.append(val).append(' '); |
| } |
| } |
| create.append(')'); |
| db.beginTransaction(); |
| try { |
| db.execSQL(create.toString()); |
| db.setTransactionSuccessful(); |
| } finally { |
| db.endTransaction(); |
| } |
| } |
| |
| protected static void dropTable(SQLiteDatabase db, String table) { |
| db.beginTransaction(); |
| try { |
| db.execSQL("drop table if exists " + table); |
| db.setTransactionSuccessful(); |
| } finally { |
| db.endTransaction(); |
| } |
| } |
| } |
| |