1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
/*
* 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 FilterStackDBHelper extends SQLiteOpenHelper {
public static final int DATABASE_VERSION = 1;
public static final String DATABASE_NAME = "filterstacks.db";
private static final String SQL_CREATE_TABLE = "CREATE TABLE ";
public static interface FilterStack {
/** The row uid */
public static final String _ID = "_id";
/** The table name */
public static final String TABLE = "filterstack";
/** The stack name */
public static final String STACK_ID = "stack_id";
/** A serialized stack of filters. */
public static final String FILTER_STACK= "stack";
}
private static final String[][] CREATE_FILTER_STACK = {
{ FilterStack._ID, "INTEGER PRIMARY KEY AUTOINCREMENT" },
{ FilterStack.STACK_ID, "TEXT" },
{ FilterStack.FILTER_STACK, "BLOB" },
};
public FilterStackDBHelper(Context context, String name, int version) {
super(context, name, null, version);
}
public FilterStackDBHelper(Context context, String name) {
this(context, name, DATABASE_VERSION);
}
public FilterStackDBHelper(Context context) {
this(context, DATABASE_NAME);
}
@Override
public void onCreate(SQLiteDatabase db) {
createTable(db, FilterStack.TABLE, CREATE_FILTER_STACK);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
dropTable(db, FilterStack.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();
}
}
}
|