SQLiteDatabase Auto backup and restore

47 Views Asked by At

How can backup and restore to firebase of my SQLite Database DATA

My DatabaseHelper:

public class DatabaseHelper extends SQLiteOpenHelper {

    public static final String DATABASE_NAME = "user_details.db";

    /* User Details Table */

    public static final String TABLE_NAME_1 = "user_details";
    public static final String COL_1_1 = "ID";
    public static final String COL_2_1 = "PHONE_NUMBER";
    public static final String COL_3_1 = "NAME";
    public static final String COL_4_1 = "PASSCODE";
    public static final String COL_5_1 = "BUSINESS_NAME";
    public static final String COL_6_1 = "LOCATION";
    public static final String COL_7_1 = "CREATED_TIME";
    public static final String COL_8_1 = "STATUS";      // 1] Personal 2] Add Contact 3] Delete
    public static final String COL_9_1 = "IMAGE";

    /* Transaction Table */

    ......

    @Override
    public void onCreate(SQLiteDatabase db) {

        db.execSQL("create table " + TABLE_NAME_1 +" ("+COL_1_1+" INTEGER PRIMARY KEY AUTOINCREMENT,"+COL_2_1+" INTEGER,"+COL_3_1+" TEXT,"+COL_4_1+" TEXT,"+COL_5_1+" TEXT,"+COL_6_1+" TEXT,"+COL_7_1+" DEFAULT CURRENT_TIMESTAMP,"+COL_8_1+" INTEGER,"+COL_9_1+" blob)");
        db.execSQL("create table " + TABLE_NAME_2 +" ("+COL_1_2+" INTEGER PRIMARY KEY AUTOINCREMENT,"+COL_2_2+" INTEGER,"+COL_3_2+" INTEGER,"+COL_4_2+" INTEGER,"+COL_5_2+" INTEGER,"+COL_6_2+" TEXT,"+COL_7_2+" DEFAULT CURRENT_TIMESTAMP,"+COL_8_2+" TEXT)");
        db.execSQL("create table " + TABLE_NAME_3 +" ("+COL_1_3+" INTEGER PRIMARY KEY AUTOINCREMENT,"+COL_2_3+" INTEGER,"+COL_3_3+" INTEGER,"+COL_4_3+" DEFAULT CURRENT_TIMESTAMP)");

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int i, int i1) {

        db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME_1);

And my dashboard.java...

0

There are 0 best solutions below