org.teiid.metadata.Table.getColumns()方法的使用及代码示例

x33g5p2x  于2022-01-30 转载在 其他  
字(10.8k)|赞(0)|评价(0)|浏览(117)

本文整理了Java中org.teiid.metadata.Table.getColumns()方法的一些代码示例，展示了Table.getColumns()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Table.getColumns()方法的具体详情如下：
包路径：org.teiid.metadata.Table
类名称：Table
方法名：getColumns

Table.getColumns介绍

暂无

代码示例

代码示例来源：origin: org.jboss.teiid/teiid-engine

public static void determineDependencies(AbstractMetadataRecord p, Command command) {
  LinkedHashSet<AbstractMetadataRecord> values = new LinkedHashSet<AbstractMetadataRecord>();
  collectDependencies(command, values);
  p.setIncomingObjects(new ArrayList<AbstractMetadataRecord>(values));
  if (p instanceof Table) {
    Table t = (Table)p;
    for (int i = 0; i < t.getColumns().size(); i++) {
      LinkedHashSet<AbstractMetadataRecord> columnValues = new LinkedHashSet<AbstractMetadataRecord>();
      Column c = t.getColumns().get(i);
      c.setIncomingObjects(columnValues);
      determineDependencies(command, c, i, columnValues);
    }
  }
}

代码示例来源：origin: teiid/teiid

public void setTableMetadata(Table tableMetadata) {
  if (tableMetadata != null) {
    this.columns = tableMetadata.getColumns();
    this.table = new GroupSymbol(tableMetadata.getName());
  }
  this.tableMetadata = tableMetadata;
}

代码示例来源：origin: org.jboss.teiid/teiid-engine

public void setTableMetadata(Table tableMetadata) {
  if (tableMetadata != null) {
    this.columns = tableMetadata.getColumns();
    this.table = new GroupSymbol(tableMetadata.getName());
  }
  this.tableMetadata = tableMetadata;
}

代码示例来源：origin: org.teiid/teiid-engine

public void setTableMetadata(Table tableMetadata) {
  if (tableMetadata != null) {
    this.columns = tableMetadata.getColumns();
    this.table = new GroupSymbol(tableMetadata.getName());
  }
  this.tableMetadata = tableMetadata;
}

代码示例来源：origin: org.teiid/teiid-engine

public List<Column> getElementIDsInGroupID(final Object groupID) throws TeiidComponentException, QueryMetadataException {
  List<Column> columns = ((Table)groupID).getColumns();
  if (columns == null || columns.isEmpty()) {
    throw new QueryMetadataException(QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31071, ((Table)groupID).getName()));
  }
  return columns;
}

代码示例来源：origin: org.jboss.teiid/teiid-engine

public List<Column> getElementIDsInGroupID(final Object groupID) throws TeiidComponentException, QueryMetadataException {
  List<Column> columns = ((Table)groupID).getColumns();
  if (columns == null || columns.isEmpty()) {
    throw new QueryMetadataException(QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31071, ((Table)groupID).getName()));
  }
  return columns;
}

代码示例来源：origin: teiid/teiid

public List<Column> getElementIDsInGroupID(final Object groupID) throws TeiidComponentException, QueryMetadataException {
  List<Column> columns = ((Table)groupID).getColumns();
  if (columns == null || columns.isEmpty()) {
    throw new QueryMetadataException(QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31071, ((Table)groupID).getName()));
  }
  return columns;
}

代码示例来源：origin: org.teiid.connectors/translator-odata4

static Table getComplexTableParentTable(RuntimeMetadata metadata, Table table) throws TranslatorException {
  for (Column c : table.getColumns()) {
    if (ODataMetadataProcessor.isPseudo(c)) {
      ForeignKey fk = table.getForeignKeys().get(0);
      String tableName = fk.getReferenceTableName();
      if (tableName.indexOf('.') == -1) {
        tableName = fk.getReferenceKey().getParent().getFullName();
      }
      return (Table)metadata.getTable(tableName);
    }            
  }
  return table;
}

代码示例来源：origin: teiid/teiid

@Test public void testArrayType() throws Exception {
  String ddl = "CREATE VIEW V (col string[]) as select ('a','b');";
  
  Schema s = helpParse(ddl, "model").getSchema();
  Table t = s.getTable("V");
  assertEquals(1, t.getColumns().size());
  assertEquals("string[]", t.getColumns().get(0).getRuntimeType());
  assertEquals(String[].class, t.getColumns().get(0).getJavaType());
}

代码示例来源：origin: teiid/teiid

@Test
public void testUDT() throws Exception {
  String ddl = "CREATE FOREIGN TABLE G1( e1 integer, e2 varchar OPTIONS (UDT 'NMTOKENS(12,13,11)'))";
  Schema s = helpParse(ddl, "model").getSchema();
  Map<String, Table> tableMap = s.getTables();    
  
  assertTrue("Table not found", tableMap.containsKey("G1"));
  Table table = tableMap.get("G1");
  
  assertEquals("NMTOKENS", table.getColumns().get(1).getDatatype().getName());
  assertEquals(12, table.getColumns().get(1).getLength());
  assertEquals(13, table.getColumns().get(1).getPrecision());
  assertEquals(11, table.getColumns().get(1).getScale());		
}

代码示例来源：origin: teiid/teiid

@Test
public void testConstraints2() throws Exception {
  String ddl = "CREATE FOREIGN TABLE G1( e1 integer, e2 varchar, e3 date, " +
      "ACCESSPATTERN(e1), UNIQUE(e1), ACCESSPATTERN(e2, e3))";
  Schema s = helpParse(ddl, "model").getSchema();
  Map<String, Table> tableMap = s.getTables();    
  
  assertTrue("Table not found", tableMap.containsKey("G1"));
  Table table = tableMap.get("G1");
  
  assertEquals(table.getColumns().subList(0, 1), table.getUniqueKeys().get(0).getColumns());
  assertEquals(2, table.getAccessPatterns().size());
  assertEquals(table.getColumns().subList(0, 1), table.getAccessPatterns().get(0).getColumns());
  assertEquals(table.getColumns().subList(1, 3), table.getAccessPatterns().get(1).getColumns());
}

代码示例来源：origin: org.teiid/teiid-engine

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()));
      }
    }
  }
}

代码示例来源：origin: teiid/teiid

@Test
public void testConstraints() throws Exception {
  String ddl = "CREATE FOREIGN TABLE G1( e1 integer, e2 varchar, e3 date, " +
      " PRIMARY KEY (e1, e2), INDEX(e2, e3), ACCESSPATTERN(e1), UNIQUE(e1)," +
      " ACCESSPATTERN(e2, e3))";
  Schema s = helpParse(ddl, "model").getSchema();
  Map<String, Table> tableMap = s.getTables();    
  
  assertTrue("Table not found", tableMap.containsKey("G1"));
  Table table = tableMap.get("G1");
  
  assertEquals(table.getColumns().subList(0, 2), table.getPrimaryKey().getColumns());
  assertEquals(table.getColumns().subList(1, 3), table.getIndexes().get(0).getColumns());
  assertEquals(table.getColumns().subList(0, 1), table.getUniqueKeys().get(0).getColumns());
  assertEquals(2, table.getAccessPatterns().size());
  assertEquals(table.getColumns().subList(0, 1), table.getAccessPatterns().get(0).getColumns());
  assertEquals(table.getColumns().subList(1, 3), table.getAccessPatterns().get(1).getColumns());
}

代码示例来源：origin: org.jboss.teiid/teiid-engine

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()));
      }
    }
  }
}

代码示例来源：origin: teiid/teiid

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()));
      }
    }
  }
}

代码示例来源：origin: teiid/teiid

@Test public void testMultiple() throws Exception {
  TransformationMetadata tm = VDBMetadataFactory.getVDBMetadata(UnitTestUtil.getTestDataPath() + "/ZZZ.vdb");
  Collection<String> names = tm.getGroupsForPartialName("PRODUCTDATA");
  assertEquals(1, names.size());
  names = tm.getGroupsForPartialName("PARTS");
  assertEquals(1, names.size());
  
  //ensure that datatypes are set
  Table t = tm.getGroupID(names.iterator().next());
  assertNotNull(t.getColumns().get(0).getDatatype());
}

代码示例来源：origin: teiid/teiid

@Test
public void testGlobalTemp() throws Exception {
  String ddl = "CREATE GLOBAL TEMPORARY TABLE T (col string);";
  
  Schema s = helpParse(ddl, "model").getSchema();
  Table t = s.getTable("T");
  assertEquals(1, t.getColumns().size());
}

代码示例来源：origin: teiid/teiid

@Test
public void testMultiKeyPK() throws Exception {
  String ddl = "CREATE FOREIGN TABLE G1( e1 integer, e2 varchar, e3 date, PRIMARY KEY (e1, e2))";
  Schema s = helpParse(ddl, "model").getSchema();
  Map<String, Table> tableMap = s.getTables();    
  
  assertTrue("Table not found", tableMap.containsKey("G1"));
  Table table = tableMap.get("G1");
  
  assertEquals(table.getColumns().subList(0, 2), table.getPrimaryKey().getColumns());
}

代码示例来源：origin: teiid/teiid

@Test
public void testAlterAddPK() throws Exception {
  String ddl = "CREATE FOREIGN TABLE G1( e1 integer, e2 varchar, e3 date); ALTER TABLE G1 ADD PRIMARY KEY (e1, e2);";
  Schema s = helpParse(ddl, "model").getSchema();
  Map<String, Table> tableMap = s.getTables();    
  
  assertTrue("Table not found", tableMap.containsKey("G1"));
  Table table = tableMap.get("G1");
  
  assertEquals(table.getColumns().subList(0, 2), table.getPrimaryKey().getColumns());
}

代码示例来源：origin: teiid/teiid

@Test
public void testFK() throws Exception {
  String ddl = "CREATE FOREIGN TABLE G1(g1e1 integer, g1e2 varchar, PRIMARY KEY(g1e1, g1e2));\n" +
      "CREATE FOREIGN TABLE G2( g2e1 integer, g2e2 varchar, " +
      "FOREIGN KEY (g2e1, g2e2) REFERENCES G1 (g1e1, g1e2) options (\"teiid_rel:allow-join\" true))";
  
  Schema s = helpParse(ddl, "model").getSchema();
  Map<String, Table> tableMap = s.getTables();    
  assertEquals(2, tableMap.size());
  
  assertTrue("Table not found", tableMap.containsKey("G1"));
  assertTrue("Table not found", tableMap.containsKey("G2"));
  
  Table table = tableMap.get("G2");
  ForeignKey fk = table.getForeignKeys().get(0);
  assertEquals(Boolean.TRUE.toString(), fk.getProperty(ForeignKey.ALLOW_JOIN, false));
  assertEquals(fk.getColumns(), table.getColumns());
  assertEquals("G1", fk.getReferenceTableName());
}

内容来源于网络，如有侵权，请联系作者删除！

Table

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Table类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com