public void setElementSymbolsAsColumns(List<ElementSymbol> columns) { this.columns.clear(); for (ElementSymbol elementSymbol : columns) { Column c = new Column(); c.setName(elementSymbol.getShortName()); c.setRuntimeType(DataTypeManager.getDataTypeName(elementSymbol.getType())); c.setNullType(NullType.Nullable); this.columns.add(c); } }
Column c = new Column(); c.setName(expr); c.setNameInSource(expr); setUUID(c);
public void setElementSymbolsAsColumns(List<ElementSymbol> columns) { this.columns.clear(); for (ElementSymbol elementSymbol : columns) { Column c = new Column(); c.setName(elementSymbol.getShortName()); c.setRuntimeType(DataTypeManager.getDataTypeName(elementSymbol.getType())); c.setNullType(NullType.Nullable); this.columns.add(c); } }
public static Column createElement(String name, ColumnSet<?> group, String type) { Column column = new Column(); column.setName(name); group.addColumn(column); column.setRuntimeType(type); if(type.equals(DataTypeManager.DefaultDataTypes.STRING)) { column.setSearchType(SearchType.Searchable); } else if (DataTypeManager.isNonComparable(type)){ column.setSearchType(SearchType.Unsearchable); } else { column.setSearchType(SearchType.All_Except_Like); } column.setNullType(NullType.Nullable); column.setPosition(group.getColumns().size()); //1 based indexing column.setUpdatable(true); column.setDatatype(SystemMetadata.getInstance().getRuntimeTypeMap().get(type), true, 0); if (DataTypeManager.hasLength(type) && !type.equalsIgnoreCase(DataTypeManager.DefaultDataTypes.CHAR)) { column.setLength(100); } column.setNameInSource(name); return column; }
private void loadColumnSetRecords(ColumnSet<?> indexRecord, Map<String, Column> columns) { for (int i = 0; i < indexRecord.getColumns().size(); i++) { String uuid = indexRecord.getColumns().get(i).getUUID(); Column c = null; if (columns != null) { c = columns.get(uuid); } else { c = findElement(uuid); c.setName(RecordFactory.getShortName(c.getName())); } indexRecord.getColumns().set(i, c); if (columns == null) { c.setParent(indexRecord); } } }
public void setElementSymbolsAsColumns(List<ElementSymbol> columns) { this.columns.clear(); for (ElementSymbol elementSymbol : columns) { Column c = new Column(); c.setName(elementSymbol.getShortName()); c.setRuntimeType(DataTypeManager.getDataTypeName(elementSymbol.getType())); c.setNullType(NullType.Nullable); this.columns.add(c); } }
private void loadColumnSetRecords(ColumnSet<?> indexRecord, Map<String, Column> columns) { for (int i = 0; i < indexRecord.getColumns().size(); i++) { String uuid = indexRecord.getColumns().get(i).getUUID(); Column c = null; if (columns != null) { c = columns.get(uuid); } else { c = findElement(uuid); c.setName(RecordFactory.getShortName(c.getName())); } indexRecord.getColumns().set(i, c); if (columns == null) { c.setParent(indexRecord); } } }
column.setName(name); Datatype type = new Datatype(); type.setName(TypeFacility.RUNTIME_NAMES.OBJECT);
column.setName(name); table.addColumn(column); column.setParent(table);
public Column renameColumn(String oldName, String name, ColumnSet<?> table) { if (this.autoCorrectColumnNames) { name = name.replace(AbstractMetadataRecord.NAME_DELIM_CHAR, '_'); } else if (name.indexOf(AbstractMetadataRecord.NAME_DELIM_CHAR) != -1) { throw new MetadataException(DataPlugin.Event.TEIID60008, DataPlugin.Util.gs(DataPlugin.Event.TEIID60008, table.getFullName(), name)); } if (table.getColumnByName(name) != null) { throw new DuplicateRecordException(DataPlugin.Event.TEIID60016, DataPlugin.Util.gs(DataPlugin.Event.TEIID60016, table.getFullName() + AbstractMetadataRecord.NAME_DELIM_CHAR + name)); } Column column = table.getColumnByName(oldName); if (column == null) { throw new MetadataException(DataPlugin.Event.TEIID60011, DataPlugin.Util.gs(DataPlugin.Event.TEIID60011, table.getFullName(), oldName)); } table.removeColumn(column); column.setName(name); table.addColumn(column); return column; }
/** * @see org.teiid.query.sql.lang.Command#clone() * @since 5.5 */ public Object clone() { Create copy = new Create(); GroupSymbol copyTable = table.clone(); copy.setTable(copyTable); copy.columns = new ArrayList<Column>(columns.size()); for (Column column : columns) { Column copyColumn = new Column(); copyColumn.setName(column.getName()); copyColumn.setRuntimeType(column.getRuntimeType()); copyColumn.setAutoIncremented(column.isAutoIncremented()); copyColumn.setNullType(column.getNullType()); copy.columns.add(copyColumn); } copy.primaryKey = LanguageObject.Util.deepClone(primaryKey, ElementSymbol.class); copyMetadataState(copy); copy.setTableMetadata(this.tableMetadata); copy.on = this.on; copy.commitAction = this.commitAction; return copy; }
/** * @see org.teiid.query.sql.lang.Command#clone() * @since 5.5 */ public Object clone() { Create copy = new Create(); GroupSymbol copyTable = table.clone(); copy.setTable(copyTable); copy.columns = new ArrayList<Column>(columns.size()); for (Column column : columns) { Column copyColumn = new Column(); copyColumn.setName(column.getName()); copyColumn.setRuntimeType(column.getRuntimeType()); copyColumn.setAutoIncremented(column.isAutoIncremented()); copyColumn.setNullType(column.getNullType()); copy.columns.add(copyColumn); } copy.primaryKey = LanguageObject.Util.deepClone(primaryKey, ElementSymbol.class); copyMetadataState(copy); copy.setTableMetadata(this.tableMetadata); copy.on = this.on; copy.commitAction = this.commitAction; return copy; }
/** * @see org.teiid.query.sql.lang.Command#clone() * @since 5.5 */ public Object clone() { Create copy = new Create(); GroupSymbol copyTable = table.clone(); copy.setTable(copyTable); copy.columns = new ArrayList<Column>(columns.size()); for (Column column : columns) { Column copyColumn = new Column(); copyColumn.setName(column.getName()); copyColumn.setRuntimeType(column.getRuntimeType()); copyColumn.setAutoIncremented(column.isAutoIncremented()); copyColumn.setNullType(column.getNullType()); copy.columns.add(copyColumn); } copy.primaryKey = LanguageObject.Util.deepClone(primaryKey, ElementSymbol.class); copyMetadataState(copy); copy.setTableMetadata(this.tableMetadata); copy.on = this.on; copy.commitAction = this.commitAction; return copy; }
c.setName(element); c.setRuntimeType(type.type); c.setAutoIncremented(autoIncrement);
c.setName(element); c.setRuntimeType(type.type); c.setAutoIncremented(autoIncrement);
c.setName(element); c.setRuntimeType(type.type); c.setAutoIncremented(autoIncrement);
String fullName = columnRecordImpl.getName(); if (fullName.startsWith(tableRecord.getName() + '.')) { columnRecordImpl.setName(new String(fullName.substring(tableRecord.getName().length() + 1)));
String fullName = columnRecordImpl.getName(); if (fullName.startsWith(tableRecord.getName() + '.')) { columnRecordImpl.setName(new String(fullName.substring(tableRecord.getName().length() + 1)));
@Test public void testForeignTemp() { Create create = new Create(); create.setTable(new GroupSymbol("tempTable")); //$NON-NLS-1$ create.setOn("source"); Table t = new Table(); t.setName("tempTable"); t.setUUID("tid:0"); Column c = new Column(); c.setName("x"); c.setUUID("tid:0"); Datatype string = SystemMetadata.getInstance().getRuntimeTypeMap().get("string"); c.setDatatype(string, true, 0); t.addColumn(c); c = new Column(); c.setName("y"); c.setUUID("tid:0"); Datatype decimal = SystemMetadata.getInstance().getRuntimeTypeMap().get("decimal"); c.setDatatype(decimal, true, 0); t.addColumn(c); t.setCardinality(10000); create.setTableMetadata(t); helpTest("create foreign temporary table tempTable (x string, y decimal) options (cardinality 10000) on source", "CREATE FOREIGN TEMPORARY TABLE tempTable (\n x string,\n y bigdecimal\n) OPTIONS (CARDINALITY 10000) ON 'source'", create); //$NON-NLS-1$ //$NON-NLS-2$ }
for (ElementSymbol es : (List<ElementSymbol>)dynamicCommand.getAsColumns()) { Column c = new Column(); c.setName(es.getShortName()); c.setRuntimeType(DataTypeManager.getDataTypeName(es.getType())); create.getColumns().add(c);