// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_ID = "id";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Image = "image";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Message = "message";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Name = "name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Next_Message = "next_message";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Next_SubName = "next_sub_name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Original_ID = "original_name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Prev_Message = "prev_message";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Prev_SubName = "prev_sub_name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_SubName = "sub_name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Time = "time";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Table_Recalled_Messages = "recalls";


import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import static com.qsboy.antirecall.db.DBHelper.Column_ID;
import static com.qsboy.antirecall.db.DBHelper.Column_Image;
import static com.qsboy.antirecall.db.DBHelper.Column_Message;
import static com.qsboy.antirecall.db.DBHelper.Column_Name;
import static com.qsboy.antirecall.db.DBHelper.Column_Next_Message;
import static com.qsboy.antirecall.db.DBHelper.Column_Next_SubName;
import static com.qsboy.antirecall.db.DBHelper.Column_Original_ID;
import static com.qsboy.antirecall.db.DBHelper.Column_Prev_Message;
import static com.qsboy.antirecall.db.DBHelper.Column_Prev_SubName;
import static com.qsboy.antirecall.db.DBHelper.Column_SubName;
import static com.qsboy.antirecall.db.DBHelper.Column_Time;
import static com.qsboy.antirecall.db.DBHelper.Table_Recalled_Messages;
    }

    public void deleteAll() {
        try {
            int delete1 = db.delete(Table_Recalled_Messages, null, null);
            int delete2 = db.delete("sqlite_sequence", null, null);
            int delete3 = db.delete("Jason", null, null);
            Log.i(TAG, "deleteAll: " + delete1);
            Log.i(TAG, "deleteAll: " + delete2);
            Log.i(TAG, "deleteAll: " + delete3);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void temp() {
        String sql;
        sql = "DROP TABLE " + Table_Recalled_Messages;
        db.execSQL(sql);
//        sql = "ALTER TABLE " + Table_Recalled_Messages + " RENAME TO " + Table_Recalled_Messages + "_";
//        db.execSQL(sql);
        sql = "CREATE TABLE IF NOT EXISTS " + Table_Recalled_Messages + " (" +
                Column_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                Column_Original_ID + " INTEGER NOT NULL, " +
                Column_Name + " TEXT NOT NULL, " +
                Column_SubName + " TEXT, " +
                Column_Message + " TEXT NOT NULL, " +
                Column_Time + " REAL NOT NULL, " +
                Column_Image + " TEXT, " +
                Column_Prev_SubName + " TEXT, " +
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_ID = "id";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Image = "image";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Message = "message";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Name = "name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Next_Message = "next_message";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Next_SubName = "next_sub_name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Original_ID = "original_name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Prev_Message = "prev_message";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Prev_SubName = "prev_sub_name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_SubName = "sub_name";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Column_Time = "time";
// 
// Path: app/src/main/java/com/qsboy/antirecall/db/DBHelper.java
// public static final String Table_Recalled_Messages = "recalls";


// Path: app/src/main/java/com/qsboy/antirecall/db/Dao.java
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import static com.qsboy.antirecall.db.DBHelper.Column_ID;
import static com.qsboy.antirecall.db.DBHelper.Column_Image;
import static com.qsboy.antirecall.db.DBHelper.Column_Message;
import static com.qsboy.antirecall.db.DBHelper.Column_Name;
import static com.qsboy.antirecall.db.DBHelper.Column_Next_Message;
import static com.qsboy.antirecall.db.DBHelper.Column_Next_SubName;
import static com.qsboy.antirecall.db.DBHelper.Column_Original_ID;
import static com.qsboy.antirecall.db.DBHelper.Column_Prev_Message;
import static com.qsboy.antirecall.db.DBHelper.Column_Prev_SubName;
import static com.qsboy.antirecall.db.DBHelper.Column_SubName;
import static com.qsboy.antirecall.db.DBHelper.Column_Time;
import static com.qsboy.antirecall.db.DBHelper.Table_Recalled_Messages;

    }

    public void deleteAll() {
        try {
            int delete1 = db.delete(Table_Recalled_Messages, null, null);
            int delete2 = db.delete("sqlite_sequence", null, null);
            int delete3 = db.delete("Jason", null, null);
            Log.i(TAG, "deleteAll: " + delete1);
            Log.i(TAG, "deleteAll: " + delete2);
            Log.i(TAG, "deleteAll: " + delete3);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void temp() {
        String sql;
        sql = "DROP TABLE " + Table_Recalled_Messages;
        db.execSQL(sql);
//        sql = "ALTER TABLE " + Table_Recalled_Messages + " RENAME TO " + Table_Recalled_Messages + "_";
//        db.execSQL(sql);
        sql = "CREATE TABLE IF NOT EXISTS " + Table_Recalled_Messages + " (" +
                Column_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                Column_Original_ID + " INTEGER NOT NULL, " +
                Column_Name + " TEXT NOT NULL, " +
                Column_SubName + " TEXT, " +
                Column_Message + " TEXT NOT NULL, " +
                Column_Time + " REAL NOT NULL, " +
                Column_Image + " TEXT, " +
                Column_Prev_SubName + " TEXT, " +
                Column_Prev_Message + " TEXT, " +