Grails GORM：选择为

我试图获取今天出生的所有 GORM 用户，但我无法在 Grails 中编写此查询：

SELECT
DAY(dateOfBirth) AS 'day',
MONTH(dateOfBirth) AS 'month'
FROM Users
WHERE day = '...' AND month = '...';

...将替换为今天的值。

Minimal User领域类

class User {

  Date dateOfBirth

  ...

}

Minimal UserService class

@Transactional
class UserService {

  def getTodayBirthdays() {

    def bornTodayQuery = User.where{
      /* I'm thinking here I must
       * select the DAY and MONTH from the DB
       * and compare it with the today ones.
       */
    }       

    User usersBornToday = bornTodayQuery.findAll()      

    usersBornToday      

  }

}

有什么想法如何使用 GORM 创建别名（SELECT 字段 AS 别名）？

我在用着：

• Grails 2.4.4

Thanks!

你可以使用哪里查询为您服务：

@Transactional(readOnly = true)
def listBirthday(int _month, int _day) {
  // Calendar.JANUARY equals to zero!
  def m = _month + 1
  // Run a where query on the users
  User.where {
    month(dateOfBirth) == m && day(dateOfBirth) == _day
  }
}

@Transactional(readOnly = true)
def listBirthdayToday() {
  def cal = Calendar.getInstance()
  listBirthday(cal.get(cal.MONTH), cal.get(cal.DAY_OF_MONTH))
}

此外month and day还有一些其他的功能，here是文档（查找“其他功能”）