Class: Mysql2::Client

Inherits:
Object
  • Object
show all
Defined in:
lib/mysql2-cs-bind.rb

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.pseudo_bind(sql, values) ⇒ Object

Raises:

  • (ArgumentError) 


20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
# File 'lib/mysql2-cs-bind.rb', line 20

def self.pseudo_bind(sql, values)
  sql = sql.dup

  placeholders = []
  search_pos = 0
  while pos = sql.index('?', search_pos)
    placeholders.push(pos)
    search_pos = pos + 1
  end
  values = values.flatten(1) if placeholders.length == values.flatten(1).length
  raise ArgumentError, "mismatch between placeholders number and values arguments" if placeholders.length != values.length

  while pos = placeholders.pop()
    rawvalue = values.pop()
    if rawvalue.is_a?(Array)
      sql[pos] = rawvalue.map{|v| quote(v) }.join(",")
    else
      sql[pos] = quote(rawvalue)
    end
  end
  sql
end

Instance Method Details

#xquery(sql, *args) ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
 
# File 'lib/mysql2-cs-bind.rb', line 7

def xquery(sql, *args)
  options = if args.size > 0 and args[-1].is_a?(Hash)
              args.pop
            else
              {}
            end
  if args.size < 1
    query(sql, options)
  else
    query(Mysql2::Client.pseudo_bind(sql, args), options)
  end
end