44
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
1 |
package com.beem.project.beem.provider;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
2 |
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
3 |
import android.content.Context;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
4 |
import android.database.sqlite.SQLiteDatabase;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
5 |
import android.database.sqlite.SQLiteOpenHelper;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
6 |
import android.util.Log;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
7 |
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
8 |
public class BeemDatabaseHelper extends SQLiteOpenHelper {
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
9 |
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
10 |
private String tag;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
11 |
private String tableName;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
12 |
private String creationQuery;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
13 |
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
14 |
public BeemDatabaseHelper(Context context, String tag, String tableName, String creationQuery) {
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
15 |
super(context, Beem.DB_NAME, null, Beem.DB_VERSION);
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
16 |
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
17 |
this.tag = tag;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
18 |
this.tableName = tableName;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
19 |
this.creationQuery = creationQuery;
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
20 |
}
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
21 |
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
22 |
@Override
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
23 |
public void onCreate(SQLiteDatabase db) {
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
24 |
db.execSQL(this.creationQuery);
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
25 |
}
|
61
|
26 |
|
44
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
27 |
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
28 |
@Override
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
29 |
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
30 |
Log.w(this.tag, "Upgrading database from version " + oldVersion + " to "
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
31 |
+ newVersion + ", which will destroy all old data");
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
32 |
db.execSQL("DROP TABLE IF EXISTS " + this.tableName + ";");
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
33 |
onCreate(db);
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
34 |
}
|
dasilvj@jean-manuel-da-silvas-macbook.local
parents:
diff
changeset
|
35 |
}
|