{ "info": { "author": "cwade", "author_email": "pysurveyhelper@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.2", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4" ], "description": "Oracle DB Query\n===============\n\nThis package consists of a single method that runs a specified query, passed\nin as a string, on an Oracle database and returns the result to a Pandas\ndata frame.\n\n----\n\nSample usage::\n\n from oracle_db_query import query_to_df\n\n query = \"select id, name from students where name like '%Oscar%'\"\n query_to_df(query, \"config.yml\")\n\nReturns::\n\n ID NAME\n 0 3298272 Meyer,Oscar\n 1 2304928 Wilde,Oscar\n 2 7654321 Grouch,Oscar\n . ... ...\n 128 2234879 De La Hoya,Oscar\n 129 9872322 Peterson,Oscar\n 130 9082394 Sanchez,Oscar\n\n [131 rows x 2 columns]\n\nSample config file::\n\n database:\n username: \"OGROUCH\"\n password: \"SECR3TPASSWORD\"\n host: >\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)\n (HOST = servername.williams.edu)\n (PORT = 1521)\n )\n (CONNECT_DATA = (SERVER = DEDICATED)\n (SID = dbname)\n )\n )\n\nIf you don't wish to store your password in the configuration file, you can\nomit that line. If a password isn't present in the configuration file, you\nwill be prompted for it at runtime.", "description_content_type": null, "docs_url": null, "download_url": null, "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/cwade/oracle_db_query", "keywords": "oracle sql query pandas dataframe", "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "oracle-db-query", "package_url": "https://pypi.org/project/oracle-db-query/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/oracle-db-query/", "project_urls": { "Homepage": "https://github.com/cwade/oracle_db_query" }, "release_url": "https://pypi.org/project/oracle-db-query/1.0.0/", "requires_dist": null, "requires_python": null, "summary": "Execute an Oracle SQL query and return result as Pandas data frame", "version": "1.0.0" }, "last_serial": 1810553, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "d51d39ad18c80c40aaa54b8c5155c873", "sha256": "2790c2ad551e7b52b847e0820dc4ffbffe87ab8bfe50b3dac7613c455fc28a20" }, "downloads": -1, "filename": "oracle_db_query-1.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "d51d39ad18c80c40aaa54b8c5155c873", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 4087, "upload_time": "2015-11-10T23:18:19", "url": "https://files.pythonhosted.org/packages/c9/1c/965f5549c17252cc126817c8a36dc88af3ec1b34bf14744181aaa8bde61f/oracle_db_query-1.0.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3361e699f4c9e837130ee103b38e1d92", "sha256": "849e33c229362d387964515f9d038cc2188d223f9f617f541d14d8fb0730a8a7" }, "downloads": -1, "filename": "oracle_db_query-1.0.0.tar.gz", "has_sig": false, "md5_digest": "3361e699f4c9e837130ee103b38e1d92", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2342, "upload_time": "2015-11-10T23:18:24", "url": "https://files.pythonhosted.org/packages/0e/16/fe50bc5a8881ebd173defe41d5873743bd02703fd2106d6017f1d80bda5b/oracle_db_query-1.0.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "d51d39ad18c80c40aaa54b8c5155c873", "sha256": "2790c2ad551e7b52b847e0820dc4ffbffe87ab8bfe50b3dac7613c455fc28a20" }, "downloads": -1, "filename": "oracle_db_query-1.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "d51d39ad18c80c40aaa54b8c5155c873", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 4087, "upload_time": "2015-11-10T23:18:19", "url": "https://files.pythonhosted.org/packages/c9/1c/965f5549c17252cc126817c8a36dc88af3ec1b34bf14744181aaa8bde61f/oracle_db_query-1.0.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3361e699f4c9e837130ee103b38e1d92", "sha256": "849e33c229362d387964515f9d038cc2188d223f9f617f541d14d8fb0730a8a7" }, "downloads": -1, "filename": "oracle_db_query-1.0.0.tar.gz", "has_sig": false, "md5_digest": "3361e699f4c9e837130ee103b38e1d92", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2342, "upload_time": "2015-11-10T23:18:24", "url": "https://files.pythonhosted.org/packages/0e/16/fe50bc5a8881ebd173defe41d5873743bd02703fd2106d6017f1d80bda5b/oracle_db_query-1.0.0.tar.gz" } ] }