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;
+	}
+	
+	
+}