def saveNewItem(self): postoffice = self.ui.comboBox.itemData(self.ui.comboBox.currentIndex()) if postoffice != None: SqlHandler.addItem( self.session, SqlHandler.PostNumber(postoffice.id, self.ui.lineEdit.text())) self.parent().setPostNumber(self.ui.lineEdit.text()) self.closeDialog()
def init(status): if not status: session = SqlHandler.newSession() SqlHandler.addItems(session,[SqlHandler.ALV(alv=24,alv_class=1), #Normal items SqlHandler.ALV(alv=10,alv_class=2), #Medicines SqlHandler.ALV(alv=14,alv_class=3)]) #Feed SqlHandler.addItems(session, [SqlHandler.GlobalVar(key="clinicpayment", value="20.00"), SqlHandler.GlobalVar(key="km_price", value="0.48")]) #create species koira = SqlHandler.Specie('Koira') kissa = SqlHandler.Specie('Kissa') hevonen = SqlHandler.Specie('Hevonen') #add species SqlHandler.addItems(session, [koira, kissa, hevonen]) item_list = [] dogs_file_name = "koirarodut.txt" cats_file_name = "kissarodut.txt" horse_file_name = "hevosrodut.txt" try: f = open(dogs_file_name, "r", encoding="utf-8") for race_name in f.readlines(): item_list.append(SqlHandler.Race(race_name.strip(),koira.id)) f.close() except IOError: print("Can not find file named: " + dogs_file_name) pass try: f = open(cats_file_name, "r", encoding="utf-8") for race_name in f.readlines(): item_list.append(SqlHandler.Race(race_name.strip(),kissa.id)) f.close() except IOError: print("Can not find file named: "+ cats_file_name) pass try: f = open(horse_file_name, "r", encoding="utf-8") for race_name in f.readlines(): item_list.append(SqlHandler.Race(race_name.strip(),hevonen.id)) f.close() except IOError: print("Can not find file named: "+ cats_file_name) pass SqlHandler.addItems(session,item_list) try: f = open('postinumerot.txt', "r", encoding="utf-8") raw_p_data = f.readlines() offices = [] offices_dict = {} for line in raw_p_data: if len(line) > 1: office = SqlHandler.PostOffice(line.split(' ')[0]) offices.append(office) offices_dict[line.split(' ')[0]] = office; SqlHandler.addItems(session,offices) numbers = [] for line in raw_p_data: if len(line) > 1: for item in line.split(' ')[1].strip().split(','): numbers.append(SqlHandler.PostNumber(offices_dict[line.split(' ')[0]].id, int(item))) SqlHandler.addItems(session,numbers) f.close() except IOError: print("Can not find file named: "+ cats_file_name) pass