Class: Sequel::SQL::Function
- Inherits:
-
GenericExpression
- Object
- Expression
- GenericExpression
- Sequel::SQL::Function
- Defined in:
- lib/sequel/sql.rb,
lib/sequel/extensions/eval_inspect.rb
Overview
Represents an SQL function call.
Constant Summary collapse
- WILDCARD =
LiteralString.new('*').freeze
- DISTINCT =
["DISTINCT ".freeze].freeze
- COMMA_ARRAY =
[LiteralString.new(', ').freeze].freeze
Instance Attribute Summary collapse
-
#args ⇒ Object
readonly
The array of arguments to pass to the function (may be blank).
-
#name ⇒ Object
(also: #f)
readonly
The SQL function to call.
-
#opts ⇒ Object
readonly
Options for this function.
Class Method Summary collapse
Instance Method Summary collapse
-
#*(ce = (arg=false;nil)) ⇒ Object
If no arguments are given, return a new function with the wildcard prepended to the arguments.
-
#distinct ⇒ Object
Return a new function with DISTINCT before the method arguments.
-
#filter(*args, &block) ⇒ Object
Return a new function with FILTER added to it, for filtered aggregate functions:.
-
#initialize(name, *args) ⇒ Function
constructor
Set the name and args for the function.
-
#lateral ⇒ Object
Return a function which will use LATERAL when literalized:.
-
#over(window = OPTS) ⇒ Object
Return a new function with an OVER clause (making it a window function).
-
#quoted ⇒ Object
Return a new function where the function name will be quoted if the database supports quoted functions:.
-
#unquoted ⇒ Object
Return a new function where the function name will not be quoted even if the database supports quoted functions:.
-
#with_ordinality ⇒ Object
Return a new function that will use WITH ORDINALITY to also return a row number for every row the function returns:.
-
#within_group(*expressions) ⇒ Object
Return a new function that uses WITHIN GROUP ordered by the given expression, useful for ordered-set and hypothetical-set aggregate functions:.
Methods included from Postgres::HStoreOpMethods
Methods included from Postgres::RangeOpMethods
Methods included from Postgres::ArrayOpMethods
Methods included from Postgres::JSONOpMethods
Methods included from Postgres::InetOpMethods
Methods included from Postgres::PGRowOp::ExpressionMethods
Methods included from SubscriptMethods
Methods included from StringMethods
Methods included from PatternMatchMethods
Methods included from OrderMethods
Methods included from NumericMethods
Methods included from ComplexExpressionMethods
#extract, #sql_boolean, #sql_number, #sql_string
Methods included from CastMethods
#cast, #cast_numeric, #cast_string
Methods included from BooleanMethods
Methods included from AliasMethods
Methods inherited from Expression
#==, attr_reader, #eql?, #hash, inherited, #inspect, #lit, #sql_literal
Constructor Details
Instance Attribute Details
#args ⇒ Object (readonly)
The array of arguments to pass to the function (may be blank)
1283 1284 1285 |
# File 'lib/sequel/sql.rb', line 1283 def args @args end |
#name ⇒ Object (readonly) Also known as: f
The SQL function to call
1279 1280 1281 |
# File 'lib/sequel/sql.rb', line 1279 def name @name end |
#opts ⇒ Object (readonly)
Options for this function
1286 1287 1288 |
# File 'lib/sequel/sql.rb', line 1286 def opts @opts end |
Class Method Details
.new!(name, args, opts) ⇒ Object
1295 1296 1297 1298 1299 |
# File 'lib/sequel/sql.rb', line 1295 def self.new!(name, args, opts) f = new(name, *args) f.instance_variable_set(:@opts, opts) f end |
Instance Method Details
#*(ce = (arg=false;nil)) ⇒ Object
1304 1305 1306 1307 1308 1309 1310 1311 |
# File 'lib/sequel/sql.rb', line 1304 def *(ce=(arg=false;nil)) if arg == false raise Error, "Cannot apply * to functions with arguments" unless args.empty? with_opts(:"*"=>true) else super(ce) end end |
#distinct ⇒ Object
1316 1317 1318 |
# File 'lib/sequel/sql.rb', line 1316 def distinct with_opts(:distinct=>true) end |
#filter(*args, &block) ⇒ Object
1324 1325 1326 1327 |
# File 'lib/sequel/sql.rb', line 1324 def filter(*args, &block) args = args.first if args.length == 1 with_opts(:filter=>args, :filter_block=>block) end |
#lateral ⇒ Object
1332 1333 1334 |
# File 'lib/sequel/sql.rb', line 1332 def lateral with_opts(:lateral=>true) end |
#over(window = OPTS) ⇒ Object
1339 1340 1341 1342 1343 |
# File 'lib/sequel/sql.rb', line 1339 def over(window=OPTS) raise Error, "function already has a window applied to it" if opts[:over] window = Window.new(window) unless window.is_a?(Window) with_opts(:over=>window) end |
#quoted ⇒ Object
1349 1350 1351 |
# File 'lib/sequel/sql.rb', line 1349 def quoted with_opts(:quoted=>true) end |
#unquoted ⇒ Object
1357 1358 1359 |
# File 'lib/sequel/sql.rb', line 1357 def unquoted with_opts(:quoted=>false) end |
#with_ordinality ⇒ Object
1365 1366 1367 |
# File 'lib/sequel/sql.rb', line 1365 def with_ordinality with_opts(:with_ordinality=>true) end |
#within_group(*expressions) ⇒ Object
1374 1375 1376 |
# File 'lib/sequel/sql.rb', line 1374 def within_group(*expressions) with_opts(:within_group=>expressions) end |