Module Sequel::Firebird::DatabaseMethods
In: lib/sequel/adapters/shared/firebird.rb

Methods

Constants

AUTO_INCREMENT = ''.freeze
TEMPORARY = 'GLOBAL TEMPORARY '.freeze

Public Instance methods

[Source]

    # File lib/sequel/adapters/shared/firebird.rb, line 9
 9:       def clear_primary_key(*tables)
10:         tables.each{|t| @primary_keys.delete(dataset.send(:input_identifier, t))}
11:       end

[Source]

    # File lib/sequel/adapters/shared/firebird.rb, line 13
13:       def create_trigger(*args)
14:         self << create_trigger_sql(*args)
15:       end

[Source]

    # File lib/sequel/adapters/shared/firebird.rb, line 17
17:       def database_type
18:         :firebird
19:       end

[Source]

    # File lib/sequel/adapters/shared/firebird.rb, line 21
21:       def drop_sequence(name)
22:         self << drop_sequence_sql(name)
23:       end

Return primary key for the given table.

[Source]

    # File lib/sequel/adapters/shared/firebird.rb, line 26
26:       def primary_key(table)
27:         t = dataset.send(:input_identifier, table)
28:         @primary_keys.fetch(t) do
29:           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
30:           @primary_keys[t] = dataset.send(:output_identifier, pk.rstrip) if pk
31:         end
32:       end

[Source]

    # File lib/sequel/adapters/shared/firebird.rb, line 34
34:       def restart_sequence(*args)
35:         self << restart_sequence_sql(*args)
36:       end

[Source]

    # File lib/sequel/adapters/shared/firebird.rb, line 38
38:       def sequences(opts=OPTS)
39:         ds = self["rdb$generators""rdb$generators"].server(opts[:server]).filter("rdb$system_flag""rdb$system_flag" => 0).select("rdb$generator_name""rdb$generator_name")
40:         block_given? ? yield(ds) : ds.map{|r| ds.send(:output_identifier, r["rdb$generator_name""rdb$generator_name"])}
41:       end

[Source]

    # File lib/sequel/adapters/shared/firebird.rb, line 43
43:       def tables(opts=OPTS)
44:         tables_or_views(0, opts)
45:       end

[Source]

    # File lib/sequel/adapters/shared/firebird.rb, line 47
47:       def views(opts=OPTS)
48:         tables_or_views(1, opts)
49:       end

[Validate]