public MutableColumn(String name, Table table) { this(name); setTable(table); }
public MutableColumn(String name, Table table) { this(name); setTable(table); }
public MutableColumn(String name, ColumnType type, Table table) { this(name); setType(type); setTable(table); }
public MutableColumn(String name, ColumnType type, Table table) { this(name); setType(type); setTable(table); }
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, Boolean nullable) { this(name, type); setColumnNumber(columnNumber); setTable(table); setNullable(nullable); }
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; }
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; }
columnType = ColumnType.VARCHAR; final MutableColumn column = new MutableColumn(columnName).setType(columnType).setTable(table); table.addColumn(column);
@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 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 MutableTable buildTable() { final int tableObservations = getObservationCount(); // sort column names by copying them to a TreeSet final Set<String> columnNames = new TreeSet<String>(_columnBuilders.keySet()); final MutableTable table = new MutableTable(_tableName); int columnNumber = 0; for (final String columnName : columnNames) { final InferentialColumnBuilder columnBuilder = getColumnBuilder(columnName); final MutableColumn column = columnBuilder.build(); column.setTable(table); column.setColumnNumber(columnNumber); final int columnObservations = columnBuilder.getObservationCount(); if (tableObservations > columnObservations) { // there may be nulls - some records does not even contain the // column column.setNullable(true); } table.addColumn(column); columnNumber++; } return table; }
@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; } };
@Override public MutableTable buildTable() { final int tableObservations = getObservationCount(); // sort column names by copying them to a TreeSet final Set<String> columnNames = new TreeSet<String>(_columnBuilders.keySet()); final MutableTable table = new MutableTable(_tableName); int columnNumber = 0; for (final String columnName : columnNames) { final InferentialColumnBuilder columnBuilder = getColumnBuilder(columnName); final MutableColumn column = columnBuilder.build(); column.setTable(table); column.setColumnNumber(columnNumber); final int columnObservations = columnBuilder.getObservationCount(); if (tableObservations > columnObservations) { // there may be nulls - some records does not even contain the // column column.setNullable(true); } table.addColumn(column); columnNumber++; } return table; }
@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; } };
mutableColumn.setTable(existingTable); mutableColumn.setColumnNumber(columnNumber); mutableColumn.setType(newColumn.getType());
column.setTable(table); column.setColumnNumber(i); column.setNativeType("" + field.getType());
@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); }
column.setTable(SalesforceTable.this); column.setRemarks(columnLabel); column.setNullable(nillable);
column.setTable(SalesforceTable.this); column.setRemarks(columnLabel); column.setNullable(nillable);