logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Bryan ThomsonPsychology
(5/5)

682 Answers

Hire Me
expert
K AndersonAccounting
(5/5)

547 Answers

Hire Me
expert
Anuj MittalMathematics
(/5)

950 Answers

Hire Me
expert
Zuber KhanEconomics
(5/5)

645 Answers

Hire Me
Python Programming

The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

CS 340 Milestone One Guidelines and Rubric 

Overview: For this assignment, you will implement the fundamental operations of create, read, update, and delete (CRUD) in either Python or Java. You will use the language-specific MongoDB driver to create CRUD functional access to your document collection. 

At this point in the course, you will need to select the programming language you would like to use. (You may choose whichever language you prefer, but considering the opportunities in your program, we do recommend Python.) Keep in mind that you must use your chosen programming language for the remainder of the course (Milestone Two and the final project) because your assignments will build on each other starting with this milestone. 

Reminders 

  • To create a code file in Codio, right-click on the briefcase icon next to your Codio project and select New File. Refer to this video for further guidance. 
  • To download a code file in Codio, right-click on the document icon next to your Codio text file and select Download
  • Type all Python code into your Codio terminal manually, especially when running the Python example code below. Python is space-sensitive and does not copy into the Codio terminal well. 

Prior to completing the prompt for this assignment, run the following code in your chosen language. 

Example Python Code to Insert a Document 

import json from bson import json_util from pymongo import MongoClient 

connection = MongoClient('localhost', 27017) db = connection['myDB'] collection = db['myCollection'] 

def insert_document(document): 

try: result=collection.save(document) except ValidationError as ve: abort(400, str(ve)) return result 

def main(): 

myDocument = { "keyName" : "test value data"} 

print insert_document(myDocument) 

main() 

--------------------------------------- 

Example Java Code 

To run with Maven, first create a project: 

mvn archetype:generate -DgroupId=com.snhu.app -DartifactId=example-app -DarchetypeArtifactId=maven-archetype- quickstart -DinteractiveMode=false 

Then use the following text for the pom.xml file: 

 

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> 4.0.0 com.snhu.app example-app jar 1.0-SNAPSHOT example-app http://maven.apache.org  

org.mongodb mongo-java-driver 2.13.3  

junit junit 3.8.1 test  

 

org.apache.maven.plugins maven-assembly-plugin 2.4  

 

jar-with-dependencies  

 

 

 

assemble-all package  

single  

org.apache.maven.plugins maven-jar-plugin  

 

 

true fully.qualified.MainClass  

Use the following code for the example-app/src/main/java/com/snhu/app/App.java file: 

package com.snhu.app; 

import com.mongodb.BasicDBObject; import com.mongodb.BulkWriteOperation; import com.mongodb.BulkWriteResult; import com.mongodb.Cursor; import com.mongodb.DB; import com.mongodb.DBCollection; 

import com.mongodb.DBCursor; import com.mongodb.DBObject; import com.mongodb.MongoClient; import com.mongodb.ParallelScanOptions; import com.mongodb.ServerAddress; 

import java.util.List; import java.util.Set; import java.io.IOException; import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.lang.ClassNotFoundException; import java.net.InetAddress; import java.net.Socket; import java.net.UnknownHostException; 

import static java.util.concurrent.TimeUnit.SECONDS; 

public class App { 

public static void create_document(BasicDBObject doc) { 

try { 

MongoClient mongoClient = new MongoClient( "localhost" ); DB db = mongoClient.getDB( "myDB" ); DBCollection coll = db.getCollection("myCollection"); coll.insert(doc); } catch (UnknownHostException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } } 

public static void main( String[] args ) { 

BasicDBObject doc = new BasicDBObject("keyName", "test value data”); 

create_document(doc); 

} } 

Prompt: After completing the textbook reading for this module and reviewing the other resources, use the Codio editor and your choice of Python or Java to complete the following tasks in Codio. For each task, provide a text file (either a .java or .py file) of your code and screenshots of execution as evidence. 

  1. Develop a function to create a document in the MongoDB database “city” in the collection “inspections.” Be sure it can handle error conditions 

gracefully. 

  1. Input -> argument to function will be set of key/value pairs in the data type acceptable to the MongoDB driver insert API call b. return -> True if successful insert else False (require a screenshot) 2. Develop a function to read a document in the MongoDB database “city” in the collection “inspections.” Be sure it can handle error conditions gracefully. 
  2. Input -> arguments to function should be the key/value lookup pair to use with the MongoDB driver find API call b. return -> result in JSON format if successful else MongoDB returned error message 3. Develop a function to update a document in the MongoDB database “city” in the collection “inspections.” Be sure it can handle error conditions 

gracefully. 

  1. 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 set of key/value pairs in the data type acceptable to the MongoDB driver insert API call. b. return -> result in JSON format if successful else MongoDB returned error message 4. Develop a function to delete a document in the MongoDB database “city” in the collection “inspections.” Be sure it can handle error conditions 

gracefully. 

  1. Input -> arguments to function should be the key/value lookup pair to use with the MongoDB driver find API call b. return -> result in JSON format if successful else MongoDB returned error message 

Specifically, the following must be addressed in your submission: 

  • Database Create, Read, Update, and Delete Functions Using Programming Language: Use code submission and screenshots to demonstrate MongoDB interactions. 

Rubric 

Guidelines for Submission: You must submit two files for this assignment: 

  • A Microsoft Word document (or equivalent) with double spacing, 12-point Times New Roman font, one-inch margins, and the appropriate screenshots 
  • A text file (either .java or .py) containing your code 

Critical Elements Proficient (100%) Needs Improvement (75%) Not Evident (0%) Value Create Function Develops function to create a document 

in chosen programming language that both compiles successfully and contains required functionality 

Develops function to create a document in chosen programming language that may compile successfully but does not contain required functionality 

Does not develop function to create a document 

25 

Read Function Develops function to read a document 

in chosen programming language that both compiles successfully and contains required functionality 

Develops function to read a document in chosen programming language that may compile successfully but does not contain required functionality 

Does not develop function to read a document 

25 

Update Function Develops function to update a 

document in chosen programming language that both compiles successfully and contains required functionality 

Develops function to update a document in chosen programming language that may compile successfully but does not contain required functionality 

Does not develop function to update a document 

25 

Delete Function Develops function to delete a 

document in chosen programming language that both compiles successfully and contains required functionality 

Develops function to delete a document in chosen programming language that may compile successfully but does not contain required functionality 

Does not develop function to delete a document 

25 

Total 100% 

Related Questions

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

. This assignment exercises interfaces and generics. Be sure and read the assignment submission instructions provided previously. It gives you the content and format of what I expect you to post.

Assignment 8  This assignment exercises interfaces and generics. Be sure and read the assignment submission instructions provided previously. It