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 



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

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

.duration(s, expr) ⇒ Object 



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

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

.false ⇒ Object

The FALSE pseudo literal.



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

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

.grouping(*v) ⇒ Object 



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

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

.json(*expr) ⇒ Object 



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

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

.null ⇒ Object

The NULL literal.



125
126
127
 
# File 'lib/arel_extensions.rb', line 125

def self.null
  Arel.quoted(nil)
end

.quoted(*args) ⇒ Object 



129
130
131
 
# File 'lib/arel_extensions.rb', line 129

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

.rand ⇒ Object 



133
134
135
 
# File 'lib/arel_extensions.rb', line 133

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

.rollup(*args) ⇒ Object 



137
138
139
 
# File 'lib/arel_extensions.rb', line 137

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

.shorten(s) ⇒ Object 



141
142
143
 
# File 'lib/arel_extensions.rb', line 141

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

.true ⇒ Object

The TRUE pseudo literal.



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

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

.tuple(*v) ⇒ Object 



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

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) “`



160
161
162
 
# File 'lib/arel_extensions.rb', line 160

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