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

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

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

Query.setSelect介绍

[英]Set the select clause for the query.
[中]为查询设置select子句。

代码示例

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

  1. public static Query createMatViewQuery(Object matMetadataId, String matTableName, List<? extends Expression> select, boolean isGlobal) {
  2.   Query query = new Query();
  3.   query.setSelect(new Select(select));
  4.   GroupSymbol gs = new GroupSymbol(matTableName);
  5.   gs.setGlobalTable(isGlobal);
  6.   gs.setMetadataID(matMetadataId);
  7.   query.setFrom(new From(Arrays.asList(new UnaryFromClause(gs))));
  8.   return query;
  9. }

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

  1. @Test public void testPositionalReference() throws Exception {
  2.   String sql = "select $1";
  3.   Query query = new Query();
  4.   query.setSelect(new Select(Arrays.asList(new Reference(0))));
  5.   helpTest(sql, "SELECT ?", query);
  6. }

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

  1. @Test public void testNonReserved() throws Exception {
  2.   String sql = "select count";
  3.   Query query = new Query();
  4.   query.setSelect(new Select(Arrays.asList(new ElementSymbol("count"))));
  5.   helpTest(sql, "SELECT count", query);
  6. }

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

  1. @Test public void testLimitWithOffset() {
  2.   Query query = new Query();
  3.   Select select = new Select(Arrays.asList(new MultipleElementSymbol()));
  4.   From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("a")))); //$NON-NLS-1$
  5.   query.setSelect(select);
  6.   query.setFrom(from);
  7.   query.setLimit(new Limit(new Constant(new Integer(50)), new Constant(new Integer(100))));
  8.   helpTest(query, "SELECT * FROM a LIMIT 50, 100"); //$NON-NLS-1$ 
  9. }

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

  1. @Test public void testLimit() {
  2.   Query query = new Query();
  3.   Select select = new Select(Arrays.asList(new MultipleElementSymbol()));
  4.   From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("a")))); //$NON-NLS-1$
  5.   query.setSelect(select);
  6.   query.setFrom(from);
  7.   query.setLimit(new Limit(null, new Constant(new Integer(100))));
  8.   helpTest("Select * from a limit 100", "SELECT * FROM a LIMIT 100", query); //$NON-NLS-1$ //$NON-NLS-2$
  9. }

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

  1. @Test public void testNameSpacedFunctionName() {
  2.   String sql = "select a.x()"; //$NON-NLS-1$
  3.   
  4.   Query query = new Query();
  5.   Select select = new Select();
  6.   Function func1 = new Function("a.x", new Expression[] { }); //$NON-NLS-1$
  7.   select.addSymbol(func1);        
  8.   query.setSelect(select);
  9.   
  10.   helpTest(sql, "SELECT a.x()", query); //$NON-NLS-1$
  11. }

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

  1. @Test public void testLimitWithReferences1() {
  2.   Query query = new Query();
  3.   Select select = new Select(Arrays.asList(new MultipleElementSymbol()));
  4.   From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("a")))); //$NON-NLS-1$
  5.   query.setSelect(select);
  6.   query.setFrom(from);
  7.   query.setLimit(new Limit(new Reference(0), new Constant(new Integer(100))));
  8.   helpTest("Select * from a limit ?,100", "SELECT * FROM a LIMIT ?, 100", query); //$NON-NLS-1$ //$NON-NLS-2$
  9. }

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

  1. @Test public void testObjectTable1() throws Exception {
  2.   Query query = new Query();
  3.   query.setSelect(new Select(Arrays.asList(new MultipleElementSymbol())));
  4.   ObjectTable objectTable = new ObjectTable();
  5.   objectTable.setRowScript("y");
  6.   objectTable.setPassing(Arrays.asList(new DerivedColumn("y", new ElementSymbol("e1"))));
  7.   objectTable.setColumns(Arrays.asList(new ObjectTable.ObjectColumn("z", "time", "now()", null)));
  8.   objectTable.setName("x");
  9.   query.setFrom(new From(Arrays.asList(objectTable)));
  10.   helpTest("select * from objecttable('y' passing e1 as y columns z time 'now()') as x", "SELECT * FROM OBJECTTABLE('y' PASSING e1 AS y COLUMNS z time 'now()') AS x", query);
  11. }

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

  1. @Test public void testNestedTable() throws Exception {
  2.   String sql = "SELECT * from TABLE(exec foo()) as x"; //$NON-NLS-1$
  3.   Query query = new Query();
  4.   query.setSelect(new Select(Arrays.asList(new MultipleElementSymbol())));
  5.   StoredProcedure sp = new StoredProcedure();
  6.   sp.setProcedureName("foo");
  7.   SubqueryFromClause sfc = new SubqueryFromClause("x", sp);
  8.   sfc.setLateral(true);
  9.   query.setFrom(new From(Arrays.asList(sfc)));
  10.   helpTest(sql, "SELECT * FROM LATERAL(EXEC foo()) AS x", query);
  11. }

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

  1. private Query createTestQuery(String group) {
  2.   GroupSymbol g = new GroupSymbol(group);
  3.   From from = new From();
  4.   from.addGroup(g);
  5.   Select select = new Select();
  6.   select.addSymbol(new MultipleElementSymbol());
  7.   
  8.   Query query1 = new Query();
  9.   query1.setSelect(select);
  10.   query1.setFrom(from);
  11.   return query1;
  12. }

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

  1. public Query createBaseQuery() throws Exception {
  2.   Query query = new Query();
  3.   
  4.   Select select = new Select();
  5.   select.addSymbol(getElementSymbol(1,1));
  6.   query.setSelect(select);
  7.   
  8.   From from = new From();
  9.   from.addGroup(getPhysicalGroup(1));
  10.   query.setFrom(from);
  11.   
  12.   return query;                
  13. }

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

  1. @Test public void testFetchFirstRow() {
  2.   Query query = new Query();
  3.   Select select = new Select(Arrays.asList(new MultipleElementSymbol()));
  4.   From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("a")))); //$NON-NLS-1$
  5.   query.setSelect(select);
  6.   query.setFrom(from);
  7.   query.setLimit(new Limit(null, new Constant(1)));
  8.   helpTest("Select * from a fetch first row only", "SELECT * FROM a LIMIT 1", query); //$NON-NLS-1$ //$NON-NLS-2$
  9. }

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

  1. @Test public void testFetchFirst() {
  2.   Query query = new Query();
  3.   Select select = new Select(Arrays.asList(new MultipleElementSymbol()));
  4.   From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("a")))); //$NON-NLS-1$
  5.   query.setSelect(select);
  6.   query.setFrom(from);
  7.   query.setLimit(new Limit(null, new Constant(2)));
  8.   helpTest("Select * from a fetch first 2 rows only", "SELECT * FROM a LIMIT 2", query); //$NON-NLS-1$ //$NON-NLS-2$
  9. }

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

  1. @Test public void testQuery1() {
  2.   Select select = new Select();
  3.   select.addSymbol(new MultipleElementSymbol());
  4.   From from = new From();
  5.   from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
  6.   Query query = new Query();
  7.   query.setSelect(select);
  8.   query.setFrom(from);
  9.   
  10.   helpTest(query, "SELECT * FROM m.g");		     //$NON-NLS-1$
  11. }

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

  1. @Test public void testCommandStatement1() {
  2.   Query q1 = new Query();
  3.   Select select = new Select();
  4.   select.addSymbol(new ElementSymbol("x"));        //$NON-NLS-1$
  5.   q1.setSelect(select);        
  6.   From from = new From();
  7.   from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$
  8.   q1.setFrom(from);
  9.       
  10.   CommandStatement cmdStmt =    new CommandStatement(q1);
  11.   helpTest(cmdStmt, "SELECT x FROM g;"); //$NON-NLS-1$
  12. }

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

  1. @Test public void testExistsCriteria1() {
  2.   
  3.   Select s1 = new Select();
  4.   s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
  5.   From f1 = new From();
  6.   f1.addGroup(new GroupSymbol("m.g1"));        //$NON-NLS-1$
  7.   Query q1 = new Query();
  8.   q1.setSelect(s1);
  9.   q1.setFrom(f1);
  10.   ExistsCriteria ec = new ExistsCriteria(q1);
  11.   helpTest(ec, "EXISTS (SELECT e1 FROM m.g1)");             //$NON-NLS-1$
  12. }

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

  1. @Test public void testScalarSubquery() {
  2.   
  3.   Select s1 = new Select();
  4.   s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
  5.   From f1 = new From();
  6.   f1.addGroup(new GroupSymbol("m.g1"));        //$NON-NLS-1$
  7.   Query q1 = new Query();
  8.   q1.setSelect(s1);
  9.   q1.setFrom(f1);
  10.   ScalarSubquery obj = new ScalarSubquery(q1);
  11.   helpTest(obj, "(SELECT e1 FROM m.g1)");             //$NON-NLS-1$
  12. }

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

  1. @Test public void testOptionalSubqueryFromClause1() {
  2.   Select s1 = new Select();
  3.   s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
  4.   From f1 = new From();
  5.   f1.addGroup(new GroupSymbol("m.g1"));        //$NON-NLS-1$
  6.   Query q1 = new Query();
  7.   q1.setSelect(s1);
  8.   q1.setFrom(f1);
  9.   SubqueryFromClause sfc = new SubqueryFromClause("temp", q1); //$NON-NLS-1$
  10.   sfc.setOptional(true);
  11.   helpTest(sfc, "/*+ optional */ (SELECT e1 FROM m.g1) AS temp");             //$NON-NLS-1$
  12. }

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

  1. @Test public void testCommandStatement1a() {
  2.   Query q1 = new Query();
  3.   Select select = new Select();
  4.   select.addSymbol(new ElementSymbol("x"));        //$NON-NLS-1$
  5.   q1.setSelect(select);        
  6.   From from = new From();
  7.   from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$
  8.   q1.setFrom(from);
  9.       
  10.   CommandStatement cmdStmt =    new CommandStatement(q1);
  11.   cmdStmt.setReturnable(false);
  12.   helpTest(cmdStmt, "SELECT x FROM g WITHOUT RETURN;"); //$NON-NLS-1$
  13. }

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

  1. @Test public void testLOBTypes() throws Exception {
  2.   Function convert = new Function("convert", new Expression[] {new Constant(null), new Constant("blob")}); //$NON-NLS-1$ //$NON-NLS-2$
  3.   Function convert1 = new Function("convert", new Expression[] {new Constant(null), new Constant("clob")}); //$NON-NLS-1$ //$NON-NLS-2$
  4.   Function convert2 = new Function("convert", new Expression[] {new Constant(null), new Constant("xml")}); //$NON-NLS-1$ //$NON-NLS-2$
  5.   Select select = new Select(Arrays.asList(convert, convert1, convert2)); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
  6.   Query query = new Query();
  7.   query.setSelect(select);
  8.   
  9.   helpTest("select convert(null, blob), convert(null, clob), convert(null, xml)", "SELECT convert(null, blob), convert(null, clob), convert(null, xml)", query); //$NON-NLS-1$ //$NON-NLS-2$
  10. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

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