Search in sources :

Example 1 with Platform

use of org.apache.ddlutils.Platform in project siena by mandubian.

the class H2MultiThreadTest method createPersistenceManager.

@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;
}
Also used : Platform(org.apache.ddlutils.Platform) Database(org.apache.ddlutils.model.Database) Connection(java.sql.Connection) DdlGenerator(siena.jdbc.ddl.DdlGenerator) Properties(java.util.Properties) H2PersistenceManager(siena.jdbc.H2PersistenceManager)

Example 2 with Platform

use of org.apache.ddlutils.Platform in project siena by mandubian.

the class H2Test method createPersistenceManager.

@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;
}
Also used : Platform(org.apache.ddlutils.Platform) Database(org.apache.ddlutils.model.Database) Connection(java.sql.Connection) DdlGenerator(siena.jdbc.ddl.DdlGenerator) H2PersistenceManager(siena.jdbc.H2PersistenceManager)

Example 3 with Platform

use of org.apache.ddlutils.Platform in project siena by mandubian.

the class JdbcModelTest method createPersistenceManager.

@Override
public PersistenceManager createPersistenceManager(List<Class<?>> classes) throws Exception {
    if (pm == null) {
        Properties p = new Properties();
        String driver = "com.mysql.jdbc.Driver";
        String username = "siena";
        String password = "siena";
        String url = "jdbc:mysql://localhost/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("mysql");
        Class.forName("com.mysql.jdbc.Driver");
        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 JdbcPersistenceManager();
        pm.init(p);
    }
    return pm;
}
Also used : JdbcPersistenceManager(siena.jdbc.JdbcPersistenceManager) Platform(org.apache.ddlutils.Platform) Database(org.apache.ddlutils.model.Database) Connection(java.sql.Connection) DdlGenerator(siena.jdbc.ddl.DdlGenerator) Properties(java.util.Properties) BasicDataSource(org.apache.commons.dbcp.BasicDataSource)

Example 4 with Platform

use of org.apache.ddlutils.Platform in project siena by mandubian.

the class JdbcTest method createPersistenceManager.

@Override
public PersistenceManager createPersistenceManager(List<Class<?>> classes) throws Exception {
    if (pm == null) {
        Properties p = new Properties();
        String driver = "com.mysql.jdbc.Driver";
        String username = "siena";
        String password = "siena";
        String url = "jdbc:mysql://localhost/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("mysql");
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection connection = DriverManager.getConnection(url, username, password);
        System.out.println(platform.getAlterTablesSql(connection, database));
        // this will perform the database changes
        CreationParameters cp = new CreationParameters();
        // to search, it requires MyISAM
        cp.addParameter(database.findTable("discoveries_search"), "ENGINE", "MyISAM");
        cp.addParameter(database.findTable("discoveries_search2"), "ENGINE", "MyISAM");
        platform.alterTables(connection, database, cp, true);
        connection.close();
        pm = new JdbcPersistenceManager();
        pm.init(p);
    }
    return pm;
}
Also used : JdbcPersistenceManager(siena.jdbc.JdbcPersistenceManager) Platform(org.apache.ddlutils.Platform) Database(org.apache.ddlutils.model.Database) Connection(java.sql.Connection) DdlGenerator(siena.jdbc.ddl.DdlGenerator) Properties(java.util.Properties) BasicDataSource(org.apache.commons.dbcp.BasicDataSource) CreationParameters(org.apache.ddlutils.platform.CreationParameters)

Example 5 with Platform

use of org.apache.ddlutils.Platform in project siena by mandubian.

the class JdbcTestNoAutoInc_4_SPECIALS method createPersistenceManager.

@Override
public PersistenceManager createPersistenceManager(List<Class<?>> classes) throws Exception {
    if (pm == null) {
        Properties p = new Properties();
        String driver = "com.mysql.jdbc.Driver";
        String username = "siena";
        String password = "siena";
        String url = "jdbc:mysql://localhost/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("mysql");
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection connection = DriverManager.getConnection(url, username, password);
        System.out.println(platform.getAlterTablesSql(connection, database));
        // this will perform the database changes
        CreationParameters cp = new CreationParameters();
        // to search, it requires MyISAM
        cp.addParameter(database.findTable("discoveries_search"), "ENGINE", "MyISAM");
        cp.addParameter(database.findTable("discoveries_search2"), "ENGINE", "MyISAM");
        platform.alterTables(connection, database, cp, true);
        connection.close();
        pm = new JdbcPersistenceManager();
        pm.init(p);
    }
    return pm;
}
Also used : JdbcPersistenceManager(siena.jdbc.JdbcPersistenceManager) Platform(org.apache.ddlutils.Platform) Database(org.apache.ddlutils.model.Database) Connection(java.sql.Connection) DdlGenerator(siena.jdbc.ddl.DdlGenerator) Properties(java.util.Properties) BasicDataSource(org.apache.commons.dbcp.BasicDataSource) CreationParameters(org.apache.ddlutils.platform.CreationParameters)

Aggregations

Connection (java.sql.Connection)11 Platform (org.apache.ddlutils.Platform)11 Database (org.apache.ddlutils.model.Database)11 DdlGenerator (siena.jdbc.ddl.DdlGenerator)11 Properties (java.util.Properties)10 BasicDataSource (org.apache.commons.dbcp.BasicDataSource)8 JdbcPersistenceManager (siena.jdbc.JdbcPersistenceManager)5 H2PersistenceManager (siena.jdbc.H2PersistenceManager)3 PostgresqlPersistenceManager (siena.jdbc.PostgresqlPersistenceManager)3 CreationParameters (org.apache.ddlutils.platform.CreationParameters)2