OrionSdkSQLiteHelper.smali

.class public Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;
.super Landroid/database/sqlite/SQLiteOpenHelper;


# annotations
.annotation system Ldalvik/annotation/MemberClasses;
    value = {
        Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper$OrionSdkSQLiteHelperHolder;
    }
.end annotation


# static fields
.field public static final DB_NAME:Ljava/lang/String; = "orion_sdk.db"

.field public static final DB_VERSION:I = 0x4

.field static final TABLE_SEARCH_HISTORY:Ljava/lang/String; = "search_history"

.field static final TABLE_SKILL_DETAIL_LOCAL:Ljava/lang/String; = "skill_detail_local"

.field static final TABLE_SPEAKER_HISTORY_LOCAL:Ljava/lang/String; = "speaker_history_local"


# direct methods
.method public constructor <init>()V
    .registers 5

    invoke-static {}, Lcom/sdk/orion/orion/OrionClient;->getOrionContext()Landroid/content/Context;

    move-result-object v0

    const-string/jumbo v1, "orion_sdk.db"

    const/4 v2, 0x0

    const/4 v3, 0x4

    invoke-direct {p0, v0, v1, v2, v3}, Landroid/database/sqlite/SQLiteOpenHelper;-><init>(Landroid/content/Context;Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)V

    return-void
.end method

.method private createSearchHistoryTable(Landroid/database/sqlite/SQLiteDatabase;)V
    .registers 5

    :try_start_0
    const-string/jumbo v0, "CREATE TABLE IF NOT EXISTS search_history(id integer primary key autoincrement,item_key TEXT)"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_6
    .catch Landroid/database/sqlite/SQLiteException; {:try_start_0 .. :try_end_6} :catch_7

    :goto_6
    return-void

    :catch_7
    move-exception v0

    new-instance v1, Ljava/lang/StringBuilder;

    invoke-direct {v1}, Ljava/lang/StringBuilder;-><init>()V

    const-string/jumbo v2, "createSkillDetailLocalTable SQLiteException !"

    invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v1

    invoke-virtual {v0}, Landroid/database/sqlite/SQLiteException;->getMessage()Ljava/lang/String;

    move-result-object v0

    invoke-virtual {v1, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v0

    invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/h/r/Logger;->d(Ljava/lang/Object;)V

    goto :goto_6
.end method

.method private createSkillDetailTable(Landroid/database/sqlite/SQLiteDatabase;)V
    .registers 5

    :try_start_0
    const-string/jumbo v0, "CREATE TABLE IF NOT EXISTS skill_detail_local(id integer primary key autoincrement,url TEXT,response TEXT)"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_6
    .catch Landroid/database/sqlite/SQLiteException; {:try_start_0 .. :try_end_6} :catch_7

    :goto_6
    return-void

    :catch_7
    move-exception v0

    new-instance v1, Ljava/lang/StringBuilder;

    invoke-direct {v1}, Ljava/lang/StringBuilder;-><init>()V

    const-string/jumbo v2, "createSkillDetailLocalTable SQLiteException !"

    invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v1

    invoke-virtual {v0}, Landroid/database/sqlite/SQLiteException;->getMessage()Ljava/lang/String;

    move-result-object v0

    invoke-virtual {v1, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v0

    invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/h/r/Logger;->d(Ljava/lang/Object;)V

    goto :goto_6
.end method

.method private createSpeakerHistoryTable(Landroid/database/sqlite/SQLiteDatabase;)V
    .registers 5

    :try_start_0
    const-string/jumbo v0, "CREATE TABLE IF NOT EXISTS speaker_history_local(id integer primary key autoincrement,user_id varchar(60),sn varchar(60),json_text TEXT)"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_6
    .catch Landroid/database/sqlite/SQLiteException; {:try_start_0 .. :try_end_6} :catch_7

    :goto_6
    return-void

    :catch_7
    move-exception v0

    new-instance v1, Ljava/lang/StringBuilder;

    invoke-direct {v1}, Ljava/lang/StringBuilder;-><init>()V

    const-string/jumbo v2, "createSpeakerHistoryLocalTable SQLiteException !"

    invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v1

    invoke-virtual {v0}, Landroid/database/sqlite/SQLiteException;->getMessage()Ljava/lang/String;

    move-result-object v0

    invoke-virtual {v1, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v0

    invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/h/r/Logger;->d(Ljava/lang/Object;)V

    goto :goto_6
.end method

.method private dropTable(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;)V
    .registers 5

    new-instance v0, Ljava/lang/StringBuilder;

    invoke-direct {v0}, Ljava/lang/StringBuilder;-><init>()V

    const-string/jumbo v1, "DROP TABLE IF EXISTS "

    invoke-virtual {v0, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v0

    invoke-virtual {v0, p2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v0

    invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v0

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    return-void
.end method

.method public static getInstance()Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;
    .registers 1

    # getter for: Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper$OrionSdkSQLiteHelperHolder;->INSTANCE:Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;
    invoke-static {}, Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper$OrionSdkSQLiteHelperHolder;->access$000()Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;

    move-result-object v0

    return-object v0
.end method


# virtual methods
.method public onCreate(Landroid/database/sqlite/SQLiteDatabase;)V
    .registers 2

    invoke-direct {p0, p1}, Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;->createSpeakerHistoryTable(Landroid/database/sqlite/SQLiteDatabase;)V

    invoke-direct {p0, p1}, Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;->createSkillDetailTable(Landroid/database/sqlite/SQLiteDatabase;)V

    invoke-direct {p0, p1}, Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;->createSearchHistoryTable(Landroid/database/sqlite/SQLiteDatabase;)V

    return-void
.end method

.method public onUpgrade(Landroid/database/sqlite/SQLiteDatabase;II)V
    .registers 5

    const-string/jumbo v0, "speaker_history_local"

    invoke-direct {p0, p1, v0}, Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;->dropTable(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;)V

    const-string/jumbo v0, "skill_detail_local"

    invoke-direct {p0, p1, v0}, Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;->dropTable(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;)V

    const-string/jumbo v0, "search_history"

    invoke-direct {p0, p1, v0}, Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;->dropTable(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;)V

    invoke-virtual {p0, p1}, Lcom/sdk/orion/ui/baselibrary/db/OrionSdkSQLiteHelper;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V

    return-void
.end method