b.smali

.class public final Lcom/proxy/ad/b/a/b;
.super Landroid/database/sqlite/SQLiteOpenHelper;


# static fields
.field private static a:Lcom/proxy/ad/b/a/b;


# direct methods
.method private constructor <init>(Landroid/content/Context;Ljava/lang/String;)V
    .registers 5

    const/4 v0, 0x0

    const/16 v1, 0xb

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

    const-string p1, "DBHelper"

    const-string p2, "DbOpenHelper newInstance"

    invoke-static {p1, p2}, Lcom/proxy/ad/log/Logger;->d(Ljava/lang/String;Ljava/lang/String;)V

    return-void
.end method

.method public static declared-synchronized a()Lcom/proxy/ad/b/a/b;
    .registers 4

    const-class v0, Lcom/proxy/ad/b/a/b;

    monitor-enter v0

    :try_start_3
    sget-object v1, Lcom/proxy/ad/b/a/b;->a:Lcom/proxy/ad/b/a/b;

    if-nez v1, :cond_12

    new-instance v1, Lcom/proxy/ad/b/a/b;

    sget-object v2, Lcom/proxy/ad/a/a/a;->a:Landroid/content/Context;

    const-string v3, "bigo_ads_sdk.db"

    invoke-direct {v1, v2, v3}, Lcom/proxy/ad/b/a/b;-><init>(Landroid/content/Context;Ljava/lang/String;)V

    sput-object v1, Lcom/proxy/ad/b/a/b;->a:Lcom/proxy/ad/b/a/b;

    :cond_12
    sget-object v1, Lcom/proxy/ad/b/a/b;->a:Lcom/proxy/ad/b/a/b;
    :try_end_14
    .catchall {:try_start_3 .. :try_end_14} :catchall_16

    monitor-exit v0

    return-object v1

    :catchall_16
    move-exception v1

    monitor-exit v0

    throw v1
.end method

.method public static b()V
    .registers 1

    const/4 v0, 0x0

    sput-object v0, Lcom/proxy/ad/b/a/b;->a:Lcom/proxy/ad/b/a/b;

    return-void
.end method


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

    const-string v0, "DBHelper"

    const-string v1, "onCreate start"

    invoke-static {v0, v1}, Lcom/proxy/ad/log/Logger;->d(Ljava/lang/String;Ljava/lang/String;)V

    const-string v1, "CREATE TABLE IF NOT EXISTS tb_download (_id INTEGER PRIMARY KEY AUTOINCREMENT,id TEXT NOT NULL UNIQUE,url TEXT NOT NULL UNIQUE,filepath TEXT NOT NULL ,filename TEXT NOT NULL ,filetype INTEGER DEFAULT 0 NOT NULL,saved_size LONG DEFAULT 0 NOT NULL,total_size LONG DEFAULT 0 NOT NULL,states INTEGER DEFAULT 0 NOT NULL,last_endtime LONG DEFAULT 0 NOT NULL,download_count INTEGER DEFAULT 0 NOT NULL,ext TEXT,ctime LONG DEFAULT 0 NOT NULL,mtime LONG DEFAULT 0 NOT NULL,UNIQUE (filepath,filename));"

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

    const-string v1, "CREATE TABLE IF NOT EXISTS tb_addata (_id INTEGER PRIMARY KEY AUTOINCREMENT,id TEXT,creative_id TEXT NOT NULL,pid TEXT NOT NULL,slot TEXT NOT NULL,adn_name TEXT NOT NULL,ad_type  INTEGER DEFAULT 0 NOT NULL,adx_type  INTEGER DEFAULT 0 NOT NULL,title TEXT,description TEXT,cta TEXT,landing_url TEXT,deeplink_url TEXT,des_name TEXT,image_url TEXT,video_url TEXT,video_config TEXT,cid LONG DEFAULT 0 NOT NULL,sid LONG DEFAULT 0 NOT NULL,adx_json TEXT NOT NULL,start_time LONG DEFAULT 0 ,end_time LONG DEFAULT 0 ,expire_time LONG DEFAULT 0 ,ad_style INTEGER DEFAULT 0 ,dsp_type INTEGER DEFAULT 1 ,skip INTEGER DEFAULT 0 ,skip_switch INTEGER DEFAULT 1 ,series_id TEXT ,display_interval LONG DEFAULT 0 ,display_total INTEGER DEFAULT 0 ,cur_display_num INTEGER DEFAULT 0 ,last_display_time LONG DEFAULT 0 ,data_hash INTEGER DEFAULT 0 ,ad_flag INTEGER DEFAULT 1 ,webview_flag INTEGER DEFAULT 0 ,ad_duration INTEGER DEFAULT 6 ,ext TEXT,ctime LONG DEFAULT 0 NOT NULL,mtime LONG DEFAULT 0 NOT NULL,hashtag_id TEXT,org_verification_account TEXT,land_title TEXT );"

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

    const-string v1, "CREATE TABLE IF NOT EXISTS tb_event (_id INTEGER PRIMARY KEY AUTOINCREMENT,id TEXT NOT NULL UNIQUE,event_type INTEGER,event_info TEXT NOT NULL,states INTEGER DEFAULT 0 NOT NULL,ext TEXT,ctime LONG DEFAULT 0 NOT NULL,mtime LONG DEFAULT 0 NOT NULL,UNIQUE (id));"

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

    const-string v1, "CREATE TABLE IF NOT EXISTS tb_tracker (_id INTEGER PRIMARY KEY AUTOINCREMENT,id TEXT NOT NULL UNIQUE,tracker_info TEXT NOT NULL,last_retry_ts LONG DEFAULT 0 NOT NULL,ext TEXT,ctime LONG DEFAULT 0 NOT NULL,mtime LONG DEFAULT 0 NOT NULL,UNIQUE (id));"

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

    const-string v1, "CREATE TABLE IF NOT EXISTS tb_winnotice (_id INTEGER PRIMARY KEY AUTOINCREMENT,id TEXT NOT NULL UNIQUE,winnotice_info TEXT NOT NULL,ext TEXT,ctime LONG DEFAULT 0 NOT NULL,mtime LONG DEFAULT 0 NOT NULL,UNIQUE (id));"

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

    const-string p1, "onCreate end"

    invoke-static {v0, p1}, Lcom/proxy/ad/log/Logger;->d(Ljava/lang/String;Ljava/lang/String;)V

    return-void
.end method

.method public final onDowngrade(Landroid/database/sqlite/SQLiteDatabase;II)V
    .registers 6

    new-instance v0, Ljava/lang/StringBuilder;

    const-string v1, "onDowngrade oldVersion="

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

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

    const-string v1, ",newVersion="

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

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

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

    move-result-object v0

    const-string v1, "DBHelper"

    invoke-static {v1, v0}, Lcom/proxy/ad/log/Logger;->d(Ljava/lang/String;Ljava/lang/String;)V

    invoke-super {p0, p1, p2, p3}, Landroid/database/sqlite/SQLiteOpenHelper;->onDowngrade(Landroid/database/sqlite/SQLiteDatabase;II)V

    return-void
.end method

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

    new-instance v0, Ljava/lang/StringBuilder;

    const-string v1, "Upgrading database from version "

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

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

    const-string v1, " to "

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

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

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

    move-result-object p3

    const-string v0, "DBHelper"

    invoke-static {v0, p3}, Lcom/proxy/ad/log/Logger;->i(Ljava/lang/String;Ljava/lang/String;)V

    const/4 p3, 0x3

    if-ge p2, p3, :cond_59

    :try_start_1e
    const-string p3, "ALTER TABLE tb_addata ADD COLUMN ad_style INTEGER DEFAULT 0 "

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN dsp_type INTEGER DEFAULT 1 "

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN skip INTEGER DEFAULT 0 "

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

    const-string p3, " ALTER TABLE tb_addata ADD COLUMN skip_switch INTEGER DEFAULT 1 NOT NULL"

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN series_id TEXT"

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN display_interval LONG DEFAULT 0 NOT NULL"

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN display_total INTEGER DEFAULT 0 NOT NULL"

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN cur_display_num INTEGER DEFAULT 0 NOT NULL"

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN data_hash INTEGER DEFAULT 0 NOT NULL"

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN last_display_time LONG DEFAULT 0"

    invoke-virtual {p1, p3}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_50
    .catchall {:try_start_1e .. :try_end_50} :catchall_51

    goto :goto_59

    :catchall_51
    move-exception p3

    invoke-static {p3}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object p3

    invoke-static {v0, p3}, Lcom/proxy/ad/log/Logger;->e(Ljava/lang/String;Ljava/lang/String;)V

    :cond_59
    :goto_59
    const/4 p3, 0x4

    if-ge p2, p3, :cond_6a

    :try_start_5c
    const-string p3, "ALTER TABLE tb_addata ADD COLUMN ad_flag INTEGER DEFAULT 1"

    invoke-virtual {p1, p3}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_61
    .catchall {:try_start_5c .. :try_end_61} :catchall_62

    goto :goto_6a

    :catchall_62
    move-exception p3

    invoke-static {p3}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object p3

    invoke-static {v0, p3}, Lcom/proxy/ad/log/Logger;->e(Ljava/lang/String;Ljava/lang/String;)V

    :cond_6a
    :goto_6a
    const/4 p3, 0x5

    if-ge p2, p3, :cond_80

    :try_start_6d
    const-string p3, "ALTER TABLE tb_addata ADD COLUMN webview_flag INTEGER DEFAULT 0"

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN ad_duration INTEGER DEFAULT 6"

    invoke-virtual {p1, p3}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_77
    .catchall {:try_start_6d .. :try_end_77} :catchall_78

    goto :goto_80

    :catchall_78
    move-exception p3

    invoke-static {p3}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object p3

    invoke-static {v0, p3}, Lcom/proxy/ad/log/Logger;->e(Ljava/lang/String;Ljava/lang/String;)V

    :cond_80
    :goto_80
    const/4 p3, 0x6

    if-ge p2, p3, :cond_91

    :try_start_83
    const-string p3, "ALTER TABLE tb_addata ADD COLUMN adn_name TEXT"

    invoke-virtual {p1, p3}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_88
    .catchall {:try_start_83 .. :try_end_88} :catchall_89

    goto :goto_91

    :catchall_89
    move-exception p3

    invoke-static {p3}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object p3

    invoke-static {v0, p3}, Lcom/proxy/ad/log/Logger;->e(Ljava/lang/String;Ljava/lang/String;)V

    :cond_91
    :goto_91
    const/4 p3, 0x7

    if-ge p2, p3, :cond_a2

    :try_start_94
    const-string p3, "ALTER TABLE tb_download ADD COLUMN filetype INTEGER DEFAULT 0"

    invoke-virtual {p1, p3}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_99
    .catchall {:try_start_94 .. :try_end_99} :catchall_9a

    goto :goto_a2

    :catchall_9a
    move-exception p3

    invoke-static {p3}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object p3

    invoke-static {v0, p3}, Lcom/proxy/ad/log/Logger;->e(Ljava/lang/String;Ljava/lang/String;)V

    :cond_a2
    :goto_a2
    const/16 p3, 0x8

    if-ge p2, p3, :cond_be

    :try_start_a6
    const-string p3, "ALTER TABLE tb_addata ADD COLUMN hashtag_id TEXT"

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN org_verification_account TEXT"

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

    const-string p3, "ALTER TABLE tb_addata ADD COLUMN land_title TEXT"

    invoke-virtual {p1, p3}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_b5
    .catchall {:try_start_a6 .. :try_end_b5} :catchall_b6

    goto :goto_be

    :catchall_b6
    move-exception p3

    invoke-static {p3}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object p3

    invoke-static {v0, p3}, Lcom/proxy/ad/log/Logger;->e(Ljava/lang/String;Ljava/lang/String;)V

    :cond_be
    :goto_be
    const/16 p3, 0x9

    if-ge p2, p3, :cond_c7

    const-string p3, "CREATE TABLE IF NOT EXISTS tb_event (_id INTEGER PRIMARY KEY AUTOINCREMENT,id TEXT NOT NULL UNIQUE,event_type INTEGER,event_info TEXT NOT NULL,states INTEGER DEFAULT 0 NOT NULL,ext TEXT,ctime LONG DEFAULT 0 NOT NULL,mtime LONG DEFAULT 0 NOT NULL,UNIQUE (id));"

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

    :cond_c7
    const/16 p3, 0xa

    if-ge p2, p3, :cond_d0

    const-string p3, "CREATE TABLE IF NOT EXISTS tb_tracker (_id INTEGER PRIMARY KEY AUTOINCREMENT,id TEXT NOT NULL UNIQUE,tracker_info TEXT NOT NULL,last_retry_ts LONG DEFAULT 0 NOT NULL,ext TEXT,ctime LONG DEFAULT 0 NOT NULL,mtime LONG DEFAULT 0 NOT NULL,UNIQUE (id));"

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

    :cond_d0
    const/16 p3, 0xb

    if-ge p2, p3, :cond_d9

    const-string p2, "CREATE TABLE IF NOT EXISTS tb_winnotice (_id INTEGER PRIMARY KEY AUTOINCREMENT,id TEXT NOT NULL UNIQUE,winnotice_info TEXT NOT NULL,ext TEXT,ctime LONG DEFAULT 0 NOT NULL,mtime LONG DEFAULT 0 NOT NULL,UNIQUE (id));"

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

    :cond_d9
    return-void
.end method