def delete_files_of_subrun(self, id_file_subrun): try: files_before: FilesOfSubrunDto = self.__files_by_id(id_file_subrun) if Checkers.validate_int( id_file_subrun, LstFilesOfSubrun.id_file_subrun.name ) and files_before.id_file_subrun is not None: self.__session.query(LstFilesOfSubrun).filter(LstFilesOfSubrun.id_file_subrun.like(id_file_subrun)) \ .delete(synchronize_session=False) self.__session.commit() files_after: FilesOfSubrunDto = self.__files_by_id( id_file_subrun) if files_before.id_file_subrun is not None and files_after.id_file_subrun is None: print("RECORD DELETE IN TABLE '{}' WITH ID '{}'".format( LstFilesOfSubrun.__tablename__.name, id_file_subrun)) else: print( " THE RECORD OF TABLE '{}' WITH ID '{}' HAS NOT BEEN DELETED BECAUSE IT DID NOT EXIST" .format(LstFilesOfSubrun.__tablename__.name, id_file_subrun)) else: print(" THE RECORD OF TABLE '{}' COULD NOT BE DELETED".format( LstFilesOfSubrun.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def insert_runs(self, runs_insert: RunsDto): try: runs_aux = LstRuns( run_number=runs_insert.run_number, id_run_type=runs_insert.id_run_type, date=runs_insert.date, id_config=runs_insert.id_config, id_production=runs_insert.id_production, path_file=runs_insert.path_file, init_ra=runs_insert.init_ra, end_ra=runs_insert.end_ra, init_dec=runs_insert.init_dec, end_dec=runs_insert.end_dec, init_altitude=runs_insert.init_altitude, end_altitude=runs_insert.end_altitude, init_azimuth=runs_insert.init_azimuth, end_azimuth=runs_insert.end_azimuth, init_time_collect_data=runs_insert.init_time_collect_data, end_time_collect_data=runs_insert.end_time_collect_data) self.__session.add(runs_aux) self.__session.commit() if runs_aux.id_run is not None: print("RECORD INSERTED IN TABLE '{}' WITH ID '{}'".format( LstRuns.__tablename__.name, runs_aux.id_run)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN INSERTED".format( LstRuns.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def insert_r1_data_check_plot( self, r1_data_check_plot_insert: R1DataCheckPlotDto): try: r1_data_check_plot_aux = LstR1DataCheckPlot( id_lst_r1_data_check_plot=r1_data_check_plot_insert. id_lst_r1_data_check_plot, id_r1_data_check=r1_data_check_plot_insert.id_r1_data_check, lst_r1_data_check_plot_path=r1_data_check_plot_insert. lst_r1_data_check_plot_path, lst_r1_data_check_plot_description=r1_data_check_plot_insert. lst_r1_data_check_plot_description) self.__session.add(r1_data_check_plot_aux) self.__session.commit() if r1_data_check_plot_aux.id_record is not None: print("RECORD INSERTED IN TABLE '{}' WITH ID '{}'".format( LstR1DataCheckPlot.__tablename__.name, r1_data_check_plot_aux.id_lst_r1_data_check_plot)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN INSERTED".format( LstR1DataCheckPlot.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def delete_r1_data_check_generic(self, id_r1_data_check_generic): try: r1_before: R1DataCheckGenericDto = self.get_r1_data_check_generic_by_id( id_r1_data_check_generic) if Checkers.validate_int( id_r1_data_check_generic, LstR1DataCheckGeneric.id_r1_data_check_generic.name ) and r1_before.id_r1_data_check_generic is not None: self.__session.query(LstR1DataCheckGeneric).filter( LstR1DataCheckGeneric.id_r1_data_check_generic.like(id_r1_data_check_generic)) \ .delete(synchronize_session=False) self.__session.commit() r1_after: R1DataCheckGenericDto = self.get_r1_data_check_generic_by_id( id_r1_data_check_generic) if r1_before.id_r1_data_check_generic is not None and r1_after.id_r1_data_check_generic is None: print("RECORD DELETE IN TABLE '{}' WITH ID '{}'".format( LstR1DataCheckGeneric.__tablename__.name, id_r1_data_check_generic)) else: print( " THE RECORD OF TABLE '{}' WITH ID '{}' HAS NOT BEEN DELETED BECAUSE IT DID NOT EXIST" .format(LstR1DataCheckGeneric.__tablename__.name, id_r1_data_check_generic)) else: print(" THE RECORD OF TABLE '{}' COULD NOT BE DELETED".format( LstR1DataCheckGeneric.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def insert_r1_data_check_generic( self, r1_data_check_generic_insert: R1DataCheckGenericDto): try: r1_data_check_generic_aux = LstR1DataCheckGeneric( init_event=r1_data_check_generic_insert.init_event, end_event=r1_data_check_generic_insert.end_event, init_pixel=r1_data_check_generic_insert.init_pixel, end_pixel=r1_data_check_generic_insert.end_pixel, init_sample=r1_data_check_generic_insert.init_sample, end_sample=r1_data_check_generic_insert.end_sample, init_subrun=r1_data_check_generic_insert.init_subrun, end_subrun=r1_data_check_generic_insert.end_subrun, type_of_gap_calc=r1_data_check_generic_insert.type_of_gap_calc, list_of_module_in_detail=r1_data_check_generic_insert. list_of_module_in_detail) self.__session.add(r1_data_check_generic_aux) self.__session.commit() if r1_data_check_generic_aux.id_r1_data_check_generic is not None: print("RECORD INSERTED IN TABLE '{}' WITH ID '{}'".format( LstR1DataCheckGeneric.__tablename__.name, r1_data_check_generic_aux.id_r1_data_check_generic)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN INSERTED".format( LstR1DataCheckGeneric.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def delete_by_id(self, id_to_delete): try: config_to_delete_before: ConfigurationDto = self.get_config_by_id( id_to_delete) if Checkers.validate_int( id_to_delete, LstConfiguration.id_config.name ) and config_to_delete_before.id_config is not None: self.__session.query(LstConfiguration).filter(LstConfiguration.id_config.like(id_to_delete)) \ .delete(synchronize_session=False) self.__session.commit() config_to_delete_after: ConfigurationDto = self.get_config_by_id( id_to_delete) if config_to_delete_before.id_config is not None and config_to_delete_after.id_config is None: print(" RECORD DELETED IN TABLE '{}' WITH ID '{}' ".format( LstConfiguration.__tablename__.name, id_to_delete)) else: print( " THE RECORD OF TABLE '{}' WITH ID '{}' HAS NOT BEEN DELETED BECAUSE IT DID NOT EXIST" .format(LstConfiguration.__tablename__.name, id_to_delete)) else: print(" THE RECORD OF TABLE '{}' COULD NOT BE DELETED".format( LstConfiguration.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def delete_dl1a(self, id_dl1a): try: dl1a_before: Dl1aDto = self.get_dl1a_by_id(id_dl1a) if Checkers.validate_int( id_dl1a, LstDl1a.id_dl1a) and dl1a_before.id_dl1a is not None: self.__session.query(LstDl1a).filter(LstDl1a.id_dl1a.like(id_dl1a)) \ .delete(synchronize_session=False) self.__session.commit() dl1a_after: Dl1aDto = self.get_dl1a_by_id(id_dl1a) if dl1a_before.id_dl1a is not None and dl1a_after.id_dl1a is None: print("RECORD DELETE IN TABLE '{}' WITH ID '{}'".format( LstDl1a.__tablename__.name, id_dl1a)) else: print( " THE RECORD OF TABLE '{}' WITH ID '{}' HAS NOT BEEN DELETED BECAUSE IT DID NOT EXIST" .format(LstDl1a.__tablename__.name, id_dl1a)) else: print(" THE RECORD OF TABLE '{}' COULD NOT BE DELETED".format( LstDl1a.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def insert_run_type(self, run_type_insert: RunTypeDto): try: run_type_aux = LstRunType( description_run_type=run_type_insert.description_run_type ) self.__session.add(run_type_aux) self.__session.commit() if run_type_aux.id_run_type is not None: print("RECORD INSERTED IN TABLE '{}' WITH ID '{}'".format(LstRunType.__tablename__.name, run_type_aux.id_run_type)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN INSERTED".format(LstRunType.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def insert_dates(self, dates_insert: DatesDto): try: dates_aux = LstDates(date=dates_insert.date) self.__session.add(dates_aux) self.__session.commit() if dates_aux.id_date is not None: print("RECORD INSERTED IN TABLE '{}' WITH ID '{}'".format( LstDates.__tablename__.name, dates_aux.id_date)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN INSERTED".format( LstDates.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def update_dl1a(self, id_dl1a, subrun_number=None, dl1a_path_file=None): try: dl1a_before: Dl1aDto = self.get_dl1a_by_id(id_dl1a) if Checkers.validate_int( id_dl1a, LstDl1a.id_dl1a) and dl1a_before.id_dl1a is not None: self.__session.query(LstDl1a).filter(LstDl1a.id_dl1a.like(id_dl1a)) \ .update({ LstDl1a.subrun_number: Checkers.check_field_not_null(LstDl1a.subrun_number, subrun_number), LstDl1a.dl1a_path_file: Checkers.check_field_not_null(LstDl1a.dl1a_path_file, dl1a_path_file) }, synchronize_session=False ) self.__session.commit() dl1a_after: Dl1aDto = self.get_dl1a_by_id(id_dl1a) if dl1a_before.__dict__ != dl1a_after.__dict__: print("RECORD UPDATE IN TABLE '{}' WITH ID '{}'".format( LstDl1a.__tablename__.name, id_dl1a)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN UPDATED". format(LstDl1a.__tablename__.name)) else: print(" THE RECORD OF TABLE '{}' COULD NOT BE UPDATED ".format( LstDl1a.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def update_dates(self, date_to_serach, id_date, date_to_update=None): try: date_before: DatesDto = self.get_date_by_id(id_date) if Checkers.validate_int( id_date, LstDates.id_date.name ) and Checkers.validate_datetime( date_to_serach, LstDates.date ) and date_before.id_date is not None and date_before.date is not None: self.__session.query(LstDates).filter(LstDates.date.like(date_to_serach), LstDates.id_date.like(id_date)) \ .update({ LstDates.date: Checkers.check_field_not_null(LstDates.date, date_to_update)}, synchronize_session=False ) self.__session.commit() date_after: DatesDto = self.get_date_by_id(id_date) if date_before.__dict__ != date_after.__dict__: print("RECORD UPDATE IN TABLE '{}' WITH ID '{}'".format( LstDates.__tablename__.name, id_date)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN UPDATED". format(LstDates.__tablename__.name)) else: print(" THE RECORD OF TABLE '{}' COULD NOT BE UPDATED ".format( LstDates.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def update_r1_data_check_plot(self, id_record, id_lst_r1_data_check_plot_to_search, id_lst_r1_data_check_plot_to_update=None, id_r1_data_check=None, lst_r1_data_check_plot_path=None, lst_r1_data_check_plot_description=None): try: r1_before: R1DataCheckPlotDto = self.get_r1_data_check_plot_by_id( id_lst_r1_data_check_plot_to_search) if Checkers.validate_int( id_lst_r1_data_check_plot_to_search, LstR1DataCheckPlot.id_lst_r1_data_check_plot.name ) and r1_before.id_record is not None and r1_before.id_lst_r1_data_check_plot is not None: self.__session.query(LstR1DataCheckPlot).filter(LstR1DataCheckPlot.id_record.like(id_record)) \ .filter(LstR1DataCheckPlot.id_lst_r1_data_check_plot.like(id_lst_r1_data_check_plot_to_search)) \ .update({ LstR1DataCheckPlot.id_lst_r1_data_check_plot: Checkers.check_field_not_null( LstR1DataCheckPlot.id_lst_r1_data_check_plot, id_lst_r1_data_check_plot_to_update), LstR1DataCheckPlot.id_r1_data_check: Checkers.check_field_not_null( LstR1DataCheckPlot.id_r1_data_check, id_r1_data_check), LstR1DataCheckPlot.lst_r1_data_check_plot_path: Checkers.check_field_not_null( LstR1DataCheckPlot.lst_r1_data_check_plot_path, lst_r1_data_check_plot_path), LstR1DataCheckPlot.lst_r1_data_check_plot_description: Checkers.check_field_not_null( LstR1DataCheckPlot.lst_r1_data_check_plot_description, lst_r1_data_check_plot_description) }, synchronize_session=False ) self.__session.commit() r1_after: R1DataCheckPlotDto = self.get_r1_data_check_plot_by_id( id_lst_r1_data_check_plot_to_search) if r1_before.__dict__ != r1_after.__dict__: print("RECORD UPDATE IN TABLE '{}' WITH ID '{}'".format( LstR1DataCheckPlot.__tablename__.name, id_record)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN UPDATED". format(LstR1DataCheckPlot.__tablename__.name)) else: print(" THE RECORD OF TABLE '{}' COULD NOT BE UPDATED ".format( LstR1DataCheckPlot.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def insert_dl1a(self, dl1a_insert: Dl1aDto): try: dl1a_aux = LstDl1a(subrun_number=dl1a_insert.subrun_number, dl1a_path_file=dl1a_insert.dl1a_path_file) self.__session.add(dl1a_aux) self.__session.commit() if dl1a_aux.id_dl1a is not None: print("RECORD INSERTED IN TABLE '{}' WITH ID '{}'".format( LstDl1a.__tablename__.name, dl1a_aux.id_dl1a)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN INSERTED".format( LstDl1a.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def insert_subruns(self, subruns_insert: SubrunsDto): try: subruns_aux = LstSubruns( subrun_number=subruns_insert.subrun_number, run_number=subruns_insert.run_number, id_run_type=subruns_insert.id_run_type) self.__session.add(subruns_aux) self.__session.commit() if subruns_aux.id_subrun is not None: print("RECORD INSERTED IN TABLE '{}' WITH ID '{}'".format( LstSubruns.__tablename__.name, subruns_aux.id_subrun)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN INSERTED".format( LstSubruns.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def insert_config(self, config_insert: ConfigurationDto): try: config_aux = LstConfiguration( config_description=config_insert.config_description, param_1=config_insert.param_1, param_2=config_insert.param_2, param_3=config_insert.param_3) self.__session.add(config_aux) self.__session.commit() if config_aux.id_config is not None: print(" RECORD INSERTED IN TABLE '{}' WITH ID '{}' ".format( LstConfiguration.__tablename__.name, config_aux.id_config)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN INSERTED".format( LstConfiguration.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def insert_pixel_group(self, pixel_group_insert: PixelGroupDto): try: pixel_group_aux = LstPixelGroup( pixel_group_number=pixel_group_insert.pixel_group_number, id_config=pixel_group_insert.id_config, other_data=pixel_group_insert.other_data) self.__session.add(pixel_group_aux) self.__session.commit() if pixel_group_aux.id_config is not None: print("RECORD INSERTED IN TABLE '{}' WITH ID '{}'".format( LstPixelGroup.__tablename__.name, pixel_group_aux.pixel_group_number)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN INSERTED".format( LstPixelGroup.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def get_file_subrun_by_id(self, id_file_subrun): try: self.__files_by_id: FilesOfSubrunDto = self.__session.query( LstFilesOfSubrun).filter( LstFilesOfSubrun.id_file_subrun.like( id_file_subrun)).first() if self.__files_by_id is not None: return create_files_of_subrun( self.__files_by_id.id_file_subrun, self.__files_by_id.subrun_number, self.__files_by_id.path_file, self.__files_by_id.num_events, self.__files_by_id.array_num_files) else: Checkers.print_object_filter_null( LstFilesOfSubrun.id_file_subrun, str(id_file_subrun)) return create_files_of_subrun(None, None, None, None, None) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return create_files_of_subrun(None, None, None, None, None)
def delete_pixel_info(self, pixel_id, pixel_group_number): try: pixel_info_before: PixelInformationDto = self.get_pixel_info_by_id( pixel_id, pixel_group_number) if Checkers.validate_int( pixel_id, LstPixelInformation.pixel_id.name ) and Checkers.validate_int( pixel_group_number, LstPixelInformation.pixel_group_number.name ) and pixel_info_before.pixel_id is not None and pixel_info_before.pixel_group_number is not None: self.__session.query(LstPixelInformation).filter(LstPixelInformation.pixel_id.like(pixel_id), LstPixelInformation.pixel_group_number.like( pixel_group_number)) \ .delete(synchronize_session=False) self.__session.commit() pixel_info_after: PixelInformationDto = self.get_pixel_info_by_id( pixel_id, pixel_group_number) if pixel_info_before.id_record is not None and pixel_info_after.id_record is None: print("RECORD DELETE IN TABLE '{}' WITH ID '{}'".format( LstPixelInformation.__tablename__.name, pixel_id)) else: print( " THE RECORD OF TABLE '{}' WITH ID '{}' HAS NOT BEEN DELETED BECAUSE IT DID NOT EXIST" .format(LstPixelInformation.__tablename__.name, pixel_id)) else: print(" THE RECORD OF TABLE '{}' COULD NOT BE DELETED".format( LstPixelInformation.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])
def get_all_r1_data_check_generic(self): r1_data_check_generic_dto_list = [] try: self.__all_r1_data_check_generic: List[ R1DataCheckGenericDto] = self.__session.query( LstR1DataCheckGeneric).all() if len(self.__all_r1_data_check_generic) != 0: for row in self.__all_r1_data_check_generic: r1_aux = create_r1_data_check_generic( row.id_r1_data_check_generic, row.init_event, row.end_event, row.init_pixel, row.end_pixel, row.init_sample, row.end_sample, row.init_subrun, row.end_subrun, row.type_of_gap_calc, row.list_of_module_in_detail) r1_data_check_generic_dto_list.append(r1_aux) else: Checkers.empty_list(LstR1DataCheckGeneric.__tablename__.name) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return r1_data_check_generic_dto_list
def get_pixel_group_by_id(self, pixel_group_number, id_config): try: self.__pixel_group_by_id: PixelGroupDto = self.__session.query( LstPixelGroup).filter( LstPixelGroup.id_config.like(id_config), LstPixelGroup.pixel_group_number.like( pixel_group_number)).first() if self.__pixel_group_by_id is not None: return create_pixel_group( self.__pixel_group_by_id.id_pixel_group, self.__pixel_group_by_id.pixel_group_number, self.__pixel_group_by_id.id_config, self.__pixel_group_by_id.other_data) else: Checkers.print_object_filter_null( LstPixelGroup.pixel_group_number.name + ", " + LstPixelGroup.id_config.name, str(pixel_group_number) + ", " + str(id_config)) return create_pixel_group(None, None, None, None) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return create_pixel_group(None, None, None, None)
def get_pixel_info_by_id(self, pixel_id, pixel_group_number): try: self.__pixel_info_by_id: PixelInformationDto = self.__session.query( LstPixelInformation).filter( LstPixelInformation.pixel_id.like(pixel_id), LstPixelInformation.pixel_group_number.like( pixel_group_number)).first() if self.__pixel_info_by_id is not None: return create_pixel_information( self.__pixel_info_by_id.id_record, self.__pixel_info_by_id.pixel_id, self.__pixel_info_by_id.pixel_group_number, self.__pixel_info_by_id.pixel_pos_x, self.__pixel_info_by_id.pixel_pos_y, self.__pixel_info_by_id.pixel_pos_z) else: Checkers.print_object_filter_null( LstPixelInformation.pixel_id.name + ", " + LstPixelInformation.pixel_group_number.name, str(pixel_id) + ", " + str(pixel_group_number)) return create_pixel_information(None, None, None, None, None, None) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return create_pixel_information(None, None, None, None, None, None)
def get_r1_data_check_analysis_by_id(self, id_r1_data_check): try: self.__r1_data_check_analysis_by_id: R1DataCheckAnalysisDto = self.__session.query( LstR1DataCheckAnalysis).filter( LstR1DataCheckAnalysis.id_r1_data_check.like( id_r1_data_check)).first() if self.__r1_data_check_analysis_by_id is not None: return create_r1_data_check_analysis( self.__r1_data_check_analysis_by_id.id_record, self.__r1_data_check_analysis_by_id.id_r1_data_check, self.__r1_data_check_analysis_by_id.run_number, self. __r1_data_check_analysis_by_id.id_r1_data_check_specific) else: Checkers.print_object_filter_null( LstR1DataCheckAnalysis.id_r1_data_check.name, str(id_r1_data_check)) return create_r1_data_check_analysis(None, None, None, None) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return create_r1_data_check_analysis(None, None, None, None)
def get_r1_data_check_plot_by_id(self, id_lst_r1_data_check_plot): try: self.__r1_data_check_plot_by_id: R1DataCheckPlotDto = self.__session.query( LstR1DataCheckPlot).filter( LstR1DataCheckPlot.id_lst_r1_data_check_plot.like( id_lst_r1_data_check_plot)).first() if self.__r1_data_check_plot_by_id is not None: return create_r1_data_check_plot( self.__r1_data_check_plot_by_id.id_record, self.__r1_data_check_plot_by_id.id_lst_r1_data_check_plot, self.__r1_data_check_plot_by_id.id_r1_data_check, self. __r1_data_check_plot_by_id.lst_r1_data_check_plot_path, self.__r1_data_check_plot_by_id. lst_r1_data_check_plot_description) else: Checkers.print_object_filter_null( LstR1DataCheckPlot.id_lst_r1_data_check_plot.name, str(id_lst_r1_data_check_plot)) return create_r1_data_check_plot(None, None, None, None, None) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return create_r1_data_check_plot(None, None, None, None, None)
def get_qp_data_by_id(self, id_qp_data): try: self.__qp_data_by_id: QpDataDto = self.__session.query(LstQpData).filter( LstQpData.id_qp_data.like(id_qp_data)).first() if self.__qp_data_by_id is not None: return create_qp_data( self.__qp_data_by_id.id_qp_data, self.__qp_data_by_id.pixel_id, self.__qp_data_by_id.id_dl1a, self.__qp_data_by_id.q_average, self.__qp_data_by_id.q_rms, self.__qp_data_by_id.time_average, self.__qp_data_by_id.time_rms, self.__qp_data_by_id.dl1a_check_build ) else: Checkers.print_object_filter_null(LstQpData.id_qp_data.name, str(id_qp_data)) return create_qp_data(None, None, None, None, None, None, None, None) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return create_qp_data(None, None, None, None, None, None, None, None)
def get_r1_data_check_specific_by_id(self, id_r1_data_check_specific): try: self.__r1_data_check_specific_by_id: R1DataCheckSpecificDto = self.__session.query( LstR1DataCheckSpecific).filter( LstR1DataCheckSpecific.id_r1_data_check_specific.like(id_r1_data_check_specific)).first() if self.__r1_data_check_specific_by_id is not None: return create_r1_data_check_specific( self.__r1_data_check_specific_by_id.id_r1_data_check_specific, self.__r1_data_check_specific_by_id.init_event, self.__r1_data_check_specific_by_id.end_event, self.__r1_data_check_specific_by_id.init_pixel, self.__r1_data_check_specific_by_id.end_pixel, self.__r1_data_check_specific_by_id.init_sample, self.__r1_data_check_specific_by_id.end_sample, self.__r1_data_check_specific_by_id.init_subrun, self.__r1_data_check_specific_by_id.end_subrun, self.__r1_data_check_specific_by_id.type_of_gap_calc, self.__r1_data_check_specific_by_id.list_of_module_in_detail ) else: Checkers.print_object_filter_null(LstR1DataCheckSpecific.id_r1_data_check_specific.name, str(id_r1_data_check_specific)) return create_r1_data_check_specific(None, None, None, None, None, None, None, None, None, None, None) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return create_r1_data_check_specific(None, None, None, None, None, None, None, None, None, None, None)
def get_all_qp_data(self): qp_data_dto_list = [] try: self.__all_qp_data: List[QpDataDto] = self.__session.query(LstQpData).all() if len(self.__all_qp_data) != 0: for row in self.__all_qp_data: qp_data_aux = create_qp_data( row.id_qp_data, row.pixel_id, row.id_dl1a, row.q_average, row.q_rms, row.time_average, row.time_rms, row.dl1a_check_build ) qp_data_dto_list.append(qp_data_aux) else: Checkers.empty_list(LstQpData.__tablename__.name) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return qp_data_dto_list
def get_runs_by_id(self, id_run): try: self.__runs_by_id: RunsDto = self.__session.query(LstRuns).filter( LstRuns.id_run.like(id_run)).first() if self.__runs_by_id is not None: return create_runs( self.__runs_by_id.id_run, self.__runs_by_id.run_number, self.__runs_by_id.id_run_type, self.__runs_by_id.date, self.__runs_by_id.id_config, self.__runs_by_id.id_production, self.__runs_by_id.path_file, self.__runs_by_id.init_ra, self.__runs_by_id.end_ra, self.__runs_by_id.init_dec, self.__runs_by_id.end_dec, self.__runs_by_id.init_altitude, self.__runs_by_id.end_altitude, self.__runs_by_id.init_azimuth, self.__runs_by_id.end_azimuth, self.__runs_by_id.init_time_collect_data, self.__runs_by_id.end_time_collect_data) else: Checkers.print_object_filter_null(LstRuns.id_run.name, str(id_run)) return create_runs(None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return create_runs(None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None)
def get_analysis_by_id(self, id_analysis_evaluation): try: self.__analysis_by_id: AnalysisEvaluationDto = self.__session.query( LstAnalysisEvaluation).filter( LstAnalysisEvaluation.id_analysis_evaluation.like( id_analysis_evaluation)).first() if self.__analysis_by_id is not None: return create_analysis_evaluation( self.__analysis_by_id.id_analysis_evaluation, self.__analysis_by_id.id_lst_r1_data_check_plot, self.__analysis_by_id.parameter_description, self.__analysis_by_id.parameter_value) else: Checkers.print_object_filter_null( LstAnalysisEvaluation.id_analysis_evaluation.name, str(id_analysis_evaluation)) return create_analysis_evaluation(None, None, None, None) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return create_analysis_evaluation(None, None, None, None)
def get_all_runs(self): runs__dto_list = [] try: self.__all_runs: List[RunsDto] = self.__session.query( LstRuns).all() if len(self.__all_runs) != 0: for row in self.__all_runs: run_aux = create_runs( row.id_run, row.run_number, row.id_run_type, row.date, row.id_config, row.id_production, row.path_file, row.init_ra, row.end_ra, row.init_dec, row.end_dec, row.init_altitude, row.end_altitude, row.init_azimuth, row.end_azimuth, row.init_time_collect_data, row.end_time_collect_data) runs__dto_list.append(run_aux) else: Checkers.empty_list(LstRuns.__tablename__.name) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0]) return runs__dto_list
def update_pixel_group(self, id_config, pixel_group_number_to_search, pixel_group_number_to_update=None, id_pixel_group=None, other_data=None): try: pixel_group_before: PixelGroupDto = self.__pixel_group_by_id( pixel_group_number_to_search, id_config) if Checkers.validate_int( id_config, LstPixelGroup.id_config.name ) and Checkers.validate_int( pixel_group_number_to_search, LstPixelGroup.pixel_group_number.name ) and pixel_group_before.id_config is not None and pixel_group_before.pixel_group_number is not None: self.__session.query(LstPixelGroup).filter(LstPixelGroup.id_config.like(id_config), LstPixelGroup.pixel_group_number.like( pixel_group_number_to_search)) \ .update({ LstPixelGroup.pixel_group_number_to_update: Checkers.check_field_not_null( LstPixelGroup.pixel_group_number_to_update, pixel_group_number_to_update), LstPixelGroup.id_config: Checkers.check_field_not_null(LstPixelGroup.id_config, id_config), LstPixelGroup.other_data: Checkers.check_field_not_null(LstPixelGroup.other_data, other_data) }, synchronize_session=False ) self.__session.commit() pixel_group_after: PixelGroupDto = self.get_pixel_group_by_id( pixel_group_number_to_search, id_config) if pixel_group_before.__dict__ != pixel_group_after.__dict__: print("RECORD UPDATE IN TABLE '{}' WITH ID '{}'".format( LstPixelGroup.__tablename__.name, id_pixel_group)) else: print(" THE RECORD OF TABLE '{}' HAS NOT BEEN UPDATED". format(LstPixelGroup.__tablename__.name)) else: print(" THE RECORD OF TABLE '{}' COULD NOT BE UPDATED ".format( LstPixelGroup.__tablename__.name)) except (InvalidRequestError, NameError) as error_request: Checkers.print_exception_one_param(error_request) except OperationalError as error_request2: Checkers.print_exception_two_params(error_request2.orig.args[1], error_request2.orig.args[0])