class LstDl1a(getBase()):
__tablename__ = Table(LstTableNames.LST_DL1A,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_dl1a = Column('ID_DL1A', INTEGER, primary_key=True, nullable=False)
subrun_number = Column('SUBRUN_NUMBER', INTEGER, nullable=False)
dl1a_path_file = Column('DL1A_PATH_FILE', VARCHAR(100), nullable=True)
class LstRunType(getBase()):
__tablename__ = Table(LstTableNames.LST_RUN_TYPE,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_run_type = Column('ID_RUN_TYPE',
INTEGER,
primary_key=True,
nullable=False)
description_run_type = Column('DESCRIPTION_RUN_TYPE',
VARCHAR(45),
nullable=True)
class LstFilesOfSubrun(getBase()):
__tablename__ = Table(LstTableNames.LST_FILES_OF_SUBRUN,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_file_subrun = Column('ID_FILE_SUBRUN',
INTEGER,
primary_key=True,
nullable=False)
subrun_number = Column('SUBRUN_NUMBER', INTEGER, nullable=False)
path_file = Column('PATH_FILE', VARCHAR(100), nullable=True)
num_events = Column('NUM_EVENTS', INTEGER, nullable=True)
array_num_files = Column('ARRAY_NUM_FILES', VARCHAR(50), nullable=True)
class LstQpData(getBase()):
__tablename__ = Table(LstTableNames.LST_QP_DATA,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_qp_data = Column('ID_QP_DATA',
INTEGER,
primary_key=True,
nullable=False)
pixel_id = Column('PIXEL_ID', INTEGER, nullable=False)
id_dl1a = Column('ID_DL1A', INTEGER, nullable=False)
q_average = Column('Q_AVERAGE', FLOAT, nullable=True)
q_rms = Column('Q_RMS', FLOAT, nullable=True)
time_average = Column('TIME_AVERAGE', FLOAT, nullable=True)
time_rms = Column('TIME_RMS', FLOAT, nullable=True)
dl1a_check_build = Column('DL1A_CHECK_BUILD', INTEGER, nullable=True)
class LstAnalysisEvaluation(getBase()):
__tablename__ = Table(LstTableNames.LST_ANALYSIS_EVALUATION,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_analysis_evaluation = Column('ID_ANALYSIS_EVALUATION',
INTEGER,
primary_key=True,
nullable=False)
id_lst_r1_data_check_plot = Column('ID_LST_R1_DATA_CHECK_PLOT',
INTEGER,
nullable=False)
parameter_description = Column('PARAMETER_DESCRIPTION',
VARCHAR(30),
nullable=False)
parameter_value = Column('PARAMETER_VALUE', DOUBLE(), nullable=False)
class LstProductions(getBase()):
__tablename__ = Table(LstTableNames.LST_PRODUCTIONS,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_production = Column('ID_PRODUCTION',
INTEGER,
primary_key=True,
nullable=False)
run_number = Column('RUN_NUMBER', INTEGER, nullable=False)
id_run_type = Column('ID_RUN_TYPE', INTEGER, nullable=False)
r1_check_build = Column('R1_CHECK_BUILD', INTEGER, nullable=True)
dl1a_check_build = Column('DL1A_CHECK_BUILD', INTEGER, nullable=True)
dl1b_check_build = Column('DL1B_CHECK_BUILD', INTEGER, nullable=True)
dl2_check_build = Column('DL2_CHECK_BUILD', INTEGER, nullable=True)
number_production = Column('NUMBER_PRODUCTION', INTEGER, nullable=True)
class LstPixelGroup(getBase()):
__tablename__ = Table(LstTableNames.LST_PIXEL_GROUP,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_pixel_group = Column('ID_PIXEL_GROUP',
INTEGER,
primary_key=True,
nullable=False)
pixel_group_number = Column('PIXEL_GROUP_NUMBER',
INTEGER,
primary_key=True,
autoincrement=False,
nullable=False)
id_config = Column('ID_CONFIG',
INTEGER,
primary_key=True,
autoincrement=False,
nullable=False)
other_data = Column('OTHER_DATA', VARCHAR(50), nullable=True)
class LstR1DataCheckPlot(getBase()):
__tablename__ = Table(LstTableNames.LST_R1_DATA_CHECK_PLOT,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_record = Column('ID_RECORD',
INTEGER,
primary_key=True,
nullable=False)
id_lst_r1_data_check_plot = Column('ID_LST_R1_DATA_CHECK_PLOT',
INTEGER,
primary_key=True,
autoincrement=False,
nullable=False)
id_r1_data_check = Column('ID_R1_DATA_CHECK', INTEGER, nullable=True)
lst_r1_data_check_plot_path = Column('LST_R1_DATA_CHECK_PLOT_PATH',
VARCHAR(120),
nullable=False)
lst_r1_data_check_plot_description = Column(
'LST_R1_DATA_CHECK_PLOT_DESCRIPTION', VARCHAR(100), nullable=False)
class LstPixelInformation(getBase()):
__tablename__ = Table(LstTableNames.LST_PIXEL_INFORMATION,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_record = Column('ID_RECORD',
INTEGER,
primary_key=True,
nullable=False)
pixel_id = Column('PIXEL_ID',
INTEGER,
primary_key=True,
autoincrement=False,
nullable=False)
pixel_group_number = Column('PIXEL_GROUP_NUMBER',
INTEGER,
primary_key=True,
nullable=False)
pixel_pos_x = Column('PIXEL_POS_X', FLOAT, nullable=True)
pixel_pos_y = Column('PIXEL_POS_Y', FLOAT, nullable=True)
pixel_pos_z = Column('PIXEL_POS_Z', FLOAT, nullable=True)
class LstR1DataCheckGeneric(getBase()):
__tablename__ = Table(LstTableNames.LST_R1_DATA_CHECK_GENERIC,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_r1_data_check_generic = Column('ID_R1_DATA_CHECK_GENERIC',
INTEGER,
primary_key=True,
nullable=False)
init_event = Column('INIT_EVENT', INTEGER, nullable=True)
end_event = Column('END_EVENT', INTEGER, nullable=True)
init_pixel = Column('INIT_PIXEL', INTEGER, nullable=True)
end_pixel = Column('END_PIXEL', INTEGER, nullable=True)
init_sample = Column('INIT_SAMPLE', INTEGER, nullable=True)
end_sample = Column('END_SAMPLE', INTEGER, nullable=True)
init_subrun = Column('INIT_SUBRUN', INTEGER, nullable=True)
end_subrun = Column('END_SUB_RUN', INTEGER, nullable=True)
type_of_gap_calc = Column('TYPE_OF_GAP_CALC',
VARCHAR(50),
nullable=True)
list_of_module_in_detail = Column('LIST_OF_MODULE_IN_DETAIL',
VARCHAR(1060),
nullable=True)
from sqlalchemy import *
from config.base import getBase, getMetaData, getEngine
from utils.checkers import Checkers
from utils.table_names import LstTableNames
if Checkers.check_table_exists(getEngine(),
LstTableNames.LST_R1_DATA_CHECK_GENERIC):
class LstR1DataCheckGeneric(getBase()):
__tablename__ = Table(LstTableNames.LST_R1_DATA_CHECK_GENERIC,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_r1_data_check_generic = Column('ID_R1_DATA_CHECK_GENERIC',
INTEGER,
primary_key=True,
nullable=False)
init_event = Column('INIT_EVENT', INTEGER, nullable=True)
end_event = Column('END_EVENT', INTEGER, nullable=True)
init_pixel = Column('INIT_PIXEL', INTEGER, nullable=True)
end_pixel = Column('END_PIXEL', INTEGER, nullable=True)
init_sample = Column('INIT_SAMPLE', INTEGER, nullable=True)
end_sample = Column('END_SAMPLE', INTEGER, nullable=True)
init_subrun = Column('INIT_SUBRUN', INTEGER, nullable=True)
end_subrun = Column('END_SUB_RUN', INTEGER, nullable=True)
type_of_gap_calc = Column('TYPE_OF_GAP_CALC',
VARCHAR(50),
nullable=True)
list_of_module_in_detail = Column('LIST_OF_MODULE_IN_DETAIL',
VARCHAR(1060),
from sqlalchemy import *
from config.base import getBase, getMetaData, getEngine
from utils.checkers import Checkers
from utils.table_names import LstTableNames
if Checkers.check_table_exists(getEngine(), LstTableNames.LST_DL1A):
class LstDl1a(getBase()):
__tablename__ = Table(LstTableNames.LST_DL1A,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_dl1a = Column('ID_DL1A', INTEGER, primary_key=True, nullable=False)
subrun_number = Column('SUBRUN_NUMBER', INTEGER, nullable=False)
dl1a_path_file = Column('DL1A_PATH_FILE', VARCHAR(100), nullable=True)
from sqlalchemy import *
from config.base import getBase, getMetaData, getEngine
from utils.checkers import Checkers
from utils.table_names import LstTableNames
if Checkers.check_table_exists(getEngine(), LstTableNames.LST_RUN_TYPE):
class LstRunType(getBase()):
__tablename__ = Table(LstTableNames.LST_RUN_TYPE,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_run_type = Column('ID_RUN_TYPE',
INTEGER,
primary_key=True,
nullable=False)
description_run_type = Column('DESCRIPTION_RUN_TYPE',
VARCHAR(45),
nullable=True)
from sqlalchemy import *
from config.base import getBase, getMetaData, getEngine
from utils.checkers import Checkers
from utils.table_names import LstTableNames
if Checkers.check_table_exists(getEngine(), LstTableNames.LST_SUBRUNS):
class LstSubruns(getBase()):
__tablename__ = Table(LstTableNames.LST_SUBRUNS, getMetaData(), autoload=True, autoload_with=getEngine())
id_subrun = Column('ID_SUBRUN', INTEGER, primary_key=True, nullable=False)
subrun_number = Column('SUBRUN_NUMBER', INTEGER, primary_key=True, autoincrement=False, nullable=False)
run_number = Column('RUN_NUMBER', INTEGER, nullable=False)
id_run_type = Column('ID_RUN_TYPE', INTEGER, nullable=False)
from sqlalchemy import *
from config.base import getBase, getMetaData, getEngine
from utils.checkers import Checkers
from utils.table_names import LstTableNames
if Checkers.check_table_exists(getEngine(), LstTableNames.LST_CONFIGURATION):
class LstConfiguration(getBase()):
__tablename__ = Table(LstTableNames.LST_CONFIGURATION, getMetaData(), autoload=True, autoload_with=getEngine())
id_config = Column('ID_CONFIG', Integer, primary_key=True)
config_description = Column('CONFIG_DESCRIPTION', VARCHAR(50), nullable=True)
param_1 = Column('PARAM_1', VARCHAR(45), nullable=True)
param_2 = Column('PARAM_2', VARCHAR(45), nullable=True)
param_3 = Column('PARAM_3', VARCHAR(45), nullable=True)
class LstSubruns(getBase()):
__tablename__ = Table(LstTableNames.LST_SUBRUNS, getMetaData(), autoload=True, autoload_with=getEngine())
id_subrun = Column('ID_SUBRUN', INTEGER, primary_key=True, nullable=False)
subrun_number = Column('SUBRUN_NUMBER', INTEGER, primary_key=True, autoincrement=False, nullable=False)
run_number = Column('RUN_NUMBER', INTEGER, nullable=False)
id_run_type = Column('ID_RUN_TYPE', INTEGER, nullable=False)
from sqlalchemy import *
from config.base import getBase, getMetaData, getEngine
from utils.checkers import Checkers
from utils.table_names import LstTableNames
if Checkers.check_table_exists(getEngine(), LstTableNames.LST_FILES_OF_SUBRUN):
class LstFilesOfSubrun(getBase()):
__tablename__ = Table(LstTableNames.LST_FILES_OF_SUBRUN,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_file_subrun = Column('ID_FILE_SUBRUN',
INTEGER,
primary_key=True,
nullable=False)
subrun_number = Column('SUBRUN_NUMBER', INTEGER, nullable=False)
path_file = Column('PATH_FILE', VARCHAR(100), nullable=True)
num_events = Column('NUM_EVENTS', INTEGER, nullable=True)
array_num_files = Column('ARRAY_NUM_FILES', VARCHAR(50), nullable=True)
class LstConfiguration(getBase()):
__tablename__ = Table(LstTableNames.LST_CONFIGURATION, getMetaData(), autoload=True, autoload_with=getEngine())
id_config = Column('ID_CONFIG', Integer, primary_key=True)
config_description = Column('CONFIG_DESCRIPTION', VARCHAR(50), nullable=True)
param_1 = Column('PARAM_1', VARCHAR(45), nullable=True)
param_2 = Column('PARAM_2', VARCHAR(45), nullable=True)
param_3 = Column('PARAM_3', VARCHAR(45), nullable=True)
from sqlalchemy import *
from config.base import getBase, getMetaData, getEngine
from utils.checkers import Checkers
from utils.table_names import LstTableNames
if Checkers.check_table_exists(getEngine(), LstTableNames.LST_PIXEL_GROUP):
class LstPixelGroup(getBase()):
__tablename__ = Table(LstTableNames.LST_PIXEL_GROUP,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_pixel_group = Column('ID_PIXEL_GROUP',
INTEGER,
primary_key=True,
nullable=False)
pixel_group_number = Column('PIXEL_GROUP_NUMBER',
INTEGER,
primary_key=True,
autoincrement=False,
nullable=False)
id_config = Column('ID_CONFIG',
INTEGER,
primary_key=True,
autoincrement=False,
nullable=False)
other_data = Column('OTHER_DATA', VARCHAR(50), nullable=True)
from sqlalchemy import *
from config.base import getBase, getMetaData, getEngine
from utils.checkers import Checkers
from utils.table_names import LstTableNames
if Checkers.check_table_exists(getEngine(), LstTableNames.LST_PRODUCTIONS):
class LstProductions(getBase()):
__tablename__ = Table(LstTableNames.LST_PRODUCTIONS,
getMetaData(),
autoload=True,
autoload_with=getEngine())
id_production = Column('ID_PRODUCTION',
INTEGER,
primary_key=True,
nullable=False)
run_number = Column('RUN_NUMBER', INTEGER, nullable=False)
id_run_type = Column('ID_RUN_TYPE', INTEGER, nullable=False)
r1_check_build = Column('R1_CHECK_BUILD', INTEGER, nullable=True)
dl1a_check_build = Column('DL1A_CHECK_BUILD', INTEGER, nullable=True)
dl1b_check_build = Column('DL1B_CHECK_BUILD', INTEGER, nullable=True)
dl2_check_build = Column('DL2_CHECK_BUILD', INTEGER, nullable=True)
number_production = Column('NUMBER_PRODUCTION', INTEGER, nullable=True)
class LstDates(getBase()):
__tablename__ = Table(LstTableNames.LST_DATES, getMetaData(), autoload=True, autoload_with=getEngine())
id_date = Column('ID_DATE', INTEGER, primary_key=True, nullable=False)
date = Column('DATE', DATETIME, primary_key=True, autoincrement=False, nullable=False)
