Python project. Идеи проекта

#!/usr/bin/env python3
import sys
from PyQt5.Qt import *
import sqlite3
#from pysqlcipher import dbapi2 as sqlite
    
class View(QMainWindow):
    def __init__(self,parent=None):
        QMainWindow.__init__(self,parent)
        self.dbname = ''
        self.connect = None
        self.view = QTextEdit()
        self.view.setReadOnly(True)
        self.box = QComboBox()
        self.box.setEditable(True)
        self.box.currentIndexChanged.connect(self.on_query)
        self.btnOpen = QPushButton("Open")
        self.btnOpen.clicked.connect(self.dbopen)
        self.lbl = QLabel()
        self.statusBar().addWidget(self.lbl)
        w = QWidget()
        grid = QGridLayout(w)
        grid.setContentsMargins(1,1,1,1)
        grid.addWidget(self.view,0,0,10,10)
        grid.addWidget(self.box,10,0,1,9)
        grid.addWidget(self.btnOpen,10,9,1,1)
        self.setCentralWidget(w)
        
    def dbopen(self,dbname=None):
        dbname = QFileDialog.getOpenFileName(self,"Open database",self.dbname,"*.db *.sql *.sqlite")
        if not dbname: return
        self.dbname = dbname[0]
        self.connect = sqlite3.connect(self.dbname)
        self.box.clear()
        self.box.addItem("select sql from sqlite_master")
 
    def on_query(self):
        query = self.box.lineEdit().text()
        if not query:
            self.message('?')
            return
        c = self.connect.cursor()
        try:
            c.execute(query)
        except Exception as e:
            self.message(e)
        else:
            s = '<table  border="1" width="100%">'
            try:
                s += '<tr>'
                for i in c.description: s += '<th>' + str(i[0]) + '</th>'
                s += '</tr>'
            except Exception as e:
                self.message(e) 
            data = c.fetchall()
            for i in data:
                s += '<tr>'
                for j in i: s +='<td align=center>' + str(j) + '</td>'
                s += '</tr>'
            s += '</table>'            
            self.view.setText(s)
            self.lbl.clear();
        self.connect.commit()
        c.close()
        
    def message(self,msg):
       self.lbl.setText('<b><font color="red">'+ str(msg) + '</b>')
        
    def closeEvent(self,event):
        try:
            self.connect.close()
        except Exception as e:
            self.message(e)
        event.accept()
        
    
if __name__=="__main__":
    app = QApplication([])
    app.lastWindowClosed.connect(sys.exit)
    v = View()
    v.setFont(QFont("times",16))
    v.resize(640,480)
    v.move(0,0)
    v.show()
    app.exec_()