Java tutorial
/******************************************************************************* * Copyright (c) 2015 XLAB d.o.o. * All rights reserved. This program and the accompanying materials * are made available under the terms of the Eclipse Public License v1.0 * which accompanies this distribution, and is available at * http://www.eclipse.org/legal/epl-v10.html * * @author XLAB d.o.o. *******************************************************************************/ package eu.cloudscale.showcase.generate; import java.util.Calendar; import java.util.Date; import java.util.GregorianCalendar; import java.util.HashSet; import java.util.LinkedList; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.Transaction; import org.springframework.context.ApplicationContext; import org.springframework.stereotype.Component; import org.springframework.transaction.annotation.Transactional; import eu.cloudscale.showcase.db.model.IAddress; import eu.cloudscale.showcase.db.model.ICcXacts; import eu.cloudscale.showcase.db.model.ICountry; import eu.cloudscale.showcase.db.model.ICustomer; import eu.cloudscale.showcase.db.model.IItem; import eu.cloudscale.showcase.db.model.IOrderLine; import eu.cloudscale.showcase.db.model.hibernate.CcXacts; import eu.cloudscale.showcase.db.model.hibernate.Customer; import eu.cloudscale.showcase.db.model.hibernate.OrderLine; import eu.cloudscale.showcase.db.model.hibernate.Orders; @Component public class GenerateHibernate extends AGenerate { public GenerateHibernate() { super(); } @Override public void populateOrdersAndCC_XACTSTable() { GregorianCalendar cal; String[] credit_cards = { "VISA", "MASTERCARD", "DISCOVER", "AMEX", "DINERS" }; int num_card_types = 5; String[] ship_types = { "AIR", "UPS", "FEDEX", "SHIP", "COURIER", "MAIL" }; int num_ship_types = 6; String[] status_types = { "PROCESSING", "SHIPPED", "PENDING", "DENIED" }; int num_status_types = 4; // Order variables int O_C_ID; java.sql.Timestamp O_DATE; double O_SUB_TOTAL; double O_TAX; double O_TOTAL; String O_SHIP_TYPE; java.sql.Timestamp O_SHIP_DATE; int O_BILL_ADDR_ID, O_SHIP_ADDR_ID; String O_STATUS; String CX_TYPE; int CX_NUM; String CX_NAME; java.sql.Date CX_EXPIRY; String CX_AUTH_ID; int CX_CO_ID; System.out.println("Populating ORDERS, ORDER_LINES, CC_XACTS with " + NUM_ORDERS + " orders"); System.out.print("Complete (in 10,000's): "); Session session = sessionFactory.openSession(); Transaction tx = session.beginTransaction(); for (int i = 1; i <= NUM_ORDERS; i++) { if (i % 1000 == 0) { session.flush(); session.clear(); System.out.print(i / 1000 + " "); } if (i % 10000 == 0) { System.out.println(); } int num_items = getRandomInt(1, 5); cal = new GregorianCalendar(); cal.add(Calendar.DAY_OF_YEAR, -1 * getRandomInt(1, 60)); O_DATE = new java.sql.Timestamp(cal.getTime().getTime()); O_SUB_TOTAL = (double) getRandomInt(1000, 999999) / 100; O_TAX = O_SUB_TOTAL * 0.0825; O_TOTAL = O_SUB_TOTAL + O_TAX + 3.00 + num_items; O_SHIP_TYPE = ship_types[getRandomInt(0, num_ship_types - 1)]; cal.add(Calendar.DAY_OF_YEAR, getRandomInt(0, 7)); O_SHIP_DATE = new java.sql.Timestamp(cal.getTime().getTime()); O_STATUS = status_types[getRandomInt(0, num_status_types - 1)]; Orders order = new Orders(); ICustomer customer = this.customers.get(getRandomInt(1, this.customers.size() - 1)); IAddress billAddress = this.addresses.get(getRandomInt(1, this.addresses.size() - 1)); IAddress shipAddress = this.addresses.get(getRandomInt(1, this.addresses.size() - 1)); // int OL_I_ID = getRandomInt( 1, NUM_ITEMS ); // IItem item = itemDao.findById( OL_I_ID ); // Set parameter order.setCustomer(customer); order.setODate(new Date(O_DATE.getTime())); order.setOSubTotal(O_SUB_TOTAL); order.setOTax(O_TAX); order.setOTotal(O_TOTAL); order.setOShipType(O_SHIP_TYPE); order.setOShipDate(O_SHIP_DATE); order.setAddressByOBillAddrId(billAddress); order.setAddressByOShipAddrId(shipAddress); order.setOStatus(O_STATUS); order.setCcXactses(new HashSet<ICcXacts>()); order.setOrderLines(new HashSet<IOrderLine>()); session.save(order); for (int j = 1; j <= num_items; j++) { int OL_ID = j; int OL_O_ID = i; int OL_QTY = getRandomInt(1, 300); double OL_DISCOUNT = (double) getRandomInt(0, 30) / 100; String OL_COMMENTS = getRandomAString(20, 100); OrderLine orderLine = new OrderLine(); orderLine.setItem(this.items.get(getRandomInt(1, this.items.size() - 1))); orderLine.setOlQty(OL_QTY); orderLine.setOlDiscount(OL_DISCOUNT); orderLine.setOlComment(OL_COMMENTS); orderLine.setOrders(order); session.save(orderLine); order.getOrderLines().add(orderLine); } CX_TYPE = credit_cards[getRandomInt(0, num_card_types - 1)]; CX_NUM = getRandomNString(16); CX_NAME = getRandomAString(14, 30); cal = new GregorianCalendar(); cal.add(Calendar.DAY_OF_YEAR, getRandomInt(10, 730)); CX_EXPIRY = new java.sql.Date(cal.getTime().getTime()); CX_AUTH_ID = getRandomAString(15); CcXacts ccXacts = new CcXacts(); ccXacts.setCountry(this.countries.get(getRandomInt(1, this.countries.size() - 1))); ccXacts.setOrders(order); ccXacts.setCxType(CX_TYPE); ccXacts.setCxNum(CX_NUM); ccXacts.setCxName(CX_NAME); ccXacts.setCxExpiry(CX_EXPIRY); ccXacts.setCxAuthId(CX_AUTH_ID); ccXacts.setCxXactAmt(O_TOTAL); ccXacts.setCxXactDate(O_SHIP_DATE); // ccXacts.setOrders( order ); order.getCcXactses().add(ccXacts); session.save(ccXacts); } tx.commit(); session.close(); System.out.println(""); } }