Class: Card::Query::SqlStatement

Inherits:
Object
  • Object
show all
Includes:
Joins, Order, Where
Defined in:
lib/card/query/sql_statement.rb,
lib/card/query/sql_statement/joins.rb,
lib/card/query/sql_statement/order.rb,
lib/card/query/sql_statement/where.rb

Overview

convert @query sort rep into order by statement order information is stored in @mods[:sort], @mods[:sort_as], and @mods[:dir]

Defined Under Namespace

Modules: Joins, Order, Where

Constant Summary collapse

ORDER_MAP = 
{
  "id" => "id",
  "update" => "updated_at",
  "create" => "created_at",
  "name" => "key",
  "content" => "db_content",
  "alpha" => "key",       # DEPRECATED
  "relevance" => "updated_at" # DEPRECATED
}.freeze

Instance Method Summary collapse

Methods included from Order

#order, #order_as, #order_config, #order_dir, #order_directive, #order_directives, #order_field

Methods included from Where

#basic_conditions, #condition_joint, #conditions_from, #exist_condition, #explicit_conditions, #format_conditions, #implicit_conditions, #in_condition, #maybe_not, #permission_conditions, #spaced_subquery_sql, #standard_condition, #trash_condition, #where

Methods included from Joins

#join_clause, #join_clause_parts, #join_table, #joins, #joins_on_query, #on_card_conditions, #on_clause, #subjoins

Constructor Details

#initialize(query = nil) ⇒ SqlStatement

Returns a new instance of SqlStatement.



22
23
24
25
 
# File 'lib/card/query/sql_statement.rb', line 22

def initialize query=nil
  @query = query
  @mods = query&.mods
end

Instance Method Details

#build ⇒ Object 



27
28
29
30
31
32
33
34
35
36
 
# File 'lib/card/query/sql_statement.rb', line 27

def build
  @fields = fields
  @tables = tables
  @joins  = joins
  @where  = where
  @group  = group
  @order  = order
  @limit_and_offset = limit_and_offset
  self
end

#cast_type(type) ⇒ Object 



115
116
117
118
 
# File 'lib/card/query/sql_statement.rb', line 115

def cast_type type
  cxn ||= ActiveRecord::Base.connection
  (val = cxn.cast_types[type.to_sym]) ? val[:name] : safe_sql(type)
end

#comment ⇒ Object 



56
57
58
59
60
 
# File 'lib/card/query/sql_statement.rb', line 56

def comment
  return nil unless Card.config.sql_comments && @query.comment

  "/* #{@query.comment} */\n"
end

#fields ⇒ Object 



66
67
68
69
70
71
72
 
# File 'lib/card/query/sql_statement.rb', line 66

def fields
  table = @query.table_alias
  field = @mods[:return] unless @mods[:return] =~ /^_\w+/
  field = field.blank? ? :card : field.to_sym
  field = full_field(table, field)
  [field, @mods[:sort_join_field]].compact * ", "
end

#from ⇒ Object 



48
49
50
 
# File 'lib/card/query/sql_statement.rb', line 48

def from
  "FROM #{@tables}"
end

#full_field(table, field) ⇒ Object 



74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
 
# File 'lib/card/query/sql_statement.rb', line 74

def full_field table, field
  case field
  when :raw      then "#{table}.*"
  when :card     then "#{table}.*"
  when :content  then "#{table}.db_content"
  when :count
    "coalesce(count( distinct #{table}.id),0) as count"
  else
    if ATTRIBUTES[field.to_sym] == :basic
      "#{table}.#{field}"
    else
      safe_sql field
    end
  end
end

#full_syntax ⇒ Object 



107
108
109
 
# File 'lib/card/query/sql_statement.rb', line 107

def full_syntax
  @query.full? ? yield : return
end

#group ⇒ Object 



90
91
92
93
 
# File 'lib/card/query/sql_statement.rb', line 90

def group
  group = @mods[:group]
  "GROUP BY #{safe_sql group}" if group.present?
end

#leading_space ⇒ Object 



52
53
54
 
# File 'lib/card/query/sql_statement.rb', line 52

def leading_space
  " " * (@query.depth * 2)
end

#limit_and_offset ⇒ Object 



95
96
97
98
99
100
101
102
103
104
105
 
# File 'lib/card/query/sql_statement.rb', line 95

def limit_and_offset
  full_syntax do
    limit = @mods[:limit]
    offset = @mods[:offset]
    if limit.to_i.positive?
      string =  "LIMIT  #{limit.to_i} "
      string += "OFFSET #{offset.to_i} " if offset.present?
      string
    end
  end
end

#safe_sql(txt) ⇒ Object 



111
112
113
 
# File 'lib/card/query/sql_statement.rb', line 111

def safe_sql txt
  Query.safe_sql txt
end

#select ⇒ Object 



44
45
46
 
# File 'lib/card/query/sql_statement.rb', line 44

def select
  "#{leading_space}SELECT DISTINCT #{@fields}"
end

#tables ⇒ Object 



62
63
64
 
# File 'lib/card/query/sql_statement.rb', line 62

def tables
  "#{@query.table} #{@query.table_alias}"
end

#to_s ⇒ Object 



38
39
40
41
42
 
# File 'lib/card/query/sql_statement.rb', line 38

def to_s
  [
    comment, select, from, @joins, @where, @group, @order, @limit_and_offset
  ].compact.join " "
end