interface PlayerModel {
class Update_number {
public static final table = "hockey_player";
public final SQLiteStatement program;
public Update_number(SQLiteDatabase db);
public void bind(int player_number, String name);
}
}
public Update_number(SQLiteDatabase db);
full example with SQLDelight + SQLBrite:
SQLiteOpenHelper databaseHelper = new MyOpenHelper(context);
// Create instance of SQLBrite.
Sqlbrite sqlBrite = new SqlBrite.Builder().build();
// Wrap the open helper.
BriteDatabase briteDatabase = sqlBrite.wrapDatabaseHelper(databaseHelper, Schedulers.io());
// Compile a statement generated by SQLDelight
PlayerModel.Update_number updateNumber = new PlayerModel.Update_number(databaseHelper.getWritableDatabase());
// Bind values to the compiled statement.
updateNumber.bind(10, "Corey Perry");
// Execute the compiled statement using SQLDelight
briteDatabase.executeUpdateDelete(updateNumber.table, updateNumber.program);
The same OpenHelper that is wrapped by SQLBrite should be used to compile a statement for SQLDelight.
Thanks for your help.
hi, AlecStrong
What's the latest Ver of SQBrite? Ver 0.6.3 seems not support method SqlBrite.Builder().build().
And what if I wana use Observable of SqlBrite with SQLDelight, how can I make it?
Most helpful comment
full example with SQLDelight + SQLBrite:
The same OpenHelper that is wrapped by SQLBrite should be used to compile a statement for SQLDelight.