OSDN Git Service

implemented textsearch
[tdcgexplorer/nimono.git] / app / models / thumb.rb
1 class Thumb < ActiveRecord::Base
2   set_primary_key :video_id
3
4   class Search
5     attr_accessor :text
6
7     def initialize(attributes)
8       attributes.each do |name, value|
9         send("#{name}=", value)
10       end if attributes
11     end
12
13     def conditions
14       @conditions ||= begin
15         sql = "TRUE"
16         ret = [ sql ]
17         terms = []
18         unless text.blank?
19           sql.concat " and (vector @@ to_tsquery('japanese', web_query(?)))"
20           ret.push text
21         end
22         ret
23       end
24     end
25
26     def find_options
27       { :conditions => conditions }
28     end
29   end
30 end