{ "info": { "author": "Samuel Tan", "author_email": "samuel@doorda.com", "bugtrack_url": null, "classifiers": [ "Intended Audience :: Developers", "License :: OSI Approved :: Apache Software License", "Operating System :: OS Independent", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7" ], "description": "# Doorda Python SDK\n\n\n## Requirements\n\n- Python 2.7 / Python 3\n- [DoordaHost Account](https://doorda.com)\n\n## Installation\n\n### PyPi\n```bash\n$ pip install doorda-sdk\n```\n\n### Source\n#### Download from:\n1) https://github.com/Doorda/doorda-python-sdk/releases\n\n```bash\n$ wget https://github.com/Doorda/doorda-python-sdk/archive/1.0.10.zip\n\n$ unzip 1.0.10.zip\n```\n#### Install\n```bash\n$ python setup.py install\n```\n\n## Usage\n\n### DoordaHost\n\n1) Connect to database\n ```python\n from doorda_sdk.host import client\n\n conn = client.connect(username=\"username\",\n password=\"password\",\n catalog=\"catalog_name\",\n schema=\"schema_name\")\n cursor = conn.cursor()\n ```\n\n2) Execute Queries\n ```python\n cursor.execute(\"SELECT * FROM table_name\")\n\n # Returns generator of results\n # Does not put result into memory. Iterates through rows in a streaming fashion.\n for row in cursor.iter_result():\n # Do something with row\n \n # Fetch all results\n rows = cursor.fetchall()\n \n # Fetch one results\n rows = cursor.fetchone()\n \n # Fetch multiple results\n rows = cursor.fetchmany(size=10)\n \n # Get list of column names\n cursor.col_names\n \n # Get column names mapped to data types\n cursor.col_types\n ```\n\n3) Simplified Functions\n\n ```python\n # Check database connection\n results = cursor.is_connected()\n \n # List all catalogs\n rows = cursor.show_catalogs()\n\n # List all tables\n rows = cursor.show_tables(\"catalog_name\", \"schema_name\")\n \n # Get number of rows\n rows = cursor.table_stats(catalog=\"catalog_name\", \n schema=\"schema_name\",\n table=\"table_name\")\n ```\n\n## Find out more\n\nTo find out more about DoordaHost, head over to [https://github.com/Doorda/Getting-Started](https://github.com/Doorda/Getting-Started/blob/master/README.md)", "description_content_type": "text/markdown", "docs_url": null, "download_url": "https://github.com/Doorda/doorda-python-sdk/archive/1.0.10.tar.gz", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/doorda/doorda-python-sdk", "keywords": "", "license": "Apache License 2.0", "maintainer": "", "maintainer_email": "", "name": "doorda-sdk", "package_url": "https://pypi.org/project/doorda-sdk/", "platform": "", "project_url": "https://pypi.org/project/doorda-sdk/", "project_urls": { "Download": "https://github.com/Doorda/doorda-python-sdk/archive/1.0.10.tar.gz", "Homepage": "https://github.com/doorda/doorda-python-sdk" }, "release_url": "https://pypi.org/project/doorda-sdk/1.0.10/", "requires_dist": null, "requires_python": "", "summary": "Doorda SDK for access to Hosted Platform", "version": "1.0.10" }, "last_serial": 5267732, "releases": { "1.0.1": [ { "comment_text": "", "digests": { "md5": "e003f97e0196a5435cca8832269779a6", "sha256": "a0399d85624c963d65c0be1052454cdb4a1814bb0271aa11855ee91084ef2009" }, "downloads": -1, "filename": "doorda_sdk-1.0.1.tar.gz", "has_sig": false, "md5_digest": "e003f97e0196a5435cca8832269779a6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4078, "upload_time": "2019-04-30T10:46:10", "url": "https://files.pythonhosted.org/packages/6e/f2/d772afecd25797d7120e5c813b41afcd08205ec34a1a64514e5478284c06/doorda_sdk-1.0.1.tar.gz" } ], "1.0.10": [ { "comment_text": "", "digests": { "md5": "44640ce7ff293a54c593af0ac915341d", "sha256": "07db19d1c255ce61f0918dd1cee3c10299fd650d1ec9e73722dc486051cf8460" }, "downloads": -1, "filename": "doorda_sdk-1.0.10.tar.gz", "has_sig": false, "md5_digest": "44640ce7ff293a54c593af0ac915341d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9551, "upload_time": "2019-05-14T14:31:32", "url": "https://files.pythonhosted.org/packages/f2/0f/50bbec170c382b47a1cda7d6225944481fef3a35c9ec885cb52737a57228/doorda_sdk-1.0.10.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "dd1e02569ae2623fd8877e4f21a728c5", "sha256": "803cb257dd8a948c02f4d2f1983c4928cfe23215a2d821d32a61b45eba69028c" }, "downloads": -1, "filename": "doorda_sdk-1.0.3.tar.gz", "has_sig": false, "md5_digest": "dd1e02569ae2623fd8877e4f21a728c5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4141, "upload_time": "2019-04-30T12:08:09", "url": "https://files.pythonhosted.org/packages/50/2f/5621e6518f3fb7f18fb2f43713d2e92ce14bc4539aa7a310f8ad9d2b1444/doorda_sdk-1.0.3.tar.gz" } ], "1.0.4": [ { "comment_text": "", "digests": { "md5": "90c8f5c2bd0239fefe4574dfc8205937", "sha256": "4204bd980ab87d2c31ac5d90d56df714edcd7dbcc49f040356157dc484d2225b" }, "downloads": -1, "filename": "doorda_sdk-1.0.4.tar.gz", "has_sig": false, "md5_digest": "90c8f5c2bd0239fefe4574dfc8205937", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4141, "upload_time": "2019-04-30T12:35:23", "url": "https://files.pythonhosted.org/packages/ac/04/a05ea22ae5ae8de16986057ae8b1e6ffdaef261a412f75215c4232524cd3/doorda_sdk-1.0.4.tar.gz" } ], "1.0.5": [ { "comment_text": "", "digests": { "md5": "2f0c7ca52e8845631fb7aa78f5dfe107", "sha256": "abd502db20ed6f0e087d4b9fa18120fa41a568fff7c7c628c4f3993bfc266c10" }, "downloads": -1, "filename": "doorda_sdk-1.0.5.tar.gz", "has_sig": false, "md5_digest": "2f0c7ca52e8845631fb7aa78f5dfe107", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4231, "upload_time": "2019-05-03T14:24:23", "url": "https://files.pythonhosted.org/packages/f9/66/a952a4f620a293b1a86162077159e65d46a0590c1a645cb0349f0620b54a/doorda_sdk-1.0.5.tar.gz" } ], "1.0.6": [ { "comment_text": "", "digests": { "md5": "f8cd461ee079b90c281092c844aa2ce1", "sha256": "82e6d237bf7416a1c47191eb078d8ee72ab1c3b8447f3fd90fa7aa043261af43" }, "downloads": -1, "filename": "doorda_sdk-1.0.6.tar.gz", "has_sig": false, "md5_digest": "f8cd461ee079b90c281092c844aa2ce1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4211, "upload_time": "2019-05-04T08:54:37", "url": "https://files.pythonhosted.org/packages/d4/64/02a1920a8e9d18df4a97676ff6601df48fc986dea90725b95d9fba293b9f/doorda_sdk-1.0.6.tar.gz" } ], "1.0.7": [ { "comment_text": "", "digests": { "md5": "e561fd3a44ec6ee54e60154f9c62e30f", "sha256": "5b10a18ed9011c3d5e2b27abb870eb7fd40aeb23406bc5b903b30219395d0ebf" }, "downloads": -1, "filename": "doorda_sdk-1.0.7.tar.gz", "has_sig": false, "md5_digest": "e561fd3a44ec6ee54e60154f9c62e30f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9269, "upload_time": "2019-05-05T11:22:25", "url": "https://files.pythonhosted.org/packages/fa/dc/3528bd938dec1658bd54b531afa7a14ec2ecf7b966cbb668735a50b178ef/doorda_sdk-1.0.7.tar.gz" } ], "1.0.8": [ { "comment_text": "", "digests": { "md5": "4777da3c9c8ca1e3b279282c8ed517b6", "sha256": "6c175d877822cb343146226f39d6cd7935988ec746617570bc3df4508cfe95b6" }, "downloads": -1, "filename": "doorda_sdk-1.0.8.tar.gz", "has_sig": false, "md5_digest": "4777da3c9c8ca1e3b279282c8ed517b6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9268, "upload_time": "2019-05-05T19:37:35", "url": "https://files.pythonhosted.org/packages/49/87/2850c694191cdac7119511cc5b41aab5b1c0b45ade7de5b04b83bcb3f142/doorda_sdk-1.0.8.tar.gz" } ], "1.0.9": [ { "comment_text": "", "digests": { "md5": "6d0fc3d2ed7da7733503dfe62d031e07", "sha256": "afc091f1ecbf2fd3422d3d32a75434825e401d8b34b138f2aa96c9141e667130" }, "downloads": -1, "filename": "doorda_sdk-1.0.9.tar.gz", "has_sig": false, "md5_digest": "6d0fc3d2ed7da7733503dfe62d031e07", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9524, "upload_time": "2019-05-07T07:24:37", "url": "https://files.pythonhosted.org/packages/85/a5/3695b093ea138e429045973060e09121a8cb157f6db23db27df3266a4c07/doorda_sdk-1.0.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "44640ce7ff293a54c593af0ac915341d", "sha256": "07db19d1c255ce61f0918dd1cee3c10299fd650d1ec9e73722dc486051cf8460" }, "downloads": -1, "filename": "doorda_sdk-1.0.10.tar.gz", "has_sig": false, "md5_digest": "44640ce7ff293a54c593af0ac915341d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9551, "upload_time": "2019-05-14T14:31:32", "url": "https://files.pythonhosted.org/packages/f2/0f/50bbec170c382b47a1cda7d6225944481fef3a35c9ec885cb52737a57228/doorda_sdk-1.0.10.tar.gz" } ] }