1package com.pdelong.speedwagon23import androidx.room.Dao4import androidx.room.Delete5import androidx.room.Insert6import androidx.room.Query7import androidx.room.Update8import kotlinx.coroutines.flow.Flow910@Dao11interface RecordingDao {12 @Query("SELECT * FROM recordings ORDER BY timestamp DESC")13 fun getAll(): Flow<List<Recording>>1415 @Query("SELECT * FROM recordings WHERE id = :id")16 suspend fun get(id: Long): Recording1718 @Insert19 suspend fun insert(recording: Recording): Long2021 @Query("UPDATE recordings SET title = :title WHERE id = :id")22 suspend fun updateTitle(id: Long, title: String)2324 @Delete25 suspend fun delete(recording: Recording)26}