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

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

本文整理了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

  1. public static void determineDependencies(AbstractMetadataRecord p, Command command) {
  2.   LinkedHashSet<AbstractMetadataRecord> values = new LinkedHashSet<AbstractMetadataRecord>();
  3.   collectDependencies(command, values);
  4.   p.setIncomingObjects(new ArrayList<AbstractMetadataRecord>(values));
  5.   if (p instanceof Table) {
  6.     Table t = (Table)p;
  7.     for (int i = 0; i < t.getColumns().size(); i++) {
  8.       LinkedHashSet<AbstractMetadataRecord> columnValues = new LinkedHashSet<AbstractMetadataRecord>();
  9.       Column c = t.getColumns().get(i);
  10.       c.setIncomingObjects(columnValues);
  11.       determineDependencies(command, c, i, columnValues);
  12.     }
  13.   }
  14. }

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

  1. public void setTableMetadata(Table tableMetadata) {
  2.   if (tableMetadata != null) {
  3.     this.columns = tableMetadata.getColumns();
  4.     this.table = new GroupSymbol(tableMetadata.getName());
  5.   }
  6.   this.tableMetadata = tableMetadata;
  7. }

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

  1. public void setTableMetadata(Table tableMetadata) {
  2.   if (tableMetadata != null) {
  3.     this.columns = tableMetadata.getColumns();
  4.     this.table = new GroupSymbol(tableMetadata.getName());
  5.   }
  6.   this.tableMetadata = tableMetadata;
  7. }

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

  1. public void setTableMetadata(Table tableMetadata) {
  2.   if (tableMetadata != null) {
  3.     this.columns = tableMetadata.getColumns();
  4.     this.table = new GroupSymbol(tableMetadata.getName());
  5.   }
  6.   this.tableMetadata = tableMetadata;
  7. }

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

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

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

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

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

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

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

  1. static Table getComplexTableParentTable(RuntimeMetadata metadata, Table table) throws TranslatorException {
  2.   for (Column c : table.getColumns()) {
  3.     if (ODataMetadataProcessor.isPseudo(c)) {
  4.       ForeignKey fk = table.getForeignKeys().get(0);
  5.       String tableName = fk.getReferenceTableName();
  6.       if (tableName.indexOf('.') == -1) {
  7.         tableName = fk.getReferenceKey().getParent().getFullName();
  8.       }
  9.       return (Table)metadata.getTable(tableName);
  10.     }            
  11.   }
  12.   return table;
  13. }

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

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

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

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

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

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

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

  1. private void verifyTableColumns(ModelMetaData model, ValidatorReport report,
  2.       MetadataValidator metadataValidator, Table view, Table matView, String ignoreColumnOnMatView) {
  3.     List<Column> columns = view.getColumns();
  4.     for(int i = 0 ; i < columns.size() ; i ++) {
  5.       Column column = columns.get(i);
  6.       Column matViewColumn = matView.getColumnByName(column.getName());
  7.       if (matViewColumn == null) {
  8.         metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31193, column.getName(), matView.getFullName(), view.getFullName()));
  9.       } else if(!column.getDatatypeUUID().equals(matViewColumn.getDatatypeUUID())){
  10.         metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31194, matViewColumn.getName(), matView.getFullName(), column.getName(), view.getFullName()));
  11.       }
  12.     }
  13.   }
  14. }

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

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

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

  1. private void verifyTableColumns(ModelMetaData model, ValidatorReport report,
  2.       MetadataValidator metadataValidator, Table view, Table matView, String ignoreColumnOnMatView) {
  3.     List<Column> columns = view.getColumns();
  4.     for(int i = 0 ; i < columns.size() ; i ++) {
  5.       Column column = columns.get(i);
  6.       Column matViewColumn = matView.getColumnByName(column.getName());
  7.       if (matViewColumn == null) {
  8.         metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31193, column.getName(), matView.getFullName(), view.getFullName()));
  9.       } else if(!column.getDatatypeUUID().equals(matViewColumn.getDatatypeUUID())){
  10.         metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31194, matViewColumn.getName(), matView.getFullName(), column.getName(), view.getFullName()));
  11.       }
  12.     }
  13.   }
  14. }

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

  1. private void verifyTableColumns(ModelMetaData model, ValidatorReport report,
  2.       MetadataValidator metadataValidator, Table view, Table matView, String ignoreColumnOnMatView) {
  3.     List<Column> columns = view.getColumns();
  4.     for(int i = 0 ; i < columns.size() ; i ++) {
  5.       Column column = columns.get(i);
  6.       Column matViewColumn = matView.getColumnByName(column.getName());
  7.       if (matViewColumn == null) {
  8.         metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31193, column.getName(), matView.getFullName(), view.getFullName()));
  9.       } else if(!column.getDatatypeUUID().equals(matViewColumn.getDatatypeUUID())){
  10.         metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31194, matViewColumn.getName(), matView.getFullName(), column.getName(), view.getFullName()));
  11.       }
  12.     }
  13.   }
  14. }

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

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

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

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

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

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

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

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

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

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

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

Table

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Table类方法

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