Module: Searchable

Included in:
SQLObject
Defined in:
lib/easy_save/searchable.rb

Instance Method Summary collapse

Instance Method Details

#where(params) ⇒ Object



4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
# File 'lib/easy_save/searchable.rb', line 4

def where(params)

  where_line = params.keys.map do |key|
    "#{key} = ?"
  end.join(" AND ")

  sql = "    SELECT\n      *\n    FROM\n      \#{table_name}\n    WHERE\n      \#{where_line}\n  SQL\n\n  results = DBConnection.execute(sql, params.values)\n\n  results.inject([]) { |final, res|  final.push(new(res)) } \nend\n"