{ "info": { "author": "Daniel Schep", "author_email": "dschep@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "License :: OSI Approved :: MIT License", "Programming Language :: Python", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: Implementation :: CPython", "Topic :: Database", "Topic :: Database :: Front-Ends" ], "description": "\n## DB-API 2.0 driver & SqlAlchemy dialect for the AWS RDS Data API\n\n**NOTE: This is currently ALPHA quality software and has not been thoroughly tested yet**\n\nThe RDS Data API allows use of MySQL and PostgreSQL RDS databases via an HTTP API, making it ideal\nfor use in AWS Lambda because it allow syou to use RDS without running your lambda in a VPC. This\nlibrary wraps that API in both a [DB-API 2.0](https://www.python.org/dev/peps/pep-0249/) driver and\n[SqlAlchemy](https://www.sqlalchemy.org/) dialect allowing you to tap into the vast python\necosystem for working with relational databases.\n\n\n### Installation\n```\npip install rdsdataapi\n```\n\n\n### Usage\n\nTo use the DB-API 2.0 interface:\n```python\nfrom rdsdataapi import connect\ncon = connect(\n resource_arn=\"arn:aws:rds:us-east-1:490103061721:cluster:database-2\",\n secret_arn=\"arn:aws:secretsmanager:us-east-1:490103061721:secret:pgdb-gIucWr\",\n database=\"postgres\",\n)\ncur = con.cursor()\ncur.execute(\"select :foo as bar\", {\"foo\": \"foobar\"})\nresult = cur.fetchall()\n```\n\nOr via SqlAlchemy:\n```python\nengine = create_engine(\n 'rdsdataapi://',\n connect_args=dict(\n resource_arn=\"arn:aws:rds:us-east-1:490103061721:cluster:database-2\",\n secret_arn=\"arn:aws:secretsmanager:us-east-1:490103061721:secret:pgdb-gIucWr\",\n database=\"postgres\",\n )\n)\nwith engine.connect() as con:\n result = con.execute(\"select :foo as bar\", foo=\"foobar\")\n```\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/dschep/rdsdataapi", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "rdsdataapi", "package_url": "https://pypi.org/project/rdsdataapi/", "platform": "", "project_url": "https://pypi.org/project/rdsdataapi/", "project_urls": { "Homepage": "https://github.com/dschep/rdsdataapi" }, "release_url": "https://pypi.org/project/rdsdataapi/0.1.1/", "requires_dist": [ "boto3", "sqlalchemy ; extra == 'sqlalchemy'" ], "requires_python": ">=3.6.0", "summary": "DBAPI 2.0 adapter & SqlAlchemy Dialect for the RDS Data API", "version": "0.1.1" }, "last_serial": 5951160, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "b985c710e16a0d7709a7631ea2b1e362", "sha256": "c3f18b359ff61cf955d898fbaa39f0dc940c9caaf11d2087bb43c36e427bba20" }, "downloads": -1, "filename": "rdsdataapi-0.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "b985c710e16a0d7709a7631ea2b1e362", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=3.6.0", "size": 4913, "upload_time": "2019-10-08T16:13:41", "url": "https://files.pythonhosted.org/packages/e6/7d/3994223276c3d1e4902833824fdefbdc9c1923556ce545edf69fd9d38a73/rdsdataapi-0.1.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "90fe29a3eb2d1f41c9f0484aeed18af1", "sha256": "a46f5cf6ec4e5b1fce2a0bed17a826e29c9e0e2f2d6f67830c42f9cc097d4e85" }, "downloads": -1, "filename": "rdsdataapi-0.1.0.tar.gz", "has_sig": false, "md5_digest": "90fe29a3eb2d1f41c9f0484aeed18af1", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6.0", "size": 5540, "upload_time": "2019-10-08T16:13:44", "url": "https://files.pythonhosted.org/packages/a6/e9/25e592f3347a7ddbac7f20d07e6291a039d260f4640acab0593396889355/rdsdataapi-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "c351801fa6932c19d1ea059b77dd6a7a", "sha256": "a467d3c00007861f9f2fa3467650801e52c1cc974ee5ed01f0d8c23ec7235927" }, "downloads": -1, "filename": "rdsdataapi-0.1.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c351801fa6932c19d1ea059b77dd6a7a", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=3.6.0", "size": 4922, "upload_time": "2019-10-09T17:41:25", "url": "https://files.pythonhosted.org/packages/5b/29/ac3ffcb9a3bc7a3c1778d10ee2e1ca9df86a8dfbcbf958449437e749bae2/rdsdataapi-0.1.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7b3b4f531b1f0b56c164e6ba90684061", "sha256": "fc2571ca8f35fce6fa5eae33707339a782d4f32e0a7b6f0adddb9e8ccf3918b8" }, "downloads": -1, "filename": "rdsdataapi-0.1.1.tar.gz", "has_sig": false, "md5_digest": "7b3b4f531b1f0b56c164e6ba90684061", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6.0", "size": 5571, "upload_time": "2019-10-09T17:41:27", "url": "https://files.pythonhosted.org/packages/65/d1/cfa11cf98337afb3e296f8e75d8af13c1351fc94044f573a42b790a4fc3f/rdsdataapi-0.1.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "c351801fa6932c19d1ea059b77dd6a7a", "sha256": "a467d3c00007861f9f2fa3467650801e52c1cc974ee5ed01f0d8c23ec7235927" }, "downloads": -1, "filename": "rdsdataapi-0.1.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c351801fa6932c19d1ea059b77dd6a7a", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=3.6.0", "size": 4922, "upload_time": "2019-10-09T17:41:25", "url": "https://files.pythonhosted.org/packages/5b/29/ac3ffcb9a3bc7a3c1778d10ee2e1ca9df86a8dfbcbf958449437e749bae2/rdsdataapi-0.1.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7b3b4f531b1f0b56c164e6ba90684061", "sha256": "fc2571ca8f35fce6fa5eae33707339a782d4f32e0a7b6f0adddb9e8ccf3918b8" }, "downloads": -1, "filename": "rdsdataapi-0.1.1.tar.gz", "has_sig": false, "md5_digest": "7b3b4f531b1f0b56c164e6ba90684061", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6.0", "size": 5571, "upload_time": "2019-10-09T17:41:27", "url": "https://files.pythonhosted.org/packages/65/d1/cfa11cf98337afb3e296f8e75d8af13c1351fc94044f573a42b790a4fc3f/rdsdataapi-0.1.1.tar.gz" } ] }