本文整理了Java中com.yahoo.squidb.sql.Query.unionAll
方法的一些代码示例,展示了Query.unionAll
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Query.unionAll
方法的具体详情如下:
包路径:com.yahoo.squidb.sql.Query
类名称:Query
方法名:unionAll
[英]Form a compound select with the given query using the UNION ALL operator
[中]使用UNION ALL运算符与给定查询形成复合select
代码示例来源:origin: yahoo/squidb
/**
* Form a compound select with the given query using the UNION ALL operator
*
* @param query a Query object to append with the UNION ALL operator
* @return this Query object, to allow chaining method calls
* @see <a href="http://www.sqlite.org/lang_select.html#compound">http://www.sqlite.org/lang_select.html#compound</a>
*/
public Query unionAll(Query query) {
if (immutable) {
return fork().unionAll(query);
}
addCompoundSelect(CompoundSelect.unionAll(query));
return this;
}
代码示例来源:origin: com.yahoo.squidb/squidb
/**
* Form a compound select with the given query using the UNION ALL operator
*
* @param query a Query object to append with the UNION ALL operator
* @return this Query object, to allow chaining method calls
* @see <a href="http://www.sqlite.org/lang_select.html#compound">http://www.sqlite.org/lang_select.html#compound</a>
*/
public Query unionAll(Query query) {
if (immutable) {
return fork().unionAll(query);
}
addCompoundSelect(CompoundSelect.unionAll(query));
return this;
}
代码示例来源:origin: yahoo/squidb
public void testUnionAll() {
Query query = Query.select().from(Employee.TABLE).where(Employee.MANAGER_ID.eq(1))
.unionAll(Query.select().from(Employee.TABLE).where(Employee.ID.eq(2)))
.orderBy(Employee.ID.asc());
SquidCursor<Employee> cursor = database.query(Employee.class, query);
try {
assertEquals(4, cursor.getCount());
cursor.moveToFirst();
assertEquals(cookieMonster, new Employee(cursor));
cursor.moveToNext();
assertEquals(cookieMonster, new Employee(cursor));
cursor.moveToNext();
assertEquals(elmo, new Employee(cursor));
cursor.moveToNext();
assertEquals(oscar, new Employee(cursor));
} finally {
cursor.close();
}
}
内容来源于网络,如有侵权,请联系作者删除!