11from __future__ import annotations
22
33from collections import namedtuple
4+ from enum import IntEnum
45from typing import Tuple , Iterator
56
67import cx_Oracle as oracle
78
9+ Argument = namedtuple (
10+ "Argument" ,
11+ "overload position level argument_name datatype default_value in_out length precision scale radix" ,
12+ )
13+
14+ ResolvedName = namedtuple (
15+ "ResolvedName" , "schema name database_link object_type object_number"
16+ )
17+
18+
19+ class ObjectTypes (IntEnum ):
20+ table = 2
21+ synonym = 5
22+ sequence = 6
23+ procedure = 7
24+ function = 8
25+ package = 9
26+ type = 13
27+
28+
29+ class NotFound (Exception ):
30+ pass
31+
832
933def _dbms_describe_describe_procedure (
1034 connection : oracle .Connection , name : str
@@ -56,7 +80,7 @@ def _dbms_describe_describe_procedure(
5680 level .aslist (),
5781 argument_name .aslist (),
5882 datatype .aslist (),
59- default_value .aslist (),
83+ map ( bool , default_value .aslist () ),
6084 in_out .aslist (),
6185 length .aslist (),
6286 precision .aslist (),
@@ -102,25 +126,27 @@ def _dbms_utility_name_resolve(
102126
103127def _exhaustive_name_resolution (
104128 connection : oracle .Connection , name : str
105- ) -> Tuple [str , str , str , int ]:
106- not_found_error = None
129+ ) -> Tuple [str , str , str , str , int , int ]:
107130 for context in range (0 , 10 ):
108131 try :
109- ( schema , part1 , part2 , _ , part1_type , _ ,) = _dbms_utility_name_resolve (
132+ return _dbms_utility_name_resolve (
110133 connection = connection , name = name , context = context
111134 )
112135 except oracle .DatabaseError as err :
113- if ( error_code := err . args [ 0 ]. code ) in ( 4047 , 6564 ):
114- if error_code == 6564 :
115- not_found_error = err
136+ # ORA-04047: object specified is incompatible with the flag specified
137+ # ORA-06564: object name does not exist
138+ if err . args [ 0 ]. code in ( 4047 , 6564 ):
116139 continue
117140 raise
118141 else :
119142 break
120- else :
121- raise not_found_error
122143
123- return schema , part1 , part2 , part1_type
144+ raise NotFound (f"name { name } not found" )
145+
146+
147+ class Function :
148+ def __init__ (self , name : ResolvedName ):
149+ self ._name = name
124150
125151
126152class Database :
@@ -138,38 +164,43 @@ def __init__(
138164 user = user , password = password , dsn = dsn , encoding = encoding , nencoding = encoding
139165 )
140166
141- def _describe_procedure (self , name : str ):
142- result = _dbms_describe_describe_procedure (self ._connection , name )
167+ def __getattr__ (self , item ):
168+ try :
169+ name = self ._name_resolve (item )
170+ except oracle .DatabaseError :
171+ raise AttributeError
143172
144- Arguments = namedtuple (
145- "Arguments" ,
146- "overload position level argument_name datatype default_value in_out length precision scale radix" ,
147- )
173+ if name .object_type == ObjectTypes .function :
174+ return Function (name )
148175
149- return [ Arguments ( * argument ) for argument in result ]
176+ raise AttributeError
150177
151- def _name_resolve (self , name : str ):
152- schema , part1 , part2 , part1_type = _exhaustive_name_resolution (
153- connection = self . _connection , name = name
154- )
178+ def _describe_procedure (self , name : str ) -> List [ Argument ] :
179+ result = _dbms_describe_describe_procedure ( self . _connection , name )
180+
181+ return [ Argument ( * argument ) for argument in result ]
155182
156- type_mapping = {
157- 2 : "TABLE" ,
158- 5 : "SYNONYM" ,
159- 6 : "SEQUENCE" ,
160- 7 : "PROCEDURE" ,
161- 8 : "FUNCTION" ,
162- 9 : "PACKAGE" ,
163- 13 : "TYPE" ,
164- }
165- ResolvedName = namedtuple ("ResolvedName" , "schema name object_type" )
183+ def _name_resolve (self , name : str ) -> ResolvedName :
184+ (
185+ schema ,
186+ part1 ,
187+ part2 ,
188+ database_link ,
189+ part1_type ,
190+ object_number ,
191+ ) = _exhaustive_name_resolution (connection = self ._connection , name = name )
166192
167193 return ResolvedName (
168194 schema ,
169195 "." .join ([part1 or "" , part2 or "" ]).strip ("." ),
170- type_mapping [part1_type ],
196+ database_link ,
197+ ObjectTypes (part1_type ),
198+ object_number ,
171199 )
172200
173- def execute (self , statement : str , * args , ** kwargs ):
201+ def query (self , sql : str , * args , ** kwargs ):
202+ pass
203+
204+ def execute (self , statement : str , * args , ** kwargs ) -> None :
174205 with self ._connection .cursor () as cursor :
175206 cursor .execute (statement , * args , ** kwargs )
0 commit comments