{ "info": { "author": "Gabriel Bordeaux", "author_email": "pypi@gab.lc", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "License :: OSI Approved :: MIT License", "Natural Language :: English", "Operating System :: MacOS", "Operating System :: POSIX :: Linux", "Programming Language :: Python", "Programming Language :: Python :: 3", "Topic :: Database", "Topic :: Database :: Database Engines/Servers" ], "description": "sql2csv\n=======\n\n|Pypi| |Build Status| |codecov| |MIT licensed|\n\nRun MySQL and PostgreSQL queries and store the results in CSV.\n\nWhy sql2csv\n-----------\n\n``sql2csv`` is a small utility to run MySQL and PostgreSQL queries and\nstore the output in a CSV file.\n\nIn some environments like when using MySQL or Aurora in AWS RDS,\nexporting queries\u2019 results to CSV is not available with native tools.\n``sql2csv`` is a simple module that offers this feature.\n\nInstallation\n------------\n\n.. code:: bash\n\n pip3 install sql2csv\n\n # Basic usage\n mysql [...] -e \"SELECT * FROM table\" | sql2csv\n # or\n psql [...] -c \"SELECT * FROM table\" | sql2csv\n\nExample\n-------\n\nFrom stdin\n~~~~~~~~~~\n\nFor simple queries you can pipe a result directly from ``mysql`` or\n``psql`` to ``sql2csv``.\n\nFor more complex queries, it is recommended to use the CLI (see below)\nto ensure a properly formatted CSV.\n\n.. code:: bash\n\n mysql -U root -p\"secret\" my_db -e \"SELECT * FROM some_mysql_table;\" | sql2csv\n\n id,some_int,some_str,some_date\n 1,12,hello world,2018-12-01 12:23:12\n 2,15,hello,2018-12-05 12:18:12\n 3,18,world,2018-12-08 12:17:12\n\n.. code:: bash\n\n psql -U postgres my_db -c \"SELECT * FROM some_pg_table\" | sql2csv\n\n id,some_int,some_str,some_date\n 1,12,hello world,2018-12-01 12:23:12\n 2,15,hello,2018-12-05 12:18:12\n 3,18,world,2018-12-08 12:17:12\n\nUsing ``sql2csv`` CLI\n~~~~~~~~~~~~~~~~~~~~~\n\nOutput to stdout\n^^^^^^^^^^^^^^^^\n\n.. code:: bash\n\n $ sql2csv --engine mysql \\\n --database my_db --user root --password \"secret\" \\\n --query \"SELECT * FROM some_mysql_table\"\n\n 1,12,hello world,2018-12-01 12:23:12\n 2,15,hello,2018-12-05 12:18:12\n 3,18,world,2018-12-08 12:17:12\n\nOutput saved in a file\n^^^^^^^^^^^^^^^^^^^^^^\n\n.. code:: bash\n\n $ sql2csv --engine mysql \\\n --database my_db --user root --password \"secret\" \\\n --query \"SELECT * FROM some_mysql_table\" \\\n --out file --destination_file export.csv\n\n # * Exporting rows...\n # ...done\n # * The result has been exported to export.csv.\n\n $ cat export.csv \n 1,12,hello world,2018-12-01 12:23:12\n 2,15,hello,2018-12-05 12:18:12\n 3,18,world,2018-12-08 12:17:12\n\nUsage\n-----\n\n.. code:: bash\n\n usage: sql2csv [-h] [-e {mysql,postgresql}] [-H HOST] [-P PORT] -u USER\n [-p PASSWORD] -d DATABASE -q QUERY [-o {stdout,file}]\n [-f DESTINATION_FILE] [-D DELIMITER] [-Q QUOTECHAR]\n\n optional arguments:\n -h, --help show this help message and exit\n -e {mysql,postgresql}, --engine {mysql,postgresql}\n Database engine\n -H HOST, --host HOST Database host\n -P PORT, --port PORT Database port\n -u USER, --user USER Database user\n -p PASSWORD, --password PASSWORD\n Database password\n -d DATABASE, --database DATABASE\n Database name\n -q QUERY, --query QUERY\n SQL query\n -o {stdout,file}, --out {stdout,file}\n CSV destination\n -f DESTINATION_FILE, --destination_file DESTINATION_FILE\n CSV destination file\n -D DELIMITER, --delimiter DELIMITER\n CSV delimiter\n -Q QUOTECHAR, --quotechar QUOTECHAR\n CSV quote character\n\n.. |Pypi| image:: https://img.shields.io/pypi/v/sql2csv.svg\n :target: https://pypi.org/project/sql2csv\n.. |Build Status| image:: https://travis-ci.org/gabfl/sql2csv.svg?branch=master\n :target: https://travis-ci.org/gabfl/sql2csv\n.. |codecov| image:: https://codecov.io/gh/gabfl/sql2csv/branch/master/graph/badge.svg\n :target: https://codecov.io/gh/gabfl/sql2csv\n.. |MIT licensed| image:: https://img.shields.io/badge/license-MIT-green.svg\n :target: https://raw.githubusercontent.com/gabfl/sql2csv/master/LICENSE\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/gabfl/sql2csv", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sql2csv", "package_url": "https://pypi.org/project/sql2csv/", "platform": "", "project_url": "https://pypi.org/project/sql2csv/", "project_urls": { "Homepage": "https://github.com/gabfl/sql2csv" }, "release_url": "https://pypi.org/project/sql2csv/1.2/", "requires_dist": [ "argparse", "PyYAML", "pymysql", "psycopg2-binary" ], "requires_python": "", "summary": "Run MySQL and PostgreSQL queries and store result in CSV", "version": "1.2" }, "last_serial": 5924630, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "5d2ef6f48d6ac72766701aa855ff8d62", "sha256": "d54faba6a145ecdee294ce846ad55c50291d62926d75bfe5629395ea8c654eb8" }, "downloads": -1, "filename": "sql2csv-0.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "5d2ef6f48d6ac72766701aa855ff8d62", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 4963, "upload_time": "2018-11-16T18:40:03", "url": "https://files.pythonhosted.org/packages/46/01/332effc49bdaa1f28bfcf92a9ccbb6804649643d4f21e7867f8b3d269bff/sql2csv-0.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7a6e26315dc9712f1855aaebc00239dd", "sha256": "32116cdb209e9f3cbfcd28d8d4b17cb9f87210092bc4f55e7ed009e1fdc4412b" }, "downloads": -1, "filename": "sql2csv-0.1.tar.gz", "has_sig": false, "md5_digest": "7a6e26315dc9712f1855aaebc00239dd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3668, "upload_time": "2018-11-16T18:40:05", "url": "https://files.pythonhosted.org/packages/88/3e/6ff611e4aa8729ef553caffac97d4881c50d551b7bea485cc39912e5dcbb/sql2csv-0.1.tar.gz" } ], "1.0": [ { "comment_text": "", "digests": { "md5": "7f944a27eba3e72c4ce4ef7622f07e22", "sha256": "e1ebab852efaa151bfad8d93f30bb72e4470b32b55965909c5c37bf94fffb451" }, "downloads": -1, "filename": "sql2csv-1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "7f944a27eba3e72c4ce4ef7622f07e22", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 4964, "upload_time": "2018-11-16T18:44:16", "url": "https://files.pythonhosted.org/packages/9f/53/cb3020c3f0cbf6e208dba183db936353ab3911eaca435f8740844d29161e/sql2csv-1.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ca3b2e0c4a0c2ead5d1477bf17d7325a", "sha256": "fc4f2bfc6b48f91cd357da4a1da1f53574fda0b887598a040591858f10cff180" }, "downloads": -1, "filename": "sql2csv-1.0.tar.gz", "has_sig": false, "md5_digest": "ca3b2e0c4a0c2ead5d1477bf17d7325a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3675, "upload_time": "2018-11-16T18:44:17", "url": "https://files.pythonhosted.org/packages/39/de/8af3979ed5a0c0706fa2ee9a32540c9e02d920235b4b24cb51e4d3ff0a0f/sql2csv-1.0.tar.gz" } ], "1.1": [ { "comment_text": "", "digests": { "md5": "e4a5c90b7e8f0ae4a1f32d3fe168f032", "sha256": "7f11d12d38799317f54694b7b41d7457b8864879826028402f4a10b64512df66" }, "downloads": -1, "filename": "sql2csv-1.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "e4a5c90b7e8f0ae4a1f32d3fe168f032", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6329, "upload_time": "2018-11-18T18:02:38", "url": "https://files.pythonhosted.org/packages/f9/42/159da8c0d7bb0fb424af9a7653ffbdac3b75669600d9b264ed51e3fd65fe/sql2csv-1.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "78384ecde02a11400487ddb8dc25d94a", "sha256": "66c12d4700a61c6a0a3ac0313e6aa0c8496d26680c03a0d8fd6352dff26b977b" }, "downloads": -1, "filename": "sql2csv-1.1.tar.gz", "has_sig": false, "md5_digest": "78384ecde02a11400487ddb8dc25d94a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5261, "upload_time": "2018-11-18T18:02:40", "url": "https://files.pythonhosted.org/packages/3d/f0/4d01384936e8bd655571ae485c930d195732dd455ece6371d7ef6fd9ea40/sql2csv-1.1.tar.gz" } ], "1.2": [ { "comment_text": "", "digests": { "md5": "a18906aeea8008584e59d8603a06f3e0", "sha256": "6d1b8fa1561e8d50cdb2d7c7c8c5aa35e5d86e80a13c864e37337a1e16270c46" }, "downloads": -1, "filename": "sql2csv-1.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a18906aeea8008584e59d8603a06f3e0", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6471, "upload_time": "2019-10-03T18:11:54", "url": "https://files.pythonhosted.org/packages/69/a6/094869c0535a9e2479275686e39214e272014f5b71a5e2f9a0c8f2dc7347/sql2csv-1.2-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "452ff883ff0203db4291e83e1e140209", "sha256": "50e242cf286154aa76b79fa54c34db2ff652d39177c917aa1c6f14b2db5535d5" }, "downloads": -1, "filename": "sql2csv-1.2.tar.gz", "has_sig": false, "md5_digest": "452ff883ff0203db4291e83e1e140209", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5407, "upload_time": "2019-10-03T18:11:55", "url": "https://files.pythonhosted.org/packages/e0/67/83224e4a5330464770c2b7efbb84046c65fcd892bed6cfd83e944dfaddca/sql2csv-1.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "a18906aeea8008584e59d8603a06f3e0", "sha256": "6d1b8fa1561e8d50cdb2d7c7c8c5aa35e5d86e80a13c864e37337a1e16270c46" }, "downloads": -1, "filename": "sql2csv-1.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a18906aeea8008584e59d8603a06f3e0", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6471, "upload_time": "2019-10-03T18:11:54", "url": "https://files.pythonhosted.org/packages/69/a6/094869c0535a9e2479275686e39214e272014f5b71a5e2f9a0c8f2dc7347/sql2csv-1.2-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "452ff883ff0203db4291e83e1e140209", "sha256": "50e242cf286154aa76b79fa54c34db2ff652d39177c917aa1c6f14b2db5535d5" }, "downloads": -1, "filename": "sql2csv-1.2.tar.gz", "has_sig": false, "md5_digest": "452ff883ff0203db4291e83e1e140209", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5407, "upload_time": "2019-10-03T18:11:55", "url": "https://files.pythonhosted.org/packages/e0/67/83224e4a5330464770c2b7efbb84046c65fcd892bed6cfd83e944dfaddca/sql2csv-1.2.tar.gz" } ] }