Package org.apache.ddlutils.model

Examples of org.apache.ddlutils.model.Database


      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();
     
View Full Code Here


      for (Class<?> clazz : classes) {
        generator.addTable(clazz);
      }
 
      // get the Database model
      Database database = generator.getDatabase();
 
      Platform platform = PlatformFactory.createNewPlatformInstance("postgresql");
      Class.forName(driver);
      Connection connection = DriverManager.getConnection(url, username, password);
     
View Full Code Here

        DatabaseIO modelReader = new DatabaseIO();

        modelReader.setUseInternalDtd(true);
        modelReader.setValidateXml(false);
       
        Database        model       = modelReader.read(new StringReader(testSchemaXml));
        final ArrayList readObjects = new ArrayList();
        DataReader      dataReader  = new DataReader();

        dataReader.setModel(model);
        dataReader.setSink(new DataSink() {
View Full Code Here

        DatabaseIO modelIO = new DatabaseIO();

        modelIO.setUseInternalDtd(true);
        modelIO.setValidateXml(false);
       
        Database     model      = modelIO.read(new StringReader(testSchemaXml));
        StringWriter output     = new StringWriter();
        DataWriter   dataWriter = new DataWriter(output, "UTF-8");
        SqlDynaBean  bean       = (SqlDynaBean)model.createDynaBeanFor(model.getTable(0));

        bean.set("id", new Integer(1));
        bean.set("value", testedValue);
        dataWriter.writeDocumentStart();
        dataWriter.write(bean);
View Full Code Here

        DatabaseIO modelIO = new DatabaseIO();

        modelIO.setUseInternalDtd(true);
        modelIO.setValidateXml(false);

        Database     model      = modelIO.read(new StringReader(testSchemaXml));
        StringWriter output     = new StringWriter();
        DataWriter   dataWriter = new DataWriter(output, "UTF-8");
        SqlDynaBean  bean       = (SqlDynaBean)model.createDynaBeanFor(model.getTable(0));

        bean.set("id", new Integer(1));
        bean.set("value1", testedValue1);
        bean.set("value2", testedValue2);
        bean.set("value3", testedValue3);
View Full Code Here

            "      <index-column name='Col2'/>\n" +
            "    </index>\n" +
            "  </table>\n" +
            "</database>";

        Database model1  = parseDatabaseFromString(MODEL1);
        Database model2  = parseDatabaseFromString(MODEL2);
        List     changes = createModelComparator(false).compare(model1, model2);

        assertEquals(2,
                     changes.size());
View Full Code Here

            "      <index-column name='Col1'/>\n" +
            "    </index>\n" +
            "  </table>\n" +
            "</database>";

        Database model1  = parseDatabaseFromString(MODEL1);
        Database model2  = parseDatabaseFromString(MODEL2);
        List     changes = createModelComparator(false).compare(model1, model2);

        assertEquals(2,
                     changes.size());
View Full Code Here

            "  <table name='TableA'>\n" +
            "    <column name='ColPK' type='INTEGER' primaryKey='true' required='true'/>\n" +
            "  </table>\n" +
            "</database>";

        Database model1  = parseDatabaseFromString(MODEL1);
        Database model2  = parseDatabaseFromString(MODEL2);
        List     changes = createModelComparator(false).compare(model1, model2);

        assertEquals(1,
                     changes.size());
View Full Code Here

            "  <table name='TableA'>\n" +
            "    <column name='ColPK' type='INTEGER' required='true'/>\n" +
            "  </table>\n" +
            "</database>";

        Database model1  = parseDatabaseFromString(MODEL1);
        Database model2  = parseDatabaseFromString(MODEL2);
        List     changes = createModelComparator(false).compare(model1, model2);

        assertEquals(1,
                     changes.size());
View Full Code Here

            "    <column name='ColPK1' type='INTEGER' primaryKey='true' required='true'/>\n" +
            "    <column name='ColPK2' type='INTEGER' primaryKey='true' required='true'/>\n" +
            "  </table>\n" +
            "</database>";

        Database model1  = parseDatabaseFromString(MODEL1);
        Database model2  = parseDatabaseFromString(MODEL2);
        List     changes = createModelComparator(true).compare(model1, model2);

        assertEquals(1,
                     changes.size());
View Full Code Here

TOP

Related Classes of org.apache.ddlutils.model.Database

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.