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

Query.groupBy介绍

[英]Add a GROUP BY clause (or an additional grouping term) to this query
[中]将GROUP BY子句（或其他分组术语）添加到此查询中

代码示例

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

/**
 * Add a GROUP BY clause (or an additional grouping term) to this query
 *
 * @param fields one or more Fields to group on
 * @return this Query object, to allow chaining method calls
 */
public Query groupBy(Field<?>... fields) {
  if (immutable) {
    return fork().groupBy(fields);
  }
  if (this.groupByFields == null) {
    this.groupByFields = new ArrayList<>();
  }
  SquidUtilities.addAll(this.groupByFields, fields);
  invalidateCompileCache();
  return this;
}

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

public void testBoundArgumentsWorkInHavingClause() {
  Query query = Query.select(Employee.PROPERTIES)
      .groupBy(Employee.MANAGER_ID)
      .having(Function.count(Employee.MANAGER_ID).gt(2));
  SquidCursor<Employee> cursor = database.query(Employee.class, query);
  try {
    assertEquals(1, cursor.getCount());
    cursor.moveToFirst();
    assertEquals(bigBird.getRowId(), cursor.get(Employee.MANAGER_ID).longValue());
  } finally {
    cursor.close();
  }
}

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

public void testAggregateCount() {
  TestModel model1 = insertBasicTestModel();
  TestModel model2 = new TestModel().setFirstName(model1.getFirstName()).setLastName("Smith");
  database.persist(model2);
  IntegerProperty groupCount = IntegerProperty.countProperty(TestModel.FIRST_NAME, false);
  Query query = Query.select(TestModel.PROPERTIES).selectMore(groupCount).groupBy(TestModel.FIRST_NAME);
  SquidCursor<TestModel> groupedCursor = database.query(TestModel.class, query);
  try {
    groupedCursor.moveToFirst();
    assertEquals(1, groupedCursor.getCount());
    assertEquals(2, groupedCursor.get(groupCount).intValue());
  } finally {
    groupedCursor.close();
  }
}

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

"subordinates");
Query subquery = Query.select(aliasedManagerId, subordinates).from(employeesAlias)
    .groupBy(aliasedManagerId);

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

/**
 * Add a GROUP BY clause (or an additional grouping term) to this query
 *
 * @param fields one or more Fields to group on
 * @return this Query object, to allow chaining method calls
 */
public Query groupBy(Field<?>... fields) {
  if (immutable) {
    return fork().groupBy(fields);
  }
  if (this.groupByFields == null) {
    this.groupByFields = new ArrayList<>();
  }
  SquidUtilities.addAll(this.groupByFields, fields);
  invalidateCompileCache();
  return this;
}

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

public void testSubqueryJoin() {
  StringProperty managerName = Employee.NAME.as("managerName");
  Query query = Query
      .fromSubquery(Query.select(Employee.MANAGER_ID).from(Employee.TABLE).groupBy(Employee.MANAGER_ID),
          "subquery");
  query.selectMore(managerName);
  query.join(Join.inner(Employee.TABLE, query.getTable().qualifyField(Employee.MANAGER_ID).eq(Employee.ID)))
      .orderBy(Employee.MANAGER_ID.asc());
  SquidCursor<Employee> cursor = database.query(Employee.class, query);
  try {
    assertEquals(3, cursor.getCount());
    cursor.moveToFirst();
    assertEquals("bigBird", cursor.get(managerName));
    cursor.moveToNext();
    assertEquals("cookieMonster", cursor.get(managerName));
    cursor.moveToNext();
    assertEquals("bert", cursor.get(managerName));
  } finally {
    cursor.close();
  }
}

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

public void testGroupConcat() {
  setUpAggregateTest();
  StringProperty firstNameConcat = StringProperty.fromFunction(
      Function.groupConcat(TestModel.FIRST_NAME), "fname_concat");
  StringProperty firstNameConcatSeparator = StringProperty.fromFunction(
      Function.groupConcat(TestModel.FIRST_NAME, "|"), "fname_concat_separator");
  StringProperty firstNameDistinct = StringProperty.fromFunction(
      Function.groupConcatDistinct(TestModel.FIRST_NAME), "fname_distinct");
  SquidCursor<TestModel> cursor = database.query(TestModel.class,
      Query.select(firstNameConcat, firstNameConcatSeparator, firstNameDistinct)
          .groupBy(TestModel.FIRST_NAME));
  try {
    assertEquals(2, cursor.getCount());
    cursor.moveToFirst();
    assertEquals("A,A,A", cursor.get(firstNameConcat));
    assertEquals("A|A|A", cursor.get(firstNameConcatSeparator));
    assertEquals("A", cursor.get(firstNameDistinct));
    cursor.moveToNext();
    assertEquals("B,B,B", cursor.get(firstNameConcat));
    assertEquals("B|B|B", cursor.get(firstNameConcatSeparator));
    assertEquals("B", cursor.get(firstNameDistinct));
  } finally {
    cursor.close();
  }
}