Class: DirectiveRecord::Query::SQL

Inherits:
Object
  • Object
show all
Defined in:
lib/directive_record/query/sql.rb

Direct Known Subclasses

BigQuery, MySQL

Instance Method Summary collapse

Constructor Details

#initialize(base) ⇒ SQL

Returns a new instance of SQL.



5
6
7
 
# File 'lib/directive_record/query/sql.rb', line 5

def initialize(base)
  @base = base
end

Instance Method Details

#to_sql(*args) ⇒ Object 



9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
 
# File 'lib/directive_record/query/sql.rb', line 9

def to_sql(*args)
  options = to_options(args)
  validate_options! options

  original_options = options.deep_dup
  original_options.reject!{|k, v| v.nil?}

  check_path_delimiter! options
  optimize_query! options

  prepare_options! options
  normalize_options! options, original_options

  parse_joins! options

  prepend_base_alias! options
  finalize_options! options

  flatten_options! options
  compose_sql options
end

#to_trend_sql(q1, q2, join_column_count, options) ⇒ Object 



31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
# File 'lib/directive_record/query/sql.rb', line 31

def to_trend_sql(q1, q2, join_column_count, options)
  i      = join_column_count + 1
  select = "q1.*, q2.c#{i}, (((q1.c#{i} - q2.c#{i}) / ABS(q2.c#{i})) * 100) AS trend"
  on     = (1..join_column_count).to_a.collect{|x| "q1.c#{x} = q2.c#{x}"}.join(" AND ")
  order  = "\nORDER BY #{options[:order]}" if options[:order]
  limit  = "\nLIMIT #{options[:limit]}" if options[:limit]
  offset = "\nOFFSET #{options[:offset]}" if options[:offset]
"SELECT \#{select}\nFROM\n(\\n\#{q1}\\n) q1\nINNER JOIN\n(\\n\#{q2}\\n) q2\nON \#{on}\#{order}\#{limit}\#{offset}\n"
end