downloadversionIRdata.py 64.1 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
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
246
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
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
287
    by H. Thomsen
Holger Niemann's avatar
Holger Niemann committed
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
    """
    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

303
def download_LUT(port,time,exposure=0,emissivity=0,camera_filter=0,version=0):
Holger Niemann's avatar
Holger Niemann committed
304
305
306
307
    """
    download_LUT(camera,port,time,exposure=0,emissivity=0,camera_filter=0,version=1):
        time in ns
    """    
308
    if port==50:# camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
309
310
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_LUT_"
        larchivepath=archivepath+stream#"QRT_INFRATEC/"+"AEF"+str(port)+"_LUT_"
Holger Niemann's avatar
Holger Niemann committed
311
        query="Filter_"+str(camera_filter)+"_Texp_"+str(int(exposure))+"us_e_"+str(float(emissivity))
312
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
313
314
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_LUT_"
        larchivepath=archivepath+stream
Holger Niemann's avatar
Holger Niemann committed
315
316
317
318
        query="Texp_"+str(int(exposure))+"us_e_"+str(float(emissivity))
    else:
        print("camera unknown, stopping here")
        raise Exception
319
320
    if version==0:
        version=get_latest_version(stream+"DATASTREAM")
321
        print("LUT V"+str(version)+" is used")
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
    if LUTpar[0]:
        LUTid=LUTpar[2][0]['structure'][query]
326
        LUTs=read_restdb_old(larchivepath+"DATASTREAM/V"+str(version)+"/0/LUT/_signal.json?from="+str(time-10)+"&upto="+str(time+20))
Holger Niemann's avatar
Holger Niemann committed
327
        if LUTs[0]:
328
            LUTs=LUTs[2].swapaxes(1,2)[0]
Holger Niemann's avatar
Holger Niemann committed
329
330
331
332
333
334
335
336
337
338
339
340
            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
                #"2017-11-15 08:00:00"
553
            times=AKF_2.get_all_time_intervals(larchivepath,stdate.replace("T"," "),enddate.replace("T"," "))#
554
555
556
557
558
559
560
561
562
            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
                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)
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
        
    def convert_raw_to_temp_thread(port,times,out_q,threadnumber,version=0,background=0,LUT=[[],[],[]],refT=28.5,gain=0,offset=0,gain_error=0,offset_error=0,give_ERROR=False,FOV=0,badpixels=[]):
        images=[]
        time=[]
        successes=[]
        for i in times:
            imag=download_last_raw_image_by_time(port,i-10,i+10,version=version)
            if imag[0]:
                images.append(np.array(imag[1],dtype=np.uint16))
                time.append(i)
                successes.append(True)
            else:
                successes.append(False)
        if give_ERROR:
            images,error_images=apply_calib_on_raw(images,background,LUT,refT,gain,offset,gain_error,offset_error,False,give_ERROR)
        else:
            images=apply_calib_on_raw(images,background,LUT,refT,gain,offset,gain_error,offset_error,False,give_ERROR)
        
        for i in range(len(images)):
            images[i]=(images[i]*FOV).astype(np.float32)
        print(datetime.datetime.now(),"correcting bad pixels")
        images=correct_images(images,badpixels)
        out_q.put([threadnumber,successes,time,images]) 
        
642
def download_last_raw_image_by_time(port,starttime,stoptime,version=0):
643
644
645
    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":
646
647
        if version==0:
            version=get_latest_version("QRT_INFRATEC/"+"AEF"+str(port)+"_raw_DATASTREAM")
648
649
        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":
650
651
        if version==0:
            version=get_latest_version("QRT_IRCAM/"+"AEF"+str(port)+"_raw_DATASTREAM")
652
653
654
655
656
657
658
659
660
661
662
663
664
        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
665
    
666
def download_raw_parlog_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
667
668
669
670
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
671
        return download_raw_parlog_by_times(port,starttime,stoptime,version)    
Holger Niemann's avatar
Holger Niemann committed
672
673
674
675
    else:
        print("cannot find the program")
        return False,0,0
    
676
def download_raw_parlog_by_times(port,starttime,stoptime,version=0):
677
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
678
679
        if version==0:
            version=get_latest_version("QRT_INFRATEC/"+"AEF"+str(port)+"_raw_PARLOG")
Holger Niemann's avatar
Holger Niemann committed
680
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_raw_PARLOG/V"+str(version)
681
    elif port in [10,11,20,21,30,31,40,41,51]:#elif camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
682
683
        if version==0:
            version=get_latest_version("QRT_IRCAM/"+"AEF"+str(port)+"_raw_PARLOG")
Holger Niemann's avatar
Holger Niemann committed
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
        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']
    

700
def get_INFRATEC_filter_by_program(program,version=0):
Holger Niemann's avatar
Holger Niemann committed
701
702
703
704
    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
705
        return  get_INFRATEC_filter_by_times(starttime,stoptime,50,version)
Holger Niemann's avatar
Holger Niemann committed
706
707
708
709
    else:
        print("cannot find the program")
        return False,0,0

710
711
712
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
713
714
715
716
717
718
719
720
721
722
    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
723
724
725
        return True, signal_list['dimensions'],signal_list['values'][0]['meta-data']['filter']  
    else:
        return False, 0,-1
Holger Niemann's avatar
Holger Niemann committed
726
    
727
def get_exposure_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
728
729
730
731
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
732
        return get_exposure_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
733
734
735
736
    else:
        print("cannot find the program")
        return False,0,0
        
737
def get_exposure_by_times(port,starttime,stoptime,version=0):
738
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
739
740
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"   
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_meta_" 
741
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
742
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_" 
743
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
744
    if version==0:
745
        version=get_latest_version(stream+"DATASTREAM")
Holger Niemann's avatar
Holger Niemann committed
746
747
    return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/3/exposuretime"+"/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
      
748
def get_camera_temp_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
749
750
751
752
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
753
        return get_camera_temp_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
754
755
756
757
    else:
        print("cannot find the program")
        return False,0,0
        
758
def get_camera_temp_by_times(port,starttime,stoptime,version=0):
759
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
760
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"  
Holger Niemann's avatar
Holger Niemann committed
761
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
762
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
763
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
Holger Niemann's avatar
Holger Niemann committed
764
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
765
766
767
    else:
        print("Port unknown")
        raise Exception
768
769
    if version==0:
        version=get_latest_version(stream+"DATASTREAM")
770
771
772
773
774
    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
775
    
776
def get_sensor_temp_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
777
778
779
780
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
781
        return get_sensor_temp_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
782
783
784
785
    else:
        print("cannot find the program")
        return False,0,0
        
786
def get_sensor_temp_by_times(port,starttime,stoptime,version=0):
787
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
788
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"
Holger Niemann's avatar
Holger Niemann committed
789
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
790
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
791
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
Holger Niemann's avatar
Holger Niemann committed
792
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
793
794
    if version==0:
        version=get_latest_version(stream+"DATASTREAM")
Holger Niemann's avatar
Holger Niemann committed
795
796
    return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/0/sensortemperature/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))

797
def get_camera_framerate_by_program(port,program,version=0):
Holger Niemann's avatar
Holger Niemann committed
798
799
800
801
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
802
        return get_camera_framerate_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
803
804
805
806
    else:
        print("cannot find the program")
        return False,0,0
        
807
def get_camera_framerate_by_times(port,starttime,stoptime,version=0):
808
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
809
        stream="QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
Holger Niemann's avatar
Holger Niemann committed
810
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
811
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
812
        stream="QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
Holger Niemann's avatar
Holger Niemann committed
813
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
814
815
    if version==0:
        version=get_latest_version(stream+"DATASTREAM")    
Holger Niemann's avatar
Holger Niemann committed
816
817
818
    return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/2/framerate/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
    

819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
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"]:
858
859
        rs=0#4
        re=4#7
860
    elif part in ["hhi","horizontal high iota","high iota","hi"]:
861
862
        rs=4#0
        re=7#4
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
    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
890
891
892
893
        try:
            return success,time,signal/n
        except:
            return False,0,-1
894
895
    else:
        return False,0,-1
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
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973

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
974
"""
975
end of download functions, below combination to get temperature
Holger Niemann's avatar
Holger Niemann committed
976
"""
977

978
979
980
981
982
983
984
985
986
#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]
987

988
989
990
def check_temperature_range(time,maxvalue_C,minvalue_C,port,exposure,cfilter=0):
    try:
        cam=portcamdict[get_OP_by_time(time)]['AEF'+str(port)]
991
992
993
994
        if port==50:
            ranges=camlimdict[cam][cfilter][exposure]
        else:
            ranges=camlimdict[cam][exposure]
995
996
997
998
999
#        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
1000
        elif minvalue_C>=ranges[0] and maxvalue_C>ranges[1]:
For faster browsing, not all history is shown. View entire blame