class ActiveRecord::ConnectionAdapters::OracleEnhancedAdapter::DatabaseTasks
Public Class Methods
new(config)
click to toggle source
# File lib/active_record/connection_adapters/oracle_enhanced/database_tasks.rb, line 11 def initialize(config) @config = config end
Public Instance Methods
create()
click to toggle source
# File lib/active_record/connection_adapters/oracle_enhanced/database_tasks.rb, line 15 def create system_password = ENV.fetch("ORACLE_SYSTEM_PASSWORD") { print "Please provide the SYSTEM password for your Oracle installation (set ORACLE_SYSTEM_PASSWORD to avoid this prompt)\n>" $stdin.gets.strip } establish_connection(@config.merge(username: "SYSTEM", password: system_password)) begin connection.execute "CREATE USER #{@config[:username]} IDENTIFIED BY #{@config[:password]}" rescue => e if /ORA-01920/.match?(e.message) # user name conflicts with another user or role name connection.execute "ALTER USER #{@config[:username]} IDENTIFIED BY #{@config[:password]}" else raise e end end OracleEnhancedAdapter.permissions.each do |permission| connection.execute "GRANT #{permission} TO #{@config[:username]}" end end
drop()
click to toggle source
# File lib/active_record/connection_adapters/oracle_enhanced/database_tasks.rb, line 36 def drop establish_connection(@config) connection.execute_structure_dump(connection.full_drop) end
purge()
click to toggle source
# File lib/active_record/connection_adapters/oracle_enhanced/database_tasks.rb, line 41 def purge drop connection.execute("PURGE RECYCLEBIN") rescue nil end
structure_dump(filename, extra_flags)
click to toggle source
# File lib/active_record/connection_adapters/oracle_enhanced/database_tasks.rb, line 46 def structure_dump(filename, extra_flags) establish_connection(@config) File.open(filename, "w:utf-8") { |f| f << connection.structure_dump } if @config[:structure_dump] == "db_stored_code" File.open(filename, "a") { |f| f << connection.structure_dump_db_stored_code } end end
structure_load(filename, extra_flags)
click to toggle source
# File lib/active_record/connection_adapters/oracle_enhanced/database_tasks.rb, line 54 def structure_load(filename, extra_flags) establish_connection(@config) connection.execute_structure_dump(File.read(filename)) end