66from plsql import Database
77
88
9- @pytest .fixture (scope = ' session' )
9+ @pytest .fixture (scope = " session" )
1010def plsql ():
1111 config = configparser .ConfigParser ()
12- config .read (' ./database.ini' )
12+ config .read (" ./database.ini" )
1313
14- parameters = dict (config [' database' ].items ())
14+ parameters = dict (config [" database" ].items ())
1515
1616 database = Database (** parameters )
1717
18- directories = [directory for directory in Path ('.' ).glob ('./sql/*/' ) if directory .is_dir ()]
18+ directories = [
19+ directory for directory in Path ("." ).glob ("./sql/*/" ) if directory .is_dir ()
20+ ]
1921
2022 objects = [
2123 (file , directory )
2224 for directory in directories
23- for file in directory .glob (' *.sql' )
25+ for file in directory .glob (" *.sql" )
2426 ]
2527
2628 create_objects (database , objects )
@@ -32,22 +34,18 @@ def plsql():
3234
3335def create_objects (plsql , objects ):
3436 for file_path , _ in objects :
35- with open (file_path , mode = 'r' , encoding = ' utf8' ) as file :
37+ with open (file_path , mode = "r" , encoding = " utf8" ) as file :
3638 sql_text = file .read ()
3739 plsql .execute_immediate (sql_text )
3840
3941
4042def drop_all_objects (plsql , objects ):
4143 def clean_name (name ):
42- if '-' in name :
43- return name [:name .find ('-' )]
44+ if "-" in name :
45+ return name [: name .find ("-" )]
4446 return name
4547
46- objects = {
47- (clean_name (file .stem ), directory .name )
48- for file , directory
49- in objects
50- }
48+ objects = {(clean_name (file .stem ), directory .name ) for file , directory in objects }
5149
5250 for object_name , object_type in objects :
53- plsql .execute_immediate (f' DROP { object_type } { object_name } ' )
51+ plsql .execute_immediate (f" DROP { object_type } { object_name } " )
0 commit comments