@Table(name = "users")
public class User {
@Column(name = "id", primaryKey = true)
private long id;
@Column(name = "name")
private String name;
}
DatabaseManager databaseManager = new DatabaseManager(context, "my_database.db", 1) {
@Override
public List<MigrationScript> getMigrations() {
List<MigrationScript> migrations = new ArrayList<>();
migrations.add(new MigrationScript(1, "CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)"));
return migrations;
}
};
EntityManager<User> entityManager = databaseManager.getEntityManager(User.class);
User user = new User();
user.setId(1);
user.setName("John Doe");
entityManager.insert(user);
List<User> users = entityManager.select();
user.setName("Jane Doe");
entityManager.update(user);
entityManager.delete(user);