Insert given values into the database.
# File lib/sequel/adapters/shared/firebird.rb, line 162 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 171 def insert_select(*values) returning.insert(*values){|r| return r} end
# File lib/sequel/adapters/shared/firebird.rb, line 175 def requires_sql_standard_datetimes? true end
# File lib/sequel/adapters/shared/firebird.rb, line 179 def supports_insert_select? true end
Firebird does not support INTERSECT or EXCEPT
# File lib/sequel/adapters/shared/firebird.rb, line 184 def supports_intersect_except? false end
# File lib/sequel/adapters/shared/firebird.rb, line 190 def insert_clause_methods INSERT_CLAUSE_METHODS end
# File lib/sequel/adapters/shared/firebird.rb, line 194 def insert_pk(*values) pk = db.primary_key(opts[:from].first) pk ? Sequel::SQL::Identifier.new(pk) : NULL end
# File lib/sequel/adapters/shared/firebird.rb, line 199 def literal_false BOOL_FALSE end
# File lib/sequel/adapters/shared/firebird.rb, line 203 def literal_true BOOL_TRUE end
The order of clauses in the SELECT SQL statement
# File lib/sequel/adapters/shared/firebird.rb, line 208 def select_clause_methods SELECT_CLAUSE_METHODS end
Use a default FROM table if the dataset does not contain a FROM table.
# File lib/sequel/adapters/shared/firebird.rb, line 213 def select_from_sql(sql) if @opts[:from] super else sql << DEFAULT_FROM end end
# File lib/sequel/adapters/shared/firebird.rb, line 221 def select_limit_sql(sql) if l = @opts[:limit] sql << FIRST literal_append(sql, l) end if o = @opts[:offset] sql << SKIP literal_append(sql, o) end end