@Dao
interface MovieDao {

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insertMovie(movie: Movie)

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insertMovies(movies: List<Movie>)

    @Query("SELECT * FROM Movie WHERE Movie.id = :id")
    fun getMovieById( id : Int) : LiveData<Movie>

    @Query("SELECT * FROM Movie")
    fun getMovies() : List<Movie>

    @Query("DELETE FROM Movie WHERE id =:id")
    fun deleteMovieById(id: Int)

    @Query("DELETE FROM Movie")
    fun deleteMovies()
}