package com.vst.snippets;
import java.util.List;
import org.apache.log4j.BasicConfigurator;
import org.apache.log4j.Logger;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.TransactionCallback;
import org.springframework.transaction.support.TransactionTemplate;
import com.vst.dao.BuildingObjectDao;
import com.vst.dao.ConstructionExampleDao;
import com.vst.dao.RegionDao;
import com.vst.model.BuildingObject;
import com.vst.model.ObjectConstruction;
import com.vst.model.Region;
public class CheckMainPageQueries {
public static void main(String[] args) {
BasicConfigurator.configure();
ApplicationContext context = new ClassPathXmlApplicationContext(
new String[]{"com/vst/snippets/snippetsContext-hibernate.xml"});
final BuildingObjectDao buildingDao =
(BuildingObjectDao) context.getBean("buildingObjectDao");
final RegionDao regionDao =
(RegionDao) context.getBean("regionDao");
final ConstructionExampleDao csamplesDao =
(ConstructionExampleDao) context.getBean("constructionExampleDao");
PlatformTransactionManager txManager =
(PlatformTransactionManager) context.getBean("txManager");
new TransactionTemplate(txManager).execute(new TransactionCallback() {
@Override
public Object doInTransaction(TransactionStatus arg0) {
long start = System.currentTimeMillis();
List<?> rlist = regionDao.getObjects();
List<?> blist = buildingDao.getBuildingObjectsForTree();
System.out.println(rlist);
System.out.println(blist);
for (Object o : blist){
BuildingObject bo = (BuildingObject) o;
List<?> clist =
buildingDao.getConstructionTypesForTree(bo.getObjectId());
System.out.println(bo);
System.out.println(clist);
for (Object c: clist){
ObjectConstruction ct = (ObjectConstruction) c;
List<?> samplelist =
csamplesDao.getConstructionExamplesLite("" + ct.getTypeId(), "tree");
System.out.println(samplelist);
}
}
long end = System.currentTimeMillis();
System.out.println("Work time:" + (end - start) );
return null;
}
});
}
}