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 160
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 169
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 173
def requires_sql_standard_datetimes?
  true
end
supports_insert_select?() click to toggle source
# File lib/sequel/adapters/shared/firebird.rb, line 177
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 182
def supports_intersect_except?
  false
end

Private Instance Methods

insert_clause_methods() click to toggle source
# File lib/sequel/adapters/shared/firebird.rb, line 188
def insert_clause_methods
  INSERT_CLAUSE_METHODS
end
insert_pk(*values) click to toggle source
# File lib/sequel/adapters/shared/firebird.rb, line 192
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 197
def literal_false
  BOOL_FALSE
end
literal_true() click to toggle source
# File lib/sequel/adapters/shared/firebird.rb, line 201
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 206
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 211
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 219
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