Skip to content

Commit eb1f7b2

Browse files
committed
cleaning up
1 parent 9a0a88a commit eb1f7b2

4 files changed

Lines changed: 15 additions & 43 deletions

File tree

‎plsql/client.py‎

Lines changed: 0 additions & 27 deletions
Original file line numberDiff line numberDiff line change
@@ -3,33 +3,6 @@
33

44
import cx_Oracle as oracle
55

6-
# class Schema:
7-
# sql_query = '''
8-
# SELECT COUNT(*)
9-
# FROM all_users
10-
# WHERE username = :name
11-
# '''
12-
#
13-
# def __init__(self, name, plsql):
14-
# self.name = name
15-
# self.plsql = plsql
16-
# result = list(plsql.query(sql_query=self.sql_query,
17-
# bind_variables={'name': name.upper()}))
18-
# if sum(row[0] for row in result) == 0:
19-
# raise ValueError('Not a database schema!')
20-
# @lru_cache(maxsize=None)
21-
# def get_schema(name, plsql):
22-
# try:
23-
# return Schema(name=name, plsql=plsql)
24-
# except ValueError:
25-
# return None
26-
#
27-
#
28-
# class Package:
29-
# pass
30-
#
31-
#
32-
336
FUNCTION = 'FUNCTION'
347
PROCEDURE = 'PROCEDURE'
358
PACKAGE = 'PACKAGE'

‎tests/conftest.py‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -27,7 +27,7 @@ def plsql():
2727

2828
yield database
2929

30-
# drop_all_objects(database, objects)
30+
drop_all_objects(database, objects)
3131

3232

3333
def create_objects(plsql, objects):
Lines changed: 11 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,14 @@
1-
CREATE OR REPLACE PACKAGE test_package AS
2-
PROCEDURE simple_procedure;
1+
CREATE OR REPLACE PACKAGE BODY test_package AS
2+
3+
PROCEDURE simple_procedure IS
4+
BEGIN
5+
NULL;
6+
END simple_procedure;
37

48
FUNCTION simple_function(p_int IN INTEGER)
5-
RETURN INTEGER;
9+
RETURN INTEGER IS
10+
BEGIN
11+
RETURN p_int * p_int;
12+
END simple_function;
13+
614
END test_package;
Lines changed: 3 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -1,15 +1,6 @@
1-
CREATE OR REPLACE PACKAGE BODY test_package AS
2-
3-
PROCEDURE simple_procedure IS
4-
BEGIN
5-
NULL;
6-
END simple_procedure;
1+
CREATE OR REPLACE PACKAGE test_package AS
2+
PROCEDURE simple_procedure;
73

84
FUNCTION simple_function(p_int IN INTEGER)
9-
RETURN INTEGER IS
10-
BEGIN
11-
RETURN p_int * p_int;
12-
END simple_function;
13-
5+
RETURN INTEGER;
146
END test_package;
15-

0 commit comments

Comments
 (0)