ORDER BY datetime DESC LIMIT :limit OFFSET :offset") suspend fun fetch( limit: Int = 100, offset: Int = 0, ): List<TravelEntity> @Query("SELECT * FROM travel WHERE datetime = :datetime") suspend fun find(datetime: Instant): TravelEntity? @Insert suspend fun register(data: TravelEntity) @Update suspend fun update(data: TravelEntity) @Delete suspend fun delete(data: TravelEntity) }
class TravelEntity( @ColumnInfo(name = "shop_id") val shopId: Int, @ColumnInfo(name = "datetime") val dateTime: Instant, val size: Size, val type: Type, val topping: String?, val comment: String?, )