| | |
|---|
| | | |
|---|
| | | @Dao |
|---|
| | | interface ReminderDao { |
|---|
| | | |
|---|
| | | @Query("SELECT * FROM reminders ORDER BY type") |
|---|
| | | @Query("SELECT * FROM reminders ORDER BY createdAt DESC") |
|---|
| | | fun getAllReminders(): Flow<List<Reminder>> |
|---|
| | | |
|---|
| | | @Insert |
|---|
| | | fun insert(reminder: Reminder) |
|---|
| | | @Insert(onConflict = OnConflictStrategy.REPLACE) |
|---|
| | | suspend fun insertReminder(reminder: Reminder) |
|---|
| | | |
|---|
| | | @Delete |
|---|
| | | fun delete(reminder: Reminder) |
|---|
| | | suspend fun deleteReminder(reminder: Reminder) |
|---|
| | | |
|---|
| | | @Query("DELETE FROM reminders WHERE categoryId = :categoryId") |
|---|
| | | suspend fun deleteReminderByCategoryId(categoryId: Int) |
|---|
| | | |
|---|
| | | @Query("SELECT * FROM reminders WHERE categoryId = :categoryId") |
|---|
| | | suspend fun getReminderByCategoryId(categoryId: Int): Reminder? |
|---|
| | | |
|---|
| | | @Query("DELETE FROM reminders") |
|---|
| | | suspend fun deleteAllReminders() |
|---|
| | | } |
|---|
