Kenneth at 21:38, 20 July 2024

2024-07-20T21:38:10Z

← Older revision		Revision as of 21:38, 20 July 2024
Line 14:		Line 14:
	with open('../files/mongo.password', 'r') as file:		with open('../files/mongo.password', 'r') as file:
	password = file.read().replace('\n', '')		password = file.read().replace('\n', '')
			with open('../files/mongo.server', 'r') as file:
			server = file.read().replace('\n', '')

	# pymongo.errors.InvalidURI: Username and password must be escaped according to RFC 3986, use urllib.parse.quote_plus()		# pymongo.errors.InvalidURI: Username and password must be escaped according to RFC 3986, use urllib.parse.quote_plus()
Line 19:		Line 21:
	q_password = urllib.parse.quote_plus(password)		q_password = urllib.parse.quote_plus(password)
	creds = (f"{q_username}:{q_password}")		creds = (f"{q_username}:{q_password}")
	db_url = f"mongodb://{creds}@~~10.249.113.13~~:27017/"		db_url = f"mongodb://{creds}@{server}:27017/"
	print(db_url)		print(db_url)

Kenneth: Created page with "== Test ==

 #!/usr/bin/env python3  # python -m pip install pymongo import pymongo import urllib.parse  # pymongo tutorial - https://www.w3schools.com/python/python_mongodb_getstarted.asp  with open('../files/mongo.username', 'r') as file:     username = file.read().replace('\n', '') with open('../files/mongo.password', 'r') as file:     password = file.read().replace('\n', '')  # pymongo.errors.InvalidURI: Username and password must be escaped according to RFC 398..."

2024-07-20T21:37:33Z

Created page with "== Test == <pre> #!/usr/bin/env python3 # python -m pip install pymongo import pymongo import urllib.parse # pymongo tutorial - https://www.w3schools.com/python/python_mongodb_getstarted.asp with open('../files/mongo.username', 'r') as file: username = file.read().replace('\n', '') with open('../files/mongo.password', 'r') as file: password = file.read().replace('\n', '') # pymongo.errors.InvalidURI: Username and password must be escaped according to RFC 398..."

New page

== Test ==

<pre>
#!/usr/bin/env python3

# python -m pip install pymongo
import pymongo
import urllib.parse

# pymongo tutorial - https://www.w3schools.com/python/python_mongodb_getstarted.asp

with open('../files/mongo.username', 'r') as file:
username = file.read().replace('\n', '')
with open('../files/mongo.password', 'r') as file:
password = file.read().replace('\n', '')

# pymongo.errors.InvalidURI: Username and password must be escaped according to RFC 3986, use urllib.parse.quote_plus()
q_username = urllib.parse.quote_plus(username)
q_password = urllib.parse.quote_plus(password)
creds = (f"{q_username}:{q_password}")
db_url = f"mongodb://{creds}@10.249.113.13:27017/"
print(db_url)

db_client = pymongo.MongoClient(db_url)

print("List Databases:")
print(db_client.list_database_names())

# MongoDB will create the database if it does not exist, and make a connection to it.
db = db_client["test"]

# MongoDB will create the collection if it does not exist.
people = db["people"]

person = {"name": "John", "color": "blue"}
x = people.insert_one(person)
print(x.inserted_id)

person = {"name": "Mike", "color": "Green"}
x = people.insert_one(person)
print(x.inserted_id)

# Find first person in collection
first_person = people.find_one()
print("First person:")
print(first_person)

print("Find people who like blue:")
# if you want to sort: blue_people.sort(KEY)
blue_people = people.find({"color": "blue"}).sort('name')
# print(blue_people)
for person in blue_people:
print(person)

print("Delete blue people")
x = people.delete_many({"color": "blue"})
print(x)

# update one record
print("Updating Mike:")
x = people.update_one({"name": "Mike"}, {"$set": {"color": "red"}})
print(x)

print("Mike:")
mike = people.find_one({"name": "Mike"})
print(mike)

print("Drop collection")
people.drop()

print("Done")
</pre>

== keywords ==

Python/MongoDB - Revision history

Kenneth at 21:38, 20 July 2024