QuoteDAO.java

@Dao
public interface QuoteDAO {

@Insert(onConflict = REPLACE)
void cacheOnDB(List<Quote> quote);

@Query("SELECT * FROM quote")
LiveData<List<Quote>>getCachedQuotes();

//for saved quotes (starred quotes)
@Insert(onConflict = REPLACE)
void saveOnDevice(SavedQuote quote);

//no need of live data, we won’t be making any changes to it
@Query("SELECT * FROM savedquote")
List<SavedQuote> getSavedQuotes();

@Delete
void deleteQuote(SavedQuote quote);