Skip to main content

A stored procedure and function loader and wrapper generator for MySQL, SQL Server, and PostgresSQL

Project description

PyStratum

A stored procedure and function loader, wrapper generator for MySQL, SQL Server and PostgreSQL in Python.

Social Release Code
https://scrutinizer-ci.com/g/SetBased/py-stratum/badges/quality-score.png?b=master

Overview

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.

Status

Currently this project is under development and for more information we refer to its sister project.

Sister Project

We are also working on PhpStratum. PhpStratum provides the same functionalities as PyStratum but in a PHP environment and supports MySQL only.

Project details


Release history Release notifications

This version
History Node

0.10.16

History Node

0.10.15

History Node

0.10.14

History Node

0.10.13

History Node

0.10.12

History Node

0.10.11

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
PyStratum-0.10.16.tar.gz (19.1 kB) Copy SHA256 hash SHA256 Source None Feb 27, 2018

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page