class DBapp(QtGui.QDialog): def __init__(self,dbname,parent=None): QtGui.QDialog.__init__(self,parent) self.ui = Ui_Dialog() self.ui.setupUi(self) print "connecting",dbname self.db = sqlite3.connect(dbname) # done in designer so commented out #QtCore.QObject.connect(self.ui.insertButton, #QtCore.SIGNAL("clicked()"), self.insertitem) #QtCore.QObject.connect(self.ui.searchButton, #QtCore.SIGNAL("clicked()"), self.searchitem) self.ui.status.setText('') def insertitem(self): (a,b,c)=(str(self.ui.username.text()), str(self.ui.fullname.text()), str(self.ui.password.text())) print "inserting ", a,b,c try: self.db.execute("""insert into user values (?,?,?)""", (a,b,c)) self.ui.status.setText("Insertion successful") except sqlite3.Error, e: self.ui.status.setText("DB error: " + e.args[0]) self.db.commit()
def __init__(self,dbname,parent=None): QtGui.QDialog.__init__(self,parent) self.ui = Ui_Dialog() self.ui.setupUi(self) print "connecting",dbname self.db = sqlite3.connect(dbname) # done in designer so commented out #QtCore.QObject.connect(self.ui.insertButton, #QtCore.SIGNAL("clicked()"), self.insertitem) #QtCore.QObject.connect(self.ui.searchButton, #QtCore.SIGNAL("clicked()"), self.searchitem) self.ui.status.setText('')