I'm in a class called Client/Server Development. We are using MongoDB and Jupyter Notebooks to complete our assignments. We must write a Python program to implement CRUD for use in our database. I have attached the assignment instructions for the Update and Delete methods. I already have the Create and Read methods which have been tested and work. I cannot seem to get Update and Delete to function properly, however. I deleted what I had for those two sections. Can I get assistance in how to implement Update and Delete? Thanks. • An Update method that queries for and changes document(s) from a specified MongoDB database and specified collection■Input -> arguments to function should be the key/value lookup pair to use with the MongoDB driver find API call. Last argument tofunction will be a set of key/value pairs in the data type acceptable to the MongoDB driver insert API call.Return -> result in JSON format if successful, else MongoDB returned error message.■OA Delete method that queries for and removes document(s) from a specified MongoDB database and specified collectionInput -> arguments to function should be the key/value lookup pair to use with the MongoDB driver find API call.Return -> result in JSON format if successful, else MongoDB returned error message. 12345678910111213路14 15 16 17 18 192812232425262728293831323456羽8948412344520304044CRUD.pyfrom pymongo import MongoClientfrom bson.objectid import ObjectIdclass AnimalShelter(object):""" CRUD operations for Animal collection in MongoDB """def _init__(self, aacuser, admin):# Initializing the MongoClient. This helps to# access the MongoDB databases and collections.self.client = MongoClient('mongodb://%s:%s@localhost: 46703/AAC' % (aacuser, admin))self.database = self.client['AAC']# Complete this create method to implement the C in CRUD.defcreate(self, data):if data is not None:insert = self.database.animals.insert(data) # data should be dictionaryif insert != 0:return Trueelse:return falseelse:raise Exception ("Nothing to save, data parameter is empty")# Create method to implement the R in CRUD.def read(self, criteria-None):# If criteria is not None then this find will return all rows which matches the criteriacriteria:if# {'_id':False} just omits the unique ID of each rowdata = self.database.animals.find(criteria, {"_id": False})else:# If there is no search criteria then all the rows will be returndata = self.database.animals.find({}, {"_id": False})assert isinstance(data, object)return data# Create method to implement the U in CRUD# Create method to implement the D in CRUD

Python code for crud operations: orders_dao.py from datetime import datetimefrom sql_connection…

Answered: I'm in a class called Client/Server…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

I'm in a class called Client/Server Development. We are using MongoDB and Jupyter Notebooks to complete our assignments. We must write a Python program to implement CRUD for use in our database. I have attached the assignment instructions for the Update and Delete methods. I already have the Create and Read methods which have been tested and work. I cannot seem to get Update and Delete to function properly, however. I deleted what I had for those two sections. Can I get assistance in how to implement Update and Delete? Thanks.

• An Update method that queries for and changes document(s) from a specified MongoDB database and specified collection
■
Input -> arguments to function should be the key/value lookup pair to use with the MongoDB driver find API call. Last argument to
function will be a set of key/value pairs in the data type acceptable to the MongoDB driver insert API call.
Return -> result in JSON format if successful, else MongoDB returned error message.
■
O
A Delete method that queries for and removes document(s) from a specified MongoDB database and specified collection
Input -> arguments to function should be the key/value lookup pair to use with the MongoDB driver find API call.
Return -> result in JSON format if successful, else MongoDB returned error message.

1
2
3
4
5
6
7
8
9
10
11
12
13
路14 15 16 17 18 192812232425262728293831323456羽89484123445
20
30
40
44
CRUD.py
from pymongo import MongoClient
from bson.objectid import ObjectId
class AnimalShelter(object):
""" CRUD operations for Animal collection in MongoDB """
def _init__(self, aacuser, admin):
# Initializing the MongoClient. This helps to
# access the MongoDB databases and collections.
self.client = MongoClient('mongodb://%s:%s@localhost: 46703/AAC' % (aacuser, admin))
self.database = self.client['AAC']
# Complete this create method to implement the C in CRUD.
def
create(self, data):
if data is not None:
insert = self.database.animals.insert(data) # data should be dictionary
if insert != 0:
return True
else:
return false
else:
raise Exception ("Nothing to save, data parameter is empty")
# Create method to implement the R in CRUD.
def read(self, criteria-None):
# If criteria is not None then this find will return all rows which matches the criteria
criteria:
if
# {'_id':False} just omits the unique ID of each row
data = self.database.animals.find(criteria, {"_id": False})
else:
# If there is no search criteria then all the rows will be return
data = self.database.animals.find({}, {"_id": False})
assert isinstance(data, object)
return data
# Create method to implement the U in CRUD
# Create method to implement the D in CRUD

Expert Solution

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

MongoDB does not use SQL. I'm sorry but was my question even read?

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions