User DAO - Room

UserDao.kt

@Dao
interface UserDao {
  
    @Insert
    fun insertAll(users: List<User>)

    @Update
    fun update(user: User)

    @Delete
    fun delete(user: User)
  
    @Query("SELECT * FROM users")
    fun getUsers(): List<User>

    @Query("SELECT * FROM users WHERE name LIKE :name LIMIT 1")
    fun getUserByName(name: String): User
}