Module Sequel::Oracle::DatabaseMethods
In: lib/sequel/adapters/shared/oracle.rb

Methods

create_sequence   create_trigger   current_user   database_type   drop_sequence   global_index_namespace?   supports_deferrable_constraints?   supports_transaction_isolation_levels?   tables   view_exists?   views  

Constants

TEMPORARY = 'GLOBAL TEMPORARY '.freeze
AUTOINCREMENT = ''.freeze
DATABASE_ERROR_REGEXPS = { /unique constraint .+ violated/ => UniqueConstraintViolation, /integrity constraint .+ violated/ => ForeignKeyConstraintViolation, /check constraint .+ violated/ => CheckConstraintViolation, /cannot insert NULL into|cannot update .+ to NULL/ => NotNullConstraintViolation, /can't serialize access for this transaction/ => SerializationFailure, }.freeze
TRANSACTION_ISOLATION_LEVELS = {:uncommitted=>'READ COMMITTED'.freeze, :committed=>'READ COMMITTED'.freeze, :repeatable=>'SERIALIZABLE'.freeze, :serializable=>'SERIALIZABLE'.freeze}

Attributes

autosequence  [RW] 

Public Instance methods

create_sequence(name, opts={})

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 13
13:       def create_sequence(name, opts={})
14:         self << create_sequence_sql(name, opts)
15:       end
create_trigger(*args)

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 17
17:       def create_trigger(*args)
18:         self << create_trigger_sql(*args)
19:       end
current_user()

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 21
21:       def current_user
22:         @current_user ||= metadata_dataset.get{sys_context('USERENV', 'CURRENT_USER')}
23:       end
database_type()

Oracle uses the :oracle database type

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 30
30:       def database_type
31:         :oracle
32:       end
drop_sequence(name)

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 25
25:       def drop_sequence(name)
26:         self << drop_sequence_sql(name)
27:       end
global_index_namespace?()

Oracle namespaces indexes per table.

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 35
35:       def global_index_namespace?
36:         false
37:       end
supports_deferrable_constraints?()

Oracle supports deferrable constraints.

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 55
55:       def supports_deferrable_constraints?
56:         true
57:       end
supports_transaction_isolation_levels?()

DB2 supports transaction isolation levels.

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 60
60:       def supports_transaction_isolation_levels?
61:         true
62:       end
tables(opts={})

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 39
39:       def tables(opts={})
40:         m = output_identifier_meth
41:         metadata_dataset.from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'TABLE').map{|r| m.call(r[:tname])}
42:       end
view_exists?(name)

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 49
49:       def view_exists?(name) 
50:         m = input_identifier_meth
51:         metadata_dataset.from(:tab).filter(:tname =>m.call(name), :tabtype => 'VIEW').count > 0 
52:       end
views(opts={})

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 44
44:       def views(opts={}) 
45:         m = output_identifier_meth
46:         metadata_dataset.from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'VIEW').map{|r| m.call(r[:tname])}
47:       end

[Validate]