Module: Arel

Defined in:
lib/arel_extensions/nodes/select.rb,
lib/arel_extensions.rb

Defined Under Namespace

Modules: Nodes Classes: InsertManager, SelectManager, Table

Class Method Summary collapse

Class Method Details

.column_of(table_name, column_name) ⇒ Object 



98
99
100
 
# File 'lib/arel_extensions.rb', line 98

def self.column_of table_name, column_name
  ArelExtensions.column_of(table_name, column_name)
end

.duration(s, expr) ⇒ Object 



102
103
104
 
# File 'lib/arel_extensions.rb', line 102

def self.duration s, expr
  ArelExtensions::Nodes::Duration.new("#{s}i", expr)
end

.false ⇒ Object

The FALSE pseudo literal.



107
108
109
 
# File 'lib/arel_extensions.rb', line 107

def self.false
  Arel::Nodes::Equality.new(1, 0)
end

.grouping(*v) ⇒ Object 



111
112
113
 
# File 'lib/arel_extensions.rb', line 111

def self.grouping *v
  Arel::Nodes::Grouping.new(*v)
end

.json(*expr) ⇒ Object 



115
116
117
118
119
120
121
122
123
 
# File 'lib/arel_extensions.rb', line 115

def self.json *expr
  ArelExtensions::Nodes::Json.new(
    if expr.length == 1
      expr.first
    else
      expr
    end
  )
end

.json_false ⇒ Object 



135
136
137
138
139
140
141
142
143
 
# File 'lib/arel_extensions.rb', line 135

def self.json_false
  res = Arel.grouping(Arel.quoted('false'))
  res.instance_eval {
    def return_type
      :boolean
    end
  }
  res
end

.json_true ⇒ Object 



125
126
127
128
129
130
131
132
133
 
# File 'lib/arel_extensions.rb', line 125

def self.json_true
  res = Arel.grouping(Arel.quoted('true'))
  res.instance_eval {
    def return_type
      :boolean
    end
  }
  res
end

.null ⇒ Object

The NULL literal.



146
147
148
 
# File 'lib/arel_extensions.rb', line 146

def self.null
  Arel.quoted(nil)
end

.quoted(*args) ⇒ Object 



150
151
152
 
# File 'lib/arel_extensions.rb', line 150

def self.quoted *args
  Arel::Nodes.build_quoted(*args)
end

.rand ⇒ Object 



154
155
156
 
# File 'lib/arel_extensions.rb', line 154

def self.rand
  ArelExtensions::Nodes::Rand.new
end

.rollup(*args) ⇒ Object 



158
159
160
 
# File 'lib/arel_extensions.rb', line 158

def self.rollup(*args)
  Arel::Nodes::RollUp.new(args)
end

.shorten(s) ⇒ Object 



162
163
164
 
# File 'lib/arel_extensions.rb', line 162

def self.shorten s
  Base64.urlsafe_encode64(Digest::MD5.new.digest(s)).tr('=', '').tr('-', '_')
end

.true ⇒ Object

The TRUE pseudo literal.



167
168
169
 
# File 'lib/arel_extensions.rb', line 167

def self.true
  Arel::Nodes::Equality.new(1, 1)
end

.tuple(*v) ⇒ Object 



171
172
173
174
 
# File 'lib/arel_extensions.rb', line 171

def self.tuple *v
  tmp = Arel.grouping(nil)
  Arel.grouping v.map{|e| tmp.convert_to_node(e)}
end

.when(condition) ⇒ Object

For instance

“‘ Arel.when(at.is_null).then(0).else(1) “`



181
182
183
 
# File 'lib/arel_extensions.rb', line 181

def self.when condition
  ArelExtensions::Nodes::Case.new.when(condition)
end