package com.parkplants.data.db.dao

import androidx.room.*
import com.parkplants.data.db.entities.CachedNursery

@Dao
interface CachedNurseryDao {

    @Query("SELECT * FROM cached_nurseries ORDER BY name ASC")
    suspend fun getAll(): List<CachedNursery>

    @Query("SELECT * FROM cached_nurseries WHERE name LIKE :prefix || '%' ORDER BY name ASC LIMIT 20")
    suspend fun searchByPrefix(prefix: String): List<CachedNursery>

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    suspend fun insertAll(nurseries: List<CachedNursery>)

    @Query("DELETE FROM cached_nurseries")
    suspend fun deleteAll()

    @Transaction
    suspend fun replaceAll(nurseries: List<CachedNursery>) {
        deleteAll()
        insertAll(nurseries)
    }
}