99from typing import Any
1010from typing import Iterator
1111from typing import List
12+ from typing import Optional
13+ from typing import Union
1214from typing import Tuple
1315
1416import cx_Oracle as oracle
@@ -163,7 +165,7 @@ class Schema:
163165 def __init__ (self , plsql : Database , name : str ):
164166 self ._plsql , self ._name = plsql , name
165167
166- def __getattr__ (self , item ) :
168+ def __getattr__ (self , item : str ) -> Optional [ Union [ Subprogram , Package ]] :
167169 item = f"{ self ._name } .{ item } "
168170 name = self ._plsql ._name_resolve (item )
169171 return search_object (plsql = self ._plsql , name = name , item = item )
@@ -173,7 +175,7 @@ class Package:
173175 def __init__ (self , plsql : Database , name : str ):
174176 self ._plsql , self ._name = plsql , name
175177
176- def __getattr__ (self , item ) :
178+ def __getattr__ (self , item : str ) -> Subprogram :
177179 item = f"{ self ._name } .{ item } "
178180 name = self ._plsql ._name_resolve (item )
179181 return Subprogram (
@@ -222,7 +224,7 @@ def __init__(self, plsql: Database, name: ResolvedName):
222224 self ._plsql , self ._name = plsql , name
223225
224226
225- def return_type (arguments : List [Argument ]):
227+ def return_type (arguments : List [Argument ]) -> Optional [ Argument ] :
226228 """
227229 Extracts return type from list of arguments.
228230 According to Oracle documentation: "Position 0 returns the values for the return type of a function."
@@ -320,11 +322,11 @@ def overloaded(self) -> bool:
320322 return len (self .overloads ) > 1
321323
322324 @property
323- def is_function (self ):
325+ def is_function (self ) -> bool :
324326 return any (overload .is_function for overload in self .overloads )
325327
326328 @property
327- def is_procedure (self ):
329+ def is_procedure (self ) -> bool :
328330 return any (not overload .is_function for overload in self .overloads )
329331
330332 @property
@@ -336,7 +338,9 @@ def standalone(self) -> bool:
336338 }
337339
338340
339- def search_object (plsql : Database , name : ResolvedName , item : str ):
341+ def search_object (
342+ plsql : Database , name : ResolvedName , item : str
343+ ) -> Optional [Union [Subprogram , Package ]]:
340344 if name .object_type in {
341345 ObjectTypes .function ,
342346 ObjectTypes .procedure ,
@@ -369,15 +373,15 @@ def __init__(
369373 user = user , password = password , dsn = dsn , encoding = encoding , nencoding = encoding
370374 )
371375
372- def is_schema (self , schema_name ) :
376+ def is_schema (self , schema_name : str ) -> bool :
373377 return bool (
374378 self .query (
375379 """SELECT COUNT(*) FROM all_users WHERE username = UPPER(:username)""" ,
376380 username = schema_name ,
377381 ).first
378382 )
379383
380- def __getattr__ (self , item ):
384+ def __getattr__ (self , item ) -> Union [ Schema , Package , Subprogram ] :
381385 try :
382386 name = self ._name_resolve (item )
383387 except (oracle .DatabaseError , NotFound ):
0 commit comments