Skip to content

Commit 76e8931

Browse files
committed
moved tests around
1 parent 8066ada commit 76e8931

5 files changed

Lines changed: 16 additions & 18 deletions

File tree

‎tests/func/test_function_call.py‎

Lines changed: 0 additions & 8 deletions
This file was deleted.

‎tests/func/test_procedure_call.py‎

Lines changed: 0 additions & 8 deletions
This file was deleted.

‎tests/func/test_subprograms.py‎

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,14 @@
1+
import pytest
2+
3+
from python_plsql import DatabaseError
4+
5+
6+
def test_function_returns_value(plsql, simple_function):
7+
assert simple_function(21) == 42
8+
assert simple_function(p_int=21) == 42
9+
assert simple_function(None) is None
10+
11+
12+
def test_procedure_gets_called(simple_procedure):
13+
with pytest.raises(DatabaseError, match="ORA-20001.+You called me.+42"):
14+
simple_procedure()

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

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ CREATE OR REPLACE PACKAGE BODY test_package AS
33
PROCEDURE simple_procedure IS
44
v_int INTEGER DEFAULT 42;
55
BEGIN
6-
raise_application_error(-20001, 'You called me :) ' || TO_CHAR(v_int));
6+
raise_application_error(-20001, 'You called me ' || TO_CHAR(v_int));
77
END simple_procedure;
88

99
FUNCTION simple_function(p_int IN INTEGER)
Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
CREATE OR REPLACE PROCEDURE simple_procedure IS
22
v_int INTEGER DEFAULT 42;
33
BEGIN
4-
raise_application_error(-20001, 'You called me :) ' || TO_CHAR(v_int));
4+
raise_application_error(-20001, 'You called me ' || TO_CHAR(v_int));
55
END;

0 commit comments

Comments
 (0)