Module: PLSQL::PackageClassMethods

Included in:
Package
Defined in:
lib/plsql/package.rb

Overview

:nodoc:

Instance Method Summary collapse

Instance Method Details

#find(schema, package_name) ⇒ Object 



3
4
5
 
# File 'lib/plsql/package.rb', line 3

def find(schema, package_name)
  find_package_in_schema(schema, package_name) || find_package_by_synonym(schema, package_name)
end

#find_by_db_object(db_object) ⇒ Object 



7
8
9
 
# File 'lib/plsql/package.rb', line 7

def find_by_db_object(db_object)
  find(db_object.schema, db_object.name)
end

#find_package_by_synonym(schema, package_name) ⇒ Object 



22
23
24
25
26
27
28
29
30
31
32
33
34
35
 
# File 'lib/plsql/package.rb', line 22

def find_package_by_synonym(schema, package_name)
  row = schema.select_first(<<-SQL, schema.schema_name, package_name.to_s.upcase)
    SELECT o.owner, o.object_name
    FROM   all_synonyms s,
           all_objects o
    WHERE  s.owner IN (:owner, 'PUBLIC')
    AND    s.synonym_name = :synonym_name
    AND    o.owner = s.table_owner
    AND    o.object_name = s.table_name
    AND    o.object_type = 'PACKAGE'
    ORDER BY DECODE(s.owner, 'PUBLIC', 1, 0)
  SQL
  new(schema, row[1], row[0]) if row
end

#find_package_in_schema(schema, package_name) ⇒ Object 



11
12
13
14
15
16
17
18
19
20
 
# File 'lib/plsql/package.rb', line 11

def find_package_in_schema(schema, package_name)
  row = schema.select_first(<<-SQL, schema.schema_name, package_name.to_s.upcase)
    SELECT object_name
    FROM   all_objects
    WHERE  owner = :owner
    AND    object_name = :package
    AND    object_type = 'PACKAGE'
  SQL
  new(schema, package_name) if row
end