btw, I went with this for the case in question - probably a cheaper
operaiton anyway:
def self.contract(month)
d = Date.from_contract_month(month)
month_start = Date.new(d.year, d.month, 1)
month_end = DateRule.apply(month_start, "+1m-1d")
all(:expiration_date => (month_start..month_end))
end
still interested in the db-function abstraction in general though.
On Jan 11, 8:13 pm, Patrik Sundberg <patrik.sundb...@gmail.com> wrote:
> Hi,
>
> I'm trying to convert this named scop from AR to DM:
> named_scope :contract, lambda { |month|
> d = Date.from_contract_month(month)
> { :conditions => ['EXTRACT(YEAR from expiration_date) = ? and
> EXTRACT(MONTH from expiration_date) = ?',
> d.year, d.month ]
> }
> }
>
> It uses some postgres functions and I was wondering if there's any
> abstractions for things like this in DM ?
>
> Sort of like
> def self.contract(month)
> all(:expiration_date.year => d.year, :expiration_date.month =>
> d.month)
> end
>
> I can do it with an SQL query in DM, just wanted to check if there's
> some abstraction that can get me out of doing that. I saw a thread
> related to this sort of thing from end of 2008 and dug around on
> github but didn't see anything.
>
> Thanks,
> Patrik
--
You received this message because you are subscribed to the Google Groups
"DataMapper" group.
To post to this group, send email to datamap...@googlegroups.com.
To unsubscribe from this group, send email to
datamapper+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/datamapper?hl=en.
