Module Sequel::Firebird::DatasetMethods
In: lib/sequel/adapters/shared/firebird.rb

Methods

Constants

BOOL_TRUE = '1'.freeze
BOOL_FALSE = '0'.freeze
NULL = LiteralString.new('NULL').freeze
FIRST = " FIRST ".freeze
SKIP = " SKIP ".freeze
DEFAULT_FROM = " FROM RDB$DATABASE"

Public Instance methods

Insert given values into the database.

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 174
174:       def insert(*values)
175:         if @opts[:sql] || @opts[:returning]
176:           super
177:         else
178:           returning(insert_pk).insert(*values){|r| return r.values.first}
179:         end
180:       end

Insert a record returning the record inserted

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 183
183:       def insert_select(*values)
184:         with_sql_first(insert_select_sql(*values))
185:       end

The SQL to use for an insert_select, adds a RETURNING clause to the insert unless the RETURNING clause is already present.

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 189
189:       def insert_select_sql(*values)
190:         ds = opts[:returning] ? self : returning
191:         ds.insert_sql(*values)
192:       end

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 194
194:       def requires_sql_standard_datetimes?
195:         true
196:       end

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 198
198:       def supports_cte?(type=:select)
199:         type == :select
200:       end

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 202
202:       def supports_insert_select?
203:         true
204:       end

Firebird does not support INTERSECT or EXCEPT

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 207
207:       def supports_intersect_except?
208:         false
209:       end

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 211
211:       def supports_returning?(type)
212:         type == :insert
213:       end

[Validate]