org.sqlite.database.sqlite.SQLiteDatabase Java Examples

@Nullable
@Override
public final Cursor query(@NonNull Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
    SQLiteDatabase database = mSQLiteHelper.getWritableDatabase();
    String table = getType(uri);
    if (TextUtils.isEmpty(table)) {
        throw new IllegalArgumentException("No such table to query");
    } else {
        return database.query(table,
                projection,
                selection,
                selectionArgs,
                null,
                null,
                sortOrder);
    }
}
 

@Override
public final int bulkInsert(@NonNull Uri uri, @NonNull ContentValues[] values) {
    SQLiteDatabase database = mSQLiteHelper.getWritableDatabase();
    String table = getType(uri);
    if (TextUtils.isEmpty(table)) {
        throw new IllegalArgumentException("No such table to insert");
    } else {
        int numInserted = 0;
        database.beginTransaction();
        try {
            for (ContentValues contentValues : values) {
                long id = database.insertWithOnConflict(table, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE);
                if (id > 0) {
                    numInserted++;
                }
            }
            database.setTransactionSuccessful();
        } finally {
            database.endTransaction();
        }
        return numInserted;
    }
}
 

@Override
public void onCreate(@NonNull SQLiteDatabase database) {
    TableBuilder.create(this)
            .textColumn(REQUEST)
            .textColumn(STATUS)
            .textColumn(ERROR)
            .primaryKey(REQUEST)
            .execute(database);
}
 

/**
 * Utility method to run the query on the db and return the value in the
 * first column of the first row.
 */
public static long longForQuery(
    SQLiteDatabase db, String query, String[] selectionArgs
) {
    SQLiteStatement prog = db.compileStatement(query);
    try {
        return longForQuery(prog, selectionArgs);
    } finally {
        prog.close();
    }
}
 

@Override
protected void onConfigure(ISQLiteDatabase db) {
    /** @see AttachDetachTest#testAttacherInTransactionOnAnotherThread() */
    Object wrappedObject = db.getWrappedObject();
    if (wrappedObject instanceof SQLiteDatabase) {
        ((SQLiteDatabase) wrappedObject).enableWriteAheadLogging();
    } else if (wrappedObject instanceof android.database.sqlite.SQLiteDatabase) {
        ((android.database.sqlite.SQLiteDatabase) wrappedObject).enableWriteAheadLogging();
    }
}
 

@Override
public void onCreate(@NonNull SQLiteDatabase database) {
    TableBuilder.create(this)
            .intColumn(ID)
            .realColumn(RATING)
            .textColumn(TEXT)
            .primaryKey(ID)
            .execute(database);
}
 

@Override
public void onCreate(@NonNull SQLiteDatabase database) {
    TableBuilder.create(this)
            .intColumn(ID)
            .realColumn(RATING)
            .textColumn(TEXT)
            .primaryKey(ID)
            .execute(database);
}
 

@Override
public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
    for (Table table : mSchema) {
        if (oldVersion < newVersion && newVersion <= table.getLastUpgradeVersion()) {
            table.onUpgrade(database);
        }
    }
}
 

@Override
public final int update(@NonNull Uri uri, ContentValues values,
                  String selection, String[] selectionArgs) {
    SQLiteDatabase database = mSQLiteHelper.getWritableDatabase();
    String table = getType(uri);
    if (TextUtils.isEmpty(table)) {
        throw new IllegalArgumentException("No such table to update");
    } else {
        return database.update(table, values, selection, selectionArgs);
    }
}
 

@Override
public final int delete(@NonNull Uri uri, String selection, String[] selectionArgs) {
    SQLiteDatabase database = mSQLiteHelper.getWritableDatabase();
    String table = getType(uri);
    if (TextUtils.isEmpty(table)) {
        throw new IllegalArgumentException("No such table to delete");
    } else {
        return database.delete(table, selection, selectionArgs);
    }
}
 

@NonNull
@Override
public final Uri insert(@NonNull Uri uri, ContentValues values) {
    SQLiteDatabase database = mSQLiteHelper.getWritableDatabase();
    String table = getType(uri);
    if (TextUtils.isEmpty(table)) {
        throw new IllegalArgumentException("No such table to insert");
    } else {
        long id = database.insertWithOnConflict(table, null, values, SQLiteDatabase.CONFLICT_REPLACE);
        return ContentUris.withAppendedId(uri, id);
    }
}
 

@Override
public void onCreate(@NonNull SQLiteDatabase database) {
    TableBuilder.create(this)
            .textColumn(CITY_NAME)
            .textColumn(WEATHER)
            .textColumn(MAIN)
            .textColumn(WIND)
            .execute(database);
}
 

@Override
public void onCreate(@NonNull SQLiteDatabase database) {
    TableBuilder.create(this)
            .textColumn(CITY_ID)
            .textColumn(CITY_NAME)
            .primaryKey(CITY_ID)
            .execute(database);
}
 

@Override
public void onCreate(@NonNull SQLiteDatabase database) {
    TableBuilder.create(this)
            .textColumn(CITY_NAME)
            .textColumn(WEATHER)
            .textColumn(MAIN)
            .textColumn(WIND)
            .execute(database);
}
 

@Override
public void onConfigure(SQLiteDatabase db) {
    delegate.onConfigure(new SQLiteBindingsAdapter(db));
}
 

@Override
public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    delegate.onDowngrade(new SQLiteBindingsAdapter(db), oldVersion, newVersion);
}
 

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    delegate.onUpgrade(new SQLiteBindingsAdapter(db), oldVersion, newVersion);
}
 

@Override
public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    super.onDowngrade(db, oldVersion, newVersion);
}
 

@Override
public void onCreate(SQLiteDatabase db) {
    delegate.onCreate(new SQLiteBindingsAdapter(db));
}
 

@Override
public ISQLiteDatabase openForWriting() {
    SQLiteDatabase database = super.getWritableDatabase();
    return new SQLiteBindingsAdapter(database);
}
 

@Override
public SQLiteDatabase getWrappedObject() {
    return db;
}
 

public SQLiteBindingsAdapter(SQLiteDatabase db) {
    if (db == null) {
        throw new NullPointerException("Can't create SQLiteDatabaseAdapter with a null SQLiteDatabase");
    }
    this.db = db;
}
 

@Override
public Cursor newCursor(SQLiteDatabase db, SQLiteCursorDriver masterQuery, String editTable, SQLiteQuery query) {
    bindArgumentsToProgram(query, sqlArgs);
    return new SQLiteCursor(masterQuery, editTable, query);
}
 

@Override
public void onOpen(SQLiteDatabase db) {
    delegate.onOpen(new SQLiteBindingsAdapter(db));
}
 

@Override
public void onCreate(@NonNull SQLiteDatabase database) {
    throw new RuntimeException("Stub!");
}
 

@Override
public void onUpgrade(@NonNull SQLiteDatabase database) {
    database.execSQL("DROP TABLE IF EXISTS " + getTableName());
    onCreate(database);
}
 

@Override
public void onCreate(SQLiteDatabase database) {
    for (Table table : mSchema) {
        table.onCreate(database);
    }
}
 

public void execute(@NonNull SQLiteDatabase database) {
    database.execSQL(buildSQL());
}
 

/**
 * defines the method to be invoked when database corruption is detected.
 * @param dbObj the {@link SQLiteDatabase} object representing the database on which corruption
 * is detected.
 */
void onCorruption(SQLiteDatabase dbObj);
 

/**
 * Get the SQLite database connection
 *
 * @return connection
 */
public SQLiteDatabase getDb() {
    return db;
}