On Sep 3, 3:13 pm, dev2 <[email protected]> wrote:
> MODELS: (not verbatim, but close enough)
>
> Tag:
> property :id, Serial
> property :name, String
> has n, :file_tags
> has n, :files, :through => :file_tags
>
> File:
> property :id, Serial
> property :fname, String
> property :location, String
>
> has n, :file_tags
> has n, :tags, :through => :file_tags
>
> FileTag:
> belongs_to :tag, :key => true
> belongs_to :file, :key => true
>
> CODE:
> qs = "big red dog"
> qry = qs.split(' ')
>
> @results = File.all('tags.name.like' => "%#{qry.shift}%")
> qry.each do |q|
> @results &= File.all('tags.name.like' => "%#{q}%")
> end
>
> Wow DM does so much heavy lifting and removes a lot of tedious query
> building.
>
> However I really need to check more than just tag name for a match. I
> really need it to do something like this:
> WHERE (tag.text like 'param[1]' OR file.fname like 'param[1]') AND
> (tag.text like 'param[2]' OR file.fname like 'param[2]') AND (tag.text
> like 'param[3]' OR file.fname like 'param[3]')
>
> I gop ethat makes sense
Resolved.
Something like that:
tmp = qry.shift
@results = File.all('tags.name.like' => "%#{tmp}%") |
File.all('tags.name.like' => "%#{tmp}%")
qry.each do |q|
@results &= File.all('tags.name.like' => "%#{q}%") |
File.all('tags.name.like' => "%#{q}%")
end
--
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.
