Repository navigation
Expand file tree
/
Copy pathconftest.py
More file actions
81 lines (61 loc) · 1.9 KB
/
Copy pathconftest.py
File metadata and controls
81 lines (61 loc) · 1.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
import configparser
from pathlib import Path
import pytest
from python_plsql import Database
from cx_Oracle import DatabaseError
@pytest.fixture(scope="session")
def plsql():
config = configparser.ConfigParser()
config.read("./tests/database.ini")
parameters = dict(config["database"].items())
user, password, encoding = (
parameters["user"],
parameters["password"],
parameters["encoding"],
)
auth = (
parameters["host"],
parameters["port"],
parameters["service_name"],
)
database = Database(
user=user, password=password, service_auth=auth, encoding=encoding
)
directories = [
directory
for directory in Path("./tests").glob("./sql/*/")
if directory.is_dir()
]
objects = [
(file, directory)
for directory in directories
for file in directory.glob("*.sql")
]
assert objects, "no objects found!"
drop_all_objects(database, objects)
create_objects(database, objects)
yield database
def create_objects(plsql, objects):
for file_path, _ in objects:
with open(file_path, mode="r", encoding="utf8") as file:
sql_text = file.read()
try:
plsql.execute(sql_text)
except DatabaseError as err:
if err.args[0].code == 955:
continue
raise
def drop_all_objects(plsql, objects):
def clean_name(name):
if "-" in name:
return name[: name.find("-")]
return name
objects = {(clean_name(file.stem), directory.name) for file, directory in objects}
for object_name, object_type in objects:
try:
plsql.execute(f"DROP {object_type} {object_name}")
except DatabaseError as err:
error_code = err.args[0].code
if error_code in [1434, 2289, 4043, 942]:
continue
raise