Examples of DBColumnInfo

org.apache.ambari.server.orm.DBAccessor.DBColumnInfo

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo


    // ========================================================================
    // Create tables


    // ClusterConfigMapping
    columns.add(new DBColumnInfo("cluster_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("type_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("version_tag", String.class, 255, null, false));
    columns.add(new DBColumnInfo("create_timestamp", Long.class, null, null, false));
    columns.add(new DBColumnInfo("selected", Integer.class, 0, null, false));
    columns.add(new DBColumnInfo("user_name", String.class, 255, "_db", false));


    dbAccessor.createTable("clusterconfigmapping", columns, "cluster_id", "type_name", "create_timestamp");


    // Request
    columns.clear();
    columns.add(new DBColumnInfo("request_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("cluster_id", Long.class, null, null, true));
    columns.add(new DBColumnInfo("request_schedule_id", Long.class, null, null, true));
    columns.add(new DBColumnInfo("command_name", String.class, 255, null, true));
    columns.add(new DBColumnInfo("create_time", Long.class, null, null, true));
    columns.add(new DBColumnInfo("end_time", Long.class, null, null, true));
    columns.add(new DBColumnInfo("inputs", byte[].class, null, null, true));
    columns.add(new DBColumnInfo("request_context", String.class, 255, null, true));
    columns.add(new DBColumnInfo("request_type", String.class, 255, null, true));
    columns.add(new DBColumnInfo("start_time", Long.class, null, null, false));
    columns.add(new DBColumnInfo("status", String.class, 255));


    dbAccessor.createTable("request", columns, "request_id");


    // RequestSchedule
    columns.clear();
    columns.add(new DBColumnInfo("schedule_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("cluster_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("description", String.class, 255, null, true));
    columns.add(new DBColumnInfo("status", String.class, 255, null, true));
    columns.add(new DBColumnInfo("batch_separation_seconds", Integer.class, null, null, true));
    columns.add(new DBColumnInfo("batch_toleration_limit", Integer.class, null, null, true));
    columns.add(new DBColumnInfo("create_user", String.class, 255, null, true));
    columns.add(new DBColumnInfo("create_timestamp", Long.class, null, null, true));
    columns.add(new DBColumnInfo("update_user", String.class, 255, null, true));
    columns.add(new DBColumnInfo("update_timestamp", Long.class, null, null, true));
    columns.add(new DBColumnInfo("minutes", String.class, 10, null, true));
    columns.add(new DBColumnInfo("hours", String.class, 10, null, true));
    columns.add(new DBColumnInfo("days_of_month", String.class, 10, null, true));
    columns.add(new DBColumnInfo("month", String.class, 10, null, true));
    columns.add(new DBColumnInfo("day_of_week", String.class, 10, null, true));
    columns.add(new DBColumnInfo("yearToSchedule", String.class, 10, null, true));
    columns.add(new DBColumnInfo("startTime", String.class, 50, null, true));
    columns.add(new DBColumnInfo("endTime", String.class, 50, null, true));
    columns.add(new DBColumnInfo("last_execution_status", String.class, 255, null, true));


    dbAccessor.createTable("requestschedule", columns, "schedule_id");


    // RequestScheduleBatchRequest
    columns.clear();
    columns.add(new DBColumnInfo("schedule_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("batch_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("request_id", Long.class, null, null, true));
    columns.add(new DBColumnInfo("request_type", String.class, 255, null, true));
    columns.add(new DBColumnInfo("request_uri", String.class, 1024, null, true));
    columns.add(new DBColumnInfo("request_body", byte[].class, null, null, true));
    columns.add(new DBColumnInfo("request_status", String.class, 255, null, true));
    columns.add(new DBColumnInfo("return_code", Integer.class, null, null, true));
    columns.add(new DBColumnInfo("return_message", String.class, 2000, null, true));


    dbAccessor.createTable("requestschedulebatchrequest", columns, "schedule_id", "batch_id");


    // HostConfigMapping
    columns.clear();
    columns.add(new DBColumnInfo("cluster_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("host_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("type_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("version_tag", String.class, 255, null, true));
    columns.add(new DBColumnInfo("service_name", String.class, 255, null, true));
    columns.add(new DBColumnInfo("create_timestamp", Long.class, null, null, false));
    columns.add(new DBColumnInfo("selected", Integer.class, 0, null, false));


    dbAccessor.createTable("hostconfigmapping", columns, "cluster_id", "host_name", "type_name", "create_timestamp");


    // Sequences
    columns.clear();
    columns.add(new DBColumnInfo("sequence_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("value", Long.class, null, null, false));


    dbAccessor.createTable("ambari_sequences", columns, "sequence_name");


    // Metainfo


    columns.clear();
    columns.add(new DBColumnInfo("metainfo_key", String.class, 255, null, false));
    columns.add(new DBColumnInfo("metainfo_value", String.class, 255, null, false));


    dbAccessor.createTable("metainfo", columns, "metainfo_key");


    // ConfigGroup
    columns.clear();
    columns.add(new DBColumnInfo("group_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("cluster_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("group_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("tag", String.class, 1024, null, false));
    columns.add(new DBColumnInfo("description", String.class, 1024, null, true));
    columns.add(new DBColumnInfo("create_timestamp", Long.class, null, null, false));


    dbAccessor.createTable("configgroup", columns, "group_id");


    // ConfigGroupClusterConfigMapping
    columns.clear();
    columns.add(new DBColumnInfo("config_group_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("cluster_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("config_type", String.class, 255, null, false));
    columns.add(new DBColumnInfo("version_tag", String.class, 255, null, false));
    columns.add(new DBColumnInfo("user_name", String.class, 255, "_db", true));
    columns.add(new DBColumnInfo("create_timestamp", Long.class, null, null, false));


    dbAccessor.createTable("confgroupclusterconfigmapping", columns, "config_group_id", "cluster_id", "config_type");


    // ConfigGroupHostMapping
    columns.clear();
    columns.add(new DBColumnInfo("config_group_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("host_name", String.class, 255, null, false));


    dbAccessor.createTable("configgrouphostmapping", columns, "config_group_id", "host_name");


    // Blueprint
    columns.clear();
    columns.add(new DBColumnInfo("blueprint_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("stack_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("stack_version", String.class, 255, null, false));


    dbAccessor.createTable("blueprint", columns, "blueprint_name");


    // Blueprint Config
    columns.clear();
    columns.add(new DBColumnInfo("blueprint_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("type_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("config_data", byte[].class, null, null, false));


    dbAccessor.createTable("blueprint_configuration", columns, "blueprint_name", "type_name");


    // HostGroup
    columns.clear();
    columns.add(new DBColumnInfo("blueprint_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("cardinality", String.class, 255, null, false));


    dbAccessor.createTable("hostgroup", columns, "blueprint_name", "name");


    // HostGroupComponent
    columns.clear();
    columns.add(new DBColumnInfo("blueprint_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("hostgroup_name", String.class, 255, null, false));
    columns.add(new DBColumnInfo("name", String.class, 255, null, false));


    dbAccessor.createTable("hostgroup_component", columns, "blueprint_name", "hostgroup_name", "name");


    // RequestResourceFilter
    columns.clear();
    columns.add(new DBColumnInfo("filter_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("request_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("service_name", String.class, 255, null, true));
    columns.add(new DBColumnInfo("component_name", String.class, 255, null, true));
    columns.add(new DBColumnInfo("hosts", byte[].class, null, null, true));


    dbAccessor.createTable("requestresourcefilter", columns, "filter_id");


    createQuartzTables();


    // ========================================================================
    // Add columns


    dbAccessor.addColumn("hostcomponentdesiredstate", new DBColumnInfo("maintenance_state", String.class, 32, "OFF", false));
    dbAccessor.addColumn("servicedesiredstate", new DBColumnInfo("maintenance_state", String.class, 32, "OFF", false));
    dbAccessor.addColumn("hoststate", new DBColumnInfo("maintenance_state", String.class, 512, null, true));
    dbAccessor.addColumn("hostcomponentdesiredstate", new DBColumnInfo("admin_state", String.class, 32, null, true));
    dbAccessor.addColumn("hosts", new DBColumnInfo("ph_cpu_count", Integer.class, 32, null, true));
    dbAccessor.addColumn("clusterstate", new DBColumnInfo("current_stack_version", String.class, 255, null, false));
    dbAccessor.addColumn("hostconfigmapping", new DBColumnInfo("user_name", String.class, 255, "_db", false));
    dbAccessor.addColumn("stage", new DBColumnInfo("request_context", String.class, 255, null, true));
    dbAccessor.addColumn("stage", new DBColumnInfo("cluster_host_info", byte[].class, null, null, true));
    dbAccessor.addColumn("clusterconfigmapping", new DBColumnInfo("user_name", String.class, 255, "_db", false));
    dbAccessor.addColumn("host_role_command", new DBColumnInfo("end_time", Long.class, null, null, true));
    dbAccessor.addColumn("host_role_command", new DBColumnInfo("structured_out", byte[].class, null, null, true));
    dbAccessor.addColumn("host_role_command", new DBColumnInfo("command_detail", String.class, 255, null, true));
    dbAccessor.addColumn("host_role_command", new DBColumnInfo("custom_command_name", String.class, 255, null, true));


    // Alter columns


    if (dbType.equals(Configuration.POSTGRES_DB_NAME)) {
      if (dbAccessor.tableExists("hostcomponentdesiredconfigmapping")) {

View Full Code Here

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo


  private void createMyTable(String tableName) throws Exception {
    DBAccessorImpl dbAccessor = injector.getInstance(DBAccessorImpl.class);


    List<DBColumnInfo> columns = new ArrayList<DBColumnInfo>();
    columns.add(new DBColumnInfo("id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("name", String.class, 20000, null, true));
    columns.add(new DBColumnInfo("time", Long.class, null, null, true));


    dbAccessor.createTable(tableName, columns, "id");
  }

View Full Code Here

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo

    String tableName = getFreeTableName();
    createMyTable(tableName);
    DBAccessorImpl dbAccessor = injector.getInstance(DBAccessorImpl.class);


    List<DBColumnInfo> columns = new ArrayList<DBColumnInfo>();
    columns.add(new DBColumnInfo("fid", Long.class, null, null, false));
    columns.add(new DBColumnInfo("fname", String.class, null, null, false));


    String foreignTableName = getFreeTableName();
    dbAccessor.createTable(foreignTableName, columns, "fid");


    dbAccessor.addFKConstraint(foreignTableName, "MYFKCONSTRAINT", "fid",

View Full Code Here

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo

  public void testAddColumn() throws Exception {
    String tableName = getFreeTableName();
    createMyTable(tableName);
    DBAccessorImpl dbAccessor = injector.getInstance(DBAccessorImpl.class);


    DBColumnInfo dbColumnInfo = new DBColumnInfo("description", String.class,
      null, null, true);


    dbAccessor.addColumn(tableName, dbColumnInfo);


    Statement statement = dbAccessor.getConnection().createStatement();

View Full Code Here

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo

    createMyTable(tableName);


    DBAccessorImpl dbAccessor = injector.getInstance(DBAccessorImpl.class);


    List<DBColumnInfo> columns = new ArrayList<DBColumnInfo>();
    columns.add(new DBColumnInfo("fid", Long.class, null, null, false));
    columns.add(new DBColumnInfo("fname", String.class, null, null, false));


    String foreignTableName = getFreeTableName();
    dbAccessor.createTable(foreignTableName, columns, "fid");


    Statement statement = dbAccessor.getConnection().createStatement();

View Full Code Here

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo

    createMyTable(tableName);
    DBAccessorImpl dbAccessor = injector.getInstance(DBAccessorImpl.class);


    dbAccessor.executeQuery("insert into " + tableName + "(id, name, time) values(1, 'Bob', 1234567)");


    dbAccessor.renameColumn(tableName, "time", new DBColumnInfo("new_time", Long.class, 0, null, true));


    Statement statement = dbAccessor.getConnection().createStatement();
    ResultSet resultSet = statement.executeQuery("select new_time from " + tableName + " where id=1");
    int count = 0;
    while (resultSet.next()) {

View Full Code Here

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo

    createMyTable(tableName);
    DBAccessorImpl dbAccessor = injector.getInstance(DBAccessorImpl.class);


    dbAccessor.executeQuery("insert into " + tableName + "(id, name, time) values(1, 'Bob', 1234567)");


    dbAccessor.alterColumn(tableName, new DBColumnInfo("name", String.class, 25000));


  }

View Full Code Here

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo

    createMyTable(tableName);
    DBAccessorImpl dbAccessor = injector.getInstance(DBAccessorImpl.class);


    dbAccessor.executeQuery("insert into " + tableName + "(id, name, time) values(1, 'Bob', 1234567)");


    dbAccessor.addColumn(tableName, new DBColumnInfo("test", String.class, 1000, "test", false));


    Statement statement = dbAccessor.getConnection().createStatement();
    ResultSet resultSet = statement.executeQuery("select * from " + tableName);
    int count = 0;
    while (resultSet.next()) {

View Full Code Here

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo

  public void testSetNullable() throws Exception {
    String tableName = getFreeTableName();
    createMyTable(tableName);
    DBAccessorImpl dbAccessor = injector.getInstance(DBAccessorImpl.class);


    dbAccessor.addColumn(tableName, new DBColumnInfo("isNullable",
        String.class, 1000, "test", false));


    Statement statement = dbAccessor.getConnection().createStatement();
    ResultSet resultSet = statement.executeQuery("SELECT isNullable FROM "
        + tableName);

View Full Code Here

Examples of org.apache.ambari.server.orm.DBAccessor.DBColumnInfo


    List<DBColumnInfo> columns;


    // Operation level
    columns = new ArrayList<DBColumnInfo>();
    columns.add(new DBColumnInfo("operation_level_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("request_id", Long.class, null, null, false));
    columns.add(new DBColumnInfo("level_name", String.class, 255, null, true));
    columns.add(new DBColumnInfo("cluster_name", String.class, 255, null, true));
    columns.add(new DBColumnInfo("service_name", String.class, 255, null, true));
    columns.add(new DBColumnInfo("host_component_name", String.class, 255, null, true));
    columns.add(new DBColumnInfo("host_name", String.class, 255, null, true));


    dbAccessor.createTable("requestoperationlevel", columns, "operation_level_id");


    // 1.6.0 initially shipped with restart_required as a BOOELAN so some
    // upgrades might be BOOLEAN but most are probably SMALLINT
    if (Configuration.POSTGRES_DB_NAME.equals(dbType)) {
      int columnType = dbAccessor.getColumnType("hostcomponentdesiredstate",
          "restart_required");


      if (columnType == Types.BOOLEAN || columnType == Types.BIT) {
        dbAccessor.executeQuery(
            "ALTER TABLE hostcomponentdesiredstate ALTER column restart_required TYPE SMALLINT USING CASE WHEN restart_required=true THEN 1 ELSE 0 END",
            true);
      }
    }


    if (Configuration.ORACLE_DB_NAME.equals(dbType)) {
      dbAccessor.executeQuery(
          "ALTER TABLE hostcomponentdesiredstate MODIFY (restart_required DEFAULT 0)",
          true);


    } else {
      dbAccessor.executeQuery(
          "ALTER TABLE hostcomponentdesiredstate ALTER column restart_required SET DEFAULT 0",
          true);
    }


    //=========================================================================
    // Add columns
    dbAccessor.addColumn("viewmain",
        new DBAccessor.DBColumnInfo("icon", String.class, 255, null, true));


    dbAccessor.addColumn("viewmain",
        new DBAccessor.DBColumnInfo("icon64", String.class, 255, null, true));


    dbAccessor.addColumn("viewinstancedata",
        new DBAccessor.DBColumnInfo("user_name", String.class, 255, " ", false));


    dbAccessor.dropConstraint("viewinstancedata", "FK_viewinstdata_view_name");
    dbAccessor.dropConstraint("viewinstanceproperty", "FK_viewinstprop_view_name");
    dbAccessor.dropConstraint("viewentity", "FK_viewentity_view_name");


    //modify primary key of viewinstancedata
    if (Configuration.ORACLE_DB_NAME.equals(dbType)
        || Configuration.MYSQL_DB_NAME.equals(dbType)
        || Configuration.DERBY_DB_NAME.equals(dbType)) {
      dbAccessor.executeQuery("ALTER TABLE viewinstance DROP PRIMARY KEY", true);
      dbAccessor.executeQuery("ALTER TABLE viewinstancedata DROP PRIMARY KEY", true);
    } else if (Configuration.POSTGRES_DB_NAME.equals(dbType)) {
      dbAccessor.executeQuery("ALTER TABLE viewinstance DROP CONSTRAINT viewinstance_pkey CASCADE", true);
      dbAccessor.executeQuery("ALTER TABLE viewinstancedata DROP CONSTRAINT viewinstancedata_pkey CASCADE", true);
    }




    dbAccessor.addColumn("viewinstance", new DBAccessor.DBColumnInfo("view_instance_id", Long.class, null, null, true));
    dbAccessor.addColumn("viewinstancedata",
      new DBAccessor.DBColumnInfo("view_instance_id", Long.class, null, null, true));


    if (Configuration.ORACLE_DB_NAME.equals(dbType)) {
      //sequence looks to be simpler than rownum
      if (dbAccessor.tableHasData("viewinstancedata")) {
        dbAccessor.executeQuery("CREATE SEQUENCE TEMP_SEQ " +
            "  START WITH 1 " +
            "  MAXVALUE 999999999999999999999999999 " +
            "  MINVALUE 1 " +
            "  NOCYCLE " +
            "  NOCACHE " +
            "  NOORDER");
        dbAccessor.executeQuery("UPDATE viewinstance SET view_instance_id = TEMP_SEQ.NEXTVAL");
        dbAccessor.dropSequence("TEMP_SEQ");
      }
    } else if (Configuration.MYSQL_DB_NAME.equals(dbType)) {
      if (dbAccessor.tableHasData("viewinstance")) {
        dbAccessor.executeQuery("UPDATE viewinstance " +
            "SET view_instance_id = (SELECT @a := @a + 1 FROM (SELECT @a := 1) s)");
      }
    } else if (Configuration.POSTGRES_DB_NAME.equals(dbType)) {
      if (dbAccessor.tableHasData("viewinstance")) {
        //window functions like row_number were added in 8.4, workaround for earlier versions (redhat/centos 5)
        dbAccessor.executeQuery("CREATE SEQUENCE temp_seq START WITH 1");
        dbAccessor.executeQuery("UPDATE viewinstance SET view_instance_id = nextval('temp_seq')");
        dbAccessor.dropSequence("temp_seq");
      }




    }


    if (Configuration.DERBY_DB_NAME.equals(dbType)) {
      dbAccessor.executeQuery("ALTER TABLE viewinstance ALTER COLUMN view_instance_id DEFAULT 0");
      dbAccessor.executeQuery("ALTER TABLE viewinstance ALTER COLUMN view_instance_id NOT NULL");
      dbAccessor.executeQuery("ALTER TABLE viewinstancedata ALTER COLUMN view_instance_id DEFAULT 0");
      dbAccessor.executeQuery("ALTER TABLE viewinstancedata ALTER COLUMN view_instance_id NOT NULL");
      dbAccessor.executeQuery("ALTER TABLE viewinstancedata ALTER COLUMN user_name DEFAULT ' '");
      dbAccessor.executeQuery("ALTER TABLE viewinstancedata ALTER COLUMN user_name NOT NULL");
    }


    dbAccessor.executeQuery("alter table viewinstance add primary key (view_instance_id)");
    dbAccessor.executeQuery("ALTER TABLE viewinstance ADD CONSTRAINT UQ_viewinstance_name UNIQUE (view_name, name)", true);
    dbAccessor.executeQuery("ALTER TABLE viewinstance ADD CONSTRAINT UQ_viewinstance_name_id UNIQUE (view_instance_id, view_name, name)", true);


    dbAccessor.addFKConstraint("viewinstanceproperty", "FK_viewinstprop_view_name",
        new String[]{"view_name", "view_instance_name"}, "viewinstance", new String[]{"view_name", "name"}, true);
    dbAccessor.addFKConstraint("viewentity", "FK_viewentity_view_name",
        new String[]{"view_name", "view_instance_name"}, "viewinstance", new String[]{"view_name", "name"}, true);


    if (Configuration.POSTGRES_DB_NAME.equals(dbType)) {
      dbAccessor.executeQuery("UPDATE viewinstancedata " +
        "SET view_instance_id = vi.view_instance_id FROM viewinstance AS vi " +
        "WHERE vi.name = viewinstancedata.view_instance_name AND vi.view_name = viewinstancedata.view_name");
    } else if (Configuration.ORACLE_DB_NAME.equals(dbType)) {
      dbAccessor.executeQuery("UPDATE viewinstancedata vid SET view_instance_id = (" +
        "SELECT view_instance_id FROM viewinstance vi WHERE vi.name = vid.view_instance_name AND vi.view_name = vid.view_name)");
    } else if (Configuration.MYSQL_DB_NAME.equals(dbType)) {
      dbAccessor.executeQuery("UPDATE viewinstancedata AS vid JOIN viewinstance AS vi " +
        "ON vi.name = vid.view_instance_name AND vi.view_name = vid.view_name " +
        "SET vid.view_instance_id = vi.view_instance_id");
    }


    dbAccessor.executeQuery("alter table viewinstancedata add primary key (view_instance_id, name, user_name)");


    dbAccessor.addFKConstraint("viewinstancedata", "FK_viewinstdata_view_name", new String[]{"view_instance_id", "view_name", "view_instance_name"},
      "viewinstance", new String[]{"view_instance_id", "view_name", "name"}, true);




    long count = 1;
    ResultSet resultSet = null;
    try {
      resultSet = dbAccessor.executeSelect("SELECT count(*) FROM viewinstance");
      if (resultSet.next()) {
        count = resultSet.getLong(1) + 2;
      }
    } finally {
      if (resultSet != null) {
        resultSet.close();
      }
    }


    String valueColumnName = "\"value\"";
    if (Configuration.ORACLE_DB_NAME.equals(dbType)
        || Configuration.MYSQL_DB_NAME.equals(dbType)) {
      valueColumnName = "value";
    }


    dbAccessor.executeQuery("INSERT INTO ambari_sequences(sequence_name, " + valueColumnName + ") " +
        "VALUES('view_instance_id_seq', " + count + ")", true);


    dbAccessor.addColumn("viewinstance",
        new DBAccessor.DBColumnInfo("label", String.class, 255, null, true));


    dbAccessor.addColumn("viewinstance",
        new DBAccessor.DBColumnInfo("description", String.class, 255, null, true));


    dbAccessor.addColumn("viewinstance",
        new DBAccessor.DBColumnInfo("visible", Character.class, 1, null, true));


    dbAccessor.addColumn("viewinstance",
        new DBAccessor.DBColumnInfo("icon", String.class, 255, null, true));


    dbAccessor.addColumn("viewinstance",
        new DBAccessor.DBColumnInfo("icon64", String.class, 255, null, true));


    // ========================================================================
    // Add constraints
    dbAccessor.addFKConstraint("requestoperationlevel", "FK_req_op_level_req_id",
            "request_id", "request", "request_id", true);
    
    // Clusters
    dbAccessor.addColumn("clusters", new DBColumnInfo("provisioning_state", String.class, 255, State.INIT.name(), false));    
    
    dbAccessor.dropConstraint("stage", "FK_stage_cluster_id", true);
    dbAccessor.dropConstraint("request", "FK_request_cluster_id", true);
  }

View Full Code Here

0 1 2

TOP

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.