{ "info": { "author": "Travis Clarke", "author_email": "travis.m.clarke@gmail.com", "bugtrack_url": null, "classifiers": [ "Environment :: Console", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Natural Language :: English", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# [csv-2-mongo](https://pypi.org/project/csv-2-mongo/)\n\n[![PyPi release](https://img.shields.io/pypi/v/csv-2-mongo.svg)](https://pypi.org/project/csv-2-mongo/)\n[![Downloads](https://pepy.tech/badge/csv-2-mongo)](https://pepy.tech/project/csv-2-mongo)\n\nImport a CSV to MongoDB using Python \ud83d\udc0d.\n\n## Installation\n\n```bash\n$ pip install csv-2-mongo\n```\n\n## Usage\n\n```text\n\nUsage: csv_2_mongo.py [OPTIONS] FILE\n\n Import a csv FILE to MongoDB\n\nOptions:\n -h, --help Show this message and exit.\n -v, --version Show the version and exit.\n -d, --database name Database name. [default: test]\n -c, --collection name Collection name. [default: test]\n -H, --host host Host name. [default: 0.0.0.0]\n -p, --port port Port number. [default: 27017]\n -t, --timeout sec Connection timeout (seconds). [default: 5]\n -f, --force Overwrite collection if exists.\n -y, --yes Automatic yes to prompts.\n\n```\n\n> Note: CSV headers are **required** to correctly correlate MongoDB `fields` to CSV `fields`. \n\n## Examples\n\nImport `mammals.csv` to a `mammals` collection in the `animals` database:\n\n```bash\n$ csv-2-mongo -d animals -c mammals ./mammals.csv\n```\n\n```txt\n....................................\nConnecting to 0.0.0.0:27017\n....................................\n\nImport data.csv to database=animals collection=mammals [y/N]? y\nImport complete!\n```\n\nImport `mammals.csv` to a `mammals` collection in the `animals` database **overwriting the collection if it exists**:\n\n> Note: the `-f, --force` flag will overwrite the collection without a prompt. If the flag is omitted, `csv-2-mongo` will prompt you before operations with potential data loss.\n\n```bash\n$ csv-2-mongo -f -d animals -c mammals ./mammals.csv\n```\n\n```txt\n....................................\nConnecting to 0.0.0.0:27017\n....................................\n\nImport data.csv to database=animals collection=mammals [y/N]? y\nImport complete!\n```\n\nImport `mammals.csv` to a `mammals` collection in the `animals` database running on *host* **mongo.travismclarke.com** at *port* **27111**:\n\n```bash\n$ csv-2-mongo -d animals -c mammals -H mongo.travismclarke.com -p 27111 ./mammals.csv\n```\n\n```txt\n....................................\nConnecting to mongo.travismclarke.com:27111\n....................................\n\nImport data.csv to database=animals collection=mammals [y/N]? y\nImport complete!\n```\n\nTo skip the prompt (e.g. `Import data.csv to ...`), such as running via a script, one can pass the `-y`, `--yes` flag to force a *yes* response to the confirmation prompt:\n\n> Note: this will not suppress the *overwrite* prompt which still requires the `-f, --force` flag.\n\n```bash\n$ csv-2-mongo -y -d animals -c mammals ./mammals.csv\n```\n\n```txt\n....................................\nConnecting to 0.0.0.0:27017\n....................................\n\nImport complete!\n```\n\n\n## License\n\nMIT © [**Travis Clarke**](https://blog.travismclarke.com/)\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/clarketm/csv_2_mongo", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "csv-2-mongo", "package_url": "https://pypi.org/project/csv-2-mongo/", "platform": "", "project_url": "https://pypi.org/project/csv-2-mongo/", "project_urls": { "Homepage": "https://github.com/clarketm/csv_2_mongo" }, "release_url": "https://pypi.org/project/csv-2-mongo/0.0.2/", "requires_dist": [ "click", "pandas", "pymongo", "black; extra == 'dev'", "nose2; extra == 'dev'" ], "requires_python": "", "summary": "Import a CSV to MongoDB.", "version": "0.0.2" }, "last_serial": 4583853, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "dad30e491fb26d931937733b75d786e6", "sha256": "ccfe2d9fd1d76df3bb8d2af33773ea733f475fb34aed0034738aeda38a0c14a0" }, "downloads": -1, "filename": "csv_2_mongo-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "dad30e491fb26d931937733b75d786e6", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3713, "upload_time": "2018-12-11T01:21:58", "url": "https://files.pythonhosted.org/packages/e1/04/81ed55fd8c878281bc99c754c8e7cb81aa14f68195c530d8b875fbdfb7ea/csv_2_mongo-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "49218f6074c593d84351de2d6ce76326", "sha256": "6d0da140113e302cf17f661686e93f9849b22b665381bc6827faae64b181e38b" }, "downloads": -1, "filename": "csv-2-mongo-0.0.1.tar.gz", "has_sig": false, "md5_digest": "49218f6074c593d84351de2d6ce76326", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3424, "upload_time": "2018-12-11T01:22:00", "url": "https://files.pythonhosted.org/packages/73/88/b7bc40606baae63d3feebae7a4ab2ce3bba46b62b2f36a01345dd016aadd/csv-2-mongo-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "54d8d0b73b828fb326f822ad6c3c39ac", "sha256": "193a9fa71c81c22e9755a7a5b6ff5c0bca63e973392a4a6869e5572f1b8c1091" }, "downloads": -1, "filename": "csv_2_mongo-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "54d8d0b73b828fb326f822ad6c3c39ac", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3750, "upload_time": "2018-12-11T05:29:43", "url": "https://files.pythonhosted.org/packages/2a/bf/02a053619d5695bac05a3b86a930941687b3c47a2f24b8d7fd313050574a/csv_2_mongo-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1e2d4d31141917ac4a61cf6d63c4aa2c", "sha256": "06079c4ccca83dcf86873ee9df6d06be03dd79ea7ad8e8f7b54a2164a9854787" }, "downloads": -1, "filename": "csv-2-mongo-0.0.2.tar.gz", "has_sig": false, "md5_digest": "1e2d4d31141917ac4a61cf6d63c4aa2c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3486, "upload_time": "2018-12-11T05:29:45", "url": "https://files.pythonhosted.org/packages/9f/4d/37b477577a396daf8e2244632f381734901fede53fe21326fd70075502b2/csv-2-mongo-0.0.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "54d8d0b73b828fb326f822ad6c3c39ac", "sha256": "193a9fa71c81c22e9755a7a5b6ff5c0bca63e973392a4a6869e5572f1b8c1091" }, "downloads": -1, "filename": "csv_2_mongo-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "54d8d0b73b828fb326f822ad6c3c39ac", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3750, "upload_time": "2018-12-11T05:29:43", "url": "https://files.pythonhosted.org/packages/2a/bf/02a053619d5695bac05a3b86a930941687b3c47a2f24b8d7fd313050574a/csv_2_mongo-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1e2d4d31141917ac4a61cf6d63c4aa2c", "sha256": "06079c4ccca83dcf86873ee9df6d06be03dd79ea7ad8e8f7b54a2164a9854787" }, "downloads": -1, "filename": "csv-2-mongo-0.0.2.tar.gz", "has_sig": false, "md5_digest": "1e2d4d31141917ac4a61cf6d63c4aa2c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3486, "upload_time": "2018-12-11T05:29:45", "url": "https://files.pythonhosted.org/packages/9f/4d/37b477577a396daf8e2244632f381734901fede53fe21326fd70075502b2/csv-2-mongo-0.0.2.tar.gz" } ] }