from io import BytesIOimport sqlite3import pandas as pdimport osimport picklesqliteConnection = Noneclass student:def __init__(self,first,last):self.first = firstself.last = lastdef to_bytes(self):import picklereturn pickle.dumps(self) def convert2Blog(filename):with open(filename, 'rb') as file:blobData = file.read()return blobDatadef connect(dbname):global sqliteConnectiontry:sqliteConnection = sqlite3.connect(dbname)cursor = sqliteConnection.cursor()print("Database created and Successfully Connected to SQLite")select_Query = "select sqlite_version();"print("Search query: ",select_Query)cursor.execute(select_Query)record = cursor.fetchall()print("SQLite Database Version is: ", record)except sqlite3.Error as error:print("Error while connecting to sqlite", error)def deleteRecord(id):global sqliteConnectiontry:cursor = sqliteConnection.cursor()delete_query = "DELETE from Database where id = "+str(id)print("Delete query: ",delete_query)cursor.execute(delete_query)sqliteConnection.commit()print("Record deleted successfully ")except sqlite3.Error as error:print("Failed to delete record from sqlite table", error)def Search(value):global sqliteConnectioncursor = sqliteConnection.cursor()sel = 'SELECT id FROM Database WHERE name == "{0}"'.format(value)print("Search query: ",sel)cursor.execute(sel)result = cursor.fetchall()return resultdef insert(query,tup):global sqliteConnectiontry:cursor = sqliteConnection.cursor()cursor.execute(query, tup)print("Search query: ",query)sqliteConnection.commit()print("Inserted successfully into table")except sqlite3.Error as error:print("Failed to insert: ", error)def readTable():global sqliteConnectionrecords = Nonetry:cursor = sqliteConnection.cursor()sqlite_select_query = """SELECT * from Database"""print("Search query: ",sqlite_select_query)cursor.execute(sqlite_select_query)records = cursor.fetchall()print("Total rows are: ", len(records))except sqlite3.Error as error:print("Failed to read data from sqlite table", error)return recordsdef table(query):global sqliteConnectiontry:cursor = sqliteConnection.cursor()cursor.execute(query)print("Table query: ",query)sqliteConnection.commit()print("SQLite table created") except sqlite3.Error as error:print("Table exists: ", error)def update(id, htext):try:cursor = sqliteConnection.cursor()update_query = """Update Database set html = ? where id = ?"""data = (htext, id)cursor.execute(update_query, data)print("Update query: ",update_query)sqliteConnection.commit()print("Record Updated successfully")except sqlite3.Error as error:print("Failed to update sqlite table", error)def dbTest(): #connectdatabase = "CIS41b_.db" connect(database)#tabletable_query = '''CREATE TABLE Database (id INTEGER PRIMARY KEY,name TEXT NOT NULL,photo text NOT NULL UNIQUE,html text NOT NULL UNIQUE)'''#columns = collections.nametuple('columns', ['id','name','photo','html'])table(table_query)#insertinsert_query = """INSERT INTO Database (id, name, photo, html) VALUES (?, ?, ?, ?)"""data_t = (1, "Temperature", convert2Blog("Temperature.png"),convert2Blog("Temperature.html"))insert(insert_query,data_t)data_t = (2, "CO2", convert2Blog("CO2.png"), convert2Blog("CO2.html"))insert(insert_query,data_t)data_t = (3, "Temperature", convert2Blog("SeaLevel.png"), convert2Blog("SeaLevel.csv"))insert(insert_query,data_t)dframe = pd.DataFrame([1,2,3,4])data_t = (4, "DataFrame", convert2Blog("Dataframe.jpg"), dframe.to_json())insert(insert_query,data_t)mad = student("Newman","Alfred")bmad = mad.to_bytes()print(mad.__class__)print(type(bmad))data_t = (5, "Alfred Newman", convert2Blog("Alfred.png"), bmad)insert(insert_query,data_t)mad = pickle.loads(bmad)print(type(mad))#readrecords = readTable()[print(r) for r in records]#searchrecord = Search("CO2")[print(r) for r in record]#updateupdate(2, "OS.html")#deletedeleteRecord(2)#shut-downsqliteConnection.close()os.remove(database)#dbTest() Please convert this file into class Database: class Database: def __init__(self): self.db = sqliteConnection() ...

Question

from io import BytesIOimport sqlite3import pandas as pdimport osimport picklesqliteConnection = Noneclass student:def __init__(self,first,last):self.first = firstself.last = lastdef to_bytes(self):import picklereturn pickle.dumps(self) def convert2Blog(filename):with open(filename, 'rb') as file:blobData = file.read()return blobDatadef connect(dbname):global sqliteConnectiontry:sqliteConnection = sqlite3.connect(dbname)cursor = sqliteConnection.cursor()print(&#34;Database created and Successfully Connected to SQLite&#34;)select_Query = &#34;select sqlite_version();&#34;print(&#34;Search query: &#34;,select_Query)cursor.execute(select_Query)record = cursor.fetchall()print(&#34;SQLite Database Version is: &#34;, record)except sqlite3.Error as error:print(&#34;Error while connecting to sqlite&#34;, error)def deleteRecord(id):global sqliteConnectiontry:cursor = sqliteConnection.cursor()delete_query = &#34;DELETE from Database where id = &#34;+str(id)print(&#34;Delete query: &#34;,delete_query)cursor.execute(delete_query)sqliteConnection.commit()print(&#34;Record deleted successfully &#34;)except sqlite3.Error as error:print(&#34;Failed to delete record from sqlite table&#34;, error)def Search(value):global sqliteConnectioncursor = sqliteConnection.cursor()sel = 'SELECT id FROM Database WHERE name == &#34;{0}&#34;'.format(value)print(&#34;Search query: &#34;,sel)cursor.execute(sel)result = cursor.fetchall()return resultdef insert(query,tup):global sqliteConnectiontry:cursor = sqliteConnection.cursor()cursor.execute(query, tup)print(&#34;Search query: &#34;,query)sqliteConnection.commit()print(&#34;Inserted successfully into table&#34;)except sqlite3.Error as error:print(&#34;Failed to insert: &#34;, error)def readTable():global sqliteConnectionrecords = Nonetry:cursor = sqliteConnection.cursor()sqlite_select_query = &#34;&#34;&#34;SELECT * from Database&#34;&#34;&#34;print(&#34;Search query: &#34;,sqlite_select_query)cursor.execute(sqlite_select_query)records = cursor.fetchall()print(&#34;Total rows are: &#34;, len(records))except sqlite3.Error as error:print(&#34;Failed to read data from sqlite table&#34;, error)return recordsdef table(query):global sqliteConnectiontry:cursor = sqliteConnection.cursor()cursor.execute(query)print(&#34;Table query: &#34;,query)sqliteConnection.commit()print(&#34;SQLite table created&#34;) except sqlite3.Error as error:print(&#34;Table exists: &#34;, error)def update(id, htext):try:cursor = sqliteConnection.cursor()update_query = &#34;&#34;&#34;Update Database set html = ? where id = ?&#34;&#34;&#34;data = (htext, id)cursor.execute(update_query, data)print(&#34;Update query: &#34;,update_query)sqliteConnection.commit()print(&#34;Record Updated successfully&#34;)except sqlite3.Error as error:print(&#34;Failed to update sqlite table&#34;, error)def dbTest(): #connectdatabase = &#34;CIS41b_.db&#34; connect(database)#tabletable_query = '''CREATE TABLE Database (id INTEGER PRIMARY KEY,name TEXT NOT NULL,photo text NOT NULL UNIQUE,html text NOT NULL UNIQUE)'''#columns = collections.nametuple('columns', ['id','name','photo','html'])table(table_query)#insertinsert_query = &#34;&#34;&#34;INSERT INTO Database (id, name, photo, html) VALUES (?, ?, ?, ?)&#34;&#34;&#34;data_t = (1, &#34;Temperature&#34;, convert2Blog(&#34;Temperature.png&#34;),convert2Blog(&#34;Temperature.html&#34;))insert(insert_query,data_t)data_t = (2, &#34;CO2&#34;, convert2Blog(&#34;CO2.png&#34;), convert2Blog(&#34;CO2.html&#34;))insert(insert_query,data_t)data_t = (3, &#34;Temperature&#34;, convert2Blog(&#34;SeaLevel.png&#34;), convert2Blog(&#34;SeaLevel.csv&#34;))insert(insert_query,data_t)dframe = pd.DataFrame([1,2,3,4])data_t = (4, &#34;DataFrame&#34;, convert2Blog(&#34;Dataframe.jpg&#34;), dframe.to_json())insert(insert_query,data_t)mad = student(&#34;Newman&#34;,&#34;Alfred&#34;)bmad = mad.to_bytes()print(mad.__class__)print(type(bmad))data_t = (5, &#34;Alfred Newman&#34;, convert2Blog(&#34;Alfred.png&#34;), bmad)insert(insert_query,data_t)mad = pickle.loads(bmad)print(type(mad))#readrecords = readTable()[print(r) for r in records]#searchrecord = Search(&#34;CO2&#34;)[print(r) for r in record]#updateupdate(2, &#34;OS.html&#34;)#deletedeleteRecord(2)#shut-downsqliteConnection.close()os.remove(database)#dbTest() Please convert this file into class Database:  class Database:        def __init__(self):            self.db = sqliteConnection()            ...

Accepted Answer

Below is the Database class converted from the given code: