private boolean hasColumns(List<String> columnNames, Table table) { for (String columnName:columnNames) { if (table.getColumnByName(columnName) == null) { return false; } } return true; }
private boolean columnExists(String name, Table table) { return table.getColumnByName(name) != null; }
static Column findColumn(Table table, String propertyName) { return table.getColumnByName(propertyName); }
public static Column getColumn(final String elementName, Table table, String shortElementName) throws QueryMetadataException { Column c = table.getColumnByName(shortElementName); if (c != null) { return c; } throw new QueryMetadataException(QueryPlugin.Event.TEIID30356, elementName+TransformationMetadata.NOT_EXISTS_MESSAGE); }
public static Column getColumn(final String elementName, Table table, String shortElementName) throws QueryMetadataException { Column c = table.getColumnByName(shortElementName); if (c != null) { return c; } throw new QueryMetadataException(QueryPlugin.Event.TEIID30356, elementName+TransformationMetadata.NOT_EXISTS_MESSAGE); }
public static Column getColumn(final String elementName, Table table, String shortElementName) throws QueryMetadataException { Column c = table.getColumnByName(shortElementName); if (c != null) { return c; } throw new QueryMetadataException(QueryPlugin.Event.TEIID30356, elementName+TransformationMetadata.NOT_EXISTS_MESSAGE); }
private void assignColumn(Table table, ColumnSet<?> columns, String columnName) { Column column = table.getColumnByName(columnName); if (column == null) { throw new MetadataException(DataPlugin.Event.TEIID60011, DataPlugin.Util.gs(DataPlugin.Event.TEIID60011, table.getFullName(), columnName)); } columns.getColumns().add(column); }
Column getColumn(String columnName, Table table) throws MetadataException { Column c = table.getColumnByName(columnName); if (c != null) { return c; } throw new MetadataException(QueryPlugin.Util.getString("SQLParser.no_column", columnName, table.getName())); //$NON-NLS-1$ }
Column getColumn(String columnName, Table table) throws MetadataException { Column c = table.getColumnByName(columnName); if (c != null) { return c; } throw new MetadataException(QueryPlugin.Util.getString("SQLParser.no_column", columnName, table.getName())); //$NON-NLS-1$ }
Column getColumn(String columnName, Table table) throws MetadataException { Column c = table.getColumnByName(columnName); if (c != null) { return c; } throw new MetadataException(QueryPlugin.Util.getString("SQLParser.no_column", columnName, table.getName())); //$NON-NLS-1$ }
private Column addColumn(MetadataFactory mf, String name, String type, Table entityTable) throws TranslatorException { if (!columnExists(name, entityTable)) { Column c = mf.addColumn(name, type, entityTable); c.setUpdatable(true); return c; } return entityTable.getColumnByName(name); }
private void addForeignKey(MetadataFactory mf, String name, List<String> columnNames, String referenceTable, Table table) throws TranslatorException { ForeignKey fk = mf.addForeignKey("FK_"+name, columnNames, referenceTable, table); for (String column:columnNames) { Column c = table.getColumnByName(column); c.setProperty(KEY_ASSOSIATED_WITH_FOREIGN_TABLE, mf.getName()+Tokens.DOT+referenceTable); } fk.setNameInSource(name); }
@Override public void setColumnStats(String vdbName, String vdbVersion, String schemaName, String tableName, String columnName, ColumnStats stats) { VDBMetaData vdb = getVdbRepository().getLiveVDB(vdbName, vdbVersion); Table t = getTable(vdbName, vdbVersion, schemaName, tableName); if (t == null) { return; } Column c = t.getColumnByName(columnName); if (c != null) { DdlPlan.setColumnStats(vdb, c, stats); } }
private boolean addProperty(MetadataFactory mf, XMLMetadata metadata, Table table, CsdlProperty property) throws TranslatorException { if (isSimple(property.getType()) || isEnum(metadata, property.getType())) { if (table.getColumnByName(property.getName()) == null) { addPropertyAsColumn(mf, table, property); } return true; } return false; }
public void removeColumn(String objectName, Database.ResourceType type, String childName) { if (!assertInEditMode(Mode.SCHEMA)) { return; } Table table = (Table)getSchemaRecord(objectName, type); assertGrant(Grant.Permission.Privilege.ALTER, Database.ResourceType.TABLE, table); Column column = table.getColumnByName(childName); if (column == null) { throw new org.teiid.metadata.MetadataException(QueryPlugin.Event.TEIID31223, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31223, childName)); } table.removeColumn(column); }
public void removeColumn(String objectName, Database.ResourceType type, String childName) { if (!assertInEditMode(Mode.SCHEMA)) { return; } Table table = (Table)getSchemaRecord(objectName, type); assertGrant(Grant.Permission.Privilege.ALTER, Database.ResourceType.TABLE, table); Column column = table.getColumnByName(childName); if (column == null) { throw new org.teiid.metadata.MetadataException(QueryPlugin.Event.TEIID31223, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31223, childName)); } table.removeColumn(column); }
private void verifyTableColumns(ModelMetaData model, ValidatorReport report, MetadataValidator metadataValidator, Table view, Table matView, String ignoreColumnOnMatView) { List<Column> columns = view.getColumns(); for(int i = 0 ; i < columns.size() ; i ++) { Column column = columns.get(i); Column matViewColumn = matView.getColumnByName(column.getName()); if (matViewColumn == null) { metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31193, column.getName(), matView.getFullName(), view.getFullName())); } else if(!column.getDatatypeUUID().equals(matViewColumn.getDatatypeUUID())){ metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31194, matViewColumn.getName(), matView.getFullName(), column.getName(), view.getFullName())); } } } }
private void verifyTableColumns(ModelMetaData model, ValidatorReport report, MetadataValidator metadataValidator, Table view, Table matView, String ignoreColumnOnMatView) { List<Column> columns = view.getColumns(); for(int i = 0 ; i < columns.size() ; i ++) { Column column = columns.get(i); Column matViewColumn = matView.getColumnByName(column.getName()); if (matViewColumn == null) { metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31193, column.getName(), matView.getFullName(), view.getFullName())); } else if(!column.getDatatypeUUID().equals(matViewColumn.getDatatypeUUID())){ metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31194, matViewColumn.getName(), matView.getFullName(), column.getName(), view.getFullName())); } } } }
private void verifyTableColumns(ModelMetaData model, ValidatorReport report, MetadataValidator metadataValidator, Table view, Table matView, String ignoreColumnOnMatView) { List<Column> columns = view.getColumns(); for(int i = 0 ; i < columns.size() ; i ++) { Column column = columns.get(i); Column matViewColumn = matView.getColumnByName(column.getName()); if (matViewColumn == null) { metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31193, column.getName(), matView.getFullName(), view.getFullName())); } else if(!column.getDatatypeUUID().equals(matViewColumn.getDatatypeUUID())){ metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31194, matViewColumn.getName(), matView.getFullName(), column.getName(), view.getFullName())); } } } }
@Test public void testAlterTableRenameColumn() throws Exception { String ddl = "CREATE FOREIGN TABLE G1( e1 integer, e2 varchar, e3 date);" + "ALTER FOREIGN TABLE G1 RENAME COLUMN e3 TO e3renamed;"; Schema s = helpParse(ddl, "model").getSchema(); Map<String, Table> tableMap = s.getTables(); assertTrue("Table not found", tableMap.containsKey("G1")); Table table = tableMap.get("G1"); Column e3 = table.getColumnByName("e3renamed"); assertNotNull(e3); assertEquals("date", e3.getRuntimeType()); }