HyperionDev strives to provide internationally$-$excellent course content that helps

achieve your learning outcomes.

Think that the content of this task, or this course as a whole, can be improved? Dc

think we've done a good job?

Click here to share your thoughts anonymously.Compulsory Task

Run SQLite and use $.$read create$\_$database.sql to create a database called

HyperionDev.db$.$

Follow these steps by using

lookup.py as a template:

Create a program that allows a user to easily be able to make certain queries

in the database. When printing, only certain fields should show on console.

In addition, after each query, the user should be given the option to either

save the resulting query in XML or JSON form. The user should also be given

the option to choose their filename.

When saving to XML or JSON, all fields in the specified table should

be included in the file.

The user should be able to

View all subjects being taken by a specified student $($search by

student$\_$id$).$

On console, the subject name should only be shown

Look up an address given a first name and a surname.

Only the street name and city should be shown on the console.

List all reviews given to a student $($search by student$\_$id$).$

The completeness, efficiency, style and documentation scores

should be displayed on console, along with the review text.

List all courses being given by a specific teacher $($search by

teacher$\_$id$).$

Just the course name should be displayed on the console.

List all students who haven't completed their course.

The student number, first and last names, email addresses and

course names should be shown on the console.

List all students who have completed their course and achieved a

mark of $30$ or below.

The student number, first and last names, email addresses and

course names should be shown on the console. Their marks

should also be displayed

Loopkup.py template:

import sqlite$3$

try:

conn $=$ sqlite$3.$connect$("$HyperionDev$.$db$")$

except sqlite$3.$Error:

print$("$Please store your datebase as HyperionDev.db$")$

quit$()$

cur $=$ connect.consor$()$

def usage$\_$is$)$incorrect$($input$,$ num$\_$args$)$:

if len$($input$)!=$ num$\_$args $+1$:

print$($f$"$The $\{$input$[0]\}$ commands required $\{$num$\_$args$\}$ argument."$)$

return True

return False

def store$\_$data$\_$as$\_$json$($data$,$ filename$)$:

pass

def store$\_$data$\_$as$\_$xml$($data$,$ filename$)$:

pass

def offer$\_$to$\_$store$($data$)$:

while True:

print$("$Would you like to store this result?"$)$

choice $=$ input$("$Y$/[$N$]?$ : $").$strip$().$lower$()$

if choice $=="$y$"$:

filename $=$ input $("$Specify filename. Must end in $.$xml or $.$json"$)$

ext $=$ filename.split$(".")[-1]$

if ext $==\text{'}$xml$\text{'}$:

store$\_$data$\_$as$\_$xml$($data$,$ filename$)$

elif ext $==$ 'json':

store$\_$data$\_$as$\_$json$($data$,$ filename$)$

else:

print$("$Invalid file extension. Please use $.$xml or $.$json"$)$

elif choice $==\text{'}$n$\text{'}$:

break

else:

print$("$Invalid choice"$)$

usage $=\text{'}\text{'}\text{'}$

what would you like to do$?$

d $-$ demo

vs

la

lr

lc

lnc

lf

e

Type your option here: $\text{'}\text{'}\text{'}$

print$("$Welcome to the data querying app!"$)$

while True:

print$()$

#Get input from user

user$\_$input $=$ input$($usgausagee$).$split$("")$

print$()$

#Parse user input into command and args

command $=$ user$\_$input$[0]$

if len$($user$\_$input$)>1$:

args $=$ user$\_$input$[1$:$]$

if command $==\text{'}$d$\text{'}$:

data $=$ cur.execute$("$SELECT $*$ FROM Student"$)$

for $\_,$ firstname, surname, $\_,\_$ in data:

print$("$f$\{$firstname$\}\{$surname$\}")$

elif command $==\text{'}$vs$\text{'}$:

if usage$\_$is$\_$incorrect$($user$\_$input, $1)$:

continue

student$\_$id $=$ atgs$[0]$

data $=$ None

#Run SQL query and store in data

offer$\_$to$\_$store$($data$)$

pass

elif command $==\text{'}$la$\text{'}$: #list address by name and surname

if usage$\_$is$\_$incorrect$($user$\_$input, $1)$:

continue

student$\_$id $=$ args$[0]$

data $=$ None

#Run SQL query and store in data

offer$\_$to$\_$store$($data$)$

elif command $==\text{'}$lnc$\text{'}$: #list all students who haven't completed their course

data $=$ None

#Run SQL query and store in data

offer$\_$to$\_$store$($data$)$

pass

elif command $==\text{'}$lf$\text{'}$: #list all students who have completed their and got a mark

data $=$ None

offer$\_$to$\_$store$($data$)$

pass

elif command $==\text{'}$e$\text{'}$ #list address by name and surname

print$("$Programme exited successfully!"$)$

break

else:

print$($f$"$Incorrect command: $\text{'}\{$command$\}\text{'}")$