Module: Sequel::Oracle::DatabaseMethods

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

Constant Summary collapse

TEMPORARY = 
'GLOBAL TEMPORARY '.freeze
AUTOINCREMENT = 
''.freeze
IGNORE_OWNERS = 
%w'APEX_040000 CTXSYS EXFSYS MDSYS OLAPSYS ORDDATA ORDSYS SYS SYSTEM XDB XDBMETADATA XDBPM XFILES WMSYS'

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Database::ResetIdentifierMangling

extended

Instance Attribute Details

#autosequence ⇒ Object

Returns the value of attribute autosequence.



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

def autosequence
  @autosequence
end

Instance Method Details

#create_sequence(name, opts = OPTS) ⇒ Object 



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

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

#create_trigger(*args) ⇒ Object 



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

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

#current_user ⇒ Object 



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

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

#database_type ⇒ Object

Oracle uses the :oracle database type



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

def database_type
  :oracle
end

#drop_sequence(name) ⇒ Object 



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

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

#foreign_key_list(table, opts = OPTS) ⇒ Object 



45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 45

def foreign_key_list(table, opts=OPTS)
  m = output_identifier_meth
  im = input_identifier_meth
  schema, table = schema_and_table(table)
  ds = metadata_dataset.
    from(:all_cons_columns___pc, :all_constraints___p, :all_cons_columns___fc, :all_constraints___f).
    where(:f__table_name=>im.call(table), :f__constraint_type=>'R', :p__owner=>:f__r_owner, :p__constraint_name=>:f__r_constraint_name, :pc__owner=>:p__owner, :pc__constraint_name=>:p__constraint_name, :pc__table_name=>:p__table_name, :fc__owner=>:f__owner, :fc__constraint_name=>:f__constraint_name, :fc__table_name=>:f__table_name, :fc__position=>:pc__position).
    select(:p__table_name___table, :pc__column_name___key, :fc__column_name___column, :f__constraint_name___name).
    order(:table, :fc__position)
  ds = ds.where(:f__schema_name=>im.call(schema)) if schema

  fks = {}
  ds.each do |r|
    if fk = fks[r[:name]]
      fk[:columns] << m.call(r[:column])
      fk[:key] << m.call(r[:key])
    else
      fks[r[:name]] = {:name=>m.call(r[:name]), :columns=>[m.call(r[:column])], :table=>m.call(r[:table]), :key=>[m.call(r[:key])]}
    end
  end
  fks.values
end

#global_index_namespace? ⇒ Boolean

Oracle namespaces indexes per table.

Returns:

  • (Boolean) 


69
70
71
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 69

def global_index_namespace?
  false
end

#server_version(server = nil) ⇒ Object

The version of the Oracle server, used for determining capability.



103
104
105
106
107
108
109
110
111
112
113
114
115
116
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 103

def server_version(server=nil)
  return @server_version if @server_version
  @server_version = synchronize(server) do |conn|
    (conn.server_version rescue nil) if conn.respond_to?(:server_version)
  end
  unless @server_version
    @server_version = if m = /(\d+)\.(\d+)\.?(\d+)?\.?(\d+)?/.match(fetch("select version from PRODUCT_COMPONENT_VERSION where lower(product) like 'oracle%'").single_value)
      (m[1].to_i*1000000) + (m[2].to_i*10000) + (m[3].to_i*100) + m[4].to_i
    else
      0
    end
  end
  @server_version
end

#supports_deferrable_constraints? ⇒ Boolean

Oracle supports deferrable constraints.

Returns:

  • (Boolean) 


120
121
122
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 120

def supports_deferrable_constraints?
  true
end

#supports_transaction_isolation_levels? ⇒ Boolean

Oracle supports transaction isolation levels.

Returns:

  • (Boolean) 


125
126
127
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 125

def supports_transaction_isolation_levels?
  true
end

#tables(opts = OPTS) ⇒ Object 



75
76
77
78
79
80
81
82
83
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 75

def tables(opts=OPTS)
  m = output_identifier_meth
  metadata_dataset.from(:all_tables).
    server(opts[:server]).
    where(:dropped=>'NO').
    exclude(:owner=>IGNORE_OWNERS).
    select(:table_name).
    map{|r| m.call(r[:table_name])}
end

#view_exists?(name) ⇒ Boolean

Returns:

  • (Boolean) 


94
95
96
97
98
99
100
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 94

def view_exists?(name) 
  m = input_identifier_meth
  metadata_dataset.from(:all_views).
    exclude(:owner=>IGNORE_OWNERS).
    where(:view_name=>m.call(name)).
    count > 0
end

#views(opts = OPTS) ⇒ Object 



85
86
87
88
89
90
91
92
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 85

def views(opts=OPTS) 
  m = output_identifier_meth
  metadata_dataset.from(:all_views).
    server(opts[:server]).
    exclude(:owner=>IGNORE_OWNERS).
    select(:view_name).
    map{|r| m.call(r[:view_name])}
end