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.4.tar.gz (56.7 kB view details)

Uploaded Source

Built Distribution

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

Uploaded Python 2 Python 3

File details

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

File metadata

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

File hashes

Hashes for PyMySQL-0.6.4.tar.gz
Algorithm Hash digest
SHA256 0f488631b97ad26213af5cfd797cdaa7823c61bdbb814b5416d4478334589461
MD5 b449e04ba325cc6db9f98c7fe0a24c8b
BLAKE2b-256 c72e393b88e81407475c702c595543435f579d2e3cc351ef62641089a25c53d9

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for PyMySQL-0.6.4-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 624d8a0c549905ed826856d5c9f79d71502462230b958899c06f434300a81c46
MD5 d8952fbe4f2292e9f9ee67d6f5fab5b0
BLAKE2b-256 34bcede45ce004b65d0dece2a7212c0b219fd61a991b7bc779c7c57dc276c076

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