def popup(self, item): #check for existing data and fill entries with it with OpenSession() as session: item.pesticides.query(session) if item.pesticides.data is not None: self.fill_pesticides(item.pesticides) #show the dialog and transfer input to the database if self.exec_(): with OpenSession() as session: self.create_from_input(session, item)
def populate_names(self): #populate the assay names combobox with OpenSession() as session: names = Chem_Names() names.get_names(session) self.chem_names = names.names self.entries['name_option'].populate(self.chem_names)
def save_note_click(self): if self.item.data is not None: new_note = self.ui.is_item_notePT.toPlainText() with OpenSession() as session: self.item.update(session, note=new_note) else: print("Warning: Load item data to save it's note.")
def popup(self, item): #check for existing data and fill entries with it with OpenSession() as session: item.moisture.query(session) item.density.query(session) item.avgwt.query(session) if item.moisture.data is not None: self.fill_moisture(item.moisture) if item.density.data is not None: self.fill_density(item.density) if item.avgwt.data is not None: self.fill_avgwt(item.avgwt) #show the dialog and transfer input to the database if self.exec_(): with OpenSession() as session: self.create_from_input(session, item)
def update_name_list(self, name): if name == '': return False if name not in self.chem_names: with OpenSession() as session: names = Chem_Names() names.add_name(session, name) return True
def popup(self, item, selected_assay_name): #check for existing data and fill entries with it #with OpenSession() as session: # item.assays.specific[selected_assay_name].query(session, selected_assay_name) if item.assays.specific[selected_assay_name].data is not None: self.fill_assay(item.assays.specific[selected_assay_name]) #show the dialog and transfer input to the database if self.exec_(): with OpenSession() as session: self.create_from_input(session, item, selected_assay_name)
def remove_chem_click(self): selected_chem_name = self.fetch_table_text(self.ui.is_chem_idTable, 0) if selected_chem_name is not None and selected_chem_name != '': text = "Are you sure you want to remove the selected chemical ID?" dialog = TextDialog(text) if dialog.exec_(): with OpenSession() as session: self.item.chem_ids.query(session) self.item.chem_ids.specific[selected_chem_name].\ remove(session) self.item.chem_ids.query(session) self.display.show_item(self.item)
def popup(self, item, selected_genus_species): #check for existing data and fill entries with it #with OpenSession() as session: #Idea: change specific to current, don't use dictionary to select specific things #use a select method to point to the desired one held in the plant_ids/assays #item.plant_ids.specific[selected_genus_species].select_name() #item.plant_ids.specific[selected_genus_species].query(session, selected_genus_species) if item.plant_ids.specific[selected_genus_species].data is not None: self.fill_plant(item.plant_ids.specific[selected_genus_species]) #show the dialog and transfer input to the database if self.exec_(): with OpenSession() as session: self.create_from_input(session, item, selected_genus_species)
def remove_plant_click(self): plant_names = [] plant_names.append(self.fetch_table_text(self.ui.is_plant_idTable, 0)) plant_names.append(self.fetch_table_text(self.ui.is_plant_idTable, 1)) selected_plant_name = ' '.join(plant_names) if selected_plant_name is not None and selected_plant_name != '': text = "Are you sure you want to remove the selected botanical ID?" dialog = TextDialog(text) if dialog.exec_(): with OpenSession() as session: self.item.plant_ids.query(session) self.item.plant_ids.specific[selected_plant_name].\ remove(session) self.item.plant_ids.query(session) self.display.show_item(self.item)
def select_lot(self, new_item_number, new_lot_number): """update the lot number for all associations and run a query""" self.item_number = new_item_number self.data_access_dict['item_id'] = new_item_number self.lot_number = new_lot_number self.data_access_dict['lot_number'] = new_lot_number with OpenSession() as session: self.basis_query(session) #sequester this in a function to check ids new_lot_id = self.data.id self.location.select_item_number(new_item_number) self.receiving.select_item_number(new_item_number) self.sage_data.select_item_number(new_item_number) self.chem_id_results.select_item_number(new_item_number) self.plant_id_results.select_item_number(new_item_number) self.assay_results.select_item_number(new_item_number) self.hm_result.select_item_number(new_item_number) self.allergens_result.select_item_number(new_item_number) self.pesticides_result.select_item_number(new_item_number) self.organoleptics_result.select_item_number(new_item_number) self.moisture_result.select_item_number(new_item_number) self.density_result.select_item_number(new_item_number) self.avgwt_result.select_item_number(new_item_number) self.microbes_result.select_item_number(new_item_number) self.pathogens_result.select_item_number(new_item_number) self.rancidity_result.select_item_number(new_item_number) self.location.select_lot_id(new_lot_id) self.receiving.select_lot_id(new_lot_id) self.sage_data.select_lot_id(new_lot_id) self.chem_id_results.select_lot_id(new_lot_id) self.plant_id_results.select_lot_id(new_lot_id) self.assay_results.select_lot_id(new_lot_id) self.hm_result.select_lot_id(new_lot_id) self.allergens_result.select_lot_id(new_lot_id) self.pesticides_result.select_lot_id(new_lot_id) self.organoleptics_result.select_lot_id(new_lot_id) self.moisture_result.select_lot_id(new_lot_id) self.density_result.select_lot_id(new_lot_id) self.avgwt_result.select_lot_id(new_lot_id) self.microbes_result.select_lot_id(new_lot_id) self.pathogens_result.select_lot_id(new_lot_id) self.rancidity_result.select_lot_id(new_lot_id)
def select_item_number(self, new_item_number): """update the item number for all associations and run a query""" self.item_number = new_item_number self.data_access_dict['id'] = new_item_number self.lots.select_item_number(self.item_number) self.assays.select_item_number(self.item_number) self.chem_ids.select_item_number(self.item_number) self.plant_ids.select_item_number(self.item_number) self.hm.select_item_number(self.item_number) self.pesticides.select_item_number(self.item_number) self.allergens.select_item_number(self.item_number) self.organoleptics.select_item_number(self.item_number) self.moisture.select_item_number(self.item_number) self.density.select_item_number(self.item_number) self.avgwt.select_item_number(self.item_number) self.microbes.select_item_number(self.item_number) self.pathogens.select_item_number(self.item_number) self.rancidity.select_item_number(self.item_number) with OpenSession() as session: self.query(session)
def popup(self, item): #show the dialog and transfer input to the database if self.exec_(): with OpenSession() as session: self.create_from_input(session, item)
def popup(self, item): if self.exec_(): with OpenSession() as session: self.create_from_input(session, item)
def popup(self, item): self.fill_in_item_id(item) with OpenSession() as session: if self.exec_(): self.create_from_input(session, item)