Mongo & Importing JSON to a Database
Console w/MongoDB
- To allow connections to your MongoDB database (such as applications needing to connect or Mongoose...), run
sudo mongod. Think of it asmongodoversees MongoDB. - To connect to the MongoDB terminal (similar to
psql), enter themongocommand.
Console commands
help: Show help.db.help(): Show help for database methods.db.<collection>.help(): Show help on collection methods. Thecan be the name of an existing collection or a non-existing collection. show dbs: Print a list of all databases on the server.use <db>: Switch current database to. The mongo shell variable db is set to the current database. show collections: Print a list of all collections for current databaseshow users: Print a list of users for current database.show roles: Print a list of all roles, both user-defined and built-in, for the current database.show profile: Print the five most recent operations that took 1 millisecond or more.show databases: No description needed.
Import JSON into a database
# mongoimport --db <databaseName> --collection <collectionName> <jsonFile.json> --jsonArray
mongoimport --db britney --collection songs britney.json --jsonArray
Only use the -jsonArray flag if you are importing an array of objects! Otherwise, you don't need it!