A stored procedure and function loader, wrapper generator for MySQL and MS-SQL
A stored procedure and function loader, wrapper generator for MySQL and SQL Server 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 or SQL Server instance. This MySQL or SQL Server instance can be part of your development or a production environment.
- Enhancing the (limited) syntax of MySQL and SQL Server 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.