BranchLocationDao

BranchLocationDao.kt

package au.com.auspost.android.feature.postcode.service

import android.arch.persistence.room.Dao
import android.arch.persistence.room.Insert
import android.arch.persistence.room.OnConflictStrategy
import android.arch.persistence.room.Query
import au.com.auspost.android.feature.postcode.model.BranchLocation
import io.reactivex.Single

@Dao
interface BranchLocationDao {

    @Query("SELECT * from branch_location ORDER BY locality ASC")
    fun getAll() : Single<List<BranchLocation>>

    @Query("SELECT * from branch_location where postcode like :keyword OR locality like :keyword ORDER BY locality ASC")
    fun getByKeyword(keyword : String) : Single<List<BranchLocation>>

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insert(branchLocation: BranchLocation)

}