SqliteWrapper.smali

.class Lio/agora/utils/SqliteWrapper;
.super Ljava/lang/Object;


# annotations
.annotation system Ldalvik/annotation/MemberClasses;
    value = {
        Lio/agora/utils/SqliteWrapper$StorageItem;
    }
.end annotation


# static fields
.field private static final TAG:Ljava/lang/String; = "SQLITE"


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

.field private final lock:Ljava/lang/Object;


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

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

    new-instance v0, Ljava/lang/Object;

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

    iput-object v0, p0, Lio/agora/utils/SqliteWrapper;->lock:Ljava/lang/Object;

    const/4 v0, 0x0

    iput-object v0, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    return-void
.end method

.method private executeCommandOnPath(Ljava/lang/String;Ljava/lang/String;)Z
    .registers 5
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0,
            0x0
        }
        names = {
            "path",
            "cmd"
        }
    .end annotation

    invoke-direct {p0}, Lio/agora/utils/SqliteWrapper;->isDatabaseValid()Z

    move-result v0

    const/4 v1, 0x0

    if-nez v0, :cond_8

    return v1

    :cond_8
    invoke-direct {p0, p1}, Lio/agora/utils/SqliteWrapper;->isPathValid(Ljava/lang/String;)Z

    move-result p1

    if-nez p1, :cond_f

    return v1

    :cond_f
    iget-object p1, p0, Lio/agora/utils/SqliteWrapper;->lock:Ljava/lang/Object;

    monitor-enter p1

    :try_start_12
    iget-object v0, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {v0, p2}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_17
    .catch Ljava/lang/Exception; {:try_start_12 .. :try_end_17} :catch_1c
    .catchall {:try_start_12 .. :try_end_17} :catchall_1a

    const/4 p2, 0x1

    :try_start_18
    monitor-exit p1

    return p2

    :catchall_1a
    move-exception p2

    goto :goto_1e

    :catch_1c
    monitor-exit p1

    return v1

    :goto_1e
    monitor-exit p1
    :try_end_1f
    .catchall {:try_start_18 .. :try_end_1f} :catchall_1a

    throw p2
.end method

.method private isDatabaseValid()Z
    .registers 2

    iget-object v0, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    if-eqz v0, :cond_14

    invoke-virtual {v0}, Landroid/database/sqlite/SQLiteDatabase;->isOpen()Z

    move-result v0

    if-eqz v0, :cond_14

    iget-object v0, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {v0}, Landroid/database/sqlite/SQLiteDatabase;->isReadOnly()Z

    move-result v0

    if-nez v0, :cond_14

    const/4 v0, 0x1

    goto :goto_15

    :cond_14
    const/4 v0, 0x0

    :goto_15
    return v0
.end method

.method private isPathValid(Ljava/lang/String;)Z
    .registers 6
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "path"
        }
    .end annotation

    invoke-static {p1}, Landroid/text/TextUtils;->isEmpty(Ljava/lang/CharSequence;)Z

    move-result v0

    const/4 v1, 0x0

    if-eqz v0, :cond_8

    return v1

    :cond_8
    move v0, v1

    :goto_9
    invoke-virtual {p1}, Ljava/lang/String;->length()I

    move-result v2

    if-ge v0, v2, :cond_2c

    invoke-virtual {p1, v0}, Ljava/lang/String;->charAt(I)C

    move-result v2

    const/16 v3, 0x20

    if-lt v2, v3, :cond_2b

    const/16 v3, 0x7e

    if-gt v2, v3, :cond_2b

    const/16 v3, 0x22

    if-eq v2, v3, :cond_2b

    const/16 v3, 0x27

    if-eq v2, v3, :cond_2b

    const/16 v3, 0x3b

    if-ne v2, v3, :cond_28

    goto :goto_2b

    :cond_28
    add-int/lit8 v0, v0, 0x1

    goto :goto_9

    :cond_2b
    :goto_2b
    return v1

    :cond_2c
    invoke-virtual {p1}, Ljava/lang/String;->toLowerCase()Ljava/lang/String;

    move-result-object p1

    const-string v0, "sqlite_master"

    invoke-virtual {p1, v0}, Ljava/lang/String;->contains(Ljava/lang/CharSequence;)Z

    move-result p1

    xor-int/lit8 p1, p1, 0x1

    return p1
.end method


# virtual methods
.method public close()V
    .registers 3

    invoke-direct {p0}, Lio/agora/utils/SqliteWrapper;->isDatabaseValid()Z

    move-result v0

    if-nez v0, :cond_7

    return-void

    :cond_7
    iget-object v0, p0, Lio/agora/utils/SqliteWrapper;->lock:Ljava/lang/Object;

    monitor-enter v0

    :try_start_a
    iget-object v1, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {v1}, Landroid/database/sqlite/SQLiteDatabase;->close()V

    const/4 v1, 0x0

    iput-object v1, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    monitor-exit v0

    return-void

    :catchall_14
    move-exception v1

    monitor-exit v0
    :try_end_16
    .catchall {:try_start_a .. :try_end_16} :catchall_14

    throw v1
.end method

.method delete(Ljava/lang/String;Ljava/lang/String;)Z
    .registers 7
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0,
            0x0
        }
        names = {
            "path",
            "key"
        }
    .end annotation

    invoke-direct {p0}, Lio/agora/utils/SqliteWrapper;->isDatabaseValid()Z

    move-result v0

    const/4 v1, 0x0

    if-nez v0, :cond_8

    return v1

    :cond_8
    invoke-direct {p0, p1}, Lio/agora/utils/SqliteWrapper;->isPathValid(Ljava/lang/String;)Z

    move-result v0

    if-nez v0, :cond_f

    return v1

    :cond_f
    invoke-direct {p0, p2}, Lio/agora/utils/SqliteWrapper;->isPathValid(Ljava/lang/String;)Z

    move-result v0

    if-nez v0, :cond_16

    return v1

    :cond_16
    iget-object v0, p0, Lio/agora/utils/SqliteWrapper;->lock:Ljava/lang/Object;

    monitor-enter v0

    :try_start_19
    new-instance v2, Ljava/lang/StringBuilder;

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

    const-string v3, "delete from \""

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

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

    const-string p1, "\" where key = \""

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

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

    const-string p1, "\";"

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

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

    move-result-object p1
    :try_end_37
    .catchall {:try_start_19 .. :try_end_37} :catchall_41

    :try_start_37
    iget-object p2, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {p2, p1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_3c
    .catch Ljava/lang/Exception; {:try_start_37 .. :try_end_3c} :catch_3f
    .catchall {:try_start_37 .. :try_end_3c} :catchall_41

    const/4 p1, 0x1

    :try_start_3d
    monitor-exit v0

    return p1

    :catch_3f
    monitor-exit v0

    return v1

    :catchall_41
    move-exception p1

    monitor-exit v0
    :try_end_43
    .catchall {:try_start_3d .. :try_end_43} :catchall_41

    throw p1
.end method

.method public dispose()V
    .registers 3

    iget-object v0, p0, Lio/agora/utils/SqliteWrapper;->lock:Ljava/lang/Object;

    monitor-enter v0

    :try_start_3
    iget-object v1, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    if-eqz v1, :cond_12

    invoke-virtual {v1}, Landroid/database/sqlite/SQLiteDatabase;->isOpen()Z

    move-result v1

    if-eqz v1, :cond_12

    iget-object v1, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {v1}, Landroid/database/sqlite/SQLiteDatabase;->close()V

    :cond_12
    const/4 v1, 0x0

    iput-object v1, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    monitor-exit v0

    return-void

    :catchall_17
    move-exception v1

    monitor-exit v0
    :try_end_19
    .catchall {:try_start_3 .. :try_end_19} :catchall_17

    throw v1
.end method

.method drop(Ljava/lang/String;)Z
    .registers 4
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "path"
        }
    .end annotation

    new-instance v0, Ljava/lang/StringBuilder;

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

    const-string v1, "drop table if exists \""

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

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

    const-string v1, "\";"

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

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

    move-result-object v0

    invoke-direct {p0, p1, v0}, Lio/agora/utils/SqliteWrapper;->executeCommandOnPath(Ljava/lang/String;Ljava/lang/String;)Z

    move-result p1

    return p1
.end method

.method load(Ljava/lang/String;Ljava/lang/String;Z)Lio/agora/utils/SqliteWrapper$StorageItem;
    .registers 13
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0,
            0x0,
            0x0
        }
        names = {
            "query",
            "cmd",
            "testSize"
        }
    .end annotation

    invoke-direct {p0}, Lio/agora/utils/SqliteWrapper;->isDatabaseValid()Z

    move-result p3

    if-nez p3, :cond_13

    const-string p1, "SQLITE"

    const-string p2, "database is invalid"

    invoke-static {p1, p2}, Lio/agora/base/internal/Logging;->w(Ljava/lang/String;Ljava/lang/String;)V

    new-instance p1, Lio/agora/utils/SqliteWrapper$StorageItem;

    invoke-direct {p1}, Lio/agora/utils/SqliteWrapper$StorageItem;-><init>()V

    return-object p1

    :cond_13
    invoke-static {p1}, Landroid/text/TextUtils;->isEmpty(Ljava/lang/CharSequence;)Z

    move-result p3

    if-eqz p3, :cond_26

    const-string p1, "SQLITE"

    const-string p2, "query is invalid"

    invoke-static {p1, p2}, Lio/agora/base/internal/Logging;->w(Ljava/lang/String;Ljava/lang/String;)V

    new-instance p1, Lio/agora/utils/SqliteWrapper$StorageItem;

    invoke-direct {p1}, Lio/agora/utils/SqliteWrapper$StorageItem;-><init>()V

    return-object p1

    :cond_26
    invoke-static {p2}, Landroid/text/TextUtils;->isEmpty(Ljava/lang/CharSequence;)Z

    move-result p3

    if-eqz p3, :cond_39

    const-string p1, "SQLITE"

    const-string p2, "cmd is invalid"

    invoke-static {p1, p2}, Lio/agora/base/internal/Logging;->w(Ljava/lang/String;Ljava/lang/String;)V

    new-instance p1, Lio/agora/utils/SqliteWrapper$StorageItem;

    invoke-direct {p1}, Lio/agora/utils/SqliteWrapper$StorageItem;-><init>()V

    return-object p1

    :cond_39
    iget-object p3, p0, Lio/agora/utils/SqliteWrapper;->lock:Ljava/lang/Object;

    monitor-enter p3

    const/4 v0, 0x0

    const-wide/16 v1, 0x0

    :try_start_3f
    iget-object v3, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    const/4 v4, 0x0

    new-array v5, v4, [Ljava/lang/String;

    invoke-virtual {v3, p1, v5}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p1
    :try_end_48
    .catch Ljava/lang/Exception; {:try_start_3f .. :try_end_48} :catch_98
    .catchall {:try_start_3f .. :try_end_48} :catchall_96

    const/4 v3, 0x1

    if-eqz p1, :cond_59

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

    move-result v5

    if-lez v5, :cond_53

    move v5, v3

    goto :goto_54

    :cond_53
    move v5, v4

    :goto_54
    invoke-interface {p1}, Landroid/database/Cursor;->close()V

    move-object p1, v0

    goto :goto_5a

    :cond_59
    move v5, v4

    :goto_5a
    if-nez v5, :cond_64

    const-string p2, "SQLITE"

    const-string v3, "table is not exist"

    invoke-static {p2, v3}, Lio/agora/base/internal/Logging;->w(Ljava/lang/String;Ljava/lang/String;)V

    goto :goto_99

    :cond_64
    iget-object v5, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

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

    invoke-virtual {v5, p2, v4}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p1

    invoke-interface {p1}, Landroid/database/Cursor;->isClosed()Z

    move-result p2

    if-nez p2, :cond_99

    invoke-interface {p1}, Landroid/database/Cursor;->moveToFirst()Z

    move-result p2

    if-eqz p2, :cond_99

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

    move-result p2

    if-eq p2, v3, :cond_7f

    goto :goto_99

    :cond_7f
    invoke-interface {p1, v3}, Landroid/database/Cursor;->getBlob(I)[B

    move-result-object v0

    const/4 p2, 0x2

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

    move-result-wide v3
    :try_end_88
    .catch Ljava/lang/Exception; {:try_start_4b .. :try_end_88} :catch_99
    .catchall {:try_start_4b .. :try_end_88} :catchall_96

    :try_start_88
    array-length p2, v0

    const/high16 v5, 0x80000

    if-le p2, v5, :cond_91

    const-wide/32 v5, 0x80000

    goto :goto_93

    :cond_91
    array-length p2, v0
    :try_end_92
    .catchall {:try_start_88 .. :try_end_92} :catchall_96

    int-to-long v5, p2

    :goto_93
    move-wide v7, v3

    move-object v4, v0

    goto :goto_9c

    :catchall_96
    move-exception p1

    goto :goto_c0

    :catch_98
    move-object p1, v0

    :catch_99
    :cond_99
    :goto_99
    move-object v4, v0

    move-wide v5, v1

    move-wide v7, v5

    :goto_9c
    if-eqz p1, :cond_a9

    :try_start_9e
    invoke-interface {p1}, Landroid/database/Cursor;->close()V
    :try_end_a1
    .catch Ljava/lang/Exception; {:try_start_9e .. :try_end_a1} :catch_a2
    .catchall {:try_start_9e .. :try_end_a1} :catchall_96

    goto :goto_a9

    :catch_a2
    :try_start_a2
    const-string p1, "SQLITE"

    const-string p2, "cursor close exception"

    invoke-static {p1, p2}, Lio/agora/base/internal/Logging;->w(Ljava/lang/String;Ljava/lang/String;)V

    :cond_a9
    :goto_a9
    cmp-long p1, v5, v1

    if-eqz p1, :cond_b9

    array-length p1, v4

    if-nez p1, :cond_b1

    goto :goto_b9

    :cond_b1
    new-instance p1, Lio/agora/utils/SqliteWrapper$StorageItem;

    move-object v3, p1

    invoke-direct/range {v3 .. v8}, Lio/agora/utils/SqliteWrapper$StorageItem;-><init>([BJJ)V

    monitor-exit p3

    return-object p1

    :cond_b9
    :goto_b9
    new-instance p1, Lio/agora/utils/SqliteWrapper$StorageItem;

    invoke-direct {p1}, Lio/agora/utils/SqliteWrapper$StorageItem;-><init>()V

    monitor-exit p3

    return-object p1

    :goto_c0
    monitor-exit p3
    :try_end_c1
    .catchall {:try_start_a2 .. :try_end_c1} :catchall_96

    throw p1
.end method

.method public open(Ljava/lang/String;)Z
    .registers 8
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "path"
        }
    .end annotation

    invoke-direct {p0, p1}, Lio/agora/utils/SqliteWrapper;->isPathValid(Ljava/lang/String;)Z

    move-result v0

    const/4 v1, 0x0

    if-nez v0, :cond_8

    return v1

    :cond_8
    iget-object v0, p0, Lio/agora/utils/SqliteWrapper;->lock:Ljava/lang/Object;

    monitor-enter v0

    const/4 v2, 0x0

    :try_start_c
    sget v3, Landroid/os/Build$VERSION;->SDK_INT:I

    const/16 v4, 0x1c

    const/high16 v5, 0x10000000

    if-lt v3, v4, :cond_31

    new-instance v3, Landroid/database/sqlite/SQLiteDatabase$OpenParams$Builder;

    invoke-direct {v3}, Landroid/database/sqlite/SQLiteDatabase$OpenParams$Builder;-><init>()V

    invoke-virtual {v3, v5}, Landroid/database/sqlite/SQLiteDatabase$OpenParams$Builder;->setOpenFlags(I)Landroid/database/sqlite/SQLiteDatabase$OpenParams$Builder;

    const-string v4, "off"

    invoke-virtual {v3, v4}, Landroid/database/sqlite/SQLiteDatabase$OpenParams$Builder;->setJournalMode(Ljava/lang/String;)Landroid/database/sqlite/SQLiteDatabase$OpenParams$Builder;

    invoke-virtual {v3}, Landroid/database/sqlite/SQLiteDatabase$OpenParams$Builder;->build()Landroid/database/sqlite/SQLiteDatabase$OpenParams;

    move-result-object v3

    new-instance v4, Ljava/io/File;

    invoke-direct {v4, p1}, Ljava/io/File;-><init>(Ljava/lang/String;)V

    invoke-static {v4, v3}, Landroid/database/sqlite/SQLiteDatabase;->openDatabase(Ljava/io/File;Landroid/database/sqlite/SQLiteDatabase$OpenParams;)Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v3

    :goto_2e
    iput-object v3, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    goto :goto_36

    :cond_31
    invoke-static {p1, v2, v5}, Landroid/database/sqlite/SQLiteDatabase;->openDatabase(Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v3
    :try_end_35
    .catch Ljava/lang/Exception; {:try_start_c .. :try_end_35} :catch_74
    .catchall {:try_start_c .. :try_end_35} :catchall_72

    goto :goto_2e

    :goto_36
    :try_start_36
    iget-object v3, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    const-string v4, "PRAGMA TEMP_STORE = MEMORY;"

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

    iget-object v3, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    const-string v4, "PRAGMA SYNCHRONOUS = OFF;"

    invoke-virtual {v3, v4}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
    :try_end_44
    .catch Ljava/lang/Exception; {:try_start_36 .. :try_end_44} :catch_47
    .catchall {:try_start_36 .. :try_end_44} :catchall_72

    const/4 p1, 0x1

    :try_start_45
    monitor-exit v0

    return p1

    :catch_47
    move-exception v3

    invoke-virtual {v3}, Ljava/lang/Exception;->printStackTrace()V

    iget-object v3, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {v3}, Landroid/database/sqlite/SQLiteDatabase;->isOpen()Z

    move-result v3

    if-eqz v3, :cond_58

    iget-object v3, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {v3}, Landroid/database/sqlite/SQLiteDatabase;->close()V

    :cond_58
    iput-object v2, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    const-string v2, "SQLITE"

    new-instance v3, Ljava/lang/StringBuilder;

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

    const-string v4, "Can not open database: "

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

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

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

    move-result-object p1

    invoke-static {v2, p1}, Lio/agora/base/internal/Logging;->d(Ljava/lang/String;Ljava/lang/String;)V

    monitor-exit v0

    return v1

    :catchall_72
    move-exception p1

    goto :goto_9d

    :catch_74
    iget-object v3, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    if-eqz v3, :cond_83

    invoke-virtual {v3}, Landroid/database/sqlite/SQLiteDatabase;->isOpen()Z

    move-result v3

    if-eqz v3, :cond_83

    iget-object v3, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {v3}, Landroid/database/sqlite/SQLiteDatabase;->close()V

    :cond_83
    iput-object v2, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    const-string v2, "SQLITE"

    new-instance v3, Ljava/lang/StringBuilder;

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

    const-string v4, "Can not open database: "

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

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

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

    move-result-object p1

    invoke-static {v2, p1}, Lio/agora/base/internal/Logging;->d(Ljava/lang/String;Ljava/lang/String;)V

    monitor-exit v0

    return v1

    :goto_9d
    monitor-exit v0
    :try_end_9e
    .catchall {:try_start_45 .. :try_end_9e} :catchall_72

    throw p1
.end method

.method save(Ljava/lang/String;Ljava/lang/String;[BJ)J
    .registers 11
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0,
            0x0,
            0x0,
            0x0
        }
        names = {
            "path",
            "key",
            "buffer",
            "expired"
        }
    .end annotation

    invoke-direct {p0, p1}, Lio/agora/utils/SqliteWrapper;->isPathValid(Ljava/lang/String;)Z

    move-result v0

    const-wide/16 v1, 0x0

    if-nez v0, :cond_9

    return-wide v1

    :cond_9
    invoke-direct {p0, p2}, Lio/agora/utils/SqliteWrapper;->isPathValid(Ljava/lang/String;)Z

    move-result v0

    if-nez v0, :cond_10

    return-wide v1

    :cond_10
    if-eqz p3, :cond_75

    array-length v0, p3

    if-nez v0, :cond_16

    goto :goto_75

    :cond_16
    array-length v0, p3

    const/high16 v3, 0x80000

    if-lt v0, v3, :cond_1c

    return-wide v1

    :cond_1c
    invoke-virtual {p0, p1}, Lio/agora/utils/SqliteWrapper;->touch(Ljava/lang/String;)Z

    move-result v0

    if-nez v0, :cond_23

    return-wide v1

    :cond_23
    iget-object v0, p0, Lio/agora/utils/SqliteWrapper;->lock:Ljava/lang/Object;

    monitor-enter v0

    :try_start_26
    new-instance v3, Ljava/lang/StringBuilder;

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

    const-string v4, "replace into \""

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

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

    const-string p1, "\" (key, value, expired) values (\""

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

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

    const-string p1, "\", ?, "

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

    invoke-virtual {v3, p4, p5}, Ljava/lang/StringBuilder;->append(J)Ljava/lang/StringBuilder;

    const-string p1, ");"

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

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

    move-result-object p1

    const/4 p2, 0x0

    iget-object p4, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {p4}, Landroid/database/sqlite/SQLiteDatabase;->beginTransaction()V
    :try_end_52
    .catchall {:try_start_26 .. :try_end_52} :catchall_72

    :try_start_52
    iget-object p4, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {p4, p1}, Landroid/database/sqlite/SQLiteDatabase;->compileStatement(Ljava/lang/String;)Landroid/database/sqlite/SQLiteStatement;

    move-result-object p2

    const/4 p1, 0x1

    invoke-virtual {p2, p1, p3}, Landroid/database/sqlite/SQLiteStatement;->bindBlob(I[B)V

    invoke-virtual {p2}, Landroid/database/sqlite/SQLiteStatement;->execute()V
    :try_end_5f
    .catch Ljava/lang/Exception; {:try_start_52 .. :try_end_5f} :catch_61
    .catchall {:try_start_52 .. :try_end_5f} :catchall_72

    :try_start_5f
    array-length p1, p3

    int-to-long v1, p1

    :catch_61
    iget-object p1, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {p1}, Landroid/database/sqlite/SQLiteDatabase;->setTransactionSuccessful()V

    iget-object p1, p0, Lio/agora/utils/SqliteWrapper;->db:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {p1}, Landroid/database/sqlite/SQLiteDatabase;->endTransaction()V

    if-eqz p2, :cond_70

    invoke-virtual {p2}, Landroid/database/sqlite/SQLiteStatement;->close()V

    :cond_70
    monitor-exit v0

    return-wide v1

    :catchall_72
    move-exception p1

    monitor-exit v0
    :try_end_74
    .catchall {:try_start_5f .. :try_end_74} :catchall_72

    throw p1

    :cond_75
    :goto_75
    return-wide v1
.end method

.method touch(Ljava/lang/String;)Z
    .registers 4
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "path"
        }
    .end annotation

    new-instance v0, Ljava/lang/StringBuilder;

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

    const-string v1, "create table if not exists \""

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

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

    const-string v1, "\" (key text primary key, value text, expired INTEGER);"

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

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

    move-result-object v0

    invoke-direct {p0, p1, v0}, Lio/agora/utils/SqliteWrapper;->executeCommandOnPath(Ljava/lang/String;Ljava/lang/String;)Z

    move-result p1

    return p1
.end method