]

#cclist = ["2017-02-1", "2017-02-2", "2017-02-3", "2017-02-4", "FieldOff", "2017-02-5", "2017-02-6", "2017-02-7", "2017-02-8", "M2D-flip-2017-02-5"]
cclist = [
    "2017-02-1", "2017-02-2", "2017-02-3", "2017-02-4", "FieldOff",
    "2017-02-5", "2017-02-6", "2017-02-7", "2017-02-8"
]

excluded_runs = [10138, 10139]
for _RUN in range(_RUNMIN, _RUNMAX + 1):
    if _RUN in excluded_runs:
        continue
    try:
        blinfo = _BL.get_beamline_for_run(_RUN)
        ccinfo = _CC.get_coolingchannel_for_run(_RUN)
        absinfo = _CC.get_absorber_for_run(_RUN)
        if blinfo[_RUN]['daq_trigger'] != 'TOF1':
            continue
        trigs = blinfo[_RUN]['scalars']
        ntof1 = trigs['ToF1 Triggers']
        ntof2 = trigs['ToF2 Triggers']
        npart = trigs['Particle Triggers']
        bl_task_name = blinfo[_RUN]['optics']
        tstart = blinfo[_RUN]["start_time"]
        tend = blinfo[_RUN]["end_time"]
        hdiff = ((tend - tstart).seconds) * 1.0 / 3600.0
        cc_task_name = ccinfo['tag']
        abs_task_name = next(iter(absinfo))[1]
        for mag in ccinfo['magnets']:
            if mag['name'] == "FCU":
                cc_mode = mag['mode']
#from cdb import CoolingChannelSuperMouse
from cdb import CoolingChannel
from cdb import Beamline

#_TEST_CDB = "http://preprodcdb.mice.rl.ac.uk"

_R_CDB = "http://cdb.mice.rl.ac.uk"
cc = CoolingChannel(_R_CDB)

#_MASTER_CDB = "http://172.16.246.25:8080"
#cc = CoolingChannelSuperMouse(_MASTER_CDB)

bl = Beamline(_R_CDB)

#print cc, help(cc), cc.get_name(), cc.get_server_host_name(), cc.get_version()

############################################################################

#print 'List'
#rint cc.list_absorber_tags()
#print 'Get'
#print cc.get_absorber_for_tag('ABS-SOLID-EMPTY')

print 'Get CCrun'
print cc.get_coolingchannel_for_run(7929)
print 'Get Absrun'
print cc.get_absorber_for_run(7929)

#print 'Get Beamline'
#print bl.get_beamline_for_run(7929)