JorisLog/2010/12/07: CreateDatabase.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package handwritten.importers;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import org.hibernate.ejb.HibernateEntityManager;

/**
 *
 * @author jorislops
 */
public class CreateDatabase {
    
    private CreateDatabase() {};

    public static void main(String[] args) throws IOException, SQLException {
        Map<String, Object> configOverrides = new HashMap<String, Object>();
        configOverrides.put("hibernate.hbm2ddl.auto", "create-drop");
        EntityManagerFactory emf =
            Persistence.createEntityManagerFactory("molgenis4LIMS", configOverrides);

        BufferedReader br = 
            new BufferedReader(
                new InputStreamReader(
                    new CreateDatabase().getClass()
                        .getResourceAsStream("triggers.sql")));

        StringBuilder trigger = new StringBuilder();
        while(br.ready()) {
            trigger.append(br.readLine()).append("\n");
        }

        EntityManager em = emf.createEntityManager();
        System.out.println("Excute trigger: ");
        System.out.println(trigger.toString());

        ///em.getTransaction().begin();

        Connection c = ((HibernateEntityManager) em).getSession().connection();
        c.createStatement().execute(trigger.toString());

//            int result = em.createNativeQuery(trigger.toString()).executeUpdate();
//        em.getTransaction().commit();

//        System.out.println("Result: " + result);
        System.out.println("Database Created!");
    }
}