def addCharacter(self, event):
name = self.sName.GetValue()
gen = self.sGen.GetValue()
age = self.sAge.GetValue()
occ = self.sOcc.GetValue()
# Checking if variables have a value
if (name == '') or (gen == '') or (age == '') or (occ == ''):
# Alert user that a variable is empty
dlg = wx.MessageDialog(None, \
'Some character details are missing. Enter values in each text box.', \
'Missing Details', wx.OK)
dlg.ShowModal()
dlg.Destroy()
return False
# Adding character to database
sqprac.newCharacter(name, gen, age, occ)
print sqprac.viewAll()
# Empty text boxes when finished.
self.sName.Clear()
self.sGen.Clear()
self.sOcc.Clear()
self.sAge.SetValue(0)
self.fillListCtrl()
def fillListCtrl(self):
# Get data from the database
allData = sqprac.viewAll()
self.listCtrl.DeleteAllItems()
# Append data to the table
for row in allData:
# Loop though and append data
self.listCtrl.Append(row)
