First release
Project description
Settings
There just one setting — SP_DIR. It is the name of the directories inside apps, that contains files with stored procesures, custom indexes and other stuff. By default it is /sp/.
Procedures files
Files with database stuff can have any extention and contain any number of procedures and statements.
So stored procedure can be called via helper, its defenition must starts with CREATE OR REPLACE FUNCTION <name> where <name> is procedure’s name. Case is important.
Usage
>>> from django_sp import sp_loader >>> sp_loader.some_procedure(arg1, arg2) [{'column1': 'value1', 'column2': 'value2}, ... ] >>> sp_loader.other_procedure(arg1, arg2, fetchone=True) {'column1': 'value1', 'column2': 'value2'} >>> sp_loader.list() ['some_procedure', 'other_procedure', 'else_one_procedure']