You are viewing a plain text version of this content. The canonical link for it is here.
Posted to hise-commits@incubator.apache.org by rr...@apache.org on 2010/08/02 13:22:36 UTC
svn commit: r981503 -
/incubator/hise/trunk/hise-services/src/main/java/org/apache/hise/engine/store/DataBaseInitializer.java
Author: rr
Date: Mon Aug 2 13:22:36 2010
New Revision: 981503
URL: http://svn.apache.org/viewvc?rev=981503&view=rev
Log:
HISE-53: Update (thanks to Paweł Byszewski)
Added:
incubator/hise/trunk/hise-services/src/main/java/org/apache/hise/engine/store/DataBaseInitializer.java
Added: incubator/hise/trunk/hise-services/src/main/java/org/apache/hise/engine/store/DataBaseInitializer.java
URL: http://svn.apache.org/viewvc/incubator/hise/trunk/hise-services/src/main/java/org/apache/hise/engine/store/DataBaseInitializer.java?rev=981503&view=auto
==============================================================================
--- incubator/hise/trunk/hise-services/src/main/java/org/apache/hise/engine/store/DataBaseInitializer.java (added)
+++ incubator/hise/trunk/hise-services/src/main/java/org/apache/hise/engine/store/DataBaseInitializer.java Mon Aug 2 13:22:36 2010
@@ -0,0 +1,164 @@
+package org.apache.hise.engine.store;
+
+import java.io.BufferedReader;
+import java.io.File;
+import java.io.FileNotFoundException;
+import java.io.FileReader;
+import java.io.IOException;
+import java.io.InputStream;
+import java.io.InputStreamReader;
+import java.net.URISyntaxException;
+import java.net.URL;
+import java.sql.SQLException;
+import java.util.ArrayList;
+import java.util.List;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceException;
+import javax.persistence.Query;
+import javax.xml.soap.MessageFactory;
+
+import org.apache.commons.logging.Log;
+import org.apache.commons.logging.LogFactory;
+import org.apache.hise.api.HISEEngine;
+import org.apache.hise.dao.Comment;
+import org.apache.hise.dao.TaskHistoryMessage;
+import org.springframework.orm.jpa.JpaCallback;
+import org.springframework.orm.jpa.JpaTemplate;
+import org.springframework.transaction.PlatformTransactionManager;
+import org.springframework.transaction.TransactionStatus;
+import org.springframework.transaction.support.TransactionCallback;
+import org.springframework.transaction.support.TransactionTemplate;
+
+public class DataBaseInitializer {
+
+ private static Log __log = LogFactory.getLog(DataBaseInitializer.class);
+
+ private PlatformTransactionManager transactionManager;
+ private HISEEngine hiseEngine;
+ private TransactionTemplate transactionTemplate;
+ private File sqlScript;
+ private URL fileName;
+
+
+ public URL getFileName() {
+ return fileName;
+ }
+
+
+ public void setFileName(URL fileName) {
+ this.fileName = fileName;
+ }
+
+
+ public DataBaseInitializer() {
+ sqlScript=null;
+ }
+
+
+ public void init() throws IOException, URISyntaxException {
+
+ InputStream inputStream=fileName.openStream();
+
+ final List<String> inserts=getStrings(inputStream);
+ transactionTemplate = new TransactionTemplate(transactionManager);
+
+ transactionTemplate.execute(new TransactionCallback() {
+ public Object doInTransaction(TransactionStatus arg0) {
+
+ Object result=null;
+ try {
+ JpaTemplate tmp=hiseEngine.getHiseDao().getJpaTemplate();
+ result=tmp.execute(new JpaCallback() {
+ public Object doInJpa(EntityManager em) throws PersistenceException {
+ String queryTmp=new String("DELETE FROM HISE_TASK_HISTORY_MESSAGE;");
+ Query q=em.createNativeQuery(queryTmp);
+ q.executeUpdate();
+ for (String query : inserts) {
+ q=em.createNativeQuery(query); // ;(query, TaskHistoryMessage2.class).getResultList();
+ int i=q.executeUpdate();
+ }
+ return null;
+
+ }
+ });
+ } catch (Exception e) {
+
+ e.printStackTrace();
+ }
+ return null;
+ }
+ });
+
+
+ }
+ private List<String> getStrings(InputStream in) throws FileNotFoundException{
+ List<String> res=new ArrayList<String>();
+ String thisLine, sqlQuery;
+ BufferedReader d = new BufferedReader( new InputStreamReader(in));
+ try {
+ sqlQuery = "";
+ while ((thisLine = d.readLine()) != null)
+ {
+ //Skip comments and empty lines
+ if(thisLine.length() > 0 && thisLine.charAt(0) == '-' || thisLine.length() == 0 )
+ continue;
+ sqlQuery = sqlQuery + " " + thisLine;
+
+ res.add(sqlQuery);
+ sqlQuery = "";
+
+ }
+ }
+ catch(IOException ex) {
+ ex.printStackTrace();
+ }
+ catch(Exception ex) {
+ ex.printStackTrace();
+
+ }
+ return res;
+ }
+
+
+ public PlatformTransactionManager getTransactionManager() {
+ return transactionManager;
+ }
+
+
+ public void setTransactionManager(PlatformTransactionManager transactionManager) {
+ this.transactionManager = transactionManager;
+ }
+
+
+ public TransactionTemplate getTransactionTemplate() {
+ return transactionTemplate;
+ }
+
+
+ public void setTransactionTemplate(TransactionTemplate transactionTemplate) {
+ this.transactionTemplate = transactionTemplate;
+ }
+
+
+ public HISEEngine getHiseEngine() {
+ return hiseEngine;
+ }
+
+
+ public void setHiseEngine(HISEEngine hiseEngine) {
+ this.hiseEngine = hiseEngine;
+ }
+
+
+ public File getSqlScript() {
+ return sqlScript;
+ }
+
+
+ public void setSqlScript(File sqlScript) {
+ this.sqlScript = sqlScript;
+ }
+
+
+}