web2py-service/modules/config.py

config_adei_servers = [
    {
        'server_key': 'katrin',
        'db_host': 'katrin.kit.edu/adei-detector',
        'db_server': 'detector',
        'db_name': 'katrin'
    },
    {
        'server_key': 'aircoils',
        'db_host': 'katrin.kit.edu/adei-detector',
        'db_server': 'aircoils',
        'db_name': 'aircoils'

    }
]

sql_databases = [
    {
        'name': 'orca',
        'host': 'mysql://status:status@192.168.32.181',
        'database': 'orca',
        'sensor_groups': ['runs', 'machines', 'experiment'] ,
        'field_ignore': [
            'machines.password', 'experiment.ratesstr',
        ],
        'field_type_fix': {
            'experiment.ratesstr': 'text',
            'experiment.totalCountsstr': 'text',
            'experiment.thresholdsstr': 'text',
            'experiment.gainsstr': 'text'
        },
        'selector': {
            'all': [{},{}],
            'last': [{-1},{}]
        },
        'disabled': True
    },
    {
        'key': 'heads',
        'host': 'mysql://cube:cube@miaopdv.ipe.kit.edu',
        'db': 'HEADS',
        'modules': 'Data_(?P<mod_mark>\d{3})_\w+',
        'axislist': 'Axislist',
        'sensorlist': 'Sensorlist',
        'views': {
            'test1': 
                [ 'Data_011_EBM1_DAR.INK_G_INKW_AVG',    
                  'Data_011_EBM1_DAR.OMB_N_N_002_AVG',
                  'Data_011_EBM1_DAR.SMT_M_SOIL_002_AVG',
                  'Data_011_EBM1_DAS1.SHF_F_SHF_002_INST',
                  'Data_080_RPG_L1B.L1B_AZIMUTH_ANGLE' ]
        }
        # 'tables': 'Data_\d{3}_\w+'
    }
]

for i, r in enumerate(sql_databases):
    if 'tables' not in r.keys():
        r['tables'] = []
    if 'field_ignore' not in r.keys():
        r['field_ignore'] = []
    if 'field_type_fix' not in r.keys():
        r['field_type_fix'] = {}
    if 'disabled' not in r.keys():
        r['disabled'] = False
    sql_databases[i].update(r)