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])