Notes

Use escape characters in the below scenarios():

1. When you are using the "$" character in the command prompt terminal.


2. When trying to access nested objects in the command prompt terminal, use the escape character in front of (")


For testing, please use sample_test.sh

(Note: Sample test score will not represent the final score.)



Follow the below instructions to complete the assessment:


Step 1:

Create a database with the name Repositories and a collection with the name repo_data


Step 2:

There is a JSON file with the name repositories.json

Write a command to load the JSON data to the repo_data collection.


Once it"s done, please check whether all the rows were imported successfully.


Step 3:


{

"topic": "xml",

"name": "fedramp-automation",

"owner": "GSA",

"owner_type": "Organization",

"full_name": "GSA/fedramp-automation",

"description": "FedRAMP Automation",

"og_image": "",

"license": "Other",

"is_archived": false,

"is_forked": false,

"size": 185327,

"language": "XSLT",

"tags": ["json", "automation", "xml", "sap", "authorization", "ssp", "sar", "fedramp", "oscal", "system-security-plan", "poam", "security-assessment-plan", "security-assessment-report", "plan-of-action-and-milestones", "fedramp-baselines"],

"open_issues": 30,

"forks": 46,

"stars": 131,

"watchers": 131,

"has_wiki": true,

"has_pages": false,

"has_sponsorship": false,

"created_at": "2019-11-25T16:52:33Z",

"updated_at": "2022-04-08T20:26:31Z"

},

{

"topic": "xml",

"name": "soupsieve",

"owner": "facelessuser",

"owner_type": "User",

"full_name": "facelessuser/soupsieve",

"description": "A modern CSS selector implementation for BeautifulSoup",

"og_image": "",

"license": "MIT License",

"is_archived": false,

"is_forked": false,

"size": 5625,

"language": "Python",

"tags": ["css", "python", "html", "html5", "xml", "css-selector", "beautifulsoup", "css4", "soup-sieve"],

"open_issues": 15,

"forks": 27,

"stars": 124,

"watchers": 124,

"has_wiki": true,

"has_pages": true,

"has_sponsorship": true,

"created_at": "2018-12-07T07:42:56Z",

"updated_at": "2022-04-05T00:18:45Z"

}


Insert the above JSON data into the collection repo_data.


Step 4:

Find the owner of the repository which has maximum stars under the topic "3d"

Display the owner and stars value as "max_rating"

Note: Store the above command results in max_stars.txt

Format: (echo "use <databasename>"; echo "<query command>") | mongo > filename.txt


Step 5:

Get the count of repositories from each topic

Note: Store the above command results in count.txt

Format: (echo "use <databasename>"; echo "<query command>") | mongo > filename.txt


Step 6:

Delete the data of the repository with name "alter-core"

Update the watchers to 160 for the repository with name "glPortal"

Update the open_issues to 0 for the repository with name "exengine"


Step 7:

The size of the repositories are given in Mega bytes

Find the average of the size of each repositories and convert them to GB

(Hint: 1 GB is equal to 1024 MB)

Note: Store the above command results in size.txt

Format: (echo "use <databasename>"; echo "<query command>") | mongo > filename.txt


Step 8:

Write a command to add "deep-learning" in tags for the repository with name "probreg"


Step 9:

Create an Index owner_index in the column owner_type