Module: Sequel::Oracle::DatabaseMethods

Included in:
JDBC::Oracle::DatabaseMethods, Database
Defined in:
lib/sequel/adapters/shared/oracle.rb

Constant Summary collapse

TEMPORARY = 
'GLOBAL TEMPORARY '.freeze
AUTOINCREMENT = 
''.freeze

Instance Attribute Summary collapse

Instance Method Summary collapse

Instance Attribute Details

#autosequence ⇒ Object

Returns the value of attribute autosequence.



9
10
11
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 9

def autosequence
  @autosequence
end

Instance Method Details

#create_sequence(name, opts = {}) ⇒ Object 



11
12
13
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 11

def create_sequence(name, opts={})
  self << create_sequence_sql(name, opts)
end

#create_trigger(*args) ⇒ Object 



15
16
17
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 15

def create_trigger(*args)
  self << create_trigger_sql(*args)
end

#current_user ⇒ Object 



19
20
21
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 19

def current_user
  @current_user ||= metadata_dataset.get{sys_context('USERENV', 'CURRENT_USER')}
end

#database_type ⇒ Object

Oracle uses the :oracle database type



28
29
30
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 28

def database_type
  :oracle
end

#drop_sequence(name) ⇒ Object 



23
24
25
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 23

def drop_sequence(name)
  self << drop_sequence_sql(name)
end

#global_index_namespace? ⇒ Boolean

Oracle namespaces indexes per table.

Returns:

  • (Boolean) 


33
34
35
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 33

def global_index_namespace?
  false
end

#supports_deferrable_constraints? ⇒ Boolean

Oracle supports deferrable constraints.

Returns:

  • (Boolean) 


53
54
55
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 53

def supports_deferrable_constraints?
  true
end

#tables(opts = {}) ⇒ Object 



37
38
39
40
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 37

def tables(opts={})
  m = output_identifier_meth
  metadata_dataset.from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'TABLE').map{|r| m.call(r[:tname])}
end

#view_exists?(name) ⇒ Boolean

Returns:

  • (Boolean) 


47
48
49
50
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 47

def view_exists?(name) 
  m = input_identifier_meth
  metadata_dataset.from(:tab).filter(:tname =>m.call(name), :tabtype => 'VIEW').count > 0 
end

#views(opts = {}) ⇒ Object 



42
43
44
45
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 42

def views(opts={}) 
  m = output_identifier_meth
  metadata_dataset.from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'VIEW').map{|r| m.call(r[:tname])}
end