package Ġcom . co clear app . p dm _ project . Room . Dao Ċ Ċ import Ġandroidx . lifecycle . LiveData Ċ import Ġandroidx . room . Dao Ċ import Ġandroidx . room . Insert Ċ import Ġandroidx . room . On Conflict Strategy Ċ import Ġandroidx . room . Query Ċ import Ġcom . co clear app . p dm _ project . Room . Entity . Sound Ċ Ċ @ Dao Ċ interface ĠSound Dao Ġ{ ĊĊĠĠĠ Ġ@ Insert ( on Conflict Ġ= ĠOn Conflict Strategy . REPLACE ) ĊĠĠĠ Ġsuspend Ġfun Ġinsert ( table Ġ: ĠSound ) ĊĊĊĠĠĠ Ġ@ Query (" SELECT Ġ* Ġfrom ĠSounds ĠORDER ĠBY ĠSounds . number ĠASC ") ĊĠĠĠ Ġfun ĠgetAll Sounds (): ĠLive Data < List < Sound >> ĊĊĊĠĠĠ Ġ@ Query (" SELECT Ġ* ĠFROM ĠSounds ĠWHERE Ġlevel Ġ= Ġ: level ") ĊĠĠĠ Ġfun Ġget Sound sBy Level ( level : ĠInt ): ĠLive Data < List < Sound >> ĊĊĠĠĠ Ġ@ Query (" DELETE ĠFROM ĠSounds ") ĊĠĠĠ Ġfun Ġdelete All Sound () Ċ }