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('')
