A stored procedure/function loader and wrapper generator for PostgresSQL
A stored procedure and function loader, wrapper generator for MySQL, SQL Server and PostgreSQL in Python.
PyStratum is a tool and library with the following mayor functionalities:
- Loading modified and new stored routines and removing obsolete stored routines into/from a MySQL, SQL Server, or PostgreSQL instance. This MySQL, SQL Server, or PostgreSQL instance can be part of your development or a production environment.
- Enhancing the (limited) syntax of MySQL, SQL Server, and PostgreSQL stored routines with constants and custom types (based on actual table columns).
- Generating automatically a Python wrapper class for calling your stored routines. This wrapper class takes care about error handing and prevents SQL injections.
- Defining Python constants based on auto increment columns and column widths.
Currently this project is under development and for more information we refer to its sister project.