需求是要把
select count(*),date_format(task_date,'%Y-%m-%d') from core.user_task_daily_log where task_id = '1450680624310212859' and user_id = '01447898594155699684' group by to_days(task_date)
这么一句sql转成sequel
实现方式:
[SQUEL的MODEL(this is a example)]. .select(Sequel.as(Sequel.function(:date_format, :task_date, '%Y-%m-%d'),:task_date),Sequel.as(Sequel.function(:count,:task_id),:cnt)) .where(:task_id => params[:task_id], :user_id => params[:user_id]) .group(Sequel.function(:date_format, :task_date, '%Y-%m-%d'))