def saveTradableGoodType(self): ''' Saves newly created data to database ''' # get the data entered by user mytradablegood = self.txtTradableGoodType.text() mymeasuringunit = self.txtTradableGoodMeasuringUnit.text() # check if record exists query = '''SELECT tradablegoodtype, unitofmeasure FROM setup_tradablegoods WHERE tradablegoodtype='%s' ''' % (mytradablegood) p = GenericDBOP(query) recordset = p.runSelectQuery() numrows = 0 for row in recordset: numrows = numrows + 1 if numrows == 0: query = '''INSERT INTO setup_tradablegoods(tradablegoodtype, unitofmeasure) VALUES('%s','%s')''' % (mytradablegood, mymeasuringunit) else: query = '''UPDATE setup_tradablegoods SET tradablegoodtype='%s', unitofmeasure='%s' WHERE tradablegoodtype='%s' ''' % (mytradablegood, mymeasuringunit, mytradablegood) # execute query and commit changes temp = GenericDBOP(query) recordset = temp.runUpdateQuery()
def deleteTradableGoodType(self): ''' Deletes record from database ''' # get the data entered by user mytradablegood = self.txtTradableGoodType.text() # check if record exists query = '''SELECT tradablegoodtype, unitofmeasure FROM setup_tradablegoods WHERE tradablegoodtype='%s' ''' % (mytradablegood) p = GenericDBOP(query) recordset = p.runSelectQuery() numrows = 0 for row in recordset: numrows = numrows + 1 if numrows <> 0: query = '''DELETE FROM setup_tradablegoods WHERE tradablegoodtype='%s' ''' % (mytradablegood) # execute query and commit changes temp = GenericDBOP(query) recordset = temp.runUpdateQuery() #self.cmbKCalories.clear() #refresh categories list self.getAssetCategories() else: QMessageBox.information(self, 'Delete TradableGood Type', "Record not found")