@Override
  public void addProduct(Product product, Customer customer) throws SQLException {
    var sql = "insert into PURCHASES (product_name, customer_name) values (?,?)";
    try (var connection = dataSource.getConnection();
        var preparedStatement = connection.prepareStatement(sql)) {
      preparedStatement.setString(1, product.getName());
      preparedStatement.setString(2, customer.getName());
      preparedStatement.executeUpdate();
    }
  }
@Test
  void shouldAddProductToPurchases() throws SQLException {
    TestUtils.executeSQL(INSERT_CUSTOMER_SQL, dataSource);
    TestUtils.executeSQL(ProductDaoImplTest.INSERT_PRODUCT_SQL, dataSource);

    customerDao.addProduct(product, customer);

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

      assertTrue(rs.next());
      assertEquals(product.getName(), rs.getString("product_name"));
      assertEquals(customer.getName(), rs.getString("customer_name"));
      assertFalse(rs.next());
    }
  }