Skip to main content

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']

Project details


Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page