downloadversionIRdata.py 57.8 KB
Newer Older
Holger Niemann's avatar
Holger Niemann committed
1
2
3
4
5
6
7
8
# -*- coding: utf-8 -*-
"""
Created on Wed Oct 25 15:51:46 2017

@author: holn
"""

import numpy as np
9
10
11
12
try:
    import W7Xrest.read_restdb as AKF_1
except:
    import read_restdb as AKF_1
Holger Niemann's avatar
Holger Niemann committed
13
14
15
import datetime
import urllib
import json
16
17
from PIL import Image
from io import BytesIO
18
19
20
import matplotlib.pyplot as plt
try:        
    import multiprocessing    
21
22
23
24
    try:
        import holn.archivedb as AKF_2
    except:
        import archivedb as AKF_2
25
26
27
28
    fastDL=True
except Exception as E:
    print(E)
    fastDL=False
Holger Niemann's avatar
Holger Niemann committed
29

30

Holger Niemann's avatar
Holger Niemann committed
31
32
archivepath="http://archive-webapi.ipp-hgw.mpg.de/Test/raw/W7X/"

33

34
35
36
37
38
39
40
41
42
43
44
45
46
47
portcamdict={
    'OP1.2a':{
        'AEF10': 'IRCam_Caleo768kL_0901',
        'AEF11': 'IRCam_Caleo768kL_0906',
        'AEF20': 'IRCam_Caleo768kL_0702',
        'AEF21': 'IRCam_Caleo768kL_0904',
        'AEF30': 'IRCam_Caleo768kL_0907',
        'AEF31': 'IRCam_Caleo768kL_0903',
        'AEF40': 'IRCam_Caleo768kL_0701',
        'AEF41': 'IRCam_Caleo768kL_0902',
        'AEF50': 'Infratec_9312907',
        'AEF51': 'IRCam_Caleo768kL_0905'}
    	}

48
49
50
51
52
53
54
55
try:
    config_path="\\\\sv-e4-fs-1\\E4-Mitarbeiter\\E4 Diagnostics\\QIR\\Software\\QI-RealTime\\v1.0.0\\release\\QIR-IrAnalysis\\Config\\Thermal calibration\\"
    FOV=plt.imread(config_path+portcamdict['OP1.2a']['AEF'+str(10)]+"\\"+"AEF"+str(10)+"_FOV.png")[:,:,0]   
    del FOV
except:
    config_path=""


56

57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
camlimdict={
    'IRCam_Caleo768kL_0901':
        {
        1:(50,5000),
        2:(50,3000),
        3:(50,2050),
        4:(50,1200),
        5:(50,1100),
        6:(50,850),
        7:(50,800),
        8:(50,600),
        9:(50,550)
         },
    'IRCam_Caleo768kL_0902':
        {
        1:(50,5000),
        2:(50,3000),
        3:(50,2050),
        4:(50,1200),
        5:(50,1100),
        6:(50,1000),
        7:(50,800),
        8:(50,800),
        9:(50,650)
         },
    'IRCam_Caleo768kL_0903':
        {
        1:(50,5000),
        2:(50,3000),
        3:(50,2050),
        4:(50,1200),
        5:(50,1100),
        6:(50,1000),
        7:(50,900),
        8:(50,800),
        9:(50,700)
         },
    'IRCam_Caleo768kL_0904':
        {
        1:(50,5000),
        2:(50,3000),
        3:(50,2050),
        4:(50,1200),
        5:(50,1100),
        6:(50,900),
        7:(50,800),
        8:(50,700),
        9:(50,600)
         },
    'IRCam_Caleo768kL_0905':
        {
        1:(50,5000),
        2:(50,3000),
        3:(50,2050),
        4:(50,1200),
        5:(50,1100),
        6:(50,900),
        7:(50,800),
        8:(50,700),
        9:(50,600)
         },
    'IRCam_Caleo768kL_0906':
        {
        1:(50,5000),
        2:(50,3000),
        3:(50,2050),
        4:(50,1200),
        5:(50,1000),
        6:(50,800),
        7:(50,750),
        8:(50,600),
        9:(50,550)
         },
    'IRCam_Caleo768kL_0907':
        {
        1:(50,5000),
        2:(50,3000),
        3:(50,2050),
        4:(50,1200),
        5:(50,1100),
        6:(50,90),
        7:(50,800),
        8:(50,700),
        9:(50,600)
         },
    'IRCam_Caleo768kL_0701':        
        {
        1:(50,5000),
        2:(50,3000),
        3:(50,2050),
        4:(50,1580),
        5:(50,1100),
        6:(50,900),
        7:(50,800),
        8:(50,750),
        9:(50,700)
         },
    'IRCam_Caleo768kL_0702':
        {
        1:(50,5000),
        2:(50,3000),
        3:(50,2050),
        4:(50,1580),
        5:(50,1150),
        6:(50,1000),
        7:(50,800),
        8:(50,750),
        9:(50,700)
         },
     'Infratec_9312907':
         {
             0:{
             25:(50,400),
             50:(50,300),
            100:(50,250),
            200:(50,200),
            400:(50,150),
            800:(50,100)
             },
             1:{
Holger Niemann's avatar
Holger Niemann committed
177
             25:(300,1200),
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
             50:(200,800),
            100:(150,650),
            200:(100,500),
            400:(50,400),
            800:(50,300)
             },
            2:{
             25:(200,1200),
             50:(200,1200),
            100:(200,1200),
            200:(200,1200),
            400:(200,1000),
            800:(200,700)
             },
         }
}

def get_OP_by_program(program):
    try:    
        bla=int(program.split(".")[0])
        time_ns=int(TimeToNs([bla // 10000,bla % 10000 // 100,bla % 10000 % 100],[10,0,0,0]))
        return get_OP_by_time(time_ns)
    except Exception as E:
        print(E)
        return None
    
def get_OP_by_time(time_ns):
    dateOP=datetime.datetime.utcfromtimestamp(time_ns/1e9)
    if dateOP.year==2017:
        if dateOP.month>8 and dateOP.month<12:
            return "OP1.2a"
        elif dateOP.month==8 and dateOP.day>28:
            return "OP1.2a"
        elif dateOP.month==12 and dateOP.day<8:
            return "OP1.2a"
        else:
            return None        
    elif dateOP.year==2018:
        return "OP1.2b"
    elif dateOP.year<=2016 and dateOP.year>=2015:
        if (dateOP.year==2016 and dateOP.month<=3) or (dateOP.year==2015 and dateOP.month==12):
            return "OP1.1"
        else:
            return None

223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
def get_latest_version(stream):
     """Find out latest version of given stream
     :param stream   url stream of interest
     :return int of version number of None if non-versioned or non-existing stream
     author: G. Schlisio, edit by holn
     """

     request =urllib.request.Request(archivepath + stream + "/_versions.json", headers={"Accept": "application/json"})
     try:
         response = urllib.request.urlopen(request)
         d = json.loads(response.read().decode('utf-8'))
     except urllib.error.HTTPError as ex:
         msg = ex.read()
         raise RuntimeError(msg)
     # detect unversioned or non-existing stream
     if d["versionInfo"] == []:
         return None
     versions = []
     for i in d['versionInfo']:
         versions.append(i['number'])

     return max(versions)


Holger Niemann's avatar
Holger Niemann committed
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
def TimeToNs(date,time):
    """
    TimeToNs(date,time)
    (list)  date    [year,month,day]
    (list)  time    [hours,minutes,seconds,microseconds]
    """ 
    date_time=datetime.datetime(date[0],date[1],date[2],time[0],time[1],time[2],time[3])
    div=date_time-datetime.datetime(1970,1,1,0,0,0)
    nsdate=div.total_seconds()*1e9
    return nsdate

def read_program(timestampstart,timestamp_end=0,tol=60):
    """
    read_program()
    """
    program_url = 'http://archive-webapi.ipp-hgw.mpg.de/programs.json?from'
    if timestamp_end!=0:
        jsonurl=program_url+"="+str(int(timestampstart-tol*1e9))+"&upto="+str(int(timestamp_end+tol*1e9))
    else:
        jsonurl=program_url+"="+str(int(timestampstart-tol*1e9))+"&upto="+str(int(timestampstart+tol*1e9))
    try:
        res = urllib.request.urlopen(jsonurl)
        prog_raw=res.read()
        res.close()
    except urllib.error.URLError as e:
        print('!get_program: Error opening URL')
        print(e)
        return False,0
    else:
        prog_string=prog_raw.decode(encoding='UTF-8')
        prog_list = json.loads(prog_string)
        pl=prog_list['programs'][0]
        return True, pl

def read_restdb_old(request_url):
    """
    Reads JSON data from W7-X REST API
    Returns: 
        valid: access ok
        t: numpy-array of time
        signal: numpy-array of requested signals
288
    by H. Thomsen
Holger Niemann's avatar
Holger Niemann committed
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
    """
    try:
        res = urllib.request.urlopen(request_url)
    except urllib.error.URLError as e:
        print(e)
        return False, 0, -1
    else:
        signal_raw=res.read()
        res.close()
        signal_string=signal_raw.decode(encoding='UTF-8')
        signal_list = json.loads(signal_string)
        signal0=np.array(signal_list['values'])
        t=np.array(signal_list['dimensions'])
        return True, t, signal0

304
def download_LUT(port,time,exposure=0,emissivity=0,camera_filter=0,version=0):
Holger Niemann's avatar
Holger Niemann committed
305
306
307
308
    """
    download_LUT(camera,port,time,exposure=0,emissivity=0,camera_filter=0,version=1):
        time in ns
    """    
309
    if port==50:# camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
310
311
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_LUT_"
        larchivepath=archivepath+stream#"QRT_INFRATEC/"+"AEF"+str(port)+"_LUT_"
Holger Niemann's avatar
Holger Niemann committed
312
        query="Filter_"+str(camera_filter)+"_Texp_"+str(int(exposure))+"us_e_"+str(float(emissivity))
313
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
314
315
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_LUT_"
        larchivepath=archivepath+stream
Holger Niemann's avatar
Holger Niemann committed
316
317
318
319
        query="Texp_"+str(int(exposure))+"us_e_"+str(float(emissivity))
    else:
        print("camera unknown, stopping here")
        raise Exception
320
321
    if version==0:
        version=get_latest_version(stream+"DATASTREAM")
Holger Niemann's avatar
Holger Niemann committed
322
    #time=int(fu.TimeToNs([2017,9,26],[8,0,0,0]))
323
    LUTpar=read_restdb_old(larchivepath+"PARLOG/V"+str(version)+"/_signal.json?from="+str(time-10)+"&upto="+str(time+20))
Holger Niemann's avatar
Holger Niemann committed
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
    if LUTpar[0]:
        LUTid=LUTpar[2][0]['structure'][query]
        LUTs=read_restdb_old(larchivepath+"DATASTREAM/V"+str(version)+"/_signal.json?from="+str(time-10)+"&upto="+str(time+20))
        if LUTs[0]:
            LUTs=LUTs[2][0]
            LUT=[LUTs[0],LUTs[LUTid],LUTs[LUTid+1]]
            del LUTpar, LUTs
            return True,LUT
        else:
            print("unable to download the LUTs")
            del LUTpar, LUTs
            return False,0
    else:
        del LUTpar
        print("unable to find LUTs, check your request")
        return False,0

341
def download_NUC_by_program(port,program,exposure,version=0):
Holger Niemann's avatar
Holger Niemann committed
342
343
344
345
346
347
348
349
350
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['0'][0]
        stoptime=prog[1]['trigger']['1'][0]
        return download_NUC_by_times(port,starttime,stoptime,exposure,version)
    else:
        print("cannot find the program")
        return False,0,0

351
def download_NUC_by_times(port,starttime,stoptime,exposure,version=0):
Holger Niemann's avatar
Holger Niemann committed
352
353
    larchivepath=archivepath+"QRT_IRCAM/AEF"+str(port)+"_NUC_"
#    NUC_parlog=AKF_1.read_restdb_old(archivepath+"PARLOG/V"+str(version)+"/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
354
355
    if version==0:
        version=get_latest_version("QRT_IRCAM/AEF"+str(port)+"_NUC_DATASTREAM")
Holger Niemann's avatar
Holger Niemann committed
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
    try:
        res = urllib.request.urlopen(larchivepath+"PARLOG/V"+str(version)+"/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
        signal_list = json.loads(res.read().decode('utf-8'))
        res.close()
        goon=True
    except urllib.error.URLError as e:
        print(e)
        goon=False
    if goon:        
        n=0
        nuctimes=[0]
        for NUCpar in signal_list['values']:
            if NUCpar['structure']['Texp']==exposure:
                nuctimes=[signal_list['dimensions'][2*n],signal_list['dimensions'][2*n+1]]
#                gain_i=NUCpar['structure']['gain_index']
                offset_i=NUCpar['structure']['offset_index']                
            n+=1 
        if nuctimes[0]!=0:
            NUC=AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/_signal.json?from="+str(nuctimes[0]-10)+"&upto="+str(nuctimes[1]+10))
            if NUC[0]:
                images=np.vsplit(NUC[2],np.shape(NUC[2])[0]/offset_i)                    
                return True,images,['gain','offset','cold','badpixels','gain_error','offset_error']
            else:
                print("NUC image for requested exposure time not found")
                return False, 0, 0
        else:
            print("NUC image for requested exposure time not found")
            return False,0,0
    else:
        return False,0,0
    
387
def download_background_by_program(port,program,exposure,version=0):
Holger Niemann's avatar
Holger Niemann committed
388
389
390
391
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['0'][0]
        stoptime=prog[1]['trigger']['1'][0]
392
        return download_background_by_times(port,starttime,stoptime,exposure,version)
Holger Niemann's avatar
Holger Niemann committed
393
394
395
396
    else:
        print("cannot find the program")
        return False,0,0
    
397
def download_background_by_times(port,starttime,stoptime,exposure,camera_filter=0,version=0):
398
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
399
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_background_" 
Holger Niemann's avatar
Holger Niemann committed
400
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_background_"      
401
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
402
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_background_"   
Holger Niemann's avatar
Holger Niemann committed
403
404
405
406
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_background_"   
    else:
        print("camera unknown, stopping here")
        raise Exception
407
408
    if version==0:
        version=get_latest_version(stream+"DATASTREAM")
Holger Niemann's avatar
Holger Niemann committed
409
410
411
412
413
414
415
416
417
418
419
420
421
    try:
        res = urllib.request.urlopen(larchivepath+"PARLOG/V"+str(version)+"/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
        signal_list = json.loads(res.read().decode('utf-8'))
        res.close()
        goon=True
    except urllib.error.URLError as e:
        print(e)
        goon=False
    if goon: 
        n=0
        backtimes=[0]
        for backpar in signal_list['values']:
            if backpar['structure']['Texp']==exposure:
422
                if port==50:# camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
                    if backpar['structure']['filter']==camera_filter:
                        backtimes=[signal_list['dimensions'][2*n],signal_list['dimensions'][2*n+1]]                             
                else:
                    backtimes=[signal_list['dimensions'][2*n],signal_list['dimensions'][2*n+1]]                             
            n+=1
        if backtimes[0]!=0:
            backdat=AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/_signal.json?from="+str(backtimes[0]-10)+"&upto="+str(backtimes[1]+10))
            if backdat[0]:                                    
                return backdat#[True,backdat[2]]
            else:
                print("background image for requested exposure time(, filter) not found")
                return False,0,0
        else:
            print("background image for requested exposure time(, filter) not found")
            return False,0,0
    else:
        return False,0,0

441
def download_raw_images_by_program(port,program,time_s=0,version=0):
Holger Niemann's avatar
Holger Niemann committed
442
443
444
445
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
Holger Niemann's avatar
Holger Niemann committed
446
447
448
449
450
451
        if type(time_s)==list:
            tstart=time_s[0]
            tstop=time_s[1]
            if tstop<tstart:
                raise Exception("endtime before starttime")
            return download_raw_images_by_times(port,int(starttime+tstart*1e9),int(starttime+tstop*1e9),version)
Holger Niemann's avatar
Holger Niemann committed
452
        else:
Holger Niemann's avatar
Holger Niemann committed
453
454
455
456
            if time_s==0:
                return download_raw_images_by_times(port,starttime,stoptime,version)
            else:
                return download_raw_images_by_times(port,starttime,int(starttime+time_s*1e9),version)
Holger Niemann's avatar
Holger Niemann committed
457
458
459
460
    else:
        print("cannot find the program")
        return False,0,0

461
462
def download_raw_images_by_times(port,starttime,stoptime,version=0,intervalSize=1E9):
    
463
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
464
465
        if version==0:
            version=get_latest_version("QRT_INFRATEC/"+"AEF"+str(port)+"_raw_DATASTREAM")
Holger Niemann's avatar
Holger Niemann committed
466
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_raw_DATASTREAM/V"+str(version)+"/0/raw"
467
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
468
469
        if version==0:
            version=get_latest_version("QRT_IRCAM/"+"AEF"+str(port)+"_raw_DATASTREAM")
Holger Niemann's avatar
Holger Niemann committed
470
471
472
473
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_raw_DATASTREAM/V"+str(version)+"/0/raw"
    else:
        print("camera unknown, stopping here")
        raise Exception
474
475
    if (stoptime-starttime)/intervalSize>1:        
        nrinterv=int(np.ceil((stoptime-starttime)/intervalSize))
476
        print("timewindow to large, splitting into smaller fractions ("+str(nrinterv)+")")
Holger Niemann's avatar
Holger Niemann committed
477
        intervalls=[]
478
        for i in range(nrinterv):
479
            intervalls.append(int(starttime-10+i*intervalSize))
Holger Niemann's avatar
Holger Niemann committed
480
        intervalls.append(stoptime)
481
        for i in range(nrinterv):
Holger Niemann's avatar
Holger Niemann committed
482
            try:
Holger Niemann's avatar
Holger Niemann committed
483
                res = urllib.request.urlopen(larchivepath+"/_signal.json?from="+str(intervalls[i])+"&upto="+str(intervalls[i+1]))
Holger Niemann's avatar
Holger Niemann committed
484
485
                signal_list = json.loads(res.read().decode('utf-8'))
                res.close()
486
487
488
                
                images=[np.array(ele, dtype=np.uint16) for ele in signal_list['values']]
#                signal=np.array(signal_list['values'],dtype=np.uint16)
Holger Niemann's avatar
Holger Niemann committed
489
490
491
                t=np.array(signal_list['dimensions'])
                del signal_list
                if i==0:
492
                    allimages=images.copy()
Holger Niemann's avatar
Holger Niemann committed
493
494
                    time=t
                else:
495
                    allimages=allimages+images#np.append(ressignal,signal,axis=0)
Holger Niemann's avatar
Holger Niemann committed
496
                    time=np.append(time,t)
497
                del images,t
Holger Niemann's avatar
Holger Niemann committed
498
            except urllib.error.URLError as e:
Holger Niemann's avatar
Holger Niemann committed
499
                print(e)                
500
        return True,time,allimages
Holger Niemann's avatar
Holger Niemann committed
501
502
503
504
505
    else:
        try:
            res = urllib.request.urlopen(larchivepath+"/_signal.json?from="+str(starttime-10)+"&upto="+str(stoptime))
            signal_list = json.loads(res.read().decode('utf-8'))
            res.close()
506
507
            images=[np.array(ele, dtype=np.uint16) for ele in signal_list['values']]
#            signal=np.array(signal_list['values'],dtype=np.uint16)
Holger Niemann's avatar
Holger Niemann committed
508
509
            t=np.array(signal_list['dimensions'])
            del signal_list
510
            return True, t, images
Holger Niemann's avatar
Holger Niemann committed
511
512
513
        except urllib.error.URLError as e:
            print(e)
            return False, 0,-1
514

515
if fastDL:
516
    def download_raw_images_by_program_via_png(port,program,time_s=0,version=0,threads=1):
517
518
519
520
521
522
523
524
        prog=AKF_1.get_program_from_PID(program)
        if prog[0]:
            starttime=prog[1]['trigger']['1'][0]
            stoptime=prog[1]['trigger']['6'][0]
            success=True
            OP=get_OP_by_time(starttime)
            Cam=portcamdict[OP]['AEF'+str(port)]
            if Cam.split("_")[0]=="Infratec":#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
525
526
                if version==0:
                    version=get_latest_version("QRT_INFRATEC/"+"AEF"+str(port)+"_raw_DATASTREAM")
527
528
                larchivepath="Test/raw/W7X/"+"QRT_INFRATEC/"+"AEF"+str(port)+"_raw_DATASTREAM/V"+str(version)+"/0/raw"
            elif Cam.split("_")[0]=="IRCam":#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
529
530
                if version==0:
                    version=get_latest_version("QRT_IRCAM/"+"AEF"+str(port)+"_raw_DATASTREAM")
531
532
533
                larchivepath="Test/raw/W7X/"+"QRT_IRCAM/"+"AEF"+str(port)+"_raw_DATASTREAM/V"+str(version)+"/0/raw"
            else:
                raise Exception("Port number does not fit the known cameras")
Holger Niemann's avatar
Holger Niemann committed
534
535
536
537
538
539
540
541
            if type(time_s)==list:
                tstart=time_s[0]
                tstop=time_s[1]
                if tstop<tstart:
                    raise Exception("endtime before starttime")
                stdate=datetime.datetime.utcfromtimestamp((starttime-100)/1e9+tstart)
                stdate=stdate.isoformat()
                enddate=datetime.datetime.utcfromtimestamp((starttime)/1e9+tstop)  
542
543
                enddate=enddate.isoformat()
            else:
Holger Niemann's avatar
Holger Niemann committed
544
545
546
547
548
549
550
551
                stdate=datetime.datetime.utcfromtimestamp((starttime-100)/1e9)
                stdate=stdate.isoformat()
                if time_s==0:
                    enddate=datetime.datetime.utcfromtimestamp(stoptime/1e9)        
                    enddate=enddate.isoformat()
                else:
                    enddate=datetime.datetime.utcfromtimestamp((starttime)/1e9+time_s)  
                    enddate=enddate.isoformat()
552
553
554
555
556
557
558
559
560
561
562
                #"2017-11-15 08:00:00"
            times=AKF_2.get_all_time_intervals(larchivepath,stdate.replace("T"," "),enddate.replace("T"," "))
            time=[]
            images=[]
            lnt=len(times)
            if threads==1:
                for i in range(lnt):
                    ele=times[lnt-1-i]
                    imag=download_last_raw_image_by_time(port,ele[0]-10,ele[0]+10)
                    if imag[0]:
                        time.append(ele[0])
563
                        images.append(np.array(imag[1],dtype=np.uint16))
564
565
                    else:
                        success=False
566
                return success,np.array(time),images
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
            else:
                tim=[]
                for i in range(lnt):
                    tim.append(times[lnt-1-i][0])
                intervalls=[]
                intervalSize=int(lnt/threads)
                for i in range(threads):
                    intervalls.append(int(i*intervalSize))
                intervalls.append(lnt)
                jobs = []
                out_q=multiprocessing.Queue()
                for i in range(threads):
                    print("Start Thread ",i+1)                
                    p = multiprocessing.Process(target=download_raw_images_png_by_times_thread, args=(port,tim[intervalls[i]:intervalls[i+1]],out_q,i,version,))
                    jobs.append(p)
                    p.start()
                resultdict = []
                for i in range(threads):
                    resultdict.append(out_q.get())
                for p in jobs:
                    p.join()
Holger Niemann's avatar
Holger Niemann committed
588
                print("all threads are done")
589
590
591
592
593
594
                order=[]
                for ele in resultdict:
                    order.append(ele[0])
                    if len(np.where(np.asarray(ele[1])==False)[0])>0:
                        success=False
                
595
596
597
598
599
                times=[]#np.array(resultdict[order.index(0)][2])
                images=[]#np.array(resultdict[order.index(0)][3])
                for i in range(threads):
                    images=images+resultdict[order.index(i)][3]
                    times=times+resultdict[order.index(i)][2]
600
                del resultdict
601
                return success,np.array(times),images
602
            
603
    
604
    def download_raw_images_png_by_times_thread(port,times,out_q,threadnumber,version=0):
605
606
607
608
        images=[]
        time=[]
        successes=[]
        for i in times:
609
            imag=download_last_raw_image_by_time(port,i-10,i+10,version=version)
610
            if imag[0]:
611
                images.append(np.array(imag[1],dtype=np.uint16))
612
613
614
615
616
617
618
                time.append(i)
                successes.append(True)
            else:
                successes.append(False)
        out_q.put([threadnumber,successes,time,images])        
    #    return success,np.array(time),np.array(images,dtype=np.uint16)
    
619
def download_last_raw_image_by_time(port,starttime,stoptime,version=0):
620
621
622
    OP=get_OP_by_time(starttime)
    Cam=portcamdict[OP]['AEF'+str(port)]
    if Cam.split("_")[0]=="Infratec":#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
623
624
        if version==0:
            version=get_latest_version("QRT_INFRATEC/"+"AEF"+str(port)+"_raw_DATASTREAM")
625
626
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_raw_DATASTREAM/V"+str(version)+"/0/raw"
    elif Cam.split("_")[0]=="IRCam":#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
627
628
        if version==0:
            version=get_latest_version("QRT_IRCAM/"+"AEF"+str(port)+"_raw_DATASTREAM")
629
630
631
632
633
634
635
636
637
638
639
640
641
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_raw_DATASTREAM/V"+str(version)+"/0/raw"
    else:
        raise Exception("camera unknown, stopping here")
    try:
        res = urllib.request.urlopen(larchivepath+"/_signal.png?from="+str(starttime-10)+"&upto="+str(stoptime))
        img = Image.open(BytesIO(res.read()))
        res.close()
#        pixelarray = np.array(img.getdata()).reshape(img.size[1], img.size[0])
        pixelarray = np.array(img,dtype=np.uint16)#.swapaxes(0,1)
        return True, pixelarray
    except urllib.error.URLError as e:
        print(e)
        return False, -1
Holger Niemann's avatar
Holger Niemann committed
642
    
643
def download_raw_parlog_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
644
645
646
647
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
648
        return download_raw_parlog_by_times(port,starttime,stoptime,version)    
Holger Niemann's avatar
Holger Niemann committed
649
650
651
652
    else:
        print("cannot find the program")
        return False,0,0
    
653
def download_raw_parlog_by_times(port,starttime,stoptime,version=0):
654
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
655
656
        if version==0:
            version=get_latest_version("QRT_INFRATEC/"+"AEF"+str(port)+"_raw_PARLOG")
Holger Niemann's avatar
Holger Niemann committed
657
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_raw_PARLOG/V"+str(version)
658
    elif port in [10,11,20,21,30,31,40,41,51]:#elif camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
659
660
        if version==0:
            version=get_latest_version("QRT_IRCAM/"+"AEF"+str(port)+"_raw_PARLOG")
Holger Niemann's avatar
Holger Niemann committed
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_raw_PARLOG/V"+str(version)   
    else:
        print("camera unknown, stopping here")
        raise Exception
    try:
        res = urllib.request.urlopen(larchivepath+"/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
        signal_list = json.loads(res.read().decode('utf-8'))
        res.close()
        goon=True
    except urllib.error.URLError as e:
        print(e)
        goon=False
    if goon: 
        return True, signal_list['dimensions'],signal_list['values'][0]['meta-data']
    

677
def get_INFRATEC_filter_by_program(program,version=0):
Holger Niemann's avatar
Holger Niemann committed
678
679
680
681
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
Holger Niemann's avatar
Holger Niemann committed
682
        return  get_INFRATEC_filter_by_times(starttime,stoptime,50,version)
Holger Niemann's avatar
Holger Niemann committed
683
684
685
686
    else:
        print("cannot find the program")
        return False,0,0

687
688
689
def get_INFRATEC_filter_by_times(starttime,stoptime,port=50,version=0):
    if version==0:
        version=get_latest_version("QRT_INFRATEC/"+"AEF"+str(port)+"_raw_PARLOG")
Holger Niemann's avatar
Holger Niemann committed
690
691
692
693
694
695
696
697
698
699
    larchivepath=archivepath+"QRT_INFRATEC/AEF"+str(port)+"_raw_PARLOG/V"+str(version)
    try:
        res = urllib.request.urlopen(larchivepath+"/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
        signal_list = json.loads(res.read().decode('utf-8'))
        res.close()
        goon=True
    except urllib.error.URLError as e:
        print(e)
        goon=False
    if goon: 
Holger Niemann's avatar
Holger Niemann committed
700
701
702
        return True, signal_list['dimensions'],signal_list['values'][0]['meta-data']['filter']  
    else:
        return False, 0,-1
Holger Niemann's avatar
Holger Niemann committed
703
    
704
def get_exposure_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
705
706
707
708
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
709
        return get_exposure_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
710
711
712
713
    else:
        print("cannot find the program")
        return False,0,0
        
714
def get_exposure_by_times(port,starttime,stoptime,version=0):
715
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
716
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
717
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
718
719
720
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_" 
    if version==0:
        version=get_latest_version("QRT_IRCAM/"+"AEF"+str(port)+"_meta_DATASTREAM")
Holger Niemann's avatar
Holger Niemann committed
721
722
    return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/3/exposuretime"+"/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
      
723
def get_camera_temp_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
724
725
726
727
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
728
        return get_camera_temp_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
729
730
731
732
    else:
        print("cannot find the program")
        return False,0,0
        
733
def get_camera_temp_by_times(port,starttime,stoptime,version=0):
734
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
735
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"  
Holger Niemann's avatar
Holger Niemann committed
736
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
737
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
738
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
Holger Niemann's avatar
Holger Niemann committed
739
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
740
741
742
    else:
        print("Port unknown")
        raise Exception
743
744
    if version==0:
        version=get_latest_version(stream+"DATASTREAM")
745
746
747
748
749
    dummy=AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/1/cameratemperature/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
    if dummy[0]:
        return dummy
    else:
        return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/1/cameratempetarure/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
Holger Niemann's avatar
Holger Niemann committed
750
    
751
def get_sensor_temp_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
752
753
754
755
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
756
        return get_sensor_temp_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
757
758
759
760
    else:
        print("cannot find the program")
        return False,0,0
        
761
def get_sensor_temp_by_times(port,starttime,stoptime,version=0):
762
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
763
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"
Holger Niemann's avatar
Holger Niemann committed
764
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
765
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
766
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
Holger Niemann's avatar
Holger Niemann committed
767
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
768
769
    if version==0:
        version=get_latest_version(stream+"DATASTREAM")
Holger Niemann's avatar
Holger Niemann committed
770
771
    return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/0/sensortemperature/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))

772
def get_camera_framerate_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
773
774
775
776
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
777
        return get_camera_framerate_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
778
779
780
781
    else:
        print("cannot find the program")
        return False,0,0
        
782
def get_camera_framerate_by_times(port,starttime,stoptime,version=0):
783
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
784
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
Holger Niemann's avatar
Holger Niemann committed
785
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
786
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
787
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
Holger Niemann's avatar
Holger Niemann committed
788
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
789
790
    if version==0:
        version=get_latest_version(stream+"DATASTREAM")    
Holger Niemann's avatar
Holger Niemann committed
791
792
793
    return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/2/framerate/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
    

794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
def get_average_divertor_TC_for_camtemp(port,starttime,endtime,part="all",TC=0):
    urlstart="http://archive-webapi.ipp-hgw.mpg.de/ArchiveDB/raw/W7X/CoDaStationDesc.115/"
    if port==50 or port==51:
        urlstart=urlstart+"DataModuleDesc.19471_DATASTREAM/"
    else:
        urlstart=urlstart+"DataModuleDesc.262_DATASTREAM/"
    if port %10==1:##uneven cameraport, even TC port
        portnr=port-1
        offset=(port//10-1)*32
    elif port%10==0:##even cameraport, uneven TC port
        portnr=port+1
        offset=(port//10-1)*32+16
    else:
        print("unknown port!")
        raise Exception
    if portnr==50:
        offset=0
    elif portnr==51:
        offset=16
    ext="/ActV1QRD"+str(portnr)+"CT1"
    n=0
    signal=0
    success=True
    if portnr==21:
        skip=True
        skipnr=1
    else:
        skip=False
        skipnr=0
    if part=="all":
        rs=0
        re=10
    elif part in ["h","horizontal","full h","full horizontal"]:
        rs=0
        re=7
    elif part in ["v","vertical","vertikal"]: 
        rs=7
        re=10
    elif part in ["hli","horizontal low iota"]:
833
834
        rs=0#4
        re=4#7
835
    elif part in ["hhi","horizontal high iota","high iota","hi"]:
836
837
        rs=4#0
        re=7#4
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
    elif part in [0,1,2,3,4,5,6,7,8,9,10]:
        rs=part
        re=part+1
    elif part in ["Single","s","single"]:
        rs=TC
        re=TC+1
    else:
        rs=0
        re=0
    if rs!=re:
        for i in range(rs,re,1):
            if skip and i==skipnr:
                i+=1
            url=urlstart+str(offset+i)+ext+"0"+str(i)+"_TC"+str(i%8+1)
            try:
                result=AKF_1.read_restdb(url+"/_signal.json?from="+str(starttime)+"&upto="+str(endtime))
    #                res.append(result)
                if result[0]:
                    n+=1            
                    time=result[1]
                    signal=signal+np.array(result[2])
                else:
                    time=0
                    success=False
            except Exception as E:
                print(E)        
                success=False
Holger Niemann's avatar
Holger Niemann committed
865
866
867
868
        try:
            return success,time,signal/n
        except:
            return False,0,-1
869
870
    else:
        return False,0,-1
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948

def get_TC_data_for_port_by_program(port,program,part=0,version=0):
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['0'][0]
        stoptime=prog[1]['trigger']['1'][0]
        return get_TC_data_for_port(port,starttime,stoptime,part,version)
    else:
        print("cannot find the program")
        return False,0,0
        
def get_TC_data_for_port(port,starttime,endtime,part=0,version=0):
    urlstart="http://archive-webapi.ipp-hgw.mpg.de/ArchiveDB/raw/W7X/CoDaStationDesc.115/DataModuleDesc.19471_DATASTREAM/"
    #66,67(10),72,73(20),78,79(30),84,85(40/50_2),90,91(50_1)
    TC_port={
    10:[10],
    11:[10],
    20:[20],
    21:[20],
    30:[30],
    31:[30],
    40:[10,20,30],
    41:[10,20,30],
    50:[50],
    51:[10,20,30]
    }
    TC_channel={
    10:[[66,67],["ActV1QSR10CT001","ActV1QSR10CT002"]], 
    20:[[72,73],["ActV1QSR20CT001","ActV1QSR20CT002"]],
    30:[[78,79],["ActV1QSR30CT001","ActV1QSR30CT002"]],
    50:[[90,91,84,85],["ActV1QRT50CT001","ActV1QRT50CT002","ActV1QRT50CT003","ActV1QRT50CT004"]]
    }
    n=0
    success=True
    signal=0
    time=0
    try:
        for thisport in TC_port[port]:
            thisTCchannel=TC_channel[thisport]
            if part==0:
                for chi in range(len(thisTCchannel[0])):            
                    url=urlstart+str(thisTCchannel[0][chi])+"/"+thisTCchannel[1][chi]
                    try:
                        result=AKF_1.read_restdb(url+"/_signal.json?from="+str(starttime)+"&upto="+str(endtime))
                        if result[0]:
                            n+=1            
                            time=result[1]
                            signal=signal+np.array(result[2])
                        else:                     
                            success=False
                    except Exception as E:
                        print(E)
                        success=False
                        n=1
            else:
                try:
                    url=urlstart+str(thisTCchannel[0][part-1])+"/"+thisTCchannel[1][part-1]
                    try:
                        result=AKF_1.read_restdb(url+"/_signal.json?from="+str(starttime)+"&upto="+str(endtime))
                        if result[0]:
                            n+=1            
                            time=result[1]
                            signal=signal+np.array(result[2])
                        else:                     
                            success=False
                            n=1
                    except Exception as E:
                        print(E)
                        success=False
                        n=1
                except Exception as E:
                    print(E)
                    success=False
                    n=1                    
    except:
        success=False
        n=1
    return success,time,signal/n
Holger Niemann's avatar
Holger Niemann committed
949
"""
950
end of download functions, below combination to get temperature
Holger Niemann's avatar
Holger Niemann committed
951
"""
952

953
954
955
956
957
958
959
960
961
#def apply_LUT_to_images(LUT,images):
#    LUTd={LUT[0][i]: LUT[1][i] for i in range(0, len(LUT[0]))}
#    return np.vectorize(LUTd.get)(images)

def temp_from_LUT(LUT,images):    
    return LUT[0,images]

def terror_from_LUT(LUT,images):
    return LUT[1,images]
962

963
964
965
966
def check_temperature_range(time,maxvalue_C,minvalue_C,port,exposure,cfilter=0):
    try:
        cam=portcamdict[get_OP_by_time(time)]['AEF'+str(port)]
        ranges=camlimdict[cam][exposure]
967
968
969
970
971
#        if minvalue_C>=ranges[0] and maxvalue_C<=ranges[1]:
#            return True
        if minvalue_C<ranges[0] and maxvalue_C<=ranges[1]:
            raise Exception("min value ({0:.2f}°C) is out of the valid temperature range (T>{1:.2f}°C)".format(minvalue_C,ranges[0]))
#            return False
972
        elif minvalue_C>=ranges[0] and maxvalue_C>ranges[1]:
973
974
975
976
977
            raise Exception("max value ({0:.2f}°C) is out of the valid temperature range (T<{1:.2f}°C)".format(maxvalue_C,ranges[1]))
#            return False
        elif minvalue_C<ranges[0] and maxvalue_C>ranges[1]:
            raise Exception("max and min value ({0:.2f}°C,{1:.2f}°C) is out of the valid temperature range ({2:.2f}°C<T<{3:.2f}!C)".format(maxvalue_C,minvalue_C,ranges[0],ranges[1]))
#            return False
978
    except Exception as E:
979
980
        raise Exception(E)
        
981

982
def get_temp_from_raw_by_program_V1(portnr,program,time_s=0,emi=0.8,divertorpart="all",version=0,intervalSize=1E9,give_ERROR=False):
983
    background,LUT,refT,gain,offset,badpixels,t_exp,cfilter,gain_error,offset_error=get_calib_data(portnr,program,emi,1,version)    
984
985
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
986
#        t0=prog[1]['trigger']['0'][0]
987
        t1=prog[1]['trigger']['1'][0]
988
        t6=prog[1]['trigger']['6'][0]
Holger Niemann's avatar
Holger Niemann committed
989
        starttime=t1-10
Holger Niemann's avatar
Holger Niemann committed
990
991
992
993
994
        if type(time_s)==list:
            tstart=time_s[0]
            tstop=time_s[1]
            if tstop<tstart:
                raise Exception("endtime before starttime")
995
            stoptime=int(starttime+tstop*1e9)  
Holger Niemann's avatar
Holger Niemann committed
996
            starttime=int(starttime+tstart*1e9)        
Holger Niemann's avatar
Holger Niemann committed
997
        else:
Holger Niemann's avatar
Holger Niemann committed
998
999
1000
            if time_s==0:                                
                stoptime=t6
            else:
For faster browsing, not all history is shown. View entire blame