yurpar/city-search-task

Importing data to mongodb

cat ./cities_canada-usa.tsv | awk -F $'\t' '{ print "{ _id: "$1", name: \""$2"\", location: {type: \"Point\", coordinates: ["$6","$5"]}, country: \""$9"\", admin:\""$11"\"}"}' | sed $'1s/^.*$//' | mongoimport --db=task-db --collection=cities --type=json --drop

By default city data stored at mongodb 'task-db' collection 'cities'

How to start

npm i

npm run dev

###ENV CONFIG defaults:

APP_PORT=300
MONGODB_URL=mongodb://localhost:27017/task-db

IP_COUNT_LIMIT=5
IP_TIME_LIMIT=1

###TODO

• docker-compose: add data to mongo db

• simplify this : cat ./cities_canada-usa.tsv | awk -F $'\t' '{ print "{ \"_id\": "$1", \"name\": \""$2"\", \"location\": {\"type\": \"Point\", \"coordinates\": ["$6","$5"]}, \"country\": \""$9"\", \"admin\":\""$11"\"}"}' | sed $'1s/^.*$//' | docker exec -i mongodb-cities sh -c 'mongoimport -d task-db -c cities --type=json --drop'