@Override
  public void deleteProduct(Product product, Customer customer) throws SQLException {
    var sql = "delete from PURCHASES where product_name = ? and customer_name = ?";
    try (var connection = dataSource.getConnection();
        var preparedStatement = connection.prepareStatement(sql)) {
      preparedStatement.setString(1, product.getName());
      preparedStatement.setString(2, customer.getName());
      preparedStatement.executeUpdate();
    }
  }
@Test
  void shouldDeleteProductFromPurchases() throws SQLException {
    TestUtils.executeSQL(INSERT_CUSTOMER_SQL, dataSource);
    TestUtils.executeSQL(ProductDaoImplTest.INSERT_PRODUCT_SQL, dataSource);
    TestUtils.executeSQL(INSERT_PURCHASES_SQL, dataSource);

    customerDao.deleteProduct(product, customer);

    try (var connection = dataSource.getConnection();
        var statement = connection.createStatement();
        ResultSet rs = statement.executeQuery(SELECT_PURCHASES_SQL)) {

      assertFalse(rs.next());
    }
  }