{ "info": { "author": "Laurent Champagnac", "author_email": "champagnac.laurent@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Environment :: Other Environment", "Intended Audience :: Developers", "License :: OSI Approved :: GNU General Public License v3 (GPLv3)", "Natural Language :: English", "Operating System :: POSIX :: Linux", "Programming Language :: Python", "Topic :: Software Development :: Libraries" ], "description": "pysolmysql\n============\n\nWelcome to pysol\n\nCopyright (C) 2013/2017 Laurent Labatut / Laurent Champagnac\n\npysolmysql is a set of simple MYSQL client Apis\n\nThey are gevent based.\nThey rely on pymysql.\n\nUsage\n===============\n\n```\nd_conf = {\n \"host\": \"localhost\",\n \"port\": 3306,\n \"database\": None,\n \"user\": \"root\",\n \"password\": \"root\",\n \"autocommit\": True,\n}\n \nar = MysqlApi.exec_n(d_conf, \"select user, host from mysql.user;\")\n\nfor d_record in ar:\n logger.info(\"user=%s, host=%s\", d_record[\"user\"], d_record[\"host\"])\n```\n\nPool\n===============\n\nNow backed by a basic pool implementation, which support underlying backend clusters (mariadb galera for instance)\n\nThis basic pool implementation is forked and adapted from :\n- https://github.com/laurentL/django-mysql-geventpool-27\n- https://github.com/shunsukeaihara/django-mysql-geventpool\n\nPool max size\n===============\n\nPool max size (default 10) can be specified using\n```\nd_conf = {\n \"pool_max_size\": 10,\n ...\n}\n```\n\nPossible backward compatibility issue:\n- If the pool is maxed, an exception will be raised\n\nMultiple hosts\n===============\n\nMultiple hosts can be addressed in an active/active manner.\n\nSeveral hosts can be specified using :\n- \"hosts\" list (preferred)\n```\nd_conf = {\n \"hosts\": [\"localhost\", \"127.0.0.1\"],\n ...\n}\n```\n\n- \"host\" comma separated list\n```\nd_conf = {\n \"host\": \"localhost,127.0.0.1\",\n ...\n}\n```\n\n- \"host\" single entry (backward compatible mode)\n```\nd_conf = {\n \"host\": \"localhost\",\n ...\n}\n```\n\nSource code\n===============\n\n- We are pep8 compliant (as far as we can, with some exemptions)\n- We use a right margin of 360 characters (please don't talk me about 80 chars)\n- All unittest files must begin with `test_` or `Test`, should implement setUp and tearDown methods\n- All tests must adapt to any running directory\n- The whole project is backed by gevent (http://www.gevent.org/)\n- We use docstring (:return, :rtype, :param, :type etc..), they are mandatory\n- We use PyCharm \"noinspection\", feel free to use them\n\nRequirements\n===============\n\n- Debian 8 Jessie or greater, x64, Python 2.7\n\nUnittests\n===============\n\nTo run unittests, you will need:\n\n- mysql installed and running, with root/root credentials\n\nLicense\n===============\n\nThis program is free software; you can redistribute it and/or\nmodify it under the terms of the GNU General Public License\nas published by the Free Software Foundation; either version 2\nof the License, or (at your option) any later version.\n\nThis program is distributed in the hope that it will be useful,\nbut WITHOUT ANY WARRANTY; without even the implied warranty of\nMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\nGNU General Public License for more details.\n\nYou should have received a copy of the GNU General Public License\nalong with this program; if not, write to the Free Software\nFoundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://knock.center", "keywords": "", "license": "GPLv3", "maintainer": "", "maintainer_email": "", "name": "pysolmysql", "package_url": "https://pypi.org/project/pysolmysql/", "platform": "", "project_url": "https://pypi.org/project/pysolmysql/", "project_urls": { "Homepage": "https://knock.center" }, "release_url": "https://pypi.org/project/pysolmysql/1.1.6/", "requires_dist": null, "requires_python": "", "summary": "Simple MYSQL client Apis", "version": "1.1.6" }, "last_serial": 5759558, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "c95d4a1284ba4ed007e8caea579a5613", "sha256": "65aa5c510127d292e560ad370f0e0eede991055fff18a322b93853f9414ac068" }, "downloads": -1, "filename": "pysolmysql-1.0.0.tar.gz", "has_sig": false, "md5_digest": "c95d4a1284ba4ed007e8caea579a5613", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18065, "upload_time": "2017-09-17T18:27:56", "url": "https://files.pythonhosted.org/packages/f9/85/402693aeaea4eb3376e16a15ee9b3b140be009c9f62a6d30a12ed14592a8/pysolmysql-1.0.0.tar.gz" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "e6dd7cfde6ecd0560e3abd888d14f3f3", "sha256": "741e5c77df2b730ca1a6edb01f547c32835bd402c48337bd9a8d3212b9cfd258" }, "downloads": -1, "filename": "pysolmysql-1.0.1.tar.gz", "has_sig": false, "md5_digest": "e6dd7cfde6ecd0560e3abd888d14f3f3", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12602, "upload_time": "2017-09-17T18:51:43", "url": "https://files.pythonhosted.org/packages/8a/2a/1e8a0b2e7c93ee4799a73be65ef48ccc118fb78a58b201db6c597b6aaae6/pysolmysql-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "eac1e9b24e76d437ca4db91e04c685a6", "sha256": "5507405c38746b9d23a3851ca62fddb820b1271397ef4277ee878fe1f8e501a9" }, "downloads": -1, "filename": "pysolmysql-1.0.2.tar.gz", "has_sig": false, "md5_digest": "eac1e9b24e76d437ca4db91e04c685a6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12622, "upload_time": "2018-02-08T15:59:48", "url": "https://files.pythonhosted.org/packages/6c/85/5226e8326ef3829492871615ae636d1d7dad497f2ff4ca5ecd90229b3ac8/pysolmysql-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "2272014921987ac92bcb511c65d5992f", "sha256": "4fa6551f196a950f84fd4d4c1723092b4767dfb4e5adebd384de46eded8a52ab" }, "downloads": -1, "filename": "pysolmysql-1.0.3.tar.gz", "has_sig": false, "md5_digest": "2272014921987ac92bcb511c65d5992f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12649, "upload_time": "2018-02-08T18:25:51", "url": "https://files.pythonhosted.org/packages/c4/e5/536328eb39049c0f4c126fb6efb8f8b516225f97d5ce539f931939c68d42/pysolmysql-1.0.3.tar.gz" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "9bccc9a6f720086aa0d8d388845a6a92", "sha256": "e54994d99913a9596c23e8535bb37021746c0574938820440c90f8270f397295" }, "downloads": -1, "filename": "pysolmysql-1.1.0.tar.gz", "has_sig": false, "md5_digest": "9bccc9a6f720086aa0d8d388845a6a92", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12868, "upload_time": "2018-05-30T21:30:21", "url": "https://files.pythonhosted.org/packages/97/a8/92cd5cd0b8cac80e0aa456fc03f51cfb06f7128ea0057a5aeb959c6fb463/pysolmysql-1.1.0.tar.gz" } ], "1.1.1": [ { "comment_text": "", "digests": { "md5": "0dd1f1e4751d68f21b43c06979f0eb12", "sha256": "2c1295bf8660ed66095d359e3a44bec3bee2d63db3e194393d62b24bae90b8dd" }, "downloads": -1, "filename": "pysolmysql-1.1.1.tar.gz", "has_sig": false, "md5_digest": "0dd1f1e4751d68f21b43c06979f0eb12", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12880, "upload_time": "2018-06-29T09:21:56", "url": "https://files.pythonhosted.org/packages/ab/29/d058014ce59f2763a3620dfc2b028b4a5caf89a5fca45612a219c0febd63/pysolmysql-1.1.1.tar.gz" } ], "1.1.2": [ { "comment_text": "", "digests": { "md5": "21a05f4e0dbdf014cf5abc955e1d9fe6", "sha256": "555688550476bdd803ef3a5c6ad9e3fa48b666fd9b0bc2bc3606f28fb8318035" }, "downloads": -1, "filename": "pysolmysql-1.1.2.tar.gz", "has_sig": false, "md5_digest": "21a05f4e0dbdf014cf5abc955e1d9fe6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18664, "upload_time": "2018-07-03T07:48:31", "url": "https://files.pythonhosted.org/packages/6c/fa/dfecd3daf5a4fcc7abada056988061ea90f99b6a2a3de82a440efe00e03a/pysolmysql-1.1.2.tar.gz" } ], "1.1.3": [ { "comment_text": "", "digests": { "md5": "29530442510830a671a7cead390757b3", "sha256": "783d524ec1e7322e79c89495a9bd6da7880e347e788fc2b81c3e37137a62c14c" }, "downloads": -1, "filename": "pysolmysql-1.1.3.tar.gz", "has_sig": false, "md5_digest": "29530442510830a671a7cead390757b3", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18643, "upload_time": "2018-07-03T08:09:26", "url": "https://files.pythonhosted.org/packages/91/12/fe2b997b54fc2c3970fa63e26c5a84ec5412a9a6eee53278a9c33cf9a38a/pysolmysql-1.1.3.tar.gz" } ], "1.1.4": [ { "comment_text": "", "digests": { "md5": "4e7a8610ca2ada3f8308bf8c3b4e745b", "sha256": "1aa40c3fb3815e50df432fa1f542d287fabd27290334cbfafbff0b7485e8febd" }, "downloads": -1, "filename": "pysolmysql-1.1.4.tar.gz", "has_sig": false, "md5_digest": "4e7a8610ca2ada3f8308bf8c3b4e745b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21928, "upload_time": "2019-08-27T14:30:58", "url": "https://files.pythonhosted.org/packages/ff/67/601b8f1375bb19f0228914c46dbcb9dad967f6d6a075488b718f04085ade/pysolmysql-1.1.4.tar.gz" } ], "1.1.5": [ { "comment_text": "", "digests": { "md5": "95ea31a3d0ec420a0074daab04689a70", "sha256": "a8223db06e110f69e3f71be9c8f6830d17053f6418cd2f540f7471ecc220a355" }, "downloads": -1, "filename": "pysolmysql-1.1.5.tar.gz", "has_sig": false, "md5_digest": "95ea31a3d0ec420a0074daab04689a70", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21974, "upload_time": "2019-08-30T07:16:11", "url": "https://files.pythonhosted.org/packages/c5/a0/40dc40a4255cda55369d56dfb0aa2d57831d9d0340319892b8b4829d15a5/pysolmysql-1.1.5.tar.gz" } ], "1.1.6": [ { "comment_text": "", "digests": { "md5": "6ed04091ec77eb5838fdc2ebe6c5bd7d", "sha256": "5615657a0b498a8d150b3c116727e70eabb1e9cc340fcbf0f42fcfc54401018e" }, "downloads": -1, "filename": "pysolmysql-1.1.6.tar.gz", "has_sig": false, "md5_digest": "6ed04091ec77eb5838fdc2ebe6c5bd7d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21968, "upload_time": "2019-08-30T10:16:56", "url": "https://files.pythonhosted.org/packages/e8/21/bada2b55439f2241f62ad7d7fa62ede5664e1fbba1588eb3e464a06cf0e2/pysolmysql-1.1.6.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "6ed04091ec77eb5838fdc2ebe6c5bd7d", "sha256": "5615657a0b498a8d150b3c116727e70eabb1e9cc340fcbf0f42fcfc54401018e" }, "downloads": -1, "filename": "pysolmysql-1.1.6.tar.gz", "has_sig": false, "md5_digest": "6ed04091ec77eb5838fdc2ebe6c5bd7d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21968, "upload_time": "2019-08-30T10:16:56", "url": "https://files.pythonhosted.org/packages/e8/21/bada2b55439f2241f62ad7d7fa62ede5664e1fbba1588eb3e464a06cf0e2/pysolmysql-1.1.6.tar.gz" } ] }