Class: RQuery::Adapters::Sql

Inherits:
Object
  • Object
show all
Defined in:
lib/rquery/adapters/sql.rb

Direct Known Subclasses

Sqlite

Class Method Summary collapse

Class Method Details

.== ⇒ Object 



27
28
29
 
# File 'lib/rquery/adapters/sql.rb', line 27

def ==
    "= ?"
end

.and_group(ops) ⇒ Object Also known as: join 



35
36
37
 
# File 'lib/rquery/adapters/sql.rb', line 35

def and_group(ops)
  "(#{ops.join(" and ")})"
end

.between ⇒ Object 



15
16
17
 
# File 'lib/rquery/adapters/sql.rb', line 15

def between
    "between ? and ?"
end

.contains ⇒ Object 



31
32
33
 
# File 'lib/rquery/adapters/sql.rb', line 31

def contains
    "like '%' + ? + '%'"
end

.in ⇒ Object 



6
7
8
 
# File 'lib/rquery/adapters/sql.rb', line 6

def in
    "in (?)" 
end

.neq ⇒ Object 



23
24
25
 
# File 'lib/rquery/adapters/sql.rb', line 23

def neq
    "<> ?"
end

.not_between ⇒ Object 



19
20
21
 
# File 'lib/rquery/adapters/sql.rb', line 19

def not_between
    "not #{between}"
end

.not_in ⇒ Object 



10
11
12
13
 
# File 'lib/rquery/adapters/sql.rb', line 10

def not_in
    #using send because 'in' is a keyword
    "not #{send(:in)}"   
end

.or_group(ops) ⇒ Object 



39
40
41
 
# File 'lib/rquery/adapters/sql.rb', line 39

def or_group(ops)
  "(#{ops.join(" or ")})"
end