File tree Expand file tree Collapse file tree
Expand file tree Collapse file tree Original file line number Diff line number Diff line change 33
44import 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-
336FUNCTION = 'FUNCTION'
347PROCEDURE = 'PROCEDURE'
358PACKAGE = 'PACKAGE'
Original file line number Diff line number Diff 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
3333def create_objects (plsql , objects ):
Original file line number Diff line number Diff line change 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+
614END test_package;
Original file line number Diff line number Diff line change 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 ;
146END test_package;
15-
You can’t perform that action at this time.
0 commit comments