H2TestNoAutoInc_4_SPECIALS.java

package siena.base.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.List;
import java.util.Properties;

import org.apache.commons.dbcp.BasicDataSource;
import org.apache.ddlutils.Platform;
import org.apache.ddlutils.PlatformFactory;
import org.apache.ddlutils.model.Database;
import org.apache.ddlutils.platform.CreationParameters;

import siena.PersistenceManager;
import siena.base.test.model.EnumTest;
import siena.base.test.model.PersonStringID;
import siena.jdbc.H2PersistenceManager;
import siena.jdbc.JdbcPersistenceManager;
import siena.jdbc.PostgresqlPersistenceManager;
import siena.jdbc.ddl.DdlGenerator;

public class H2TestNoAutoInc_4_SPECIALS extends JdbcTestNoAutoInc_4_SPECIALS {
	private static H2PersistenceManager pm;

	@Override
	public PersistenceManager createPersistenceManager(List<Class<?>> classes) throws Exception {
		if(pm==null){
			Properties p = new Properties();
			
			String driver   = "org.h2.Driver";
			String url      = "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1";
			String username = "sa";
			String password = "";
			
			p.setProperty("driver",   driver);
			p.setProperty("url",      url);
			p.setProperty("user",     username);
			p.setProperty("password", password);

			DdlGenerator generator = new DdlGenerator();
			for (Class<?> clazz : classes) {
				generator.addTable(clazz);
			}
	
			// get the Database model
			Database database = generator.getDatabase();
	
			Platform platform = PlatformFactory.createNewPlatformInstance("mysql");
			Class.forName(driver);
			//JdbcDataSource ds = new JdbcDataSource();
			//ds.setURL(url);
			//Connection connection = ds.getConnection();
			Connection connection = DriverManager.getConnection(url, username, password);
			
			System.out.println(platform.getAlterTablesSql(connection, database));
			
			// this will perform the database changes
			platform.alterTables(connection, database, true);
	
			connection.close();
			
			pm = new H2PersistenceManager();
			pm.init(p);
		}
		return pm;
	}

	
    
}