-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmain.py
64 lines (51 loc) · 1.68 KB
/
main.py
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
#import pymongo
import pymongo
import os
from dotenv import load_dotenv
load_dotenv()
# Fetch mongo env vars
# usr = os.environ['MONGO_DB_USER']
# pwd = os.environ['MONGO_DB_PASS']
# mongo_db_name = os.environ['MONGO_DB_NAME']
# mongo_collection_name = os.environ['MONGO_COLLECTION_NAME']
# url = os.environ['MONGO_DB_URL']
# Create a connection to the MongoDB server
#connectionString = "mongodb+srv://User_practice_project:[email protected]/?retryWrites=true&w=majority"
connectionString = os.environ['CONNECTION_STRING']
try:
client = pymongo.MongoClient(connectionString)
except Exception:
print ("error" + Exception)
#create a database
db = client['python-mongoDB-CRUD']
#create a collection
collection = db['demo_collection']
#create a document
'''Doc = {
"name":"Dilini Liyanage",
"message":"This is the 1st document in python-mongoDB-CRUD"
}
Doc2 = {
"name":"Dilini Liyanage",
"message":"This is the 2nd document in python-mongoDB-CRUD"
}
Doc3 = {
"name":"Dilini Liyanage",
"message":"This is the 3rd document in python-mongoDB-CRUD"
}
#insert a document
res = collection.insert_one(Doc)
print(res.inserted_id)
collection.insert_one(Doc2)
collection.insert_one(Doc3)'''
print (client.list_database_names())
#read a document
record = collection.find_one()
print(record)
'''#update a document
query = {"message":"This is the 1st document in python-mongoDB-CRUD"}
new_value = {"$set":{"message":"This is the updated document in python-mongoDB-CRUD doc 1"}}
collection.update_one(query, new_value)
#delete a document
query_del = {"message":"This is the updated document in python-mongoDB-CRUD doc 1"}
collection.delete_one(query_del)'''