Module ImportFrom alias ClassDef bases NameLoad body FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr TryFinally body TryExcept body Expr Call AttributeLoad NameLoad attr Str handlers ExceptHandler body Expr Call AttributeLoad AttributeLoad NameLoad attr attr TryExcept body Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad AttributeLoad NameLoad attr attr handlers ExceptHandler body Expr Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str finalbody Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Expr Call AttributeLoad NameLoad attr BinOpMod Str Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr TryExcept body Assert UnaryOpNot NameLoad Str handlers ExceptHandler type NameLoad name NameStore body Print Str For NameStore NameLoad body Print NameLoad Raise NameLoad finalbody Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str TupleLoad Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Num Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str TupleLoad Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Num Call NameLoad NameLoad finalbody Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Assign NameStore ListLoad Str Expr Call AttributeLoad NameLoad attr Str NameLoad Expr Call AttributeLoad NameLoad attr ListLoad Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Num Call NameLoad Call AttributeLoad NameLoad attr finalbody Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Assign NameStore ListLoad NameLoad Str Expr Call AttributeLoad NameLoad attr Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr Assert CompareIs NameLoad NameLoad Str Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str SubscriptLoad NameLoad Index Num Expr Call AttributeLoad NameLoad attr Str SubscriptLoad NameLoad Index Num finalbody Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Assert CompareIsNot NameLoad NameLoad Str Expr Call AttributeLoad NameLoad attr Num Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str SubscriptLoad NameLoad Index Num finalbody Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Assign NameStore ListLoad Str Expr Call AttributeLoad NameLoad attr Str NameLoad Expr Call AttributeLoad NameLoad attr Num AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assert CompareIsNot NameLoad NameLoad Str Expr Call AttributeLoad NameLoad attr Num Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str SubscriptLoad NameLoad Index Num finalbody Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Assign NameStore ListLoad Str Expr Call AttributeLoad NameLoad attr Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Num AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assert CompareIsNot NameLoad NameLoad Str Expr Call AttributeLoad NameLoad attr Num Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str SubscriptLoad NameLoad Index Num finalbody Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Assign NameStore ListLoad NameLoad Expr Call AttributeLoad NameLoad attr Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr Assert CompareIsNot NameLoad NameLoad Str Expr Call AttributeLoad NameLoad attr Num Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str SubscriptLoad NameLoad Index Num Expr Call AttributeLoad NameLoad attr Str Call AttributeLoad SubscriptLoad NameLoad Index Num attr finalbody Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Assert CompareIsNot NameLoad NameLoad Str Assign NameStore Call AttributeLoad NameLoad attr Assert CompareIs NameLoad NameLoad Str finalbody Expr Call AttributeLoad NameLoad attr decorator_list decorator_list ClassDef bases NameLoad body FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr TryFinally body For NameStore TupleLoad TupleLoad Str Str TupleLoad Str Str body TryExcept body Expr Call AttributeLoad NameLoad attr BinOpMod Str NameLoad handlers ExceptHandler body Pass Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr Str TupleLoad Num Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Num Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Num Call NameLoad AttributeLoad NameLoad attr Assert CompareIsNot Call AttributeLoad NameLoad attr NameLoad Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Num Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Num Call NameLoad AttributeLoad NameLoad attr finalbody Expr Call AttributeLoad NameLoad attr decorator_list decorator_list
N/A zxtest zxCoreTestCase OracleSPTest N/A zxCoreTestCase N/A setUp N/A N/A self N/A N/A N/A N/A N/A zxCoreTestCase setUp self N/A c N/A N/A self cursor N/A N/A N/A N/A N/A N/A N/A c execute drop table sptest N/A N/A N/A N/A N/A N/A N/A self db rollback N/A N/A N/A N/A N/A c execute create table sptest (x varchar2(20)) N/A N/A N/A c execute create or replace procedure procnone is begin insert into sptest values ('testing'); end; N/A N/A N/A c execute create or replace procedure procin (y in varchar2) is begin insert into sptest values (y); end; N/A N/A N/A c execute create or replace procedure procout (y out varchar2) is begin y := 'tested'; end; N/A N/A N/A c execute create or replace procedure procinout (y out varchar2, z in varchar2) is begin insert into sptest values (z); y := 'tested'; end; N/A N/A N/A c execute create or replace function funcnone return varchar2 is begin return 'tested'; end; N/A N/A N/A c execute create or replace function funcin (y varchar2) return varchar2 is begin return y || y; end; N/A N/A N/A c execute create or replace function funcout (y out varchar2) return varchar2 is begin y := 'tested'; return 'returned'; end; N/A N/A N/A N/A self db commit N/A N/A N/A N/A N/A N/A N/A self db rollback N/A N/A N/A self fail procedure creation failed N/A N/A N/A self proc_errors PROC N/A N/A N/A self proc_errors FUNC N/A N/A N/A N/A c close N/A tearDown N/A N/A self N/A N/A N/A N/A N/A zxCoreTestCase tearDown self N/A proc_errors N/A N/A self name N/A N/A N/A c N/A N/A self cursor N/A N/A N/A N/A N/A c execute N/A select * from user_errors where name like '%s%%' N/A N/A name upper N/A errors N/A N/A c fetchall N/A N/A N/A N/A errors found errors N/A N/A N/A AssertionError N/A e N/A N/A printing errors: N/A a errors N/A N/A a N/A e N/A N/A N/A N/A c close N/A testCursor N/A N/A self N/A N/A N/A c N/A N/A self cursor N/A N/A N/A N/A N/A c execute insert into sptest values ('a') N/A N/A N/A c execute insert into sptest values ('b') N/A N/A N/A c execute insert into sptest values ('c') N/A N/A N/A c execute insert into sptest values ('d') N/A N/A N/A c execute insert into sptest values ('e') N/A N/A N/A c execute 
                                CREATE OR REPLACE PACKAGE types
                                AS
                                        TYPE ref_cursor IS REF CURSOR;
                                END;
                         N/A N/A N/A c execute 
                                CREATE OR REPLACE FUNCTION funccur(v_x IN VARCHAR)
                                        RETURN types.ref_cursor
                                AS
                                        funccur_cursor types.ref_cursor;
                                BEGIN
                                        OPEN funccur_cursor FOR
                                                SELECT x FROM sptest WHERE x < v_x;
                                        RETURN funccur_cursor;
                                END;
                         N/A N/A N/A self proc_errors funccur N/A N/A N/A c callproc funccur N/A z N/A data N/A N/A c fetchall N/A N/A N/A self assertEquals 5 N/A len data N/A N/A N/A c callproc funccur N/A c N/A data N/A N/A c fetchall N/A N/A N/A self assertEquals 2 N/A len data N/A N/A N/A N/A c close N/A testProcin N/A N/A self N/A N/A N/A c N/A N/A self cursor N/A N/A N/A params N/A testProcin N/A N/A N/A c callproc procin params N/A N/A N/A self assertEquals N/A N/A N/A c fetchall N/A N/A N/A c execute select * from sptest N/A N/A N/A self assertEquals 1 N/A len N/A N/A c fetchall N/A N/A N/A N/A c close N/A testProcinout N/A N/A self N/A N/A N/A c N/A N/A self cursor N/A N/A N/A params N/A None testing N/A N/A N/A c callproc procinout params N/A data N/A N/A c fetchone N/A N/A data None data was not None N/A N/A N/A c execute select * from sptest N/A data N/A N/A c fetchone N/A N/A N/A self assertEquals testing N/A data N/A 0 N/A N/A N/A self assertEquals tested N/A params N/A 0 N/A N/A N/A N/A c close N/A testFuncnone N/A N/A self N/A N/A N/A c N/A N/A self cursor N/A N/A N/A N/A N/A c callproc funcnone N/A data N/A N/A c fetchone N/A N/A data None data was None N/A N/A N/A self assertEquals 1 N/A len data N/A N/A N/A self assertEquals tested N/A data N/A 0 N/A N/A N/A N/A c close N/A testFuncin N/A N/A self N/A N/A N/A c N/A N/A self cursor N/A N/A N/A params N/A testing N/A N/A N/A c callproc funcin params N/A N/A N/A self assertEquals 1 N/A c rowcount N/A data N/A N/A c fetchone N/A N/A data None data was None N/A N/A N/A self assertEquals 1 N/A len data N/A N/A N/A self assertEquals testingtesting N/A data N/A 0 N/A N/A N/A N/A c close N/A testCallingWithKws N/A N/A self N/A N/A N/A c N/A N/A self cursor N/A N/A N/A params N/A testing N/A N/A N/A c callproc funcin params params N/A N/A N/A self assertEquals 1 N/A c rowcount N/A data N/A N/A c fetchone N/A N/A data None data was None N/A N/A N/A self assertEquals 1 N/A len data N/A N/A N/A self assertEquals testingtesting N/A data N/A 0 N/A N/A N/A N/A c close N/A testFuncout N/A N/A self N/A N/A N/A c N/A N/A self cursor N/A N/A N/A params N/A None N/A N/A N/A c callproc funcout params N/A data N/A N/A c fetchone N/A N/A data None data was None N/A N/A N/A self assertEquals 1 N/A len data N/A N/A N/A self assertEquals returned N/A data N/A 0 N/A N/A N/A self assertEquals tested N/A N/A N/A params N/A 0 strip N/A N/A N/A N/A c close N/A testMultipleFetch N/A N/A self N/A N/A N/A testing the second fetch call to a callproc() is None N/A c N/A N/A self cursor N/A N/A N/A N/A N/A c callproc funcnone N/A data N/A N/A c fetchone N/A N/A data None data was None N/A data N/A N/A c fetchone N/A N/A data None data was not None N/A N/A N/A N/A c close N/A N/A SQLServerSPTest N/A zxCoreTestCase N/A testProcWithResultSet N/A N/A self N/A N/A N/A c N/A N/A self cursor N/A N/A N/A a N/A N/A table sptest N/A procedure sp_proctest N/A N/A N/A N/A N/A N/A c execute N/A drop %s %s a N/A N/A N/A N/A N/A N/A N/A c execute create table sptest (a int, b varchar(32)) N/A N/A N/A c execute insert into sptest values (1, 'hello') N/A N/A N/A c execute insert into sptest values (2, 'there') N/A N/A N/A c execute insert into sptest values (3, 'goodbye') N/A N/A N/A c execute  create procedure sp_proctest (@A int) as select a, b from sptest where a <= @A  N/A N/A N/A N/A self db commit N/A N/A N/A c callproc sp_proctest N/A 2 N/A data N/A N/A c fetchall N/A N/A N/A self assertEquals 2 N/A len data N/A N/A N/A self assertEquals 2 N/A len N/A c description N/A N/A N/A N/A c nextset None expected an additional result set N/A data N/A N/A c fetchall N/A N/A N/A self assertEquals 1 N/A len data N/A N/A N/A self assertEquals 1 N/A len N/A c description N/A N/A N/A N/A c close N/A N/A