@Test public void testInsertWithGeneratedId() { // Make sure the env supports bulk inserts with generated ids... if (!supportsBulkInsertIdGeneration(PettingZoo.class)) { SkipLog.reportSkip( "bulk id generation not supported", "test bulk inserts with generated id and generated timestamp"); return; } // create a Zoo Zoo zoo = new Zoo(); zoo.setName("zoo"); Session s = openSession(); Transaction t = s.beginTransaction(); s.save(zoo); t.commit(); s.close(); s = openSession(); t = s.beginTransaction(); int count = s.createQuery("insert into PettingZoo (name) select name from Zoo").executeUpdate(); t.commit(); s.close(); assertEquals("unexpected insertion count", 1, count); s = openSession(); t = s.beginTransaction(); PettingZoo pz = (PettingZoo) s.createQuery("from PettingZoo").uniqueResult(); t.commit(); s.close(); assertEquals(zoo.getName(), pz.getName()); assertTrue(!zoo.getId().equals(pz.getId())); s = openSession(); t = s.beginTransaction(); s.createQuery("delete Zoo").executeUpdate(); t.commit(); s.close(); }
private void prepare() { Session s = openSession(); Transaction txn = s.beginTransaction(); polliwog = new Animal(); polliwog.setBodyWeight(12); polliwog.setDescription("Polliwog"); catepillar = new Animal(); catepillar.setBodyWeight(10); catepillar.setDescription("Catepillar"); frog = new Animal(); frog.setBodyWeight(34); frog.setDescription("Frog"); polliwog.setFather(frog); frog.addOffspring(polliwog); butterfly = new Animal(); butterfly.setBodyWeight(9); butterfly.setDescription("Butterfly"); catepillar.setMother(butterfly); butterfly.addOffspring(catepillar); s.save(frog); s.save(polliwog); s.save(butterfly); s.save(catepillar); Dog dog = new Dog(); dog.setBodyWeight(200); dog.setDescription("dog"); s.save(dog); Cat cat = new Cat(); cat.setBodyWeight(100); cat.setDescription("cat"); s.save(cat); zoo = new Zoo(); zoo.setName("Zoo"); Address add = new Address(); add.setCity("MEL"); add.setCountry("AU"); add.setStreet("Main st"); add.setPostalCode("3000"); zoo.setAddress(add); pettingZoo = new PettingZoo(); pettingZoo.setName("Petting Zoo"); Address addr = new Address(); addr.setCity("Sydney"); addr.setCountry("AU"); addr.setStreet("High st"); addr.setPostalCode("2000"); pettingZoo.setAddress(addr); s.save(zoo); s.save(pettingZoo); Joiner joiner = new Joiner(); joiner.setJoinedName("joined-name"); joiner.setName("name"); s.save(joiner); Car car = new Car(); car.setVin("123c"); car.setOwner("Kirsten"); s.save(car); Truck truck = new Truck(); truck.setVin("123t"); truck.setOwner("Steve"); s.save(truck); SUV suv = new SUV(); suv.setVin("123s"); suv.setOwner("Joe"); s.save(suv); Pickup pickup = new Pickup(); pickup.setVin("123p"); pickup.setOwner("Cecelia"); s.save(pickup); BooleanLiteralEntity bool = new BooleanLiteralEntity(); s.save(bool); txn.commit(); s.close(); }