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.google.android.gms.measurement.internal.zze.zzd() calling method android.database.sqlite.SQLiteDatabase.update()


    public void zzd(String p7, byte[] p8)
    {
        com.google.android.gms.common.internal.zzab.zzhr(p7);
        this.zzwu();
        this.zzzg();
        com.google.android.gms.measurement.internal.zzp$zza v0_7 = new android.content.ContentValues();
        v0_7.put("remote_config", p8);
        try {
            String v1_4 = this.getWritableDatabase();
            String[] v4_1 = new String[1];
            v4_1[0] = p7;
        } catch (com.google.android.gms.measurement.internal.zzp$zza v0_5) {
            this.zzbsd().zzbsv().zzj("Error storing remote config", v0_5);
            return;
        }
        if (((long) v1_4.update("apps", v0_7, "app_id = ?", v4_1)) != 0) {
            return;
        } else {
            this.zzbsd().zzbsv().log("Failed to update remote config (got 0)");
            return;
        }
    }

Method com.google.android.gms.measurement.internal.zze.zza() calling method android.database.sqlite.SQLiteDatabase.update()


    public com.google.android.gms.measurement.internal.zze$zza zza(long p12, String p14, boolean p15, boolean p16, boolean p17)
    {
        com.google.android.gms.common.internal.zzab.zzhr(p14);
        this.zzwu();
        this.zzzg();
        String[] v10 = new String[1];
        v10[0] = p14;
        com.google.android.gms.measurement.internal.zze$zza v8_1 = new com.google.android.gms.measurement.internal.zze$zza();
        try {
            com.google.android.gms.measurement.internal.zze$zza v0_0 = this.getWritableDatabase();
            android.content.ContentValues v2_4 = new String[5];
            v2_4[0] = "day";
            v2_4[1] = "daily_events_count";
            v2_4[2] = "daily_public_events_count";
            v2_4[3] = "daily_conversions_count";
            v2_4[4] = "daily_error_events_count";
            String v4_16 = new String[1];
            v4_16[0] = p14;
            int v1_1 = v0_0.query("apps", v2_4, "app_id=?", v4_16, 0, 0, 0);
            try {
                com.google.android.gms.measurement.internal.zze$zza v0_1;
                if (v1_1.moveToFirst()) {
                    if (v1_1.getLong(0) == p12) {
                        v8_1.aiq = v1_1.getLong(1);
                        v8_1.aip = v1_1.getLong(2);
                        v8_1.air = v1_1.getLong(3);
                        v8_1.ais = v1_1.getLong(4);
                    }
                    v8_1.aiq = (v8_1.aiq + 1);
                    if (p15) {
                        v8_1.aip = (v8_1.aip + 1);
                    }
                    if (p16) {
                        v8_1.air = (v8_1.air + 1);
                    }
                    if (p17) {
                        v8_1.ais = (v8_1.ais + 1);
                    }
                    android.content.ContentValues v2_1 = new android.content.ContentValues();
                    v2_1.put("day", Long.valueOf(p12));
                    v2_1.put("daily_public_events_count", Long.valueOf(v8_1.aip));
                    v2_1.put("daily_events_count", Long.valueOf(v8_1.aiq));
                    v2_1.put("daily_conversions_count", Long.valueOf(v8_1.air));
                    v2_1.put("daily_error_events_count", Long.valueOf(v8_1.ais));
                    v0_0.update("apps", v2_1, "app_id=?", v10);
                    if (v1_1 != 0) {
                        v1_1.close();
                    }
                    v0_1 = v8_1;
                    return v0_1;
                } else {
                    this.zzbsd().zzbsx().zzj("Not updating daily counts, app is not known", p14);
                    if (v1_1 != 0) {
                        v1_1.close();
                    }
                    v0_1 = v8_1;
                    return v0_1;
                }
            } catch (com.google.android.gms.measurement.internal.zze$zza v0_5) {
                this.zzbsd().zzbsv().zzj("Error updating daily counts", v0_5);
                if (v1_1 != 0) {
                    v1_1.close();
                }
                v0_1 = v8_1;
                return v0_1;
            }
        } catch (com.google.android.gms.measurement.internal.zze$zza v0_6) {
            v1_1 = 0;
            if (v1_1 != 0) {
                v1_1.close();
            }
            throw v0_6;
        } catch (com.google.android.gms.measurement.internal.zze$zza v0_5) {
            v1_1 = 0;
        } catch (com.google.android.gms.measurement.internal.zze$zza v0_6) {
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzbsg() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    public String zzbsg()
    {
        String v0_0 = 0;
        try {
            Throwable v2_0 = this.getWritableDatabase().rawQuery("select app_id from queue where app_id not in (select app_id from apps where measurement_enabled=0) order by rowid limit 1;", 0);
            try {
                if (!v2_0.moveToFirst()) {
                    if (v2_0 == null) {
                        return v0_0;
                    } else {
                        v2_0.close();
                        return v0_0;
                    }
                } else {
                    v0_0 = v2_0.getString(0);
                    if (v2_0 == null) {
                        return v0_0;
                    } else {
                        v2_0.close();
                        return v0_0;
                    }
                }
            } catch (int v1_1) {
                this.zzbsd().zzbsv().zzj("Database error getting next bundle app id", v1_1);
                if (v2_0 == null) {
                    return v0_0;
                } else {
                    v2_0.close();
                    return v0_0;
                }
            }
        } catch (int v1_4) {
            v2_0 = 0;
            String v0_1 = v1_4;
            if (v2_0 != null) {
                v2_0.close();
            }
            throw v0_1;
        } catch (int v1_1) {
            v2_0 = 0;
        } catch (String v0_1) {
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzbi() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    public String zzbi(long p8)
    {
        String v0_0 = 0;
        this.zzwu();
        this.zzzg();
        try {
            int v1_4 = this.getWritableDatabase();
            String v3_4 = new String[1];
            v3_4[0] = String.valueOf(p8);
            Throwable v2_0 = v1_4.rawQuery("select app_id from apps where app_id in (select distinct app_id from raw_events) and config_fetched_time < ? order by failed_config_fetch_time limit 1;", v3_4);
            try {
                if (v2_0.moveToFirst()) {
                    v0_0 = v2_0.getString(0);
                    if (v2_0 == null) {
                        return v0_0;
                    } else {
                        v2_0.close();
                        return v0_0;
                    }
                } else {
                    this.zzbsd().zzbtc().log("No expired configs for apps with pending events");
                    if (v2_0 == null) {
                        return v0_0;
                    } else {
                        v2_0.close();
                        return v0_0;
                    }
                }
            } catch (int v1_0) {
                this.zzbsd().zzbsv().zzj("Error selecting expired configs", v1_0);
                if (v2_0 == null) {
                    return v0_0;
                } else {
                    v2_0.close();
                    return v0_0;
                }
            }
        } catch (int v1_1) {
            v2_0 = 0;
            String v0_1 = v1_1;
            if (v2_0 != null) {
                v2_0.close();
            }
            throw v0_1;
        } catch (int v1_0) {
            v2_0 = 0;
        } catch (String v0_1) {
        }
    }

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


    public void zza(String p15, long p16, com.google.android.gms.measurement.internal.zze$zzb p18)
    {
        android.database.Cursor v3_0 = 0;
        com.google.android.gms.common.internal.zzab.zzy(p18);
        this.zzwu();
        this.zzzg();
        try {
            String v12;
            boolean v2_19 = this.getWritableDatabase();
        } catch (boolean v2_1) {
            android.database.Cursor v11 = v3_0;
            if (v11 != null) {
                v11.close();
            }
            throw v2_1;
        } catch (boolean v2_0) {
            this.zzbsd().zzbsv().zzj("Data loss. Error selecting raw event", v2_0);
            if (v3_0 == null) {
                return;
            } else {
                v3_0.close();
                return;
            }
        } catch (boolean v2_1) {
            v11 = v3_0;
        }
        if (!android.text.TextUtils.isEmpty(p15)) {
            String v5_2 = new String[1];
            v5_2[0] = p15;
            v3_0 = v2_19.rawQuery("select metadata_fingerprint from raw_events where app_id = ? order by rowid limit 1;", v5_2);
            if (v3_0.moveToFirst()) {
                com.google.android.gms.measurement.internal.zzp$zza v4_10 = v3_0.getString(0);
                v3_0.close();
                v12 = v4_10;
            } else {
                if (v3_0 == null) {
                    return;
                } else {
                    v3_0.close();
                    return;
                }
            }
        } else {
            String v5_10 = new String[1];
            v5_10[0] = String.valueOf(p16);
            v3_0 = v2_19.rawQuery("select app_id, metadata_fingerprint from raw_events where app_id in (select app_id from apps where config_fetched_time >= ?) order by rowid limit 1;", v5_10);
            if (v3_0.moveToFirst()) {
                p15 = v3_0.getString(0);
                com.google.android.gms.measurement.internal.zzp$zza v4_15 = v3_0.getString(1);
                v3_0.close();
                v12 = v4_15;
            } else {
                if (v3_0 == null) {
                    return;
                } else {
                    v3_0.close();
                    return;
                }
            }
        }
        try {
            com.google.android.gms.measurement.internal.zzp$zza v4_17 = new String[1];
            v4_17[0] = "metadata";
            com.google.android.gms.internal.zzuh$zzb v6_12 = new String[2];
            v6_12[0] = p15;
            v6_12[1] = v12;
            v11 = v2_19.query("raw_events_metadata", v4_17, "app_id=? and metadata_fingerprint=?", v6_12, 0, 0, "rowid", "2");
        } catch (boolean v2_1) {
        } catch (boolean v2_0) {
            v3_0 = v11;
        }
        if (v11.moveToFirst()) {
            android.database.Cursor v3_7 = com.google.android.gms.internal.zzapn.zzbd(v11.getBlob(0));
            com.google.android.gms.measurement.internal.zzp$zza v4_20 = new com.google.android.gms.internal.zzuh$zze();
            try {
                v4_20.zzb(v3_7);
            } catch (boolean v2_20) {
                this.zzbsd().zzbsv().zze("Data loss. Failed to merge raw event metadata", p15, v2_20);
                if (v11 == null) {
                    return;
                } else {
                    v11.close();
                    return;
                }
            }
            if (v11.moveToNext()) {
                this.zzbsd().zzbsx().log("Get multiple raw event metadata records, expected one");
            }
            v11.close();
            p18.zzc(v4_20);
            com.google.android.gms.measurement.internal.zzp$zza v4_1 = new String[4];
            v4_1[0] = "rowid";
            v4_1[1] = "name";
            v4_1[2] = "timestamp";
            v4_1[3] = "data";
            com.google.android.gms.internal.zzuh$zzb v6_6 = new String[2];
            v6_6[0] = p15;
            v6_6[1] = v12;
            v3_0 = v2_19.query("raw_events", v4_1, "app_id=? and metadata_fingerprint=?", v6_6, 0, 0, "rowid", 0);
            if (!v3_0.moveToFirst()) {
                this.zzbsd().zzbsx().log("Raw event data disappeared while in transaction");
                if (v3_0 == null) {
                    return;
                } else {
                    v3_0.close();
                    return;
                }
            }
            do {
                com.google.android.gms.measurement.internal.zzp$zza v4_2 = v3_0.getLong(0);
                boolean v2_6 = com.google.android.gms.internal.zzapn.zzbd(v3_0.getBlob(3));
                com.google.android.gms.internal.zzuh$zzb v6_8 = new com.google.android.gms.internal.zzuh$zzb();
                v6_8.zzb(v2_6);
                v6_8.name = v3_0.getString(1);
                v6_8.ano = Long.valueOf(v3_0.getLong(2));
                if (p18.zza(v4_2, v6_8)) {
                } else {
                    if (v3_0 == null) {
                        return;
                    } else {
                        v3_0.close();
                        return;
                    }
                }
            } while(v3_0.moveToNext());
            if (v3_0 == null) {
                return;
            } else {
                v3_0.close();
                return;
            }
        } else {
            this.zzbsd().zzbsv().log("Raw event metadata record is missing");
            if (v11 == null) {
                return;
            } else {
                v11.close();
                return;
            }
        }
    }

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


    private long zzb(String p5, String[] p6)
    {
        try {
            android.database.Cursor v1 = this.getWritableDatabase().rawQuery(p5, p6);
        } catch (android.database.sqlite.SQLiteException v0_2) {
            this.zzbsd().zzbsv().zze("Database error", p5, v0_2);
            throw v0_2;
        } catch (android.database.sqlite.SQLiteException v0_3) {
            if (v1 != null) {
                v1.close();
            }
            throw v0_3;
        }
        if (!v1.moveToFirst()) {
            throw new android.database.sqlite.SQLiteException("Database returned empty set");
        } else {
            com.google.android.gms.measurement.internal.zzp$zza v2_2 = v1.getLong(0);
            if (v1 != null) {
                v1.close();
            }
            return v2_2;
        }
    }

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


    private long zza(String p6, String[] p7, long p8)
    {
        try {
            android.database.Cursor v1 = this.getWritableDatabase().rawQuery(p6, p7);
        } catch (int v0_4) {
            this.zzbsd().zzbsv().zze("Database error", p6, v0_4);
            throw v0_4;
        } catch (int v0_1) {
            if (v1 != null) {
                v1.close();
            }
            throw v0_1;
        }
        if (!v1.moveToFirst()) {
            if (v1 != null) {
                v1.close();
            }
        } else {
            p8 = v1.getLong(0);
            if (v1 != null) {
                v1.close();
            }
        }
        return p8;
    }

Method com.google.android.gms.measurement.internal.zze$zzc.onOpen() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    public void onOpen(android.database.sqlite.SQLiteDatabase p13)
    {
        if (android.os.Build$VERSION.SDK_INT < 15) {
            void v0_9 = p13.rawQuery("PRAGMA journal_mode=memory", 0);
            try {
                v0_9.moveToFirst();
                v0_9.close();
            } catch (Throwable v1_9) {
                v0_9.close();
                throw v1_9;
            }
        }
        this.zza(p13, "events", "CREATE TABLE IF NOT EXISTS events ( app_id TEXT NOT NULL, name TEXT NOT NULL, lifetime_count INTEGER NOT NULL, current_bundle_count INTEGER NOT NULL, last_fire_timestamp INTEGER NOT NULL, PRIMARY KEY (app_id, name)) ;", "app_id,name,lifetime_count,current_bundle_count,last_fire_timestamp", 0);
        this.zza(p13, "user_attributes", "CREATE TABLE IF NOT EXISTS user_attributes ( app_id TEXT NOT NULL, name TEXT NOT NULL, set_timestamp INTEGER NOT NULL, value BLOB NOT NULL, PRIMARY KEY (app_id, name)) ;", "app_id,name,set_timestamp,value", 0);
        this.zza(p13, "apps", "CREATE TABLE IF NOT EXISTS apps ( app_id TEXT NOT NULL, app_instance_id TEXT, gmp_app_id TEXT, resettable_device_id_hash TEXT, last_bundle_index INTEGER NOT NULL, last_bundle_end_timestamp INTEGER NOT NULL, PRIMARY KEY (app_id)) ;", "app_id,app_instance_id,gmp_app_id,resettable_device_id_hash,last_bundle_index,last_bundle_end_timestamp", com.google.android.gms.measurement.internal.zze.zzbsn());
        this.zza(p13, "queue", "CREATE TABLE IF NOT EXISTS queue ( app_id TEXT NOT NULL, bundle_end_timestamp INTEGER NOT NULL, data BLOB NOT NULL);", "app_id,bundle_end_timestamp,data", 0);
        this.zza(p13, "raw_events_metadata", "CREATE TABLE IF NOT EXISTS raw_events_metadata ( app_id TEXT NOT NULL, metadata_fingerprint INTEGER NOT NULL, metadata BLOB NOT NULL, PRIMARY KEY (app_id, metadata_fingerprint));", "app_id,metadata_fingerprint,metadata", 0);
        this.zza(p13, "raw_events", "CREATE TABLE IF NOT EXISTS raw_events ( app_id TEXT NOT NULL, name TEXT NOT NULL, timestamp INTEGER NOT NULL, metadata_fingerprint INTEGER NOT NULL, data BLOB NOT NULL);", "app_id,name,timestamp,metadata_fingerprint,data", 0);
        this.zza(p13, "event_filters", "CREATE TABLE IF NOT EXISTS event_filters ( app_id TEXT NOT NULL, audience_id INTEGER NOT NULL, filter_id INTEGER NOT NULL, event_name TEXT NOT NULL, data BLOB NOT NULL, PRIMARY KEY (app_id, event_name, audience_id, filter_id));", "app_id,audience_id,filter_id,event_name,data", 0);
        this.zza(p13, "property_filters", "CREATE TABLE IF NOT EXISTS property_filters ( app_id TEXT NOT NULL, audience_id INTEGER NOT NULL, filter_id INTEGER NOT NULL, property_name TEXT NOT NULL, data BLOB NOT NULL, PRIMARY KEY (app_id, property_name, audience_id, filter_id));", "app_id,audience_id,filter_id,property_name,data", 0);
        this.zza(p13, "audience_filter_values", "CREATE TABLE IF NOT EXISTS audience_filter_values ( app_id TEXT NOT NULL, audience_id INTEGER NOT NULL, current_results BLOB, PRIMARY KEY (app_id, audience_id));", "app_id,audience_id,current_results", 0);
        return;
    }

Method com.google.android.gms.measurement.internal.zze$zzc.zzb() calling method android.database.sqlite.SQLiteDatabase.rawQuery()


    private java.util.Set zzb(android.database.sqlite.SQLiteDatabase p4, String p5)
    {
        Throwable v0_1 = new java.util.HashSet();
        android.database.Cursor v1_5 = p4.rawQuery(new StringBuilder((String.valueOf(p5).length() + 22)).append("SELECT * FROM ").append(p5).append(" LIMIT 0").toString(), 0);
        try {
            java.util.Collections.addAll(v0_1, v1_5.getColumnNames());
            v1_5.close();
            return v0_1;
        } catch (Throwable v0_2) {
            v1_5.close();
            throw v0_2;
        }
    }

Method io.fabric.sdk.android.FabricContext.openOrCreateDatabase() calling method android.database.sqlite.SQLiteDatabase.openOrCreateDatabase()


    public android.database.sqlite.SQLiteDatabase openOrCreateDatabase(String p2, int p3, android.database.sqlite.SQLiteDatabase$CursorFactory p4, android.database.DatabaseErrorHandler p5)
    {
        return android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(this.getDatabasePath(p2).getPath(), p4, p5);
    }

Method io.fabric.sdk.android.FabricContext.openOrCreateDatabase() calling method android.database.sqlite.SQLiteDatabase.openOrCreateDatabase()


    public android.database.sqlite.SQLiteDatabase openOrCreateDatabase(String p2, int p3, android.database.sqlite.SQLiteDatabase$CursorFactory p4)
    {
        return android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(this.getDatabasePath(p2), p4);
    }

Method com.google.android.gms.measurement.internal.zze.zza() calling method android.database.sqlite.SQLiteDatabase.insert()


    public void zza(com.google.android.gms.measurement.internal.zzh p9, long p10)
    {
        this.zzwu();
        this.zzzg();
        com.google.android.gms.common.internal.zzab.zzy(p9);
        com.google.android.gms.common.internal.zzab.zzhr(p9.zzcjf);
        int v3_6 = new com.google.android.gms.internal.zzuh$zzb();
        v3_6.anp = Long.valueOf(p9.aiA);
        com.google.android.gms.measurement.internal.zzp$zza v0_3 = new com.google.android.gms.internal.zzuh$zzc[p9.aiB.size()];
        v3_6.ann = v0_3;
        long v4_0 = p9.aiB.iterator();
        String v1_1 = 0;
        while (v4_0.hasNext()) {
            com.google.android.gms.measurement.internal.zzp$zza v0_19 = ((String) v4_0.next());
            com.google.android.gms.internal.zzuh$zzc v5_1 = new com.google.android.gms.internal.zzuh$zzc();
            String v2_10 = (v1_1 + 1);
            v3_6.ann[v1_1] = v5_1;
            v5_1.name = v0_19;
            this.zzbrz().zza(v5_1, p9.aiB.get(v0_19));
            v1_1 = v2_10;
        }
        try {
            com.google.android.gms.measurement.internal.zzp$zza v0_7 = new byte[v3_6.aM()];
            String v1_3 = com.google.android.gms.internal.zzapo.zzbe(v0_7);
            v3_6.zza(v1_3);
            v1_3.az();
            this.zzbsd().zzbtc().zze("Saving event, name, data size", p9.mName, Integer.valueOf(v0_7.length));
            String v1_7 = new android.content.ContentValues();
            v1_7.put("app_id", p9.zzcjf);
            v1_7.put("name", p9.mName);
            v1_7.put("timestamp", Long.valueOf(p9.pJ));
            v1_7.put("metadata_fingerprint", Long.valueOf(p10));
            v1_7.put("data", v0_7);
            try {
                if (this.getWritableDatabase().insert("raw_events", 0, v1_7) != -1) {
                    return;
                } else {
                    this.zzbsd().zzbsv().log("Failed to insert raw event (got -1)");
                    return;
                }
            } catch (com.google.android.gms.measurement.internal.zzp$zza v0_16) {
                this.zzbsd().zzbsv().zzj("Error storing raw event", v0_16);
                return;
            }
        } catch (com.google.android.gms.measurement.internal.zzp$zza v0_9) {
            this.zzbsd().zzbsv().zzj("Data loss. Failed to serialize event params/data", v0_9);
            return;
        }
    }

Method com.google.android.gms.measurement.internal.zze.zza() calling method android.database.sqlite.SQLiteDatabase.insert()


    public void zza(com.google.android.gms.internal.zzuh$zze p7)
    {
        this.zzwu();
        this.zzzg();
        com.google.android.gms.common.internal.zzab.zzy(p7);
        com.google.android.gms.common.internal.zzab.zzhr(p7.zzck);
        com.google.android.gms.common.internal.zzab.zzy(p7.anz);
        this.zzbsh();
        com.google.android.gms.measurement.internal.zzp$zza v0_0 = this.zzyw().currentTimeMillis();
        if ((p7.anz.longValue() < (v0_0 - this.zzbsf().zzbrf())) || (p7.anz.longValue() > (this.zzbsf().zzbrf() + v0_0))) {
            this.zzbsd().zzbsx().zze("Storing bundle outside of the max uploading time span. now, timestamp", Long.valueOf(v0_0), p7.anz);
        }
        try {
            com.google.android.gms.measurement.internal.zzp$zza v0_4 = new byte[p7.aM()];
            String v1_1 = com.google.android.gms.internal.zzapo.zzbe(v0_4);
            p7.zza(v1_1);
            v1_1.az();
            com.google.android.gms.measurement.internal.zzp$zza v0_6 = this.zzbrz().zzj(v0_4);
            this.zzbsd().zzbtc().zzj("Saving bundle, size", Integer.valueOf(v0_6.length));
            String v1_6 = new android.content.ContentValues();
            v1_6.put("app_id", p7.zzck);
            v1_6.put("bundle_end_timestamp", p7.anz);
            v1_6.put("data", v0_6);
            try {
                if (this.getWritableDatabase().insert("queue", 0, v1_6) != -1) {
                    return;
                } else {
                    this.zzbsd().zzbsv().log("Failed to insert bundle (got -1)");
                    return;
                }
            } catch (com.google.android.gms.measurement.internal.zzp$zza v0_14) {
                this.zzbsd().zzbsv().zzj("Error storing bundle", v0_14);
                return;
            }
        } catch (com.google.android.gms.measurement.internal.zzp$zza v0_7) {
            this.zzbsd().zzbsv().zzj("Data loss. Failed to serialize bundle", v0_7);
            return;
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzy() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void zzy(String p6, int p7)
    {
        com.google.android.gms.common.internal.zzab.zzhr(p6);
        this.zzwu();
        this.zzzg();
        try {
            android.database.sqlite.SQLiteException v0_1 = this.getWritableDatabase();
            String v2_2 = new String[3];
            v2_2[0] = p6;
            v2_2[1] = p6;
            v2_2[2] = String.valueOf(p7);
            v0_1.execSQL("delete from user_attributes where app_id=? and name in (select name from user_attributes where app_id=? and name like \'_ltv_%\' order by set_timestamp desc limit ?,10);", v2_2);
        } catch (android.database.sqlite.SQLiteException v0_0) {
            this.zzbsd().zzbsv().zze("Error pruning currencies", p6, v0_0);
        }
        return;
    }

Method com.google.android.gms.measurement.internal.zze.zzlt() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void zzlt(String p5)
    {
        android.database.sqlite.SQLiteException v0_0 = this.getWritableDatabase();
        try {
            String v2_2 = new String[2];
            v2_2[0] = p5;
            v2_2[1] = p5;
            v0_0.execSQL("delete from raw_events_metadata where app_id=? and metadata_fingerprint not in (select distinct metadata_fingerprint from raw_events where app_id=?)", v2_2);
        } catch (android.database.sqlite.SQLiteException v0_1) {
            this.zzbsd().zzbsv().zzj("Failed to remove unused event metadata", v0_1);
        }
        return;
    }

Method com.google.android.gms.measurement.internal.zze$zzc.zza() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    private void zza(android.database.sqlite.SQLiteDatabase p7, String p8, String p9, java.util.Map p10)
    {
        String v1_0 = this.zzb(p7, p8);
        String v2_6 = p9.split(",");
        String v0_10 = 0;
        while (v0_10 < v2_6.length) {
            String v4 = v2_6[v0_10];
            if (v1_0.remove(v4)) {
                v0_10++;
            } else {
                throw new android.database.sqlite.SQLiteException(new StringBuilder(((String.valueOf(p8).length() + 35) + String.valueOf(v4).length())).append("Table ").append(p8).append(" is missing required column: ").append(v4).toString());
            }
        }
        if (p10 != null) {
            String v2_0 = p10.entrySet().iterator();
            while (v2_0.hasNext()) {
                String v0_7 = ((java.util.Map$Entry) v2_0.next());
                if (!v1_0.remove(v0_7.getKey())) {
                    p7.execSQL(((String) v0_7.getValue()));
                }
            }
        }
        if (v1_0.isEmpty()) {
            return;
        } else {
            throw new android.database.sqlite.SQLiteException(new StringBuilder((String.valueOf(p8).length() + 30)).append("Table ").append(p8).append(" table has extra columns").toString());
        }
    }

Method com.google.android.gms.measurement.internal.zze$zzc.zza() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    private void zza(android.database.sqlite.SQLiteDatabase p4, String p5, String p6, String p7, java.util.Map p8)
    {
        if (!this.zza(p4, p5)) {
            p4.execSQL(p6);
        }
        try {
            this.zza(p4, p5, p7, p8);
            return;
        } catch (android.database.sqlite.SQLiteException v0_1) {
            this.ait.zzbsd().zzbsv().zzj("Failed to verify columns on table that was just created", p5);
            throw v0_1;
        }
    }

Method com.facebook.react.modules.storage.ReactDatabaseSupplier.onCreate() calling method android.database.sqlite.SQLiteDatabase.execSQL()


    public void onCreate(android.database.sqlite.SQLiteDatabase p2)
    {
        p2.execSQL("CREATE TABLE catalystLocalStorage (key TEXT PRIMARY KEY, value TEXT NOT NULL)");
        return;
    }

Method com.google.android.gms.measurement.internal.zze.zzz() calling method android.database.sqlite.SQLiteDatabase.delete()


    void zzz(String p9, int p10)
    {
        this.zzzg();
        this.zzwu();
        com.google.android.gms.common.internal.zzab.zzhr(p9);
        android.database.sqlite.SQLiteDatabase v0 = this.getWritableDatabase();
        String[] v3_0 = new String[2];
        v3_0[0] = p9;
        v3_0[1] = String.valueOf(p10);
        v0.delete("property_filters", "app_id=? and audience_id=?", v3_0);
        String[] v3_1 = new String[2];
        v3_1[0] = p9;
        v3_1[1] = String.valueOf(p10);
        v0.delete("event_filters", "app_id=? and audience_id=?", v3_1);
        return;
    }

Method com.google.android.gms.measurement.internal.zze.zzls() calling method android.database.sqlite.SQLiteDatabase.delete()


    void zzls(String p6)
    {
        this.zzzg();
        this.zzwu();
        com.google.android.gms.common.internal.zzab.zzhr(p6);
        try {
            Integer v0_0 = this.getWritableDatabase();
            com.google.android.gms.measurement.internal.zzp$zza v1_3 = new String[1];
            v1_3[0] = p6;
            Integer v0_2 = (v0_0.delete("audience_filter_values", "app_id=?", v1_3) + (((((((v0_0.delete("events", "app_id=?", v1_3) + 0) + v0_0.delete("user_attributes", "app_id=?", v1_3)) + v0_0.delete("apps", "app_id=?", v1_3)) + v0_0.delete("raw_events", "app_id=?", v1_3)) + v0_0.delete("raw_events_metadata", "app_id=?", v1_3)) + v0_0.delete("event_filters", "app_id=?", v1_3)) + v0_0.delete("property_filters", "app_id=?", v1_3)));
        } catch (Integer v0_4) {
            this.zzbsd().zzbsv().zze("Error deleting application data. appId, error", p6, v0_4);
            return;
        }
        if (v0_2 <= null) {
            return;
        } else {
            this.zzbsd().zzbtc().zze("Deleted application data. app, records", p6, Integer.valueOf(v0_2));
            return;
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzlq() calling method android.database.sqlite.SQLiteDatabase.delete()


    void zzlq(String p7)
    {
        this.zzzg();
        this.zzwu();
        com.google.android.gms.common.internal.zzab.zzhr(p7);
        android.database.sqlite.SQLiteDatabase v0 = this.getWritableDatabase();
        String[] v3_1 = new String[1];
        v3_1[0] = p7;
        v0.delete("property_filters", "app_id=?", v3_1);
        String[] v3_0 = new String[1];
        v3_0[0] = p7;
        v0.delete("event_filters", "app_id=?", v3_0);
        return;
    }

Method com.google.android.gms.measurement.internal.zze.zzlo() calling method android.database.sqlite.SQLiteDatabase.delete()


    public long zzlo(String p7)
    {
        com.google.android.gms.common.internal.zzab.zzhr(p7);
        this.zzwu();
        this.zzzg();
        try {
            long v0_3 = this.getWritableDatabase();
            com.google.android.gms.measurement.internal.zzp$zza v1_0 = String.valueOf(this.zzbsf().zzll(p7));
            String[] v4_1 = new String[2];
            v4_1[0] = p7;
            v4_1[1] = v1_0;
            long v0_1 = ((long) v0_3.delete("raw_events", "rowid in (select rowid from raw_events where app_id=? order by rowid desc limit -1 offset ?)", v4_1));
        } catch (long v0_2) {
            this.zzbsd().zzbsv().zzj("Error deleting over the limit events", v0_2);
            v0_1 = 0;
        }
        return v0_1;
    }

Method com.google.android.gms.measurement.internal.zze.zzbsi() calling method android.database.sqlite.SQLiteDatabase.delete()


    void zzbsi()
    {
        this.zzwu();
        this.zzzg();
        if (this.zzbsm()) {
            Integer v0_3 = this.getWritableDatabase();
            com.google.android.gms.measurement.internal.zzp$zza v1_3 = new String[2];
            v1_3[0] = String.valueOf(this.zzyw().currentTimeMillis());
            v1_3[1] = String.valueOf(this.zzbsf().zzbrf());
            Integer v0_0 = v0_3.delete("queue", "abs(bundle_end_timestamp - ?) > cast(? as integer)", v1_3);
            if (v0_0 > null) {
                this.zzbsd().zzbtc().zzj("Deleted stale rows. rowsDeleted", Integer.valueOf(v0_0));
            }
        }
        return;
    }

Method com.google.android.gms.measurement.internal.zze.zzbh() calling method android.database.sqlite.SQLiteDatabase.delete()


    public void zzbh(long p6)
    {
        this.zzwu();
        this.zzzg();
        com.google.android.gms.measurement.internal.zzp$zza v0_3 = this.getWritableDatabase();
        String v1_1 = new String[1];
        v1_1[0] = String.valueOf(p6);
        if (v0_3.delete("queue", "rowid=?", v1_1) != 1) {
            this.zzbsd().zzbsv().log("Deleted fewer rows from queue than expected");
        }
        return;
    }

Method com.google.android.gms.measurement.internal.zze.zzar() calling method android.database.sqlite.SQLiteDatabase.delete()


    public void zzar(String p6, String p7)
    {
        com.google.android.gms.common.internal.zzab.zzhr(p6);
        com.google.android.gms.common.internal.zzab.zzhr(p7);
        this.zzwu();
        this.zzzg();
        try {
            android.database.sqlite.SQLiteException v0_3 = this.getWritableDatabase();
            String[] v3_1 = new String[2];
            v3_1[0] = p6;
            v3_1[1] = p7;
            this.zzbsd().zzbtc().zzj("Deleted user attribute rows:", Integer.valueOf(v0_3.delete("user_attributes", "app_id=? and name=?", v3_1)));
        } catch (android.database.sqlite.SQLiteException v0_2) {
            this.zzbsd().zzbsv().zzd("Error deleting user attribute", p6, p7, v0_2);
        }
        return;
    }

Method com.google.android.gms.measurement.internal.zze.zzac() calling method android.database.sqlite.SQLiteDatabase.delete()


    public void zzac(java.util.List p7)
    {
        com.google.android.gms.common.internal.zzab.zzy(p7);
        this.zzwu();
        this.zzzg();
        String v2_3 = new StringBuilder("rowid in (");
        com.google.android.gms.measurement.internal.zzp$zza v1_4 = 0;
        while (v1_4 < p7.size()) {
            if (v1_4 != null) {
                v2_3.append(",");
            }
            v2_3.append(((Long) p7.get(v1_4)).longValue());
            v1_4++;
        }
        v2_3.append(")");
        Integer v0_2 = this.getWritableDatabase().delete("raw_events", v2_3.toString(), 0);
        if (v0_2 != p7.size()) {
            this.zzbsd().zzbsv().zze("Deleted fewer rows from raw events table than expected", Integer.valueOf(v0_2), Integer.valueOf(p7.size()));
        }
        return;
    }

Method com.facebook.react.modules.storage.AsyncStorageModule$3.doInBackgroundGuarded() calling method android.database.sqlite.SQLiteDatabase.delete()


    protected varargs void doInBackgroundGuarded(Void[] p12)
    {
        if (com.facebook.react.modules.storage.AsyncStorageModule.access$000(this.this$0)) {
            com.facebook.react.bridge.WritableMap v1 = 0;
            try {
                com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().beginTransaction();
                int v3 = 0;
            } catch (String v4_31) {
                try {
                    com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().endTransaction();
                } catch (Exception v0_0) {
                    com.facebook.common.logging.FLog.w("React", v0_0.getMessage(), v0_0);
                    if (v1 != null) {
                    } else {
                        com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_0.getMessage());
                    }
                }
                throw v4_31;
            } catch (Exception v0_2) {
                com.facebook.common.logging.FLog.w("React", v0_2.getMessage(), v0_2);
                v1 = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_2.getMessage());
                try {
                    com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().endTransaction();
                } catch (Exception v0_3) {
                    com.facebook.common.logging.FLog.w("React", v0_3.getMessage(), v0_3);
                    if (v1 != null) {
                    } else {
                        v1 = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_3.getMessage());
                    }
                }
                if (v1 == null) {
                    Object[] v5_10 = new Object[0];
                    this.val$callback.invoke(v5_10);
                } else {
                    String v4_30 = this.val$callback;
                    Object[] v5_11 = new Object[1];
                    v5_11[0] = v1;
                    v4_30.invoke(v5_11);
                }
            }
            while (v3 < this.val$keys.size()) {
                int v2 = Math.min((this.val$keys.size() - v3), 999);
                com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().delete("catalystLocalStorage", com.facebook.react.modules.storage.AsyncLocalStorageUtil.buildKeySelection(v2), com.facebook.react.modules.storage.AsyncLocalStorageUtil.buildKeySelectionArgs(this.val$keys, v3, v2));
                v3 += 999;
            }
            com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().setTransactionSuccessful();
            try {
                com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().endTransaction();
            } catch (Exception v0_1) {
                com.facebook.common.logging.FLog.w("React", v0_1.getMessage(), v0_1);
                if (0 != 0) {
                } else {
                    v1 = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_1.getMessage());
                }
            }
        } else {
            String v4_1 = this.val$callback;
            Object[] v5_3 = new Object[1];
            v5_3[0] = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getDBError(0);
            v4_1.invoke(v5_3);
        }
        return;
    }

Method com.facebook.react.modules.storage.ReactDatabaseSupplier.clear() calling method android.database.sqlite.SQLiteDatabase.delete()


    declared_synchronized void clear()
    {
        try {
            this.get().delete("catalystLocalStorage", 0, 0);
            return;
        } catch (Throwable v0_1) {
            throw v0_1;
        }
    }

Method com.facebook.react.modules.storage.AsyncStorageModule$2.doInBackgroundGuarded() calling method android.database.sqlite.SQLiteDatabase.compileStatement()


    protected varargs void doInBackgroundGuarded(Void[] p13)
    {
        if (com.facebook.react.modules.storage.AsyncStorageModule.access$000(this.this$0)) {
            android.database.sqlite.SQLiteStatement v4 = com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().compileStatement("INSERT OR REPLACE INTO catalystLocalStorage VALUES (?, ?);");
            com.facebook.react.bridge.WritableMap v1_0 = 0;
            try {
                com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().beginTransaction();
                int v2 = 0;
            } catch (String v5_7) {
                try {
                    com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().endTransaction();
                } catch (Exception v0_1) {
                    com.facebook.common.logging.FLog.w("React", v0_1.getMessage(), v0_1);
                    if (v1_0 != null) {
                    } else {
                        com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_1.getMessage());
                    }
                }
                throw v5_7;
            } catch (Exception v0_6) {
                com.facebook.common.logging.FLog.w("React", v0_6.getMessage(), v0_6);
                v1_0 = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_6.getMessage());
                try {
                    com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().endTransaction();
                } catch (Exception v0_0) {
                    com.facebook.common.logging.FLog.w("React", v0_0.getMessage(), v0_0);
                    if (v1_0 != null) {
                    } else {
                        v1_0 = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_0.getMessage());
                    }
                }
                if (v1_0 == null) {
                    String v6_1 = new Object[0];
                    this.val$callback.invoke(v6_1);
                } else {
                    String v5_6 = this.val$callback;
                    String v6_2 = new Object[1];
                    v6_2[0] = v1_0;
                    v5_6.invoke(v6_2);
                }
            }
            while (v2 < this.val$keyValueArray.size()) {
                if (this.val$keyValueArray.getArray(v2).size() == 2) {
                    if (this.val$keyValueArray.getArray(v2).getString(0) != null) {
                        if (this.val$keyValueArray.getArray(v2).getString(1) != null) {
                            v4.clearBindings();
                            v4.bindString(1, this.val$keyValueArray.getArray(v2).getString(0));
                            v4.bindString(2, this.val$keyValueArray.getArray(v2).getString(1));
                            v4.execute();
                            v2++;
                        } else {
                            com.facebook.react.bridge.WritableMap v1_1 = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getInvalidValueError(0);
                            try {
                                com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().endTransaction();
                            } catch (Exception v0_2) {
                                com.facebook.common.logging.FLog.w("React", v0_2.getMessage(), v0_2);
                                if (v1_1 == null) {
                                    com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_2.getMessage());
                                }
                            }
                        }
                    } else {
                        com.facebook.react.bridge.WritableMap v1_2 = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getInvalidKeyError(0);
                        try {
                            com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().endTransaction();
                        } catch (Exception v0_3) {
                            com.facebook.common.logging.FLog.w("React", v0_3.getMessage(), v0_3);
                            if (v1_2 == null) {
                                com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_3.getMessage());
                            }
                        }
                    }
                } else {
                    com.facebook.react.bridge.WritableMap v1_3 = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getInvalidValueError(0);
                    try {
                        com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().endTransaction();
                    } catch (Exception v0_4) {
                        com.facebook.common.logging.FLog.w("React", v0_4.getMessage(), v0_4);
                        if (v1_3 == null) {
                            com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_4.getMessage());
                        }
                    }
                }
            }
            com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().setTransactionSuccessful();
            try {
                com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().endTransaction();
            } catch (Exception v0_5) {
                com.facebook.common.logging.FLog.w("React", v0_5.getMessage(), v0_5);
                if (0 != 0) {
                } else {
                    v1_0 = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v0_5.getMessage());
                }
            }
        } else {
            String v5_29 = this.val$callback;
            String v6_11 = new Object[1];
            v6_11[0] = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getDBError(0);
            v5_29.invoke(v6_11);
        }
        return;
    }

Method com.google.android.gms.measurement.internal.zze.zzn() calling method android.database.sqlite.SQLiteDatabase.query()


    public java.util.List zzn(String p12, int p13, int p14)
    {
        int v0_9;
        java.util.ArrayList v1_0 = 1;
        this.zzwu();
        this.zzzg();
        if (p13 <= 0) {
            v0_9 = 0;
        } else {
            v0_9 = 1;
        }
        com.google.android.gms.common.internal.zzab.zzbo(v0_9);
        if (p14 <= 0) {
            v1_0 = 0;
        }
        com.google.android.gms.common.internal.zzab.zzbo(v1_0);
        com.google.android.gms.common.internal.zzab.zzhr(p12);
        try {
            int v0_2 = this.getWritableDatabase();
            java.util.ArrayList v2_4 = new String[2];
            v2_4[0] = "rowid";
            v2_4[1] = "data";
            com.google.android.gms.measurement.internal.zzp$zza v4_3 = new String[1];
            v4_3[0] = p12;
            java.util.ArrayList v2_2 = v0_2.query("queue", v2_4, "app_id=?", v4_3, 0, 0, "rowid", String.valueOf(p13));
            try {
                int v0_0;
                if (v2_2.moveToFirst()) {
                    java.util.ArrayList v1_4 = new java.util.ArrayList();
                    int v3_4 = 0;
                    while(true) {
                        com.google.android.gms.measurement.internal.zzp$zza v4_4 = v2_2.getLong(0);
                        byte[] v6_2 = this.zzbrz().zzw(v2_2.getBlob(1));
                        if ((!v1_4.isEmpty()) && ((v6_2.length + v3_4) > p14)) {
                            break;
                        }
                        int v0_14 = com.google.android.gms.internal.zzapn.zzbd(v6_2);
                        com.google.android.gms.internal.zzuh$zze v7_2 = new com.google.android.gms.internal.zzuh$zze();
                        try {
                            v7_2.zzb(v0_14);
                        } catch (int v0_16) {
                            this.zzbsd().zzbsv().zze("Failed to merge queued bundle", p12, v0_16);
                            int v0_10 = v3_4;
                        }
                        v0_10 = (v6_2.length + v3_4);
                        v1_4.add(android.util.Pair.create(v7_2, Long.valueOf(v4_4)));
                        if ((!v2_2.moveToNext()) || (v0_10 > p14)) {
                            break;
                        }
                        v3_4 = v0_10;
                    }
                    if (v2_2 != null) {
                        v2_2.close();
                    }
                    v0_0 = v1_4;
                    return v0_0;
                } else {
                    v0_0 = java.util.Collections.emptyList();
                    if (v2_2 == null) {
                        return v0_0;
                    } else {
                        v2_2.close();
                        return v0_0;
                    }
                }
            } catch (int v0_1) {
                if (v2_2 != null) {
                    v2_2.close();
                }
                throw v0_1;
            } catch (int v0_3) {
                java.util.ArrayList v1_2 = v2_2;
                try {
                    this.zzbsd().zzbsv().zze("Error querying bundles", p12, v0_3);
                    v0_0 = java.util.Collections.emptyList();
                } catch (int v0_1) {
                    v2_2 = v1_2;
                }
                if (v1_2 == null) {
                    return v0_0;
                } else {
                    v1_2.close();
                    return v0_0;
                }
            }
        } catch (int v0_1) {
            v2_2 = 0;
        } catch (int v0_3) {
            v1_2 = 0;
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzlr() calling method android.database.sqlite.SQLiteDatabase.query()


    java.util.Map zzlr(String p10)
    {
        this.zzzg();
        this.zzwu();
        com.google.android.gms.common.internal.zzab.zzhr(p10);
        android.support.v4.util.ArrayMap v0_9 = this.getWritableDatabase();
        try {
            android.support.v4.util.ArrayMap v2_4 = new String[2];
            v2_4[0] = "audience_id";
            v2_4[1] = "current_results";
            com.google.android.gms.measurement.internal.zzp$zza v4_3 = new String[1];
            v4_3[0] = p10;
            android.support.v4.util.ArrayMap v2_0 = v0_9.query("audience_filter_values", v2_4, "app_id=?", v4_3, 0, 0, 0);
            try {
                android.support.v4.util.ArrayMap v0_11;
                if (v2_0.moveToFirst()) {
                    android.support.v4.util.ArrayMap v1_2 = new android.support.v4.util.ArrayMap();
                    do {
                        Integer v3_2 = v2_0.getInt(0);
                        android.support.v4.util.ArrayMap v0_6 = com.google.android.gms.internal.zzapn.zzbd(v2_0.getBlob(1));
                        com.google.android.gms.measurement.internal.zzp$zza v4_5 = new com.google.android.gms.internal.zzuh$zzf();
                        v4_5.zzb(v0_6);
                        v1_2.put(Integer.valueOf(v3_2), v4_5);
                    } while(v2_0.moveToNext());
                    if (v2_0 != null) {
                        v2_0.close();
                    }
                    v0_11 = v1_2;
                    return v0_11;
                } else {
                    if (v2_0 != null) {
                        v2_0.close();
                    }
                    v0_11 = 0;
                    return v0_11;
                }
            } catch (android.support.v4.util.ArrayMap v0_1) {
                if (v2_0 != null) {
                    v2_0.close();
                }
                throw v0_1;
            } catch (android.support.v4.util.ArrayMap v0_0) {
                android.support.v4.util.ArrayMap v1_0 = v2_0;
                try {
                    this.zzbsd().zzbsv().zzj("Database error querying filter results", v0_0);
                } catch (android.support.v4.util.ArrayMap v0_1) {
                    v2_0 = v1_0;
                }
                if (v1_0 != null) {
                    v1_0.close();
                }
                v0_11 = 0;
                return v0_11;
            }
        } catch (android.support.v4.util.ArrayMap v0_1) {
            v2_0 = 0;
        } catch (android.support.v4.util.ArrayMap v0_0) {
            v1_0 = 0;
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzlp() calling method android.database.sqlite.SQLiteDatabase.query()


    public byte[] zzlp(String p10)
    {
        com.google.android.gms.common.internal.zzab.zzhr(p10);
        this.zzwu();
        this.zzzg();
        try {
            byte[] v0_5 = this.getWritableDatabase();
            com.google.android.gms.measurement.internal.zzp$zza v2_6 = new String[1];
            v2_6[0] = "remote_config";
            String[] v4_2 = new String[1];
            v4_2[0] = p10;
            int v1_0 = v0_5.query("apps", v2_6, "app_id=?", v4_2, 0, 0, 0);
            try {
                byte[] v0_4;
                if (v1_0.moveToFirst()) {
                    v0_4 = v1_0.getBlob(0);
                    if (v1_0.moveToNext()) {
                        this.zzbsd().zzbsv().log("Got multiple records for app config, expected one");
                    }
                    if (v1_0 == 0) {
                        return v0_4;
                    } else {
                        v1_0.close();
                        return v0_4;
                    }
                } else {
                    if (v1_0 != 0) {
                        v1_0.close();
                    }
                    v0_4 = 0;
                    return v0_4;
                }
            } catch (byte[] v0_0) {
                this.zzbsd().zzbsv().zze("Error querying remote config", p10, v0_0);
                if (v1_0 != 0) {
                    v1_0.close();
                }
                v0_4 = 0;
                return v0_4;
            }
        } catch (byte[] v0_1) {
            v1_0 = 0;
            if (v1_0 != 0) {
                v1_0.close();
            }
            throw v0_1;
        } catch (byte[] v0_0) {
            v1_0 = 0;
        } catch (byte[] v0_1) {
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzln() calling method android.database.sqlite.SQLiteDatabase.query()


    public com.google.android.gms.measurement.internal.zza zzln(String p12)
    {
        com.google.android.gms.common.internal.zzab.zzhr(p12);
        this.zzwu();
        this.zzzg();
        try {
            int v0_3 = this.getWritableDatabase();
            com.google.android.gms.measurement.internal.zzp$zza v2_0 = new String[20];
            v2_0[0] = "app_instance_id";
            v2_0[1] = "gmp_app_id";
            v2_0[2] = "resettable_device_id_hash";
            v2_0[3] = "last_bundle_index";
            v2_0[4] = "last_bundle_start_timestamp";
            v2_0[5] = "last_bundle_end_timestamp";
            v2_0[6] = "app_version";
            v2_0[7] = "app_store";
            v2_0[8] = "gmp_version";
            v2_0[9] = "dev_cert_hash";
            v2_0[10] = "measurement_enabled";
            v2_0[11] = "day";
            v2_0[12] = "daily_public_events_count";
            v2_0[13] = "daily_events_count";
            v2_0[14] = "daily_conversions_count";
            v2_0[15] = "config_fetched_time";
            v2_0[16] = "failed_config_fetch_time";
            v2_0[17] = "app_version_int";
            v2_0[18] = "firebase_instance_id";
            v2_0[19] = "daily_error_events_count";
            String[] v4_21 = new String[1];
            v4_21[0] = p12;
            int v1_1 = v0_3.query("apps", v2_0, "app_id=?", v4_21, 0, 0, 0);
            try {
                int v0_1;
                if (v1_1.moveToFirst()) {
                    com.google.android.gms.measurement.internal.zzp$zza v2_19;
                    v0_1 = new com.google.android.gms.measurement.internal.zza(this.ahD, p12);
                    v0_1.zzky(v1_1.getString(0));
                    v0_1.zzkz(v1_1.getString(1));
                    v0_1.zzla(v1_1.getString(2));
                    v0_1.zzaz(v1_1.getLong(3));
                    v0_1.zzau(v1_1.getLong(4));
                    v0_1.zzav(v1_1.getLong(5));
                    v0_1.setAppVersion(v1_1.getString(6));
                    v0_1.zzlc(v1_1.getString(7));
                    v0_1.zzax(v1_1.getLong(8));
                    v0_1.zzay(v1_1.getLong(9));
                    if (!v1_1.isNull(10)) {
                        v2_19 = v1_1.getInt(10);
                    } else {
                        v2_19 = 1;
                    }
                    com.google.android.gms.measurement.internal.zzp$zza v2_20;
                    if (v2_19 == null) {
                        v2_20 = 0;
                    } else {
                        v2_20 = 1;
                    }
                    com.google.android.gms.measurement.internal.zzp$zza v2_37;
                    v0_1.setMeasurementEnabled(v2_20);
                    v0_1.zzbc(v1_1.getLong(11));
                    v0_1.zzbd(v1_1.getLong(12));
                    v0_1.zzbe(v1_1.getLong(13));
                    v0_1.zzbf(v1_1.getLong(14));
                    v0_1.zzba(v1_1.getLong(15));
                    v0_1.zzbb(v1_1.getLong(16));
                    if (!v1_1.isNull(17)) {
                        v2_37 = ((long) v1_1.getInt(17));
                    } else {
                        v2_37 = -2147483648;
                    }
                    v0_1.zzaw(v2_37);
                    v0_1.zzlb(v1_1.getString(18));
                    v0_1.zzbg(v1_1.getLong(19));
                    v0_1.zzbpr();
                    if (v1_1.moveToNext()) {
                        this.zzbsd().zzbsv().log("Got multiple records for app, expected one");
                    }
                    if (v1_1 == 0) {
                        return v0_1;
                    } else {
                        v1_1.close();
                        return v0_1;
                    }
                } else {
                    if (v1_1 != 0) {
                        v1_1.close();
                    }
                    v0_1 = 0;
                    return v0_1;
                }
            } catch (int v0_0) {
                this.zzbsd().zzbsv().zze("Error querying app", p12, v0_0);
                if (v1_1 != 0) {
                    v1_1.close();
                }
                v0_1 = 0;
                return v0_1;
            }
        } catch (int v0_2) {
            v1_1 = 0;
            if (v1_1 != 0) {
                v1_1.close();
            }
            throw v0_2;
        } catch (int v0_0) {
            v1_1 = 0;
        } catch (int v0_2) {
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzlm() calling method android.database.sqlite.SQLiteDatabase.query()


    public java.util.List zzlm(String p12)
    {
        android.database.Cursor v10 = 0;
        com.google.android.gms.common.internal.zzab.zzhr(p12);
        this.zzwu();
        this.zzzg();
        java.util.ArrayList v9_1 = new java.util.ArrayList();
        try {
            java.util.ArrayList v0_8 = this.getWritableDatabase();
            String v2_0 = new String[3];
            v2_0[0] = "name";
            v2_0[1] = "set_timestamp";
            v2_0[2] = "value";
            long v4_4 = new String[1];
            v4_4[0] = p12;
            android.database.Cursor v7_1 = v0_8.query("user_attributes", v2_0, "app_id=?", v4_4, 0, 0, "rowid", String.valueOf(this.zzbsf().zzbqz()));
            try {
                java.util.ArrayList v0_9;
                if (!v7_1.moveToFirst()) {
                    if (v7_1 != null) {
                        v7_1.close();
                    }
                    v0_9 = v9_1;
                    return v0_9;
                }
            } catch (java.util.ArrayList v0_1) {
                v10 = v7_1;
                if (v10 != null) {
                    v10.close();
                }
                throw v0_1;
            } catch (java.util.ArrayList v0_0) {
                com.google.android.gms.measurement.internal.zzak v1_0 = v7_1;
                try {
                    this.zzbsd().zzbsv().zze("Error querying user properties", p12, v0_0);
                } catch (java.util.ArrayList v0_1) {
                    v10 = v1_0;
                }
                if (v1_0 != null) {
                    v1_0.close();
                }
                v0_9 = 0;
                return v0_9;
            }
            do {
                String v3_4 = v7_1.getString(0);
                long v4_5 = v7_1.getLong(1);
                Object v6_1 = this.zzb(v7_1, 2);
                if (v6_1 != null) {
                    v9_1.add(new com.google.android.gms.measurement.internal.zzak(p12, v3_4, v4_5, v6_1));
                } else {
                    this.zzbsd().zzbsv().log("Read invalid user property value, ignoring it");
                }
            } while(v7_1.moveToNext());
            if (v7_1 != null) {
                v7_1.close();
            }
            v0_9 = v9_1;
            return v0_9;
        } catch (java.util.ArrayList v0_1) {
        } catch (java.util.ArrayList v0_0) {
            v1_0 = 0;
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzau() calling method android.database.sqlite.SQLiteDatabase.query()


    java.util.Map zzau(String p11, String p12)
    {
        this.zzzg();
        this.zzwu();
        com.google.android.gms.common.internal.zzab.zzhr(p11);
        com.google.android.gms.common.internal.zzab.zzhr(p12);
        android.support.v4.util.ArrayMap v8_1 = new android.support.v4.util.ArrayMap();
        android.support.v4.util.ArrayMap v0_14 = this.getWritableDatabase();
        try {
            com.google.android.gms.measurement.internal.zzp$zza v2_1 = new String[2];
            v2_1[0] = "audience_id";
            v2_1[1] = "data";
            String[] v4_3 = new String[2];
            v4_3[0] = p11;
            v4_3[1] = p12;
            int v1_0 = v0_14.query("property_filters", v2_1, "app_id=? AND property_name=?", v4_3, 0, 0, 0);
            try {
                android.support.v4.util.ArrayMap v0_13;
                if (!v1_0.moveToFirst()) {
                    v0_13 = java.util.Collections.emptyMap();
                    if (v1_0 == 0) {
                        return v0_13;
                    } else {
                        v1_0.close();
                        return v0_13;
                    }
                }
            } catch (android.support.v4.util.ArrayMap v0_0) {
                this.zzbsd().zzbsv().zzj("Database error querying filters", v0_0);
                if (v1_0 != 0) {
                    v1_0.close();
                }
                v0_13 = 0;
                return v0_13;
            }
            do {
                android.support.v4.util.ArrayMap v0_5 = com.google.android.gms.internal.zzapn.zzbd(v1_0.getBlob(1));
                com.google.android.gms.measurement.internal.zzp$zza v2_3 = new com.google.android.gms.internal.zzuf$zze();
                v2_3.zzb(v0_5);
                Integer v3_4 = v1_0.getInt(0);
                android.support.v4.util.ArrayMap v0_11 = ((java.util.List) v8_1.get(Integer.valueOf(v3_4)));
                if (v0_11 == null) {
                    v0_11 = new java.util.ArrayList();
                    v8_1.put(Integer.valueOf(v3_4), v0_11);
                }
                v0_11.add(v2_3);
            } while(v1_0.moveToNext());
            if (v1_0 != 0) {
                v1_0.close();
            }
            v0_13 = v8_1;
            return v0_13;
        } catch (android.support.v4.util.ArrayMap v0_1) {
            v1_0 = 0;
            if (v1_0 != 0) {
                v1_0.close();
            }
            throw v0_1;
        } catch (android.support.v4.util.ArrayMap v0_0) {
            v1_0 = 0;
        } catch (android.support.v4.util.ArrayMap v0_1) {
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzat() calling method android.database.sqlite.SQLiteDatabase.query()


    java.util.Map zzat(String p11, String p12)
    {
        this.zzzg();
        this.zzwu();
        com.google.android.gms.common.internal.zzab.zzhr(p11);
        com.google.android.gms.common.internal.zzab.zzhr(p12);
        android.support.v4.util.ArrayMap v8_1 = new android.support.v4.util.ArrayMap();
        android.support.v4.util.ArrayMap v0_14 = this.getWritableDatabase();
        try {
            com.google.android.gms.measurement.internal.zzp$zza v2_1 = new String[2];
            v2_1[0] = "audience_id";
            v2_1[1] = "data";
            String[] v4_3 = new String[2];
            v4_3[0] = p11;
            v4_3[1] = p12;
            int v1_0 = v0_14.query("event_filters", v2_1, "app_id=? AND event_name=?", v4_3, 0, 0, 0);
            try {
                android.support.v4.util.ArrayMap v0_13;
                if (!v1_0.moveToFirst()) {
                    v0_13 = java.util.Collections.emptyMap();
                    if (v1_0 == 0) {
                        return v0_13;
                    } else {
                        v1_0.close();
                        return v0_13;
                    }
                }
            } catch (android.support.v4.util.ArrayMap v0_0) {
                this.zzbsd().zzbsv().zzj("Database error querying filters", v0_0);
                if (v1_0 != 0) {
                    v1_0.close();
                }
                v0_13 = 0;
                return v0_13;
            }
            do {
                android.support.v4.util.ArrayMap v0_5 = com.google.android.gms.internal.zzapn.zzbd(v1_0.getBlob(1));
                com.google.android.gms.measurement.internal.zzp$zza v2_3 = new com.google.android.gms.internal.zzuf$zzb();
                v2_3.zzb(v0_5);
                Integer v3_4 = v1_0.getInt(0);
                android.support.v4.util.ArrayMap v0_11 = ((java.util.List) v8_1.get(Integer.valueOf(v3_4)));
                if (v0_11 == null) {
                    v0_11 = new java.util.ArrayList();
                    v8_1.put(Integer.valueOf(v3_4), v0_11);
                }
                v0_11.add(v2_3);
            } while(v1_0.moveToNext());
            if (v1_0 != 0) {
                v1_0.close();
            }
            v0_13 = v8_1;
            return v0_13;
        } catch (android.support.v4.util.ArrayMap v0_1) {
            v1_0 = 0;
            if (v1_0 != 0) {
                v1_0.close();
            }
            throw v0_1;
        } catch (android.support.v4.util.ArrayMap v0_0) {
            v1_0 = 0;
        } catch (android.support.v4.util.ArrayMap v0_1) {
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzas() calling method android.database.sqlite.SQLiteDatabase.query()


    public com.google.android.gms.measurement.internal.zzak zzas(String p10, String p11)
    {
        android.database.Cursor v8 = 0;
        com.google.android.gms.common.internal.zzab.zzhr(p10);
        com.google.android.gms.common.internal.zzab.zzhr(p11);
        this.zzwu();
        this.zzzg();
        try {
            com.google.android.gms.measurement.internal.zzp$zza v0_8 = this.getWritableDatabase();
            String v2_5 = new String[2];
            v2_5[0] = "set_timestamp";
            v2_5[1] = "value";
            long v4_3 = new String[2];
            v4_3[0] = p10;
            v4_3[1] = p11;
            android.database.Cursor v7_1 = v0_8.query("user_attributes", v2_5, "app_id=? and name=?", v4_3, 0, 0, 0);
            try {
                com.google.android.gms.measurement.internal.zzak v1_2;
                if (v7_1.moveToFirst()) {
                    v1_2 = new com.google.android.gms.measurement.internal.zzak(p10, p11, v7_1.getLong(0), this.zzb(v7_1, 1));
                    if (v7_1.moveToNext()) {
                        this.zzbsd().zzbsv().log("Got multiple records for user property, expected one");
                    }
                    if (v7_1 == null) {
                        return v1_2;
                    } else {
                        v7_1.close();
                        return v1_2;
                    }
                } else {
                    if (v7_1 != null) {
                        v7_1.close();
                    }
                    v1_2 = 0;
                    return v1_2;
                }
            } catch (com.google.android.gms.measurement.internal.zzp$zza v0_1) {
                v8 = v7_1;
                if (v8 != null) {
                    v8.close();
                }
                throw v0_1;
            } catch (com.google.android.gms.measurement.internal.zzp$zza v0_0) {
                com.google.android.gms.measurement.internal.zzak v1_0 = v7_1;
                try {
                    this.zzbsd().zzbsv().zzd("Error querying user property", p10, p11, v0_0);
                } catch (com.google.android.gms.measurement.internal.zzp$zza v0_1) {
                    v8 = v1_0;
                }
                if (v1_0 != null) {
                    v1_0.close();
                }
                v1_2 = 0;
                return v1_2;
            }
        } catch (com.google.android.gms.measurement.internal.zzp$zza v0_1) {
        } catch (com.google.android.gms.measurement.internal.zzp$zza v0_0) {
            v1_0 = 0;
        }
    }

Method com.google.android.gms.measurement.internal.zze.zzaq() calling method android.database.sqlite.SQLiteDatabase.query()


    public com.google.android.gms.measurement.internal.zzi zzaq(String p13, String p14)
    {
        android.database.Cursor v10 = 0;
        com.google.android.gms.common.internal.zzab.zzhr(p13);
        com.google.android.gms.common.internal.zzab.zzhr(p14);
        this.zzwu();
        this.zzzg();
        try {
            com.google.android.gms.measurement.internal.zzp$zza v0_9 = this.getWritableDatabase();
            String v2_5 = new String[3];
            v2_5[0] = "lifetime_count";
            v2_5[1] = "current_bundle_count";
            v2_5[2] = "last_fire_timestamp";
            long v4_4 = new String[2];
            v4_4[0] = p13;
            v4_4[1] = p14;
            android.database.Cursor v11 = v0_9.query("events", v2_5, "app_id=? and name=?", v4_4, 0, 0, 0);
            try {
                com.google.android.gms.measurement.internal.zzi v1_2;
                if (v11.moveToFirst()) {
                    v1_2 = new com.google.android.gms.measurement.internal.zzi(p13, p14, v11.getLong(0), v11.getLong(1), v11.getLong(2));
                    if (v11.moveToNext()) {
                        this.zzbsd().zzbsv().log("Got multiple records for event aggregates, expected one");
                    }
                    if (v11 == null) {
                        return v1_2;
                    } else {
                        v11.close();
                        return v1_2;
                    }
                } else {
                    if (v11 != null) {
                        v11.close();
                    }
                    v1_2 = 0;
                    return v1_2;
                }
            } catch (com.google.android.gms.measurement.internal.zzp$zza v0_1) {
                v10 = v11;
                if (v10 != null) {
                    v10.close();
                }
                throw v0_1;
            } catch (com.google.android.gms.measurement.internal.zzp$zza v0_0) {
                com.google.android.gms.measurement.internal.zzi v1_0 = v11;
                try {
                    this.zzbsd().zzbsv().zzd("Error querying events", p13, p14, v0_0);
                } catch (com.google.android.gms.measurement.internal.zzp$zza v0_1) {
                    v10 = v1_0;
                }
                if (v1_0 != null) {
                    v1_0.close();
                }
                v1_2 = 0;
                return v1_2;
            }
        } catch (com.google.android.gms.measurement.internal.zzp$zza v0_1) {
        } catch (com.google.android.gms.measurement.internal.zzp$zza v0_0) {
            v1_0 = 0;
        }
    }

Method com.google.android.gms.measurement.internal.zze.zza() calling method android.database.sqlite.SQLiteDatabase.query()


    public void zza(String p15, long p16, com.google.android.gms.measurement.internal.zze$zzb p18)
    {
        android.database.Cursor v3_0 = 0;
        com.google.android.gms.common.internal.zzab.zzy(p18);
        this.zzwu();
        this.zzzg();
        try {
            String v12;
            boolean v2_19 = this.getWritableDatabase();
        } catch (boolean v2_1) {
            android.database.Cursor v11 = v3_0;
            if (v11 != null) {
                v11.close();
            }
            throw v2_1;
        } catch (boolean v2_0) {
            this.zzbsd().zzbsv().zzj("Data loss. Error selecting raw event", v2_0);
            if (v3_0 == null) {
                return;
            } else {
                v3_0.close();
                return;
            }
        } catch (boolean v2_1) {
            v11 = v3_0;
        }
        if (!android.text.TextUtils.isEmpty(p15)) {
            String v5_2 = new String[1];
            v5_2[0] = p15;
            v3_0 = v2_19.rawQuery("select metadata_fingerprint from raw_events where app_id = ? order by rowid limit 1;", v5_2);
            if (v3_0.moveToFirst()) {
                com.google.android.gms.measurement.internal.zzp$zza v4_10 = v3_0.getString(0);
                v3_0.close();
                v12 = v4_10;
            } else {
                if (v3_0 == null) {
                    return;
                } else {
                    v3_0.close();
                    return;
                }
            }
        } else {
            String v5_10 = new String[1];
            v5_10[0] = String.valueOf(p16);
            v3_0 = v2_19.rawQuery("select app_id, metadata_fingerprint from raw_events where app_id in (select app_id from apps where config_fetched_time >= ?) order by rowid limit 1;", v5_10);
            if (v3_0.moveToFirst()) {
                p15 = v3_0.getString(0);
                com.google.android.gms.measurement.internal.zzp$zza v4_15 = v3_0.getString(1);
                v3_0.close();
                v12 = v4_15;
            } else {
                if (v3_0 == null) {
                    return;
                } else {
                    v3_0.close();
                    return;
                }
            }
        }
        try {
            com.google.android.gms.measurement.internal.zzp$zza v4_17 = new String[1];
            v4_17[0] = "metadata";
            com.google.android.gms.internal.zzuh$zzb v6_12 = new String[2];
            v6_12[0] = p15;
            v6_12[1] = v12;
            v11 = v2_19.query("raw_events_metadata", v4_17, "app_id=? and metadata_fingerprint=?", v6_12, 0, 0, "rowid", "2");
        } catch (boolean v2_1) {
        } catch (boolean v2_0) {
            v3_0 = v11;
        }
        if (v11.moveToFirst()) {
            android.database.Cursor v3_7 = com.google.android.gms.internal.zzapn.zzbd(v11.getBlob(0));
            com.google.android.gms.measurement.internal.zzp$zza v4_20 = new com.google.android.gms.internal.zzuh$zze();
            try {
                v4_20.zzb(v3_7);
            } catch (boolean v2_20) {
                this.zzbsd().zzbsv().zze("Data loss. Failed to merge raw event metadata", p15, v2_20);
                if (v11 == null) {
                    return;
                } else {
                    v11.close();
                    return;
                }
            }
            if (v11.moveToNext()) {
                this.zzbsd().zzbsx().log("Get multiple raw event metadata records, expected one");
            }
            v11.close();
            p18.zzc(v4_20);
            com.google.android.gms.measurement.internal.zzp$zza v4_1 = new String[4];
            v4_1[0] = "rowid";
            v4_1[1] = "name";
            v4_1[2] = "timestamp";
            v4_1[3] = "data";
            com.google.android.gms.internal.zzuh$zzb v6_6 = new String[2];
            v6_6[0] = p15;
            v6_6[1] = v12;
            v3_0 = v2_19.query("raw_events", v4_1, "app_id=? and metadata_fingerprint=?", v6_6, 0, 0, "rowid", 0);
            if (!v3_0.moveToFirst()) {
                this.zzbsd().zzbsx().log("Raw event data disappeared while in transaction");
                if (v3_0 == null) {
                    return;
                } else {
                    v3_0.close();
                    return;
                }
            }
            do {
                com.google.android.gms.measurement.internal.zzp$zza v4_2 = v3_0.getLong(0);
                boolean v2_6 = com.google.android.gms.internal.zzapn.zzbd(v3_0.getBlob(3));
                com.google.android.gms.internal.zzuh$zzb v6_8 = new com.google.android.gms.internal.zzuh$zzb();
                v6_8.zzb(v2_6);
                v6_8.name = v3_0.getString(1);
                v6_8.ano = Long.valueOf(v3_0.getLong(2));
                if (p18.zza(v4_2, v6_8)) {
                } else {
                    if (v3_0 == null) {
                        return;
                    } else {
                        v3_0.close();
                        return;
                    }
                }
            } while(v3_0.moveToNext());
            if (v3_0 == null) {
                return;
            } else {
                v3_0.close();
                return;
            }
        } else {
            this.zzbsd().zzbsv().log("Raw event metadata record is missing");
            if (v11 == null) {
                return;
            } else {
                v11.close();
                return;
            }
        }
    }

Method com.google.android.gms.measurement.internal.zze.zza() calling method android.database.sqlite.SQLiteDatabase.query()


    public com.google.android.gms.measurement.internal.zze$zza zza(long p12, String p14, boolean p15, boolean p16, boolean p17)
    {
        com.google.android.gms.common.internal.zzab.zzhr(p14);
        this.zzwu();
        this.zzzg();
        String[] v10 = new String[1];
        v10[0] = p14;
        com.google.android.gms.measurement.internal.zze$zza v8_1 = new com.google.android.gms.measurement.internal.zze$zza();
        try {
            com.google.android.gms.measurement.internal.zze$zza v0_0 = this.getWritableDatabase();
            android.content.ContentValues v2_4 = new String[5];
            v2_4[0] = "day";
            v2_4[1] = "daily_events_count";
            v2_4[2] = "daily_public_events_count";
            v2_4[3] = "daily_conversions_count";
            v2_4[4] = "daily_error_events_count";
            String v4_16 = new String[1];
            v4_16[0] = p14;
            int v1_1 = v0_0.query("apps", v2_4, "app_id=?", v4_16, 0, 0, 0);
            try {
                com.google.android.gms.measurement.internal.zze$zza v0_1;
                if (v1_1.moveToFirst()) {
                    if (v1_1.getLong(0) == p12) {
                        v8_1.aiq = v1_1.getLong(1);
                        v8_1.aip = v1_1.getLong(2);
                        v8_1.air = v1_1.getLong(3);
                        v8_1.ais = v1_1.getLong(4);
                    }
                    v8_1.aiq = (v8_1.aiq + 1);
                    if (p15) {
                        v8_1.aip = (v8_1.aip + 1);
                    }
                    if (p16) {
                        v8_1.air = (v8_1.air + 1);
                    }
                    if (p17) {
                        v8_1.ais = (v8_1.ais + 1);
                    }
                    android.content.ContentValues v2_1 = new android.content.ContentValues();
                    v2_1.put("day", Long.valueOf(p12));
                    v2_1.put("daily_public_events_count", Long.valueOf(v8_1.aip));
                    v2_1.put("daily_events_count", Long.valueOf(v8_1.aiq));
                    v2_1.put("daily_conversions_count", Long.valueOf(v8_1.air));
                    v2_1.put("daily_error_events_count", Long.valueOf(v8_1.ais));
                    v0_0.update("apps", v2_1, "app_id=?", v10);
                    if (v1_1 != 0) {
                        v1_1.close();
                    }
                    v0_1 = v8_1;
                    return v0_1;
                } else {
                    this.zzbsd().zzbsx().zzj("Not updating daily counts, app is not known", p14);
                    if (v1_1 != 0) {
                        v1_1.close();
                    }
                    v0_1 = v8_1;
                    return v0_1;
                }
            } catch (com.google.android.gms.measurement.internal.zze$zza v0_5) {
                this.zzbsd().zzbsv().zzj("Error updating daily counts", v0_5);
                if (v1_1 != 0) {
                    v1_1.close();
                }
                v0_1 = v8_1;
                return v0_1;
            }
        } catch (com.google.android.gms.measurement.internal.zze$zza v0_6) {
            v1_1 = 0;
            if (v1_1 != 0) {
                v1_1.close();
            }
            throw v0_6;
        } catch (com.google.android.gms.measurement.internal.zze$zza v0_5) {
            v1_1 = 0;
        } catch (com.google.android.gms.measurement.internal.zze$zza v0_6) {
        }
    }

Method com.facebook.react.modules.storage.AsyncStorageModule$6.doInBackgroundGuarded() calling method android.database.sqlite.SQLiteDatabase.query()


    protected varargs void doInBackgroundGuarded(Void[] p15)
    {
        if (com.facebook.react.modules.storage.AsyncStorageModule.access$000(this.this$0)) {
            com.facebook.react.bridge.WritableArray v9 = com.facebook.react.bridge.Arguments.createArray();
            String[] v2 = new String[1];
            v2[0] = "key";
            android.database.Cursor v8 = com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().query("catalystLocalStorage", v2, 0, 0, 0, 0, 0);
            try {
                if (v8.moveToFirst()) {
                    do {
                        v9.pushString(v8.getString(0));
                    } while(v8.moveToNext());
                }
            } catch (com.facebook.react.bridge.Callback v0_8) {
                v8.close();
                throw v0_8;
            } catch (Exception v10) {
                com.facebook.common.logging.FLog.w("React", v10.getMessage(), v10);
                com.facebook.react.bridge.Callback v0_6 = this.val$callback;
                Object[] v1_3 = new Object[2];
                v1_3[0] = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v10.getMessage());
                v1_3[1] = 0;
                v0_6.invoke(v1_3);
                v8.close();
            }
            v8.close();
            com.facebook.react.bridge.Callback v0_12 = this.val$callback;
            Object[] v1_4 = new Object[2];
            v1_4[0] = 0;
            v1_4[1] = v9;
            v0_12.invoke(v1_4);
        } else {
            com.facebook.react.bridge.Callback v0_14 = this.val$callback;
            Object[] v1_5 = new Object[2];
            v1_5[0] = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getDBError(0);
            v1_5[1] = 0;
            v0_14.invoke(v1_5);
        }
        return;
    }

Method com.facebook.react.modules.storage.AsyncStorageModule$1.doInBackgroundGuarded() calling method android.database.sqlite.SQLiteDatabase.query()


    protected varargs void doInBackgroundGuarded(Void[] p20)
    {
        if (com.facebook.react.modules.storage.AsyncStorageModule.access$000(this.this$0)) {
            String[] v3 = new String[2];
            v3[0] = "key";
            v3[1] = "value";
            java.util.HashSet v17 = com.facebook.react.common.SetBuilder.newHashSet();
            com.facebook.react.bridge.WritableArray v10 = com.facebook.react.bridge.Arguments.createArray();
            int v16 = 0;
            while (v16 < this.val$keys.size()) {
                int v14 = Math.min((this.val$keys.size() - v16), 999);
                android.database.Cursor v9 = com.facebook.react.modules.storage.AsyncStorageModule.access$100(this.this$0).get().query("catalystLocalStorage", v3, com.facebook.react.modules.storage.AsyncLocalStorageUtil.buildKeySelection(v14), com.facebook.react.modules.storage.AsyncLocalStorageUtil.buildKeySelectionArgs(this.val$keys, v16, v14), 0, 0, 0);
                v17.clear();
                try {
                    if (v9.getCount() != this.val$keys.size()) {
                        int v15 = v16;
                        while (v15 < (v16 + v14)) {
                            v17.add(this.val$keys.getString(v15));
                            v15++;
                        }
                    }
                    if (v9.moveToFirst()) {
                        do {
                            com.facebook.react.bridge.WritableArray v18_1 = com.facebook.react.bridge.Arguments.createArray();
                            v18_1.pushString(v9.getString(0));
                            v18_1.pushString(v9.getString(1));
                            v10.pushArray(v18_1);
                            v17.remove(v9.getString(0));
                        } while(v9.moveToNext());
                    }
                    v9.close();
                    java.util.Iterator v12 = v17.iterator();
                    while (v12.hasNext()) {
                        String v13_1 = ((String) v12.next());
                        com.facebook.react.bridge.WritableArray v18_0 = com.facebook.react.bridge.Arguments.createArray();
                        v18_0.pushString(v13_1);
                        v18_0.pushNull();
                        v10.pushArray(v18_0);
                    }
                    v17.clear();
                    v16 += 999;
                } catch (boolean v1_7) {
                    v9.close();
                    throw v1_7;
                } catch (Exception v11) {
                    com.facebook.common.logging.FLog.w("React", v11.getMessage(), v11);
                    boolean v1_6 = this.val$callback;
                    Object[] v2_3 = new Object[2];
                    v2_3[0] = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getError(0, v11.getMessage());
                    v2_3[1] = 0;
                    v1_6.invoke(v2_3);
                    v9.close();
                }
            }
            boolean v1_11 = this.val$callback;
            Object[] v2_7 = new Object[2];
            v2_7[0] = 0;
            v2_7[1] = v10;
            v1_11.invoke(v2_7);
        } else {
            boolean v1_8 = this.val$callback;
            Object[] v2_5 = new Object[2];
            v2_5[0] = com.facebook.react.modules.storage.AsyncStorageErrorUtil.getDBError(0);
            v2_5[1] = 0;
            v1_8.invoke(v2_5);
        }
        return;
    }

Method com.google.android.gms.measurement.internal.zze$zzc.zza() calling method android.database.sqlite.SQLiteDatabase.query()


    private boolean zza(android.database.sqlite.SQLiteDatabase p11, String p12)
    {
        int v9 = 0;
        try {
            com.google.android.gms.measurement.internal.zzp$zza v2_3 = new String[1];
            v2_3[0] = "name";
            String[] v4 = new String[1];
            v4[0] = p12;
            int v1_0 = p11.query("SQLITE_MASTER", v2_3, "name=?", v4, 0, 0, 0);
            try {
                int v0_4 = v1_0.moveToFirst();
            } catch (int v0_2) {
                this.ait.zzbsd().zzbsx().zze("Error querying for table", p12, v0_2);
                if (v1_0 != 0) {
                    v1_0.close();
                }
                v0_4 = 0;
                return v0_4;
            }
            if (v1_0 == 0) {
                return v0_4;
            } else {
                v1_0.close();
                return v0_4;
            }
        } catch (int v0_3) {
            if (v9 != 0) {
                v9.close();
            }
            throw v0_3;
        } catch (int v0_2) {
            v1_0 = 0;
        } catch (int v0_3) {
            v9 = v1_0;
        }
    }

Method com.facebook.react.modules.storage.AsyncLocalStorageUtil.getItemImpl() calling method android.database.sqlite.SQLiteDatabase.query()


    public static String getItemImpl(android.database.sqlite.SQLiteDatabase p9, String p10)
    {
        String v5 = 0;
        String[] v2 = new String[1];
        v2[0] = "value";
        String[] v4 = new String[1];
        v4[0] = p10;
        android.database.Cursor v8 = p9.query("catalystLocalStorage", v2, "key=?", v4, 0, 0, 0);
        try {
            if (v8.moveToFirst()) {
                v5 = v8.getString(0);
                v8.close();
            } else {
                v8.close();
            }
        } catch (int v0_3) {
            v8.close();
            throw v0_3;
        }
        return v5;
    }