com.yahoo.squidb.sql.Query.intersect()方法的使用及代码示例

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

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

Query.intersect介绍

[英]Form a compound select with the given query using the INTERSECT operator
[中]使用INTERSECT运算符与给定查询形成复合select

代码示例

代码示例来源:origin: yahoo/squidb

/**
 * Form a compound select with the given query using the INTERSECT operator
 *
 * @param query a Query object to append with the INTERSECT 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 intersect(Query query) {
  if (immutable) {
    return fork().intersect(query);
  }
  addCompoundSelect(CompoundSelect.intersect(query));
  return this;
}

代码示例来源:origin: yahoo/squidb

public void testIntersect() {
  Query query = Query.select().from(Employee.TABLE).where(Employee.MANAGER_ID.eq(1))
      .intersect(Query.select().from(Employee.TABLE).where(Employee.ID.eq(2)))
      .orderBy(Employee.ID.asc());
  SquidCursor<Employee> cursor = database.query(Employee.class, query);
  try {
    assertEquals(1, cursor.getCount());
    cursor.moveToFirst();
    assertEquals(cookieMonster, new Employee(cursor));
  } finally {
    cursor.close();
  }
}

代码示例来源:origin: com.yahoo.squidb/squidb

/**
 * Form a compound select with the given query using the INTERSECT operator
 *
 * @param query a Query object to append with the INTERSECT 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 intersect(Query query) {
  if (immutable) {
    return fork().intersect(query);
  }
  addCompoundSelect(CompoundSelect.intersect(query));
  return this;
}

相关文章