new file mode 100644

@@ -0,0 +1,40 @@

+/*

+ * Copyright (c) 2023 Samson Achiaga

+ *

+ * Licensed under the Apache License, Version 2.0 (the "License");

+ * you may not use this file except in compliance with the License.

+ * You may obtain a copy of the License at

+ *

+ *     http://www.apache.org/licenses/LICENSE-2.0

+ *

+ * Unless required by applicable law or agreed to in writing, software

+ * distributed under the License is distributed on an "AS IS" BASIS,

+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

+ * See the License for the specific language governing permissions and

+ * limitations under the License.

+ */

+

+package com.certified.audionote.database

+

+import androidx.room.*

+import com.certified.audionote.model.Note

+import kotlinx.coroutines.flow.Flow

+

+@Dao

+interface AudioNotesDAO {

+

+    @Insert(onConflict = OnConflictStrategy.REPLACE)

+    suspend fun insertNote(note: Note)

+

+    @Update

+    suspend fun updateNote(note: Note)

+

+    @Delete

+    suspend fun deleteNote(note: Note)

+

+    @Query("SELECT * FROM notes_table WHERE id = :noteId")

+    fun getNote(noteId: Int): Flow<Note>

+

+    @Query("SELECT * FROM notes_table ORDER BY id DESC")

+    fun getAllNotes(): Flow<List<Note>?>

+}

\ No newline at end of file