org.teiid.query.sql.lang.Query.getProjectedSymbols()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(8.9k)|赞(0)|评价(0)|浏览(674)

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

Query.getProjectedSymbols介绍

[英]Get the ordered list of all elements returned by this query. These elements may be ElementSymbols or ExpressionSymbols but in all cases each represents a single column.
[中]获取此查询返回的所有元素的有序列表。这些元素可能是元素符号或表达式符号，但在所有情况下，每个元素都代表一列。

代码示例

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

  1. /**
  2.  * @see org.teiid.query.sql.lang.Command#areResultsCachable()
  3.  */
  4. public boolean areResultsCachable() {
  5.   if(this.getInto() != null){
  6.     return false;
  7.   }
  8.   List<Expression> projectedSymbols = getProjectedSymbols();
  9.   return areColumnsCachable(projectedSymbols);
  10. }

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

  1. /**
  2.  * @see org.teiid.query.sql.lang.Command#areResultsCachable()
  3.  */
  4. public boolean areResultsCachable() {
  5.   if(this.getInto() != null){
  6.     return false;
  7.   }
  8.   List<Expression> projectedSymbols = getProjectedSymbols();
  9.   return areColumnsCachable(projectedSymbols);
  10. }

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

  1. /**
  2.  * @see org.teiid.query.sql.lang.Command#areResultsCachable()
  3.  */
  4. public boolean areResultsCachable() {
  5.   if(this.getInto() != null){
  6.     return false;
  7.   }
  8.   if (isXML) {
  9.     return true;
  10.   }
  11.   List<Expression> projectedSymbols = getProjectedSymbols();
  12.   return areColumnsCachable(projectedSymbols);
  13. }

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

  1. /**
  2.  * Get the ordered list of all elements returned by this query.  These elements
  3.  * may be ElementSymbols or ExpressionSymbols but in all cases each represents a 
  4.  * single column.
  5.  * @return Ordered list of SingleElementSymbol
  6.  */
  7. public List getProjectedSymbols() {
  8.   Query query = getProjectedQuery();
  9.   List projectedSymbols = query.getProjectedSymbols();
  10.   if (projectedTypes != null) {
  11.     return getTypedProjectedSymbols(projectedSymbols, projectedTypes, metadata);
  12.   } 
  13.   return projectedSymbols;
  14. }

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

  1. /**
  2.  * Get the ordered list of all elements returned by this query.  These elements
  3.  * may be ElementSymbols or ExpressionSymbols but in all cases each represents a 
  4.  * single column.
  5.  * @return Ordered list of SingleElementSymbol
  6.  */
  7. public List getProjectedSymbols() {
  8.   Query query = getProjectedQuery();
  9.   List projectedSymbols = query.getProjectedSymbols();
  10.   if (projectedTypes != null) {
  11.     return getTypedProjectedSymbols(projectedSymbols, projectedTypes, metadata);
  12.   } 
  13.   return projectedSymbols;
  14. }

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

  1. /**
  2.  * Get the ordered list of all elements returned by this query.  These elements
  3.  * may be ElementSymbols or ExpressionSymbols but in all cases each represents a 
  4.  * single column.
  5.  * @return Ordered list of SingleElementSymbol
  6.  */
  7. public List getProjectedSymbols() {
  8.   Query query = getProjectedQuery();
  9.   List projectedSymbols = query.getProjectedSymbols();
  10.   if (projectedTypes != null) {
  11.     return getTypedProjectedSymbols(projectedSymbols, projectedTypes, metadata);
  12.   } 
  13.   return projectedSymbols;
  14. }

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

  1. public void testQuery() {    
  2.     Query q = sample3();
  3.     
  4.     List projList = new ArrayList();
  5.     projList.add(new ElementSymbol("xml")); //$NON-NLS-1$
  6.     
  7.     assertEquals("result is not as expected.", //$NON-NLS-1$
  8.       projList, 
  9.       q.getProjectedSymbols());
  10.   }
  11. }

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

  1. @Test public void testSelectAllOrder() {
  2.   Query q = (Query)helpResolve("select * from pm1.g1, pm1.g2");
  3.   assertEquals("[pm1.g1.e1, pm1.g1.e2, pm1.g1.e3, pm1.g1.e4, pm1.g2.e1, pm1.g2.e2, pm1.g2.e3, pm1.g2.e4]", q.getProjectedSymbols().toString());
  4.   
  5.   q = (Query)helpResolve("select * from pm1.g1 cross join pm1.g2");
  6.   assertEquals("[pm1.g1.e1, pm1.g1.e2, pm1.g1.e3, pm1.g1.e4, pm1.g2.e1, pm1.g2.e2, pm1.g2.e3, pm1.g2.e4]", q.getProjectedSymbols().toString());
  7.   
  8.   q = (Query)helpResolve("select * from pm1.g1, pm1.g2 inner join pm1.g3 on (pm1.g2.e1 = pm1.g3.e1)");
  9.   assertEquals("[pm1.g1.e1, pm1.g1.e2, pm1.g1.e3, pm1.g1.e4, pm1.g2.e1, pm1.g2.e2, pm1.g2.e3, pm1.g2.e4, pm1.g3.e1, pm1.g3.e2, pm1.g3.e3, pm1.g3.e4]", q.getProjectedSymbols().toString());
  10. }

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

  1. @Test public void testSelectAllOrderCommonTable() {
  2.   Query q = (Query)helpResolve("with x as (select 1 y) select * from pm1.g1, pm1.g2");
  3.   assertEquals("[pm1.g1.e1, pm1.g1.e2, pm1.g1.e3, pm1.g1.e4, pm1.g2.e1, pm1.g2.e2, pm1.g2.e3, pm1.g2.e4]", q.getProjectedSymbols().toString());
  4. }

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

  1. @Test public void testParamOrder() {
  2.   Query resolvedQuery = (Query)helpResolve("SELECT * FROM (exec pm4.spRetOut()) as a", RealMetadataFactory.exampleBQTCached()); //$NON-NLS-1$
  3.   
  4.   assertEquals("a.ret", resolvedQuery.getProjectedSymbols().get(0).toString());
  5. }

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

  1. public static org.teiid.query.sql.symbol.ScalarSubquery helpExample() {
  2.   Query query = TestQueryImpl.helpExample(true);
  3.   org.teiid.query.sql.symbol.ScalarSubquery ss = new org.teiid.query.sql.symbol.ScalarSubquery(query);
  4.   ss.setType(((Expression)query.getProjectedSymbols().get(0)).getType());
  5.   return ss;
  6. }

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

  1. @Test public void testProcRelationalWithOutParam() {
  2.   Query proc = (Query)helpResolve("select * from pm2.spTest8 where inkey = 1", RealMetadataFactory.exampleBQTCached());
  3.   assertEquals(3, proc.getProjectedSymbols().size());
  4. }

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

  1. @Test public void testTrim() {
  2.   Query query = (Query)helpResolve("select trim(e1) from pm1.g1");
  3.   assertEquals(DataTypeManager.DefaultDataClasses.STRING, query.getProjectedSymbols().get(0).getType());
  4. }

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

  1. @Test public void testReferenceInSelect1() {
  2.   String sql = "select convert(?, integer), e1 from pm1.g1"; //$NON-NLS-1$
  3.   
  4.   Query command = (Query)helpResolve(sql, RealMetadataFactory.example1Cached());
  5.   assertEquals(DataTypeManager.DefaultDataClasses.INTEGER, command.getProjectedSymbols().get(0).getType());
  6. }

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

  1. @Test public void testReferenceInSelect() {
  2.   String sql = "select ?, e1 from pm1.g1"; //$NON-NLS-1$
  3.   Query command = (Query)helpResolve(sql, RealMetadataFactory.example1Cached());
  4.   assertEquals(DataTypeManager.DefaultDataClasses.STRING, command.getProjectedSymbols().get(0).getType());
  5. }

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

  1. @Override
  2.   protected TupleSource createTupleSource()
  3.       throws TeiidComponentException, TeiidProcessingException {
  4.     TempTableStore tts = contextStore;
  5.     
  6.     TempTable tt = tts.getOrCreateTempTable(tableName, query, bufferManager, true, false, context, group);
  7.     if (context.getDataObjects() != null) {
  8.       Object id = RelationalPlanner.getTrackableGroup(group, context.getMetadata());
  9.       if (id != null) {
  10.         context.accessedDataObject(id);
  11.       }
  12.     }
  13.     return tt.createTupleSource(query.getProjectedSymbols(), query.getCriteria(), query.getOrderBy());
  14.   }
  15. };

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

  1. @Test public void testOrderBySymbolName() throws Exception {
  2.   String sql = "select e1 from pm1.g1 order by e1"; //$NON-NLS-1$
  3.   String expected = "SELECT g_0.e1 AS c_0 FROM pm1.g1 AS g_0 ORDER BY c_0"; //$NON-NLS-1$
  4.   Query command = (Query)helpTest(sql, expected, true, false, RealMetadataFactory.example1Cached());
  5.   assertEquals(((Symbol)command.getOrderBy().getSortKeys().get(0)).getName(), "c_0"); //$NON-NLS-1$
  6.   assertEquals(((Symbol)command.getProjectedSymbols().get(0)).getShortName(), "c_0"); //$NON-NLS-1$
  7. }

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

  1. @Test public void testSubqueryAliasWithPeriod() throws Exception {
  2.   String sql = "select \"pm1.g2\".x from (select 1 as x) as \"pm1.g2\"";
  3.   Query query = (Query)helpResolve(sql);
  4.   SubqueryFromClause sfc = (SubqueryFromClause)query.getFrom().getClauses().get(0);
  5.   GroupSymbol gs = sfc.getGroupSymbol();
  6.   assertEquals("pm1.g2", gs.getName());
  7.   assertNull(gs.getDefinition());
  8.   assertEquals("SELECT \"pm1.g2\".x FROM (SELECT 1 AS x) AS \"pm1.g2\"", query.toString());
  9.   assertEquals("SELECT \"pm1.g2\".x FROM (SELECT 1 AS x) AS \"pm1.g2\"", query.clone().toString());
  10.   assertEquals("[\"pm1.g2\".x]", query.getProjectedSymbols().toString());
  11. }

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

  1. @Test public void testTableAliasWithMultiplePeriods() throws Exception {
  2.   String sql = "select \"pm1..g2\".e1 from pm1.g1 as \"pm1..g2\"";
  3.   Query query = (Query)helpResolve(sql);
  4.   UnaryFromClause ufc = (UnaryFromClause)query.getFrom().getClauses().get(0);
  5.   GroupSymbol gs = ufc.getGroup();
  6.   assertEquals("pm1..g2", gs.getName());
  7.   assertEquals("pm1.g1", gs.getDefinition());
  8.   assertEquals("SELECT \"pm1..g2\".e1 FROM pm1.g1 AS \"pm1..g2\"", query.toString());
  9.   assertEquals("[\"pm1..g2\".e1]", query.getProjectedSymbols().toString());
  10. }

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

  1. @Test public void testTableAliasWithPeriod() throws Exception {
  2.   String sql = "select \"pm1.g2\".*, e1, \"pm1.g2\".e2, pm1.g2.e2 from pm1.g1 as \"pm1.g2\"";
  3.   Query query = (Query)helpResolve(sql);
  4.   UnaryFromClause ufc = (UnaryFromClause)query.getFrom().getClauses().get(0);
  5.   GroupSymbol gs = ufc.getGroup();
  6.   assertEquals("pm1.g2", gs.getName());
  7.   assertEquals("pm1.g1", gs.getDefinition());
  8.   assertFalse(gs.isTempTable());
  9.   assertEquals("SELECT \"pm1.g2\".*, e1, \"pm1.g2\".e2, \"pm1.g2\".e2 FROM pm1.g1 AS \"pm1.g2\"", query.toString());
  10.   assertEquals("[\"pm1.g2\".e1, \"pm1.g2\".e2, \"pm1.g2\".e3, \"pm1.g2\".e4, e1, \"pm1.g2\".e2, \"pm1.g2\".e2]", query.getProjectedSymbols().toString());
  11. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

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