package com.vst.snippets;
import org.apache.log4j.BasicConfigurator;
import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.hibernate3.AbstractSessionFactoryBean;
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.dao.hibernate.DetailDaoHibernate;
public class CheckAlterSchemeQueries {
public static void main(String[] args) {
//BasicConfigurator.configure();
ApplicationContext context = new ClassPathXmlApplicationContext(
new String[]{"com/vst/snippets/snippetsContext-hibernate.xml"});
Configuration cfg = (Configuration)
context.getBean("hibernateConfiguration");
// SchemaExport sche = new SchemaExport(cfg);
// sche.setOutputFile("./db.sql");
// sche.setDelimiter(";");
// // set script=true and sqls printing on console
// // export if true export script to DB.
// // script, export, justDrop, justCreate
// sche.execute(false, false, false, false);
final BuildingObjectDao buildingDao =
(BuildingObjectDao) context.getBean("buildingObjectDao");
final RegionDao regionDao =
(RegionDao) context.getBean("regionDao");
final ConstructionExampleDao csamplesDao =
(ConstructionExampleDao) context.getBean("constructionExampleDao");
final DetailDaoHibernate detailDao =
(DetailDaoHibernate) context.getBean("detailDao");
PlatformTransactionManager txManager =
(PlatformTransactionManager) context.getBean("txManager");
new TransactionTemplate(txManager).execute(new TransactionCallback() {
@Override
public Object doInTransaction(TransactionStatus arg0) {
long start = System.currentTimeMillis();
detailDao.getAllPipe();
long end = System.currentTimeMillis();
System.out.println("Work time:" + (end - start));
return null;
}
});
}
}