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 170
170:       def insert(*values)
171:         if @opts[:sql] || @opts[:returning]
172:           super
173:         else
174:           returning(insert_pk).insert(*values){|r| return r.values.first}
175:         end
176:       end

Insert a record returning the record inserted

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 179
179:       def insert_select(*values)
180:         with_sql_first(insert_select_sql(*values))
181:       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 185
185:       def insert_select_sql(*values)
186:         ds = opts[:returning] ? self : returning
187:         ds.insert_sql(*values)
188:       end

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 190
190:       def requires_sql_standard_datetimes?
191:         true
192:       end

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 194
194:       def supports_cte?(type=:select)
195:         type == :select
196:       end

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 198
198:       def supports_insert_select?
199:         true
200:       end

Firebird does not support INTERSECT or EXCEPT

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 203
203:       def supports_intersect_except?
204:         false
205:       end

[Source]

     # File lib/sequel/adapters/shared/firebird.rb, line 207
207:       def supports_returning?(type)
208:         type == :insert
209:       end

[Validate]