@Dao
public interface ProductDao {
  @Query("SELECT * FROM product")
  List<Product> getAll();

  @Query("SELECT * FROM product WHERE name = :name")
  List<Product> findByName(String name);

  @Insert
  void insert(Product product);

  @Update
  void update(Product product);

  @Delete
  void delete(Product product);
  
  @Query("DELETE FROM product WHERE name = :name")
  void deleteByName(String name);
}