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
PythonDrill_PartFour_GUIprogramDB.newCharacter(name, gen, age, occ)
print PythonDrill_PartFour_GUIprogramDB.viewAll()
# Empty text boxes when finished
self.sName.Clear()
self.sGen.Clear()
self.sOcc.Clear()
self.sAge.SetValue(0)
# Update list control
self.fillListCtrl()
def fillListCtrl(self):
# Get data from the database
allData = PythonDrill_PartFour_GUIprogramDB.viewAll()
# Delete old data before adding new data
self.listCtrl.DeleteAllItems()
# Append data to the table
for row in allData:
# Loop through and append data
self.listCtrl.Append(row)
def onDelete(self, event):
# Delete the character
PythonDrill_PartFour_GUIprogramDB.deleteCharacter(self.selectedID)
# Refresh the table
self.fillListCtrl()
