/**
* With delete-orphan cascade. The cascade=”delete-orphan” is declared in ‘billingDetails’ to
* enable the delete orphan cascade effect. When you save or update the User, it will remove those
* ‘billingDetails’ which already mark as removed.
*
* <p>In short, delete-orphan allow parent table to delete few records (delete orphan) in its
* child table.
*/
public void /*test*/ BillingDetailsWithDeleteOrphanCascade() throws Exception {
LogHelper.disableLogging();
User u1 = new User("Christian", "Bauer", "turin", "abc123", "*****@*****.**");
u1.setAddress(new Address("Foo", "12345", "Bar"));
u1.setAdmin(true);
HibernateUtil.getSession().save(u1);
BillingDetails ccOne =
new CreditCard(
"Christian Bauer", u1, "1234567890", CreditCardType.MASTERCARD, "10", "2005");
u1.addBillingDetails(ccOne);
HibernateUtil.getSession().save(ccOne);
HibernateUtil.getSession().flush();
UserDAO userDAO = new UserDAO();
User user = userDAO.loadUserById(1l, false);
Set details = user.getBillingDetails();
for (Object detail : details) {
LogHelper.setLogging("org.hibernate.SQL", Level.DEBUG);
user.getBillingDetails().remove(detail);
user.setDefaultBillingDetails(null);
LogHelper.disableLogging();
}
LogHelper.setLogging("org.hibernate.SQL", Level.DEBUG);
HibernateUtil.getSession().saveOrUpdate(u1);
HibernateUtil.getSession().flush();
}
public void /*test*/ LoadUserWithBillingDetails() {
System.out.println("******************** testLoadUserWithBillingDetails ********************");
UserDAO userDAO = new UserDAO();
User user = userDAO.loadUserById(1l, false);
Set<BillingDetails> billingDetails = user.getBillingDetails();
Iterator<BillingDetails> billingIterator = billingDetails.iterator();
while (billingIterator.hasNext()) {
BillingDetails details = billingIterator.next();
if (details instanceof BankAccount) {
BankAccount account = (BankAccount) details;
assertEquals("FooBar Rich Bank", account.getBankName());
assertEquals("234234234234", account.getNumber());
}
if (details instanceof CreditCard) {
CreditCard cc = (CreditCard) details;
assertEquals("1234567890", cc.getNumber());
}
if (details instanceof HibernateProxy) {
HibernateProxy proxy = (HibernateProxy) details;
Object proxyImpl = proxy.getHibernateLazyInitializer().getImplementation();
if (proxyImpl instanceof CreditCard) {
CreditCard cc = (CreditCard) proxyImpl;
assertEquals("1234567890", cc.getNumber());
} else {
fail("Proxy is not a CreditCard");
}
}
}
BillingDetails defaultBillingDetails = user.getDefaultBillingDetails();
if (defaultBillingDetails instanceof HibernateProxy) {
HibernateProxy proxy = (HibernateProxy) defaultBillingDetails;
Object proxyImpl = proxy.getHibernateLazyInitializer().getImplementation();
if (proxyImpl instanceof CreditCard) {
CreditCard cc = (CreditCard) proxyImpl;
assertEquals("1234567890", cc.getNumber());
} else {
fail("Proxy is not a CreditCard");
}
} else {
fail("DefaultBillingDetails is not a proxy");
}
// HibernateUtil.closeSession();
BillingDetailsDAO billingDetailsDAO = new BillingDetailsDAO();
BillingDetails billingDetails1 = billingDetailsDAO.getBillingDetailsById(1l, false);
assertNotNull(billingDetails1);
assertTrue(billingDetails1.getUser() == user);
user.removeBillingDetails(billingDetails1);
HibernateUtil.getSession().flush();
// BillingDetails billingDetails2 = billingDetailsDAO.loadBillingDetailsById(1l, false);
BillingDetails billingDetails2 = billingDetailsDAO.getBillingDetailsById(1l, false);
assertNull(billingDetails2);
}
public void makeTransient(User user) throws InfrastructureException {
try {
HibernateUtil.getSession().delete(user);
} catch (HibernateException ex) {
throw new InfrastructureException(ex);
}
}
public void makePersistent(User user) throws InfrastructureException {
try {
HibernateUtil.getSession().saveOrUpdate(user);
} catch (HibernateException ex) {
throw new InfrastructureException(ex);
}
}
public Collection findAll() throws InfrastructureException {
Collection users;
try {
users = HibernateUtil.getSession().createCriteria(User.class).list();
} catch (HibernateException ex) {
throw new InfrastructureException(ex);
}
return users;
}
public Collection findByExample(User exampleUser) throws InfrastructureException {
Collection users;
try {
Criteria crit = HibernateUtil.getSession().createCriteria(User.class);
users = crit.add(Example.create(exampleUser)).list();
} catch (HibernateException ex) {
throw new InfrastructureException(ex);
}
return users;
}
/**
* With save-update cascade. The cascade=”save-update” is declared in ‘BillingDetails’ to enable
* the save-update cascade effect..
*/
public void /*test*/ BillingDetailsCascadeSaveUpdate() {
User u1 = new User("Christian", "Bauer", "turin", "abc123", "*****@*****.**");
u1.setAddress(new Address("Foo", "12345", "Bar"));
u1.setAdmin(true);
BillingDetails ccOne =
new CreditCard(
"Christian Bauer", u1, "1234567890", CreditCardType.MASTERCARD, "10", "2005");
u1.addBillingDetails(ccOne);
HibernateUtil.getSession().save(u1);
}
public User getUserById(Long userId, boolean lock) throws InfrastructureException {
Session session = HibernateUtil.getSession();
User user = null;
try {
if (lock) {
user = (User) session.load(User.class, userId, LockMode.UPGRADE);
} else {
user = (User) session.load(User.class, userId);
}
} catch (HibernateException ex) {
throw new InfrastructureException(ex);
}
return user;
}
/**
* fetch=”subselect” or @Fetch(FetchMode.SUBSELECT).
*
* <p>This fetching strategy is enable all its related collection in a sub select statement. Let
* see the same query again.
*
* <p>With “subselect” enabled, it will create two select statements.
*
* <p>1. Select statement to retrieve all the Stock records.
*
* <p>2. Select all its related collections in a sub select query.
*/
@org.junit.Test
public void /*test*/ UserBatchItems() {
System.out.println("******************* testUserBatchItems ********************");
Session session = HibernateUtil.getSession();
List<User> list = session.createQuery("from User").list();
for (User user : list) {
Set items = user.getItems();
for (Iterator iter = items.iterator(); iter.hasNext(); ) {
Item item = (Item) iter.next();
assertNotNull(item.getId());
assertNotNull(item.getName());
}
}
}
