Method: CandySql::Interpreter.statement

Defined in:
lib/candy--sql/interpreter.rb

.statement(src, var) ⇒ Object 



6
7
8
9
10
11
12
13
14
15
16
17
18
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
 
# File 'lib/candy--sql/interpreter.rb', line 6

def statement(src, var)

  if src[1] == "--"
    if  src[0] == "G"

      src[0] = "GROUP BY"

    elsif src[0] == "O"

      src[0] = "ORDER BY"

    elsif src[0] == "H"

      src[0] = "HAVING"

    else
      if src[0] == "S"

        src[0] = "SELECT"
      
      elsif src[0] == "F"

        src[0] = "FROM"

      elsif src[0] == "W"

        src[0] = "WHERE"

      end
      src.each_with_index do |t, i|
        if t == "=<"
          src[i] = "INNER JOIN"
          src.insert( i, "\n" )
        elsif t == "<<"
          src[i] = "LEFT JOIN"
          src.insert( i, "\n" )
        elsif t == ">>"
          src[i] = "RIGHT JOIN"
          src.insert( i, "\n" )
        elsif var.key?(t)
          src[i] = var[t]
          if src[i+1] == ","
            src[i+1] = ",\n"
          end
        end
      end
    end
    src.slice!( 1, 1 )

  elsif src[1] == "-"

    if src[0] == "A"

      src[0] = "AND"

    elsif src[0] == "O"

      src[0] = "OR"

    end
    src.slice!( 1, 1 )
    src.each_with_index do |t, i|
      if var.key?(t)
        src[i] = var[t]
      end
    end
  end

  return src.join(" ").gsub(/\s\(/, "(").gsub(/\s,/, ",")
end