Sqldelight: Aren't compiled statements support BriteDatabase?

Created on 27 Oct 2016  路  3Comments  路  Source: cashapp/sqldelight

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);

Most helpful comment

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.

All 3 comments

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?

Was this page helpful?
0 / 5 - 0 ratings

Related issues

gabrielittner picture gabrielittner  路  15Comments

LiewJunTung picture LiewJunTung  路  12Comments

GianfrancoMS picture GianfrancoMS  路  13Comments

ReginFell picture ReginFell  路  14Comments

JakeWharton picture JakeWharton  路  25Comments