Examples of nexj.core.meta.persistence.sql.upgrade.AlterColumnStep

Package nexj.core.meta.persistence.sql.upgrade

Examples of nexj.core.meta.persistence.sql.upgrade.AlterColumnStep

nexj.core.meta.persistence.sql.upgrade.AlterColumnStep
Upgrade step for altering a column.


               upgrade.addStep(create);
            }
            else if (sElement.equals("AlterColumn"))
            {
               AlterColumnStep alter = new AlterColumnStep();


               alter.setTableName(XMLMetadataHelper.getNameAttr(stepElement, "table", XMLMetadataHelper.NAME_DOT));


               ColumnOutline outline = new ColumnOutline();


               loadColumnOutline(stepElement, outline, false);
               alter.setOutline(outline);


               upgrade.addStep(alter);
            }
            else if (sElement.equals("RenameColumn"))
            {

View Full Code Here

      insert.setSQL(buf.toString()); // ensure at least one row in table
      script.addStatement(insert);
      exec.getScriptHolder().addScript(script);
      upgrade(exec, null, null); // insert a record into the table to test altering an actual value


      AlterColumnStep step = new AlterColumnStep();
      ColumnOutline outline = new ColumnOutline("value");


      outline.setType(to);


      if (bToLOB)
      {
         outline.setAllocation(Column.LOCATOR);
      }
      else
      {
         outline.setAllocation( // set Column.FIXED/Column.VARYING as per original column
            (column1.getAllocation() == Column.LOCATOR) ? Column.VARYING : column1.getAllocation());
      }


      outline.setNullable(Boolean.FALSE);


      if (to == Primitive.BINARY || to == Primitive.STRING)
      {
         outline.setPrecision(100);
         outline.setCaseInsensitive(Boolean.FALSE);
      }


      step.setOutline(outline);
      step.setTableName(m_doubleColTableStep.getName());


      try
      {
         schema = upgrade(step, schema, null);
      }

View Full Code Here

      Column column = table.getColumn(0);


      assertEquals(Primitive.INTEGER, column.getType());
      assertFalse(column.isNullable());


      AlterColumnStep step = new AlterColumnStep();
      ColumnOutline outline = new ColumnOutline("id");


      outline.setType(Primitive.STRING);
      outline.setNullable(Boolean.TRUE);
      step.setOutline(outline);
      step.setTableName(m_singleColTableStep.getName());
      schema = upgrade(step, schema, null);
      table = schema.getTable(m_singleColTableStep.getName());
      assertNotNull(table);
      assertEquals(1, table.getColumnCount());
      column = table.getColumn(0);

View Full Code Here

TOP

Related Classes of nexj.core.meta.persistence.sql.upgrade.AlterColumnStep

nexj.core.meta.persistence.sql.RelationalSchema

nexj.core.meta.persistence.sql.Table

nexj.core.meta.persistence.sql.XMLRelationalMetadataLoader

nexj.core.persistence.sql.SQLSchemaManagerTest

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.