Skip to main content

A stored procedure and function loader, wrapper generator for MySQL

Project description

PyStratum

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

Social

Release

Tests

Code

https://badges.gitter.im/SetBased/py-stratum.svg https://badge.fury.io/py/pystratum-mysql.svg https://travis-ci.org/SetBased/py-stratum-mysql.svg?branch=master https://scrutinizer-ci.com/g/SetBased/py-stratum-mysql/badges/coverage.png?b=master https://scrutinizer-ci.com/g/SetBased/py-stratum-mysql/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


Download files

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

Source Distribution

PyStratum-MySQL-0.10.14.tar.gz (20.0 kB view details)

Uploaded Source

File details

Details for the file PyStratum-MySQL-0.10.14.tar.gz.

File metadata

  • Download URL: PyStratum-MySQL-0.10.14.tar.gz
  • Upload date:
  • Size: 20.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.2 pkginfo/1.4.2 requests/2.20.0 setuptools/40.4.3 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/3.7.2

File hashes

Hashes for PyStratum-MySQL-0.10.14.tar.gz
Algorithm Hash digest
SHA256 909d2bfbd76b8fcab22bf0fe34a3da7b37792a3a5aa8043971e6d8ec297361ce
MD5 9c1064d9862a0eb7223259db77c4563c
BLAKE2b-256 c20688b0261e05891fe78fec8cef79c29ef20a327e1b884d41fe5eb0fc4e7158

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page