.class public Lcom/brsdk/android/utils/f;
.super Ljava/lang/Object;
.source "BRSQLite.java"


# annotations
.annotation system Ldalvik/annotation/MemberClasses;
    value = {
        Lcom/brsdk/android/utils/f$a;
    }
.end annotation


# static fields
.field private static a:Lcom/brsdk/android/utils/f;

.field private static final c:[Ljava/lang/String;


# instance fields
.field private b:Landroid/database/sqlite/SQLiteDatabase;


# direct methods
.method static constructor <clinit>()V
    .locals 5

    .line 17
    new-instance v0, Lcom/brsdk/android/utils/f;

    invoke-direct {v0}, Lcom/brsdk/android/utils/f;-><init>()V

    sput-object v0, Lcom/brsdk/android/utils/f;->a:Lcom/brsdk/android/utils/f;

    const-string v0, "`channel`"

    const-string v1, "`user_id`"

    const-string v2, "`account`"

    const-string v3, "`password`"

    const-string v4, "`update`"

    .line 24
    filled-new-array {v0, v1, v2, v3, v4}, [Ljava/lang/String;

    move-result-object v0

    sput-object v0, Lcom/brsdk/android/utils/f;->c:[Ljava/lang/String;

    return-void
.end method

.method private constructor <init>()V
    .locals 3

    .line 27
    invoke-direct {p0}, Ljava/lang/Object;-><init>()V

    .line 29
    :try_start_0
    new-instance v0, Ljava/io/File;

    invoke-static {}, Lcom/brsdk/android/utils/BRUtils;->g()Ljava/io/File;

    move-result-object v1

    const-string v2, "user"

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

    .line 30
    invoke-virtual {v0}, Ljava/io/File;->getParentFile()Ljava/io/File;

    move-result-object v1

    invoke-virtual {v1}, Ljava/io/File;->exists()Z

    move-result v1

    if-nez v1, :cond_0

    invoke-virtual {v0}, Ljava/io/File;->getParentFile()Ljava/io/File;

    move-result-object v1

    invoke-virtual {v1}, Ljava/io/File;->mkdirs()Z

    move-result v1

    if-eqz v1, :cond_1

    .line 31
    :cond_0
    invoke-virtual {v0}, Ljava/io/File;->exists()Z

    move-result v1

    if-nez v1, :cond_2

    invoke-virtual {v0}, Ljava/io/File;->createNewFile()Z

    move-result v1

    if-eqz v1, :cond_1

    goto :goto_0

    .line 32
    :cond_1
    new-instance v1, Ljava/io/IOException;

    invoke-virtual {v0}, Ljava/io/File;->getAbsolutePath()Ljava/lang/String;

    move-result-object v0

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

    throw v1

    :cond_2
    :goto_0
    const/4 v1, 0x0

    .line 34
    invoke-static {v0, v1}, Landroid/database/sqlite/SQLiteDatabase;->openOrCreateDatabase(Ljava/io/File;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;)Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    iput-object v0, p0, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    .line 36
    iget-object v0, p0, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    const-string v1, "CREATE TABLE IF NOT EXISTS record(`channel` TEXT, `user_id` TEXT, `account` TEXT, `password` TEXT, `update` LONG);"

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

    .line 42
    iget-object v0, p0, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    const-string v1, "CREATE UNIQUE INDEX IF NOT EXISTS user_unique ON record(`channel`, `user_id`, `account`)"

    invoke-virtual {v0, v1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_0
    .catch Ljava/lang/Throwable; {:try_start_0 .. :try_end_0} :catch_0

    goto :goto_1

    :catch_0
    move-exception v0

    const/4 v1, 0x0

    .line 45
    new-array v1, v1, [Ljava/lang/Object;

    const-string v2, "Failed to create"

    invoke-static {v0, v2, v1}, Lcom/brsdk/android/utils/BRLogger;->e(Ljava/lang/Throwable;Ljava/lang/String;[Ljava/lang/Object;)V

    :goto_1
    return-void
.end method

.method private static a(Landroid/database/Cursor;)Lcom/brsdk/android/utils/f$a;
    .locals 3

    .line 131
    new-instance v0, Lcom/brsdk/android/utils/f$a;

    invoke-direct {v0}, Lcom/brsdk/android/utils/f$a;-><init>()V

    const-string v1, "channel"

    .line 132
    invoke-interface {p0, v1}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I

    move-result v1

    invoke-interface {p0, v1}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v1

    iput-object v1, v0, Lcom/brsdk/android/utils/f$a;->a:Ljava/lang/String;

    const-string v1, "user_id"

    .line 133
    invoke-interface {p0, v1}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I

    move-result v1

    invoke-interface {p0, v1}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v1

    iput-object v1, v0, Lcom/brsdk/android/utils/f$a;->b:Ljava/lang/String;

    const-string v1, "account"

    .line 134
    invoke-interface {p0, v1}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I

    move-result v1

    invoke-interface {p0, v1}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v1

    iput-object v1, v0, Lcom/brsdk/android/utils/f$a;->c:Ljava/lang/String;

    const-string v1, "password"

    .line 135
    invoke-interface {p0, v1}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I

    move-result v1

    invoke-interface {p0, v1}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v1

    iput-object v1, v0, Lcom/brsdk/android/utils/f$a;->d:Ljava/lang/String;

    const-string v1, "update"

    .line 136
    invoke-interface {p0, v1}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I

    move-result v1

    invoke-interface {p0, v1}, Landroid/database/Cursor;->getLong(I)J

    move-result-wide v1

    iput-wide v1, v0, Lcom/brsdk/android/utils/f$a;->e:J

    return-object v0
.end method

.method public static a()Lcom/brsdk/android/utils/f;
    .locals 1

    .line 20
    sget-object v0, Lcom/brsdk/android/utils/f;->a:Lcom/brsdk/android/utils/f;

    return-object v0
.end method

.method public static a(Lcom/brsdk/android/utils/f$a;)V
    .locals 4

    .line 96
    invoke-static {}, Lcom/brsdk/android/utils/f;->a()Lcom/brsdk/android/utils/f;

    move-result-object v0

    iget-object v0, v0, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    invoke-static {v0}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v0

    if-nez v0, :cond_1

    invoke-static {p0}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v0

    if-eqz v0, :cond_0

    goto :goto_0

    .line 99
    :cond_0
    invoke-static {}, Lcom/brsdk/android/core/c;->k()Ljava/lang/String;

    move-result-object v0

    .line 100
    invoke-static {}, Lcom/brsdk/android/utils/f;->a()Lcom/brsdk/android/utils/f;

    move-result-object v1

    iget-object v1, v1, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    const/4 v2, 0x3

    new-array v2, v2, [Ljava/lang/String;

    const/4 v3, 0x0

    aput-object v0, v2, v3

    const/4 v0, 0x1

    iget-object v3, p0, Lcom/brsdk/android/utils/f$a;->b:Ljava/lang/String;

    aput-object v3, v2, v0

    const/4 v0, 0x2

    iget-object p0, p0, Lcom/brsdk/android/utils/f$a;->c:Ljava/lang/String;

    aput-object p0, v2, v0

    const-string p0, "record"

    const-string v0, "`channel` = ? AND `user_id` = ? AND `account` = ?"

    invoke-virtual {v1, p0, v0, v2}, Landroid/database/sqlite/SQLiteDatabase;->delete(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)I

    :cond_1
    :goto_0
    return-void
.end method

.method public static a(Ljava/lang/String;Ljava/lang/String;)V
    .locals 4

    .line 121
    invoke-static {}, Lcom/brsdk/android/utils/f;->a()Lcom/brsdk/android/utils/f;

    move-result-object v0

    iget-object v0, v0, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    invoke-static {v0}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v0

    if-nez v0, :cond_1

    invoke-static {p0}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v0

    if-eqz v0, :cond_0

    goto :goto_0

    .line 123
    :cond_0
    new-instance v0, Landroid/content/ContentValues;

    invoke-direct {v0}, Landroid/content/ContentValues;-><init>()V

    const-string v1, "password"

    .line 124
    invoke-virtual {v0, v1, p1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 125
    invoke-static {}, Lcom/brsdk/android/utils/f;->a()Lcom/brsdk/android/utils/f;

    move-result-object p1

    iget-object p1, p1, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    const/4 v1, 0x2

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    .line 127
    invoke-static {}, Lcom/brsdk/android/core/c;->k()Ljava/lang/String;

    move-result-object v3

    aput-object v3, v1, v2

    const/4 v2, 0x1

    aput-object p0, v1, v2

    const-string p0, "record"

    const-string v2, "`channel` = ? AND `user_id` = ?"

    .line 125
    invoke-virtual {p1, p0, v0, v2, v1}, Landroid/database/sqlite/SQLiteDatabase;->update(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;)I

    :cond_1
    :goto_0
    return-void
.end method

.method public static a(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
    .locals 5

    .line 106
    invoke-static {}, Lcom/brsdk/android/utils/f;->a()Lcom/brsdk/android/utils/f;

    move-result-object v0

    iget-object v0, v0, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    invoke-static {v0}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v0

    if-nez v0, :cond_1

    .line 107
    invoke-static {p1}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v0

    if-nez v0, :cond_1

    invoke-static {p0}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v0

    if-eqz v0, :cond_0

    goto :goto_0

    .line 110
    :cond_0
    invoke-static {}, Lcom/brsdk/android/core/c;->k()Ljava/lang/String;

    move-result-object v0

    .line 111
    invoke-static {}, Ljava/lang/System;->currentTimeMillis()J

    move-result-wide v1

    invoke-static {v1, v2}, Ljava/lang/String;->valueOf(J)Ljava/lang/String;

    move-result-object v1

    .line 112
    invoke-static {}, Lcom/brsdk/android/utils/f;->a()Lcom/brsdk/android/utils/f;

    move-result-object v2

    iget-object v2, v2, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    const/4 v3, 0x5

    new-array v3, v3, [Ljava/lang/String;

    const/4 v4, 0x0

    aput-object v0, v3, v4

    const/4 v0, 0x1

    aput-object p0, v3, v0

    const/4 p0, 0x2

    aput-object p1, v3, p0

    const/4 p0, 0x3

    aput-object p2, v3, p0

    const/4 p0, 0x4

    aput-object v1, v3, p0

    const-string p0, "INSERT OR REPLACE INTO record (`channel`, `user_id`, `account`, `password`, `update`) VALUES (?, ?, ?, ?, ?)"

    invoke-virtual {v2, p0, v3}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;[Ljava/lang/Object;)V

    :cond_1
    :goto_0
    return-void
.end method

.method public static b()Lcom/brsdk/android/utils/f$a;
    .locals 11

    .line 50
    invoke-static {}, Lcom/brsdk/android/utils/f;->c()Ljava/util/List;

    move-result-object v0

    invoke-static {v0}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v0

    const/4 v1, 0x0

    if-eqz v0, :cond_0

    return-object v1

    .line 53
    :cond_0
    invoke-static {}, Lcom/brsdk/android/core/c;->k()Ljava/lang/String;

    move-result-object v0

    .line 54
    invoke-static {}, Lcom/brsdk/android/utils/f;->a()Lcom/brsdk/android/utils/f;

    move-result-object v2

    iget-object v3, v2, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    sget-object v5, Lcom/brsdk/android/utils/f;->c:[Ljava/lang/String;

    const/4 v2, 0x1

    new-array v7, v2, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object v0, v7, v2

    const/4 v8, 0x0

    const/4 v9, 0x0

    const-string v4, "record"

    const-string v6, "`channel` = ?"

    const-string v10, "`update` DESC"

    invoke-virtual/range {v3 .. v10}, Landroid/database/sqlite/SQLiteDatabase;->query(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v0

    .line 58
    invoke-static {v0}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v2

    if-nez v2, :cond_3

    invoke-interface {v0}, Landroid/database/Cursor;->getCount()I

    move-result v2

    if-nez v2, :cond_1

    goto :goto_0

    .line 65
    :cond_1
    invoke-interface {v0}, Landroid/database/Cursor;->moveToNext()Z

    move-result v2

    if-eqz v2, :cond_2

    .line 66
    invoke-static {v0}, Lcom/brsdk/android/utils/f;->a(Landroid/database/Cursor;)Lcom/brsdk/android/utils/f$a;

    move-result-object v1

    .line 68
    :cond_2
    invoke-interface {v0}, Landroid/database/Cursor;->close()V

    return-object v1

    .line 59
    :cond_3
    :goto_0
    invoke-static {v0}, Lcom/brsdk/android/utils/BRUtils;->isNotEmpty(Ljava/lang/Object;)Z

    move-result v2

    if-eqz v2, :cond_4

    .line 60
    invoke-interface {v0}, Landroid/database/Cursor;->close()V

    :cond_4
    return-object v1
.end method

.method public static c()Ljava/util/List;
    .locals 11
    .annotation system Ldalvik/annotation/Signature;
        value = {
            "()",
            "Ljava/util/List<",
            "Lcom/brsdk/android/utils/f$a;",
            ">;"
        }
    .end annotation

    .line 73
    new-instance v0, Ljava/util/ArrayList;

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

    .line 74
    invoke-static {}, Lcom/brsdk/android/utils/f;->a()Lcom/brsdk/android/utils/f;

    move-result-object v1

    iget-object v1, v1, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    invoke-static {v1}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v1

    if-eqz v1, :cond_0

    return-object v0

    .line 77
    :cond_0
    invoke-static {}, Lcom/brsdk/android/core/c;->k()Ljava/lang/String;

    move-result-object v1

    .line 78
    invoke-static {}, Lcom/brsdk/android/utils/f;->a()Lcom/brsdk/android/utils/f;

    move-result-object v2

    iget-object v3, v2, Lcom/brsdk/android/utils/f;->b:Landroid/database/sqlite/SQLiteDatabase;

    sget-object v5, Lcom/brsdk/android/utils/f;->c:[Ljava/lang/String;

    const/4 v2, 0x1

    new-array v7, v2, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object v1, v7, v2

    const/4 v8, 0x0

    const/4 v9, 0x0

    const-string v4, "record"

    const-string v6, "`channel` = ?"

    const-string v10, "`update` DESC"

    invoke-virtual/range {v3 .. v10}, Landroid/database/sqlite/SQLiteDatabase;->query(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v1

    .line 82
    invoke-static {v1}, Lcom/brsdk/android/utils/BRUtils;->isEmpty(Ljava/lang/Object;)Z

    move-result v2

    if-nez v2, :cond_3

    invoke-interface {v1}, Landroid/database/Cursor;->getCount()I

    move-result v2

    if-nez v2, :cond_1

    goto :goto_1

    .line 88
    :cond_1
    :goto_0
    invoke-interface {v1}, Landroid/database/Cursor;->moveToNext()Z

    move-result v2

    if-eqz v2, :cond_2

    .line 89
    invoke-static {v1}, Lcom/brsdk/android/utils/f;->a(Landroid/database/Cursor;)Lcom/brsdk/android/utils/f$a;

    move-result-object v2

    invoke-interface {v0, v2}, Ljava/util/List;->add(Ljava/lang/Object;)Z

    goto :goto_0

    .line 91
    :cond_2
    invoke-interface {v1}, Landroid/database/Cursor;->close()V

    return-object v0

    .line 83
    :cond_3
    :goto_1
    invoke-static {v1}, Lcom/brsdk/android/utils/BRUtils;->isNotEmpty(Ljava/lang/Object;)Z

    move-result v2

    if-eqz v2, :cond_4

    .line 84
    invoke-interface {v1}, Landroid/database/Cursor;->close()V

    :cond_4
    return-object v0
.end method