import sqlite$3$

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

print$("$Database connected."$)$

conn.execute$(\text{'}\text{'}\text{'}$CREATE TABLE IF NOT EXISTS CONTACTS

$($ID INT PRIMARY KEY NOT NULL,

NAME TEXT NOT NULL,

AGE INT NOT NULL,

ADDRESS CHAR$(50))$;$\text{'}\text{'}\text{'})$

print$("$Table created."$)$

conn.execute$("$INSERT INTO CONTACTS $($ID$,$NAME,AGE,ADDRESS$)\backslash$

VALUES $(18,$ 'Polly', $32,$ 'Seattle'$)")$;

conn.execute$("$INSERT INTO CONTACTS $($ID$,$NAME,AGE,ADDRESS$)\backslash$

VALUES $(19,$ 'Roger', $28,$ 'Bainbridge'$)")$;

conn.commit$()$

print$("$Records created."$)$

cursor $=$ conn.execute$("$SELECT $*$ from CONTACTS"$)$

for row in cursor:

print $("$ID $="+$ str$($row$[0]))$

print $("$NAME $="+$ row$[1])$

print$("$AGE $="+$ str$($row$[2]))$

print $("$ADDRESS $="+$ str$($row$[3])+"$

$")$

print $("$Records found."$)$

cursor $=$ conn.execute$("$UPDATE CONTACTS SET NAME $=$ 'Mazen' WHERE NAME $=$ 'Polly'"$)$

conn.commit$()$

cursor $=$ conn.execute$("$SELECT $*$ from CONTACTS"$)$

for row in cursor:

print $("$ID $="+$ str$($row$[0]))$

print $("$NAME $="+$ row$[1])$

print$("$AGE $="+$ str$($row$[2]))$

print $("$ADDRESS $="+$ str$($row$[3])+"$

$")$

print$("$Records updated."$)$

cursor $=$ conn.execute$("$DELETE FROM CONTACTS WHERE NAME $=$ 'Polly'"$)$

conn.commit$()$

print$("$Record deieted"$)$

conn.close$()$

Use this code to:

Create a Python script for managing a server.

Create a Python module to consume data from a public API and reformat the data to present as a web page.

Create a Python module for complex queries to a SQL or NoSQL database.

Create a Python module to search log files for selected content and to generate a report on what is discovered.