Info Call to SQLite query API

Description

Improper SQL query construction could lead to SQL injection. An SQL injection attack consists of injecting of an SQL query via the input data from the client to the application

Recommendation

This entry is informative, no recommendations applicable.

Technical details

Method com.android.insecurebankv2.TrackUserContentProvider.query() calling method android.database.sqlite.SQLiteQueryBuilder.query()


    public android.database.Cursor query(android.net.Uri p10, String[] p11, String p12, String[] p13, String p14)
    {
        android.database.sqlite.SQLiteQueryBuilder v0_1 = new android.database.sqlite.SQLiteQueryBuilder();
        v0_1.setTables("names");
        if (com.android.insecurebankv2.TrackUserContentProvider.uriMatcher.match(p10) == 1) {
            v0_1.setProjectionMap(com.android.insecurebankv2.TrackUserContentProvider.values);
            if ((p14 == null) || (p14 == "")) {
                p14 = "name";
            }
            android.database.Cursor v1_3 = v0_1.query(this.db, p11, p12, p13, 0, 0, p14);
            v1_3.setNotificationUri(this.getContext().getContentResolver(), p10);
            return v1_3;
        } else {
            android.content.ContentResolver v2_4 = new StringBuilder();
            v2_4.append("Unknown URI ");
            v2_4.append(p10);
            throw new IllegalArgumentException(v2_4.toString());
        }
    }

Method com.google.android.gms.tagmanager.zzby.zzd() calling method android.database.sqlite.SQLiteDatabase.update()


    private void zzd(long p6, long p8)
    {
        android.database.sqlite.SQLiteDatabase v0_1 = this.zzer("Error opening database for getNumStoredHits.");
        if (v0_1 != null) {
            android.content.ContentValues v1_1 = new android.content.ContentValues();
            v1_1.put("hit_first_send_time", Long.valueOf(p8));
            try {
                String[] v2_1 = new String[1];
                v2_1[0] = String.valueOf(p6);
                v0_1.update("gtm_hits", v1_1, "hit_id=?", v2_1);
                return;
            } catch (String v8) {
                String v8_3 = new StringBuilder();
                v8_3.append("Error setting HIT_FIRST_DISPATCH_TIME for hitId: ");
                v8_3.append(p6);
                com.google.android.gms.tagmanager.zzbg.zzaC(v8_3.toString());
                this.zzq(p6);
                return;
            }
        } else {
            return;
        }
    }

Method com.android.insecurebankv2.TrackUserContentProvider.update() calling method android.database.sqlite.SQLiteDatabase.update()


    public int update(android.net.Uri p5, android.content.ContentValues p6, String p7, String[] p8)
    {
        if (com.android.insecurebankv2.TrackUserContentProvider.uriMatcher.match(p5) == 1) {
            int v0 = this.db.update("names", p6, p7, p8);
            this.getContext().getContentResolver().notifyChange(p5, 0);
            return v0;
        } else {
            int v2_2 = new StringBuilder();
            v2_2.append("Unknown URI ");
            v2_2.append(p5);
            throw new IllegalArgumentException(v2_2.toString());
        }
    }

Method com.google.android.gms.analytics.internal.zzj.zzb() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    private long zzb(String p3, String[] p4)
    {
        String v1_1 = 0;
        try {
            String v4_2 = this.getWritableDatabase().rawQuery(p3, p4);
            try {
                if (!v4_2.moveToFirst()) {
                    throw new android.database.sqlite.SQLiteException("Database returned empty set");
                } else {
                    android.database.sqlite.SQLiteException v0_4 = v4_2.getLong(0);
                    if (v4_2 != null) {
                        v4_2.close();
                    }
                    return v0_4;
                }
            } catch (Throwable v3_1) {
                if (v4_2 != null) {
                    v4_2.close();
                }
                throw v3_1;
            } catch (android.database.sqlite.SQLiteException v0_2) {
                v1_1 = v4_2;
                this.zzd("Database error", p3, v0_2);
                throw v0_2;
            }
        } catch (Throwable v3_1) {
            v4_2 = v1_1;
        } catch (android.database.sqlite.SQLiteException v0_2) {
        }
    }

Method com.google.android.gms.analytics.internal.zzj.zza() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    private long zza(String p3, String[] p4, long p5)
    {
        String v1 = 0;
        try {
            String v4_2 = this.getWritableDatabase().rawQuery(p3, p4);
            try {
                if (!v4_2.moveToFirst()) {
                    if (v4_2 != null) {
                        v4_2.close();
                    }
                    return p5;
                } else {
                    long v5_2 = v4_2.getLong(0);
                    if (v4_2 != null) {
                        v4_2.close();
                    }
                    return v5_2;
                }
            } catch (Throwable v3_1) {
                v1 = v4_2;
                if (v1 != null) {
                    v1.close();
                }
                throw v3_1;
            } catch (long v5_3) {
                v1 = v4_2;
                this.zzd("Database error", p3, v5_3);
                throw v5_3;
            }
        } catch (Throwable v3_1) {
        } catch (long v5_3) {
        }
    }

Method com.google.android.gms.tagmanager.zzw.zzyE() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    private int zzyE()
    {
        String v0_2 = this.zzer("Error opening database for getNumStoredEntries.");
        int v1_1 = 0;
        if (v0_2 != null) {
            long v2_1 = 0;
            try {
                String v0_3 = v0_2.rawQuery("SELECT COUNT(*) from datalayer", 0);
                try {
                    if (v0_3.moveToFirst()) {
                        v1_1 = ((int) v0_3.getLong(0));
                    }
                } catch (int v1_0) {
                    v2_1 = v0_3;
                    if (v2_1 != 0) {
                        v2_1.close();
                    }
                    throw v1_0;
                } catch (long v2) {
                    v2_1 = v0_3;
                    com.google.android.gms.tagmanager.zzbg.zzaC("Error getting numStoredEntries");
                    if (v2_1 == 0) {
                        return v1_1;
                    } else {
                        v2_1.close();
                        return v1_1;
                    }
                }
                if (v0_3 == null) {
                    return v1_1;
                } else {
                    v0_3.close();
                    return v1_1;
                }
            } catch (int v1_0) {
            } catch (String v0) {
            }
        } else {
            return 0;
        }
    }

Method com.google.android.gms.tagmanager.zzby.zzzc() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    int zzzc()
    {
        String v0_2 = this.zzer("Error opening database for getNumStoredHits.");
        int v1_1 = 0;
        if (v0_2 != null) {
            long v2_1 = 0;
            try {
                String v0_3 = v0_2.rawQuery("SELECT COUNT(*) from gtm_hits", 0);
                try {
                    if (v0_3.moveToFirst()) {
                        v1_1 = ((int) v0_3.getLong(0));
                    }
                } catch (int v1_0) {
                    v2_1 = v0_3;
                    if (v2_1 != 0) {
                        v2_1.close();
                    }
                    throw v1_0;
                } catch (long v2) {
                    v2_1 = v0_3;
                    com.google.android.gms.tagmanager.zzbg.zzaC("Error getting numStoredHits");
                    if (v2_1 == 0) {
                        return v1_1;
                    } else {
                        v2_1.close();
                        return v1_1;
                    }
                }
                if (v0_3 == null) {
                    return v1_1;
                } else {
                    v0_3.close();
                    return v1_1;
                }
            } catch (int v1_0) {
            } catch (String v0) {
            }
        } else {
            return 0;
        }
    }

Method com.google.android.gms.tagmanager.zzw$zza.onOpen() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    public void onOpen(android.database.sqlite.SQLiteDatabase p3)
    {
        if (android.os.Build$VERSION.SDK_INT < 15) {
            String v0_5 = p3.rawQuery("PRAGMA journal_mode=memory", 0);
            try {
                v0_5.moveToFirst();
                v0_5.close();
            } catch (Throwable v1_2) {
                v0_5.close();
                throw v1_2;
            }
        }
        if (this.zza("datalayer", p3)) {
            this.zzc(p3);
            return;
        } else {
            p3.execSQL(com.google.android.gms.tagmanager.zzw.zzyG());
            return;
        }
    }

Method com.google.android.gms.tagmanager.zzw$zza.zzc() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    private void zzc(android.database.sqlite.SQLiteDatabase p5)
    {
        android.database.sqlite.SQLiteException v5_9 = p5.rawQuery("SELECT * FROM datalayer WHERE 0", 0);
        String v0_5 = new java.util.HashSet();
        try {
            String[] v1_1 = v5_9.getColumnNames();
            int v2 = 0;
        } catch (String v0_1) {
            v5_9.close();
            throw v0_1;
        }
        while (v2 < v1_1.length) {
            v0_5.add(v1_1[v2]);
            v2++;
        }
        v5_9.close();
        if ((v0_5.remove("key")) && ((v0_5.remove("value")) && ((v0_5.remove("ID")) && (v0_5.remove("expires"))))) {
            if (v0_5.isEmpty()) {
                return;
            } else {
                throw new android.database.sqlite.SQLiteException("Database has extra columns");
            }
        } else {
            throw new android.database.sqlite.SQLiteException("Database column missing");
        }
    }

Method com.google.android.gms.tagmanager.zzby$zzb.onOpen() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    public void onOpen(android.database.sqlite.SQLiteDatabase p3)
    {
        if (android.os.Build$VERSION.SDK_INT < 15) {
            String v0_5 = p3.rawQuery("PRAGMA journal_mode=memory", 0);
            try {
                v0_5.moveToFirst();
                v0_5.close();
            } catch (Throwable v1_2) {
                v0_5.close();
                throw v1_2;
            }
        }
        if (this.zza("gtm_hits", p3)) {
            this.zzc(p3);
            return;
        } else {
            p3.execSQL(com.google.android.gms.tagmanager.zzby.zzze());
            return;
        }
    }

Method com.google.android.gms.tagmanager.zzby$zzb.zzc() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    private void zzc(android.database.sqlite.SQLiteDatabase p5)
    {
        android.database.sqlite.SQLiteException v5_9 = p5.rawQuery("SELECT * FROM gtm_hits WHERE 0", 0);
        String v0_5 = new java.util.HashSet();
        try {
            String[] v1_1 = v5_9.getColumnNames();
            int v2 = 0;
        } catch (String v0_1) {
            v5_9.close();
            throw v0_1;
        }
        while (v2 < v1_1.length) {
            v0_5.add(v1_1[v2]);
            v2++;
        }
        v5_9.close();
        if ((v0_5.remove("hit_id")) && ((v0_5.remove("hit_url")) && ((v0_5.remove("hit_time")) && (v0_5.remove("hit_first_send_time"))))) {
            if (v0_5.isEmpty()) {
                return;
            } else {
                throw new android.database.sqlite.SQLiteException("Database has extra columns");
            }
        } else {
            throw new android.database.sqlite.SQLiteException("Database column missing");
        }
    }

Method com.google.android.gms.analytics.internal.zzj$zza.onOpen() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    public void onOpen(android.database.sqlite.SQLiteDatabase p3)
    {
        if (android.os.Build$VERSION.SDK_INT < 15) {
            String v0_8 = p3.rawQuery("PRAGMA journal_mode=memory", 0);
            try {
                v0_8.moveToFirst();
                v0_8.close();
            } catch (Throwable v1_2) {
                v0_8.close();
                throw v1_2;
            }
        }
        if (this.zza(p3, "hits2")) {
            this.zza(p3);
        } else {
            p3.execSQL(com.google.android.gms.analytics.internal.zzj.zziw());
        }
        if (this.zza(p3, "properties")) {
            this.zzb(p3);
            return;
        } else {
            p3.execSQL("CREATE TABLE IF NOT EXISTS properties ( app_uid INTEGER NOT NULL, cid TEXT NOT NULL, tid TEXT NOT NULL, params TEXT NOT NULL, adid INTEGER NOT NULL, hits_count INTEGER NOT NULL, PRIMARY KEY (app_uid, cid, tid)) ;");
            return;
        }
    }

Method com.google.android.gms.analytics.internal.zzj$zza.zzb() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    private java.util.Set zzb(android.database.sqlite.SQLiteDatabase p4, String p5)
    {
        java.util.HashSet v0_1 = new java.util.HashSet();
        int v1_3 = new StringBuilder();
        v1_3.append("SELECT * FROM ");
        v1_3.append(p5);
        v1_3.append(" LIMIT 0");
        android.database.Cursor v4_1 = p4.rawQuery(v1_3.toString(), 0);
        try {
            Throwable v5_2 = v4_1.getColumnNames();
            int v1_1 = 0;
        } catch (Throwable v5_3) {
            v4_1.close();
            throw v5_3;
        }
        while (v1_1 < v5_2.length) {
            v0_1.add(v5_2[v1_1]);
            v1_1++;
        }
        v4_1.close();
        return v0_1;
    }

Method com.google.android.gms.ads.internal.purchase.zzh.getRecordCount() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    public int getRecordCount()
    {
        try {
            android.database.sqlite.SQLiteException v1_1 = this.getWritableDatabase();
        } catch (android.database.sqlite.SQLiteException v1_4) {
            throw v1_4;
        }
        if (v1_1 != null) {
            int v3_2 = 0;
            try {
                android.database.sqlite.SQLiteException v1_5 = v1_1.rawQuery("select count(*) from InAppPurchase", 0);
                try {
                    if (!v1_5.moveToFirst()) {
                        if (v1_5 == null) {
                            return 0;
                        } else {
                            v1_5.close();
                            return 0;
                        }
                    } else {
                        int v3_3 = v1_5.getInt(0);
                        if (v1_5 != null) {
                            v1_5.close();
                        }
                        return v3_3;
                    }
                } catch (Throwable v2_0) {
                    v3_2 = v1_5;
                    if (v3_2 != 0) {
                        v3_2.close();
                    }
                    throw v2_0;
                } catch (int v3_1) {
                    v3_2 = v1_5;
                    android.database.sqlite.SQLiteException v1_0 = v3_1;
                    StringBuilder v4_1 = new StringBuilder();
                    v4_1.append("Error getting record count");
                    v4_1.append(v1_0.getMessage());
                    com.google.android.gms.ads.internal.util.client.zzb.zzaC(v4_1.toString());
                    if (v3_2 == 0) {
                        return 0;
                    } else {
                        v3_2.close();
                        return 0;
                    }
                }
            } catch (Throwable v2_0) {
            } catch (android.database.sqlite.SQLiteException v1_0) {
            }
        } else {
            return 0;
        }
    }

Method com.google.android.gms.analytics.internal.zzj.zzc() calling method android.database.sqlite.SQLiteDatabase.insert()


    public void zzc(com.google.android.gms.analytics.internal.zzab p6)
    {
        com.google.android.gms.common.internal.zzu.zzu(p6);
        this.zzhO();
        this.zzia();
        Long v0_5 = com.google.android.gms.analytics.internal.zzj.zze(p6);
        if (v0_5.length() <= 8192) {
            this.zziu();
            android.database.sqlite.SQLiteDatabase v1_0 = this.getWritableDatabase();
            String v2_1 = new android.content.ContentValues();
            v2_1.put("hit_string", v0_5);
            v2_1.put("hit_time", Long.valueOf(p6.zzjW()));
            v2_1.put("hit_app_id", Integer.valueOf(p6.zzjU()));
            v2_1.put("hit_url", this.zzd(p6));
            try {
                Long v0_4 = v1_0.insert("hits2", 0, v2_1);
            } catch (String v6_2) {
                this.zze("Error storing a hit", v6_2);
                return;
            }
            if (v0_4 != -1) {
                this.zzb("Hit saved to database. db-id, hit", Long.valueOf(v0_4), p6);
                return;
            } else {
                this.zzaX("Failed to insert a hit (got -1)");
                return;
            }
        } else {
            this.zzhQ().zza(p6, "Hit length exceeds the maximum allowed size");
            return;
        }
    }

Method com.google.android.gms.tagmanager.zzw.zzc() calling method android.database.sqlite.SQLiteDatabase.insert()


    private void zzc(java.util.List p6, long p7)
    {
        android.database.sqlite.SQLiteDatabase v0_1 = this.zzer("Error opening database for writeEntryToDatabase.");
        if (v0_1 != null) {
            java.util.Iterator v6_1 = p6.iterator();
            while (v6_1.hasNext()) {
                String v1_1 = ((com.google.android.gms.tagmanager.zzw$zzb) v6_1.next());
                android.content.ContentValues v2_1 = new android.content.ContentValues();
                v2_1.put("expires", Long.valueOf(p7));
                v2_1.put("key", v1_1.zztw);
                v2_1.put("value", v1_1.zzaLy);
                v0_1.insert("datalayer", 0, v2_1);
            }
            return;
        } else {
            return;
        }
    }

Method com.google.android.gms.tagmanager.zzby.zzh() calling method android.database.sqlite.SQLiteDatabase.insert()


    private void zzh(long p4, String p6)
    {
        android.database.sqlite.SQLiteDatabase v0_1 = this.zzer("Error opening database for putHit");
        if (v0_1 != null) {
            android.content.ContentValues v1_1 = new android.content.ContentValues();
            v1_1.put("hit_time", Long.valueOf(p4));
            v1_1.put("hit_url", p6);
            v1_1.put("hit_first_send_time", Integer.valueOf(0));
            try {
                v0_1.insert("gtm_hits", 0, v1_1);
                this.zzaMu.zzan(0);
                return;
            } catch (String v4) {
                com.google.android.gms.tagmanager.zzbg.zzaC("Error storing hit");
                return;
            }
        } else {
            return;
        }
    }

Method com.google.android.gms.ads.internal.purchase.zzh.zzb() calling method android.database.sqlite.SQLiteDatabase.insert()


    public void zzb(com.google.android.gms.ads.internal.purchase.zzf p7)
    {
        if (p7 != 0) {
            try {
                long v1_2 = this.getWritableDatabase();
            } catch (long v7_3) {
                throw v7_3;
            }
            if (v1_2 != 0) {
                android.content.ContentValues v2_1 = new android.content.ContentValues();
                v2_1.put("product_id", p7.zzAT);
                v2_1.put("developer_payload", p7.zzAS);
                v2_1.put("record_time", Long.valueOf(android.os.SystemClock.elapsedRealtime()));
                p7.zzAR = v1_2.insert("InAppPurchase", 0, v2_1);
                if (((long) this.getRecordCount()) > 20000) {
                    this.zzfg();
                }
                return;
            } else {
                return;
            }
        } else {
            return;
        }
    }

Method com.android.insecurebankv2.TrackUserContentProvider.insert() calling method android.database.sqlite.SQLiteDatabase.insert()


    public android.net.Uri insert(android.net.Uri p6, android.content.ContentValues p7)
    {
        long v0_1 = this.db.insert("names", "", p7);
        if (v0_1 <= 0) {
            String v3_0 = new StringBuilder();
            v3_0.append("Failed to add a record into ");
            v3_0.append(p6);
            throw new android.database.SQLException(v3_0.toString());
        } else {
            android.database.SQLException v2_3 = android.content.ContentUris.withAppendedId(com.android.insecurebankv2.TrackUserContentProvider.CONTENT_URI, v0_1);
            this.getContext().getContentResolver().notifyChange(v2_3, 0);
            return v2_3;
        }
    }

Method com.google.android.gms.tagmanager.zzw$zza.onOpen() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void onOpen(android.database.sqlite.SQLiteDatabase p3)
    {
        if (android.os.Build$VERSION.SDK_INT < 15) {
            String v0_5 = p3.rawQuery("PRAGMA journal_mode=memory", 0);
            try {
                v0_5.moveToFirst();
                v0_5.close();
            } catch (Throwable v1_2) {
                v0_5.close();
                throw v1_2;
            }
        }
        if (this.zza("datalayer", p3)) {
            this.zzc(p3);
            return;
        } else {
            p3.execSQL(com.google.android.gms.tagmanager.zzw.zzyG());
            return;
        }
    }

Method com.google.android.gms.tagmanager.zzby$zzb.onOpen() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void onOpen(android.database.sqlite.SQLiteDatabase p3)
    {
        if (android.os.Build$VERSION.SDK_INT < 15) {
            String v0_5 = p3.rawQuery("PRAGMA journal_mode=memory", 0);
            try {
                v0_5.moveToFirst();
                v0_5.close();
            } catch (Throwable v1_2) {
                v0_5.close();
                throw v1_2;
            }
        }
        if (this.zza("gtm_hits", p3)) {
            this.zzc(p3);
            return;
        } else {
            p3.execSQL(com.google.android.gms.tagmanager.zzby.zzze());
            return;
        }
    }

Method com.google.android.gms.analytics.internal.zzj$zza.onOpen() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void onOpen(android.database.sqlite.SQLiteDatabase p3)
    {
        if (android.os.Build$VERSION.SDK_INT < 15) {
            String v0_8 = p3.rawQuery("PRAGMA journal_mode=memory", 0);
            try {
                v0_8.moveToFirst();
                v0_8.close();
            } catch (Throwable v1_2) {
                v0_8.close();
                throw v1_2;
            }
        }
        if (this.zza(p3, "hits2")) {
            this.zza(p3);
        } else {
            p3.execSQL(com.google.android.gms.analytics.internal.zzj.zziw());
        }
        if (this.zza(p3, "properties")) {
            this.zzb(p3);
            return;
        } else {
            p3.execSQL("CREATE TABLE IF NOT EXISTS properties ( app_uid INTEGER NOT NULL, cid TEXT NOT NULL, tid TEXT NOT NULL, params TEXT NOT NULL, adid INTEGER NOT NULL, hits_count INTEGER NOT NULL, PRIMARY KEY (app_uid, cid, tid)) ;");
            return;
        }
    }

Method com.google.android.gms.analytics.internal.zzj$zza.zza() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    private void zza(android.database.sqlite.SQLiteDatabase p8)
    {
        String v0_1 = this.zzb(p8, "hits2");
        String v1_4 = new String[4];
        int v3 = 0;
        v1_4[0] = "hit_id";
        v1_4[1] = "hit_string";
        v1_4[2] = "hit_time";
        v1_4[3] = "hit_url";
        while (v3 < v1_4.length) {
            String v5_2 = v1_4[v3];
            if (v0_1.remove(v5_2)) {
                v3++;
            } else {
                String v0_6 = new StringBuilder();
                v0_6.append("Database hits2 is missing required column: ");
                v0_6.append(v5_2);
                throw new android.database.sqlite.SQLiteException(v0_6.toString());
            }
        }
        String v1_2 = (v0_1.remove("hit_app_id") ^ 1);
        if (v0_1.isEmpty()) {
            if (v1_2 != null) {
                p8.execSQL("ALTER TABLE hits2 ADD COLUMN hit_app_id INTEGER");
            }
            return;
        } else {
            throw new android.database.sqlite.SQLiteException("Database hits2 has extra columns");
        }
    }

Method com.google.android.gms.ads.internal.purchase.zzh$zza.onUpgrade() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void onUpgrade(android.database.sqlite.SQLiteDatabase p3, int p4, int p5)
    {
        String v0_1 = new StringBuilder();
        v0_1.append("Database updated from version ");
        v0_1.append(p4);
        v0_1.append(" to version ");
        v0_1.append(p5);
        com.google.android.gms.ads.internal.util.client.zzb.zzaA(v0_1.toString());
        p3.execSQL("DROP TABLE IF EXISTS InAppPurchase");
        this.onCreate(p3);
        return;
    }

Method com.google.android.gms.ads.internal.purchase.zzh$zza.onCreate() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void onCreate(android.database.sqlite.SQLiteDatabase p2)
    {
        p2.execSQL(com.google.android.gms.ads.internal.purchase.zzh.zzfh());
        return;
    }

Method com.android.insecurebankv2.TrackUserContentProvider$DatabaseHelper.onUpgrade() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void onUpgrade(android.database.sqlite.SQLiteDatabase p2, int p3, int p4)
    {
        p2.execSQL("DROP TABLE IF EXISTS names");
        this.onCreate(p2);
        return;
    }

Method com.android.insecurebankv2.TrackUserContentProvider$DatabaseHelper.onCreate() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void onCreate(android.database.sqlite.SQLiteDatabase p2)
    {
        p2.execSQL(" CREATE TABLE names (id INTEGER PRIMARY KEY AUTOINCREMENT,  name TEXT NOT NULL);");
        return;
    }

Method com.google.android.gms.analytics.internal.zzj.zzis() calling method android.database.sqlite.SQLiteDatabase.delete()


    public int zzis()
    {
        this.zzhO();
        this.zzia();
        if (this.zzKj.zzv(86400000)) {
            this.zzKj.start();
            this.zzaT("Deleting stale hits (if any)");
            int v0_1 = this.getWritableDatabase();
            String[] v4_2 = new String[1];
            v4_2[0] = Long.toString((this.zzhP().currentTimeMillis() - 1.280618154e-314));
            int v0_3 = v0_1.delete("hits2", "hit_time < ?", v4_2);
            this.zza("Deleted stale hits, count", Integer.valueOf(v0_3));
            return v0_3;
        } else {
            return 0;
        }
    }

Method com.google.android.gms.analytics.internal.zzj.zzir() calling method android.database.sqlite.SQLiteDatabase.delete()


    public void zzir()
    {
        this.zzhO();
        this.zzia();
        this.getWritableDatabase().delete("properties", 0, 0);
        return;
    }

Method com.google.android.gms.analytics.internal.zzj.zziq() calling method android.database.sqlite.SQLiteDatabase.delete()


    public void zziq()
    {
        this.zzhO();
        this.zzia();
        this.getWritableDatabase().delete("hits2", 0, 0);
        return;
    }

Method com.google.android.gms.analytics.internal.zzj.zzd() calling method android.database.sqlite.SQLiteDatabase.delete()


    public void zzd(java.util.List p9)
    {
        com.google.android.gms.common.internal.zzu.zzu(p9);
        this.zzhO();
        this.zzia();
        if (!p9.isEmpty()) {
            String v0_5 = new StringBuilder("hit_id");
            v0_5.append(" in (");
            int v1_0 = 0;
            while (v1_0 < p9.size()) {
                String v2_6 = ((Long) p9.get(v1_0));
                if ((v2_6 != null) && (v2_6.longValue() != 0)) {
                    if (v1_0 > 0) {
                        v0_5.append(",");
                    }
                    v0_5.append(v2_6);
                    v1_0++;
                } else {
                    throw new android.database.sqlite.SQLiteException("Invalid hit id");
                }
            }
            v0_5.append(")");
            String v0_0 = v0_5.toString();
            try {
                int v1_2 = this.getWritableDatabase();
                this.zza("Deleting dispatched hits. count", Integer.valueOf(p9.size()));
                int v1_3 = v1_2.delete("hits2", v0_0, 0);
            } catch (Integer v9_3) {
                this.zze("Error deleting hits", v9_3);
                throw v9_3;
            }
            if (v1_3 != p9.size()) {
                this.zzb("Deleted fewer hits then expected", Integer.valueOf(p9.size()), Integer.valueOf(v1_3), v0_0);
            }
            return;
        } else {
            return;
        }
    }

Method com.google.android.gms.analytics.internal.zzj.zza() calling method android.database.sqlite.SQLiteDatabase.delete()


    public void zza(long p5, String p7)
    {
        com.google.android.gms.common.internal.zzu.zzcj(p7);
        this.zzia();
        this.zzhO();
        android.database.sqlite.SQLiteDatabase v0 = this.getWritableDatabase();
        String[] v3_1 = new String[2];
        v3_1[0] = String.valueOf(p5);
        v3_1[1] = p7;
        Integer v5_3 = v0.delete("properties", "app_uid=? AND cid<>?", v3_1);
        if (v5_3 > null) {
            this.zza("Deleted property records", Integer.valueOf(v5_3));
        }
        return;
    }

Method com.google.android.gms.tagmanager.zzw.zzeq() calling method android.database.sqlite.SQLiteDatabase.delete()


    private void zzeq(String p8)
    {
        android.database.sqlite.SQLiteException v0_1 = this.zzer("Error opening database for clearKeysWithPrefix.");
        if (v0_1 != null) {
            try {
                String[] v3_1 = new String[2];
                v3_1[0] = p8;
                String v5_1 = new StringBuilder();
                v5_1.append(p8);
                v5_1.append(".%");
                v3_1[1] = v5_1.toString();
                android.database.sqlite.SQLiteException v0_2 = v0_1.delete("datalayer", "key = ? OR key LIKE ?", v3_1);
                StringBuilder v1_1 = new StringBuilder();
                v1_1.append("Cleared ");
                v1_1.append(v0_2);
                v1_1.append(" items");
                com.google.android.gms.tagmanager.zzbg.zzaB(v1_1.toString());
            } catch (String v8_4) {
                this.zzyF();
                throw v8_4;
            } catch (android.database.sqlite.SQLiteException v0_5) {
                StringBuilder v1_3 = new StringBuilder();
                v1_3.append("Error deleting entries with key prefix: ");
                v1_3.append(p8);
                v1_3.append(" (");
                v1_3.append(v0_5);
                v1_3.append(").");
                com.google.android.gms.tagmanager.zzbg.zzaC(v1_3.toString());
            }
            this.zzyF();
            return;
        } else {
            return;
        }
    }

Method com.google.android.gms.tagmanager.zzw.zze() calling method android.database.sqlite.SQLiteDatabase.delete()


    private void zze(String[] p8)
    {
        if (p8 != null) {
            if (p8.length != 0) {
                StringBuilder v0_4 = this.zzer("Error opening database for deleteEntries.");
                if (v0_4 != null) {
                    String v2_2 = new Object[2];
                    v2_2[0] = "ID";
                    v2_2[1] = android.text.TextUtils.join(",", java.util.Collections.nCopies(p8.length, "?"));
                    try {
                        v0_4.delete("datalayer", String.format("%s in (%s)", v2_2), p8);
                        return;
                    } catch (StringBuilder v0) {
                        StringBuilder v0_2 = new StringBuilder();
                        v0_2.append("Error deleting entries ");
                        v0_2.append(java.util.Arrays.toString(p8));
                        com.google.android.gms.tagmanager.zzbg.zzaC(v0_2.toString());
                    }
                } else {
                    return;
                }
            } else {
                return;
            }
        }
        return;
    }

Method com.google.android.gms.tagmanager.zzw.zzS() calling method android.database.sqlite.SQLiteDatabase.delete()


    private void zzS(long p6)
    {
        String v0_2 = this.zzer("Error opening database for deleteOlderThan.");
        if (v0_2 != null) {
            try {
                String[] v3_1 = new String[1];
                v3_1[0] = Long.toString(p6);
                String v6_2 = v0_2.delete("datalayer", "expires <= ?", v3_1);
                StringBuilder v7_1 = new StringBuilder();
                v7_1.append("Deleted ");
                v7_1.append(v6_2);
                v7_1.append(" expired items");
                com.google.android.gms.tagmanager.zzbg.zzaB(v7_1.toString());
                return;
            } catch (String v6) {
                com.google.android.gms.tagmanager.zzbg.zzaC("Error deleting old entries.");
                return;
            }
        } else {
            return;
        }
    }

Method com.google.android.gms.tagmanager.zzby.zzis() calling method android.database.sqlite.SQLiteDatabase.delete()


    int zzis()
    {
        int v0_3 = this.zzpw.currentTimeMillis();
        int v3 = 0;
        if (v0_3 > (this.zzaMw + 86400000)) {
            this.zzaMw = v0_3;
            int v0_2 = this.zzer("Error opening database for deleteStaleHits.");
            if (v0_2 != 0) {
                String[] v5 = new String[1];
                v5[0] = Long.toString((this.zzpw.currentTimeMillis() - 1.280618154e-314));
                int v0_4 = v0_2.delete("gtm_hits", "HIT_TIME < ?", v5);
                if (this.zzzc() == 0) {
                    v3 = 1;
                }
                this.zzaMu.zzan(v3);
                return v0_4;
            } else {
                return 0;
            }
        } else {
            return 0;
        }
    }

Method com.google.android.gms.tagmanager.zzby.zzf() calling method android.database.sqlite.SQLiteDatabase.delete()


    void zzf(String[] p8)
    {
        if (p8 != null) {
            if (p8.length != 0) {
                int v0_3 = this.zzer("Error opening database for deleteHits.");
                if (v0_3 != 0) {
                    int v2 = 1;
                    String v3_1 = new Object[1];
                    v3_1[0] = android.text.TextUtils.join(",", java.util.Collections.nCopies(p8.length, "?"));
                    try {
                        v0_3.delete("gtm_hits", String.format("HIT_ID in (%s)", v3_1), p8);
                    } catch (String v8) {
                        com.google.android.gms.tagmanager.zzbg.zzaC("Error deleting hits");
                    }
                    if (this.zzzc() != 0) {
                        v2 = 0;
                    } else {
                    }
                    this.zzaMu.zzan(v2);
                    return;
                } else {
                    return;
                }
            } else {
                return;
            }
        }
        return;
    }

Method com.google.android.gms.ads.internal.purchase.zzh.zza() calling method android.database.sqlite.SQLiteDatabase.delete()


    public void zza(com.google.android.gms.ads.internal.purchase.zzf p8)
    {
        if (p8 != null) {
            try {
                android.database.sqlite.SQLiteDatabase v1 = this.getWritableDatabase();
            } catch (String v8_3) {
                throw v8_3;
            }
            if (v1 != null) {
                int v3_2 = new Object[2];
                v3_2[0] = "purchase_id";
                v3_2[1] = Long.valueOf(p8.zzAR);
                v1.delete("InAppPurchase", String.format("%s = %d", v3_2), 0);
                return;
            } else {
                return;
            }
        } else {
            return;
        }
    }

Method com.android.insecurebankv2.TrackUserContentProvider.delete() calling method android.database.sqlite.SQLiteDatabase.delete()


    public int delete(android.net.Uri p5, String p6, String[] p7)
    {
        if (com.android.insecurebankv2.TrackUserContentProvider.uriMatcher.match(p5) == 1) {
            int v0 = this.db.delete("names", p6, p7);
            this.getContext().getContentResolver().notifyChange(p5, 0);
            return v0;
        } else {
            int v2_2 = new StringBuilder();
            v2_2.append("Unknown URI ");
            v2_2.append(p5);
            throw new IllegalArgumentException(v2_2.toString());
        }
    }

Method com.google.android.gms.analytics.internal.zzj.zzr() calling method android.database.sqlite.SQLiteDatabase.query()


    public java.util.List zzr(long p28)
    {
        this.zzia();
        this.zzhO();
        Throwable v2_1 = this.getWritableDatabase();
        try {
            boolean v4_2 = new String[5];
            v4_2[0] = "cid";
            v4_2[1] = "tid";
            v4_2[2] = "adid";
            v4_2[3] = "hits_count";
            v4_2[4] = "params";
            com.google.android.gms.analytics.internal.zzh v9_0 = this.zzhR().zzjv();
            String v16 = String.valueOf(v9_0);
            String v6_0 = new String[1];
            v6_0[0] = String.valueOf(p28);
            android.database.sqlite.SQLiteException v11_1 = v9_0;
            Throwable v2_2 = v2_1.query("properties", v4_2, "app_uid=?", v6_0, 0, 0, 0, v16);
            try {
                String v3_8 = new java.util.ArrayList();
            } catch (Throwable v0_0) {
                android.database.sqlite.SQLiteException v11_0 = v2_2;
                Throwable v2_0 = v0_0;
                if (v11_0 != null) {
                    v11_0.close();
                }
                throw v2_0;
            } catch (Throwable v0_3) {
                v11_0 = v2_2;
                Throwable v2_3 = v0_3;
                try {
                    this.zze("Error loading hits from the database", v2_3);
                    throw v2_3;
                } catch (Throwable v0_0) {
                }
            }
            if (v2_2.moveToFirst()) {
                do {
                    int v23;
                    boolean v4_1 = v2_2.getString(0);
                    String v5_1 = v2_2.getString(1);
                    if (v2_2.getInt(2) == 0) {
                        v23 = 0;
                    } else {
                        v23 = 1;
                    }
                    String v6_3 = ((long) v2_2.getInt(3));
                    java.util.Map vtmp14 = this.zzaZ(v2_2.getString(4));
                    if (android.text.TextUtils.isEmpty(v4_1)) {
                        this.zzc("Read property with empty client id or tracker id", v4_1, v5_1);
                    } else {
                        if (!android.text.TextUtils.isEmpty(v5_1)) {
                            com.google.android.gms.analytics.internal.zzh v9_5 = new com.google.android.gms.analytics.internal.zzh;
                            v9_5(p28, v4_1, v5_1, v23, v6_3, vtmp14);
                            v3_8.add(v9_5);
                        } else {
                        }
                    }
                } while(v2_2.moveToNext());
            }
            if (v3_8.size() >= v11_1) {
                this.zzaW("Sending hits to too many properties. Campaign report might be incorrect");
            }
            if (v2_2 != null) {
                v2_2.close();
            }
            return v3_8;
        } catch (Throwable v0_2) {
            v2_0 = v0_2;
            v11_0 = 0;
        } catch (Throwable v0_1) {
            v2_3 = v0_1;
            v11_0 = 0;
        }
    }

Method com.google.android.gms.analytics.internal.zzj.zzp() calling method android.database.sqlite.SQLiteDatabase.query()


    public java.util.List zzp(long p24)
    {
        boolean v1_5;
        int v11_0 = 0;
        if (p24 < 0) {
            v1_5 = 0;
        } else {
            v1_5 = 1;
        }
        com.google.android.gms.common.internal.zzu.zzV(v1_5);
        this.zzhO();
        this.zzia();
        int v13_0 = this.getWritableDatabase();
        try {
            int v15_0 = new String[5];
            v15_0[0] = "hit_id";
            v15_0[1] = "hit_time";
            int v9_0 = 2;
            v15_0[2] = "hit_string";
            int v7_0 = 3;
            v15_0[3] = "hit_url";
            int v8 = 4;
            v15_0[4] = "hit_app_id";
            Object[] v5_1 = new Object[1];
            v5_1[0] = "hit_id";
            int v13_1 = v13_0.query("hits2", v15_0, 0, 0, 0, 0, String.format("%s ASC", v5_1), Long.toString(p24));
            try {
                java.util.ArrayList v14_2 = new java.util.ArrayList();
            } catch (android.database.sqlite.SQLiteException v0_0) {
                boolean v1_3 = v0_0;
                this.zze("Error loading hits from the database", v1_3);
                throw v1_3;
            }
            if (v13_1.moveToFirst()) {
                while(true) {
                    String v2_9 = new com.google.android.gms.analytics.internal.zzab;
                    int v11_1 = v2_9;
                    int v19 = 4;
                    v2_9(this, this.zzaY(v13_1.getString(v9_0)), v13_1.getLong(1), com.google.android.gms.analytics.internal.zzam.zzbn(v13_1.getString(v7_0)), v13_1.getLong(v11_0), v13_1.getInt(v8));
                    v14_2.add(v11_1);
                    if (!v13_1.moveToNext()) {
                        break;
                    }
                    v7_0 = 3;
                    v8 = 4;
                    v9_0 = 2;
                    v11_0 = 0;
                }
            }
            if (v13_1 != 0) {
                v13_1.close();
            }
            return v14_2;
        } catch (android.database.sqlite.SQLiteException v0_1) {
            v13_1 = 0;
            boolean v1_4 = v0_1;
            if (v13_1 != 0) {
                v13_1.close();
            }
            throw v1_4;
        } catch (android.database.sqlite.SQLiteException v0_0) {
            v13_1 = 0;
        } catch (android.database.sqlite.SQLiteException v0_1) {
        }
    }

Method com.google.android.gms.analytics.internal.zzj.zzo() calling method android.database.sqlite.SQLiteDatabase.query()


    public java.util.List zzo(long p14)
    {
        this.zzhO();
        this.zzia();
        if (p14 > 0) {
            long v0_2 = this.getWritableDatabase();
            java.util.ArrayList v9_1 = new java.util.ArrayList();
            String v10 = 0;
            try {
                int v3_0 = new String[1];
                v3_0[0] = "hit_id";
                String[] v2_1 = new Object[1];
                v2_1[0] = "hit_id";
                String v14_2 = v0_2.query("hits2", v3_0, 0, 0, 0, 0, String.format("%s ASC", v2_1), Long.toString(p14));
                try {
                    if (v14_2.moveToFirst()) {
                        do {
                            v9_1.add(Long.valueOf(v14_2.getLong(0)));
                        } while(v14_2.moveToNext());
                    }
                } catch (boolean v15_2) {
                    v10 = v14_2;
                    if (v10 != null) {
                        v10.close();
                    }
                    throw v15_2;
                } catch (boolean v15_0) {
                    v10 = v14_2;
                    this.zzd("Error selecting hit ids", v15_0);
                    if (v10 == null) {
                        return v9_1;
                    } else {
                        v10.close();
                        return v9_1;
                    }
                }
                if (v14_2 == null) {
                    return v9_1;
                } else {
                    v14_2.close();
                    return v9_1;
                }
            } catch (boolean v15_2) {
            } catch (boolean v15_0) {
            }
        } else {
            return java.util.Collections.emptyList();
        }
    }

Method com.google.android.gms.tagmanager.zzw.zzyD() calling method android.database.sqlite.SQLiteDatabase.query()


    private java.util.List zzyD()
    {
        android.database.Cursor v1_0 = this.zzer("Error opening database for loadSerialized.");
        Throwable v0_3 = new java.util.ArrayList();
        if (v1_0 != null) {
            String v3_1 = new String[2];
            v3_1[0] = "key";
            v3_1[1] = "value";
            android.database.Cursor v1_1 = v1_0.query("datalayer", v3_1, 0, 0, 0, 0, "ID", 0);
            try {
                while (v1_1.moveToNext()) {
                    v0_3.add(new com.google.android.gms.tagmanager.zzw$zzb(v1_1.getString(0), v1_1.getBlob(1)));
                }
            } catch (Throwable v0_1) {
                v1_1.close();
                throw v0_1;
            }
            v1_1.close();
            return v0_3;
        } else {
            return v0_3;
        }
    }

Method com.google.android.gms.tagmanager.zzw.zziT() calling method android.database.sqlite.SQLiteDatabase.query()


    private java.util.List zziT(int p15)
    {
        Throwable v0_1 = new java.util.ArrayList();
        if (p15 > null) {
            StringBuilder v2_2 = this.zzer("Error opening database for peekEntryIds.");
            if (v2_2 != null) {
                boolean v1_3 = 0;
                try {
                    int v5_0 = new String[1];
                    v5_0[0] = "ID";
                    String[] v4_0 = new Object[1];
                    v4_0[0] = "ID";
                    android.database.sqlite.SQLiteException v15_2 = v2_2.query("datalayer", v5_0, 0, 0, 0, 0, String.format("%s ASC", v4_0), Integer.toString(p15));
                    try {
                        if (v15_2.moveToFirst()) {
                            do {
                                v0_1.add(String.valueOf(v15_2.getLong(0)));
                            } while(v15_2.moveToNext());
                        }
                    } catch (Throwable v0_2) {
                        v1_3 = v15_2;
                        if (v1_3) {
                            v1_3.close();
                        }
                        throw v0_2;
                    } catch (boolean v1_2) {
                        v1_3 = v15_2;
                        android.database.sqlite.SQLiteException v15_3 = v1_2;
                        StringBuilder v2_1 = new StringBuilder();
                        v2_1.append("Error in peekEntries fetching entryIds: ");
                        v2_1.append(v15_3.getMessage());
                        com.google.android.gms.tagmanager.zzbg.zzaC(v2_1.toString());
                        if (!v1_3) {
                            return v0_1;
                        } else {
                            v1_3.close();
                            return v0_1;
                        }
                    }
                    if (v15_2 == null) {
                        return v0_1;
                    } else {
                        v15_2.close();
                        return v0_1;
                    }
                } catch (Throwable v0_2) {
                } catch (android.database.sqlite.SQLiteException v15_3) {
                }
            } else {
                return v0_1;
            }
        } else {
            com.google.android.gms.tagmanager.zzbg.zzaC("Invalid maxEntries specified. Skipping.");
            return v0_1;
        }
    }

Method com.google.android.gms.tagmanager.zzby.zzzd() calling method android.database.sqlite.SQLiteDatabase.query()


    int zzzd()
    {
        String v1_0 = this.zzer("Error opening database for getNumStoredHits.");
        if (v1_0 != null) {
            String v9 = 0;
            try {
                String[] v3_1 = new String[2];
                v3_1[0] = "hit_id";
                v3_1[1] = "hit_first_send_time";
                String v1_1 = v1_0.query("gtm_hits", v3_1, "hit_first_send_time=0", 0, 0, 0, 0);
                try {
                    android.database.sqlite.SQLiteException v2_0 = v1_1.getCount();
                } catch (android.database.sqlite.SQLiteException v0_2) {
                    v9 = v1_1;
                    if (v9 != null) {
                        v9.close();
                    }
                    throw v0_2;
                } catch (android.database.sqlite.SQLiteException v2) {
                    v9 = v1_1;
                    com.google.android.gms.tagmanager.zzbg.zzaC("Error getting num untried hits");
                    if (v9 != null) {
                        v9.close();
                    }
                    return 0;
                }
                if (v1_1 != null) {
                    v1_1.close();
                }
                return v2_0;
            } catch (android.database.sqlite.SQLiteException v0_2) {
            } catch (String v1) {
            }
        } else {
            return 0;
        }
    }

Method com.google.android.gms.tagmanager.zzby.zziZ() calling method android.database.sqlite.SQLiteDatabase.query()


    public java.util.List zziZ(int p19)
    {
        int v1_1 = new java.util.ArrayList();
        java.util.Iterator v2_3 = this.zzer("Error opening database for peekHits");
        if (v2_3 != null) {
            try {
                Long v6_5 = new String[3];
                int v14 = 0;
                v6_5[0] = "hit_id";
                v6_5[1] = "hit_time";
                v6_5[2] = "hit_first_send_time";
                String v11_1 = new Object[1];
                v11_1[0] = "hit_id";
                String v12_3 = v2_3.query("gtm_hits", v6_5, 0, 0, 0, 0, String.format("%s ASC", v11_1), Integer.toString(p19));
                try {
                    String v11_3 = new java.util.ArrayList();
                    try {
                        if (v12_3.moveToFirst()) {
                            try {
                                do {
                                    int v1_17 = new com.google.android.gms.tagmanager.zzaq;
                                    v1_17(v12_3.getLong(0), v12_3.getLong(1), v12_3.getLong(2));
                                    v11_3.add(v1_17);
                                } while(v12_3.moveToNext());
                            } catch (android.database.sqlite.SQLiteException v0_10) {
                                int v1_14 = v0_10;
                                String v13_3 = v12_3;
                                if (v13_3 != null) {
                                    v13_3.close();
                                }
                                throw v1_14;
                            } catch (android.database.sqlite.SQLiteException v0_8) {
                                int v1_15 = v0_8;
                                v13_3 = v12_3;
                                try {
                                    java.util.Iterator v2_5 = new StringBuilder();
                                    v2_5.append("Error in peekHits fetching hitIds: ");
                                    v2_5.append(v1_15.getMessage());
                                    com.google.android.gms.tagmanager.zzbg.zzaC(v2_5.toString());
                                } catch (android.database.sqlite.SQLiteException v0_9) {
                                    v1_14 = v0_9;
                                }
                                if (v13_3 != null) {
                                    v13_3.close();
                                }
                                return v11_3;
                            }
                            if (!v12_3.moveToNext()) {
                            }
                        }
                    } catch (android.database.sqlite.SQLiteException v0_6) {
                        v1_15 = v0_6;
                        v13_3 = v12_3;
                    }
                    if (v12_3 != null) {
                        v12_3.close();
                    }
                    try {
                        Long v6_0 = new String[2];
                        v6_0[0] = "hit_id";
                        v6_0[1] = "hit_url";
                        boolean v4_1 = new Object[1];
                        v4_1[0] = "hit_id";
                        java.util.Iterator v2_0 = v11_3;
                        String v11_0 = String.format("%s ASC", v4_1);
                        String v16_0 = v12_3;
                        String v12_0 = Integer.toString(p19);
                        try {
                            v12_0 = v2_3.query("gtm_hits", v6_0, 0, 0, 0, 0, v11_0, v12_0);
                            try {
                                if (v12_0.moveToFirst()) {
                                    int v1_9 = 0;
                                    do {
                                        if (((android.database.sqlite.SQLiteCursor) v12_0).getWindow().getNumRows() <= 0) {
                                            Object[] v5_1 = new Object[1];
                                            v5_1[0] = Long.valueOf(((com.google.android.gms.tagmanager.zzaq) v2_0.get(v1_9)).zzyO());
                                            com.google.android.gms.tagmanager.zzbg.zzaC(String.format("HitString for hitId %d too large.  Hit will be deleted.", v5_1));
                                        } else {
                                            ((com.google.android.gms.tagmanager.zzaq) v2_0.get(v1_9)).zzev(v12_0.getString(1));
                                        }
                                        v1_9++;
                                    } while(v12_0.moveToNext());
                                }
                            } catch (android.database.sqlite.SQLiteException v0_0) {
                                int v1_6 = v0_0;
                                boolean v4_14 = new StringBuilder();
                                v4_14.append("Error in peekHits fetching hit url: ");
                                v4_14.append(v1_6.getMessage());
                                com.google.android.gms.tagmanager.zzbg.zzaC(v4_14.toString());
                                int v1_13 = new java.util.ArrayList();
                                java.util.Iterator v2_1 = v2_0.iterator();
                            }
                            if (v12_0 != null) {
                                v12_0.close();
                            }
                            return v2_0;
                        } catch (android.database.sqlite.SQLiteException v0_3) {
                            int v1_7 = v0_3;
                            v12_0 = v16_0;
                            if (v12_0 != null) {
                                v12_0.close();
                            }
                            throw v1_7;
                        } catch (android.database.sqlite.SQLiteException v0_2) {
                            v1_6 = v0_2;
                            v12_0 = v16_0;
                        }
                    } catch (android.database.sqlite.SQLiteException v0_1) {
                        v1_7 = v0_1;
                    } catch (android.database.sqlite.SQLiteException v0_0) {
                        v2_0 = v11_0;
                    } catch (android.database.sqlite.SQLiteException v0_1) {
                    }
                } catch (android.database.sqlite.SQLiteException v0_7) {
                    v1_14 = v0_7;
                    v13_3 = v12_3;
                } catch (android.database.sqlite.SQLiteException v0_4) {
                    v11_3 = v1_1;
                    v13_3 = v12_3;
                    v1_15 = v0_4;
                }
            } catch (android.database.sqlite.SQLiteException v0_5) {
                v1_14 = v0_5;
                v13_3 = 0;
            } catch (android.database.sqlite.SQLiteException v0_4) {
                v11_3 = v1_1;
                v13_3 = 0;
            }
        } else {
            return v1_1;
        }
    }

Method com.google.android.gms.tagmanager.zzby.zziY() calling method android.database.sqlite.SQLiteDatabase.query()


    java.util.List zziY(int p15)
    {
        Throwable v0_1 = new java.util.ArrayList();
        if (p15 > null) {
            StringBuilder v2_2 = this.zzer("Error opening database for peekHitIds.");
            if (v2_2 != null) {
                boolean v1_3 = 0;
                try {
                    int v5_0 = new String[1];
                    v5_0[0] = "hit_id";
                    String[] v4_0 = new Object[1];
                    v4_0[0] = "hit_id";
                    android.database.sqlite.SQLiteException v15_2 = v2_2.query("gtm_hits", v5_0, 0, 0, 0, 0, String.format("%s ASC", v4_0), Integer.toString(p15));
                    try {
                        if (v15_2.moveToFirst()) {
                            do {
                                v0_1.add(String.valueOf(v15_2.getLong(0)));
                            } while(v15_2.moveToNext());
                        }
                    } catch (Throwable v0_2) {
                        v1_3 = v15_2;
                        if (v1_3) {
                            v1_3.close();
                        }
                        throw v0_2;
                    } catch (boolean v1_2) {
                        v1_3 = v15_2;
                        android.database.sqlite.SQLiteException v15_3 = v1_2;
                        StringBuilder v2_1 = new StringBuilder();
                        v2_1.append("Error in peekHits fetching hitIds: ");
                        v2_1.append(v15_3.getMessage());
                        com.google.android.gms.tagmanager.zzbg.zzaC(v2_1.toString());
                        if (!v1_3) {
                            return v0_1;
                        } else {
                            v1_3.close();
                            return v0_1;
                        }
                    }
                    if (v15_2 == null) {
                        return v0_1;
                    } else {
                        v15_2.close();
                        return v0_1;
                    }
                } catch (Throwable v0_2) {
                } catch (android.database.sqlite.SQLiteException v15_3) {
                }
            } else {
                return v0_1;
            }
        } else {
            com.google.android.gms.tagmanager.zzbg.zzaC("Invalid maxHits specified. Skipping");
            return v0_1;
        }
    }

Method com.google.android.gms.tagmanager.zzw$zza.zza() calling method android.database.sqlite.SQLiteDatabase.query()


    private boolean zza(String p11, android.database.sqlite.SQLiteDatabase p12)
    {
        StringBuilder v1_0 = 0;
        try {
            String[] v4 = new String[1];
            v4[0] = "name";
            String[] v6 = new String[1];
            v6[0] = p11;
            StringBuilder v12_1 = p12.query("SQLITE_MASTER", v4, "name=?", v6, 0, 0, 0);
            try {
                StringBuilder v1_1 = v12_1.moveToFirst();
            } catch (Throwable v11_2) {
                v1_0 = v12_1;
                if (v1_0 != null) {
                    v1_0.close();
                }
                throw v11_2;
            } catch (StringBuilder v1) {
                v1_0 = v12_1;
                StringBuilder v12_3 = new StringBuilder();
                v12_3.append("Error querying for table ");
                v12_3.append(p11);
                com.google.android.gms.tagmanager.zzbg.zzaC(v12_3.toString());
                if (v1_0 != null) {
                    v1_0.close();
                }
                return 0;
            }
            if (v12_1 != null) {
                v12_1.close();
            }
            return v1_1;
        } catch (Throwable v11_2) {
        } catch (StringBuilder v12) {
        }
    }

Method com.google.android.gms.tagmanager.zzby$zzb.zza() calling method android.database.sqlite.SQLiteDatabase.query()


    private boolean zza(String p11, android.database.sqlite.SQLiteDatabase p12)
    {
        StringBuilder v1_0 = 0;
        try {
            String[] v4 = new String[1];
            v4[0] = "name";
            String[] v6 = new String[1];
            v6[0] = p11;
            StringBuilder v12_1 = p12.query("SQLITE_MASTER", v4, "name=?", v6, 0, 0, 0);
            try {
                StringBuilder v1_1 = v12_1.moveToFirst();
            } catch (Throwable v11_2) {
                v1_0 = v12_1;
                if (v1_0 != null) {
                    v1_0.close();
                }
                throw v11_2;
            } catch (StringBuilder v1) {
                v1_0 = v12_1;
                StringBuilder v12_3 = new StringBuilder();
                v12_3.append("Error querying for table ");
                v12_3.append(p11);
                com.google.android.gms.tagmanager.zzbg.zzaC(v12_3.toString());
                if (v1_0 != null) {
                    v1_0.close();
                }
                return 0;
            }
            if (v12_1 != null) {
                v12_1.close();
            }
            return v1_1;
        } catch (Throwable v11_2) {
        } catch (StringBuilder v12) {
        }
    }

Method com.google.android.gms.analytics.internal.zzj$zza.zza() calling method android.database.sqlite.SQLiteDatabase.query()


    private boolean zza(android.database.sqlite.SQLiteDatabase p12, String p13)
    {
        android.database.sqlite.SQLiteException v1_0 = 0;
        try {
            String[] v4 = new String[1];
            v4[0] = "name";
            String[] v6 = new String[1];
            v6[0] = p13;
            android.database.sqlite.SQLiteException v12_1 = p12.query("SQLITE_MASTER", v4, "name=?", v6, 0, 0, 0);
            try {
                android.database.sqlite.SQLiteException v1_1 = v12_1.moveToFirst();
            } catch (Throwable v13_1) {
                v1_0 = v12_1;
                if (v1_0 != null) {
                    v1_0.close();
                }
                throw v13_1;
            } catch (android.database.sqlite.SQLiteException v1_2) {
                v1_0 = v12_1;
                android.database.sqlite.SQLiteException v12_2 = v1_2;
                this.zzKl.zzc("Error querying for table", p13, v12_2);
                if (v1_0 != null) {
                    v1_0.close();
                }
                return 0;
            }
            if (v12_1 != null) {
                v12_1.close();
            }
            return v1_1;
        } catch (Throwable v13_1) {
        } catch (android.database.sqlite.SQLiteException v12_2) {
        }
    }

Method com.google.android.gms.ads.internal.purchase.zzh.zzfg() calling method android.database.sqlite.SQLiteDatabase.query()


    public void zzfg()
    {
        try {
            String v1_1 = this.getWritableDatabase();
        } catch (String v1_5) {
            throw v1_5;
        }
        if (v1_1 != null) {
            String v10 = 0;
            try {
                String v1_0 = v1_1.query("InAppPurchase", 0, 0, 0, 0, 0, "record_time ASC", "1");
                try {
                    if ((v1_0 != null) && (v1_0.moveToFirst())) {
                        this.zza(this.zza(v1_0));
                    }
                } catch (com.google.android.gms.ads.internal.purchase.zzf v2_3) {
                    v10 = v1_0;
                    if (v10 != null) {
                        v10.close();
                    }
                    throw v2_3;
                } catch (com.google.android.gms.ads.internal.purchase.zzf v2_0) {
                    v10 = v1_0;
                    String v1_3 = new StringBuilder();
                    v1_3.append("Error remove oldest record");
                    v1_3.append(v2_0.getMessage());
                    com.google.android.gms.ads.internal.util.client.zzb.zzaC(v1_3.toString());
                    if (v10 == null) {
                        return;
                    } else {
                        v10.close();
                        return;
                    }
                }
                if (v1_0 == null) {
                    return;
                } else {
                    v1_0.close();
                    return;
                }
            } catch (com.google.android.gms.ads.internal.purchase.zzf v2_3) {
            } catch (com.google.android.gms.ads.internal.purchase.zzf v2_0) {
            }
        } else {
            return;
        }
    }

Method com.google.android.gms.ads.internal.purchase.zzh.zzf() calling method android.database.sqlite.SQLiteDatabase.query()


    public java.util.List zzf(long p13)
    {
        try {
            java.util.LinkedList v1_1 = new java.util.LinkedList();
        } catch (String v13_5) {
            throw v13_5;
        }
        if (p13 > 0) {
            String v2_2 = this.getWritableDatabase();
            if (v2_2 != null) {
                String v11 = 0;
                try {
                    String v13_1 = v2_2.query("InAppPurchase", 0, 0, 0, 0, 0, "record_time ASC", String.valueOf(p13));
                    try {
                        if (v13_1.moveToFirst()) {
                            do {
                                v1_1.add(this.zza(v13_1));
                            } while(v13_1.moveToNext());
                        }
                    } catch (boolean v14_3) {
                        v11 = v13_1;
                        if (v11 != null) {
                            v11.close();
                        }
                        throw v14_3;
                    } catch (boolean v14_0) {
                        v11 = v13_1;
                        String v13_3 = new StringBuilder();
                        v13_3.append("Error extracing purchase info: ");
                        v13_3.append(v14_0.getMessage());
                        com.google.android.gms.ads.internal.util.client.zzb.zzaC(v13_3.toString());
                        if (v11 == null) {
                            return v1_1;
                        } else {
                            v11.close();
                            return v1_1;
                        }
                    }
                    if (v13_1 == null) {
                        return v1_1;
                    } else {
                        v13_1.close();
                        return v1_1;
                    }
                } catch (boolean v14_3) {
                } catch (boolean v14_0) {
                }
            } else {
                return v1_1;
            }
        } else {
            return v1_1;
        }
    }