Examples with DdlGenerator siena.jdbc.ddl.DdlGenerator used on opensource projects

Example 11 with DdlGenerator

use of siena.jdbc.ddl.DdlGenerator in project siena by mandubian.

the class DrizzleTest method createPersistenceManager.

@Override
public PersistenceManager createPersistenceManager(List<Class<?>> classes) throws Exception {
    if (pm == null) {
        Properties p = new Properties();
        String driver = "org.drizzle.jdbc.DrizzleDriver";
        //String username = "root";
        //String password = "";
        String url = "jdbc:mysql://localhost:4427/siena";
        p.setProperty("driver", driver);
        //p.setProperty("user",     username);
        //p.setProperty("password", password);
        p.setProperty("url", url);
        Class.forName(driver);
        BasicDataSource dataSource = new BasicDataSource();
        dataSource = new BasicDataSource();
        dataSource.setUrl(url);
        //dataSource.setUsername(username);
        //dataSource.setPassword(password);
        // 2 seconds max for wait a connection.
        dataSource.setMaxWait(2000);
        DdlGenerator generator = new DdlGenerator();
        for (Class<?> clazz : classes) {
            generator.addTable(clazz);
        }
        // get the Database model
        Database database = generator.getDatabase();
        Platform platform = PlatformFactory.createNewPlatformInstance(dataSource);
        Class.forName("org.drizzle.jdbc.DrizzleDriver");
        Connection connection = DriverManager.getConnection(url);
        System.out.println(platform.getAlterTablesSql(connection, database));
        // this will perform the database changes
        platform.alterTables(connection, database, true);
        connection.close();
        pm = new JdbcPersistenceManager();
        pm.init(p);
    }
    return pm;
}