934 lines
22 KiB
Smali
934 lines
22 KiB
Smali
.class public Lcom/moji/areamanagement/db/AreaDatabaseOpenHelper;
|
|
.super Landroid/database/sqlite/SQLiteOpenHelper;
|
|
.source "AreaDatabaseOpenHelper.java"
|
|
|
|
|
|
# direct methods
|
|
.method public constructor <init>(Landroid/content/Context;)V
|
|
.locals 3
|
|
|
|
const-string v0, "mojiweather"
|
|
|
|
const/4 v1, 0x0
|
|
|
|
const/4 v2, 0x4
|
|
|
|
.line 28
|
|
invoke-direct {p0, p1, v0, v1, v2}, Landroid/database/sqlite/SQLiteOpenHelper;-><init>(Landroid/content/Context;Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)V
|
|
|
|
return-void
|
|
.end method
|
|
|
|
.method private a(Landroid/database/sqlite/SQLiteDatabase;)V
|
|
.locals 12
|
|
|
|
.line 72
|
|
new-instance v0, Ljava/util/ArrayList;
|
|
|
|
invoke-direct {v0}, Ljava/util/ArrayList;-><init>()V
|
|
|
|
const/4 v1, 0x0
|
|
|
|
.line 74
|
|
:try_start_0
|
|
new-instance v2, Landroid/database/sqlite/SQLiteQueryBuilder;
|
|
|
|
invoke-direct {v2}, Landroid/database/sqlite/SQLiteQueryBuilder;-><init>()V
|
|
|
|
const-string v3, "table_city"
|
|
|
|
.line 75
|
|
invoke-virtual {v2, v3}, Landroid/database/sqlite/SQLiteQueryBuilder;->setTables(Ljava/lang/String;)V
|
|
|
|
const/4 v3, 0x6
|
|
|
|
.line 76
|
|
new-array v4, v3, [Ljava/lang/String;
|
|
|
|
const-string v3, "city_id"
|
|
|
|
const/4 v10, 0x0
|
|
|
|
aput-object v3, v4, v10
|
|
|
|
const-string v3, "city_name"
|
|
|
|
const/4 v11, 0x1
|
|
|
|
aput-object v3, v4, v11
|
|
|
|
const/4 v3, 0x2
|
|
|
|
const-string v5, "is_location"
|
|
|
|
aput-object v5, v4, v3
|
|
|
|
const/4 v3, 0x3
|
|
|
|
const-string v5, "is_footstep"
|
|
|
|
aput-object v5, v4, v3
|
|
|
|
const/4 v3, 0x4
|
|
|
|
const-string v5, "street_name"
|
|
|
|
aput-object v5, v4, v3
|
|
|
|
const/4 v3, 0x5
|
|
|
|
const-string v5, "timestamp"
|
|
|
|
aput-object v5, v4, v3
|
|
|
|
const/4 v5, 0x0
|
|
|
|
const/4 v6, 0x0
|
|
|
|
const/4 v7, 0x0
|
|
|
|
const/4 v8, 0x0
|
|
|
|
const/4 v9, 0x0
|
|
|
|
move-object v3, p1
|
|
|
|
invoke-virtual/range {v2 .. v9}, Landroid/database/sqlite/SQLiteQueryBuilder;->query(Landroid/database/sqlite/SQLiteDatabase;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;
|
|
|
|
move-result-object v2
|
|
:try_end_0
|
|
.catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_1
|
|
.catchall {:try_start_0 .. :try_end_0} :catchall_1
|
|
|
|
.line 77
|
|
:goto_0
|
|
:try_start_1
|
|
invoke-interface {v2}, Landroid/database/Cursor;->moveToNext()Z
|
|
|
|
move-result v1
|
|
|
|
if-eqz v1, :cond_2
|
|
|
|
.line 78
|
|
new-instance v1, Lcom/moji/common/area/AreaInfo;
|
|
|
|
invoke-direct {v1}, Lcom/moji/common/area/AreaInfo;-><init>()V
|
|
|
|
const-string v3, "city_name"
|
|
|
|
.line 79
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getColumnIndexOrThrow(Ljava/lang/String;)I
|
|
|
|
move-result v3
|
|
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;
|
|
|
|
move-result-object v3
|
|
|
|
iput-object v3, v1, Lcom/moji/common/area/AreaInfo;->cityName:Ljava/lang/String;
|
|
|
|
const-string v3, "city_id"
|
|
|
|
.line 80
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getColumnIndexOrThrow(Ljava/lang/String;)I
|
|
|
|
move-result v3
|
|
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getInt(I)I
|
|
|
|
move-result v3
|
|
|
|
iput v3, v1, Lcom/moji/common/area/AreaInfo;->cityId:I
|
|
|
|
const-string v3, "is_location"
|
|
|
|
.line 81
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getColumnIndexOrThrow(Ljava/lang/String;)I
|
|
|
|
move-result v3
|
|
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getInt(I)I
|
|
|
|
move-result v3
|
|
|
|
if-ne v3, v11, :cond_0
|
|
|
|
const/4 v3, 0x1
|
|
|
|
goto :goto_1
|
|
|
|
:cond_0
|
|
const/4 v3, 0x0
|
|
|
|
:goto_1
|
|
iput-boolean v3, v1, Lcom/moji/common/area/AreaInfo;->isLocation:Z
|
|
|
|
const-string v3, "is_footstep"
|
|
|
|
.line 82
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getColumnIndexOrThrow(Ljava/lang/String;)I
|
|
|
|
move-result v3
|
|
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getInt(I)I
|
|
|
|
move-result v3
|
|
|
|
if-ne v3, v11, :cond_1
|
|
|
|
const/4 v3, 0x1
|
|
|
|
goto :goto_2
|
|
|
|
:cond_1
|
|
const/4 v3, 0x0
|
|
|
|
:goto_2
|
|
iput-boolean v3, v1, Lcom/moji/common/area/AreaInfo;->isFootStep:Z
|
|
|
|
const-string v3, "street_name"
|
|
|
|
.line 83
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getColumnIndexOrThrow(Ljava/lang/String;)I
|
|
|
|
move-result v3
|
|
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;
|
|
|
|
move-result-object v3
|
|
|
|
iput-object v3, v1, Lcom/moji/common/area/AreaInfo;->streetName:Ljava/lang/String;
|
|
|
|
const-string v3, "timestamp"
|
|
|
|
.line 84
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getColumnIndexOrThrow(Ljava/lang/String;)I
|
|
|
|
move-result v3
|
|
|
|
invoke-interface {v2, v3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;
|
|
|
|
move-result-object v3
|
|
|
|
iput-object v3, v1, Lcom/moji/common/area/AreaInfo;->timestamp:Ljava/lang/String;
|
|
|
|
.line 85
|
|
invoke-interface {v0, v1}, Ljava/util/List;->add(Ljava/lang/Object;)Z
|
|
|
|
goto :goto_0
|
|
|
|
:cond_2
|
|
const-string v1, "DROP TABLE table_city;"
|
|
|
|
.line 88
|
|
invoke-virtual {p1, v1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
|
|
|
|
const-string v1, "create table table_city (_id integer primary key autoincrement, city_id integer, city_index integer, city_name text, is_location integer, is_footstep integer, street_name text, timestamp text); "
|
|
|
|
.line 91
|
|
invoke-virtual {p1, v1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
|
|
|
|
.line 92
|
|
invoke-interface {v0}, Ljava/util/List;->isEmpty()Z
|
|
|
|
move-result v1
|
|
|
|
if-nez v1, :cond_3
|
|
|
|
.line 93
|
|
:goto_3
|
|
invoke-interface {v0}, Ljava/util/List;->size()I
|
|
|
|
move-result v1
|
|
|
|
if-ge v10, v1, :cond_3
|
|
|
|
.line 94
|
|
invoke-interface {v0, v10}, Ljava/util/List;->get(I)Ljava/lang/Object;
|
|
|
|
move-result-object v1
|
|
|
|
check-cast v1, Lcom/moji/common/area/AreaInfo;
|
|
|
|
.line 95
|
|
new-instance v3, Ljava/lang/StringBuilder;
|
|
|
|
invoke-direct {v3}, Ljava/lang/StringBuilder;-><init>()V
|
|
|
|
const-string v4, "insert into table_city (city_id,city_index,city_name,is_location,is_footstep, street_name,timestamp) VALUES (\'"
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
iget v4, v1, Lcom/moji/common/area/AreaInfo;->cityId:I
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
|
|
|
|
const-string v4, "\',\'"
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v3, v10}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
|
|
|
|
const-string v4, "\',\'"
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
iget-object v4, v1, Lcom/moji/common/area/AreaInfo;->cityName:Ljava/lang/String;
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
const-string v4, "\',\'"
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
iget-boolean v4, v1, Lcom/moji/common/area/AreaInfo;->isLocation:Z
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
|
|
|
|
const-string v4, "\',\'"
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
iget-boolean v4, v1, Lcom/moji/common/area/AreaInfo;->isFootStep:Z
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
|
|
|
|
const-string v4, "\',\'"
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
iget-object v4, v1, Lcom/moji/common/area/AreaInfo;->streetName:Ljava/lang/String;
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
const-string v4, "\',\'"
|
|
|
|
invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
iget-object v1, v1, Lcom/moji/common/area/AreaInfo;->timestamp:Ljava/lang/String;
|
|
|
|
invoke-virtual {v3, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
const-string v1, "\')"
|
|
|
|
invoke-virtual {v3, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v3}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
|
|
|
|
move-result-object v1
|
|
|
|
.line 97
|
|
invoke-virtual {p1, v1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
|
|
:try_end_1
|
|
.catch Ljava/lang/Exception; {:try_start_1 .. :try_end_1} :catch_0
|
|
.catchall {:try_start_1 .. :try_end_1} :catchall_0
|
|
|
|
add-int/lit8 v10, v10, 0x1
|
|
|
|
goto :goto_3
|
|
|
|
:cond_3
|
|
if-eqz v2, :cond_4
|
|
|
|
.line 104
|
|
invoke-interface {v2}, Landroid/database/Cursor;->close()V
|
|
|
|
goto :goto_5
|
|
|
|
:catchall_0
|
|
move-exception p1
|
|
|
|
goto :goto_6
|
|
|
|
:catch_0
|
|
move-exception p1
|
|
|
|
move-object v1, v2
|
|
|
|
goto :goto_4
|
|
|
|
:catchall_1
|
|
move-exception p1
|
|
|
|
move-object v2, v1
|
|
|
|
goto :goto_6
|
|
|
|
:catch_1
|
|
move-exception p1
|
|
|
|
:goto_4
|
|
:try_start_2
|
|
const-string v0, "AreaDatabaseOpenHelper"
|
|
|
|
.line 101
|
|
invoke-static {v0, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V
|
|
:try_end_2
|
|
.catchall {:try_start_2 .. :try_end_2} :catchall_1
|
|
|
|
if-eqz v1, :cond_4
|
|
|
|
.line 104
|
|
invoke-interface {v1}, Landroid/database/Cursor;->close()V
|
|
|
|
:cond_4
|
|
:goto_5
|
|
return-void
|
|
|
|
:goto_6
|
|
if-eqz v2, :cond_5
|
|
|
|
invoke-interface {v2}, Landroid/database/Cursor;->close()V
|
|
|
|
.line 106
|
|
:cond_5
|
|
throw p1
|
|
.end method
|
|
|
|
.method private a(Landroid/database/sqlite/SQLiteDatabase;I)V
|
|
.locals 0
|
|
|
|
packed-switch p2, :pswitch_data_0
|
|
|
|
goto :goto_0
|
|
|
|
.line 61
|
|
:pswitch_0
|
|
invoke-direct {p0, p1}, Lcom/moji/areamanagement/db/AreaDatabaseOpenHelper;->b(Landroid/database/sqlite/SQLiteDatabase;)V
|
|
|
|
.line 63
|
|
:pswitch_1
|
|
invoke-direct {p0, p1}, Lcom/moji/areamanagement/db/AreaDatabaseOpenHelper;->c(Landroid/database/sqlite/SQLiteDatabase;)V
|
|
|
|
.line 65
|
|
:pswitch_2
|
|
invoke-direct {p0, p1}, Lcom/moji/areamanagement/db/AreaDatabaseOpenHelper;->d(Landroid/database/sqlite/SQLiteDatabase;)V
|
|
|
|
:goto_0
|
|
return-void
|
|
|
|
:pswitch_data_0
|
|
.packed-switch 0x1
|
|
:pswitch_0
|
|
:pswitch_1
|
|
:pswitch_2
|
|
.end packed-switch
|
|
.end method
|
|
|
|
.method private a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)Z
|
|
.locals 4
|
|
|
|
const-string v0, "select sql from sqlite_master where type = \'table\' and name = \'%s\'"
|
|
|
|
const/4 v1, 0x1
|
|
|
|
.line 184
|
|
new-array v2, v1, [Ljava/lang/Object;
|
|
|
|
const/4 v3, 0x0
|
|
|
|
aput-object p2, v2, v3
|
|
|
|
invoke-static {v0, v2}, Ljava/lang/String;->format(Ljava/lang/String;[Ljava/lang/Object;)Ljava/lang/String;
|
|
|
|
move-result-object p2
|
|
|
|
const/4 v0, 0x0
|
|
|
|
.line 185
|
|
invoke-virtual {p1, p2, v0}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;
|
|
|
|
move-result-object p1
|
|
|
|
if-eqz p1, :cond_1
|
|
|
|
.line 188
|
|
:try_start_0
|
|
invoke-interface {p1}, Landroid/database/Cursor;->moveToFirst()Z
|
|
|
|
move-result p2
|
|
|
|
if-eqz p2, :cond_1
|
|
|
|
const-string p2, "sql"
|
|
|
|
.line 189
|
|
invoke-interface {p1, p2}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I
|
|
|
|
move-result p2
|
|
|
|
invoke-interface {p1, p2}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;
|
|
|
|
move-result-object v0
|
|
:try_end_0
|
|
.catchall {:try_start_0 .. :try_end_0} :catchall_0
|
|
|
|
goto :goto_0
|
|
|
|
:catchall_0
|
|
move-exception p2
|
|
|
|
if-eqz p1, :cond_0
|
|
|
|
.line 193
|
|
invoke-interface {p1}, Landroid/database/Cursor;->close()V
|
|
|
|
.line 194
|
|
:cond_0
|
|
throw p2
|
|
|
|
:cond_1
|
|
:goto_0
|
|
if-eqz p1, :cond_2
|
|
|
|
.line 193
|
|
invoke-interface {p1}, Landroid/database/Cursor;->close()V
|
|
|
|
:cond_2
|
|
if-eqz v0, :cond_3
|
|
|
|
.line 196
|
|
invoke-virtual {v0, p3}, Ljava/lang/String;->contains(Ljava/lang/CharSequence;)Z
|
|
|
|
move-result p1
|
|
|
|
if-eqz p1, :cond_3
|
|
|
|
return v1
|
|
|
|
:cond_3
|
|
return v3
|
|
.end method
|
|
|
|
.method private b(Landroid/database/sqlite/SQLiteDatabase;)V
|
|
.locals 1
|
|
|
|
const-string v0, "create table table_city (_id integer primary key autoincrement, city_id integer, city_index integer, city_name text, is_location integer, is_footstep integer, street_name text, timestamp text)"
|
|
|
|
.line 112
|
|
invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
|
|
|
|
return-void
|
|
.end method
|
|
|
|
.method private c(Landroid/database/sqlite/SQLiteDatabase;)V
|
|
.locals 10
|
|
|
|
const/4 v0, 0x0
|
|
|
|
.line 118
|
|
:try_start_0
|
|
new-instance v1, Landroid/database/sqlite/SQLiteQueryBuilder;
|
|
|
|
invoke-direct {v1}, Landroid/database/sqlite/SQLiteQueryBuilder;-><init>()V
|
|
|
|
const-string v2, "table_city"
|
|
|
|
.line 119
|
|
invoke-virtual {v1, v2}, Landroid/database/sqlite/SQLiteQueryBuilder;->setTables(Ljava/lang/String;)V
|
|
|
|
const/4 v2, 0x1
|
|
|
|
.line 120
|
|
new-array v3, v2, [Ljava/lang/String;
|
|
|
|
const-string v2, "city_id"
|
|
|
|
const/4 v9, 0x0
|
|
|
|
aput-object v2, v3, v9
|
|
|
|
const/4 v4, 0x0
|
|
|
|
const/4 v5, 0x0
|
|
|
|
const/4 v6, 0x0
|
|
|
|
const/4 v7, 0x0
|
|
|
|
const/4 v8, 0x0
|
|
|
|
move-object v2, p1
|
|
|
|
invoke-virtual/range {v1 .. v8}, Landroid/database/sqlite/SQLiteQueryBuilder;->query(Landroid/database/sqlite/SQLiteDatabase;[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
|
|
:try_end_0
|
|
.catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_1
|
|
.catchall {:try_start_0 .. :try_end_0} :catchall_1
|
|
|
|
.line 122
|
|
:goto_0
|
|
:try_start_1
|
|
invoke-interface {v1}, Landroid/database/Cursor;->moveToNext()Z
|
|
|
|
move-result v0
|
|
|
|
if-eqz v0, :cond_0
|
|
|
|
const-string v0, "city_id"
|
|
|
|
.line 123
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getColumnIndexOrThrow(Ljava/lang/String;)I
|
|
|
|
move-result v0
|
|
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getInt(I)I
|
|
|
|
move-result v0
|
|
|
|
.line 124
|
|
new-instance v2, Ljava/lang/StringBuilder;
|
|
|
|
invoke-direct {v2}, Ljava/lang/StringBuilder;-><init>()V
|
|
|
|
const-string v3, "update table_city set city_index="
|
|
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v2, v9}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
|
|
|
|
const-string v3, " where "
|
|
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
const-string v3, "city_id"
|
|
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
const-string v3, "="
|
|
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v2, v0}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
|
|
|
|
const-string v0, ";"
|
|
|
|
invoke-virtual {v2, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
|
|
|
|
move-result-object v0
|
|
|
|
.line 127
|
|
invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
|
|
:try_end_1
|
|
.catch Ljava/lang/Exception; {:try_start_1 .. :try_end_1} :catch_0
|
|
.catchall {:try_start_1 .. :try_end_1} :catchall_0
|
|
|
|
add-int/lit8 v9, v9, 0x1
|
|
|
|
goto :goto_0
|
|
|
|
:cond_0
|
|
if-eqz v1, :cond_1
|
|
|
|
.line 134
|
|
invoke-interface {v1}, Landroid/database/Cursor;->close()V
|
|
|
|
goto :goto_2
|
|
|
|
:catchall_0
|
|
move-exception p1
|
|
|
|
goto :goto_3
|
|
|
|
:catch_0
|
|
move-exception p1
|
|
|
|
move-object v0, v1
|
|
|
|
goto :goto_1
|
|
|
|
:catchall_1
|
|
move-exception p1
|
|
|
|
move-object v1, v0
|
|
|
|
goto :goto_3
|
|
|
|
:catch_1
|
|
move-exception p1
|
|
|
|
:goto_1
|
|
:try_start_2
|
|
const-string v1, "AreaDatabaseOpenHelper"
|
|
|
|
.line 131
|
|
invoke-static {v1, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V
|
|
:try_end_2
|
|
.catchall {:try_start_2 .. :try_end_2} :catchall_1
|
|
|
|
if-eqz v0, :cond_1
|
|
|
|
.line 134
|
|
invoke-interface {v0}, Landroid/database/Cursor;->close()V
|
|
|
|
:cond_1
|
|
:goto_2
|
|
return-void
|
|
|
|
:goto_3
|
|
if-eqz v1, :cond_2
|
|
|
|
invoke-interface {v1}, Landroid/database/Cursor;->close()V
|
|
|
|
.line 136
|
|
:cond_2
|
|
throw p1
|
|
.end method
|
|
|
|
.method private d(Landroid/database/sqlite/SQLiteDatabase;)V
|
|
.locals 10
|
|
|
|
const/4 v0, 0x0
|
|
|
|
:try_start_0
|
|
const-string v1, "table_city"
|
|
|
|
const-string v2, "is_footstep"
|
|
|
|
.line 145
|
|
invoke-direct {p0, p1, v1, v2}, Lcom/moji/areamanagement/db/AreaDatabaseOpenHelper;->a(Landroid/database/sqlite/SQLiteDatabase;Ljava/lang/String;Ljava/lang/String;)Z
|
|
|
|
move-result v1
|
|
|
|
if-eqz v1, :cond_0
|
|
|
|
return-void
|
|
|
|
:cond_0
|
|
const-string v1, "alter table table_city add column is_footstep integer;"
|
|
|
|
.line 150
|
|
invoke-virtual {p1, v1}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
|
|
|
|
.line 151
|
|
new-instance v2, Landroid/database/sqlite/SQLiteQueryBuilder;
|
|
|
|
invoke-direct {v2}, Landroid/database/sqlite/SQLiteQueryBuilder;-><init>()V
|
|
|
|
const-string v1, "table_city"
|
|
|
|
.line 153
|
|
invoke-virtual {v2, v1}, Landroid/database/sqlite/SQLiteQueryBuilder;->setTables(Ljava/lang/String;)V
|
|
|
|
const/4 v1, 0x1
|
|
|
|
.line 154
|
|
new-array v4, v1, [Ljava/lang/String;
|
|
|
|
const/4 v1, 0x0
|
|
|
|
const-string v3, "is_footstep"
|
|
|
|
aput-object v3, v4, v1
|
|
|
|
const/4 v5, 0x0
|
|
|
|
const/4 v6, 0x0
|
|
|
|
const/4 v7, 0x0
|
|
|
|
const/4 v8, 0x0
|
|
|
|
const/4 v9, 0x0
|
|
|
|
move-object v3, p1
|
|
|
|
invoke-virtual/range {v2 .. v9}, Landroid/database/sqlite/SQLiteQueryBuilder;->query(Landroid/database/sqlite/SQLiteDatabase;[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
|
|
:try_end_0
|
|
.catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_1
|
|
.catchall {:try_start_0 .. :try_end_0} :catchall_1
|
|
|
|
.line 155
|
|
:goto_0
|
|
:try_start_1
|
|
invoke-interface {v1}, Landroid/database/Cursor;->moveToNext()Z
|
|
|
|
move-result v0
|
|
|
|
if-eqz v0, :cond_1
|
|
|
|
const-string v0, "city_id"
|
|
|
|
.line 156
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getColumnIndexOrThrow(Ljava/lang/String;)I
|
|
|
|
move-result v0
|
|
|
|
invoke-interface {v1, v0}, Landroid/database/Cursor;->getInt(I)I
|
|
|
|
move-result v0
|
|
|
|
.line 157
|
|
new-instance v2, Ljava/lang/StringBuilder;
|
|
|
|
invoke-direct {v2}, Ljava/lang/StringBuilder;-><init>()V
|
|
|
|
const-string v3, "update table_city set is_footstep= 0 where city_id="
|
|
|
|
invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v2, v0}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
|
|
|
|
const-string v0, ";"
|
|
|
|
invoke-virtual {v2, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
|
|
|
|
move-result-object v0
|
|
|
|
.line 160
|
|
invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V
|
|
:try_end_1
|
|
.catch Ljava/lang/Exception; {:try_start_1 .. :try_end_1} :catch_0
|
|
.catchall {:try_start_1 .. :try_end_1} :catchall_0
|
|
|
|
goto :goto_0
|
|
|
|
:cond_1
|
|
if-eqz v1, :cond_2
|
|
|
|
.line 166
|
|
invoke-interface {v1}, Landroid/database/Cursor;->close()V
|
|
|
|
goto :goto_2
|
|
|
|
:catchall_0
|
|
move-exception p1
|
|
|
|
move-object v0, v1
|
|
|
|
goto :goto_3
|
|
|
|
:catch_0
|
|
move-exception p1
|
|
|
|
move-object v0, v1
|
|
|
|
goto :goto_1
|
|
|
|
:catchall_1
|
|
move-exception p1
|
|
|
|
goto :goto_3
|
|
|
|
:catch_1
|
|
move-exception p1
|
|
|
|
:goto_1
|
|
:try_start_2
|
|
const-string v1, "AreaDatabaseOpenHelper"
|
|
|
|
.line 163
|
|
invoke-static {v1, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V
|
|
:try_end_2
|
|
.catchall {:try_start_2 .. :try_end_2} :catchall_1
|
|
|
|
if-eqz v0, :cond_2
|
|
|
|
.line 166
|
|
invoke-interface {v0}, Landroid/database/Cursor;->close()V
|
|
|
|
:cond_2
|
|
:goto_2
|
|
return-void
|
|
|
|
:goto_3
|
|
if-eqz v0, :cond_3
|
|
|
|
invoke-interface {v0}, Landroid/database/Cursor;->close()V
|
|
|
|
.line 168
|
|
:cond_3
|
|
throw p1
|
|
.end method
|
|
|
|
|
|
# virtual methods
|
|
.method public onCreate(Landroid/database/sqlite/SQLiteDatabase;)V
|
|
.locals 2
|
|
|
|
const-string v0, "AreaDatabaseOpenHelper"
|
|
|
|
const-string v1, "populating new database"
|
|
|
|
.line 33
|
|
invoke-static {v0, v1}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V
|
|
|
|
const/4 v0, 0x0
|
|
|
|
const/4 v1, 0x4
|
|
|
|
.line 34
|
|
invoke-virtual {p0, p1, v0, v1}, Lcom/moji/areamanagement/db/AreaDatabaseOpenHelper;->onUpgrade(Landroid/database/sqlite/SQLiteDatabase;II)V
|
|
|
|
return-void
|
|
.end method
|
|
|
|
.method public onDowngrade(Landroid/database/sqlite/SQLiteDatabase;II)V
|
|
.locals 1
|
|
|
|
const/4 v0, 0x4
|
|
|
|
if-ne p3, v0, :cond_1
|
|
|
|
const/4 v0, 0x2
|
|
|
|
if-ne p2, v0, :cond_0
|
|
|
|
const-string p1, "AreaDatabaseOpenHelper"
|
|
|
|
.line 48
|
|
new-instance p2, Ljava/lang/StringBuilder;
|
|
|
|
invoke-direct {p2}, Ljava/lang/StringBuilder;-><init>()V
|
|
|
|
const-string v0, "downgradeTo:"
|
|
|
|
invoke-virtual {p2, v0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {p2, p3}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;
|
|
|
|
const-string p3, " do nothing"
|
|
|
|
invoke-virtual {p2, p3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
|
|
|
invoke-virtual {p2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;
|
|
|
|
move-result-object p2
|
|
|
|
invoke-static {p1, p2}, Lcom/moji/tool/log/MJLogger;->c(Ljava/lang/String;Ljava/lang/String;)V
|
|
|
|
goto :goto_0
|
|
|
|
.line 50
|
|
:cond_0
|
|
invoke-direct {p0, p1}, Lcom/moji/areamanagement/db/AreaDatabaseOpenHelper;->a(Landroid/database/sqlite/SQLiteDatabase;)V
|
|
|
|
:cond_1
|
|
:goto_0
|
|
return-void
|
|
.end method
|
|
|
|
.method public onUpgrade(Landroid/database/sqlite/SQLiteDatabase;II)V
|
|
.locals 0
|
|
|
|
:goto_0
|
|
add-int/lit8 p2, p2, 0x1
|
|
|
|
if-gt p2, p3, :cond_0
|
|
|
|
.line 40
|
|
invoke-direct {p0, p1, p2}, Lcom/moji/areamanagement/db/AreaDatabaseOpenHelper;->a(Landroid/database/sqlite/SQLiteDatabase;I)V
|
|
|
|
goto :goto_0
|
|
|
|
:cond_0
|
|
return-void
|
|
.end method
|