Import a CSV to MongoDB.
Project description
csv-2-mongo
Import a CSV to MongoDB using Python 🐍.
Installation
$ pip install csv-2-mongo
Usage
Usage: csv_2_mongo.py [OPTIONS] FILE
Import a csv FILE to MongoDB
Options:
-h, --help Show this message and exit.
-v, --version Show the version and exit.
-d, --database name Database name. [default: test]
-c, --collection name Collection name. [default: test]
-H, --host host Host name. [default: 0.0.0.0]
-p, --port port Port number. [default: 27017]
-t, --timeout sec Connection timeout (seconds). [default: 5]
-f, --force Overwrite collection if exists.
-y, --yes Automatic yes to prompts.
Note: CSV headers are required to correctly correlate MongoDB
fields
to CSVfields
.
Examples
Import mammals.csv
to a mammals
collection in the animals
database:
$ csv-2-mongo -d animals -c mammals ./mammals.csv
....................................
Connecting to 0.0.0.0:27017
....................................
Import data.csv to database=animals collection=mammals [y/N]? y
Import complete!
Import mammals.csv
to a mammals
collection in the animals
database overwriting the collection if it exists:
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.
$ csv-2-mongo -f -d animals -c mammals ./mammals.csv
....................................
Connecting to 0.0.0.0:27017
....................................
Import data.csv to database=animals collection=mammals [y/N]? y
Import complete!
Import mammals.csv
to a mammals
collection in the animals
database running on host mongo.travismclarke.com at port 27111:
$ csv-2-mongo -d animals -c mammals -H mongo.travismclarke.com -p 27111 ./mammals.csv
....................................
Connecting to mongo.travismclarke.com:27111
....................................
Import data.csv to database=animals collection=mammals [y/N]? y
Import complete!
To 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:
Note: this will not suppress the overwrite prompt which still requires the
-f, --force
flag.
$ csv-2-mongo -y -d animals -c mammals ./mammals.csv
....................................
Connecting to 0.0.0.0:27017
....................................
Import complete!
License
MIT © Travis Clarke
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for csv_2_mongo-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 193a9fa71c81c22e9755a7a5b6ff5c0bca63e973392a4a6869e5572f1b8c1091 |
|
MD5 | 54d8d0b73b828fb326f822ad6c3c39ac |
|
BLAKE2b-256 | 2abf02a053619d5695bac05a3b86a930941687b3c47a2f24b8d7fd313050574a |