dependencies {
implementation 'org.dbtools:dbtools-android:1.0.0'
}
import org.dbtools.android.domain.config.DatabaseConfig;
import org.dbtools.android.domain.database.DatabaseWrapper;
import org.dbtools.android.domain.database.DefaultDatabaseWrapper;
import org.dbtools.android.domain.database.JdbcSqliteDatabaseWrapper;
public class MyDatabase extends DefaultDatabaseWrapper {
public static final int VERSION = 1;
public MyDatabase(Context context) {
super(new DatabaseConfig.Builder()
.setDatabaseName("mydatabase.db")
.setVersion(VERSION)
.build());
setUpdateScript("db/updates", VERSION);
}
@Override
public void onCreate(DatabaseWrapper db) {
db.executeSQL("CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)");
}
@Override
public void onUpgrade(DatabaseWrapper db, int oldVersion, int newVersion) {
}
}
public class MainActivity extends AppCompatActivity {
private MyDatabase myDatabase;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
myDatabase = new MyDatabase(this);
myDatabase.open();
myDatabase.insert(user);
QueryBuilder<User> query = SQLiteQueryBuilder.select(User.class);
query.where(UserTable.Cols.ID.eq(1));
List<User> users = myDatabase.findAll(query);
for (User u : users) {
Log.d("TAG", u.getName());
}
myDatabase.close();
}
}
