.find_by_sql is a class method which does not allow for chaining. Chaining functions by taking the query object that's stored on a collection, and modifying/updating it with a new query.
The only problem is when you call Model.find_by_sql, there *is* no query object, because you're specifying a data set by directly invoking SQL. -T On Mon, Dec 6, 2010 at 12:34 AM, dev2 <[email protected]> wrote: > Hi, > This is a really cool function of datamapper. Kudos to snusnu and > thanks. > > I have some questions about it > > Is it possible to use find_by_sql in an instance, or can it only be > used as a class method? > > Is it possible to have it returns a collection of a type other than > the class its called from? (for example ( Person, Place, PersonPlace - > lets say I want to do some complex querying to find places that have > people that meet certain criteria. I could do this in the Person > model, but it seems to feel better having the Place model do it (with > a function called specific_people). place = Place.first; > place.specific_people) > > I'm sure more questions will trickle from this. > > I really appreciate any help you can offer. Also, there doesn't seem > to be much in the way of docs for this feature, so if I missed them > please let me know where they are :) > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "DataMapper" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<datamapper%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/datamapper?hl=en. > > -- You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/datamapper?hl=en.
