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
|
package org.fox.ttcomics;
import java.io.File;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteStatement;
import android.provider.BaseColumns;
public class DatabaseHelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "ComicsCache.db";
public static final int DATABASE_VERSION = 2;
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("DROP TABLE IF EXISTS comics_cache;");
db.execSQL("CREATE TABLE IF NOT EXISTS comics_cache (" +
BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
"filename TEXT, " +
"path TEXT, " + //v2
"checksum TEXT, " + //v2
"size INTEGER, " +
"position INTEGER, " +
"max_position INTEGER" +
");");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
if (oldVersion == 1 && newVersion == 2) {
db.execSQL("ALTER TABLE comics_cache ADD COLUMN path TEXT;");
db.execSQL("ALTER TABLE comics_cache ADD COLUMN checksum TEXT;");
Cursor c = db.query("comics_cache", null,
null, null, null, null, null);
if (c.moveToFirst()) {
while (!c.isAfterLast()) {
int id = c.getInt(c.getColumnIndex(BaseColumns._ID));
String fileName = c.getString(c.getColumnIndex("filename"));
File file = new File(fileName);
SQLiteStatement stmt = db.compileStatement("UPDATE comics_cache SET filename = ?, path = ? WHERE " + BaseColumns._ID + " = ?");
stmt.bindString(1, file.getName());
stmt.bindString(2, file.getParentFile().getAbsolutePath());
stmt.bindLong(3, id);
stmt.execute();
c.moveToNext();
}
}
c.close();
}
}
}
|