module Sequel::Firebird::DatasetMethods
Constants
- BOOL_FALSE
- BOOL_TRUE
- DEFAULT_FROM
- FIRST
- INSERT_CLAUSE_METHODS
- NULL
- SELECT_CLAUSE_METHODS
- SKIP
Public Instance Methods
insert(*values)
click to toggle source
Insert given values into the database.
Calls superclass method
# 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_select(*values)
click to toggle source
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
requires_sql_standard_datetimes?()
click to toggle source
# File lib/sequel/adapters/shared/firebird.rb, line 175 def requires_sql_standard_datetimes? true end
supports_insert_select?()
click to toggle source
# File lib/sequel/adapters/shared/firebird.rb, line 179 def supports_insert_select? true end
supports_intersect_except?()
click to toggle source
Firebird does not support INTERSECT or EXCEPT
# File lib/sequel/adapters/shared/firebird.rb, line 184 def supports_intersect_except? false end
Private Instance Methods
insert_clause_methods()
click to toggle source
# File lib/sequel/adapters/shared/firebird.rb, line 190 def insert_clause_methods INSERT_CLAUSE_METHODS end
insert_pk(*values)
click to toggle source
# 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
literal_false()
click to toggle source
# File lib/sequel/adapters/shared/firebird.rb, line 199 def literal_false BOOL_FALSE end
literal_true()
click to toggle source
# File lib/sequel/adapters/shared/firebird.rb, line 203 def literal_true BOOL_TRUE end
select_clause_methods()
click to toggle source
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
select_from_sql(sql)
click to toggle source
Use a default FROM table if the dataset does not contain a FROM table.
Calls superclass method
# File lib/sequel/adapters/shared/firebird.rb, line 213 def select_from_sql(sql) if @opts[:from] super else sql << DEFAULT_FROM end end
select_limit_sql(sql)
click to toggle source
# 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