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

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

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

Table.getSelectTransformation介绍

暂无

代码示例

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

  1. public String getQuery() {
  2.     return t.getSelectTransformation();
  3.   }
  4. }

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

  1. public String getQuery() {
  2.     return t.getSelectTransformation();
  3.   }
  4. }

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

  1. public String getQuery() {
  2.     return t.getSelectTransformation();
  3.   }
  4. }

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

  1. public MappingNode getMappingNode(final Object groupID) throws TeiidComponentException, QueryMetadataException {
  2.   Table tableRecord = (Table) groupID;
  3.   
  4.   MappingDocument mappingDoc = (MappingDocument) getFromMetadataCache(groupID, "xml-doc"); //$NON-NLS-1$
  5.   
  6.   if (mappingDoc != null) {
  7.     return mappingDoc;
  8.   }
  9.   
  10.   final String groupName = tableRecord.getFullName();
  11.   if(tableRecord.isVirtual()) {
  12.     // get mapping transform
  13.     String document = tableRecord.getSelectTransformation();            
  14.     InputStream inputStream = new ByteArrayInputStream(document.getBytes());
  15.     MappingLoader reader = new MappingLoader();
  16.     try{
  17.       mappingDoc = reader.loadDocument(inputStream);
  18.       mappingDoc.setName(groupName);
  19.     } catch (Exception e){
  20.        throw new TeiidComponentException(QueryPlugin.Event.TEIID30363, e, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30363, groupName, mappingDoc));
  21.     } finally {
  22.       try {
  23.         inputStream.close();
  24.       } catch(Exception e) {}
  25.     }
  26.     addToMetadataCache(groupID, "xml-doc", mappingDoc); //$NON-NLS-1$
  27.     return mappingDoc;
  28.   }
  29.   return null;
  30. }

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

  1. public static void alterView(final VDBMetaData vdb, final Table t, final String sql, boolean updateStore) {
  2.   TransformationMetadata metadata = vdb.getAttachment(TransformationMetadata.class);
  3.   DatabaseStore store = vdb.getAttachment(DatabaseStore.class);
  4.   
  5.   try {
  6.     Command command = QueryParser.getQueryParser().parseCommand(t.getSelectTransformation());
  7.     QueryResolver.resolveCommand(command, metadata);
  8.     MetadataValidator.determineDependencies(t, command);
  9.   } catch (TeiidException e) {
  10.     //should have been caught in validation, but this logic
  11.     //is also not mature so since there is no lock on the vdb
  12.     //it is possible that the plan is no longer valid at this point due
  13.     //to a concurrent execution
  14.   }
  15.   t.setSelectTransformation(sql);
  16.   t.setLastModified(System.currentTimeMillis());
  17.   metadata.addToMetadataCache(t, "transformation/"+SQLConstants.Reserved.SELECT, null); //$NON-NLS-1$
  18. }

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

  1. public static void alterView(final VDBMetaData vdb, final Table t, final String sql, boolean updateStore) {
  2.   TransformationMetadata metadata = vdb.getAttachment(TransformationMetadata.class);
  3.   DatabaseStore store = vdb.getAttachment(DatabaseStore.class);
  4.   
  5.   try {
  6.     Command command = QueryParser.getQueryParser().parseCommand(t.getSelectTransformation());
  7.     QueryResolver.resolveCommand(command, metadata);
  8.     MetadataValidator.determineDependencies(t, command);
  9.   } catch (TeiidException e) {
  10.     //should have been caught in validation, but this logic
  11.     //is also not mature so since there is no lock on the vdb
  12.     //it is possible that the plan is no longer valid at this point due
  13.     //to a concurrent execution
  14.   }
  15.   t.setSelectTransformation(sql);
  16.   t.setLastModified(System.currentTimeMillis());
  17.   metadata.addToMetadataCache(t, "transformation/"+SQLConstants.Reserved.SELECT, null); //$NON-NLS-1$
  18. }

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

  1. public static void alterView(final VDBMetaData vdb, final Table t, final String sql, boolean updateStore) {
  2.   TransformationMetadata metadata = vdb.getAttachment(TransformationMetadata.class);
  3.   DatabaseStore store = vdb.getAttachment(DatabaseStore.class);
  4.   
  5.   try {
  6.     Command command = QueryParser.getQueryParser().parseCommand(t.getSelectTransformation());
  7.     QueryResolver.resolveCommand(command, metadata);
  8.     MetadataValidator.determineDependencies(t, command);
  9.   } catch (TeiidException e) {
  10.     //should have been caught in validation, but this logic
  11.     //is also not mature so since there is no lock on the vdb
  12.     //it is possible that the plan is no longer valid at this point due
  13.     //to a concurrent execution
  14.   }
  15.   t.setSelectTransformation(sql);
  16.   t.setLastModified(System.currentTimeMillis());
  17.   metadata.addToMetadataCache(t, "transformation/"+SQLConstants.Reserved.SELECT, null); //$NON-NLS-1$
  18. }

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

  1. public void tableCreated(Table table) {
  2.   if (!assertInEditMode(Mode.SCHEMA)) {
  3.     return;
  4.   }
  5.   assertGrant(Grant.Permission.Privilege.CREATE, Database.ResourceType.TABLE, table);
  6.   
  7.   Schema s = getCurrentSchema();
  8.   setUUID(s.getUUID(), table);
  9.   
  10.   if (table.isVirtual() && table.getSelectTransformation() == null && table.getTableType() != Type.TemporaryTable) {
  11.     throw new org.teiid.metadata.MetadataException(QueryPlugin.Event.TEIID31272,
  12.         QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31272, table.getFullName()));
  13.   }
  14.   
  15.   s.addTable(table);
  16. }

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

  1. @Test
  2. public void testView() throws Exception {
  3.   String ddl = "CREATE View G1( e1 integer, e2 varchar) OPTIONS (CARDINALITY 12) AS select e1, e2 from foo.bar";
  4.   Schema s = helpParse(ddl, "model").getSchema();
  5.   Map<String, Table> tableMap = s.getTables();    
  6.   
  7.   Table table = tableMap.get("G1");
  8.   
  9.   assertEquals("SELECT e1, e2 FROM foo.bar", table.getSelectTransformation());
  10.   assertEquals(12, table.getCardinality());
  11. }

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

  1. public void tableCreated(Table table) {
  2.   if (!assertInEditMode(Mode.SCHEMA)) {
  3.     return;
  4.   }
  5.   assertGrant(Grant.Permission.Privilege.CREATE, Database.ResourceType.TABLE, table);
  6.   
  7.   Schema s = getCurrentSchema();
  8.   setUUID(s.getUUID(), table);
  9.   
  10.   if (table.isVirtual() && table.getSelectTransformation() == null && table.getTableType() != Type.TemporaryTable) {
  11.     throw new org.teiid.metadata.MetadataException(QueryPlugin.Event.TEIID31272,
  12.         QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31272, table.getFullName()));
  13.   }
  14.   
  15.   s.addTable(table);
  16. }

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

  1. @Test 
  2. public void testAlterView() throws Exception {
  3.   String ddl = "CREATE DATABASE FOO;"
  4.       + "USE DATABASE FOO ;"
  5.       + "CREATE VIRTUAL SCHEMA test;"
  6.       + "SET SCHEMA test;"
  7.       + "CREATE VIRTUAL VIEW G1( e1 integer, e2 varchar, e3 date) AS SELECT 1, '2', curdate();"
  8.       + "ALTER VIEW G1 AS /*+ foo */ SELECT 1, 'foo', curdate()";
  9.   
  10.   Database db = helpParse(ddl);
  11.   Schema s = db.getSchema("test");
  12.   Table t = s.getTable("G1");
  13.   assertEquals("SELECT 1, 'foo', curdate()", t.getSelectTransformation());
  14. }

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

  1. @Test 
  2. public void testAlterViewAddColumn2() throws Exception {
  3.   String ddl = "CREATE DATABASE FOO;"
  4.       + "USE DATABASE FOO ;"
  5.       + "CREATE VIRTUAL SCHEMA test;"
  6.       + "SET SCHEMA test;"
  7.       + "CREATE VIRTUAL VIEW G1 AS SELECT 1 as e1, '2' as e2, curdate() as e3;"
  8.       + "ALTER VIEW G1 AS SELECT 1 as e1, '2' as e2, curdate() as e3, 'foo' as e4;";
  9.   
  10.   Database db = helpParse(ddl);
  11.   Schema s = db.getSchema("test");
  12.   Table t = s.getTable("G1");
  13.   assertEquals("SELECT 1 AS e1, '2' AS e2, curdate() AS e3, 'foo' AS e4", t.getSelectTransformation());
  14. }

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

  1. @Test
  2. public void testMultipleCommands() throws Exception {
  3.   String ddl = "CREATE VIEW V1 AS SELECT * FROM PM1.G1; " +
  4.       "CREATE PROCEDURE FOO(P1 integer) RETURNS (e1 integer, e2 varchar) AS SELECT * FROM PM1.G1;";
  5.   
  6.   Schema s = helpParse(ddl, "model").getSchema();
  7.   Map<String, Table> tableMap = s.getTables();
  8.   Table table = tableMap.get("V1");
  9.   assertNotNull(table);
  10.   assertEquals("SELECT * FROM PM1.G1", table.getSelectTransformation());
  11.   
  12.   Map<String, Procedure> procedureMap = s.getProcedures();
  13.   Procedure p = procedureMap.get("FOO");
  14.   assertNotNull(p);
  15.   assertEquals("SELECT * FROM PM1.G1;", p.getQueryPlan());
  16.   
  17. }

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

  1. append(NEWLINE).append(SQLConstants.Reserved.AS).append(NEWLINE).append(table.getSelectTransformation());

代码示例来源：origin: org.teiid/teiid-spring-boot-starter

  1. @Test
  2. public void testRedirectionLayerSelectPlan() {
  3.   RedirectionSchemaBuilder mg = new RedirectionSchemaBuilder(this.context, "redirected");
  4.   VDBMetaData vdb = new VDBMetaData();
  5.   vdb.addModel(buildSourceTable());
  6.   ModelMetaData model = mg.buildRedirectionLayer(buildSourceTableWithPK().getAttachment(MetadataFactory.class),
  7.       "base");
  8.   String expected = "SELECT o.id, o.name, o.dob FROM internal.Person AS o LEFT OUTER JOIN "
  9.       + "redirected.Person_REDIRECTED AS m ON (o.id = m.id) WHERE m.ROW__STATUS IS NULL \n" + " UNION ALL \n"
  10.       + "SELECT id, name, dob FROM redirected.Person_REDIRECTED WHERE ROW__STATUS <> 3";
  11.   MetadataFactory mf = model.getAttachment(MetadataFactory.class);
  12.   Table table = mf.getSchema().getTable("Person");
  13.   assertEquals(expected, table.getSelectTransformation());
  14. }

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

  1. append(NEWLINE).append(SQLConstants.Reserved.AS).append(NEWLINE).append(table.getSelectTransformation());

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

  1. if (t.getSelectTransformation() == null) {
  2.   metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31079, t.getFullName(), model.getName()));

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

  1. append(NEWLINE).append(SQLConstants.Reserved.AS).append(NEWLINE).append(table.getSelectTransformation());

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

  1. if (t.getSelectTransformation() == null) {
  2.   metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31079, t.getFullName(), model.getName()));

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

  1. if (t.getSelectTransformation() == null) {
  2.   metadataValidator.log(report, model, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31079, t.getFullName(), model.getName()));

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

Table

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Table类方法

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