Setup mongodb and load datasets

[richard-donbosco]

• nonsql mongodb

• Script to download the

• Install mongodb

• Create a location for the file storage locally

• Import json into the database collection

  • CLI
  • python

TODO:

• [ ] run docker container mongodb
• [x] install mongosh cli
• [x] install mongo compass
• [x] Experiment with loading datasets with json
• [x] Write a python script to load data to mongo
• [x] write the DB script for CRUD command
• [ ] Richard: Write a docker compose file for backend flask, frontend angular and mongodb

[richard-donbosco]

tutorial link mongodb

https://www.tutorialspoint.com/mongodb/mongodb_overview.htm

[richard-donbosco]

have a script to download the datasets locally

• one script -> dataset --> /src/data
• loader.py --> dataset from /src/data -> mongodb
• then work whatever

[richard-donbosco]

How to execute mongobd docker server:

docker run --name mongodb -d -p 27017:27017 -v ~/github/LAR-backend/src/data/mongodb:/data/db  mongo

[wzjoriv]

Datasets:

• Hospitals
• Fire Stations
• Aviation Facilities
• Local Law Enforcement Locations
• Public Schools

[richard-donbosco]

https://www.mongodb.com/compatibility/json-to-mongodb

https://www.mongodb.com/docs/mongodb-shell/crud/read/

[wzjoriv]

Command to create anaconda environment:

conda env create --file=environment.yml 
conda activate lar