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

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

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

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

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

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

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

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

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

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

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

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

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

@Test public void testNameSpacedFunctionName() {
  String sql = "select a.x()"; //$NON-NLS-1$
  
  Query query = new Query();
  Select select = new Select();
  Function func1 = new Function("a.x", new Expression[] { }); //$NON-NLS-1$
  select.addSymbol(func1);        
  query.setSelect(select);
  
  helpTest(sql, "SELECT a.x()", query); //$NON-NLS-1$
}

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

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

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

@Test public void testObjectTable1() throws Exception {
  Query query = new Query();
  query.setSelect(new Select(Arrays.asList(new MultipleElementSymbol())));
  ObjectTable objectTable = new ObjectTable();
  objectTable.setRowScript("y");
  objectTable.setPassing(Arrays.asList(new DerivedColumn("y", new ElementSymbol("e1"))));
  objectTable.setColumns(Arrays.asList(new ObjectTable.ObjectColumn("z", "time", "now()", null)));
  objectTable.setName("x");
  query.setFrom(new From(Arrays.asList(objectTable)));
  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);
}

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

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

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

private Query createTestQuery(String group) {
  GroupSymbol g = new GroupSymbol(group);
  From from = new From();
  from.addGroup(g);
  Select select = new Select();
  select.addSymbol(new MultipleElementSymbol());
  
  Query query1 = new Query();
  query1.setSelect(select);
  query1.setFrom(from);
  return query1;
}

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

public Query createBaseQuery() throws Exception {
  Query query = new Query();
  
  Select select = new Select();
  select.addSymbol(getElementSymbol(1,1));
  query.setSelect(select);
  
  From from = new From();
  from.addGroup(getPhysicalGroup(1));
  query.setFrom(from);
  
  return query;                
}

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

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

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

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

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

@Test public void testQuery1() {
  Select select = new Select();
  select.addSymbol(new MultipleElementSymbol());
  From from = new From();
  from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
  Query query = new Query();
  query.setSelect(select);
  query.setFrom(from);
  
  helpTest(query, "SELECT * FROM m.g");		     //$NON-NLS-1$
}

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

@Test public void testCommandStatement1() {
  Query q1 = new Query();
  Select select = new Select();
  select.addSymbol(new ElementSymbol("x"));        //$NON-NLS-1$
  q1.setSelect(select);        
  From from = new From();
  from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$
  q1.setFrom(from);
      
  CommandStatement cmdStmt =    new CommandStatement(q1);
  helpTest(cmdStmt, "SELECT x FROM g;"); //$NON-NLS-1$
}

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

@Test public void testExistsCriteria1() {
  
  Select s1 = new Select();
  s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
  From f1 = new From();
  f1.addGroup(new GroupSymbol("m.g1"));        //$NON-NLS-1$
  Query q1 = new Query();
  q1.setSelect(s1);
  q1.setFrom(f1);
  ExistsCriteria ec = new ExistsCriteria(q1);
  helpTest(ec, "EXISTS (SELECT e1 FROM m.g1)");             //$NON-NLS-1$
}

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

@Test public void testScalarSubquery() {
  
  Select s1 = new Select();
  s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
  From f1 = new From();
  f1.addGroup(new GroupSymbol("m.g1"));        //$NON-NLS-1$
  Query q1 = new Query();
  q1.setSelect(s1);
  q1.setFrom(f1);
  ScalarSubquery obj = new ScalarSubquery(q1);
  helpTest(obj, "(SELECT e1 FROM m.g1)");             //$NON-NLS-1$
}

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

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

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

@Test public void testCommandStatement1a() {
  Query q1 = new Query();
  Select select = new Select();
  select.addSymbol(new ElementSymbol("x"));        //$NON-NLS-1$
  q1.setSelect(select);        
  From from = new From();
  from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$
  q1.setFrom(from);
      
  CommandStatement cmdStmt =    new CommandStatement(q1);
  cmdStmt.setReturnable(false);
  helpTest(cmdStmt, "SELECT x FROM g WITHOUT RETURN;"); //$NON-NLS-1$
}

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

@Test public void testLOBTypes() throws Exception {
  Function convert = new Function("convert", new Expression[] {new Constant(null), new Constant("blob")}); //$NON-NLS-1$ //$NON-NLS-2$
  Function convert1 = new Function("convert", new Expression[] {new Constant(null), new Constant("clob")}); //$NON-NLS-1$ //$NON-NLS-2$
  Function convert2 = new Function("convert", new Expression[] {new Constant(null), new Constant("xml")}); //$NON-NLS-1$ //$NON-NLS-2$
  Select select = new Select(Arrays.asList(convert, convert1, convert2)); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
  Query query = new Query();
  query.setSelect(select);
  
  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$
}

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

query

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

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