public Column toColumn() { final String name = _nameTextField.getText(); final ColumnType columnType = _columnTypeComboBox.getSelectedItem(); final Integer size = getColumnSize(); final boolean primaryKey = _primaryKeyCheckBox.isSelected(); return new MutableColumn(name, columnType).setColumnSize(size).setPrimaryKey(primaryKey).setNullable(_notNull); }
@Override public ColumnCreationBuilder withColumn(String name) { logger.debug("withColumn({})", name); MutableColumn col = (MutableColumn) _table.getColumnByName(name); if (col == null) { col = new MutableColumn(name).setTable(_table).setColumnNumber(_table.getColumnCount()); _table.addColumn(col); } return new ColumnCreationBuilderImpl(this, col); }
@Override public final T like(Column column) { _column.setColumnSize(column.getColumnSize()); _column.setNativeType(column.getNativeType()); _column.setType(column.getType()); _column.setNullable(column.isNullable()); _column.setPrimaryKey(column.isPrimaryKey()); return getReturnObject(); }
public MutableColumn(String name, ColumnType type, Table table, int columnNumber, Boolean nullable) { this(name, type); setColumnNumber(columnNumber); setTable(table); setNullable(nullable); }
public MutableColumn(String name, ColumnType type, Table table, int columnNumber, Integer columnSize, String nativeType, Boolean nullable, String remarks, boolean indexed, String quote) { this(name, type, table, columnNumber, nullable); setColumnSize(columnSize); setNativeType(nativeType); setRemarks(remarks); setIndexed(indexed); setQuote(quote); }
final ColumnType columnType = toColumnType(type); final MutableColumn column = new MutableColumn(columnName, columnType); column.setTable(SalesforceTable.this); column.setRemarks(columnLabel); column.setNullable(nillable); column.setNativeType(type.toString()); column.setColumnSize(columnSize); column.setColumnNumber(i); column.setPrimaryKey(true);
@Override public OutputDataStreamBuilder withColumn(final String name, final ColumnType type) { final int columnNumber = _table.getColumnCount() + 1; final MutableColumn column = new MutableColumn(name, type, _table, columnNumber, true); _table.addColumn(column); return this; }
Field field = dbf.getField(i + 1); MutableColumn column = new MutableColumn(field.getName()); ColumnType columnType = ColumnType.VARCHAR; column.setType(columnType); column.setTable(table); column.setColumnNumber(i); column.setNativeType("" + field.getType()); column.setColumnSize(field.getLength()); table.addColumn(column); } catch (Exception e) {
@Override protected Schema getMainSchema() throws MetaModelException { final MutableSchema schema = new MutableSchema(getMainSchemaName()); for (XmlSaxTableDef tableDef : _tableDefs) { final String rowXpath = tableDef.getRowXpath(); final MutableTable table = new MutableTable(getTableName(tableDef)).setSchema(schema).setRemarks("XPath: " + rowXpath); final MutableColumn rowIndexColumn = new MutableColumn(COLUMN_NAME_ROW_ID, ColumnType.INTEGER) .setColumnNumber(0).setNullable(false).setTable(table).setRemarks("Row/tag index (0-based)"); table.addColumn(rowIndexColumn); for (String valueXpath : tableDef.getValueXpaths()) { final MutableColumn column = new MutableColumn(getName(tableDef, valueXpath)).setRemarks("XPath: " + valueXpath); if (valueXpath.startsWith("index(") && valueXpath.endsWith(")")) { column.setType(ColumnType.INTEGER); } else { column.setType(ColumnType.STRING); } column.setTable(table); table.addColumn(column); } schema.addTable(table); } return new ImmutableSchema(schema); }
@Override protected List<Column> fetch() { final List<Column> result = new ArrayList<Column>(); final String session = sessionId.get(); final NewModuleFields fields = service.getModuleFields(session, _name, new SelectFields()); final FieldList moduleFields = fields.getModuleFields(); final List<Object> list = moduleFields.getAny(); for (Object object : list) { if (object instanceof Node) { final Node node = (Node) object; final String name = SugarCrmXmlHelper.getChildElementText(node, "name"); final String nativeType = SugarCrmXmlHelper.getChildElementText(node, "type"); final String remarks = SugarCrmXmlHelper.getChildElementText(node, "label"); final ColumnType columnType = convertToColumnType(nativeType); final Column column = new MutableColumn(name, columnType).setNativeType(nativeType) .setRemarks(remarks).setTable(SugarCrmTable.this); result.add(column); } } return result; } };
public static Map<String, ?> getMappingSource(final MutableTable table) { if (table.getColumnByName(FIELD_ID) == null) { final MutableColumn idColumn = new MutableColumn(FIELD_ID, ColumnType.STRING).setTable(table).setPrimaryKey( true); table.addColumn(0, idColumn); } final Map<String, Map<String, String>> propertiesMap = new LinkedHashMap<>(); for (Column column : table.getColumns()) { final String columnName = column.getName(); if (FIELD_ID.equals(columnName)) { // do nothing - the ID is a client-side construct continue; } final String fieldName = getValidatedFieldName(columnName); final Map<String, String> propertyMap = new HashMap<>(); final String type = getType(column); propertyMap.put("type", type); propertiesMap.put(fieldName, propertyMap); } HashMap<String, Map<String, Map<String, String>>> docTypeMap = new HashMap<>(); docTypeMap.put("properties", propertiesMap); final Map<String, Map<String, Map<String, Map<String, String>>>> mapping = new HashMap<>(); mapping.put(table.getName(), docTypeMap); return mapping; }
@Override protected Schema getMainSchema() throws MetaModelException { final MutableSchema schema = new MutableSchema(getMainSchemaName()); final Collection<String> topics = topicSupplier.get(); for (String topic : topics) { final MutableTable table = new MutableTable(topic, schema); table.addColumn(new MutableColumn(COLUMN_PARTITION, ColumnType.INTEGER, table).setPrimaryKey(true)); table.addColumn(new MutableColumn(COLUMN_OFFSET, ColumnType.BIGINT, table).setPrimaryKey(true)); table.addColumn(new MutableColumn(COLUMN_TIMESTAMP, ColumnType.TIMESTAMP, table)); table.addColumn(new MutableColumn(COLUMN_KEY, ColumnTypeImpl.convertColumnType(keyClass), table)); table.addColumn(new MutableColumn(COLUMN_VALUE, ColumnTypeImpl.convertColumnType(valueClass), table)); schema.addTable(table); } return schema; }
@Override public MutableColumn build() { final MutableColumn column = new MutableColumn(_name); column.setType(detectType()); if (_nulls) { column.setNullable(true); } return column; }
private MutableColumn getIdColumn(MutableTable table) { MutableColumn column = null; for (Column col : table.getColumns()) { if (NATIVE_TYPE_PRIMARY_KEY.equals(col.getNativeType())) { column = (MutableColumn) col; break; } } if (column == null) { String tableName = table.getName(); logger.info("Creating id column for table: " + tableName); column = new MutableColumn(tableName + "_metamodel_surrogate_id", ColumnType.INTEGER, table, table .getColumnCount(), false); column.setNativeType(NATIVE_TYPE_PRIMARY_KEY); column.setIndexed(true); table.addColumn(column); } return column; }
/** * Verifies, and adds if nescesary, the two mandatory columns: _id and _rev. * * @param table */ public static void addMandatoryColumns(MutableTable table) { // add or correct ID column { MutableColumn idColumn = (MutableColumn) table.getColumnByName(CouchDbDataContext.FIELD_ID); if (idColumn == null) { idColumn = new MutableColumn(CouchDbDataContext.FIELD_ID, ColumnType.VARCHAR, table, 0, false); table.addColumn(0, idColumn); } idColumn.setPrimaryKey(true); idColumn.setNullable(false); } // add or correct _rev column { MutableColumn revColumn = (MutableColumn) table.getColumnByName(CouchDbDataContext.FIELD_REV); if (revColumn == null) { revColumn = new MutableColumn(CouchDbDataContext.FIELD_REV, ColumnType.VARCHAR, table, 1, false); table.addColumn(1, revColumn); } revColumn.setNullable(false); } }
@Override public void column(int columnIndex, String columnName, String columnLabel, SasColumnType columnType, int columnLength) { final ColumnType type; if (columnType == SasColumnType.NUMERIC) { type = ColumnType.NUMERIC; } else if (columnType == SasColumnType.CHARACTER) { type = ColumnType.VARCHAR; } else { type = null; } MutableColumn column = new MutableColumn(columnName, type, _table, columnIndex, true); column.setRemarks(columnLabel); column.setColumnSize(columnLength); _columns.add(column); }
MutableColumn column = (MutableColumn) table.getColumnByName(attributeName); if (column == null) { column = new MutableColumn(attributeName, table); table.addColumn(column); column.setType(DynamoDbUtils.toColumnType(attributeName, attributeType)); column.setIndexed(true); column.setNativeType(attributeType); MutableColumn column = (MutableColumn) table.getColumnByName(columnName); if (column == null) { column = new MutableColumn(columnName, table); table.addColumn(column); if (column.getType() == null && columnType != null) { column.setType(columnType);
columnType = ColumnType.VARCHAR; final MutableColumn column = new MutableColumn(columnName).setType(columnType).setTable(table); table.addColumn(column);
@Override public final T asPrimaryKey() { _column.setPrimaryKey(true); return getReturnObject(); }