-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdb_teste.js
More file actions
86 lines (67 loc) · 2.15 KB
/
db_teste.js
File metadata and controls
86 lines (67 loc) · 2.15 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
const {MongoClient} = require('mongodb');
async function main(){
/**
* Connection URI. Update <username>, <password>, and <your-cluster-url> to reflect your cluster.
* See https://docs.mongodb.com/ecosystem/drivers/node/ for more details
*/
const uri = "mongodb+srv://dbUser:userDB1234@cluster0.qpj9v.mongodb.net/myFirstDatabase?retryWrites=true&w=majority";
const client = new MongoClient(uri);
try {
// Connect to the MongoDB cluster
await client.connect();
// Make the appropriate DB calls
await listUsers(client);
} catch (e) {
console.error(e);
} finally {
await client.close();
}
}
async function listUsers(client){
const database = client.db("dadosdb");
const users = database.collection("users");
const options = {
sort: {username : 1},
};
const docs = await users.find().lean().exec();
console.log();
}
/*
const cursor = users.find();
const results = await cursor.toArray();
if (results.length > 0){
console.log("A pesquisa obteve resultados!");
results.forEach((result, i) => {
console.log();
console.log(`${i + 1}. name: ${result.username}`);
console.log(` _id: ${result._id}`);
console.log(` e-mail: ${result.email}`);
});
} else{
console.log("Nenhum Resultado.");
}
}
async function listDatabases(client){
databasesList = await client.db().admin().listDatabases();
console.log("Databases:");
databasesList.databases.forEach(db => console.log(` - ${db.name}`));
};
main().catch(console.error); */
/* MongoDB Local
const mongoose = require('mongoose');
const server = 'mongodb://localhost:27017/'
const database = 'dadosdb';
mongoose.connect(server+database).then(() => {
console.log("Succesfully connect to MongoDB.");
})
.catch(err => {
console.error("Connection error", err);
process.exit();
});
const userSchema = new mongoose.Schema({
username: String,
email: String
}, { collection: 'users'}
);
module.exports = {Mongoose:mongoose, UserSchema:userSchema}
*/