Class: MiniSql::Builder

Inherits:
Object
  • Object
show all
Defined in:
lib/mini_sql/builder.rb

Instance Method Summary collapse

Constructor Details

#initialize(connection, template) ⇒ Builder

Returns a new instance of Builder.



3
4
5
6
7
8
 
# File 'lib/mini_sql/builder.rb', line 3

def initialize(connection, template)
  @args = {}
  @sql = template
  @sections = {}
  @connection = connection
end

Instance Method Details

#exec(args = nil) ⇒ Object 



56
57
58
59
60
61
62
 
# File 'lib/mini_sql/builder.rb', line 56

def exec(args = nil)
  if args
    @args.merge!(args)
  end
  sql = to_sql
  @connection.query(sql, args)
end

#query(args = nil) ⇒ Object 



48
49
50
51
52
53
54
 
# File 'lib/mini_sql/builder.rb', line 48

def query(args = nil)
  if args
    @args.merge!(args)
  end
  sql = to_sql
  @connection.query(sql, args)
end

#to_sql ⇒ Object 



19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
# File 'lib/mini_sql/builder.rb', line 19

def to_sql
  sql = @sql.dup

  @sections.each do |k, v|
    joined = nil
    case k
    when :select
      joined = "SELECT " << v.join(" , ")
    when :where, :where2
      joined = "WHERE " << v.map { |c| "(" << c << ")" }.join(" AND ")
    when :join
      joined = v.map { |item| "JOIN " << item }.join("\n")
    when :left_join
      joined = v.map { |item| "LEFT JOIN " << item }.join("\n")
    when :limit
      joined = "LIMIT " << v.last.to_s
    when :offset
      joined = "OFFSET " << v.last.to_s
    when :order_by
      joined = "ORDER BY " << v.join(" , ")
    when :set
      joined = "SET " << v.join(" , ")
    end

    sql.sub!("/*#{k}*/", joined)
  end
  sql
end