DatabaseConfig config = new DatabaseConfig.Builder(context)
.setName("mydatabase.db")
.setVersion(1)
.setTableDefinitions(MyDatabaseTables.class)
.setMigrationScripts("scripts/upgrade.sql")
.build();
DBTools.initialize(config);
@DBTable(name = "users")
public class UserTable {
@DBColumn(name = "id", type = DBDataType.INT, primaryKey = true)
public static final String COLUMN_ID = "id";
@DBColumn(name = "name", type = DBDataType.TEXT)
public static final String COLUMN_NAME = "name";
public static void createTable(DatabaseRunner runner) {
runner.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)");
}
}
List<User> users = DBTools.select(User.class).getAllResults();
User user = new User("John");
DBTools.insert(user);
User user = DBTools.select(User.class).where(UserTable.COLUMN_ID, 1).getFirstResult();
user.setName("John Smith");
DBTools.update(user);
DBTools.delete(User.class, 1);
