Skip to content

Commit 41f6656

Browse files
committed
extra test for nested table
1 parent 0bd0ff9 commit 41f6656

3 files changed

Lines changed: 13 additions & 22 deletions

File tree

‎tests/conftest.py‎

Lines changed: 12 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -6,21 +6,23 @@
66
from plsql import Database
77

88

9-
@pytest.fixture(scope='session')
9+
@pytest.fixture(scope="session")
1010
def 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

3335
def 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

4042
def 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}")

‎tests/sql/package/test_package-h.sql‎

Lines changed: 0 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -17,9 +17,6 @@ CREATE OR REPLACE PACKAGE test_package AS
1717
FUNCTION out_integers(p_integer IN INTEGER)
1818
RETURN tt_integers;
1919

20-
FUNCTION in_integers(pt_integers IN tt_integers)
21-
RETURN INTEGER;
22-
2320
FUNCTION return_record
2421
RETURN tr_rec;
2522

‎tests/test_package_type.py‎

Lines changed: 1 addition & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -40,9 +40,5 @@ def test_rec_plsql_table(plsql):
4040
assert result == reduce(mul, record.values()) * 100
4141

4242

43-
def test_nested_table_as_out(plsql):
43+
def test_nested_table(plsql):
4444
assert plsql.test_package.out_integers(p_integer=5) == [1, 2, 5]
45-
46-
47-
def test_nested_table_as_in(plsql):
48-
assert plsql.test_package.in_integers(pt_integers=[1, 2, 3]) == 6

0 commit comments

Comments
 (0)