Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 681399 Details for
Bug 899515
HHH-6655 TemplateRenderer and CriteriaQueryBuilder.TrimSpec behaves differently for DB2 causing querybuilder.trim test in JPA2 TCK to fail
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
Client.java
Client.java (text/plain), 207.72 KB, created by
Madhumita Sadhukhan
on 2011-09-14 12:53:48 UTC
(
hide
)
Description:
Client.java
Filename:
MIME Type:
Creator:
Madhumita Sadhukhan
Created:
2011-09-14 12:53:48 UTC
Size:
207.72 KB
patch
obsolete
> /* > * Copyright 2009 Sun Microsystems, Inc. All rights reserved. > * SUN PROPRIETARY/CONFIDENTIAL. Use is subject to license terms. > */ >package com.sun.ts.tests.ejb30.persistence.criteriaapi.querybuilder; > >import javax.persistence.EntityTransaction; >import javax.persistence.EntityManager; >import javax.persistence.metamodel.Metamodel; >import javax.persistence.metamodel.EntityType; >import javax.persistence.metamodel.ManagedType; >import javax.persistence.metamodel.EmbeddableType; >import java.util.Properties; >import java.util.Set; >import java.util.Collection; >import java.math.BigInteger; >import com.sun.javatest.Status; >import com.sun.ts.lib.harness.EETest.Fault; >import com.sun.ts.tests.ejb30.common.helper.TLogger; >import com.sun.ts.tests.ejb30.persistence.common.PMClientBase; >import javax.persistence.EntityManagerFactory; >import javax.persistence.Tuple; >import javax.persistence.criteria.CriteriaQuery; >import javax.persistence.criteria.CriteriaBuilder; >import javax.persistence.criteria.CriteriaBuilder.Trimspec; >import javax.persistence.criteria.Root; >import javax.persistence.criteria.Predicate; >import javax.persistence.Query; >import javax.persistence.TypedQuery; >import javax.persistence.criteria.Expression; >import javax.persistence.criteria.ParameterExpression; >import java.lang.reflect.Method; >import java.lang.reflect.Field; >import java.lang.reflect.Modifier; >import java.util.List; >import java.util.Iterator; >import java.math.BigDecimal; > >import java.sql.Date; >import java.sql.Time; >import java.sql.Timestamp; >import java.text.SimpleDateFormat; >import java.util.Calendar; >import javax.persistence.PersistenceException; >import javax.persistence.NoResultException; >import javax.persistence.Query; >import javax.persistence.criteria.Subquery; >import javax.persistence.criteria.Join; >import javax.persistence.metamodel.CollectionAttribute; > >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Address; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Alias; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Country; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.CreditCard; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Info; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.LineItem; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Order; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Phone; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.HardwareProduct; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.SoftwareProduct; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Spouse; >import com.sun.ts.tests.ejb30.persistence.criteriaapi.util.ShelfLife; > >public class Client extends PMClientBase implements java.io.Serializable { > > public static final int CUSTOMERREF = 1; > public static final int ORDERREF = 2; > public static final int ALIASREF = 3; > public static final int PRODUCTREF = 4; > public static final int NUMOFCUSTOMERS = 20; > public static final int NUMOFORDERS = 20; > public static final int NUMOFALIASES = 30; > public static final int NUMOFALLPRODUCTS = 38; > public static final int NUMOFPRODUCTS = 18; > public static final int NUMOFSWPRODUCTS = 10; > public static final int NUMOFHWPRODUCTS = 10; > public static final int NUMOFADDRESSES = 36; > public static final int NUMOFHOMEADDRESSES = 18; > public static final int NUMOFWORKADDRESSES = 18; > public static final int NUMOFPHONES = 36; > public static final int NUMOFCREDITCARDS = 24; > public static final int NUMOFLINEITEMS = 56; > public static final int NUMOFSPOUSES = 6; > public static final int NUMOFINFODATA = 6; > public static final int NUMOFCOUNTRIES = 20; > public static Phone phone[] = new Phone[50]; > public static Address address[] = new Address[50]; > public static Country country[] = new Country[50]; > public static CreditCard creditCard[] = new CreditCard[50]; > public static LineItem lineItem[] = new LineItem[60]; > public static Spouse spouse[] = new Spouse[6]; > public static Info info[] = new Info[6]; > private static Customer customerRef[] = new Customer[50]; > private static Order orderRef[] = new Order[50]; > private static Alias aliasRef[] = new Alias[50]; > private static Product productRef[] = new Product[50]; > private static HardwareProduct hardwareRef[] = new HardwareProduct[20]; > private static SoftwareProduct softwareRef[] = new SoftwareProduct[20]; > private static ShelfLife shelfRef[] = new ShelfLife[20]; > public static final Date d1 = getShelfDate(2000, 2, 14); > public static final Date d2 = getShelfDate(2001, 6, 27); > public static final Date d3 = getShelfDate(2002, 7, 7); > public static final Date d4 = getShelfDate(2003, 3, 3); > public static final Date d5 = getShelfDate(2004, 4, 10); > public static final Date d6 = getShelfDate(2005, 2, 18); > public static final Date d7 = getShelfDate(2000, 9, 17); > public static final Date d8 = getShelfDate(2001, 11, 14); > public static final Date d9 = getShelfDate(2002, 10, 4); > public static final Date d10 = getShelfDate(2003, 1, 25); > private static Properties props = null; > private static List aliasCol = null; > private static List custCol = null; > private static List orderCol = null; > private static List prodCol = null; > > public Client() { > } > > public static void main(String[] args) { > Client theTests = new Client(); > Status s = theTests.run(args, System.out, System.err); > s.exit(); > } > > public void setup(String[] args, Properties p) throws Fault { > TLogger.log("setup"); > try { > super.setup(args, p); > schema30Setup(p); > } catch (Exception e) { > TLogger.log("Exception: " + e.getMessage()); > throw new Fault("Setup failed:", e); > } > } > > /* > * @testName: createQuery > * @assertion_ids: > * > * @test_Strategy: > * > */ > public void createQuery() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Object> cquery = cbuilder.createQuery(); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > pass = true; > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("createQuery Test failed"); > } > } > > /* > * @testName: createQuery2 > * @assertion_ids: > * > * @test_Strategy: > * > */ > public void createQuery2() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Order> cquery = cbuilder.createQuery(Order.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > pass = true; > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("createQuery2 Test failed"); > } > } > > /* > * @testName: createTuple > * @assertion_ids: > * > * @test_Strategy: > * > */ > public void createTuple() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Tuple> cquery = cbuilder.createTupleQuery(); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query Tuple"); > pass = true; > } else { > TLogger.log("Failed to get Non-null Criteria Query Tuple"); > } > > et.commit(); > > if (!pass) { > throw new Fault("createTuple Test failed"); > } > } > > /* > * @testName: construct > * @assertion_ids: > * > * @test_Strategy: convert the following jpql to CriteriaQuery > * > * SELECT NEW com.sun.ts.tests.ejb30.persistence.query.language.schema30.Customer > * (c.id, c.name) FROM Customer c where c.home.city = 'Roslindale' > * > * > */ > public void construct() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > Metamodel mm = em.getMetamodel(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > EntityType<Address> Address_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Address.class); > > cquery.select(cbuilder.construct(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer.class, > customer.get(Customer_.getSingularAttribute("id", String.class)), > customer.get(Customer_.getSingularAttribute("name", String.class)))).where(cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("city", String.class)), "Roslindale")); > TypedQuery<Customer> tq = em.createQuery(cquery); > List<Customer> result = tq.getResultList(); > > if (result.size() != 1) { > TLogger.log( > "ERROR: Did not get expected results. Expected 1 , got: " + result.size()); > } else { > TLogger.log("Expected results received"); > pass = true; > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("construct Test failed"); > } > } > > /* > * @testName: tuple > * @assertion_ids: > * > * @test_Strategy: convert the following JPQL to CriteriaQuery > * Select c.id, c.name from Customer c > * > */ > public void tuple() throws Fault { > boolean pass = false; > int expectedResultSize = 20; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Tuple> cquery = cbuilder.createTupleQuery(); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > TLogger.log("Use Tuple Query"); > > cquery.multiselect(customer.get(Customer_.getSingularAttribute("id", String.class)), > customer.get(Customer_.getSingularAttribute("name", String.class))); > > TypedQuery<Tuple> tq = em.createQuery(cquery); > > List<Tuple> result = tq.getResultList(); > > if (result.size() == expectedResultSize) { > TLogger.log("Result size =" + result.size()); > pass = true; > > } else { > TLogger.log("Received incorrect result size =" + result.size()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("tuple test failed"); > } > } > > /* > * testName: array > * @assertion_ids: > * > * @test_Strategy: > * convert the following JPQL to CriteriaQuery and return the result as > * an object array > * > * Select c.id, c.name from Customer c > * > */ > public void array() throws Fault { > boolean pass = false; > int expectedResultSize = 400; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Object[]> cquery = cbuilder.createQuery(Object[].class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > TLogger.log("Use Tuple Query"); > > cquery.select(cbuilder.array( > customer.get(Customer_.getSingularAttribute("id", String.class)), > customer.get(Customer_.getSingularAttribute("name", String.class)) > )); > > Query q = em.createQuery(cquery); > > List result = q.getResultList(); > > if (result.size() == expectedResultSize) { > TLogger.log("Result size =" + result.size()); > pass = true; > > } else { > TLogger.log("Received incorrect result size =" + result.size()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("array test failed"); > } > } > > > /* > * @testName: asc > * @assertion_ids: > * > * @test_Strategy: > * Select hardwareProduct.modelNumber from HardwareProduct ORDER BY hardware.Product.modeNumber > */ > public void asc() throws Fault { > final int expectedModelNumber = 40; > final int expectedResultSize = 10; > boolean pass = false; > EntityManager em = getEntityManager(); > > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<HardwareProduct> cquery = cbuilder.createQuery(HardwareProduct.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<HardwareProduct> hardProd = cquery.from(HardwareProduct.class); > EntityType<HardwareProduct> HardwareProduct_ = hardProd.getModel(); > cquery.select(hardProd); > cquery.orderBy(cbuilder.asc(hardProd.get(HardwareProduct_.getSingularAttribute("modelNumber")))); > TypedQuery<HardwareProduct> tq = em.createQuery(cquery); > List<HardwareProduct> result = tq.getResultList(); > > if (result.size() == expectedResultSize && result.get(0).getModelNumber() == expectedModelNumber) { > TLogger.log("Expected results received."); > pass = true; > } else { > TLogger.log("test returned: " + result.get(0).getModelNumber() + > ", expected: " + expectedModelNumber); > for (HardwareProduct o : result) { > TLogger.log("**id=" + o.getId() + ", model=" + o.getModelNumber()); > } > pass = false; > } > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("asc Test failed"); > } > } > > /* > * @testName: desc > * @assertion_ids: > * > * @test_Strategy: > * > */ > public void desc() throws Fault { > final int expectedModelNumber = 104; > final int expectedResultSize = 10; > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<HardwareProduct> cquery = cbuilder.createQuery(HardwareProduct.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<HardwareProduct> hardProd = cquery.from(HardwareProduct.class); > EntityType<HardwareProduct> HardwareProduct_ = hardProd.getModel(); > cquery.select(hardProd); > cquery.orderBy(cbuilder.desc(hardProd.get(HardwareProduct_.getSingularAttribute("modelNumber")))); > TypedQuery<HardwareProduct> tq = em.createQuery(cquery); > List<HardwareProduct> result = tq.getResultList(); > > > if (result.size() == expectedResultSize && result.get(7).getModelNumber() == expectedModelNumber) { > TLogger.log("Expected results received."); > pass = true; > } else { > TLogger.log("test returned: " + result.get(7).getModelNumber() + > "expected: " + expectedModelNumber); > for (HardwareProduct o : result) { > TLogger.log("**id=" + o.getId() + ", model=" + o.getModelNumber()); > } > pass = false; > } > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("desc Test failed"); > } > } > > > /* > * @testName: avg > * @assertion_ids: > * > * @test_Strategy: Convert the following JPQL to CriteriaQuery > * SELECT AVG(o.totalPrice) FROM Order o > */ > public void avg() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Double> cquery = cbuilder.createQuery(Double.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> order_ = order.getModel(); > cquery.select(cbuilder.avg(order.get(order_.getSingularAttribute("totalPrice", Double.class)))); > > TypedQuery<Double> tq = em.createQuery(cquery); > Double d1 = 1487.29; > Double d2 = 1487.30; > > Double d3 = tq.getSingleResult(); > > if (((d3 >= d1) && (d3 < d2))) { > TLogger.log("avg test returned expected results: " + d1); > pass = true; > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("avg test failed"); > } > } > > /* > * @testName: sum > * @assertion_ids: > * > * @test_Strategy: Convert the following JPQL to CriteriaQuery > * SELECT Sum(p.price) FROM Product p > */ > public void sum() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Double> cquery = cbuilder.createQuery(Double.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Product> product = cquery.from(Product.class); > > //Get Metamodel from Root > EntityType<Product> Product_ = product.getModel(); > cquery.select(cbuilder.sum(product.get(Product_.getSingularAttribute("price", Double.class)))); > > TypedQuery<Double> tq = em.createQuery(cquery); > Double d1 = new Double(33387.14); > Double d2 = new Double(33387.15); > > Double d3 = tq.getSingleResult(); > > if (((d3 >= d1) && (d3 < d2))) { > TLogger.log("sum test returned expected results: " + d1); > pass = true; > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("sum test failed"); > } > } > > /* > * @testName: max > * @assertion_ids: > * > * @test_Strategy: Convert following JPQL to CriteriaQuery > * SELECT DISTINCT MAX(l.quantity) FROM LineItem l > */ > public void max() throws Fault { > boolean pass = false; > Integer i1 = new Integer(8); > Integer i2 = 0; > > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Integer> cquery = cbuilder.createQuery(Integer.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<LineItem> lineItem = cquery.from(LineItem.class); > > //Get Metamodel from Root > EntityType<LineItem> lineItem_ = lineItem.getModel(); > TLogger.log("Find MAXIMUM number of lineItem quantities available an order may have"); > > cquery.select(cbuilder.max(lineItem.get(lineItem_.getSingularAttribute("quantity", Integer.class)))); > cquery.distinct(true); > > TypedQuery<Integer> tq = em.createQuery(cquery); > > i2 = tq.getSingleResult(); > > if (i2.equals(i1)) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("max test returned:" + i2 + "expected: " + i1); > > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("max test failed"); > } > } > > /* > * @testName: min > * @assertion_ids: > * > * @test_Strategy: convert the forllowing JPQL into CriteriaQuery > * SELECT DISTINCT MIN(o.totalPrice) FROM Order o where o.customer.name = 'Robert E. Bissett' > */ > public void min() throws Fault { > boolean pass = false; > Double d1 = new Double("92.9"); > Double d2 = null; > > > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Double> cquery = cbuilder.createQuery(Double.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > EntityType<Customer> Customer_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer.class); > TLogger.log("Find MINIMUM order totalPrice for Robert E. Bissett"); > > cquery.select(cbuilder.min(order.get(Order_.getSingularAttribute("totalPrice", Double.class)))); > cquery.where(cbuilder.equal( > order.get(Order_.getSingularAttribute("customer", Customer.class)).get(Customer_.getSingularAttribute("name", String.class)), "Robert E. Bissett")); > > cquery.distinct(true); > > TypedQuery<Double> tq = em.createQuery(cquery); > d2 = tq.getSingleResult(); > TLogger.log("Received D2=" + d2); > > if (d2.equals(d1)) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("min test returned " + d2 + "expected: " + d1); > > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("min test failed"); > } > } > > /* > * @testName: greatest > * @assertion_ids: > * > * @test_Strategy: > * > */ > public void greatest() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<String> cquery = cbuilder.createQuery(String.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > TLogger.log("Find Greatest Order id Using lexicographic comparision"); > > cquery.select(cbuilder.greatest(order.get(Order_.getSingularAttribute("id", String.class)))); > > TypedQuery<String> tq = em.createQuery(cquery); > > // lexicographic comparision should return 9 as the greatest id > // from the following list of ids > // { 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 } > String expectedResult = "9"; > String queryOutput = tq.getSingleResult(); > > if (queryOutput.equals(expectedResult)) { > TLogger.log("Received expected result : " + expectedResult); > pass = true; > } else { > TLogger.log("Query returned : " + queryOutput + " Expected result : " + expectedResult); > } > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("greatest test failed"); > } > } > > /* > * @testName: least > * @assertion_ids: > * > * @test_Strategy: > * > */ > public void least() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<String> cquery = cbuilder.createQuery(String.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > TLogger.log("Find least Order id Using lexicographic comparision"); > > cquery.select(cbuilder.least(order.get(Order_.getSingularAttribute("id", String.class)))); > > TypedQuery<String> tq = em.createQuery(cquery); > > // lexicographic comparision should return 1 as the least id > // from the following list of ids > // { 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 } > String expectedResult = "1"; > String queryOutput = tq.getSingleResult(); > > if (queryOutput.equals(expectedResult)) { > TLogger.log("Received expected result : " + expectedResult); > pass = true; > } else { > TLogger.log("Query returned : " + queryOutput + " Expected result : " + expectedResult); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("least test failed"); > } > } > > /* > * @testName: count > * @assertion_ids: > * > * @test_Strategy: convert the following JPQL to CriteriaQuery > * Select COUNT (o.id) From Order o > */ > public void count() throws Fault { > boolean pass = false; > > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Long> cquery = cbuilder.createQuery(Long.class); > if (cquery != null) { > Root<Order> order = cquery.from(Order.class); > EntityType<Order> Order_ = order.getModel(); > cquery.select(cbuilder.count(order.get(Order_.getSingularAttribute("id", String.class)))); > > TypedQuery<Long> tq = em.createQuery(cquery); > > Long countResult = tq.getSingleResult(); > Long expectedCount = new Long(20); > > if (countResult.equals(expectedCount)) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("count test returned:" + countResult + "expected: " + expectedCount); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("count test failed"); > } > } > > /* > * @testName: countDistinct > * @assertion_ids: > * > * @test_Strategy: > * Select DISTINCT Count(c.home.city) from Customer c > */ > public void countDistinct() throws Fault { > boolean pass = false; > > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Long> cquery = cbuilder.createQuery(Long.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > EntityType<Address> Address_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Address.class); > TLogger.log("Count number of orders by customer"); > > cquery.select(cbuilder.countDistinct(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("city", String.class)))); > > TypedQuery<Long> tq = em.createQuery(cquery); > > Long countResult = tq.getSingleResult(); > Long expectedCount = new Long(16); > > if (countResult.equals(expectedCount)) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("count test returned:" + countResult + "expected: " + expectedCount); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("countDistinct test failed"); > } > } > > /* > * @testName: exists > * @assertion_ids: > * > * @test_Strategy: convert the following JPQL into CriteriaQuery > * > * SELECT product FROM PRODUCT product WHERE EXISTS > * (Select hardProd From PRODUCT hardprod where hardprod.id = '19'). > * > * > */ > public void exists() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Product> cquery = cbuilder.createQuery(Product.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<Product> product = cquery.from(Product.class); > > //Get Metamodel from Root > EntityType<Product> Product_ = product.getModel(); > > // create Subquery instance, with root Customer > Subquery<Product> sq = cquery.subquery(Product.class); > Root<Product> hardProd = sq.from(Product.class); > > // the subquery references the root of the containing query > sq.where(cbuilder.equal( > product.get(Product_.getSingularAttribute("id", String.class)), "19")).select(hardProd); > > // an exists condition is applied to the subquery result > cquery.where(cbuilder.exists(sq)); > > cquery.select(product); > > TypedQuery<Product> tq = em.createQuery(cquery); > List<Product> result = tq.getResultList(); > int expectedSize = 1; > > if (result.size() == expectedSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("exists test returned:" + result.size() + "expected: " + expectedSize); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("exists test failed"); > } > } > > /* > * @testName: all > * @assertion_ids: > * > * @test_Strategy: convert the following JPQL into CriteriaQuery > * > * Select hardProd.modelNumber From HardwareProduct hardProd where hardProd.modelNumber > ALL ( > * Select subHardProd.modelNumber From HardwareProduct subHardProd where subHardProd.modelNumber < 10050 ) > * > * > */ > public void all() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Integer> cquery = cbuilder.createQuery(Integer.class); > if (cquery != null) { > TLogger.log("Obtained Non-null Criteria Query"); > Root<HardwareProduct> hardProd = cquery.from(HardwareProduct.class); > > //Get Metamodel from Root > EntityType<HardwareProduct> HardwareProduct_ = hardProd.getModel(); > > // create Subquery instance > Subquery<Integer> sq = cquery.subquery(Integer.class); > Root<HardwareProduct> subHardProd = sq.from(HardwareProduct.class); > > > sq.select(subHardProd.get(HardwareProduct_.getSingularAttribute("modelNumber", Integer.class))); > sq.where(cbuilder.lt(subHardProd.get(HardwareProduct_.getSingularAttribute("modelNumber", Integer.class)), 1050)); > > cquery.select(hardProd.get(HardwareProduct_.getSingularAttribute("modelNumber", Integer.class))); > cquery.where(cbuilder.gt( > hardProd.get(HardwareProduct_.getSingularAttribute("modelNumber", Integer.class)), > cbuilder.all(sq))); > > TypedQuery<Integer> tq = em.createQuery(cquery); > List<Integer> result = tq.getResultList(); > int expectedSize = 5; > > if (result.size() == expectedSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("all test returned:" + result.size() + "expected: " + expectedSize); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("all test failed"); > } > } > > /* > * @testName: some > * @assertion_ids: > * > * @test_Strategy: convert the following JPQL into CriteriaQuery > * SELECT DISTINCT c FROM Customer c, IN(c.orders) co > * WHERE co.totalPrice <= SOME(Select o.totalPrice FROM Order o, > * IN(o.lineItems) l WHERE l.quantity = 3 ) > * > */ > public void some() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > // Get Root Customer > Root<Customer> customer = cquery.from(Customer.class); > > // Get Metamodels > EntityType<Order> Order_ = mm.entity( > com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Order.class); > > EntityType<LineItem> LineItem_ = mm.entity( > com.sun.ts.tests.ejb30.persistence.criteriaapi.util.LineItem.class); > > EntityType<Customer> Customer_ = customer.getModel(); > > // Join Customer-Order > Join<Customer, Order> orders = customer.join(Customer_.getCollection("orders", Order.class)); > > > // create Subquery instance > Subquery<Double> sq = cquery.subquery(Double.class); > > // Create Roots > Root<Order> order = sq.from(Order.class); > > // Join Order-LineItem > Join<Order, LineItem> lineItems = order.join(Order_.getCollection("lineItems", LineItem.class)); > > // Create SubQuery > sq.select(order.get(Order_.getSingularAttribute("totalPrice", Double.class))).where(cbuilder.equal(lineItems.get(LineItem_.getSingularAttribute("quantity", Integer.class)), 3)); > > cquery.select(customer); > > // Create Main Query with SubQuery > cquery.where(cbuilder.le(orders.get(Order_.getSingularAttribute("totalPrice", Double.class)), cbuilder.some(sq))); > cquery.distinct(true); > > TypedQuery<Customer> tq = em.createQuery(cquery); > List<Customer> result = tq.getResultList(); > int expectedSize = 18; > > if (result.size() == expectedSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("exists test returned:" + result.size() + "expected: " + expectedSize); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("some test failed"); > } > } > > /* > * @testName: any > * @assertion_ids: > * > * @test_Strategy: convert the following JPQL into CriteriaQuery > * SELECT DISTINCT object(c) FROM Customer c, IN(c.orders) co > * WHERE co.totalPrice < ANY (Select o.totalPrice FROM Order o, > * IN(o.lineItems) l WHERE l.quantity = 3 ) > * > */ > public void any() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > // Get Root Customer > Root<Customer> customer = cquery.from(Customer.class); > > // Get Metamodels > EntityType<Order> Order_ = mm.entity( > com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Order.class); > > EntityType<LineItem> LineItem_ = mm.entity( > com.sun.ts.tests.ejb30.persistence.criteriaapi.util.LineItem.class); > > EntityType<Customer> Customer_ = customer.getModel(); > > // Join Customer-Order > Join<Customer, Order> orders = customer.join(Customer_.getCollection("orders", Order.class)); > > > // create Subquery instance > Subquery<Double> sq = cquery.subquery(Double.class); > > // Create Roots > Root<Order> order = sq.from(Order.class); > > // Join Order-LineItem > Join<Order, LineItem> lineItems = order.join(Order_.getCollection("lineItems", LineItem.class)); > > // Create SubQuery > sq.select(order.get(Order_.getSingularAttribute("totalPrice", Double.class))). > where(cbuilder.equal(lineItems.get(LineItem_.getSingularAttribute("quantity")), 3)); > > cquery.select(customer); > > // Create Main Query with SubQuery > cquery.where(cbuilder.lt(orders.get(Order_.getSingularAttribute("totalPrice", Double.class)), cbuilder.any(sq))); > cquery.distinct(true); > > TypedQuery<Customer> tq = em.createQuery(cquery); > List<Customer> result = tq.getResultList(); > int expectedSize = 17; > > if (result.size() == expectedSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("exists test returned:" + result.size() + "expected: " + expectedSize); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("any test failed"); > } > } > > /* > * @testName: andPredicates > * @assertion_ids: > * > * @test_Strategy: > * SELECT c from Customer c WHERE c.home.street = '125 Moxy Lane' AND > * c.home.city = 'Swansea' AND c.home.state = 'MA and > * c.home.zip = '11345' > */ > public void andPredicates() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > EntityType<Address> Address_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Address.class); > > cquery.select(customer); > > cquery.where(cbuilder.and( > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("street", String.class)), "125 Moxy Lane"), > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("city", String.class)), "Swansea"), > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("state", String.class)), "MA"), > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("zip", String.class)), "11345"))); > > TypedQuery<Customer> tq = em.createQuery(cquery); > > Customer result = tq.getSingleResult(); > > > Customer expectedCustomer = em.find(Customer.class, "3"); > if (expectedCustomer != null) { > if (result == expectedCustomer) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received result"); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("andPredicates test failed"); > > } > } > > > /* > * @testName: orPredicates > * @assertion_ids: > * > * @test_Strategy: > * SELECT Distinct c from Customer c WHERE c.home.street = '47 Skyline Drive' OR > * c.home.city = 'Chelmsford' OR c.home.state = 'VT' OR > * c.home.zip = '02155' > */ > public void orPredicates() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > EntityType<Address> Address_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Address.class); > > cquery.select(customer); > > cquery.where(cbuilder.or( > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("street", String.class)), "47 Skyline Drive"), > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("city", String.class)), "Chelmsford"), > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("state", String.class)), "VT"), > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("zip", String.class)), "02155"))); > cquery.distinct(true); > > TypedQuery<Customer> tq = em.createQuery(cquery); > > List<Customer> result = tq.getResultList(); > int expectedResultSize = 4; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("orPredicates test failed"); > > } > } > > > /* > * @testName: not > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct o FROM Order o WHERE NOT o.totalPrice < 4500 > * > * > */ > public void not() throws Fault { > boolean pass = false; > Double expectedTotalPrice = new Double(4500.0); > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Order> cquery = cbuilder.createQuery(Order.class); > if (cquery != null) { > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > > cquery.select(order); > cquery.where(cbuilder.not( > cbuilder.lt(order.get(Order_.getSingularAttribute("totalPrice", Double.class)), > expectedTotalPrice))); > > cquery.distinct(true); > > TypedQuery<Order> tq = em.createQuery(cquery); > > List<Order> result = tq.getResultList(); > int expectedResultSize = 3; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("not test failed"); > > } > } > > > /* > * @testName: conjunction > * @assertion_ids: > * > * @test_Strategy: Use Conjunction > * Select Distinct o FROM Order o where o.customer.name = 'Robert E. Bissett' > * > * Note: cbuilder.conjunction() always returns true > */ > public void conjunction() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Order> cquery = cbuilder.createQuery(Order.class); > if (cquery != null) { > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > EntityType<Customer> Customer_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer.class); > cquery.select(order); > cquery.where(cbuilder.and(cbuilder.equal( > order.get(Order_.getSingularAttribute("customer", Customer.class)).get(Customer_.getSingularAttribute("name", String.class)), "Robert E. Bissett"), > cbuilder.isTrue(cbuilder.conjunction()))); > > cquery.distinct(true); > > TypedQuery<Order> tq = em.createQuery(cquery); > > List<Order> result = tq.getResultList(); > int expectedResultSize = 2; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("conjunction test failed"); > > } > } > > /* > * @testName: disjunction > * @assertion_ids: > * > * @test_Strategy: Use Disjunction > * Select Distinct o FROM Order o where o.customer.name = 'Robert E. Bissett' > * > * Note: cbuilder.disjunction() always returns false > */ > public void disjunction() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Order> cquery = cbuilder.createQuery(Order.class); > if (cquery != null) { > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > EntityType<Customer> Customer_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer.class); > cquery.select(order); > cquery.where(cbuilder.and(cbuilder.equal( > order.get(Order_.getSingularAttribute("customer", Customer.class)).get(Customer_.getSingularAttribute("name", String.class)), "Robert E. Bissett"), > cbuilder.isFalse(cbuilder.disjunction()))); > > cquery.distinct(true); > > TypedQuery<Order> tq = em.createQuery(cquery); > > List<Order> result = tq.getResultList(); > int expectedResultSize = 2; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("disjunction test failed"); > > } > } > > /* > * @testName: isTrue > * @assertion_ids: > * > * @test_Strategy: Use Conjunction > * Select Distinct o FROM Order o where o.customer.name = 'Robert E. Bissett' > * > * Note: cbuilder.conjunction() always returns true > */ > public void isTrue() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Order> cquery = cbuilder.createQuery(Order.class); > if (cquery != null) { > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > EntityType<Customer> Customer_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer.class); > cquery.select(order); > cquery.where(cbuilder.and(cbuilder.equal( > order.get(Order_.getSingularAttribute("customer", Customer.class)).get(Customer_.getSingularAttribute("name", String.class)), "Robert E. Bissett"), > cbuilder.isTrue(cbuilder.conjunction()))); > > cquery.distinct(true); > > TypedQuery<Order> tq = em.createQuery(cquery); > > List<Order> result = tq.getResultList(); > int expectedResultSize = 2; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("isTrue test failed"); > > } > } > > /* > * @testName: isFalse > * @assertion_ids: > * > * @test_Strategy: Use Disjunction > * Select Distinct o FROM Order o where o.customer.name = 'Robert E. Bissett' > * > * Note: cbuilder.disjunction() always returns false > */ > public void isFalse() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Order> cquery = cbuilder.createQuery(Order.class); > if (cquery != null) { > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > EntityType<Customer> Customer_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer.class); > cquery.select(order); > cquery.where(cbuilder.and(cbuilder.equal( > order.get(Order_.getSingularAttribute("customer", Customer.class)).get(Customer_.getSingularAttribute("name", String.class)), "Robert E. Bissett"), > cbuilder.isFalse(cbuilder.disjunction()))); > > cquery.distinct(true); > > TypedQuery<Order> tq = em.createQuery(cquery); > > List<Order> result = tq.getResultList(); > int expectedResultSize = 2; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("isFalse test failed"); > > } > } > > > /* > * @testName: isNull > * @assertion_ids: > * > * @test_Strategy: > * Select c FROM Customer c where c.name is null > * > * > */ > public void isNull() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer.class); > cquery.select(customer); > > cquery.where(cbuilder.isNull(customer.get(Customer_.getSingularAttribute("name", String.class)))); > > TypedQuery<Customer> tq = em.createQuery(cquery); > > List<Customer> result = tq.getResultList(); > int expectedResultSize = 1; > > if (result.size() == expectedResultSize) { > pass = true; > TLogger.log("Successfully received expected Result"); > } else { > TLogger.log("Expected resultsize :" + expectedResultSize + " Received size :" + result.size()); > } > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("isNull test failed"); > > } > } > > /* > * @testName: isNotNull > * @assertion_ids: > * > * @test_Strategy: > * Select c FROM Customer c where c.work.zip IS NOT NULL > * > */ > public void isNotNull() throws Fault { > boolean pass = false; > final int expectedResultSize = 17; > EntityManager em = getEntityManager(); > CriteriaBuilder cb = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cb.createQuery(Customer.class); > > if (cquery != null) { > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = mm.entity(Customer.class); > EntityType<Address> Address_ = mm.entity(Address.class); > cquery.where( > cb.isNotNull( > customer.get(Customer_.getSingularAttribute("work", Address.class)).get(Address_.getSingularAttribute("zip", String.class)))); > > cquery.select(customer); > > TypedQuery<Customer> tq = em.createQuery(cquery); > List<Customer> result = tq.getResultList(); > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("isNotNull test failed"); > > } > > } > > > /* > * @testName: equal > * @assertion_ids: > * > * @test_Strategy: Use equal and not > * Select Distinct o FROM Order o where o.customer.name <> 'Robert E. Bissett' > * > */ > public void equal() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Order> cquery = cbuilder.createQuery(Order.class); > if (cquery != null) { > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > EntityType<Customer> Customer_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer.class); > cquery.select(order); > cquery.where(cbuilder.not(cbuilder.equal( > order.get(Order_.getSingularAttribute("customer", Customer.class)).get(Customer_.getSingularAttribute("name", String.class)), "Robert E. Bissett"))); > > cquery.distinct(true); > > TypedQuery<Order> tq = em.createQuery(cquery); > > List<Order> result = tq.getResultList(); > int expectedResultSize = 17; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("equal test failed"); > > } > } > > /* > * @testName: notEqual > * @assertion_ids: > * > * @test_Strategy: Use notEqual > * Select Distinct o FROM Order o where o.customer.name <> 'Robert E. Bissett' > * > */ > public void notEqual() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Order> cquery = cbuilder.createQuery(Order.class); > if (cquery != null) { > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > EntityType<Customer> Customer_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Customer.class); > cquery.select(order); > cquery.where(cbuilder.notEqual( > order.get(Order_.getSingularAttribute("customer", Customer.class)).get(Customer_.getSingularAttribute("name", String.class)), "Robert E. Bissett")); > > cquery.distinct(true); > > TypedQuery<Order> tq = em.createQuery(cquery); > > List<Order> result = tq.getResultList(); > int expectedResultSize = 17; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("notEqual test failed"); > > } > } > > /* > * @testName: greaterThan > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct a From Alias a WHERE LENGTH(a.alias) > 4 > * > */ > public void greaterThan() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Alias> cquery = cbuilder.createQuery(Alias.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > //Get Metamodel from Root > EntityType<Alias> Alias_ = alias.getModel(); > cquery.select(alias); > cquery.where(cbuilder.greaterThan( > cbuilder.length(alias.get(Alias_.getSingularAttribute("alias", String.class))), > 4)); > > cquery.distinct(true); > > TypedQuery<Alias> tq = em.createQuery(cquery); > > List<Alias> result = tq.getResultList(); > int expectedResultSize = 7; // Need to fix this once the API works > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("greaterThan test failed"); > > } > } > > /* > * @testName: greaterThanOrEqualTo > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct a From Alias a WHERE LENGTH(a.alias) >= 4 > * > */ > public void greaterThanOrEqualTo() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Alias> cquery = cbuilder.createQuery(Alias.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > //Get Metamodel from Root > EntityType<Alias> Alias_ = alias.getModel(); > cquery.select(alias); > cquery.where(cbuilder.greaterThanOrEqualTo( > cbuilder.length(alias.get(Alias_.getSingularAttribute("alias", String.class))), > 4)); > > cquery.distinct(true); > > TypedQuery<Alias> tq = em.createQuery(cquery); > > List<Alias> result = tq.getResultList(); > int expectedResultSize = 13; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("greaterThanOrEqualTo test failed"); > > } > } > > > /* > * @testName: lessThan > * @assertion_ids: > * > * @test_Strategy: > > * Select p From Product p WHERE p.quantity < 50 > * > */ > public void lessThan() throws Fault { > final int expectedResultSize = 20; > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cb = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > > CriteriaQuery<Product> cquery = cb.createQuery(Product.class); > if (cquery != null) { > > Root<Product> prod = cquery.from(Product.class); > > //Get Metamodel from Root > EntityType<Product> Product_ = prod.getModel(); > cquery.where(cb.lessThan( > prod.get(Product_.getSingularAttribute("quantity", Integer.class)), 50)); > cquery.select(prod); > > TypedQuery<Product> tq = em.createQuery(cquery); > List<Product> result = tq.getResultList(); > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Product"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("lessThan test failed"); > > } > } > > > /* > * @testName: lessThanOrEqualTo > * @assertion_ids: > * > * @test_Strategy: > * Select p From Product p WHERE p.quantity <= 50 > * > */ > public void lessThanOrEqualTo() throws Fault { > final int expectedResultSize = 22; > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cb = em.getCriteriaBuilder(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Product> cquery = cb.createQuery(Product.class); > > if (cquery != null) { > Root<Product> prod = cquery.from(Product.class); > > //Get Metamodel from Root > EntityType<Product> Product_ = prod.getModel(); > cquery.where(cb.lessThanOrEqualTo( > prod.get(Product_.getSingularAttribute("quantity", Integer.class)), 50)); > cquery.select(prod); > > TypedQuery<Product> tq = em.createQuery(cquery); > List<Product> result = tq.getResultList(); > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Product"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("lessThanOrEqualTo test failed"); > > } > } > > /* > * @testName: between > * @assertion_ids: > * > * @test_Strategy: > * SELECT p From Product p where p.shelfLife.soldDate BETWEEN :date1 AND :date6 > */ > public void between() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > Date date1 = getShelfDate(2000, 2, 14); > Date date6 = getShelfDate(2005, 2, 18); > > CriteriaQuery<Product> cquery = cbuilder.createQuery(Product.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = product.getModel(); > EmbeddableType<ShelfLife> ShelfLife_ = mm.embeddable(ShelfLife.class); > > cquery.select(product); > > cquery.where(cbuilder.between( > product.get(Product_.getSingularAttribute("shelfLife", ShelfLife.class)). > get(ShelfLife_.getSingularAttribute("soldDate", Date.class)), > cbuilder.parameter(Date.class, "date1"), > cbuilder.parameter(Date.class, "date6"))); > > cquery.distinct(true); > > TypedQuery<Product> tq = em.createQuery(cquery); > tq.setParameter("date1", date1); > tq.setParameter("date6", date6); > > List<Product> result = tq.getResultList(); > int expectedSize = 4; > > if (result.size() == expectedSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("exists test returned:" + result.size() + "expected: " + expectedSize); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("between test failed"); > } > } > > > /* > * @testName: gt > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct a From Alias a WHERE LENGTH(a.alias) > 4 > * > */ > public void gt() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Alias> cquery = cbuilder.createQuery(Alias.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > //Get Metamodel from Root > EntityType<Alias> Alias_ = alias.getModel(); > cquery.select(alias); > cquery.where(cbuilder.gt( > cbuilder.length(alias.get(Alias_.getSingularAttribute("alias", String.class))), > 4)); > > cquery.distinct(true); > > TypedQuery<Alias> tq = em.createQuery(cquery); > > List<Alias> result = tq.getResultList(); > int expectedResultSize = 7; // Need to fix this once the API works > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("gt test failed"); > > } > } > > /* > * @testName: ge > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct a From Alias a WHERE LENGTH(a.alias) >= 4 > * > */ > public void ge() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Alias> cquery = cbuilder.createQuery(Alias.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > //Get Metamodel from Root > EntityType<Alias> Alias_ = alias.getModel(); > cquery.select(alias); > cquery.where(cbuilder.ge( > cbuilder.length(alias.get(Alias_.getSingularAttribute("alias", String.class))), > 4)); > > cquery.distinct(true); > > TypedQuery<Alias> tq = em.createQuery(cquery); > > List<Alias> result = tq.getResultList(); > int expectedResultSize = 13; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("ge test failed"); > > } > } > > > /* > * @testName: lt > * @assertion_ids: > * > * @test_Strategy: > * Select p From Product p WHERE p.quantity < 50 > * > */ > public void lt() throws Fault { > final int expectedResultSize = 20; > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cb = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > > CriteriaQuery<Product> cquery = cb.createQuery(Product.class); > if (cquery != null) { > > Root<Product> prod = cquery.from(Product.class); > > //Get Metamodel from Root > EntityType<Product> Product_ = prod.getModel(); > cquery.where(cb.lt( > prod.get(Product_.getSingularAttribute("quantity", Integer.class)), 50)); > cquery.select(prod); > > TypedQuery<Product> tq = em.createQuery(cquery); > List<Product> result = tq.getResultList(); > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Product"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("le test failed"); > > } > } > > > > /* > * @testName: le > * @assertion_ids: > * > * @test_Strategy: > * Select p From Product p WHERE p.quantity <= 50 > * > */ > public void le() throws Fault { > final int expectedResultSize = 22; > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > > CriteriaQuery<Product> cquery = cbuilder.createQuery(Product.class); > if (cquery != null) { > > Root<Product> prod = cquery.from(Product.class); > > //Get Metamodel from Root > EntityType<Product> Product_ = prod.getModel(); > cquery.where(cbuilder.le( > prod.get(Product_.getSingularAttribute("quantity", Integer.class)), 50)); > cquery.select(prod); > > TypedQuery<Product> tq = em.createQuery(cquery); > List<Product> result = tq.getResultList(); > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Product"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("le test failed"); > > } > } > > /* > * @testName: neg > * @assertion_ids: > * > * @test_Strategy: > * SELECT NEG(p.quantity) From Product p where p.quantity = 5 > */ > public void neg() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Integer> cquery = cbuilder.createQuery(Integer.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.neg(product.get(Product_.getSingularAttribute("quantity", Integer.class)))); > > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 5)); > > > TypedQuery<Integer> tq = em.createQuery(cquery); > > > Integer result = tq.getSingleResult(); > Integer expectedResult = new Integer(-5); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("neg test failed"); > } > > } > > > /* > * @testName: abs > * @assertion_ids: > * > * @test_Strategy: > * Select DISTINCT o From Order o WHERE :dbl < ABS(- o.totalPrice) > * > * Note :dbl = 1180D > * > */ > public void abs() throws Fault { > boolean pass = false; > double expectedTotalPrice = 1180D; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Order> cquery = cbuilder.createQuery(Order.class); > if (cquery != null) { > Root<Order> order = cquery.from(Order.class); > > //Get Metamodel from Root > EntityType<Order> Order_ = order.getModel(); > cquery.select(order); > cquery.where( > cbuilder.lt(cbuilder.parameter(Double.class, "dbl"), cbuilder.abs(cbuilder.neg(order.get(Order_.getSingularAttribute("totalPrice", Double.class)))))); > > cquery.distinct(true); > > TypedQuery<Order> tq = em.createQuery(cquery); > tq.setParameter("dbl", new Double(1180D)); > > List<Order> result = tq.getResultList(); > int expectedResultSize = 9; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Order"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("abs test failed"); > > } > } > > > /* > * @testName: prod > * @assertion_ids: > * > * @test_Strategy: > * SELECT p.quantity *10 From Product p where p.quantity = 5 > */ > public void prod() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Integer> cquery = cbuilder.createQuery(Integer.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.prod(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 10)); > > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 5)); > > > TypedQuery<Integer> tq = em.createQuery(cquery); > > > Integer result = tq.getSingleResult(); > Integer expectedResult = new Integer(50); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("prod test failed"); > } > } > > > /* > * @testName: diff > * @assertion_ids: > * > * @test_Strategy: > * SELECT DIFF(p.quantity, 2) From Product p where p.quantity=5 > */ > public void diff() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Integer> cquery = cbuilder.createQuery(Integer.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.diff( > product.get(Product_.getSingularAttribute("quantity", Integer.class)), > 2)); > > cquery.where(cbuilder.equal( > product.get(Product_.getSingularAttribute("quantity", Integer.class)), > 5)); > > > TypedQuery<Integer> tq = em.createQuery(cquery); > > > Integer result = tq.getSingleResult(); > Integer expectedResult = new Integer(3); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("diff test failed"); > } > } > > /* > * @testName: quot > * @assertion_ids: > * > * @test_Strategy: > * SELECT QUOT(p.quantity, 2) From Product p where p.quantity = 5 > */ > public void quot() throws Fault { > final Integer expectedResult = new Integer(2); > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cb = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Number> cquery = cb.createQuery(Number.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(Product.class); > > cquery.select(cb.quot(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 2)); > cquery.where(cb.equal( > product.get(Product_.getSingularAttribute("quantity", Integer.class)), > 5)); > > TypedQuery<Number> tq = em.createQuery(cquery); > Number result = tq.getSingleResult(); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("quot test failed"); > } > } > > /* > * @testName: mod > * @assertion_ids: > * > * @test_Strategy: > * Select DISTINCT Object(p) From Product p > * where MOD(550, 100) = p.quantity > */ > public void mod() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Product> cquery = cbuilder.createQuery(Product.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.where(cbuilder.equal(cbuilder.mod(cbuilder.literal(550), 100), product.get(Product_.getSingularAttribute("quantity", Integer.class)))); > cquery.select(product).distinct(true); > > > TypedQuery<Product> tq = em.createQuery(cquery); > > List<Product> result = tq.getResultList(); > int expectedResultSize = 2; > > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.size() + "expected: " + expectedResultSize); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("mod test failed"); > } > } > > /* > * @testName: sqrt > * @assertion_ids: > * > * @test_Strategy: > * SELECT SQRT(p.quantity) From Product p where p.quantity = 5 > */ > public void sqrt() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Double> cquery = cbuilder.createQuery(Double.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.sqrt(product.get(Product_.getSingularAttribute("quantity", Integer.class)))); > > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("quantity", Integer.class)), > 5)); > > TypedQuery<Double> tq = em.createQuery(cquery); > Double result = tq.getSingleResult(); > Double expectedResult = new Double(2.1); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > //TLogger.log("test returned:" + result.doubleValue() + "expected: " + expectedResult.doubleValue()); > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("sqrt test failed"); > } > } > > > /* > * @testName: toLong > * @assertion_ids: > * > * @test_Strategy: > * SELECT toLong(p.quantity * 5L) From Product p where p.quantity = 5 > */ > public void toLong() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Long> cquery = cbuilder.createQuery(Long.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.toLong(cbuilder.prod(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 5L))); > > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 5)); > > > TypedQuery<Long> tq = em.createQuery(cquery); > > Long result = tq.getSingleResult(); > Long expectedResult = new Long(25); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("toLong test failed"); > } > } > > /* > * @testName: toInteger > * @assertion_ids: > * > * @test_Strategy: > * SELECT toInteger(p.quantity) From Product p where p.partNumber = 373767373 > */ > public void toInteger() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Integer> cquery = cbuilder.createQuery(Integer.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.toInteger(product.get(Product_.getSingularAttribute("quantity", Integer.class)))); > > cquery.where(cbuilder.equal( > product.get(Product_.getSingularAttribute("partNumber", Long.class)), > 373767373)); > > TypedQuery<Integer> tq = em.createQuery(cquery); > > > Integer result = tq.getSingleResult(); > Integer expectedResult = new Integer(5); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("toInteger test failed"); > } > } > > /* > * @testName: toFloat > * @assertion_ids: > * > * @test_Strategy: > * SELECT p.quantity *1/2 From Product p where p.quantity = 5 > */ > public void toFloat() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Float> cquery = cbuilder.createQuery(Float.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.toFloat(cbuilder.prod(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 0.5f ))); > > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 5)); > > > TypedQuery<Float> tq = em.createQuery(cquery); > > > Float result = tq.getSingleResult(); > Float expectedResult = new Float(2.5); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("toFloat test failed"); > } > > } > > /* > * @testName: toDouble > * @assertion_ids: > * > * @test_Strategy: > * SELECT toDouble(SQRT(p.quantity)) From Product p where p.quantity = 5 > */ > public void toDouble() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Double> cquery = cbuilder.createQuery(Double.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.toDouble(cbuilder.sqrt(product.get(Product_.getSingularAttribute("quantity", Integer.class))))); > > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("quantity", Integer.class)), > 5)); > > TypedQuery<Double> tq = em.createQuery(cquery); > Double result = tq.getSingleResult(); > Double expectedResult = new Double(2.1); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("toDouble test failed"); > } > } > > /* > * @testName: toBigDecimal > * @assertion_ids: > * > * @test_Strategy: > * SELECT ToBigDecimal(p.quantity * BIGDECIMAL) From Product p where p.quantity = 5 > */ > public void toBigDecimal() throws Fault { > final BigDecimal expectedResult = new BigDecimal("50.5"); > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<BigDecimal> cquery = cbuilder.createQuery(BigDecimal.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.toBigDecimal(cbuilder.prod(product.get(Product_.getSingularAttribute("quantity", Integer.class)), new BigDecimal("10.1")))); > > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 5)); > > > TypedQuery<BigDecimal> tq = em.createQuery(cquery); > > BigDecimal result = tq.getSingleResult(); > > if (result.compareTo(expectedResult) == 0) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result + "expected: " + expectedResult); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("toBigDecimal test failed"); > } > } > > /* > * @testName: toBigInteger > * @assertion_ids: > * > * @test_Strategy: > * SELECT toBigInteger(p.quantity * BigInteger("10000000000")) From Product p where p.quantity = 5 > */ > public void toBigInteger() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<BigInteger> cquery = cbuilder.createQuery(BigInteger.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(cbuilder.toBigInteger(cbuilder.prod(product.get(Product_.getSingularAttribute("quantity", Integer.class)), new BigInteger("10000000000")))); > > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("quantity", Integer.class)), 5)); > > TypedQuery<BigInteger> tq = em.createQuery(cquery); > > > BigInteger result = tq.getSingleResult(); > BigInteger expectedResult = new BigInteger("50000000000"); > > if (result.compareTo(expectedResult) == 0) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result + "expected: " + expectedResult); > } > > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("toBigInteger test failed"); > } > } > > /* > * @testName: toStringTest > * @assertion_ids: > * > * @test_Strategy: > * SELECT ToString(p.id) From Product p where p.id ='1' > */ > public void toStringTest() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<String> cquery = cbuilder.createQuery(String.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > cquery.select(cbuilder.toString(cbuilder.literal('a'))); > > cquery.where(cbuilder.equal( > product.get(Product_.getSingularAttribute("id", String.class)), > "1")); > > TypedQuery<String> tq = em.createQuery(cquery); > > String result = tq.getSingleResult(); > String expectedResult = "a"; > > if (result.equals(expectedResult)) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result + "expected: " + expectedResult); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("toStringTest test failed"); > } > } > > /* > * @testName: literal > * @assertion_ids: > * > * @test_Strategy: > * SELECT p.quantity From Product p where 5 = p.quantity > */ > public void literal() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Integer> cquery = cbuilder.createQuery(Integer.class); > if (cquery != null) { > > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Product.class); > > > cquery.select(product.get(Product_.getSingularAttribute("quantity", Integer.class))); > > > cquery.where( > cbuilder.equal(cbuilder.literal(5), product.get(Product_.getSingularAttribute("quantity", Integer.class)))); > > > TypedQuery<Integer> tq = em.createQuery(cquery); > > > Integer result = tq.getSingleResult(); > Integer expectedResult = new Integer(5); > > if (result.intValue() == expectedResult.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedResult.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("literal test failed"); > } > } > > > /* > * @testName: parameter > * @assertion_ids: > * > * @test_Strategy: > * SELECT Distinct c from Customer c WHERE c.home.street = :street OR > * c.home.city = :city OR c.home.state = :state OR > * c.home.zip = :zip > * > * where :street = '47 Skyline Drive' > * :city ='Chelmsford' > * :state ='VT' > * :zip = '02155' > * > * > */ > public void parameter() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > EntityType<Address> Address_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Address.class); > > > ParameterExpression<String> param1 = cbuilder.parameter(String.class, "streetParam"); > ParameterExpression<String> param2 = cbuilder.parameter(String.class, "cityParam"); > ParameterExpression<String> param3 = cbuilder.parameter(String.class, "stateParam"); > ParameterExpression<String> param4 = cbuilder.parameter(String.class, "zipParam"); > > cquery.select(customer); > cquery.where(cbuilder.or( > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("street", String.class)), param1), > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("city", String.class)), param2), > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("state", String.class)), param3), > cbuilder.equal(customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("zip", String.class)), param4))); > cquery.distinct(true); > > TypedQuery<Customer> tq = em.createQuery(cquery); > > tq.setParameter("streetParam", "47 Skyline Drive"); > tq.setParameter("cityParam", "Chelmsford"); > tq.setParameter("stateParam", "VT"); > tq.setParameter("zipParam", "02155"); > > List<Customer> result = tq.getResultList(); > int expectedResultSize = 4; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("parameter test failed"); > > } > } > > /* > * @testName: isEmpty > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct c fRoM Customer c where c.aliases IS EMPTY > */ > public void isEmpty() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > > Root<Customer> customer = cquery.from(Customer.class); > EntityType<Customer> Customer_ = customer.getModel(); > > cquery.where(cbuilder.isEmpty(customer.<Set<String>>get("aliases"))); > cquery.select(customer).distinct(true); > > TypedQuery<Customer> tq = em.createQuery(cquery); > List<Customer> result = tq.getResultList(); > int expectedSize = 7; > > if (result.size() == expectedSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.size() + "expected: " + expectedSize); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("isEmpty test failed"); > } > } > > /* > * @testName: isNotEmpty > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct c fRoM Customer c where c.aliases IS NOT EMPTY > */ > public void isNotEmpty() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > > Root<Customer> customer = cquery.from(Customer.class); > cquery.where(cbuilder.isNotEmpty(customer.<Set<String>>get("aliases"))); > cquery.select(customer).distinct(true); > > TypedQuery<Customer> tq = em.createQuery(cquery); > List<Customer> result = tq.getResultList(); > int expectedSize = 13; > > if (result.size() == expectedSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.size() + "expected: " + expectedSize); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("isNotEmpty test failed"); > } > } > > /* > * @testName: size > * @assertion_ids: > * > * @test_Strategy: > * Select size(c.aliases) fRoM Customer c where c.id ="3" > */ > public void size() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Integer> cquery = cbuilder.createQuery(Integer.class); > if (cquery != null) { > > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > > cquery.select(cbuilder.size(customer.<Collection<Alias>>get("aliases"))); > cquery.where(cbuilder.equal(customer.get("name"), "Alan E. Frechette")); > > TypedQuery<Integer> tq = em.createQuery(cquery); > Integer result = tq.getSingleResult(); > Integer expectedSize = 4; > > if (result.intValue() == expectedSize.intValue()) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.intValue() + "expected: " + expectedSize.intValue()); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("size test failed"); > } > } > > /* > * @testName: isMember > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct a FROM Alias a WHERE a.customerNoop MEMBER OF a.customersNoop > * > */ > public void isMember() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Alias> cquery = cbuilder.createQuery(Alias.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > cquery.where(cbuilder.isMember(alias.<Customer>get("customerNoop"), alias.<Collection<Customer>>get("customersNoop"))); > cquery.select(alias).distinct(true); > > TypedQuery<Alias> tq = em.createQuery(cquery); > > List<Alias> result = tq.getResultList(); > int expectedResultSize = 0; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("isMember test failed"); > > } > } > > /* > * @testName: isNotMember > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct a FROM Alias a WHERE a.customerNoop NOT MEMBER OF a.customersNoop > * > */ > public void isNotMember() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Alias> cquery = cbuilder.createQuery(Alias.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > //Get Metamodel from Root > EntityType<Alias> Alias_ = alias.getModel(); > > cquery.where(cbuilder.isNotMember(alias.<Customer>get("customerNoop"), alias.<Collection<Customer>>get("customersNoop"))); > > //cquery.where(cbuilder.not(cbuilder.isMember( > //alias.get(Alias_.getSingularAttribute("customerNoop", Customer.class)), > //Alias_.getCollection("customersNoop", Customer.class)))); > > > cquery.distinct(true); > > TypedQuery<Alias> tq = em.createQuery(cquery); > > List<Alias> result = tq.getResultList(); > int expectedResultSize = 30; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("isNotMember test failed"); > > } > > } > > /* > * @testName: like > * @assertion_ids: > * > * @test_Strategy: > * SELECT Distinct c from Customer c WHERE c.home.zip LIKE "%77" > * > * > * > */ > public void like() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > EntityType<Address> Address_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Address.class); > > cquery.select(customer); > > cquery.where(cbuilder.like( > customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("zip", String.class)), "%77")); > > cquery.distinct(true); > > TypedQuery<Customer> tq = em.createQuery(cquery); > > > List<Customer> result = tq.getResultList(); > int expectedResultSize = 1; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("like test failed"); > > } > } > > /* > * @testName: notLike > * @assertion_ids: > * > * @test_Strategy: > * SELECT Distinct c from Customer c WHERE c.home.zip NOT LIKE "%77" > * > * > * > */ > public void notLike() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > EntityType<Address> Address_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Address.class); > > cquery.select(customer); > > cquery.where(cbuilder.notLike( > customer.get(Customer_.getSingularAttribute("home", Address.class)).get(Address_.getSingularAttribute("zip", String.class)), "%77")); > > cquery.distinct(true); > > TypedQuery<Customer> tq = em.createQuery(cquery); > > > List<Customer> result = tq.getResultList(); > int expectedResultSize = 17; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("notLike test failed"); > > } > } > > /* > * @testName: concat > * @assertion_ids: > * > * @test_Strategy: > * SELECT Distinct c from Customer c WHERE c.work.street="1 Network" CONCAT " Drive" > * > * > * > */ > public void concat() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > Root<Customer> customer = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > EntityType<Address> Address_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.Address.class); > cquery.select(customer); > > cquery.where(cbuilder.equal( > customer.get(Customer_.getSingularAttribute("work", Address.class)).get(Address_.getSingularAttribute("street", String.class)), > cbuilder.concat(cbuilder.literal("1 Network"), " Drive"))); > > cquery.distinct(true); > > TypedQuery<Customer> tq = em.createQuery(cquery); > > > List<Customer> result = tq.getResultList(); > int expectedResultSize = 18; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("concat test failed"); > > } > } > > /* > * @testName: substring > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct a From Alias a WHERE a.alias = SUBSTRING("iris", 1, 4) > * > */ > public void substring() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Alias> cquery = cbuilder.createQuery(Alias.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > //Get Metamodel from Root > EntityType<Alias> Alias_ = alias.getModel(); > > cquery.select(alias); > cquery.where(cbuilder.equal( > alias.get(Alias_.getSingularAttribute("alias", String.class)), > cbuilder.substring(cbuilder.parameter(String.class, "string1"), 1, 4))); > > cquery.distinct(true); > > TypedQuery<Alias> tq = em.createQuery(cquery); > tq.setParameter("string1", "iris"); > > List<Alias> result = tq.getResultList(); > int expectedResultSize = 1; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected Customer"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("substring test failed"); > > } > } > > /* > * @testName: trim > * @assertion_ids: > * > * @test_Strategy: > * Select trim(both from c.name) from Customer c where c.name= ' David R. Vincent ' > * > */ > public void trim() throws Fault { > boolean pass = false; > final String expectedResult = "David R. Vincent"; > EntityManager em = getEntityManager(); > CriteriaBuilder cb = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<String> cquery = cb.createQuery(String.class); > if (cquery != null) { > Root<Customer> cust = cquery.from(Customer.class); > > > //Get Metamodel from Root > EntityType<Customer> Customer_ = cust.getModel(); > > cquery.where(cb.equal( > cust.get(Customer_.getSingularAttribute("name", String.class)), > cb.literal(" David R. Vincent "))); > cquery.select(cb.trim(Trimspec.BOTH, > cust.get(Customer_.getSingularAttribute("name", String.class)))); > > > TypedQuery<String> tq = em.createQuery(cquery); > > String result = tq.getSingleResult(); > > if (result.equals(expectedResult)) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResult + " received = " + result); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("trim test failed"); > > } > } > > /* > * @testName: lower > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct lower(a.alias) From Alias a WHERE a.alias = 'Lisa M. Presley' > * > */ > public void lower() throws Fault { > final String expectedResult = "lisa m. presley"; > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cb = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<String> cquery = cb.createQuery(String.class); > if (cquery != null) { > Root<Customer> cust = cquery.from(Customer.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = cust.getModel(); > > cquery.where(cb.equal( > cust.get(Customer_.getSingularAttribute("name", String.class)), > cb.literal("Lisa M. Presley"))); > cquery.select(cb.lower( > cust.get(Customer_.getSingularAttribute("name", String.class)))); > > TypedQuery<String> tq = em.createQuery(cquery); > > String result = tq.getSingleResult(); > > if (result.equals(expectedResult)) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResult + " received = " + result); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("lower test failed"); > > } > } > > /* > * @testName: upper > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct upper(a.alias) From Alias a WHERE a.alias = 'iris' > * > */ > public void upper() throws Fault { > final String expectedResult = "IRIS"; > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cb = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<String> cquery = cb.createQuery(String.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > //Get Metamodel from Root > EntityType<Alias> Alias_ = alias.getModel(); > > cquery.where(cb.equal( > alias.get(Alias_.getSingularAttribute("alias", String.class)), > cb.literal("iris"))); > cquery.select(cb.upper(alias.get(Alias_.getSingularAttribute("alias", String.class)))); > > TypedQuery<String> tq = em.createQuery(cquery); > String result = tq.getSingleResult(); > > if (result != null & result.equals(expectedResult)) { > System.out.println("Successfully returned expected results"); > pass = true; > } else { > System.out.println("Mismatch in received results - expected = " + expectedResult + " received = " + result); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("upper test failed"); > > } > } > > /* > * @testName: length > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct a From Alias a WHERE length (a.alias) = 9 > * > */ > public void length() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Alias> cquery = cbuilder.createQuery(Alias.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > //Get Metamodel from Root > EntityType<Alias> Alias_ = alias.getModel(); > cquery.select(alias); > > cquery.where(cbuilder.equal( > cbuilder.length(alias.get(Alias_.getSingularAttribute("alias", String.class))), > 9)); > > > cquery.distinct(true); > > TypedQuery<Alias> tq = em.createQuery(cquery); > > List<Alias> result = tq.getResultList(); > int expectedResultSize = 1; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected result"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("length test failed"); > > } > } > > /* > * @testName: locate > * @assertion_ids: > * > * @test_Strategy: > * Select Distinct a from Alias a where LOCATE('ev', a.alias) = 3 > * > */ > public void locate() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Alias> cquery = cbuilder.createQuery(Alias.class); > if (cquery != null) { > Root<Alias> alias = cquery.from(Alias.class); > > //Get Metamodel from Root > EntityType<Alias> Alias_ = alias.getModel(); > cquery.select(alias); > cquery.where(cbuilder.equal(cbuilder.locate(alias.get(Alias_.getSingularAttribute("alias", String.class)), "ev"), 3)); > > cquery.distinct(true); > > TypedQuery<Alias> tq = em.createQuery(cquery); > > List<Alias> result = tq.getResultList(); > int expectedResultSize = 3; > > if (result != null) { > if (result.size() == expectedResultSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Mismatch in received results - expected = " + expectedResultSize + " received = " + result.size()); > } > } else { > TLogger.log("Missing expected result"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("locate test failed"); > > } > } > > > /* > * @testName: currentDate > * @assertion_ids: > * > * @test_Strategy: > * SELECT current_date() From Product p where p.id = "1" > */ > public void currentDate() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Date> cquery = cbuilder.createQuery(Date.class); > if (cquery != null) { > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = product.getModel(); > cquery.select(cbuilder.currentDate()); > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("id", String.class)), "1")); > > TypedQuery<Date> tq = em.createQuery(cquery); > > Date result = tq.getSingleResult(); > Date d = Date.valueOf(result.toString()); > if (d.equals(result)) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Didnt get the expected Date object"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("currentDate test failed"); > } > } > > > /* > * @testName: currentTime > * @assertion_ids: > * > * @test_Strategy: > * SELECT current_time() From Product p where p.id = "1" > */ > public void currentTime() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Time> cquery = cbuilder.createQuery(Time.class); > if (cquery != null) { > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = product.getModel(); > cquery.select(cbuilder.currentTime()); > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("id", String.class)), "1")); > > TypedQuery<Time> tq = em.createQuery(cquery); > > Time result = tq.getSingleResult(); > Time ts = new Time(result.getTime()); > if ( result.equals(ts)) { > > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Didnt get the expected Time object"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("currentTimes test failed"); > } > } > > /* > * @testName: currentTimestamp > * @assertion_ids: > * > * @test_Strategy: > * SELECT current_timestamp() From Product p where p.id = "1" > */ > public void currentTimestamp() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Timestamp> cquery = cbuilder.createQuery(Timestamp.class); > if (cquery != null) { > Root<Product> product = cquery.from(Product.class); > EntityType<Product> Product_ = product.getModel(); > cquery.select(cbuilder.currentTimestamp()); > cquery.where(cbuilder.equal(product.get(Product_.getSingularAttribute("id", String.class)), "1")); > > TypedQuery<Timestamp> tq = em.createQuery(cquery); > > Timestamp result = tq.getSingleResult(); > Timestamp ts = Timestamp.valueOf(result.toString()); > if (ts.equals(result)) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("Didnt get the expected Timestamp object"); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault("currentTimestamp test failed"); > } > } > > /* > * @testName: in > * @assertion_ids: > * > * @test_Strategy: > * Select c fRoM Customer c, IN(c.creditCards) a where a.type ="AXP" > */ > public void in() throws Fault { > boolean pass = false; > EntityManager em = getEntityManager(); > CriteriaBuilder cbuilder = em.getCriteriaBuilder(); > Metamodel mm = em.getMetamodel(); > > EntityTransaction et = getEntityTransaction(); > > et.begin(); > CriteriaQuery<Customer> cquery = cbuilder.createQuery(Customer.class); > if (cquery != null) { > > Root<Customer> customer = cquery.from(Customer.class); > EntityType<CreditCard> CreditCard_ = mm.entity(com.sun.ts.tests.ejb30.persistence.criteriaapi.util.CreditCard.class); > > //Get Metamodel from Root > EntityType<Customer> Customer_ = customer.getModel(); > Join<Customer, CreditCard> creditCard = customer.join(Customer_.getCollection("creditCards", CreditCard.class)); > cquery.select(customer); > cquery.where(cbuilder.equal(creditCard.get(CreditCard_.getSingularAttribute("type", String.class)), "AXP")); > > TypedQuery<Customer> tq = em.createQuery(cquery); > List<Customer> result = tq.getResultList(); > int expectedSize = 7; > > if (result.size() == expectedSize) { > TLogger.log("Successfully returned expected results"); > pass = true; > } else { > TLogger.log("test returned:" + result.size() + "expected: " + expectedSize); > } > > } else { > TLogger.log("Failed to get Non-null Criteria Query"); > } > > et.commit(); > > if (!pass) { > throw new Fault(" in test failed"); > } > } > > > public void cleanup() throws Fault { > > TLogger.log("In cleanup"); > > RemoveSchemaData(); > TLogger.log("Done cleanup, calling super.cleanup"); > super.cleanup(); > } > /* > * > * Setup for Query Language Tests > * > */ > > public void schema30Setup(Properties p) throws Exception { > TLogger.log("Entering Schema 3.0 Setup"); > try { > > props = p; > > TLogger.log("Create Schema Data"); > createSchemaData(p); > > TLogger.log("Set Relationships"); > createRelationships(); > > } catch (Exception e) { > if (getEntityTransaction().isActive()) { > getEntityTransaction().rollback(); > } > RemoveSchemaData(); > e.printStackTrace(); > throw new Exception("Exception occurred in Schema 3.0 setup: " + e); > } finally { > try { > if (getEntityTransaction().isActive()) { > getEntityTransaction().rollback(); > } > } catch (Exception re) { > TLogger.log("Unexpection Exception in schema30Setup:" + re); > re.printStackTrace(); > } > } > } > > private boolean SchemaAlreadyExists() throws Exception { > > getEntityTransaction().begin(); > TLogger.log("SchemaAlreadyExists"); > > boolean schemaExists = true; > > TLogger.log("Invoke findAllCustomers"); > custCol = getEntityManager().createQuery( > "Select DISTINCT Object(c) From Customer c").setMaxResults(NUMOFCUSTOMERS).getResultList(); > > TLogger.log("Invoke findAllProducts"); > prodCol = getEntityManager().createQuery( > "Select DISTINCT Object(p) From Product p").setMaxResults(NUMOFALLPRODUCTS).getResultList(); > > TLogger.log("Invoke findAllOrders"); > orderCol = getEntityManager().createQuery( > "Select DISTINCT Object(o) From Order o").setMaxResults(NUMOFORDERS).getResultList(); > > TLogger.log("Invoke findAllAliases"); > aliasCol = getEntityManager().createQuery( > "Select DISTINCT Object(a) From Alias a").setMaxResults(NUMOFALIASES).getResultList(); > > if (custCol.size() != NUMOFCUSTOMERS || > prodCol.size() != NUMOFALLPRODUCTS || > orderCol.size() != NUMOFORDERS || > aliasCol.size() != NUMOFALIASES) { > TLogger.log("Number of customers found = " + custCol.size()); > TLogger.log("Number of products found = " + prodCol.size()); > TLogger.log("Number of orders found = " + orderCol.size()); > TLogger.log("Number of aliases found = " + aliasCol.size()); > schemaExists = false; > } > > getEntityTransaction().commit(); > > if (schemaExists) { > TLogger.log("Schema already exists in Persistent Storage"); > return true; > } else { > TLogger.log("Schema does not exist in Persistent Storage"); > RemoveSchemaData(); > return false; > } > } > > private void RemoveSchemaData() { > TLogger.log("RemoveSchemaData"); > if (getEntityTransaction().isActive()) { > getEntityTransaction().rollback(); > } > EntityManager em = getEntityManager(); > EntityTransaction et = getEntityTransaction(); > > try { > et.begin(); > > em.createNativeQuery("DELETE FROM FKS_ANOOP_CNOOP").executeUpdate(); > em.createNativeQuery("DELETE FROM FKS_ALIAS_CUSTOMER").executeUpdate(); > em.createNativeQuery("DELETE FROM ALIAS_TABLE").executeUpdate(); > em.createNativeQuery("DELETE FROM CREDITCARD_TABLE").executeUpdate(); > em.createNativeQuery("DELETE FROM SPOUSE_TABLE").executeUpdate(); > em.createNativeQuery("DELETE FROM INFO_TABLE").executeUpdate(); > em.createNativeQuery("DELETE FROM PHONE_TABLE").executeUpdate(); > em.createNativeQuery("UPDATE ORDER_TABLE SET FK4_FOR_CUSTOMER_TABLE= NULL").executeUpdate(); > em.createNativeQuery("UPDATE LINEITEM_TABLE SET FK_FOR_PRODUCT_TABLE= NULL, FK1_FOR_ORDER_TABLE=NULL").executeUpdate(); > em.createNativeQuery("DELETE FROM CUSTOMER_TABLE").executeUpdate(); > em.createNativeQuery("DELETE FROM ADDRESS").executeUpdate(); > em.createNativeQuery("DELETE FROM PRODUCT_DETAILS").executeUpdate(); > em.createNativeQuery("DELETE FROM PRODUCT_TABLE").executeUpdate(); > em.createNativeQuery("DELETE FROM ORDER_TABLE").executeUpdate(); > em.createNativeQuery("DELETE FROM LINEITEM_TABLE").executeUpdate(); > > TLogger.log("Removed Created Entities"); > > et.commit(); > } catch (Exception e) { > TLogger.log("Exception encountered while removing entities:"); > e.printStackTrace(); > } finally { > try { > if (et.isActive()) { > et.rollback(); > } > } catch (Exception re) { > TLogger.log("Unexpection Exception in RemoveSchemaData:" + re); > re.printStackTrace(); > } > } > } > > > private static Date getShelfDate(int yy, int mm, int dd) { > Calendar newCal = Calendar.getInstance(); > newCal.clear(); > newCal.set(yy, mm, dd); > SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); > String sDate = sdf.format(newCal.getTime()); > TLogger.log("returning date:" + java.sql.Date.valueOf(sDate)); > return java.sql.Date.valueOf(sDate); > } > > private void doFlush() throws PersistenceException { > //TLogger.log("Entering doFlush method"); > try { > getEntityManager().flush(); > } catch (PersistenceException pe) { > pe.printStackTrace(); > throw new PersistenceException("Unexpected Exception caught while flushing: " + pe); > } > } > > private void createSchemaData(Properties p) throws Exception { > getEntityTransaction().begin(); > TLogger.log("Entered createSchemaData"); > > //TLogger.log("Create " + NUMOFCOUNTRIES + " countries"); > country[0] = new Country("United States", "USA"); > country[1] = new Country("United States", "USA"); > country[2] = new Country("United States", "USA"); > country[3] = new Country("United States", "USA"); > country[4] = new Country("United States", "USA"); > country[5] = new Country("United States", "USA"); > country[6] = new Country("United States", "USA"); > country[7] = new Country("United States", "USA"); > country[8] = new Country("United States", "USA"); > country[9] = new Country("United States", "USA"); > country[10] = new Country("England", "GBR"); > country[11] = new Country("Ireland", "IRE"); > country[12] = new Country("China", "CHA"); > country[13] = new Country("Japan", "JPN"); > country[14] = new Country("United States", "USA"); > country[15] = new Country("England", "GBR"); > country[16] = new Country("Ireland", "IRE"); > country[17] = new Country("China", "CHA"); > country[18] = new Country("China", "CHA"); > country[19] = new Country("China", "CHA"); > > > //TLogger.log("Create " + NUMOFADDRESSES + " addresses"); > address[0] = new Address( > "1", "1 Oak Road", "Bedford", "MA", "02155"); > address[1] = new Address( > "2", "1 Network Drive", "Burlington", "MA", "00252"); > > address[2] = new Address( > "3", "10 Griffin Road", "Lexington", "MA", "02277"); > address[3] = new Address( > "4", "1 Network Drive", "Burlington", "MA", "00252"); > > address[4] = new Address( > "5", "125 Moxy Lane", "Swansea", "MA", "11345"); > address[5] = new Address( > "6", "1 Network Drive", "Burlington", "MA", "11345"); > > address[6] = new Address( > "7", "2654 Brookline Avenue", "Brookline", "MA", "11678"); > address[7] = new Address( > "8", "1 Network Drive", "Burlington", "MA", "00252"); > > address[8] = new Address( > "9", "100 Forrest Drive", "Hudson", "NH", "78654"); > address[9] = new Address( > "10", "1 Network Drive", "Burlington", "MA", "00252"); > > address[10] = new Address( > "11", "200 Elliot Road", "Nashua", "NH", "65447"); > address[11] = new Address( > "12", "1 Network Drive", "Burlington", "MA", "00252"); > > address[12] = new Address( > "13", "634 Goldstar Road", "Peabody", "MA", "88444"); > address[13] = new Address( > "14", "1 Network Drive", "Burlington", "MA", "00252"); > > address[14] = new Address( > "15", "100 Forrest Drive", "Peabody", "MA", "88444"); > address[15] = new Address( > "16", "1 Network Drive", "Burlington", "MA", "00252"); > > address[16] = new Address( > "17", "18 Rosewood Avenue", null, "MA", "87653"); > address[17] = new Address( > "18", "1 Network Drive", "Burlington", "MA", "00252"); > > address[18] = new Address( > "19", null, "Belmont", "VT", "23083"); > address[19] = new Address( > "20", "1 Network Drive", "Burlington", "MA", "00252"); > > address[20] = new Address( > "21", "3212 Boston Road", "Chelmsford", "MA", "01824"); > address[21] = new Address( > "22", "1 Network Drive", "Burlington", "MA", "00252"); > > address[22] = new Address( > "23", "212 Edgewood Drive", "Claremont", "NH", "58976"); > address[23] = new Address( > "24", "1 Network Drive", "Burlington", null, "00252"); > > address[24] = new Address( > "25", "47 Skyline Drive", "Attleboro", "MA", "76656"); > address[25] = new Address( > "26", "1 Network Drive", "Burlington", "MA", null); > > address[26] = new Address( > "27", "4 Rangeway Road", "Lawrence", "RI", "53026"); > address[27] = new Address( > "28", "1 Network Drive", "Burlington", "MA", "00252"); > > address[28] = new Address( > "29", "48 Sears Street", "Boston", "MA", "02110"); > address[29] = new Address( > "30", "1 Network Drive", "Burlington", "MA", "00252"); > > address[30] = new Address( > "31", "1240 Davis Drive", "Northwood", "NH", "03260"); > address[31] = new Address( > "32", "1 Network Drive", "Burlington", "MA", "00252"); > > address[32] = new Address( > "33", "455 James Avenue", "Roslindale", "NY", "57550"); > address[33] = new Address( > "34", "1 Network Drive", "Burlington", "MA", "00252"); > > address[34] = new Address( > "35", "8 Beverly Lane", "HarwichPort", "PA", "45870"); > address[35] = new Address( > "36", "1 Network Drive", "Burlington", "MA", "00252"); > > > for (int i = 0; i < NUMOFADDRESSES; i++) { > getEntityManager().persist(address[i]); > //TLogger.log("persisted address " + address[i]); > } > //TLogger.log("persisted address entities"); > > //TLogger.log("Create " + NUMOFPHONES + " phone numbers"); > phone[0] = new Phone("1", "617", "664-8122", address[0]); > phone[1] = new Phone("2", "781", "442-8122", address[1]); > phone[2] = new Phone("3", "508", "662-7117", address[2]); > phone[3] = new Phone("4", "781", "442-4488", address[3]); > phone[4] = new Phone("5", "992", "223-8888", address[4]); > phone[5] = new Phone("6", "781", "442-1134", address[5]); > > phone[6] = new Phone("7", "442", "883-1597", address[6]); > phone[7] = new Phone("8", "781", "442-6699", address[7]); > phone[8] = new Phone("9", "603", "777-7890", address[8]); > phone[9] = new Phone("10", "781", "442-2323", address[9]); > phone[10] = new Phone("11", "603", "889-2355", address[10]); > > phone[11] = new Phone("12", "781", "442-9876", address[11]); > phone[12] = new Phone("13", "222", "767-3124", address[12]); > phone[13] = new Phone("14", "781", "442-1111", address[13]); > phone[14] = new Phone("15", "222", "767-8898", address[14]); > phone[15] = new Phone("16", "781", "442-4444", address[15]); > > phone[16] = new Phone("17", null, "564-9087", address[16]); > phone[17] = new Phone("18", "781", "442-5341", address[17]); > phone[18] = new Phone("19", null, null, address[18]); > phone[19] = new Phone("20", "781", "442-1585", address[19]); > phone[20] = new Phone("21", "207", "532-6354", address[20]); > > phone[21] = new Phone("22", "781", "442-0845", address[21]); > phone[22] = new Phone("23", "913", null, address[22]); > phone[23] = new Phone("24", "781", "442-7465", address[23]); > phone[24] = new Phone("25", "678", "663-6091", address[24]); > phone[25] = new Phone("26", "781", "442-2139", address[25]); > > phone[26] = new Phone("27", "890", "670-9138", address[26]); > phone[27] = new Phone("28", "781", "442-0230", address[27]); > phone[28] = new Phone("29", "450", "876-9087", address[28]); > phone[29] = new Phone("30", "781", "442-6766", address[29]); > phone[30] = new Phone("31", "908", "458-0980", address[30]); > > phone[31] = new Phone("32", "781", "442-6251", address[31]); > phone[32] = new Phone("33", "432", "435-0909", address[32]); > phone[33] = new Phone("34", "781", "442-8790", address[33]); > phone[34] = new Phone("35", "415", "355-9008", address[34]); > phone[35] = new Phone("36", "781", "442-2879", address[35]); > > for (int i = 0; i < NUMOFPHONES; i++) { > getEntityManager().persist(phone[i]); > //TLogger.log("persisted phone " + phone[i]); > doFlush(); > } > //TLogger.log("persisted phone entities"); > > //TLogger.log("Create " + NUMOFCREDITCARDS + " creditcards"); > creditCard[0] = new CreditCard( > "1", "1234-2567-1222-9999", "VISA", "04/02", true, (double) 5579); > creditCard[1] = new CreditCard( > "2", "3455-9876-1221-0060", "MCARD", "10/03", false, (double) 15000); > creditCard[2] = new CreditCard( > "3", "1210-1449-2200-3254", "AXP", "11/02", true, (double) 3000); > creditCard[3] = new CreditCard( > "4", "0002-1221-0078-0890", "VISA", "05/03", true, (double) 8000); > creditCard[4] = new CreditCard( > "5", "1987-5555-8733-0011", "VISA", "05/03", true, (double) 2500); > creditCard[5] = new CreditCard( > "6", "0000-0011-2200-3087", "MCARD", "11/02", true, (double) 23000); > creditCard[6] = new CreditCard( > "7", "3341-7610-8880-9910", "AXP", "10/04", true, (double) 13000); > creditCard[7] = new CreditCard( > "8", "2222-3333-4444-5555", "MCARD", "12/03", true, (double) 2000); > creditCard[8] = new CreditCard( > "9", "8888-2222-0090-1348", "AXP", "01/02", true, (double) 4500); > creditCard[9] = new CreditCard( > "10", "1762-5094-8769-3117", "VISA", "06/01", true, (double) 14000); > creditCard[10] = new CreditCard( > "11", "1234-1234-1234-9999", "MCARD", "09/03", true, (double) 7000); > creditCard[11] = new CreditCard( > "12", "9876-9876-1234-5678", "VISA", "04/04", false, (double) 1000); > creditCard[12] = new CreditCard( > "13", "7777-8888-9999-0012", "MCARD", "01/02", true, (double) 3500); > creditCard[13] = new CreditCard( > "14", "9099-8808-7718-4455", "AXP", "03/05", true, (double) 4400); > creditCard[14] = new CreditCard( > "15", "7653-7901-2397-1768", "AXP", "02/04", true, (double) 5000); > creditCard[15] = new CreditCard( > "16", "8760-8618-9263-3322", "VISA", "04/05", false, (double) 750); > creditCard[16] = new CreditCard( > "17", "9870-2309-6754-3210", "MCARD", "03/03", true, (double) 500); > creditCard[17] = new CreditCard( > "18", "8746-8754-9090-1234", "AXP", "08/04", false, (double) 1500); > creditCard[18] = new CreditCard( > "19", "8736-0980-8765-4869", "MCARD", "09/02", true, (double) 5500); > creditCard[19] = new CreditCard( > "20", "6745-0979-0970-2345", "VISA", "02/05", true, (double) 1400); > creditCard[20] = new CreditCard( > "21", "8033-5896-9901-4566", "AXP", "09/07", true, (double) 400); > creditCard[21] = new CreditCard( > "22", "4390-5671-4385-0091", "MCARD", "03/06", false, (double) 7400); > creditCard[22] = new CreditCard( > "23", "3456-0909-3434-2134", "VISA", "04/08", true, (double) 9500); > creditCard[23] = new CreditCard( > "24", "5643-2090-4569-2323", "MCARD", "01/06", false, (double) 1000); > > for (int i = 0; i < NUMOFCREDITCARDS; i++) { > getEntityManager().persist(creditCard[i]); > //TLogger.log("persisted creditCard " + creditCard[i]); > doFlush(); > } > //TLogger.log("persisted creditCard entities"); > > //TLogger.log("Create " + NUMOFLINEITEMS + " lineitems"); > lineItem[0] = new LineItem("1", 1); > lineItem[1] = new LineItem("2", 1); > lineItem[2] = new LineItem("3", 1); > lineItem[3] = new LineItem("4", 1); > lineItem[4] = new LineItem("5", 1); > lineItem[5] = new LineItem("6", 1); > lineItem[6] = new LineItem("7", 1); > lineItem[7] = new LineItem("8", 1); > lineItem[8] = new LineItem("9", 1); > lineItem[9] = new LineItem("10", 1); > lineItem[10] = new LineItem("11", 1); > lineItem[11] = new LineItem("12", 1); > lineItem[12] = new LineItem("13", 1); > lineItem[13] = new LineItem("14", 1); > lineItem[14] = new LineItem("15", 1); > lineItem[15] = new LineItem("16", 1); > lineItem[16] = new LineItem("17", 1); > lineItem[17] = new LineItem("18", 1); > lineItem[18] = new LineItem("19", 1); > lineItem[19] = new LineItem("20", 1); > lineItem[20] = new LineItem("21", 1); > lineItem[21] = new LineItem("22", 1); > lineItem[22] = new LineItem("23", 1); > lineItem[23] = new LineItem("24", 1); > lineItem[24] = new LineItem("25", 1); > lineItem[25] = new LineItem("26", 1); > lineItem[26] = new LineItem("27", 1); > lineItem[27] = new LineItem("28", 1); > lineItem[28] = new LineItem("29", 1); > lineItem[29] = new LineItem("30", 5); > lineItem[30] = new LineItem("31", 3); > lineItem[31] = new LineItem("32", 8); > lineItem[32] = new LineItem("33", 1); > lineItem[33] = new LineItem("34", 1); > lineItem[34] = new LineItem("35", 6); > lineItem[35] = new LineItem("36", 1); > lineItem[36] = new LineItem("37", 2); > lineItem[37] = new LineItem("38", 3); > lineItem[38] = new LineItem("39", 5); > lineItem[39] = new LineItem("40", 3); > lineItem[40] = new LineItem("41", 2); > lineItem[41] = new LineItem("42", 1); > lineItem[42] = new LineItem("43", 1); > lineItem[43] = new LineItem("44", 3); > lineItem[44] = new LineItem("45", 1); > lineItem[45] = new LineItem("46", 2); > lineItem[46] = new LineItem("47", 3); > lineItem[47] = new LineItem("48", 3); > lineItem[48] = new LineItem("49", 4); > lineItem[49] = new LineItem("50", 5); > lineItem[50] = new LineItem("51", 2); > lineItem[51] = new LineItem("52", 1); > lineItem[52] = new LineItem("53", 3); > lineItem[53] = new LineItem("54", 1); > lineItem[54] = new LineItem("55", 3); > lineItem[55] = new LineItem("56", 1); > > for (int i = 0; i < NUMOFLINEITEMS; i++) { > getEntityManager().persist(lineItem[i]); > //TLogger.log("persisted lineItem " + lineItem[i]); > doFlush(); > } > //TLogger.log("persisted lineItem entities"); > > //TLogger.log("Create " + NUMOFCUSTOMERS + " customers"); > customerRef[0] = new Customer( > "1", "Alan E. Frechette", > address[0], address[1], country[0]); > customerRef[1] = new Customer( > "2", "Arthur D. Frechette", > address[2], address[3], country[1]); > customerRef[2] = new Customer( > "3", "Shelly D. McGowan", > address[4], address[5], country[2]); > customerRef[3] = new Customer( > "4", "Robert E. Bissett", > address[6], address[7], country[3]); > customerRef[4] = new Customer( > "5", "Stephen S. D'Milla", > address[8], address[9], country[4]); > customerRef[5] = new Customer( > "6", "Karen R. Tegan", > address[10], address[11], country[5]); > customerRef[6] = new Customer( > "7", "Stephen J. Caruso", > address[12], address[13], country[6]); > customerRef[7] = new Customer( > "8", "Irene M. Caruso", > address[14], address[15], country[7]); > customerRef[8] = new Customer( > "9", "William P. Keaton", > address[16], address[17], country[8]); > customerRef[9] = new Customer( > "10", "Kate P. Hudson", > address[18], address[19], country[9]); > customerRef[10] = new Customer( > "11", "Jonathan K. Smith", > address[20], address[21], country[10]); > customerRef[11] = new Customer( > "12", null, > address[22], address[23], country[11]); > customerRef[12] = new Customer( > "13", "Douglas A. Donahue", > address[24], address[25], country[12]); > customerRef[13] = new Customer( > "14", "Kellie A. Sanborn", > address[26], address[27], country[13]); > customerRef[14] = new Customer( > "15", "Margaret Mills", > address[28], address[29], country[14]); > customerRef[15] = new Customer( > "16", "Sonya C. Sanders", > address[30], address[31], country[15]); > customerRef[16] = new Customer( > "17", "Jack B. Grace", > address[32], address[33], country[16]); > customerRef[17] = new Customer( > "18", "Ron F. Bender", > address[34], address[35], country[17]); > customerRef[18] = new Customer( > "19", "Lisa M. Presley", country[18]); > customerRef[19] = new Customer( > "20", " David R. Vincent ", country[19]); > > for (int i = 0; i < NUMOFCUSTOMERS; i++) { > getEntityManager().persist(customerRef[i]); > //TLogger.log("persisted customer " + customerRef[i]); > doFlush(); > } > //TLogger.log("persisted customer entities "); > > //TLogger.log("Create " + NUMOFINFODATA + " spouse info data"); > info[0] = new Info(); > info[0].setId("1"); > info[0].setStreet("634 Goldstar Road"); > info[0].setCity("Peabody"); > info[0].setState("MA"); > info[0].setZip("88444"); > info[1] = new Info(); > info[1].setId("2"); > info[1].setStreet("3212 Boston Road"); > info[1].setCity("Chelmsford"); > info[1].setState("MA"); > info[1].setZip("01824"); > info[2] = new Info(); > info[2].setId("3"); > info[2].setStreet("47 Skyline Drive"); > info[2].setCity("Attleboro"); > info[2].setState("MA"); > info[2].setZip("76656"); > info[3] = new Info(); > info[3].setId("4"); > info[3].setStreet(null); > info[3].setCity("Belmont"); > info[3].setState("VT"); > info[3].setZip("23083"); > info[4] = new Info(); > info[4].setId("5"); > info[4].setStreet("212 Edgewood Drive"); > info[4].setCity("Claremont"); > info[4].setState("NH"); > info[4].setZip("58976"); > info[5] = new Info(); > info[5].setId("6"); > info[5].setStreet("11 Richmond Lane"); > info[5].setCity("Chatham"); > info[5].setState("NJ"); > info[5].setZip("65490"); > > //TLogger.log("Create " + NUMOFSPOUSES + " spouses"); > spouse[0] = new Spouse( > "1", "Kathleen", "Jones", "Porter", > "034-58-0988", info[0], customerRef[6]); > spouse[1] = new Spouse( > "2", "Judith", "Connors", "McCall", > "074-22-6431", info[1], customerRef[10]); > spouse[2] = new Spouse( > "3", "Linda", "Kelly", "Morrison", > "501-22-5940", info[2], customerRef[12]); > spouse[3] = new Spouse( > "4", "Thomas", null, "Mullen", > "210-23-3456", info[3], customerRef[9]); > spouse[4] = new Spouse( > "5", "Mitchell", null, "Jackson", > "476-44-3349", info[4], customerRef[11]); > spouse[5] = new Spouse( > "6", "Cynthia", "White", "Allen", > "508-908-7765", info[5]); > > for (int i = 0; i < NUMOFSPOUSES; i++) { > getEntityManager().persist(spouse[i]); > //TLogger.log("persisted spouse " + spouse[i]); > doFlush(); > } > //TLogger.log("persisted spouse-info entities"); > > //TLogger.log("Create " + NUMOFPRODUCTS + " products"); > productRef[0] = new Product( > "1", "Java 2 Unleashed Programming", > (double) 54.95, 100, (long) 987654321); > productRef[1] = new Product( > "2", "Java 2 Network Programming", > (double) 37.95, 100, (long) 876543219); > productRef[2] = new Product( > "3", "CORBA Programming", > (double) 44.95, 55, (long) 765432198); > productRef[3] = new Product( > "4", "WEB Programming with JSP's & Servlet's", > (double) 33.95, 25, (long) 654321987); > productRef[4] = new Product( > "5", "Dell Laptop PC", > (double) 1095.95, 50, (long) 543219876); > productRef[5] = new Product( > "6", "Compaq Laptop PC", > (double) 995.95, 33, (long) 432198765); > productRef[6] = new Product( > "7", "Toshiba Laptop PC", > (double) 1210.95, 22, (long) 321987654); > productRef[7] = new Product( > "8", "Gateway Laptop PC", > (double) 1100.95, 11, (long) 219876543); > productRef[8] = new Product( > "9", "Free Samples", > (double) 0.00, 10, (long) 000000000); > productRef[9] = new Product( > "10", "Designing Enterprise Applications", > (double) 39.95, 500, (long) 123456789); > productRef[10] = new Product( > "11", "Complete Guide to XML", > (double) 38.85, 300, (long) 234567891); > productRef[11] = new Product( > "12", "Programming for Dummies", > (double) 24.95, 45, (long) 345678912); > productRef[12] = new Product( > "13", "Introduction to Java", > (double) 60.95, 95, (long) 456789123); > productRef[13] = new Product( > "14", "Ultra System", > (double) 5095.95, 250, (long) 567891234); > productRef[14] = new Product( > "15", "Very Best Tutorial", > (double) 25.99, 0, (long) 678912345); > productRef[15] = new Product( > "16", "Home Grown Programming Examples", > (double) 10.95, 25, (long) 789123456); > productRef[16] = new Product( > "17", "Programming in ANSI C", > (double) 23.95, 10, (long) 891234567); > productRef[17] = new Product( > "18", "Trial Software", > (double) 10.00, 75, (long) 912345678); > > for (int i = 0; i < NUMOFPRODUCTS; i++) { > getEntityManager().persist(productRef[i]); > //TLogger.log("persisted product " + productRef[i]); > doFlush(); > } > //TLogger.log("persisted product entities "); > > //TLogger.log("Create 10 ShelfLife Instances"); > shelfRef[0] = new ShelfLife(d1, null); > shelfRef[1] = new ShelfLife(d2, null); > shelfRef[2] = new ShelfLife(d3, null); > shelfRef[3] = new ShelfLife(d4, null); > shelfRef[4] = new ShelfLife(d5, null); > shelfRef[5] = new ShelfLife(null, null); > shelfRef[6] = new ShelfLife(null, d6); > shelfRef[7] = new ShelfLife(null, d7); > shelfRef[8] = new ShelfLife(d8, d9); > shelfRef[9] = new ShelfLife(null, d10); > > //TLogger.log("Create " + NUMOFHWPRODUCTS + " Hardware Products"); > hardwareRef[0] = new HardwareProduct(); > hardwareRef[0].setId("19"); > hardwareRef[0].setName("Gateway E Series"); > hardwareRef[0].setPrice((double) 600.00); > hardwareRef[0].setQuantity(25); > hardwareRef[0].setPartNumber((long) 238945678); > hardwareRef[0].setShelfLife(shelfRef[0]); > hardwareRef[0].setWareHouse("Columbia"); > hardwareRef[0].setModelNumber(2578); > getEntityManager().persist(hardwareRef[0]); > hardwareRef[1] = new HardwareProduct(); > hardwareRef[1].setId("20"); > hardwareRef[1].setName("Java Desktop Systems"); > hardwareRef[1].setPrice((double) 890.00); > hardwareRef[1].setQuantity(50); > hardwareRef[1].setPartNumber((long) 304506708); > hardwareRef[1].setModelNumber(10050); > hardwareRef[1].setWareHouse("Lowell"); > getEntityManager().persist(hardwareRef[1]); > hardwareRef[2] = new HardwareProduct(); > hardwareRef[2].setId("21"); > hardwareRef[2].setName("Dell Inspiron"); > hardwareRef[2].setPrice((double) 1100.00); > hardwareRef[2].setQuantity(5); > hardwareRef[2].setPartNumber((long) 373767373); > hardwareRef[2].setModelNumber(01100); > hardwareRef[2].setWareHouse("Richmond"); > hardwareRef[2].setShelfLife(shelfRef[1]); > getEntityManager().persist(hardwareRef[2]); > hardwareRef[3] = new HardwareProduct(); > hardwareRef[3].setId("22"); > hardwareRef[3].setName("Toshiba"); > hardwareRef[3].setPrice((double) 250.00); > hardwareRef[3].setQuantity(40); > hardwareRef[3].setPartNumber((long) 285764839); > hardwareRef[3].setModelNumber(00720); > hardwareRef[3].setWareHouse("Richmond"); > getEntityManager().persist(hardwareRef[3]); > hardwareRef[4] = new HardwareProduct(); > hardwareRef[4].setId("23"); > hardwareRef[4].setName("SunBlade"); > hardwareRef[4].setPrice((double) 450.00); > hardwareRef[4].setQuantity(80); > hardwareRef[4].setPartNumber((long) 987290102); > hardwareRef[4].setModelNumber(00150); > getEntityManager().persist(hardwareRef[4]); > hardwareRef[5] = new HardwareProduct(); > hardwareRef[5].setId("24"); > hardwareRef[5].setName("Opteron"); > hardwareRef[5].setPrice((double) 800.00); > hardwareRef[5].setQuantity(33); > hardwareRef[5].setPartNumber((long) 725109484); > hardwareRef[5].setModelNumber(00050); > hardwareRef[5].setWareHouse("Lowell"); > hardwareRef[5].setShelfLife(shelfRef[2]); > getEntityManager().persist(hardwareRef[5]); > hardwareRef[6] = new HardwareProduct(); > hardwareRef[6].setId("25"); > hardwareRef[6].setName("Sun Enterprise"); > hardwareRef[6].setPrice((double) 15000.00); > hardwareRef[6].setQuantity(100); > hardwareRef[6].setPartNumber((long) 773620626); > hardwareRef[6].setModelNumber(10000); > getEntityManager().persist(hardwareRef[6]); > hardwareRef[7] = new HardwareProduct(); > hardwareRef[7].setId("26"); > hardwareRef[7].setName("Dell Dimension"); > hardwareRef[7].setPrice((double) 950.00); > hardwareRef[7].setQuantity(70); > hardwareRef[7].setPartNumber((long) 927262628); > hardwareRef[7].setModelNumber(3000); > getEntityManager().persist(hardwareRef[7]); > hardwareRef[8] = new HardwareProduct(); > hardwareRef[8].setId("27"); > hardwareRef[8].setName("Dell Dimension"); > hardwareRef[8].setPrice((double) 795.00); > hardwareRef[8].setQuantity(20); > hardwareRef[8].setPartNumber((long) 482726166); > hardwareRef[8].setModelNumber(04500); > hardwareRef[8].setShelfLife(shelfRef[3]); > hardwareRef[8].setWareHouse("Columbia"); > getEntityManager().persist(hardwareRef[8]); > hardwareRef[9] = new HardwareProduct(); > hardwareRef[9].setId("28"); > hardwareRef[9].setName("SunBlade"); > hardwareRef[9].setPrice((double) 1000.00); > hardwareRef[9].setQuantity(20); > hardwareRef[9].setPartNumber((long) 312010108); > hardwareRef[9].setModelNumber(00100); > hardwareRef[9].setShelfLife(shelfRef[4]); > getEntityManager().persist(hardwareRef[9]); > > //TLogger.log("Flush hardware products"); > doFlush(); > > //TLogger.log("Create " + NUMOFSWPRODUCTS + " Software Products"); > softwareRef[0] = new SoftwareProduct(); > softwareRef[0].setId("29"); > softwareRef[0].setName("SunOS 9"); > softwareRef[0].setPrice((double) 500.00); > softwareRef[0].setQuantity(500); > softwareRef[0].setPartNumber((long) 837373379); > softwareRef[0].setRevisionNumber((double) 1.0); > softwareRef[0].setShelfLife(shelfRef[5]); > getEntityManager().persist(softwareRef[0]); > softwareRef[1] = new SoftwareProduct(); > softwareRef[1].setId("30"); > softwareRef[1].setName("Patch 590-009"); > softwareRef[1].setPrice((double) 55.00); > softwareRef[1].setQuantity(23); > softwareRef[1].setPartNumber((long) 285764891); > softwareRef[1].setRevisionNumber((double) 1.1); > getEntityManager().persist(softwareRef[1]); > softwareRef[2] = new SoftwareProduct(); > softwareRef[2].setId("31"); > softwareRef[2].setName("NetBeans"); > softwareRef[2].setPrice((double) 35.00); > softwareRef[2].setQuantity(15); > softwareRef[2].setPartNumber((long) 174983901); > softwareRef[2].setRevisionNumber((double) 4.0); > softwareRef[2].setShelfLife(shelfRef[6]); > softwareRef[2].setWareHouse("Lowell"); > getEntityManager().persist(softwareRef[2]); > softwareRef[3] = new SoftwareProduct(); > softwareRef[3].setId("32"); > softwareRef[3].setName("J2SE"); > softwareRef[3].setPrice((double) 150.00); > softwareRef[3].setQuantity(100); > softwareRef[3].setPartNumber((long) 173479765); > softwareRef[3].setRevisionNumber((double) 5.0); > softwareRef[3].setShelfLife(shelfRef[7]); > getEntityManager().persist(softwareRef[3]); > softwareRef[4] = new SoftwareProduct(); > softwareRef[4].setId("33"); > softwareRef[4].setName("Creator"); > softwareRef[4].setPrice((double) 125.00); > softwareRef[4].setQuantity(60); > softwareRef[4].setPartNumber((long) 847651234); > softwareRef[4].setRevisionNumber((double) 4.0); > softwareRef[4].setShelfLife(shelfRef[8]); > getEntityManager().persist(softwareRef[4]); > softwareRef[5] = new SoftwareProduct(); > softwareRef[5].setId("34"); > softwareRef[5].setName("Java Programming Examples"); > softwareRef[5].setPrice((double) 175.00); > softwareRef[5].setQuantity(200); > softwareRef[5].setPartNumber((long) 376512908); > softwareRef[5].setRevisionNumber((double) 1.5); > getEntityManager().persist(softwareRef[5]); > softwareRef[6] = new SoftwareProduct(); > softwareRef[6].setId("35"); > softwareRef[6].setName("Tutorial"); > softwareRef[6].setPrice((double) 250.00); > softwareRef[6].setQuantity(35); > softwareRef[6].setPartNumber((long) 837462890); > softwareRef[6].setRevisionNumber((double) 1.4); > softwareRef[6].setWareHouse(null); > getEntityManager().persist(softwareRef[6]); > softwareRef[7] = new SoftwareProduct(); > softwareRef[7].setId("36"); > softwareRef[7].setName("Testing Tools"); > softwareRef[7].setPrice((double) 300.00); > softwareRef[7].setQuantity(20); > softwareRef[7].setPartNumber((long) 372615467); > softwareRef[7].setRevisionNumber((double) 1.0); > getEntityManager().persist(softwareRef[7]); > softwareRef[8] = new SoftwareProduct(); > softwareRef[8].setId("37"); > softwareRef[8].setName("Patch 395-478"); > softwareRef[8].setPrice((double) 55.00); > softwareRef[8].setQuantity(25); > softwareRef[8].setPartNumber((long) 847628901); > softwareRef[8].setRevisionNumber((double) 1.1); > softwareRef[8].setShelfLife(shelfRef[9]); > softwareRef[8].setWareHouse("Lowell"); > getEntityManager().persist(softwareRef[8]); > softwareRef[9] = new SoftwareProduct(); > softwareRef[9].setId("38"); > softwareRef[9].setName("Appserver 8"); > softwareRef[9].setPrice((double) 0.00); > softwareRef[9].setQuantity(150); > softwareRef[9].setPartNumber((long) 873657891); > softwareRef[9].setRevisionNumber((double) 1.1); > getEntityManager().persist(softwareRef[9]); > > //TLogger.log("Flush software products"); > doFlush(); > > //TLogger.log("Create " + NUMOFORDERS + " Orders"); > orderRef[0] = new Order("1", customerRef[0]); > orderRef[1] = new Order("2", customerRef[1]); > orderRef[2] = new Order("3", customerRef[2]); > orderRef[3] = new Order("4", customerRef[3]); > orderRef[4] = new Order("5", customerRef[4]); > orderRef[5] = new Order("6", customerRef[5]); > orderRef[6] = new Order("7", customerRef[6]); > orderRef[7] = new Order("8", customerRef[7]); > orderRef[8] = new Order("9", customerRef[3]); > orderRef[9] = new Order("10", customerRef[8]); > orderRef[10] = new Order("11", customerRef[9]); > orderRef[11] = new Order("12", customerRef[10]); > orderRef[12] = new Order("13", customerRef[11]); > orderRef[13] = new Order("14", customerRef[12]); > orderRef[14] = new Order("15", customerRef[13]); > orderRef[15] = new Order("16", customerRef[13]); > orderRef[16] = new Order("17", customerRef[14]); > orderRef[17] = new Order("18", customerRef[15]); > orderRef[18] = new Order("19"); > orderRef[19] = new Order("20"); > > for (int i = 0; i < NUMOFORDERS; i++) { > getEntityManager().persist(orderRef[i]); > //TLogger.log("persisted order " + orderRef[i]); > doFlush(); > } > //TLogger.log("persisted order entities"); > > //TLogger.log("Create " + NUMOFALIASES + " Aliases"); > aliasRef[0] = new Alias("1", "aef"); > aliasRef[1] = new Alias("2", "al"); > aliasRef[2] = new Alias("3", "fish"); > aliasRef[3] = new Alias("4", "twin"); > aliasRef[4] = new Alias("5", "adf"); > aliasRef[5] = new Alias("6", "art"); > aliasRef[6] = new Alias("7", "sdm"); > aliasRef[7] = new Alias("8", "sh_ll"); > aliasRef[8] = new Alias("9", "reb"); > aliasRef[9] = new Alias("10", "bobby"); > aliasRef[10] = new Alias("11", "bb"); > aliasRef[11] = new Alias("12", "ssd"); > aliasRef[12] = new Alias("13", "steved"); > aliasRef[13] = new Alias("14", "stevie"); > aliasRef[14] = new Alias("15", ""); > aliasRef[15] = new Alias("16", ""); > aliasRef[16] = new Alias("17", "sjc"); > aliasRef[17] = new Alias("18", "stevec"); > aliasRef[18] = new Alias("19", "imc"); > aliasRef[19] = new Alias("20", "iris"); > aliasRef[20] = new Alias("21", "bro"); > aliasRef[21] = new Alias("22", "sis"); > aliasRef[22] = new Alias("23", "kell"); > aliasRef[23] = new Alias("24", "bill"); > aliasRef[24] = new Alias("25", "suzy"); > aliasRef[25] = new Alias("26", "jon"); > aliasRef[26] = new Alias("27", "jk"); > aliasRef[27] = new Alias("28", "kellieann"); > aliasRef[28] = new Alias("29", "smitty"); > aliasRef[29] = new Alias("30", null); > > for (int i = 0; i < NUMOFALIASES; i++) { > getEntityManager().persist(aliasRef[i]); > //TLogger.log("persisted alias " + aliasRef[i]); > doFlush(); > } > //TLogger.log("persisted alias entities"); > > getEntityTransaction().commit(); > TLogger.log("Persisted Entities"); > > } > > private void createRelationships() throws Exception { > double totalPrice; > > getEntityTransaction().begin(); > //TLogger.log("Setting additional relationships for Order 1"); > lineItem[0].setProduct(productRef[0]); > lineItem[0].setOrder(orderRef[0]); > getEntityManager().merge(lineItem[0]); > > lineItem[1].setProduct(productRef[1]); > lineItem[1].setOrder(orderRef[0]); > getEntityManager().merge(lineItem[1]); > > lineItem[2].setProduct(productRef[7]); > lineItem[2].setOrder(orderRef[0]); > getEntityManager().merge(lineItem[2]); > > lineItem[28].setProduct(productRef[8]); > lineItem[28].setOrder(orderRef[0]); > getEntityManager().merge(lineItem[28]); > > orderRef[0].getLineItems().add(lineItem[0]); > orderRef[0].getLineItems().add(lineItem[1]); > orderRef[0].getLineItems().add(lineItem[2]); > orderRef[0].setSampleLineItem(lineItem[28]); > totalPrice = productRef[0].getPrice() + > productRef[1].getPrice() + productRef[7].getPrice() + > productRef[8].getPrice(); > orderRef[0].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[0]); > > creditCard[1].setOrder(orderRef[0]); > creditCard[1].setCustomer(customerRef[0]); > getEntityManager().merge(creditCard[1]); > doFlush(); > //TLogger.log("Done with Order 1 relationships"); > > //TLogger.log("Setting additional relationships for Order 2"); > lineItem[3].setProduct(productRef[0]); > lineItem[3].setOrder(orderRef[1]); > getEntityManager().merge(lineItem[3]); > > lineItem[4].setProduct(productRef[1]); > lineItem[4].setOrder(orderRef[1]); > getEntityManager().merge(lineItem[4]); > > lineItem[5].setProduct(productRef[2]); > lineItem[5].setOrder(orderRef[1]); > getEntityManager().merge(lineItem[5]); > > lineItem[6].setProduct(productRef[3]); > lineItem[6].setOrder(orderRef[1]); > getEntityManager().merge(lineItem[6]); > > lineItem[7].setProduct(productRef[4]); > lineItem[7].setOrder(orderRef[1]); > getEntityManager().merge(lineItem[7]); > > orderRef[1].getLineItems().add(lineItem[3]); > orderRef[1].getLineItems().add(lineItem[4]); > orderRef[1].getLineItems().add(lineItem[5]); > orderRef[1].getLineItems().add(lineItem[6]); > orderRef[1].getLineItems().add(lineItem[7]); > totalPrice = productRef[0].getPrice() + > productRef[1].getPrice() + productRef[2].getPrice() + > productRef[3].getPrice() + productRef[4].getPrice(); > orderRef[1].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[1]); > > creditCard[3].setOrder(orderRef[1]); > creditCard[3].setCustomer(customerRef[1]); > getEntityManager().merge(creditCard[3]); > doFlush(); > //TLogger.log("Done Setting relationships for Order 2"); > > //TLogger.log("Setting additional relationships for Order 3"); > lineItem[8].setProduct(productRef[2]); > lineItem[8].setOrder(orderRef[2]); > getEntityManager().merge(lineItem[8]); > > lineItem[9].setProduct(productRef[5]); > lineItem[9].setOrder(orderRef[2]); > getEntityManager().merge(lineItem[9]); > > orderRef[2].getLineItems().add(lineItem[8]); > orderRef[2].getLineItems().add(lineItem[9]); > totalPrice = productRef[2].getPrice() + productRef[5].getPrice(); > orderRef[2].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[2]); > > creditCard[4].setOrder(orderRef[2]); > creditCard[4].setCustomer(customerRef[2]); > getEntityManager().merge(creditCard[4]); > doFlush(); > //TLogger.log("Done Setting Relationships for Order 3"); > > //TLogger.log("Setting additional relationships for Order 4"); > lineItem[10].setProduct(productRef[6]); > lineItem[10].setOrder(orderRef[3]); > getEntityManager().merge(lineItem[10]); > > orderRef[3].getLineItems().add(lineItem[10]); > totalPrice = productRef[6].getPrice(); > orderRef[3].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[3]); > > creditCard[5].setOrder(orderRef[3]); > creditCard[5].setCustomer(customerRef[3]); > getEntityManager().merge(creditCard[5]); > doFlush(); > //TLogger.log("Done Setting Relationships for Order 4"); > > //TLogger.log("Setting additional relationships for Order 5"); > lineItem[11].setProduct(productRef[0]); > lineItem[11].setOrder(orderRef[4]); > getEntityManager().merge(lineItem[11]); > > lineItem[12].setProduct(productRef[1]); > lineItem[12].setOrder(orderRef[4]); > getEntityManager().merge(lineItem[12]); > > lineItem[13].setProduct(productRef[2]); > lineItem[13].setOrder(orderRef[4]); > getEntityManager().merge(lineItem[13]); > > lineItem[14].setProduct(productRef[3]); > lineItem[14].setOrder(orderRef[4]); > getEntityManager().merge(lineItem[14]); > > lineItem[15].setProduct(productRef[4]); > lineItem[15].setOrder(orderRef[4]); > getEntityManager().merge(lineItem[15]); > > lineItem[16].setProduct(productRef[5]); > lineItem[16].setOrder(orderRef[4]); > getEntityManager().merge(lineItem[16]); > > lineItem[17].setProduct(productRef[6]); > lineItem[17].setOrder(orderRef[4]); > getEntityManager().merge(lineItem[17]); > > lineItem[18].setProduct(productRef[7]); > lineItem[18].setOrder(orderRef[4]); > getEntityManager().merge(lineItem[18]); > > orderRef[4].getLineItems().add(lineItem[11]); > orderRef[4].getLineItems().add(lineItem[12]); > orderRef[4].getLineItems().add(lineItem[13]); > orderRef[4].getLineItems().add(lineItem[14]); > orderRef[4].getLineItems().add(lineItem[15]); > orderRef[4].getLineItems().add(lineItem[16]); > orderRef[4].getLineItems().add(lineItem[17]); > orderRef[4].getLineItems().add(lineItem[18]); > totalPrice = productRef[0].getPrice() + > productRef[1].getPrice() + productRef[2].getPrice() + > productRef[3].getPrice() + productRef[4].getPrice() + > productRef[5].getPrice() + productRef[6].getPrice() + > productRef[7].getPrice(); > orderRef[4].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[4]); > > creditCard[7].setOrder(orderRef[4]); > creditCard[7].setCustomer(customerRef[4]); > getEntityManager().merge(creditCard[7]); > doFlush(); > //TLogger.log("Done Setting Relationships for Order 5"); > > //TLogger.log("Setting additional relationships for Order 6"); > lineItem[19].setProduct(productRef[3]); > lineItem[19].setOrder(orderRef[5]); > getEntityManager().merge(lineItem[19]); > > lineItem[20].setProduct(productRef[6]); > lineItem[20].setOrder(orderRef[5]); > getEntityManager().merge(lineItem[20]); > > lineItem[29].setProduct(productRef[8]); > lineItem[29].setOrder(orderRef[5]); > getEntityManager().merge(lineItem[29]); > > orderRef[5].getLineItems().add(lineItem[19]); > orderRef[5].getLineItems().add(lineItem[20]); > orderRef[5].setSampleLineItem(lineItem[29]); > totalPrice = productRef[3].getPrice() + productRef[6].getPrice() + > productRef[8].getPrice(); > orderRef[5].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[5]); > > creditCard[10].setOrder(orderRef[5]); > creditCard[10].setCustomer(customerRef[5]); > getEntityManager().merge(creditCard[10]); > doFlush(); > //TLogger.log("Done Setting Relationships for Order 6"); > > //TLogger.log("Setting additional relationships for Order 7"); > lineItem[21].setProduct(productRef[2]); > lineItem[21].setOrder(orderRef[6]); > getEntityManager().merge(lineItem[21]); > > lineItem[22].setProduct(productRef[3]); > lineItem[22].setOrder(orderRef[6]); > getEntityManager().merge(lineItem[22]); > > lineItem[23].setProduct(productRef[7]); > lineItem[23].setOrder(orderRef[6]); > getEntityManager().merge(lineItem[23]); > > orderRef[6].getLineItems().add(lineItem[21]); > orderRef[6].getLineItems().add(lineItem[22]); > orderRef[6].getLineItems().add(lineItem[23]); > totalPrice = productRef[2].getPrice() + > productRef[3].getPrice() + productRef[7].getPrice(); > orderRef[6].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[6]); > > creditCard[11].setOrder(orderRef[6]); > creditCard[11].setCustomer(customerRef[6]); > getEntityManager().merge(creditCard[11]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 7"); > > //TLogger.log("Setting additional relationships for Order 8"); > lineItem[24].setProduct(productRef[0]); > lineItem[24].setOrder(orderRef[7]); > getEntityManager().merge(lineItem[24]); > > lineItem[25].setProduct(productRef[4]); > lineItem[25].setOrder(orderRef[7]); > getEntityManager().merge(lineItem[25]); > > orderRef[7].getLineItems().add(lineItem[24]); > orderRef[7].getLineItems().add(lineItem[25]); > totalPrice = productRef[0].getPrice() + productRef[4].getPrice(); > orderRef[7].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[7]); > > creditCard[13].setOrder(orderRef[7]); > creditCard[13].setCustomer(customerRef[7]); > getEntityManager().merge(creditCard[13]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 8"); > > //TLogger.log("Setting additional relationships for Order 9"); > lineItem[26].setProduct(productRef[0]); > lineItem[26].setOrder(orderRef[8]); > getEntityManager().merge(lineItem[26]); > > lineItem[27].setProduct(productRef[1]); > lineItem[27].setOrder(orderRef[8]); > getEntityManager().merge(lineItem[27]); > > orderRef[8].getLineItems().add(lineItem[26]); > orderRef[8].getLineItems().add(lineItem[27]); > totalPrice = productRef[0].getPrice() + productRef[1].getPrice(); > orderRef[8].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[8]); > > creditCard[6].setOrder(orderRef[8]); > creditCard[6].setCustomer(customerRef[3]); > getEntityManager().merge(creditCard[6]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 9"); > > > //TLogger.log("Setting additional relationships for Order 10"); > lineItem[30].setProduct(productRef[9]); > lineItem[30].setOrder(orderRef[9]); > getEntityManager().merge(lineItem[30]); > > lineItem[31].setProduct(productRef[16]); > lineItem[31].setOrder(orderRef[9]); > getEntityManager().merge(lineItem[31]); > > orderRef[9].getLineItems().add(lineItem[30]); > orderRef[9].getLineItems().add(lineItem[31]); > totalPrice = productRef[9].getPrice() + productRef[16].getPrice(); > orderRef[9].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[9]); > > creditCard[14].setOrder(orderRef[9]); > creditCard[14].setCustomer(customerRef[8]); > getEntityManager().merge(creditCard[14]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 10"); > > > //TLogger.log("Setting additional relationships for Order 11"); > lineItem[32].setProduct(productRef[13]); > lineItem[32].setOrder(orderRef[10]); > getEntityManager().merge(lineItem[32]); > > orderRef[10].getLineItems().add(lineItem[32]); > totalPrice = productRef[13].getPrice(); > orderRef[10].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[10]); > > creditCard[15].setOrder(orderRef[10]); > creditCard[15].setCustomer(customerRef[9]); > getEntityManager().merge(creditCard[15]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 11"); > > //TLogger.log("Setting additional relationships for Order 12"); > lineItem[33].setProduct(productRef[10]); > lineItem[33].setOrder(orderRef[11]); > getEntityManager().merge(lineItem[33]); > > lineItem[34].setProduct(productRef[12]); > lineItem[34].setOrder(orderRef[11]); > getEntityManager().merge(lineItem[34]); > > orderRef[11].getLineItems().add(lineItem[33]); > orderRef[11].getLineItems().add(lineItem[34]); > totalPrice = productRef[10].getPrice() + productRef[12].getPrice(); > orderRef[11].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[11]); > > creditCard[16].setOrder(orderRef[11]); > creditCard[16].setCustomer(customerRef[10]); > getEntityManager().merge(creditCard[16]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 12"); > > > //TLogger.log("Setting additional relationships for Order 13"); > lineItem[35].setProduct(productRef[17]); > lineItem[35].setOrder(orderRef[12]); > getEntityManager().merge(lineItem[35]); > > orderRef[12].getLineItems().add(lineItem[35]); > totalPrice = productRef[17].getPrice(); > orderRef[12].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[12]); > > creditCard[17].setOrder(orderRef[12]); > creditCard[17].setCustomer(customerRef[11]); > getEntityManager().merge(creditCard[17]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 13"); > > > //TLogger.log("Setting additional relationships for Order 14"); > lineItem[36].setProduct(productRef[7]); > lineItem[36].setOrder(orderRef[13]); > getEntityManager().merge(lineItem[36]); > > lineItem[37].setProduct(productRef[14]); > lineItem[37].setOrder(orderRef[13]); > getEntityManager().merge(lineItem[37]); > > lineItem[38].setProduct(productRef[15]); > lineItem[38].setOrder(orderRef[13]); > getEntityManager().merge(lineItem[38]); > > orderRef[13].getLineItems().add(lineItem[36]); > orderRef[13].getLineItems().add(lineItem[37]); > orderRef[13].getLineItems().add(lineItem[38]); > totalPrice = productRef[7].getPrice() + productRef[14].getPrice() + > productRef[15].getPrice(); > orderRef[13].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[13]); > > creditCard[18].setOrder(orderRef[13]); > creditCard[18].setCustomer(customerRef[12]); > getEntityManager().merge(creditCard[18]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 14"); > > //TLogger.log("Setting additional relationships for Order 15"); > lineItem[39].setProduct(productRef[1]); > lineItem[39].setOrder(orderRef[14]); > getEntityManager().merge(lineItem[39]); > > lineItem[40].setProduct(productRef[2]); > lineItem[40].setOrder(orderRef[14]); > getEntityManager().merge(lineItem[40]); > > lineItem[41].setProduct(productRef[12]); > lineItem[41].setOrder(orderRef[14]); > getEntityManager().merge(lineItem[41]); > > lineItem[42].setProduct(productRef[15]); > lineItem[42].setOrder(orderRef[14]); > getEntityManager().merge(lineItem[42]); > > orderRef[14].getLineItems().add(lineItem[39]); > orderRef[14].getLineItems().add(lineItem[40]); > orderRef[14].getLineItems().add(lineItem[41]); > orderRef[14].getLineItems().add(lineItem[42]); > totalPrice = productRef[1].getPrice() + productRef[2].getPrice() + > productRef[12].getPrice() + productRef[15].getPrice(); > orderRef[14].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[14]); > > creditCard[19].setOrder(orderRef[14]); > creditCard[19].setCustomer(customerRef[13]); > getEntityManager().merge(creditCard[19]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 15"); > > > //TLogger.log("Setting additional relationships for Order 16"); > lineItem[43].setProduct(productRef[13]); > lineItem[43].setOrder(orderRef[15]); > getEntityManager().merge(lineItem[43]); > > orderRef[15].getLineItems().add(lineItem[43]); > totalPrice = productRef[13].getPrice(); > orderRef[15].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[15]); > > creditCard[19].setOrder(orderRef[15]); > creditCard[19].setCustomer(customerRef[13]); > getEntityManager().merge(creditCard[19]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 16"); > > //TLogger.log("Setting additional relationships for Order 17"); > lineItem[44].setProduct(hardwareRef[0]); > lineItem[44].setOrder(orderRef[16]); > getEntityManager().merge(lineItem[44]); > > lineItem[45].setProduct(hardwareRef[1]); > lineItem[45].setOrder(orderRef[16]); > getEntityManager().merge(lineItem[45]); > > lineItem[46].setProduct(softwareRef[0]); > lineItem[46].setOrder(orderRef[16]); > getEntityManager().merge(lineItem[46]); > > orderRef[16].getLineItems().add(lineItem[44]); > orderRef[16].getLineItems().add(lineItem[45]); > orderRef[16].getLineItems().add(lineItem[46]); > totalPrice = hardwareRef[0].getPrice() + hardwareRef[1].getPrice() + > softwareRef[0].getPrice(); > orderRef[16].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[16]); > > creditCard[20].setOrder(orderRef[16]); > creditCard[20].setCustomer(customerRef[14]); > getEntityManager().merge(creditCard[20]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 17"); > > //TLogger.log("Setting additional relationships for Order 18"); > lineItem[47].setProduct(hardwareRef[2]); > lineItem[47].setOrder(orderRef[17]); > getEntityManager().merge(lineItem[47]); > > lineItem[48].setProduct(softwareRef[1]); > lineItem[48].setOrder(orderRef[17]); > getEntityManager().merge(lineItem[48]); > > lineItem[49].setProduct(hardwareRef[3]); > lineItem[49].setOrder(orderRef[17]); > getEntityManager().merge(lineItem[49]); > > lineItem[50].setProduct(softwareRef[2]); > lineItem[50].setOrder(orderRef[17]); > getEntityManager().merge(lineItem[50]); > > orderRef[17].getLineItems().add(lineItem[47]); > orderRef[17].getLineItems().add(lineItem[48]); > orderRef[17].getLineItems().add(lineItem[49]); > orderRef[17].getLineItems().add(lineItem[50]); > totalPrice = hardwareRef[2].getPrice() + hardwareRef[3].getPrice() + > softwareRef[1].getPrice() + softwareRef[2].getPrice(); > orderRef[17].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[17]); > > creditCard[21].setOrder(orderRef[17]); > creditCard[21].setCustomer(customerRef[15]); > getEntityManager().merge(creditCard[21]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 18"); > > > //TLogger.log("Setting additional relationships for Order 19"); > lineItem[51].setProduct(hardwareRef[4]); > lineItem[51].setOrder(orderRef[18]); > getEntityManager().merge(lineItem[51]); > > lineItem[52].setProduct(softwareRef[3]); > lineItem[52].setOrder(orderRef[18]); > getEntityManager().merge(lineItem[52]); > > lineItem[53].setProduct(softwareRef[4]); > lineItem[53].setOrder(orderRef[18]); > getEntityManager().merge(lineItem[53]); > > orderRef[18].getLineItems().add(lineItem[51]); > orderRef[18].getLineItems().add(lineItem[52]); > orderRef[18].getLineItems().add(lineItem[53]); > totalPrice = hardwareRef[4].getPrice() + softwareRef[3].getPrice() + > softwareRef[4].getPrice(); > orderRef[18].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[18]); > > creditCard[22].setOrder(orderRef[18]); > creditCard[22].setCustomer(customerRef[16]); > getEntityManager().merge(creditCard[22]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 19"); > > //TLogger.log("Setting additional relationships for Order 20"); > lineItem[54].setProduct(hardwareRef[5]); > lineItem[54].setOrder(orderRef[19]); > getEntityManager().merge(lineItem[54]); > > lineItem[55].setProduct(softwareRef[5]); > lineItem[55].setOrder(orderRef[19]); > getEntityManager().merge(lineItem[55]); > > orderRef[19].getLineItems().add(lineItem[54]); > orderRef[19].getLineItems().add(lineItem[55]); > totalPrice = hardwareRef[5].getPrice() + softwareRef[5].getPrice(); > orderRef[19].setTotalPrice((double) totalPrice); > getEntityManager().merge(orderRef[19]); > > creditCard[23].setOrder(orderRef[19]); > creditCard[23].setCustomer(customerRef[17]); > getEntityManager().merge(creditCard[23]); > doFlush(); > //TLogger.log("Done Setting additional relationships for Order 20"); > > > //TLogger.log("Setting additional relationships for Customer 1"); > aliasRef[0].getCustomers().add(customerRef[0]); > getEntityManager().merge(aliasRef[0]); > > aliasRef[1].getCustomers().add(customerRef[0]); > getEntityManager().merge(aliasRef[1]); > > aliasRef[2].getCustomers().add(customerRef[0]); > getEntityManager().merge(aliasRef[2]); > > aliasRef[3].getCustomers().add(customerRef[0]); > getEntityManager().merge(aliasRef[3]); > > orderRef[0].setCustomer(customerRef[0]); > getEntityManager().merge(orderRef[0]); > > creditCard[0].setCustomer(customerRef[0]); > getEntityManager().merge(creditCard[0]); > > creditCard[1].setCustomer(customerRef[0]); > getEntityManager().merge(creditCard[1]); > > creditCard[2].setCustomer(customerRef[0]); > getEntityManager().merge(creditCard[2]); > doFlush(); > > //TLogger.log("Setting additional relationships for Customer 2"); > aliasRef[2].getCustomers().add(customerRef[1]); > getEntityManager().merge(aliasRef[2]); > > aliasRef[3].getCustomers().add(customerRef[1]); > getEntityManager().merge(aliasRef[3]); > > aliasRef[4].getCustomers().add(customerRef[1]); > getEntityManager().merge(aliasRef[4]); > > aliasRef[5].getCustomers().add(customerRef[1]); > getEntityManager().merge(aliasRef[5]); > > orderRef[1].setCustomer(customerRef[1]); > getEntityManager().merge(orderRef[1]); > > creditCard[3].setCustomer(customerRef[1]); > getEntityManager().merge(creditCard[3]); > doFlush(); > > //TLogger.log("Setting additional relationships for Customer 3"); > aliasRef[6].getCustomers().add(customerRef[2]); > getEntityManager().merge(aliasRef[6]); > > aliasRef[7].getCustomers().add(customerRef[2]); > getEntityManager().merge(aliasRef[7]); > > orderRef[2].setCustomer(customerRef[2]); > getEntityManager().merge(orderRef[2]); > > creditCard[4].setCustomer(customerRef[2]); > getEntityManager().merge(creditCard[4]); > doFlush(); > > //TLogger.log("Setting additional relationships for Customer 4"); > aliasRef[8].getCustomers().add(customerRef[3]); > getEntityManager().merge(aliasRef[8]); > > aliasRef[9].getCustomers().add(customerRef[3]); > getEntityManager().merge(aliasRef[9]); > > aliasRef[10].getCustomers().add(customerRef[3]); > getEntityManager().merge(aliasRef[10]); > > orderRef[3].setCustomer(customerRef[3]); > getEntityManager().merge(orderRef[3]); > > creditCard[5].setCustomer(customerRef[3]); > getEntityManager().merge(creditCard[5]); > > creditCard[6].setCustomer(customerRef[3]); > getEntityManager().merge(creditCard[6]); > doFlush(); > > //TLogger.log("Setting additional relationships for Customer 5"); > aliasRef[11].getCustomers().add(customerRef[4]); > getEntityManager().merge(aliasRef[11]); > > aliasRef[12].getCustomers().add(customerRef[4]); > getEntityManager().merge(aliasRef[12]); > > aliasRef[13].getCustomers().add(customerRef[4]); > getEntityManager().merge(aliasRef[13]); > > orderRef[4].setCustomer(customerRef[4]); > getEntityManager().merge(orderRef[4]); > > creditCard[7].setCustomer(customerRef[4]); > getEntityManager().merge(creditCard[7]); > > creditCard[8].setCustomer(customerRef[4]); > getEntityManager().merge(creditCard[8]); > doFlush(); > > //TLogger.log("Setting additional relationships for Customer 6"); > // aliasRef[14] - Not Set > // aliasRef[15] - Not Set > orderRef[5].setCustomer(customerRef[5]); > getEntityManager().merge(orderRef[5]); > > creditCard[9].setCustomer(customerRef[5]); > getEntityManager().merge(creditCard[9]); > > creditCard[10].setCustomer(customerRef[5]); > getEntityManager().merge(creditCard[10]); > doFlush(); > > //TLogger.log("Setting additional relationships for Customer 7"); > aliasRef[13].getCustomers().add(customerRef[6]); > getEntityManager().merge(aliasRef[13]); > > aliasRef[16].getCustomers().add(customerRef[6]); > getEntityManager().merge(aliasRef[16]); > > aliasRef[17].getCustomers().add(customerRef[6]); > getEntityManager().merge(aliasRef[17]); > > orderRef[6].setCustomer(customerRef[6]); > getEntityManager().merge(orderRef[6]); > > creditCard[11].setCustomer(customerRef[6]); > getEntityManager().merge(creditCard[11]); > > customerRef[6].setSpouse(spouse[0]); > getEntityManager().merge(customerRef[6]); > doFlush(); > > //TLogger.log("Setting additional relationships for Customer 8"); > aliasRef[18].getCustomers().add(customerRef[7]); > getEntityManager().merge(aliasRef[18]); > > aliasRef[19].getCustomers().add(customerRef[7]); > getEntityManager().merge(aliasRef[19]); > > orderRef[7].setCustomer(customerRef[7]); > getEntityManager().merge(orderRef[7]); > > creditCard[12].setCustomer(customerRef[7]); > getEntityManager().merge(creditCard[12]); > > creditCard[13].setCustomer(customerRef[7]); > getEntityManager().merge(creditCard[13]); > doFlush(); > //TLogger.log("Setting additional relationships for Customer 9"); > aliasRef[23].getCustomers().add(customerRef[8]); > getEntityManager().merge(aliasRef[23]); > > orderRef[9].setCustomer(customerRef[8]); > getEntityManager().merge(orderRef[9]); > > creditCard[14].setCustomer(customerRef[8]); > getEntityManager().merge(creditCard[14]); > > doFlush(); > //TLogger.log("Setting additional relationships for Customer 10"); > aliasRef[21].getCustomers().add(customerRef[9]); > getEntityManager().merge(aliasRef[21]); > > aliasRef[29].getCustomers().add(customerRef[9]); > getEntityManager().merge(aliasRef[29]); > > orderRef[10].setCustomer(customerRef[9]); > getEntityManager().merge(orderRef[10]); > > creditCard[15].setCustomer(customerRef[9]); > getEntityManager().merge(creditCard[15]); > > customerRef[9].setSpouse(spouse[3]); > getEntityManager().merge(customerRef[9]); > doFlush(); > //TLogger.log("Setting additional relationships for Customer 11"); > aliasRef[25].getCustomers().add(customerRef[10]); > getEntityManager().merge(aliasRef[25]); > > aliasRef[26].getCustomers().add(customerRef[10]); > getEntityManager().merge(aliasRef[26]); > > aliasRef[28].getCustomers().add(customerRef[10]); > getEntityManager().merge(aliasRef[28]); > > orderRef[11].setCustomer(customerRef[10]); > getEntityManager().merge(orderRef[11]); > > creditCard[16].setCustomer(customerRef[10]); > getEntityManager().merge(creditCard[16]); > > customerRef[10].setSpouse(spouse[1]); > getEntityManager().merge(customerRef[10]); > doFlush(); > //TLogger.log("Setting additional relationships for Customer 12"); > aliasRef[24].getCustomers().add(customerRef[11]); > getEntityManager().merge(aliasRef[24]); > > orderRef[12].setCustomer(customerRef[11]); > getEntityManager().merge(orderRef[12]); > > creditCard[17].setCustomer(customerRef[11]); > getEntityManager().merge(creditCard[17]); > > customerRef[11].setSpouse(spouse[4]); > getEntityManager().merge(customerRef[11]); > doFlush(); > //TLogger.log("Setting additional relationships for Customer 13"); > aliasRef[20].getCustomers().add(customerRef[12]); > getEntityManager().merge(aliasRef[20]); > > orderRef[13].setCustomer(customerRef[12]); > getEntityManager().merge(orderRef[13]); > > creditCard[18].setCustomer(customerRef[12]); > getEntityManager().merge(creditCard[18]); > > customerRef[12].setSpouse(spouse[2]); > getEntityManager().merge(customerRef[12]); > > doFlush(); > //TLogger.log("Setting additional relationships for Customer 14"); > aliasRef[22].getCustomers().add(customerRef[13]); > getEntityManager().merge(aliasRef[22]); > > aliasRef[27].getCustomers().add(customerRef[13]); > getEntityManager().merge(aliasRef[27]); > > orderRef[14].setCustomer(customerRef[13]); > getEntityManager().merge(orderRef[14]); > > orderRef[15].setCustomer(customerRef[13]); > getEntityManager().merge(orderRef[15]); > > creditCard[19].setCustomer(customerRef[13]); > getEntityManager().merge(creditCard[19]); > doFlush(); > //TLogger.log("Setting additional relationships for Customer 15"); > // No Aliases > orderRef[16].setCustomer(customerRef[14]); > getEntityManager().merge(orderRef[16]); > > creditCard[20].setCustomer(customerRef[14]); > getEntityManager().merge(creditCard[20]); > doFlush(); > //TLogger.log("Setting additional relationships for Customer 16"); > // No Aliases > orderRef[17].setCustomer(customerRef[15]); > getEntityManager().merge(orderRef[17]); > > creditCard[21].setCustomer(customerRef[15]); > getEntityManager().merge(creditCard[21]); > doFlush(); > //TLogger.log("Setting additional relationships for Customer 17"); > // No Aliases > orderRef[18].setCustomer(customerRef[16]); > getEntityManager().merge(orderRef[18]); > > creditCard[22].setCustomer(customerRef[16]); > getEntityManager().merge(creditCard[22]); > doFlush(); > //TLogger.log("Setting additional relationships for Customer 18"); > // No Aliases > orderRef[19].setCustomer(customerRef[17]); > getEntityManager().merge(orderRef[19]); > > creditCard[23].setCustomer(customerRef[17]); > getEntityManager().merge(creditCard[23]); > doFlush(); > TLogger.log("created Relationships"); > > getEntityTransaction().commit(); > } >}
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=681399">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 899515
:
681397
|
681398
| 681399