Examples with Product org.hibernate.test.cid.Product used on opensource projects

Example 1 with Product

use of org.hibernate.test.cid.Product in project hibernate-orm by hibernate.

the class ASTParserLoadingTest method testStandardFunctions.

@Test
public void testStandardFunctions() throws Exception {
    Session session = openSession();
    Transaction t = session.beginTransaction();
    Product p = new Product();
    p.setDescription("a product");
    p.setPrice(new BigDecimal(1.0));
    p.setProductId("abc123");
    session.persist(p);
    Object[] result = (Object[]) session.createQuery("select current_time(), current_date(), current_timestamp() from Product").uniqueResult();
    assertTrue(result[0] instanceof Time);
    assertTrue(result[1] instanceof Date);
    assertTrue(result[2] instanceof Timestamp);
    assertNotNull(result[0]);
    assertNotNull(result[1]);
    assertNotNull(result[2]);
    session.delete(p);
    t.commit();
    session.close();
}

Example 2 with Product

use of org.hibernate.test.cid.Product in project hibernate-orm by hibernate.

the class ASTParserLoadingTest method testRowValueConstructorSyntaxInInList.

@Test
public void testRowValueConstructorSyntaxInInList() {
    Session s = openSession();
    s.beginTransaction();
    Product product = new Product();
    product.setDescription("My Product");
    product.setNumberAvailable(10);
    product.setPrice(new BigDecimal(123));
    product.setProductId("4321");
    s.save(product);
    Customer customer = new Customer();
    customer.setCustomerId("123456789");
    customer.setName("My customer");
    customer.setAddress("somewhere");
    s.save(customer);
    Order order = customer.generateNewOrder(new BigDecimal(1234));
    s.save(order);
    LineItem li = order.generateLineItem(product, 5);
    s.save(li);
    product = new Product();
    product.setDescription("My Product");
    product.setNumberAvailable(10);
    product.setPrice(new BigDecimal(123));
    product.setProductId("1234");
    s.save(product);
    li = order.generateLineItem(product, 10);
    s.save(li);
    s.flush();
    Query query = s.createQuery("from LineItem l where l.id in (:idList)");
    List<Id> list = new ArrayList<Id>();
    list.add(new Id("123456789", order.getId().getOrderNumber(), "4321"));
    list.add(new Id("123456789", order.getId().getOrderNumber(), "1234"));
    query.setParameterList("idList", list);
    assertEquals(2, query.list().size());
    query = s.createQuery("from LineItem l where l.id in :idList");
    query.setParameterList("idList", list);
    assertEquals(2, query.list().size());
    s.getTransaction().rollback();
    s.close();
}

Example 3 with Product

use of org.hibernate.test.cid.Product in project hibernate-orm by hibernate.

the class ASTParserLoadingTest method testOneToManyFilter.

@Test
@SkipForDialect(value = IngresDialect.class, jiraKey = "HHH-4976", comment = "Ingres 9.3 does not support sub-selects in the select list")
public void testOneToManyFilter() throws Throwable {
    Session session = openSession();
    Transaction txn = session.beginTransaction();
    Product product = new Product();
    product.setDescription("My Product");
    product.setNumberAvailable(10);
    product.setPrice(new BigDecimal(123));
    product.setProductId("4321");
    session.save(product);
    Customer customer = new Customer();
    customer.setCustomerId("123456789");
    customer.setName("My customer");
    customer.setAddress("somewhere");
    session.save(customer);
    Order order = customer.generateNewOrder(new BigDecimal(1234));
    session.save(order);
    LineItem li = order.generateLineItem(product, 5);
    session.save(li);
    session.flush();
    assertEquals(session.createFilter(customer.getOrders(), "").list().size(), 1);
    assertEquals(session.createFilter(order.getLineItems(), "").list().size(), 1);
    assertEquals(session.createFilter(order.getLineItems(), "where this.quantity > :quantity").setInteger("quantity", 5).list().size(), 0);
    session.delete(li);
    session.delete(order);
    session.delete(product);
    session.delete(customer);
    txn.commit();
    session.close();
}

Example 4 with Product

use of org.hibernate.test.cid.Product in project hibernate-orm by hibernate.

the class ASTParserLoadingTest method testImplicitPolymorphism.

@Test
@SkipForDialect(value = IngresDialect.class, jiraKey = "HHH-4976", comment = "Ingres 9.3 does not support sub-selects in the select list")
public void testImplicitPolymorphism() {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Product product = new Product();
    product.setDescription("My Product");
    product.setNumberAvailable(10);
    product.setPrice(new BigDecimal(123));
    product.setProductId("4321");
    s.save(product);
    List list = s.createQuery("from java.lang.Comparable").list();
    assertEquals(list.size(), 0);
    list = s.createQuery("from java.lang.Object").list();
    assertEquals(list.size(), 1);
    s.delete(product);
    list = s.createQuery("from java.lang.Object").list();
    assertEquals(list.size(), 0);
    t.commit();
    s.close();
}