groovy
dependencies {
implementation 'ca.dallas.db:dbtools:3.0.0'
}
public class MyDatabase extends CAStoreOpenHelperBase {
public MyDatabase(Context context) {
super(context, "my_database.db", null, 1);
}
@Override
public void onCreateDatabase(ConnectionWrapper connection) {
connection.executeSql("CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, email TEXT)");
}
@Override
public void onUpgradeDatabase(ConnectionWrapper connection, int oldVersion, int newVersion) {
}
}
MyDatabase myDatabase = new MyDatabase(context);
database.insert("users")
.column("name", "John")
.column("email", "john@example.com")
.execute();
DataSet dataSet = database
.select()
.from("users")
.where("name", "John")
.execute();
database.update("users")
.column("email", "new_email@example.com")
.where("id", 1)
.execute();
database.delete()
.from("users")
.where("id", 1)
.execute();
database.close();
