{ "info": { "author": "yutaka.matsubara", "author_email": "yutaka.matsubara@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: Implementation :: CPython", "Programming Language :: Python :: Implementation :: PyPy", "Topic :: Database" ], "description": ".. image:: https://readthedocs.org/projects/pymysql/badge/?version=latest\n :target: https://pymysql.readthedocs.io/\n :alt: Documentation Status\n\n.. image:: https://badge.fury.io/py/PyMySQL.svg\n :target: https://badge.fury.io/py/PyMySQL\n\n.. image:: https://travis-ci.org/PyMySQL/PyMySQL.svg?branch=master\n :target: https://travis-ci.org/PyMySQL/PyMySQL\n\n.. image:: https://coveralls.io/repos/PyMySQL/PyMySQL/badge.svg?branch=master&service=github\n :target: https://coveralls.io/github/PyMySQL/PyMySQL?branch=master\n\n.. image:: https://img.shields.io/badge/license-MIT-blue.svg\n :target: https://github.com/PyMySQL/PyMySQL/blob/master/LICENSE\n\n\nPyMySQL\n=======\n\n.. contents:: Table of Contents\n :local:\n\nThis package contains a pure-Python MySQL client library, based on `PEP 249`_.\n\nMost public APIs are compatible with mysqlclient and MySQLdb.\n\nNOTE: PyMySQL doesn't support low level APIs `_mysql` provides like `data_seek`,\n`store_result`, and `use_result`. You should use high level APIs defined in `PEP 249`_.\nBut some APIs like `autocommit` and `ping` are supported because `PEP 249`_ doesn't cover\ntheir usecase.\n\n.. _`PEP 249`: https://www.python.org/dev/peps/pep-0249/\n\n\nRequirements\n-------------\n\n* Python -- one of the following:\n\n - CPython_ : 2.7 and >= 3.5\n - PyPy_ : Latest version\n\n* MySQL Server -- one of the following:\n\n - MySQL_ >= 5.5\n - MariaDB_ >= 5.5\n\n.. _CPython: https://www.python.org/\n.. _PyPy: https://pypy.org/\n.. _MySQL: https://www.mysql.com/\n.. _MariaDB: https://mariadb.org/\n\n\nInstallation\n------------\n\nPackage is uploaded on `PyPI `_.\n\nYou can install it with pip::\n\n $ python3 -m pip install PyMySQL\n\nTo use \"sha256_password\" or \"caching_sha2_password\" for authenticate,\nyou need to install additional dependency::\n\n $ python3 -m pip install PyMySQL[rsa]\n\n\nDocumentation\n-------------\n\nDocumentation is available online: https://pymysql.readthedocs.io/\n\nFor support, please refer to the `StackOverflow\n`_.\n\nExample\n-------\n\nThe following examples make use of a simple table\n\n.. code:: sql\n\n CREATE TABLE `users` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `email` varchar(255) COLLATE utf8_bin NOT NULL,\n `password` varchar(255) COLLATE utf8_bin NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin\n AUTO_INCREMENT=1 ;\n\n\n.. code:: python\n\n import pymysql.cursors\n\n # Connect to the database\n connection = pymysql.connect(host='localhost',\n user='user',\n password='passwd',\n db='db',\n charset='utf8mb4',\n cursorclass=pymysql.cursors.DictCursor)\n\n try:\n with connection.cursor() as cursor:\n # Create a new record\n sql = \"INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)\"\n cursor.execute(sql, ('webmaster@python.org', 'very-secret'))\n\n # connection is not autocommit by default. So you must commit to save\n # your changes.\n connection.commit()\n\n with connection.cursor() as cursor:\n # Read a single record\n sql = \"SELECT `id`, `password` FROM `users` WHERE `email`=%s\"\n cursor.execute(sql, ('webmaster@python.org',))\n result = cursor.fetchone()\n print(result)\n finally:\n connection.close()\n\nThis example will print:\n\n.. code:: python\n\n {'password': 'very-secret', 'id': 1}\n\n\nResources\n---------\n\n* DB-API 2.0: https://www.python.org/dev/peps/pep-0249/\n\n* MySQL Reference Manuals: https://dev.mysql.com/doc/\n\n* MySQL client/server protocol:\n https://dev.mysql.com/doc/internals/en/client-server-protocol.html\n\n* \"Connector\" channel in MySQL Community Slack:\n https://lefred.be/mysql-community-on-slack/\n\n* PyMySQL mailing list: https://groups.google.com/forum/#!forum/pymysql-users\n\nLicense\n-------\n\nPyMySQL is released under the MIT License. See LICENSE for more information.\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/anthill-utils/PyMySQL/", "keywords": "MySQL", "license": "\"MIT\"", "maintainer": "INADA Naoki", "maintainer_email": "songofacandy@gmail.com", "name": "anthill-PyMySQL", "package_url": "https://pypi.org/project/anthill-PyMySQL/", "platform": "", "project_url": "https://pypi.org/project/anthill-PyMySQL/", "project_urls": { "Documentation": "https://pymysql.readthedocs.io/", "Homepage": "https://github.com/anthill-utils/PyMySQL/" }, "release_url": "https://pypi.org/project/anthill-PyMySQL/0.9.999/", "requires_dist": [ "cryptography ; extra == 'rsa'" ], "requires_python": "", "summary": "Pure Python MySQL Driver", "version": "0.9.999" }, "last_serial": 4796816, "releases": { "0.9.999": [ { "comment_text": "", "digests": { "md5": "3901d6df944c169c8d0b48506afcc041", "sha256": "945e912bdaeb663349890ebdfb846afb99d391ee13a979fd57712147bd10db3f" }, "downloads": -1, "filename": "anthill_PyMySQL-0.9.999-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3901d6df944c169c8d0b48506afcc041", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 46970, "upload_time": "2019-02-08T18:25:27", "url": "https://files.pythonhosted.org/packages/ac/13/d0f733bd14ae487117cad470190c5e4dbe8b94f62888ae450dcecff92dd1/anthill_PyMySQL-0.9.999-py2.py3-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "3901d6df944c169c8d0b48506afcc041", "sha256": "945e912bdaeb663349890ebdfb846afb99d391ee13a979fd57712147bd10db3f" }, "downloads": -1, "filename": "anthill_PyMySQL-0.9.999-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3901d6df944c169c8d0b48506afcc041", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 46970, "upload_time": "2019-02-08T18:25:27", "url": "https://files.pythonhosted.org/packages/ac/13/d0f733bd14ae487117cad470190c5e4dbe8b94f62888ae450dcecff92dd1/anthill_PyMySQL-0.9.999-py2.py3-none-any.whl" } ] }