Module | Sequel::Firebird::DatabaseMethods |
In: |
lib/sequel/adapters/shared/firebird.rb
|
AUTO_INCREMENT | = | ''.freeze |
TEMPORARY | = | 'GLOBAL TEMPORARY '.freeze |
# File lib/sequel/adapters/shared/firebird.rb, line 13 13: def clear_primary_key(*tables) 14: tables.each{|t| @primary_keys.delete(dataset.send(:input_identifier, t))} 15: end
# File lib/sequel/adapters/shared/firebird.rb, line 17 17: def create_trigger(*args) 18: self << create_trigger_sql(*args) 19: end
# File lib/sequel/adapters/shared/firebird.rb, line 25 25: def drop_sequence(name) 26: self << drop_sequence_sql(name) 27: end
Return primary key for the given table.
# File lib/sequel/adapters/shared/firebird.rb, line 30 30: def primary_key(table) 31: t = dataset.send(:input_identifier, table) 32: @primary_keys.fetch(t) do 33: pk = fetch("SELECT RDB$FIELD_NAME FROM RDB$INDEX_SEGMENTS NATURAL JOIN RDB$RELATION_CONSTRAINTS WHERE RDB$CONSTRAINT_TYPE = 'PRIMARY KEY' AND RDB$RELATION_NAME = ?", t).single_value 34: @primary_keys[t] = dataset.send(:output_identifier, pk.rstrip) if pk 35: end 36: end
# File lib/sequel/adapters/shared/firebird.rb, line 38 38: def restart_sequence(*args) 39: self << restart_sequence_sql(*args) 40: end
# File lib/sequel/adapters/shared/firebird.rb, line 42 42: def sequences(opts=OPTS) 43: ds = self["rdb$generators""rdb$generators"].server(opts[:server]).filter("rdb$system_flag""rdb$system_flag" => 0).select("rdb$generator_name""rdb$generator_name") 44: block_given? ? yield(ds) : ds.map{|r| ds.send(:output_identifier, r["rdb$generator_name""rdb$generator_name"])} 45: end
# File lib/sequel/adapters/shared/firebird.rb, line 47 47: def tables(opts=OPTS) 48: tables_or_views(0, opts) 49: end