downloadversionIRdata.py 63.3 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
import W7Xrest.read_restdb as AKF_1
Holger Niemann's avatar
Holger Niemann committed
10
11
12
import datetime
import urllib
import json
13
14
15
16
import holn.archivedb as AKF_2
from PIL import Image
from io import BytesIO
import multiprocessing
Holger Niemann's avatar
Holger Niemann committed
17
18
19

archivepath="http://archive-webapi.ipp-hgw.mpg.de/Test/raw/W7X/"

20
21
22
23
24
25
26
27
28
29
30
31
32
33
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'}
    	}

34
35
config_path="\\\\sv-e4-fs-1\\E4-Mitarbeiter\\E4 Diagnostics\\QIR\\Software\\QI-RealTime\\v1.0.0\\release\\QIR-IrAnalysis\\Config\\Thermal calibration\\"

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
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
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
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:{
             25:(300,12000),
             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

Holger Niemann's avatar
Holger Niemann committed
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
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
    by Thomsen
    """
    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

259
def download_LUT(port,time,exposure=0,emissivity=0,camera_filter=0,version=1):
Holger Niemann's avatar
Holger Niemann committed
260
261
262
263
    """
    download_LUT(camera,port,time,exposure=0,emissivity=0,camera_filter=0,version=1):
        time in ns
    """    
264
    if port==50:# camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
265
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_LUT_"
Holger Niemann's avatar
Holger Niemann committed
266
        query="Filter_"+str(camera_filter)+"_Texp_"+str(int(exposure))+"us_e_"+str(float(emissivity))
267
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
Holger Niemann's avatar
Holger Niemann committed
268
269
270
271
272
273
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_LUT_"
        query="Texp_"+str(int(exposure))+"us_e_"+str(float(emissivity))
    else:
        print("camera unknown, stopping here")
        raise Exception
    #time=int(fu.TimeToNs([2017,9,26],[8,0,0,0]))
274
    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
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
    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

def download_NUC_by_program(port,program,exposure,version=1):
    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

def download_NUC_by_times(port,starttime,stoptime,exposure,version=1):
    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))
    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
    
336
def download_background_by_program(port,program,exposure,version=1):
Holger Niemann's avatar
Holger Niemann committed
337
338
339
340
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['0'][0]
        stoptime=prog[1]['trigger']['1'][0]
341
        return download_background_by_times(port,starttime,stoptime,exposure,version)
Holger Niemann's avatar
Holger Niemann committed
342
343
344
345
    else:
        print("cannot find the program")
        return False,0,0
    
346
347
def download_background_by_times(port,starttime,stoptime,exposure,camera_filter=0,version=1):
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
348
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_background_"      
349
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
Holger Niemann's avatar
Holger Niemann committed
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_background_"   
    else:
        print("camera unknown, stopping here")
        raise Exception
    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:
367
                if port==50:# camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
                    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

386
def download_raw_images_by_program(port,program,time_s=0,version=1):
Holger Niemann's avatar
Holger Niemann committed
387
388
389
390
391
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
        if time_s==0:
392
            return download_raw_images_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
393
        else:
394
            return download_raw_images_by_times(port,starttime,int(starttime+time_s*1e9),version)
Holger Niemann's avatar
Holger Niemann committed
395
396
397
398
    else:
        print("cannot find the program")
        return False,0,0

399
def download_raw_images_by_times(port,starttime,stoptime,version=1,intervalSize=1E9):
400
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
401
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_raw_DATASTREAM/V"+str(version)+"/0/raw"
402
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
Holger Niemann's avatar
Holger Niemann committed
403
404
405
406
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_raw_DATASTREAM/V"+str(version)+"/0/raw"
    else:
        print("camera unknown, stopping here")
        raise Exception
407
408
    if (stoptime-starttime)/intervalSize>1:        
        nrinterv=int(np.ceil((stoptime-starttime)/intervalSize))
409
        print("timewindow to large, putting it into smaller fractions ("+str(nrinterv)+")")
Holger Niemann's avatar
Holger Niemann committed
410
        intervalls=[]
411
        for i in range(nrinterv):
412
            intervalls.append(int(starttime-10+i*intervalSize))
Holger Niemann's avatar
Holger Niemann committed
413
        intervalls.append(stoptime)
414
        for i in range(nrinterv):
Holger Niemann's avatar
Holger Niemann committed
415
            try:
Holger Niemann's avatar
Holger Niemann committed
416
                res = urllib.request.urlopen(larchivepath+"/_signal.json?from="+str(intervalls[i])+"&upto="+str(intervalls[i+1]))
Holger Niemann's avatar
Holger Niemann committed
417
418
419
420
421
422
423
424
425
                signal_list = json.loads(res.read().decode('utf-8'))
                res.close()
                signal=np.array(signal_list['values'],dtype=np.uint16)
                t=np.array(signal_list['dimensions'])
                del signal_list
                if i==0:
                    ressignal=signal
                    time=t
                else:
426
                    ressignal=np.append(ressignal,signal,axis=0)
Holger Niemann's avatar
Holger Niemann committed
427
428
429
                    time=np.append(time,t)
                del signal,t
            except urllib.error.URLError as e:
Holger Niemann's avatar
Holger Niemann committed
430
                print(e)                
Holger Niemann's avatar
Holger Niemann committed
431
432
433
434
435
436
437
438
439
440
441
442
443
        return True,time,ressignal
    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()
            signal=np.array(signal_list['values'],dtype=np.uint16)
            t=np.array(signal_list['dimensions'])
            del signal_list
            return True, t, signal
        except urllib.error.URLError as e:
            print(e)
            return False, 0,-1
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552


def download_raw_images_by_program_via_png(port,program,time_s=0,version=1,threads=1):
    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":
            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":
            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")
        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()
            #"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])
                    images.append(imag[1])
                else:
                    success=False
            return success,np.array(time),np.array(images,dtype=np.uint16)
        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()
            order=[]
            for ele in resultdict:
                order.append(ele[0])
                if len(np.where(np.asarray(ele[1])==False)[0])>0:
                    success=False
            
            times=np.array(resultdict[order.index(0)][2])
            images=np.array(resultdict[order.index(0)][3])
            for i in range(threads-1):
                images=np.append(images,resultdict[order.index(i+1)][3],axis=0)
                times=np.append(times,resultdict[order.index(i+1)][2])
            del resultdict
            return success,times,images
        

def download_raw_images_png_by_times_thread(port,times,out_q,threadnumber,version=1):
    images=[]
    time=[]
    successes=[]
    for i in times:
        imag=download_last_raw_image_by_time(port,i-10,i+10)
        if imag[0]:
            images.append(imag[1])
            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)

def download_last_raw_image_by_time(port,starttime,stoptime,version=1):
    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":
        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":
        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
553
    
554
def download_raw_parlog_by_program(port,program,version=1):
Holger Niemann's avatar
Holger Niemann committed
555
556
557
558
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
559
        return download_raw_parlog_by_times(port,starttime,stoptime,version)    
Holger Niemann's avatar
Holger Niemann committed
560
561
562
563
    else:
        print("cannot find the program")
        return False,0,0
    
564
565
def download_raw_parlog_by_times(port,starttime,stoptime,version=1):
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
566
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_raw_PARLOG/V"+str(version)
567
    elif port in [10,11,20,21,30,31,40,41,51]:#elif camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
Holger Niemann's avatar
Holger Niemann committed
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
        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']
    

def get_INFRATEC_filter_by_program(program,version=1):
    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
589
        return  get_INFRATEC_filter_by_times(starttime,stoptime,50,version)
Holger Niemann's avatar
Holger Niemann committed
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
    else:
        print("cannot find the program")
        return False,0,0

def get_INFRATEC_filter_by_times(starttime,stoptime,port=50,version=1):
    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
605
606
607
        return True, signal_list['dimensions'],signal_list['values'][0]['meta-data']['filter']  
    else:
        return False, 0,-1
Holger Niemann's avatar
Holger Niemann committed
608
    
609
def get_exposure_by_program(port,program,version=1):
Holger Niemann's avatar
Holger Niemann committed
610
611
612
613
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
614
        return get_exposure_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
615
616
617
618
    else:
        print("cannot find the program")
        return False,0,0
        
619
def get_exposure_by_times(port,starttime,stoptime,version=1):
620
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
621
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
622
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
Holger Niemann's avatar
Holger Niemann committed
623
624
625
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"   
    return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/3/exposuretime"+"/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
      
626
def get_camera_temp_by_program(port,program,version=1):
Holger Niemann's avatar
Holger Niemann committed
627
628
629
630
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
631
        return get_camera_temp_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
632
633
634
635
    else:
        print("cannot find the program")
        return False,0,0
        
636
637
def get_camera_temp_by_times(port,starttime,stoptime,version=1):
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
638
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
639
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
Holger Niemann's avatar
Holger Niemann committed
640
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
641
642
643
    else:
        print("Port unknown")
        raise Exception
644
645
646
647
648
    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
649
    
650
def get_sensor_temp_by_program(port,program,version=1):
Holger Niemann's avatar
Holger Niemann committed
651
652
653
654
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
655
        return get_sensor_temp_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
656
657
658
659
    else:
        print("cannot find the program")
        return False,0,0
        
660
def get_sensor_temp_by_times(port,starttime,stoptime,version=1):
661
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
662
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
663
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
Holger Niemann's avatar
Holger Niemann committed
664
665
666
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
    return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/0/sensortemperature/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))

667
def get_camera_framerate_by_program(port,program,version=1):
Holger Niemann's avatar
Holger Niemann committed
668
669
670
671
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        starttime=prog[1]['trigger']['1'][0]
        stoptime=prog[1]['trigger']['6'][0]
672
        return get_camera_framerate_by_times(port,starttime,stoptime,version)
Holger Niemann's avatar
Holger Niemann committed
673
674
675
676
    else:
        print("cannot find the program")
        return False,0,0
        
677
678
def get_camera_framerate_by_times(port,starttime,stoptime,version=1):
    if port==50:#camera=="INFRATEC" or camera=="infratec" or camera=="Infratec":
Holger Niemann's avatar
Holger Niemann committed
679
        larchivepath=archivepath+"QRT_INFRATEC/"+"AEF"+str(port)+"_meta_"      
680
    elif port in [10,11,20,21,30,31,40,41,51]:#camera=="IRCAM" or camera=="IRcam" or camera=="ircam":
Holger Niemann's avatar
Holger Niemann committed
681
682
683
684
        larchivepath=archivepath+"QRT_IRCAM/"+"AEF"+str(port)+"_meta_"
    return AKF_1.read_restdb(larchivepath+"DATASTREAM/V"+str(version)+"/2/framerate/_signal.json?from="+str(starttime)+"&upto="+str(stoptime))
    

685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
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"]:
724
725
        rs=0#4
        re=4#7
726
    elif part in ["hhi","horizontal high iota","high iota","hi"]:
727
728
        rs=4#0
        re=7#4
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
    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
756
757
758
759
        try:
            return success,time,signal/n
        except:
            return False,0,-1
760
761
    else:
        return False,0,-1
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
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
833
834
835
836
837
838
839

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
840
"""
841
end of download functions, below combination to get temperature
Holger Niemann's avatar
Holger Niemann committed
842
"""
843
844
845
846
847

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)

848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
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]
        if minvalue_C>=ranges[0] and maxvalue_C<=ranges[1]:
            return True
        elif minvalue_C<ranges[0] and maxvalue_C<=ranges[1]:
            print("min value ({0:.2f}°C) is out of the valid temperature range (T>{1:.2f}°C)".format(minvalue_C,ranges[0]))
            return False
        elif minvalue_C>=ranges[0] and maxvalue_C>ranges[1]:
            print("max value ({0:.2f}°C) is out of the valid temperature range (T<{1:.2f}°C)".format(maxvalue_C,ranges[1]))
            return False
        else:
            print("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
    except Exception as E:
        print(E)
        return False

867
def get_temp_from_raw_by_program_V1(portnr,program,time_s=0,emi=0.8,divertorpart="all",version=1,intervalSize=1E9):
868
869
870
871
872
873
874
875
876
877
    if portnr==50:
        cf=get_INFRATEC_filter_by_program(program,version)
        if cf[0]:
            cfilter=cf[2]
        else:
            cfilter=-1
            print("Filter not found for INFRATEC Camera")
            raise Exception
    else:
        cfilter=0
878
879
880
881
    prog=AKF_1.get_program_from_PID(program)
    if prog[0]:
        t0=prog[1]['trigger']['0'][0]
        t1=prog[1]['trigger']['1'][0]
882
        t6=prog[1]['trigger']['6'][0]
Holger Niemann's avatar
Holger Niemann committed
883
884
885
886
887
        starttime=t1-10
        if time_s==0:                                
            stoptime=t6
        else:
            stoptime=int(starttime+time_s*1e9)
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
        expoDL=get_exposure_by_times(portnr,t1,t6,version)
        if expoDL[0]:
            t_exp=expoDL[2][0]
            del expoDL
            time=int(TimeToNs([2017,9,26],[8,0,0,0]))   
            LUT_DL=download_LUT(portnr,time,t_exp,emi,cfilter,version)
            if LUT_DL[0]:
                LUT=LUT_DL[1]
                del LUT_DL
                back_dl=download_background_by_times(portnr,t0,t1,t_exp,version)
                if back_dl[0]:
                    background=back_dl[2]
    #                background=background.swapaxes(0,1)
                    backtime=back_dl[1]
                    backtime=backtime.tolist()
Holger Niemann's avatar
Holger Niemann committed
903
                    TCT_dl=get_average_divertor_TC_for_camtemp(portnr,int(backtime-2e9),int(backtime+2e9),divertorpart)
904
905
                    if TCT_dl[0]:
                        TCT=np.average(TCT_dl[2])
906
                    else:
Holger Niemann's avatar
Holger Niemann committed
907
908
909
910
911
912
                        TCT_dl=get_average_divertor_TC_for_camtemp(portnr,int(backtime-6e9),int(backtime+6e9),divertorpart)
                        if TCT_dl[0]:
                            TCT=np.average(TCT_dl[2])
                        else:
                            print("loading TC data was not successfull")
                            TCT=0
913
                    del back_dl
Holger Niemann's avatar
Holger Niemann committed
914
                    success=True
915
916
917
918
919
920
921
922
923
924
                    if portnr!=50:
                        #tempcalc for the IRCAMs
                        NUC_DL=download_NUC_by_times(portnr,t0,t1,t_exp,version)
                        if NUC_DL[0]==False:
                            print("NUC was not found")
                            return False,0,-1
                            raise Exception
                        else:
                            gain=NUC_DL[1][0]
                            offset=NUC_DL[1][1]
Holger Niemann's avatar
Holger Niemann committed
925
                            
926
                            print(datetime.datetime.now(),"Start download of raw images")
Holger Niemann's avatar
Holger Niemann committed
927
                            
928
929
                            if (stoptime-starttime)/intervalSize>1:        
                                nrinterv=int(np.ceil((stoptime-starttime)/intervalSize))
930
                                print("timewindow to large, putting it into smaller fractions ("+str(nrinterv)+")")
931
932
933
934
935
936
                                intervalls=[]
                                for i in range(nrinterv):
                                    intervalls.append(int(starttime-10+i*intervalSize))
                                intervalls.append(stoptime)
                                
                                for i in range(nrinterv):                            
Holger Niemann's avatar
Holger Niemann committed
937
                                    raw_dl=download_raw_images_by_times(portnr,intervalls[i],intervalls[i+1],version,intervalSize)
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
                                    print(datetime.datetime.now(),"download of raw images part "+str(i+1)+" of "+str(nrinterv)+" finished")
                                    if raw_dl[0]:
                                        time=raw_dl[1]
                                        images=raw_dl[2]
            #                            del raw_dl
                                        images=images.swapaxes(1,2)
                                        images=images[:]*gain
                                        images=images[:]+offset
                                        images=images[:]-background
                                        images=images.clip(min=0)
                                        images=np.array(images,dtype=np.uint16)
                                        images=apply_LUT_to_images(LUT,images)
                                        images=images+(TCT+273.15)
                                        if i==0:
                                            temperatureimages=images
                                            times=time
Holger Niemann's avatar
Holger Niemann committed
954
                                            del time,images
955
                                        else:
Holger Niemann's avatar
Holger Niemann committed
956
                                            temperatureimages=np.append(temperatureimages,images,axis=0)
Holger Niemann's avatar
Holger Niemann committed
957
958
                                            times=np.append(times,time)                                        
                                            del time,images
959
960
961
                                    else:
                                        print("cannot download the raw images")
                                        success=False
962
                                        times=[0]
Holger Niemann's avatar
Holger Niemann committed
963
                                        temperatureimages=-1
964
                            else:
Holger Niemann's avatar
Holger Niemann committed
965
                                raw_dl=download_raw_images_by_times(portnr,starttime,stoptime,version,intervalSize)
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
                                if raw_dl[0]:
                                    times=raw_dl[1]
                                    temperatureimages=raw_dl[2]
        #                            del raw_dl
                                    temperatureimages=temperatureimages.swapaxes(1,2)
                                    temperatureimages=temperatureimages[:]*gain
                                    temperatureimages=temperatureimages[:]+offset
                                    temperatureimages=temperatureimages[:]-background
                                    temperatureimages=temperatureimages.clip(min=0)
                                    temperatureimages=np.array(temperatureimages,dtype=np.uint16)
                                    temperatureimages=apply_LUT_to_images(LUT,temperatureimages)
                                    temperatureimages=temperatureimages+(TCT+273.15)                                    
                                else:
                                    print("cannot download the raw images")
                                    success=False
981
982
983
984
                                    times=[0]
                                    temperatureimages=[-1]
                            valid=check_temperature_range(times[0],np.max(temperatureimages)-273.15,np.min(temperatureimages)-273.15,portnr,t_exp,cfilter)
                            return success,times,temperatureimages,valid
985
986
                    else:
                        #tempcalc for infratec
Holger Niemann's avatar
Holger Niemann committed
987
988
                        print(datetime.datetime.now(),"Start download of raw images")                        
#                        print(datetime.datetime.now(),"download of raw images finished")
989
990
                        if (stoptime-starttime)/intervalSize>1:    
                            nrinterv=int(np.ceil((stoptime-starttime)/intervalSize))
991
                            print("timewindow to large, putting it into smaller fractions ("+str(nrinterv)+")")
992
993
994
995
996
997
                            intervalls=[]
                            for i in range(nrinterv):
                                intervalls.append(int(starttime-10+i*intervalSize))
                            intervalls.append(stoptime)
                            
                            for i in range(nrinterv):                            
Holger Niemann's avatar
Holger Niemann committed
998
                                raw_dl=download_raw_images_by_times(portnr,intervalls[i],intervalls[i+1],version,intervalSize)
999
1000
                                print(datetime.datetime.now(),"download of raw images part "+str(i+1)+" of "+str(nrinterv)+" finished")
                                if raw_dl[0]:
For faster browsing, not all history is shown. View entire blame