Insert given values into the database.
# File lib/sequel/adapters/shared/firebird.rb, line 184 def insert(*values) if @opts[:sql] || @opts[:returning] super else returning(insert_pk).insert(*values){|r| return r.values.first} end end
Insert a record returning the record inserted
# File lib/sequel/adapters/shared/firebird.rb, line 193 def insert_select(*values) with_sql_first(insert_select_sql(*values)) end
The SQL to use for an #insert_select, adds a RETURNING clause to the insert unless the RETURNING clause is already present.
# File lib/sequel/adapters/shared/firebird.rb, line 199 def insert_select_sql(*values) ds = opts[:returning] ? self : returning ds.insert_sql(*values) end
# File lib/sequel/adapters/shared/firebird.rb, line 204 def requires_sql_standard_datetimes? true end
# File lib/sequel/adapters/shared/firebird.rb, line 208 def supports_cte?(type=:select) type == :select end
# File lib/sequel/adapters/shared/firebird.rb, line 212 def supports_insert_select? true end
Firebird does not support INTERSECT or EXCEPT
# File lib/sequel/adapters/shared/firebird.rb, line 217 def supports_intersect_except? false end
# File lib/sequel/adapters/shared/firebird.rb, line 221 def supports_returning?(type) type == :insert end