dependencies {
implementation 'org.dbtools:dbtools-android:10.0.0'
implementation 'org.dbtools:dbtools-database:10.0.0'
}
@Database(version = MyDatabase.VERSION)
public class MyDatabase {
public static final int VERSION = 1;
@Table(value = "users", className = "User", create = true)
public static final String USERS = "users";
}
@DatabaseName(MyDatabase.NAME)
public interface UserDao extends BaseDao<User> {
@Query("SELECT * FROM users")
List<User> getAllUsers();
@Query("SELECT * FROM users WHERE name = :name")
User getUserByName(String name);
}
DaoManager daoManager = new DaoManager(context);
UserDao userDao = daoManager.getDao(UserDao.class);
User user = new User("John", 30);
userDao.insert(user);
List<User> users = userDao.getAllUsers();
User user = userDao.getUserByName("John");
user.setAge(35);
userDao.update(user);
userDao.delete(user);
