Module: ActiveRecord::Bulkoperation::OracleEnhancedAdapter

Included in:
ConnectionAdapters::OracleEnhancedAdapter
Defined in:
lib/activerecord_bulkoperation/adapters/oracle_enhanced_adapter.rb

Instance Method Summary collapse

Instance Method Details

#find_by_sequence_name_sql_array(name) ⇒ Object 



37
38
39
40
 
# File 'lib/activerecord_bulkoperation/adapters/oracle_enhanced_adapter.rb', line 37

def find_by_sequence_name_sql_array(name)
  sql = 'select * from user_sequences where sequence_name = ?'
  [sql, name.upcase]
end

#find_detail_references_sql_array(table_name) ⇒ Object 



25
26
27
28
29
30
31
32
33
34
35
 
# File 'lib/activerecord_bulkoperation/adapters/oracle_enhanced_adapter.rb', line 25

def find_detail_references_sql_array(table_name)
  sql = "select
    m.table_name master_table,
    ( select listagg( column_name, ',' ) within group (order by position) from user_cons_columns where constraint_name = m.constraint_name ) master_columns,
    d.table_name detail_table,
    ( select listagg( column_name, ',' ) within group (order by position) from user_cons_columns where constraint_name = d.constraint_name ) detail_columns
    from
    user_constraints m join user_constraints d on( m.constraint_name = d.r_constraint_name )
    where m.table_name = ?"
  [sql, table_name.upcase]
end

#find_foreign_detail_tables_sql_array(table_name) ⇒ Object 



15
16
17
18
19
20
21
22
23
 
# File 'lib/activerecord_bulkoperation/adapters/oracle_enhanced_adapter.rb', line 15

def find_foreign_detail_tables_sql_array(table_name)
  sql = "select
           d.table_name
         from
           user_constraints m join user_constraints d on (m.constraint_name = d.r_constraint_name)
         where
       m.table_name = ?"
  [sql, table_name.upcase]
end

#find_foreign_master_tables_sql_array(table_name) ⇒ Object 



5
6
7
8
9
10
11
12
13
 
# File 'lib/activerecord_bulkoperation/adapters/oracle_enhanced_adapter.rb', line 5

def find_foreign_master_tables_sql_array(table_name)
  sql = "select
           m.table_name
         from
           user_constraints m join user_constraints d on (m.constraint_name = d.r_constraint_name)
         where
           d.table_name = ?"
  [sql, table_name.upcase]
end