Module: Sequel::Firebird::DatasetMethods

Included in:
Dataset
Defined in:
lib/sequel/adapters/shared/firebird.rb

Constant Summary

BOOL_TRUE =
'1'.freeze
BOOL_FALSE =
'0'.freeze
NULL =
LiteralString.new('NULL').freeze
FIRST =
" FIRST ".freeze
SKIP =
" SKIP ".freeze
DEFAULT_FROM =
" FROM RDB$DATABASE"

Instance Method Summary collapse

Instance Method Details

#insert(*values) ⇒ Object

Insert given values into the database.



168
169
170
171
172
173
174
# File 'lib/sequel/adapters/shared/firebird.rb', line 168

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) ⇒ Object

Insert a record returning the record inserted



177
178
179
# File 'lib/sequel/adapters/shared/firebird.rb', line 177

def insert_select(*values)
  with_sql_first(insert_select_sql(*values))
end

#insert_select_sql(*values) ⇒ Object

The SQL to use for an insert_select, adds a RETURNING clause to the insert unless the RETURNING clause is already present.



183
184
185
186
# File 'lib/sequel/adapters/shared/firebird.rb', line 183

def insert_select_sql(*values)
  ds = opts[:returning] ? self : returning
  ds.insert_sql(*values)
end

#requires_sql_standard_datetimes?Boolean

Returns:

  • (Boolean)


188
189
190
# File 'lib/sequel/adapters/shared/firebird.rb', line 188

def requires_sql_standard_datetimes?
  true
end

#supports_cte?(type = :select) ⇒ Boolean

Returns:

  • (Boolean)


192
193
194
# File 'lib/sequel/adapters/shared/firebird.rb', line 192

def supports_cte?(type=:select)
  type == :select
end

#supports_insert_select?Boolean

Returns:

  • (Boolean)


196
197
198
# File 'lib/sequel/adapters/shared/firebird.rb', line 196

def supports_insert_select?
  true
end

#supports_intersect_except?Boolean

Firebird does not support INTERSECT or EXCEPT

Returns:

  • (Boolean)


201
202
203
# File 'lib/sequel/adapters/shared/firebird.rb', line 201

def supports_intersect_except?
  false
end

#supports_returning?(type) ⇒ Boolean

Returns:

  • (Boolean)


205
206
207
# File 'lib/sequel/adapters/shared/firebird.rb', line 205

def supports_returning?(type)
  type == :insert
end