{ "info": { "author": "Sebastian Estenssoro", "author_email": "seb.estenssoro@gmail.com", "bugtrack_url": null, "classifiers": [], "description": "sqlwriter\n=========\n\nWrites pandas DataFrame to several flavors of sql database\n\nFlavors\n-------\n\n- Postres [complete]\n- Microsoft SQL [complete]\n- MySQL [complete]\n- Oracle [building]\n\nUsage\n=====\n.. code-block:: pycon\n\n from sqlwriter import SQLWriter\n import psycopg2\n import pandas as pd\n\n conn = psycopg2.connect(**db_creds)\n df = pd.DataFrame(data=range(10), columns=['numbers'])\n\n writer = SQLWriter(conn=conn,\n database='mydb',\n table_name='table_name',\n cols=df.columns,\n truncate=True)\n writer.write(df.values)\n writer.close()\n\nor\n\n.. code-block:: pycon\n\n from sqlwriter import SQLDataFrame\n import psycopg2\n\n conn = psycopg2.connect(**db_creds)\n\n df = SQLDataFrame(data=range(10), columns=['numbers'])\n df.to_sql(conn=conn,\n database='mydb',\n table_name='table_name',\n cols=df.columns,\n truncate=True)\n", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/estenssors/sqlwriter", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sqlwriter", "package_url": "https://pypi.org/project/sqlwriter/", "platform": "", "project_url": "https://pypi.org/project/sqlwriter/", "project_urls": { "Homepage": "https://github.com/estenssors/sqlwriter" }, "release_url": "https://pypi.org/project/sqlwriter/1.0.4/", "requires_dist": null, "requires_python": "", "summary": "Writes pandas DataFrame to several flavors of sql database", "version": "1.0.4" }, "last_serial": 3525599, "releases": { "1.0.1": [ { "comment_text": "", "digests": { "md5": "d2f0a14c171cd1d1c12f17e344753fe3", "sha256": "dea31e5315a52fbc3fb36037dd00dadd35ca417eb7b06780b820b4a2cababaf8" }, "downloads": -1, "filename": "sqlwriter-1.0.1-py2-none-any.whl", "has_sig": false, "md5_digest": "d2f0a14c171cd1d1c12f17e344753fe3", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 7514, "upload_time": "2017-12-30T20:17:38", "url": "https://files.pythonhosted.org/packages/fb/fb/454ae891b41615ed86df6f4460be4ffdef0d401ae35012eac4bcb768d862/sqlwriter-1.0.1-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "c78f3ac4f12b6ef89e67c1a9936789e4", "sha256": "d98302be88ba269e613792475ea5fc5f3d11f531ae713507d4308daa400e0048" }, "downloads": -1, "filename": "sqlwriter-1.0.1.tar.gz", "has_sig": false, "md5_digest": "c78f3ac4f12b6ef89e67c1a9936789e4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6887, "upload_time": "2017-12-30T20:17:41", "url": "https://files.pythonhosted.org/packages/c3/36/da82d9ef1aa98e3c6cd2fdd8eaaa339c629bfa91f0cc55f7f2d4956502e0/sqlwriter-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "43a801b017348241043a63f4db1aaf70", "sha256": "ed24ef456dc856c3b24febdd5713a9123939a0a5bcc294ed02b0b5eb8251d7a4" }, "downloads": -1, "filename": "sqlwriter-1.0.2.tar.gz", "has_sig": false, "md5_digest": "43a801b017348241043a63f4db1aaf70", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9534, "upload_time": "2018-01-11T12:27:15", "url": "https://files.pythonhosted.org/packages/10/e4/c5b7506e185fe0abfdf6e96db6b9276c1c6ad4aa0dd7f4e2ff07e5c3d6d7/sqlwriter-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "89c556bbc13114cc1dcfa4e19f21a4ef", "sha256": "02da0e10e64a211ce8dbeb9e97bc5f080b53aaceeb03edb7ac59cc46f6cc99de" }, "downloads": -1, "filename": "sqlwriter-1.0.3.tar.gz", "has_sig": false, "md5_digest": "89c556bbc13114cc1dcfa4e19f21a4ef", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9886, "upload_time": "2018-01-11T12:36:08", "url": "https://files.pythonhosted.org/packages/95/c6/55affd24be0e9177917eb86dbd27e4a141c287fc97ae1a5df8ac87da97b2/sqlwriter-1.0.3.tar.gz" } ], "1.0.4": [ { "comment_text": "", "digests": { "md5": "2086bbbe503e7f81f0653401223e533b", "sha256": "aeda31dc6f8f043069ac0ba40da403618cf843f436c2e68126e33d5fe5cd3d45" }, "downloads": -1, "filename": "sqlwriter-1.0.4.tar.gz", "has_sig": false, "md5_digest": "2086bbbe503e7f81f0653401223e533b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10223, "upload_time": "2018-01-27T00:06:53", "url": "https://files.pythonhosted.org/packages/c1/f5/2c6c303ef030a68d2842fce3a04ebdb013fd4086d66137c9471cb36f4d02/sqlwriter-1.0.4.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "2086bbbe503e7f81f0653401223e533b", "sha256": "aeda31dc6f8f043069ac0ba40da403618cf843f436c2e68126e33d5fe5cd3d45" }, "downloads": -1, "filename": "sqlwriter-1.0.4.tar.gz", "has_sig": false, "md5_digest": "2086bbbe503e7f81f0653401223e533b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10223, "upload_time": "2018-01-27T00:06:53", "url": "https://files.pythonhosted.org/packages/c1/f5/2c6c303ef030a68d2842fce3a04ebdb013fd4086d66137c9471cb36f4d02/sqlwriter-1.0.4.tar.gz" } ] }