Skip to main content

Pure-Python MySQL Driver

Project description

https://travis-ci.org/PyMySQL/PyMySQL.svg?branch=master

This package contains a pure-Python MySQL client library. The goal of PyMySQL is to be a drop-in replacement for MySQLdb and work on CPython, PyPy and IronPython.

Requirements

Installation

The last stable release is available on PyPI and can be installed with pip:

$ pip install PyMySQL

Alternatively (e.g. if pip is not available), a tarball can be downloaded from GitHub and installed with Setuptools:

$ # X.X is the desired PyMySQL version (e.g. 0.5 or 0.6).
$ curl -L https://github.com/PyMySQL/PyMySQL/tarball/pymysql-X.X | tar xz
$ cd PyMySQL*
$ python setup.py install
$ # The folder PyMySQL* can be safely removed now.

Test Suite

If you would like to run the test suite, create database for test like this:

mysql -e 'create database test_pymysql  DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;'
mysql -e 'create database test_pymysql2 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;'

Then, copy the file .travis.databases.json to pymysql/tests/databases.json and edit the new file to match your MySQL configuration:

$ cp .travis.databases.json pymysql/tests/databases.json
$ $EDITOR pymysql/tests/databases.json

To run all the tests, execute the script runtests.py:

$ python runtests.py

A tox.ini file is also provided for conveniently running tests on multiple Python versions:

$ tox

Resources

DB-API 2.0: http://www.python.org/dev/peps/pep-0249

MySQL Reference Manuals: http://dev.mysql.com/doc/

MySQL client/server protocol: http://dev.mysql.com/doc/internals/en/client-server-protocol.html

PyMySQL mailing list: https://groups.google.com/forum/#!forum/pymysql-users

License

PyMySQL is released under the MIT License. See LICENSE for more information.

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

PyMySQL-0.6.6.tar.gz (56.9 kB view details)

Uploaded Source

Built Distribution

PyMySQL-0.6.6-py2.py3-none-any.whl (66.2 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file PyMySQL-0.6.6.tar.gz.

File metadata

  • Download URL: PyMySQL-0.6.6.tar.gz
  • Upload date:
  • Size: 56.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for PyMySQL-0.6.6.tar.gz
Algorithm Hash digest
SHA256 c18e62ca481c5ada6c7bee1b81fc003d6ceae932c878db384cd36808010b3774
MD5 a3968a6bf6672fa93ca931ab2ef46024
BLAKE2b-256 90dd1d6548e5810beb9ea852b9e71ac9f8981bb3c5bd892bf7b454cbe564ba89

See more details on using hashes here.

File details

Details for the file PyMySQL-0.6.6-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for PyMySQL-0.6.6-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 84dfd838f49d784978084cf7536f91becea456325c4b84874ccd2f5dccaa35d3
MD5 2b884925ec118e339c1bf7b3a023719c
BLAKE2b-256 e1d6194d7eb320164ff1e78307fa3de4a80066121d2a512db8057f9730a95019

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