@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") List<TaskEntry> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); }
@Dao public interface ReadStoriesDao { @Insert(onConflict = OnConflictStrategy.REPLACE) void insert(ReadStory readStory); @Query("SELECT * FROM read WHERE itemid = :itemId LIMIT 1") ReadStory selectByItemId(String itemId); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") List<TaskEntry> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") List<TaskEntry> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); }
@Dao public interface ReadableDao { @Insert(onConflict = OnConflictStrategy.REPLACE) void insert(Readable readable); @Query("SELECT * FROM readable WHERE itemid = :itemId LIMIT 1") Readable selectByItemId(String itemId); }
/** * Created by anandgaurav on 12/02/18. */ @Dao public interface UserDao { @Query("SELECT * FROM users") List<User> loadAll(); @Query("SELECT * FROM users WHERE id IN (:userIds)") List<User> loadAllByIds(List<Integer> userIds); @Insert(onConflict = OnConflictStrategy.REPLACE) void insert(User user); @Insert(onConflict = OnConflictStrategy.REPLACE) void insertAll(List<User> users); @Delete void delete(User user); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") List<TaskEntry> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") List<TaskEntry> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") List<TaskEntry> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") List<TaskEntry> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") List<TaskEntry> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") LiveData<List<TaskEntry>> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); @Query("SELECT * FROM task WHERE id = :id") LiveData<TaskEntry> loadTaskById(int id); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") LiveData<List<TaskEntry>> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); @Query("SELECT * FROM task WHERE id = :id") LiveData<TaskEntry> loadTaskById(int id); }
@Dao public abstract class PlaylistDAO implements BasicDAO<PlaylistEntity> { @Override @Query("SELECT * FROM " + PLAYLIST_TABLE) public abstract Flowable<List<PlaylistEntity>> getAll(); @Override @Query("DELETE FROM " + PLAYLIST_TABLE) public abstract int deleteAll(); @Override public Flowable<List<PlaylistEntity>> listByService(int serviceId) { throw new UnsupportedOperationException(); } @Query("SELECT * FROM " + PLAYLIST_TABLE + " WHERE " + PLAYLIST_ID + " = :playlistId") public abstract Flowable<List<PlaylistEntity>> getPlaylist(final long playlistId); @Query("DELETE FROM " + PLAYLIST_TABLE + " WHERE " + PLAYLIST_ID + " = :playlistId") public abstract int deletePlaylist(final long playlistId); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") List<TaskEntry> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); // TODO (1) Create a Query method named loadTaskById that receives an int id and returns a TaskEntry Object // The query for this method should get all the data for that id in the task table }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") LiveData<List<TaskEntry>> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); @Query("SELECT * FROM task WHERE id = :id") LiveData<TaskEntry> loadTaskById(int id); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") LiveData<List<TaskEntry>> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); @Query("SELECT * FROM task WHERE id = :id") LiveData<TaskEntry> loadTaskById(int id); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") LiveData<List<TaskEntry>> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); // COMPLETED (1) Wrap the return type with LiveData @Query("SELECT * FROM task WHERE id = :id") LiveData<TaskEntry> loadTaskById(int id); }
@Dao public interface TaskDao { // COMPLETED (2) Wrap the return type with LiveData @Query("SELECT * FROM task ORDER BY priority") LiveData<List<TaskEntry>> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); @Query("SELECT * FROM task WHERE id = :id") TaskEntry loadTaskById(int id); }
@Dao public interface TaskDao { @Query("SELECT * FROM task ORDER BY priority") LiveData<List<TaskEntry>> loadAllTasks(); @Insert void insertTask(TaskEntry taskEntry); @Update(onConflict = OnConflictStrategy.REPLACE) void updateTask(TaskEntry taskEntry); @Delete void deleteTask(TaskEntry taskEntry); // TODO (1) Wrap the return type with LiveData @Query("SELECT * FROM task WHERE id = :id") TaskEntry loadTaskById(int id); }