EventsDao.kt

package org.fossify.calendar.interfaces

import androidx.room.Dao
import androidx.room.Insert
import androidx.room.OnConflictStrategy
import androidx.room.Query
import org.fossify.calendar.helpers.LOCAL_CALENDAR_ID
import org.fossify.calendar.helpers.SOURCE_CONTACT_ANNIVERSARY
import org.fossify.calendar.helpers.SOURCE_CONTACT_BIRTHDAY
import org.fossify.calendar.helpers.TYPE_EVENT
import org.fossify.calendar.helpers.TYPE_TASK
import org.fossify.calendar.models.Event

@Dao
interface EventsDao {
    @Query("SELECT * FROM events")
    fun getAllEvents(): List<Event>

    @Query("SELECT * FROM events WHERE type = $TYPE_TASK")
    fun getAllTasks(): List<Event>

    @Query("SELECT DISTINCT location FROM events")
    fun getAllLocations(): List<String>

    @Query("SELECT * FROM events WHERE event_type IN (:calendarIds) AND type = $TYPE_EVENT")
    fun getAllEventsWithCalendarIds(calendarIds: List<Long>): List<Event>

    @Query("SELECT * FROM events WHERE event_type IN (:calendarIds) AND type = $TYPE_TASK")
    fun getAllTasksWithCalendarIds(calendarIds: List<Long>): List<Event>

    @Query("SELECT * FROM events WHERE end_ts > :currTS AND event_type IN (:calendarIds) AND type = $TYPE_EVENT")
    fun getAllFutureEventsWithCalendarIds(currTS: Long, calendarIds: List<Long>): List<Event>

    @Query("SELECT * FROM events WHERE end_ts > :currTS AND event_type IN (:calendarIds) AND type = $TYPE_TASK")
    fun getAllFutureTasksWithCalendarIds(currTS: Long, calendarIds: List<Long>): List<Event>

    @Query("SELECT * FROM events WHERE id = :id AND type = $TYPE_EVENT")
    fun getEventWithId(id: Long): Event?

    @Query("SELECT * FROM events WHERE id = :id AND type = $TYPE_TASK")
    fun getTaskWithId(id: Long): Event?

    @Query("SELECT * FROM events WHERE id = :id")
    fun getEventOrTaskWithId(id: Long): Event?

    @Query("SELECT * FROM events WHERE import_id = :importId AND type = $TYPE_EVENT")
    fun getEventWithImportId(importId: String): Event?

    @Query("SELECT * FROM events WHERE start_ts <= :toTS AND end_ts >= :fromTS AND repeat_interval = 0")
    fun getOneTimeEventsOrTasksFromTo(toTS: Long, fromTS: Long): List<Event>

    @Query("SELECT * FROM events WHERE start_ts <= :toTS AND start_ts >= :fromTS AND event_type IN (:calendarIds) AND type = $TYPE_TASK")
    fun getTasksFromTo(fromTS: Long, toTS: Long, calendarIds: List<Long>): List<Event>

    @Query("SELECT * FROM events WHERE id = :id AND start_ts <= :toTS AND end_ts >= :fromTS AND repeat_interval = 0")
    fun getOneTimeEventFromToWithId(id: Long, toTS: Long, fromTS: Long): List<Event>

    @Query("SELECT * FROM events WHERE start_ts <= :toTS AND end_ts >= :fromTS AND start_ts != 0 AND repeat_interval = 0 AND event_type IN (:calendarIds)")
    fun getOneTimeEventsFromToWithCalendarIds(
        toTS: Long,
        fromTS: Long,
        calendarIds: List<Long>
    ): List<Event>

    @Query("SELECT * FROM events WHERE start_ts <= :toTS AND end_ts >= :fromTS AND start_ts != 0 AND repeat_interval = 0 AND event_type IN (:calendarIds) AND (title LIKE :searchQuery OR location LIKE :searchQuery OR description LIKE :searchQuery)")
    fun getOneTimeEventsFromToWithTypesForSearch(
        toTS: Long,
        fromTS: Long,
        calendarIds: List<Long>,
        searchQuery: String
    ): List<Event>

    @Query("SELECT * FROM events WHERE start_ts <= :toTS AND repeat_interval != 0")
    fun getRepeatableEventsOrTasksWithCalendarIds(toTS: Long): List<Event>

    @Query("SELECT * FROM events WHERE id = :id AND start_ts <= :toTS AND repeat_interval != 0")
    fun getRepeatableEventsOrTasksWithId(id: Long, toTS: Long): List<Event>

    @Query("SELECT * FROM events WHERE start_ts <= :toTS AND start_ts != 0 AND repeat_interval != 0 AND event_type IN (:calendarIds)")
    fun getRepeatableEventsOrTasksWithCalendarIds(toTS: Long, calendarIds: List<Long>): List<Event>

    @Query("SELECT * FROM events WHERE start_ts <= :toTS AND start_ts != 0 AND repeat_interval != 0 AND event_type IN (:calendarIds) AND (title LIKE :searchQuery OR location LIKE :searchQuery OR description LIKE :searchQuery)")
    fun getRepeatableEventsOrTasksWithTypesForSearch(
        toTS: Long,
        calendarIds: List<Long>,
        searchQuery: String
    ): List<Event>

    @Query("SELECT * FROM events WHERE id IN (:ids) AND import_id != \"\" AND type = $TYPE_EVENT")
    fun getEventsByIdsWithImportIds(ids: List<Long>): List<Event>

    @Query("SELECT * FROM events WHERE source = \'$SOURCE_CONTACT_BIRTHDAY\' AND type = $TYPE_EVENT")
    fun getBirthdays(): List<Event>

    @Query("SELECT * FROM events WHERE source = \'$SOURCE_CONTACT_ANNIVERSARY\' AND type = $TYPE_EVENT")
    fun getAnniversaries(): List<Event>

    @Query("SELECT * FROM events WHERE import_id != \"\"")
    fun getEventsOrTasksWithImportIds(): List<Event>

    @Query("SELECT * FROM events WHERE source = :source AND type = $TYPE_EVENT")
    fun getEventsFromCalDAVCalendar(source: String): List<Event>

    @Query("SELECT * FROM events WHERE id IN (:ids)")
    fun getEventsOrTasksWithIds(ids: List<Long>): List<Event>

    //val selection = "$COL_REMINDER_MINUTES != -1 AND ($COL_START_TS > ? OR $COL_REPEAT_INTERVAL != 0) AND $COL_START_TS != 0"
    @Query("SELECT * FROM events WHERE reminder_1_minutes != -1 AND (start_ts > :currentTS OR repeat_interval != 0) AND start_ts != 0")
    fun getEventsOrTasksAtReboot(currentTS: Long): List<Event>

    @Query("SELECT id FROM events")
    fun getEventIds(): List<Long>

    @Query("SELECT id FROM events WHERE import_id = :importId AND type = $TYPE_EVENT")
    fun getEventIdWithImportId(importId: String): Long?

    @Query("SELECT id FROM events WHERE import_id LIKE :importId AND type = $TYPE_EVENT")
    fun getEventIdWithLastImportId(importId: String): Long?

    @Query("SELECT id FROM events WHERE event_type = :calendarId")
    fun getEventAndTasksIdsByCalendar(calendarId: Long): List<Long>

    @Query("SELECT id FROM events WHERE event_type IN (:calendarIds)")
    fun getEventAndTasksIdsByCalendar(calendarIds: List<Long>): List<Long>

    @Query("SELECT id FROM events WHERE parent_id IN (:parentIds)")
    fun getEventIdsWithParentIds(parentIds: List<Long>): List<Long>

    @Query("SELECT id FROM events WHERE source = :source AND import_id != \"\" AND type = $TYPE_EVENT")
    fun getCalDAVCalendarEvents(source: String): List<Long>

    @Query("UPDATE events SET event_type = $LOCAL_CALENDAR_ID WHERE event_type = :calendarId")
    fun resetEventsAndTasksWithCalendarId(calendarId: Long)

    @Query("UPDATE events SET import_id = :importId, source = :source WHERE id = :id AND type = $TYPE_EVENT")
    fun updateEventImportIdAndSource(importId: String, source: String, id: Long)

    @Query("UPDATE events SET repeat_limit = :repeatLimit WHERE id = :id")
    fun updateEventRepetitionLimit(repeatLimit: Long, id: Long)

    @Query("UPDATE events SET repetition_exceptions = :repetitionExceptions WHERE id = :id")
    fun updateEventRepetitionExceptions(repetitionExceptions: String, id: Long)

    @Deprecated("Use Context.updateTaskCompletion() instead unless you know what you are doing.")
    @Query("UPDATE events SET flags = :newFlags WHERE id = :id")
    fun updateTaskCompletion(id: Long, newFlags: Int)

    @Query("UPDATE events SET import_id = :importId WHERE id = :id AND type = $TYPE_TASK")
    fun updateTaskImportId(importId: String, id: Long)

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insertOrUpdate(event: Event): Long

    @Query("DELETE FROM events WHERE id IN (:ids)")
    fun deleteEvents(ids: List<Long>)

    @Query("DELETE FROM events WHERE source = :source AND import_id = :importId")
    fun deleteBirthdayAnniversary(source: String, importId: String): Int
}