Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a script that a user is able to parse and input data from a QA CSV into a database Script will need to use

Create a script that a user is able to parse and input data from a QA CSV into a database
Script will need to use Argparse
Database will be MongoDB (but can be any other DB if you prefer) Mongo is widely used in M&E for it's ease of flexible scheme, completely versitile non-relational DB
Will input your weekly QA reports into Collection 1
Will input a mock "DB dump" which will be everyone's reports in one mega file into Collection 2(watch out! missing dates!) EG4-DBDump.xlsxDownload EG4-DBDump.xlsx
Use DB to quickly create own reports (do this programmatically)
Deliverables
1. Copy/paste code
2. Console output of all runs (each individual and then final collective QA CSV)-4 Total runs (Weekly assignment 4-7)
3. Database Answers (From "Database Calls" and done programmatically i.e python)
List all work done by Your user - from both collections(No duplicates)
All repeatable bugs- from both collections(No duplicates)
All Blocker bugs- from both collections(No duplicates)
All reports on build 3/19/2024- from both collections(No duplicates)
Report back the very 1st test case (Test #1), the middle test case (you determine that),and the final test case of your database - from collection 2
4. CSV export of user "Kevin Chaja" (use argparse to trigger code)- from collection 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions

Question

What is job description ? State the uses of job description.

Answered: 1 week ago

Question

What are the objectives of job evaluation ?

Answered: 1 week ago

Question

Write a note on job design.

Answered: 1 week ago

Question

Compute the derivative of f(x)cos(-4/5x)

Answered: 1 week ago