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
-
#autosequence ⇒ Object
Returns the value of attribute autosequence.
Instance Method Summary collapse
- #create_sequence(name, opts = {}) ⇒ Object
- #create_trigger(*args) ⇒ Object
- #current_user ⇒ Object
-
#database_type ⇒ Object
Oracle uses the :oracle database type.
- #drop_sequence(name) ⇒ Object
- #tables(opts = {}) ⇒ Object
- #view_exists?(name) ⇒ Boolean
- #views(opts = {}) ⇒ Object
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 ||= .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 |
#tables(opts = {}) ⇒ Object
32 33 34 35 |
# File 'lib/sequel/adapters/shared/oracle.rb', line 32 def tables(opts={}) m = output_identifier_meth .from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'TABLE').map{|r| m.call(r[:tname])} end |
#view_exists?(name) ⇒ Boolean
42 43 44 45 |
# File 'lib/sequel/adapters/shared/oracle.rb', line 42 def view_exists?(name) m = input_identifier_meth .from(:tab).filter(:tname =>m.call(name), :tabtype => 'VIEW').count > 0 end |
#views(opts = {}) ⇒ Object
37 38 39 40 |
# File 'lib/sequel/adapters/shared/oracle.rb', line 37 def views(opts={}) m = output_identifier_meth .from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'VIEW').map{|r| m.call(r[:tname])} end |