Como criar banco de dados e coleção em MongoDB

In MongoDB, the first basic step is to have a database and collection in place. The database is used to store all of the collections, and the collection in turn is used to store all of the documents. The documents in turn will contain the relevant field name and field values.

The snapshot above shows a basic example of how a document would look. The field names of the document are “Employeeid” and “EmployeeName”, and the field values are “1” and “Smith” respectively. A bunch of documents would then make up a collection in MongoDB.

Criando um banco de dados usando o comando “use”

Criando um banco de dados em MongoDB é tão simples quanto emitir o “usar” comando. O exemplo a seguir mostra como isso pode ser feito.

Code Explicação:

• As "usar" comando é usado para criar um banco de dados em MongoDB. If the database does not exist, a new one will be created.

If the command is executed successfully, the following output will be shown:

Saída:

MongoDB mudará automaticamente para o banco de dados depois de criado.

Criando uma coleção/tabela usando insert()

The easiest way to create a collection is to insert a record (which is nothing but a document consisting of field names and values) into a collection. If the collection does not exist, a new one will be created. The following example shows how this can be done.

db.Employee.insert
(
	{
		"Employeeid" : 1,
		"EmployeeName" : "Martin"
	}
)

Code Explicação:

• Como visto acima, usando o "inserir" comando a coleção será criada.

Adicionando documentos usando o comando insert()

MongoDB fornece o insert() command para inserir documentos em uma coleção. O exemplo a seguir mostra como isso pode ser feito.

Passo 1) Write the “insert” command.

Passo 2) Within the “insert” command, add the required field name and field value for the document which needs to be created.

Code Explicação:

1. A primeira parte do comando é “insert statement“, which is the statement used to insert a document into the collection.
2. The second part of the statement is to add the field name and the field value, in other words, what the document in the collection is going to contain.

If the command is executed successfully, the following output will be shown:

Saída:

A saída mostra que a operação executada foi uma operação de inserção e que um registro foi inserido na coleção.

How to Query Documents in MongoDB using find()

After inserting documents, the next step is to read them back. MongoDB provides the find() method to query documents in a collection. This is the “read” operation in CRUD (Create, Read, Update, Delete).

To display all documents in the Employee collection, run the command below:

db.Employee.find()

The output of find() can be difficult to read on a single line. To display the documents in a formatted, easy-to-read structure, append the pretty() method:

db.Employee.find().pretty()

You can also filter the results by passing a query condition. For example, to find only the employee whose Employeeid is 1, pass a field-value pair to find():

db.Employee.find({ "Employeeid" : 1 })

Code Explicação:

• find() with no argument returns every document in the collection as a cursor.
• Passing a field-value pair, such as {“Employeeid”: 1}, returns only the documents that match that condition.
• The findOne() method works the same way but returns just the first matching document instead of a cursor.

This read operation is the most common way to retrieve stored data from a MongoDB coleção.

How to Drop a Collection and Database in MongoDB

When a collection or database is no longer needed, MongoDB lets you remove it. To drop a single collection, switch to its database and run the drop() method:

db.Employee.drop()

This deletes the Employee collection along with all of its documents. The command returns verdadeiro when the collection is dropped successfully.

To drop the entire current database, run the dropDatabase() command:

db.dropDatabase()

This removes the database you are currently using, along with all of its collections. Keep the following cautions in mind before dropping:

• Cairping is permanent and cannot be undone, so back up important data first.
• Make sure you are connected to the correct database before running dropDatabase().
• Use these commands carefully, especially in production environments.

Perguntas Frequentes