Medium article - Room + Flow for location updates

LocationDao.kt

@Dao
interface LocationDao {

    @Transaction
    suspend fun updateLocation(location: Location) {
        location.let {
            deleteLocations() // This deletes previous locations to keep the database small. If you want to store a full location history, remove this line.
            insertLocation(it)
        }
    }

    @Insert(onConflict = OnConflictStrategy.IGNORE)
    suspend fun insertLocation(location: Location)

    @Query("DELETE FROM location_table")
    suspend fun deleteLocations()

    @Query("SELECT * FROM location_table ORDER BY time")
    fun getLocations(): Flow<List<Location>>
}