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::PGRowOp::ExpressionMethods
Methods included from SubscriptMethods
Methods included from StringMethods
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)
1237 1238 1239 |
# File 'lib/sequel/sql.rb', line 1237 def args @args end |
#name ⇒ Object (readonly) Also known as: f
The SQL function to call
1233 1234 1235 |
# File 'lib/sequel/sql.rb', line 1233 def name @name end |
#opts ⇒ Object (readonly)
Options for this function
1240 1241 1242 |
# File 'lib/sequel/sql.rb', line 1240 def opts @opts end |
Class Method Details
.new!(name, args, opts) ⇒ Object
1249 1250 1251 1252 1253 |
# File 'lib/sequel/sql.rb', line 1249 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
1258 1259 1260 1261 1262 1263 1264 1265 |
# File 'lib/sequel/sql.rb', line 1258 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
1270 1271 1272 |
# File 'lib/sequel/sql.rb', line 1270 def distinct with_opts(:distinct=>true) end |
#filter(*args, &block) ⇒ Object
1278 1279 1280 1281 |
# File 'lib/sequel/sql.rb', line 1278 def filter(*args, &block) args = args.first if args.length == 1 with_opts(:filter=>args, :filter_block=>block) end |
#lateral ⇒ Object
1286 1287 1288 |
# File 'lib/sequel/sql.rb', line 1286 def lateral with_opts(:lateral=>true) end |
#over(window = OPTS) ⇒ Object
1293 1294 1295 1296 1297 |
# File 'lib/sequel/sql.rb', line 1293 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
1303 1304 1305 |
# File 'lib/sequel/sql.rb', line 1303 def quoted with_opts(:quoted=>true) end |
#unquoted ⇒ Object
1311 1312 1313 |
# File 'lib/sequel/sql.rb', line 1311 def unquoted with_opts(:quoted=>false) end |
#with_ordinality ⇒ Object
1319 1320 1321 |
# File 'lib/sequel/sql.rb', line 1319 def with_ordinality with_opts(:with_ordinality=>true) end |
#within_group(*expressions) ⇒ Object
1328 1329 1330 |
# File 'lib/sequel/sql.rb', line 1328 def within_group(*expressions) with_opts(:within_group=>expressions) end |