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_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_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)
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_INFORMATION): 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)
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)
def getBase2(name): if Checkers.check_table_exists(getEngine(), name): return declarative_base()
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_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)
from sqlalchemy import * from sqlalchemy.dialects.mysql import DOUBLE 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_ANALYSIS_EVALUATION): 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)
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)
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)