コード例 #1
0
 /**
  * Create foreign keys from table.
  *
  * @param table
  * @uses schema
  * @throws SQLException
  */
 @Override
 protected void buildForeignKeys(final DatabaseTable table) throws SQLException {
   final ResultSet resultSet =
       dbmd.getImportedKeys(null, getSchemaSpacePattern(), table.getTitle());
   while (resultSet.next()) {
     final ForeignKey foreign = new ForeignKey(resultSet.getString(12));
     foreign.setColumn(resultSet.getString(8));
     foreign.setReferToTable(resultSet.getString(3));
     foreign.setReferToColumn(resultSet.getString(4));
     schema.addForeignKey(foreign);
   }
   resultSet.close();
 }
コード例 #2
0
  /**
   * Create primary keys from table.
   *
   * @param table
   * @uses schema
   * @throws SQLException
   */
  @Override
  protected void buildPrimaryKeys(final DatabaseTable table) throws SQLException {
    PrimaryKey primary = null;

    final ResultSet resultSet =
        dbmd.getPrimaryKeys(null, getSchemaSpacePattern(), table.getTitle());
    while (resultSet.next()) {
      if (primary == null) {
        primary = new PrimaryKey(resultSet.getString(6));
      }
      primary.addColumn(resultSet.getString(4));
    }
    resultSet.close();

    if (primary != null) {
      schema.addPrimaryKey(primary);
    }
  }
コード例 #3
0
  /**
   * Create unique keys keys from table.
   *
   * @param table
   * @uses schema
   * @throws SQLException
   */
  @Override
  protected void buildUniqueKeys(final DatabaseTable table) throws SQLException {

    final List<UniqueKey> uniqueKeys = new ArrayList<UniqueKey>();
    final List<Index> indices = new ArrayList<Index>();

    // For each result, create a key if 9th value (name) is present and not already exists.
    final ResultSet resultSet =
        dbmd.getIndexInfo(null, getSchemaSpacePattern(), table.getTitle(), false, false);
    while (resultSet.next()) {
      if (resultSet.getString(9) != null) {
        if (resultSet.getBoolean(4)) {
          Index index = new Index(resultSet.getString(6));
          if (indices.contains(index)) {
            index = indices.get(indices.indexOf(index));
          } else {
            indices.add(index);
          }
          index.addColumn(resultSet.getString(9));
        } else {
          UniqueKey uniqueKey = new UniqueKey(resultSet.getString(6));
          if (uniqueKeys.contains(uniqueKey)) {
            // If already in the list, get that key instead of the
            // one
            // above.
            uniqueKey = uniqueKeys.get(uniqueKeys.indexOf(uniqueKey));
          } else {
            uniqueKeys.add(uniqueKey);
          }
          uniqueKey.addColumn(resultSet.getString(9));
        }
      }
    }
    resultSet.close();

    // Add them all to the schema.
    for (final UniqueKey uniqueKey : uniqueKeys) {
      schema.addUniqueKey(uniqueKey);
    }
    for (final Index index : indices) {
      schema.addIndex(index);
    }
  }
コード例 #4
0
  @Override
  protected void analyzeTriggers() throws SQLException {
    for (final DatabaseTrigger trigger : triggers) {
      firePropertyChange("analyzingTrigger", trigger.getTitle());

      // Create a new ddlschema object.
      final TriggerSchemaEditable schema = trigger.createTriggerSchemaEditableObject();

      // Get all trigger data.
      final String[] data = triggerData.get(trigger.getTitle());

      // 1 trigger_name, 2 trigger_type, 3 triggering_event, 4 table_owner, 5 base_object_type, 6
      // table_name, 7
      // column_name, 8 referencing_names, 9 when_clause, 10 status, 11 description, 12 action_type,
      // 13
      // trigger_body, 14 crossedition, 15 before_statement, 16 before_row, 17 after_row, 18
      // after_statement, 19
      // instead_of_row
      // 1 trigger_name, 2 event_manipulation, 3 definer, 4 event_object_table, 5 action_statement,
      // 6
      // action_timing

      schema.setName(trimStringOrNull(data[1 - 1]));
      schema.setType(trimStringOrNull(data[6 - 1]));
      schema.setEvents(Arrays.asList(trimStringOrNull(data[2 - 1]).split("(OR)")));
      schema.setTableOwner(trimStringOrNull(data[3 - 1]));
      // schema.setBaseObjectType(trimStringOrNull(data[5 - 1]));
      schema.setTableName(trimStringOrNull(data[4 - 1]));
      // schema.setColumnName(trimStringOrNull(data[7 - 1]));
      // schema.setReferencingNames(trimStringOrNull(data[8 - 1]));
      // schema.setWhenClause(trimStringOrNull(data[9 - 1]));
      schema.setEnabled(true);
      // schema.setDescription(trimStringOrNull(data[11 - 1]));
      // schema.setActionType(trimStringOrNull(data[12 - 1]));

      // MySQL deletes the ending semicolon of the trigger-body, so we added it again
      schema.setBody(trimStringOrNull(data[5 - 1]) + ";");

      // schema.setCrossEdition(!"NO".equalsIgnoreCase(trimStringOrNull(data[14 - 1])));
      // schema.setInsteadOfRow(!"NO".equalsIgnoreCase(trimStringOrNull(data[19 - 1])));

      // This columns are always "NO" and seem not containing the right information. As workaround,
      // we scan the
      // type column's content.
      // schema.setBeforeStatement(!"NO".equalsIgnoreCase(trimStringOrNull(data[15 - 1])));
      // schema.setBeforeRow(!"NO".equalsIgnoreCase(trimStringOrNull(data[16 - 1])));
      // schema.setAfterRow(!"NO".equalsIgnoreCase(trimStringOrNull(data[17 - 1])));
      // schema.setAfterStatement(!"NO".equalsIgnoreCase(trimStringOrNull(data[18 - 1])));
      // schema.setBeforeStatement(compareModeStrings(data[2 - 1], "BEFORE STATEMENT"));
      // schema.setBeforeRow(compareModeStrings(data[6 - 1], "BEFORE"));
      // schema.setAfterRow(compareModeStrings(data[6 - 1], "AFTER"));
      // schema.setAfterStatement(compareModeStrings(data[2 - 1], "AFTER STATEMENT"));
      // schema.setInsteadOfRow(compareModeStrings(data[2 - 1], "INSTEAD OF"));
      // Save the trigger schema.
      trigger.setTriggerSchemaObject(schema);

      // Add the trigger to the corresponding table. Otherwise ignore this trigger
      final DatabaseTable table = schema.getTable();
      if (table != null) {
        final DdlSchemaEditable ddlschema = table.createDdlSchemaEditableObject();
        ddlschema.addTrigger(schema.getName());
        table.setDdlSchemaObject(ddlschema);
      } else {
        trigger.getConnection().removeTrigger(trigger);
        triggers.remove(trigger);
      }
    }
  }