Ejemplo n.º 1
0
  private SQLCompletionProposal makeProposalsFromObject(
      DBPNamedObject object, @Nullable DBPImage objectIcon) {
    String objectName = DBUtils.getObjectFullName(object);

    StringBuilder info = new StringBuilder();
    PropertyCollector collector = new PropertyCollector(object, false);
    collector.collectProperties();
    for (DBPPropertyDescriptor descriptor : collector.getPropertyDescriptors2()) {
      Object propValue = collector.getPropertyValue(descriptor.getId());
      if (propValue == null) {
        continue;
      }
      String propString = propValue.toString();
      info.append("<b>").append(descriptor.getDisplayName()).append(":  </b>");
      info.append(propString);
      info.append("<br>");
    }

    boolean isSingleObject = true;
    String replaceString = null;
    DBPDataSource dataSource = editor.getDataSource();
    if (dataSource != null) {
      // If we replace short name with referenced object
      // and current active schema (catalog) is not this object's container then
      // replace with full qualified name
      if (!getPreferences().getBoolean(SQLPreferenceConstants.PROPOSAL_SHORT_NAME)
          && object instanceof DBSObjectReference) {
        if (wordDetector.getFullWord().indexOf(editor.getSyntaxManager().getStructSeparator())
            == -1) {
          DBSObjectReference structObject = (DBSObjectReference) object;
          if (structObject.getContainer() != null) {
            DBSObject selectedObject = getSelectedObject(dataSource);
            if (selectedObject != structObject.getContainer()) {
              replaceString =
                  DBUtils.getFullQualifiedName(dataSource, structObject.getContainer(), object);
              isSingleObject = false;
            }
          }
        }
      }
      if (replaceString == null) {
        replaceString = DBUtils.getQuotedIdentifier(dataSource, object.getName());
      }
    } else {
      replaceString = DBUtils.getObjectShortName(object);
    }
    return createCompletionProposal(
        replaceString, objectName, info.toString(), objectIcon, isSingleObject, object);
  }
Ejemplo n.º 2
0
 @Override
 public void appendModifier(
     OBJECT_TYPE column, StringBuilder sql, DBECommandAbstract<OBJECT_TYPE> command) {
   if (column.isRequired()) {
     sql.append(" NOT NULL"); // $NON-NLS-1$
   }
 }
Ejemplo n.º 3
0
        @Override
        public void appendModifier(
            OBJECT_TYPE column, StringBuilder sql, DBECommandAbstract<OBJECT_TYPE> command) {
          String defaultValue = CommonUtils.toString(column.getDefaultValue());
          if (!CommonUtils.isEmpty(defaultValue)) {
            boolean useQuotes =
                column.getDataKind() == DBPDataKind.STRING
                    || column.getDataKind() == DBPDataKind.DATETIME;

            if (useQuotes && defaultValue.trim().startsWith(QUOTE)) {
              useQuotes = false;
            }

            sql.append(" DEFAULT "); // $NON-NLS-1$
            if (useQuotes) sql.append(QUOTE);
            sql.append(defaultValue);
            if (useQuotes) sql.append(QUOTE);
          }
        }
Ejemplo n.º 4
0
 @Override
 public void appendModifier(
     OBJECT_TYPE column, StringBuilder sql, DBECommandAbstract<OBJECT_TYPE> command) {
   final String typeName = column.getTypeName();
   DBPDataKind dataKind = column.getDataKind();
   final DBSDataType dataType = findDataType(column.getDataSource(), typeName);
   sql.append(' ').append(typeName);
   if (dataType == null) {
     log.debug(
         "Type name '"
             + typeName
             + "' is not supported by driver"); //$NON-NLS-1$ //$NON-NLS-2$
   } else {
     dataKind = dataType.getDataKind();
   }
   String modifiers = SQLUtils.getColumnTypeModifiers(column, typeName, dataKind);
   if (modifiers != null) {
     sql.append(modifiers);
   }
 }
Ejemplo n.º 5
0
  @Override
  protected StringBuilder getNestedDeclaration(
      TABLE_TYPE owner, DBECommandAbstract<OBJECT_TYPE> command) {
    OBJECT_TYPE column = command.getObject();

    // Create column
    String columnName = DBUtils.getQuotedIdentifier(column.getDataSource(), column.getName());

    if (command instanceof SQLObjectEditor.ObjectRenameCommand) {
      columnName = ((ObjectRenameCommand) command).getNewName();
    }

    StringBuilder decl = new StringBuilder(40);
    decl.append(columnName);
    for (ColumnModifier modifier : getSupportedModifiers()) {
      modifier.appendModifier(column, decl, command);
    }

    return decl;
  }
Ejemplo n.º 6
0
 @Override
 public void appendModifier(
     OBJECT_TYPE column, StringBuilder sql, DBECommandAbstract<OBJECT_TYPE> command) {
   sql.append(column.isRequired() ? " NOT NULL" : " NULL");
 }