todesking · September 17, 2011 01:46
diff --git a/doma_query_helper.sql b/doma_query_helper.sql
 /* 自分で定義したDateRange型から､where条件を生成したい */

 -- before
 select * from table
 where
  update_time between /*range.getStart()*/'2011-01-01' and /*range.getEnd()*/'2011-12-31'

 -- after
 select * from table
 where
  /*=QueyUtil.between("update_time",range)*/
	/* 自分で定義したDateRange型から､where条件を生成したい */

	-- before
	select * from table
	where
	update_time between /range.getStart()/'2011-01-01' and /range.getEnd()/'2011-12-31'

	-- after
	select * from table
	where
	/=QueyUtil.between("update_time",range)/