예제 #1
0
 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)
예제 #2
0
 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)
예제 #3
0
 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)
예제 #4
0
 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)
예제 #5
0
 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)
예제 #6
0
 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)
예제 #7
0
 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)
예제 #8
0
 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)
예제 #9
0
 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)
예제 #10
0
 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)
예제 #11
0
 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)
예제 #12
0
 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)
예제 #13
0
    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)