{ "info": { "author": "laodouya", "author_email": "jin.xu@CovenantSQL.io", "bugtrack_url": null, "classifiers": [ "Development Status :: 2 - Pre-Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: Apache Software License", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: Implementation :: CPython", "Programming Language :: Python :: Implementation :: PyPy", "Topic :: Database" ], "description": "PyCovenantSQL\n===============\n\n.. contents:: Table of Contents\n :local:\n\nThis package contains a pure-Python CovenantSQL client library, based on `PEP 249`_.\n\n\nNOTE: PyCovenantSQL only support high level APIs defined in `PEP 249`_.\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.4\n - PyPy_ : Latest version\n\n* Packages:\n\n - Requests_ >= 2.19\n - Arrow_ >= 0.13\n\n* CovenantSQL Adapter Server:\n\n - CovenantSQL_ >= 0.0.3\n\n\n.. _CPython: https://www.python.org/\n.. _PyPy: https://pypy.org/\n.. _Requests: http://www.python-requests.org/\n.. _Arrow: https://github.com/crsmithdev/arrow\n.. _CovenantSQL: https://github.com/CovenantSQL/CovenantSQL\n\n\n\nInstallation\n------------\n\nPackage is uploaded on `PyPI `_.\n\nYou can install it with pip::\n\n $ python3 -m pip install PyCovenantSQL\n\n\nDocumentation\n-------------\n\nDocumentation is available online: http://developers.covenantsql.io/\n\nKey file and dsn can get from: http://developers.covenantsql.io/docs/quickstart\n\nFor support, please fire a issue at `Github\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` INTEGER PRIMARY KEY AUTOINCREMENT,\n `email` varchar(255) NOT NULL,\n `password` varchar(255) NOT NULL\n );\n\n\n.. code:: python\n\n import pycovenantsql\n\n\n # Connect to the database with dsn\n # host and port are your local CovenantSQL Adapter server\n connection = pycovenantsql.connect(\n dsn='covenantsql://your_database_id',\n host='localhost',\n port=11108,\n )\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 autocommit. No need to commit in any case.\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: http://www.python.org/dev/peps/pep-0249\n\n* CovenantSQL Website: https://covenantsql.io/\n\n* CovenantSQL testnet quick start:\n https://testnet.covenantsql.io/quickstart\n\n* CovenantSQL source code:\n https://github.com/CovenantSQL/CovenantSQL\n\n\nLicense\n-------\n\nPyCovenantSQL is released under the Apache 2.0 License. See LICENSE for more information.", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/CovenantSQL/cql-python-driver/", "keywords": "CovenantSQL,driver,database", "license": "Apache 2.0 Licence", "maintainer": "", "maintainer_email": "", "name": "PyCovenantSQL", "package_url": "https://pypi.org/project/PyCovenantSQL/", "platform": "", "project_url": "https://pypi.org/project/PyCovenantSQL/", "project_urls": { "Homepage": "https://github.com/CovenantSQL/cql-python-driver/" }, "release_url": "https://pypi.org/project/PyCovenantSQL/0.1.5/", "requires_dist": null, "requires_python": "", "summary": "Pure Python CovenantSQL Driver", "version": "0.1.5" }, "last_serial": 5296773, "releases": { "0.0.2": [ { "comment_text": "", "digests": { "md5": "36c92f5f6abbb52dcf0d1f7177563751", "sha256": "faee164621fc7bb399bc666a245e73c35aac2930c01cc46e8eb5583de1333739" }, "downloads": -1, "filename": "PyCovenantSQL-0.0.2.tar.gz", "has_sig": false, "md5_digest": "36c92f5f6abbb52dcf0d1f7177563751", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13588, "upload_time": "2018-10-22T17:56:45", "url": "https://files.pythonhosted.org/packages/94/dc/e6ae405f985f2a80af505dbc687699b79b6de22f42408c8e962185f4bd1e/PyCovenantSQL-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "938e12bfcc3b322208e1f002270b9de3", "sha256": "0ffbfd46512685d9536fe4cf21e998ace7567611c89c636f6e8e7ae120c4272d" }, "downloads": -1, "filename": "PyCovenantSQL-0.0.3.tar.gz", "has_sig": false, "md5_digest": "938e12bfcc3b322208e1f002270b9de3", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13629, "upload_time": "2018-10-24T11:11:42", "url": "https://files.pythonhosted.org/packages/4f/bf/6c6cb65490ed3a22787fb868111a998d03085bd32eff38a1559f99e64584/PyCovenantSQL-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "b3627c1bc72f9b3bfdfcddc8a4df67cc", "sha256": "9dff3604c5bfe8fb60514f741a242960e1c2eb546272c5ba32315653d4857da8" }, "downloads": -1, "filename": "PyCovenantSQL-0.0.4.tar.gz", "has_sig": false, "md5_digest": "b3627c1bc72f9b3bfdfcddc8a4df67cc", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13775, "upload_time": "2018-11-02T08:55:44", "url": "https://files.pythonhosted.org/packages/7c/e1/adbfa3db236968a2c4cf3dbfe79e3755b6019d9fbed222d94160fdae48cf/PyCovenantSQL-0.0.4.tar.gz" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "d9007a88c838d0ca0d0c6ba17e80c9bb", "sha256": "7e5390af74227da394021841f6d72d93e8becc3310fdfc8de5c0bff28e5fe24c" }, "downloads": -1, "filename": "PyCovenantSQL-0.0.5.tar.gz", "has_sig": false, "md5_digest": "d9007a88c838d0ca0d0c6ba17e80c9bb", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13771, "upload_time": "2018-11-08T10:19:38", "url": "https://files.pythonhosted.org/packages/10/50/533c92bf0229af89dd709d6358ab7523bdb5c7c65baf24f648ee616bccd3/PyCovenantSQL-0.0.5.tar.gz" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "799b54d0ba9061a21cccfe746dd07426", "sha256": "c864368a1a20a2e2b239bf584a38f7d60d02cd4480c71ea4ec3cd69778fc4974" }, "downloads": -1, "filename": "PyCovenantSQL-0.0.6.tar.gz", "has_sig": false, "md5_digest": "799b54d0ba9061a21cccfe746dd07426", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14039, "upload_time": "2018-11-08T10:35:04", "url": "https://files.pythonhosted.org/packages/fa/d8/f73ca957e70a364f5f8160f831fc8b5480c22abd8b5010fa0f355384aad6/PyCovenantSQL-0.0.6.tar.gz" } ], "0.0.7": [ { "comment_text": "", "digests": { "md5": "4b841c8e415997e2f6fa28246272a1c4", "sha256": "22c2bb1d2649d4f8b0704f5fc1813e11ce4fa1a3717748d02d95154fd85bb191" }, "downloads": -1, "filename": "PyCovenantSQL-0.0.7.tar.gz", "has_sig": false, "md5_digest": "4b841c8e415997e2f6fa28246272a1c4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14140, "upload_time": "2018-11-08T12:57:43", "url": "https://files.pythonhosted.org/packages/46/13/aa7a23527c71671d94677c6bcebcce6daeb04cd289707b873bc36d9f58fa/PyCovenantSQL-0.0.7.tar.gz" } ], "0.0.8": [ { "comment_text": "", "digests": { "md5": "624a99417f429fe8800136fd9c256650", "sha256": "f0d2923f9f13f80130b2069732b33b83d26c8cdb2208115513c5b7a75ae4e7ab" }, "downloads": -1, "filename": "PyCovenantSQL-0.0.8.tar.gz", "has_sig": false, "md5_digest": "624a99417f429fe8800136fd9c256650", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14151, "upload_time": "2018-11-27T06:45:23", "url": "https://files.pythonhosted.org/packages/73/ba/187dc0743334af6a0b69839a42e6a0542aa4d3a675172a1d4e5c5a3c9627/PyCovenantSQL-0.0.8.tar.gz" } ], "0.1.0": [ { "comment_text": "", "digests": { "md5": "f3ca51f1c92b27a5e3498a972af5989b", "sha256": "a67330a9e28118c2d6d8dea0713b36779ee688a175774cc5febbc4b64f5be93d" }, "downloads": -1, "filename": "PyCovenantSQL-0.1.0.tar.gz", "has_sig": false, "md5_digest": "f3ca51f1c92b27a5e3498a972af5989b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14108, "upload_time": "2018-12-06T12:26:08", "url": "https://files.pythonhosted.org/packages/74/3f/9808ce3033cbff5151c23755483f53af060f7aa3962d7ea49feffa53b440/PyCovenantSQL-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "0f578d02cd7c9817a727425d654eceb7", "sha256": "f376bb36dbc8af4466bfee414895aaae071a2c628343d9d7b088e2a4c62a63dd" }, "downloads": -1, "filename": "PyCovenantSQL-0.1.1.tar.gz", "has_sig": false, "md5_digest": "0f578d02cd7c9817a727425d654eceb7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13719, "upload_time": "2018-12-18T02:59:19", "url": "https://files.pythonhosted.org/packages/9b/d7/b605e13952d19e91b2579d1ebfd38741962ceaeaca000d5befe1836efac9/PyCovenantSQL-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "7556b79a3936995a6c4b9b6f2f2c6fdb", "sha256": "b8a811765e37fb7d56e1940adfb170dec98180c4241d3ee585c2d6685dbbe06c" }, "downloads": -1, "filename": "PyCovenantSQL-0.1.2.tar.gz", "has_sig": false, "md5_digest": "7556b79a3936995a6c4b9b6f2f2c6fdb", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13746, "upload_time": "2019-02-01T11:10:36", "url": "https://files.pythonhosted.org/packages/de/18/71ae6948ae68f52e06da66b490881df764267709dea9d32a6eba319eed65/PyCovenantSQL-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "e7315ffa015f5748405f5802823b6165", "sha256": "71c092f60dbcb3dc568d0885d4f035634bdc45db877a5b2db4c499c0cf2160fa" }, "downloads": -1, "filename": "PyCovenantSQL-0.1.3.tar.gz", "has_sig": false, "md5_digest": "e7315ffa015f5748405f5802823b6165", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13761, "upload_time": "2019-02-11T06:38:44", "url": "https://files.pythonhosted.org/packages/b5/37/9154f1dc6e2d49b783a7395da07793dcb5a85198ae84126b12f7b8aedb30/PyCovenantSQL-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "abed1ed3684e7ea0fa6ef408f7e3b421", "sha256": "2ddc56c801c4a30255fcbd840c7eb4e941aa87e41c26a9f413517a71b62ea640" }, "downloads": -1, "filename": "PyCovenantSQL-0.1.4.tar.gz", "has_sig": false, "md5_digest": "abed1ed3684e7ea0fa6ef408f7e3b421", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13840, "upload_time": "2019-04-16T09:53:54", "url": "https://files.pythonhosted.org/packages/05/75/3054e6148ec15a7862fda9806874f298bf55fe562daf89519d0e591fad12/PyCovenantSQL-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "fc240df17bed7ed489c554fd2c9bfced", "sha256": "27c0b1edeb2194de8f36fc8bc6416934df94cdf023f0856d9306a7841ef4d043" }, "downloads": -1, "filename": "PyCovenantSQL-0.1.5.tar.gz", "has_sig": false, "md5_digest": "fc240df17bed7ed489c554fd2c9bfced", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14336, "upload_time": "2019-05-21T09:22:12", "url": "https://files.pythonhosted.org/packages/97/66/a6e578803e3351052ee36f4939051291337cab24a090d1caa7bf08028c47/PyCovenantSQL-0.1.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "fc240df17bed7ed489c554fd2c9bfced", "sha256": "27c0b1edeb2194de8f36fc8bc6416934df94cdf023f0856d9306a7841ef4d043" }, "downloads": -1, "filename": "PyCovenantSQL-0.1.5.tar.gz", "has_sig": false, "md5_digest": "fc240df17bed7ed489c554fd2c9bfced", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14336, "upload_time": "2019-05-21T09:22:12", "url": "https://files.pythonhosted.org/packages/97/66/a6e578803e3351052ee36f4939051291337cab24a090d1caa7bf08028c47/PyCovenantSQL-0.1.5.tar.gz" } ] }