Blame view

src/common/models.py 32.4 KB
ddf59dd4   haribo   Remaniement :
1
2
from __future__ import unicode_literals

53787d30   Jeremy   Alert now inherit...
3
from django.contrib.auth.models import AbstractUser
3df2d31a   haribo   #3430 : dates are...
4
5
from django.db import models

ddf59dd4   haribo   Remaniement :
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
class Album(models.Model):
    sequence = models.ForeignKey(
        'Sequence', on_delete=models.CASCADE, related_name="albums")
    detector = models.ForeignKey(
        'Detector', models.DO_NOTHING, related_name="albums", blank=True, null=True)
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    complete = models.BooleanField(default=False)

    class Meta:
        managed = True
        db_table = 'album'

    def __str__(self):
        return (str(self.name))


ddf59dd4   haribo   Remaniement :
25
26
27
28
29
30
31
32
33
34
35
36
37
class Country(models.Model):
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    quota = models.FloatField(blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'country'
        verbose_name_plural = "Countries"

    def __str__(self):
        return (str(self.name))

ce470283   Jeremy   Plc simulator fin...
38

abfb02e2   Jeremy   Device Model is n...
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
class Device(models.Model):
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    is_online = models.BooleanField(default=False)
    status = models.CharField(max_length=11, blank=True, null=True)
    maintenance_date = models.DateTimeField(blank=True, null=True)

    class Meta:
        abstract = True

    def __str__(self):
        return (str(self.name))

6c2793c2   jeremy   Update
54
class PlcDeviceStatus(models.Model):
9f3db1a3   Quentin Durand   plc_mode in progr...
55
    device = models.ForeignKey('PlcDevice', on_delete=models.CASCADE, related_name='current_status')
6973f7df   Quentin Durand   PLC STATE + MODE
56
    created = models.DateTimeField(auto_now_add=True, editable=False, blank=True)
6c2793c2   jeremy   Update
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
    outside_temp = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    outside_temp_unit = models.CharField(max_length=45, blank=True, null=True)
    outside_humidity = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    outside_humidity_unit = models.CharField(max_length=45, blank=True, null=True)
    pressure = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    pressure_unit = models.CharField(max_length=45, blank=True, null=True)
    rain_rate = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    rain_rate_unit = models.CharField(max_length=45, blank=True, null=True)
    wind_speed = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    wind_speed_unit = models.CharField(max_length=45, blank=True, null=True)
    wind_dir = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    wind_dir_unit = models.CharField(max_length=45, blank=True, null=True)
    dew_point = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    dew_point_unit = models.CharField(max_length=45, blank=True, null=True)
    analog = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    analog_unit = models.CharField(max_length=45, blank=True, null=True)
    digital = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    digital_unit = models.CharField(max_length=45, blank=True, null=True)
    inside_temp = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    inside_temp_unit = models.CharField(max_length=45, blank=True, null=True)
    inside_humidity = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    inside_humidity_unit = models.CharField(max_length=45, blank=True, null=True)
fe5613f5   jeremy   Update plc protocol
79
    wind_dir_cardinal = models.CharField(max_length=45, blank=True, null=True)
6c2793c2   jeremy   Update
80
81
82
83
84
85
86
87
    wind_dir_cardinal_unit = models.CharField(max_length=45, blank=True, null=True)
    sensor_temperature = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    sensor_temperature_unit = models.CharField(max_length=45, blank=True, null=True)
    sky_temperature = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    sky_temperature_unit = models.CharField(max_length=45,  blank=True, null=True)
    status = models.CharField(max_length=45, blank=True, null=True)
    current = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    current_unit = models.CharField(max_length=45, blank=True, null=True)
6973f7df   Quentin Durand   PLC STATE + MODE
88
89
    is_safe = models.BooleanField(default=True)
    plc_mode = models.CharField(max_length=4, null=True)
6c2793c2   jeremy   Update
90
91
92
93
94
95
96
97

    class Meta:
        managed = True
        db_table = 'plc_devices_status'

    def __str__(self):
        return (str(self.__dict__))

fe5613f5   jeremy   Update plc protocol
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
    '''
        TODO : This function is Ugly,
        we should change this with a function pointer array
        and setters getters for each attribute
    '''
    def setValue(self, key, value, unit=""):
        if key == "OutsideTemp":
            self.outside_temp = value
            self.outside_temp_unit = unit
        elif key == "OutsideHumidity":
            self.outside_humidity = value
            self.outside_humidity_unit = unit
        elif key == "Pressure":
            self.pressure = value
            self.pressure_unit = unit
        elif key == "RainRate":
            self.rain_rate = value
            self.rain_rate_unit = unit
        elif key == "WindSpeed":
            self.wind_speed = value
            self.wind_speed_unit = unit
        elif key == "WindDir":
            self.wind_dir = value
            self.wind_dir_unit = unit
        elif key == "DewPoint":
            self.dew_point = value
            self.dew_point_unit = unit
        elif key == "analog":
            self.analog = value
            self.analog_unit = unit
        elif key == "digital":
            self.digital = value
            self.digital_unit = unit
        elif key == "InsideTemp":
            self.inside_temp = value
            self.inside_temp_unit = unit
        elif key == "InsideHumidity":
            self.inside_humidity = value
            self.inside_humidity_unit = unit
        elif key == "WindDirCardinal":
            self.wind_dir_cardinal = value
            self.wind_dir_cardinal_unit = unit
        elif key == "SensorTemperature":
            self.sensor_temperature = value
            self.sensor_temperature_unit = unit
        elif key == "SkyTemperature":
            self.sky_temperature = value
            self.sky_temperature_unit = unit
        elif key == "status":
            self.status = value
        elif key == "current":
            self.current = value
            self.current_unit = unit
6973f7df   Quentin Durand   PLC STATE + MODE
151
152
153
154
        elif key == "mode":
            self.plc_mode = value
        elif key == "is_safe":
            self.is_safe = value
fe5613f5   jeremy   Update plc protocol
155
156
157
        else:
            raise KeyError("Key " + str(key) + " unrecognized")

9f3db1a3   Quentin Durand   plc_mode in progr...
158
159
class PlcDevice(Device):
    #device = models.ForeignKey('Plc', on_delete=models.CASCADE, related_name='plc_devices')
6c2793c2   jeremy   Update
160
161
162
163
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
6973f7df   Quentin Durand   PLC STATE + MODE
164

6c2793c2   jeremy   Update
165
166
167
168
169
170
171
172
173

    class Meta:
        managed = True
        db_table = 'plc_devices'

    def __str__(self):
        return str(self.name)


9f3db1a3   Quentin Durand   plc_mode in progr...
174
175
176
177
178
179
#class Plc(Device):
 #   last_update_status = models.DateTimeField(blank=True, null=True)
#    i
 #   class Meta:
  #      managed = True
   #     db_table = 'plc'
6c2793c2   jeremy   Update
180

abfb02e2   Jeremy   Device Model is n...
181
182
183
184

class Detector(Device):
    VIS = "Visible camera"
    NIR = "Cagire"
ddf59dd4   haribo   Remaniement :
185

ddf59dd4   haribo   Remaniement :
186
187
    telescope = models.ForeignKey(
        'Telescope', models.DO_NOTHING, related_name="detectors")
ddf59dd4   haribo   Remaniement :
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
    nb_photo_x = models.IntegerField(blank=True, null=True)
    nb_photo_y = models.IntegerField(blank=True, null=True)
    photo_size_x = models.IntegerField(blank=True, null=True)
    photo_size_y = models.IntegerField(blank=True, null=True)
    has_shutter = models.BooleanField(default=False)
    equivalent_foc_len = models.CharField(max_length=45, blank=True, null=True)
    acq_start = models.DateTimeField(blank=True, null=True)
    acq_stop = models.DateTimeField(blank=True, null=True)
    check_temp = models.FloatField(blank=True, null=True)
    gain = models.FloatField(blank=True, null=True)
    readout_noise = models.FloatField(blank=True, null=True)
    readout_time = models.FloatField(blank=True, null=True)
    idcam_readout_mode = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'detector'

    def __str__(self):
f7dd3df1   Jeremy   Update simulators...
207
        return str(self.name)
ddf59dd4   haribo   Remaniement :
208
209
210
211
212
213

    def device_name(self):
        return self.__str__()
    device_name.short_description = "Name"


abfb02e2   Jeremy   Device Model is n...
214
class Filter(Device):
ddf59dd4   haribo   Remaniement :
215
216
217
218
219
    VIS_FILTER_1 = "First visible filter"
    VIS_FILTER_2 = "Second visible filter"
    NIR_FILTER_1 = "First infrared filter"
    NIR_FILTER_2 = "Second infrared filter"

ddf59dd4   haribo   Remaniement :
220
221
222
223
224
225
226
227
228
229
230
    filter_wheel = models.ForeignKey(
        "FilterWheel", models.DO_NOTHING, related_name="filters", blank=True, null=True)
    category = models.CharField(max_length=1, blank=True, null=True)
    transmission_curve_doc = models.CharField(
        max_length=45, blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'filter'

    def __str__(self):
f7dd3df1   Jeremy   Update simulators...
231
        return (str(self.name))
ddf59dd4   haribo   Remaniement :
232
233
234
235
236
237

    def device_name(self):
        return self.__str__()
    device_name.short_description = "Name"


abfb02e2   Jeremy   Device Model is n...
238
class FilterWheel(Device):
ce470283   Jeremy   Plc simulator fin...
239
240
    detector = models.OneToOneField(Detector, on_delete=models.CASCADE,
                                    related_name="filter_wheel", blank=True, null=True)
ddf59dd4   haribo   Remaniement :
241
242
243
244
245
246

    class Meta:
        managed = True
        db_table = 'filter_wheel'

    def __str__(self):
f7dd3df1   Jeremy   Update simulators...
247
        return (str(self.name))
ddf59dd4   haribo   Remaniement :
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
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
336
337
338

    def device_name(self):
        return self.__str__()
    device_name.short_description = "Name"


class Image(models.Model):
    plan = models.ForeignKey('Plan', on_delete=models.CASCADE, related_name="images")
    nrtanalysis = models.ForeignKey(
        'NrtAnalysis', models.DO_NOTHING, blank=True, null=True, related_name="images")
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    date_from_gps = models.CharField(max_length=45, blank=True, null=True)
    level = models.IntegerField(blank=True, null=True)
    type = models.CharField(max_length=5, blank=True, null=True)
    quality = models.CharField(max_length=45, blank=True, null=True)
    flaggps = models.CharField(max_length=45, blank=True, null=True)
    exposure = models.CharField(max_length=45, blank=True, null=True)
    tempext = models.CharField(max_length=45, blank=True, null=True)
    pressure = models.CharField(max_length=45, blank=True, null=True)
    humidext = models.CharField(max_length=45, blank=True, null=True)
    wind = models.CharField(max_length=45, blank=True, null=True)
    wind_dir = models.CharField(max_length=45, blank=True, null=True)
    dwnimg = models.CharField(max_length=45, blank=True, null=True)
    dwncata = models.CharField(max_length=45, blank=True, null=True)
    dwn = models.CharField(max_length=45, blank=True, null=True)
    level0_fits_name = models.CharField(max_length=45, blank=True, null=True)
    level1a_fits_name = models.CharField(max_length=45, blank=True, null=True)
    level1b_fits_name = models.CharField(max_length=45, blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'image'

    def __str__(self):
        return (str(self.name))


class Log(models.Model):
    agent = models.CharField(max_length=45, blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    message = models.TextField(blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'log'

    def __str__(self):
        return (str(self.agent))


class NrtAnalysis(models.Model):
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    analysis = models.TextField(blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'nrtanalysis'
        verbose_name_plural = "Nrt analyzes"

    def __str__(self):
        return (str(self.name))


class Plan(models.Model):
    album = models.ForeignKey(Album, on_delete=models.CASCADE, related_name="plans")
    filter = models.ForeignKey(Filter, models.DO_NOTHING, related_name="plans", blank=True, null=True)
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.CharField(max_length=45, blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    duration = models.FloatField(default=0, blank=True, null=True)
    position = models.CharField(max_length=45, blank=True, null=True)
    exposure_time = models.FloatField(blank=True, null=True)
    nb_images = models.IntegerField(blank=True, null=True)
    dithering = models.BooleanField(default=False)
    complete = models.BooleanField(default=False)

    class Meta:
        managed = True
        db_table = 'plan'

    def __str__(self):
        return (str(self.name))


53787d30   Jeremy   Alert now inherit...
339
class PyrosUser(AbstractUser):
2c61f856   theopuhl   Url change to pat...
340
    username = models.CharField(max_length=255, blank=False, null=False, unique=True)
c5ae1cae   theopuhl   Add send mail + v...
341
342
    is_active = models.BooleanField(default='False')
    first_time = models.BooleanField(default='False')
ddf59dd4   haribo   Remaniement :
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
    country = models.ForeignKey(
        Country, on_delete=models.DO_NOTHING, related_name="pyros_users")
    user_level = models.ForeignKey(
        'UserLevel', on_delete=models.DO_NOTHING, related_name="pyros_users")
    desc = models.TextField(blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    tel = models.CharField(max_length=45, blank=True, null=True)
    address = models.TextField(max_length=100, blank=True, null=True)
    laboratory = models.CharField(max_length=45, blank=True, null=True)
    last_connect = models.DateTimeField(blank=True, null=True)
    cur_connect = models.DateTimeField(blank=True, null=True)
    putvalid_beg = models.DateTimeField(blank=True, null=True)
    putvalid_end = models.DateTimeField(blank=True, null=True)
    acqvalid_beg = models.CharField(max_length=45, blank=True, null=True)
    acqvalid_end = models.CharField(max_length=45, blank=True, null=True)
    quota = models.FloatField(blank=True, null=True)
    quota_rea = models.FloatField(blank=True, null=True)
    u_priority = models.IntegerField(blank=True, null=True)
    p_priority = models.IntegerField(blank=True, null=True)
    dir_level = models.IntegerField(blank=True, null=True)
    can_del_void_req = models.BooleanField(default=False)

    class Meta:
        managed = True
        db_table = 'pyros_user'

    def __str__(self):
53787d30   Jeremy   Alert now inherit...
371
        return (str(self.get_username()))
ddf59dd4   haribo   Remaniement :
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402

    def user_username(self):
        return self.__str__()
    user_username.short_description = "Username"


class Request(models.Model):
    pyros_user = models.ForeignKey(
        'PyrosUser', on_delete=models.DO_NOTHING, related_name="requests")
    scientific_program = models.ForeignKey(
        'ScientificProgram', on_delete=models.DO_NOTHING, related_name="requests", blank=True, null=True)
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    is_alert = models.BooleanField(default=False)
    target_type = models.CharField(max_length=8, blank=True, null=True)
    status = models.CharField(max_length=10, blank=True, null=True)
    autodeposit = models.BooleanField(default=False)
    checkpoint = models.CharField(max_length=45, blank=True, null=True)
    flag = models.CharField(max_length=45, blank=True, null=True)
    complete = models.BooleanField(default=False)
    submitted = models.BooleanField(default=False)

    class Meta:
        managed = True
        db_table = 'request'

    def __str__(self):
        return (str(self.name))

ce470283   Jeremy   Plc simulator fin...
403

53787d30   Jeremy   Alert now inherit...
404
class Alert(Request):
5f148e7d   Unknown   Update to django2...
405
    request = models.OneToOneField('Request', on_delete=models.CASCADE, default='', parent_link=True)
53787d30   Jeremy   Alert now inherit...
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
    strategyobs = models.ForeignKey(
        'StrategyObs', models.DO_NOTHING, related_name="alerts", blank=True, null=True)
    voevent_file = models.CharField(max_length=45, blank=True, null=True)
    author = models.CharField(max_length=45, blank=True, null=True)
    burst_jd = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    burst_ra = models.FloatField(max_length=45, blank=True, null=True)
    burst_dec = models.FloatField(max_length=45, blank=True, null=True)
    astro_coord_system = models.CharField(max_length=45, blank=True, null=True)
    jd_send = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    jd_received = models.DecimalField(max_digits=15, decimal_places=8, blank=True, null=True)
    trig_id = models.IntegerField(blank=True, null=True)
    error_radius = models.FloatField(max_length=45, blank=True, null=True)
    defly_not_grb = models.BooleanField(default=False)
    editor = models.CharField(max_length=45, blank=True, null=True)
    soln_status = models.CharField(max_length=45, blank=True, null=True)
    pkt_ser_num = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'alert'

    def __str__(self):
        return str(self.trig_id)

    def request_name(self):
        return self.__str__()

    request_name.short_description = "Name"
ddf59dd4   haribo   Remaniement :
434
435
436
437
438
439
440
441
442
443
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

# class Schedule(models.Model):
#     created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
#     plan_start = models.DecimalField(
#         default=0.0, max_digits=15, decimal_places=8)
#     plan_end = models.DecimalField(
#         default=0.0, max_digits=15, decimal_places=8)
#     flag = models.CharField(max_length=45, blank=True, null=True)
#
#     class Meta:
#         managed = True
#         db_table = 'schedule'
#
#     def __str__(self):
#         return (str(self.created))


class Schedule(models.Model):
    sequences = models.ManyToManyField(
        'Sequence', through='ScheduleHasSequences', related_name='schedules')
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    plan_night_start = models.DecimalField(
        default=0.0, max_digits=15, decimal_places=8)
    plan_end = models.DecimalField(
        default=0.0, max_digits=15, decimal_places=8)
    plan_start = models.DecimalField(
        default=0.0, max_digits=15, decimal_places=8)
    flag = models.CharField(max_length=45, blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'schedule'
        verbose_name_plural = "Schedules"

    def __str__(self):
        return (str(self.created))


class ScientificProgram(models.Model):
    pyros_users = models.ManyToManyField(
        'PyrosUser', related_name="scientific_programs")
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    quota = models.FloatField(blank=True, null=True)
    priority = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'scientific_program'

    def __str__(self):
        return (str(self.name))


class Sequence(models.Model):

    """ Definition of Status enum values """

    INCOMPLETE = "INCPL"
    COMPLETE = "CPL"
    TOBEPLANNED = "TBP"
ff448d43   Jeremy   Update
495
    PLANNED = "PLND"
ddf59dd4   haribo   Remaniement :
496
    PENDING = "PNDG"
ddf59dd4   haribo   Remaniement :
497
    EXECUTING = "EXING"
ff448d43   Jeremy   Update
498
    EXECUTED = "EXD"
ddf59dd4   haribo   Remaniement :
499
    REJECTED = "RJTD"
ddf59dd4   haribo   Remaniement :
500
    INVALID = "INVL"
ff448d43   Jeremy   Update
501
502
    CANCELLED = "CNCLD"
    UNPLANNABLE = "UNPLN"
ddf59dd4   haribo   Remaniement :
503
504
505
506
    STATUS_CHOICES = (
        (INCOMPLETE, "Incomplete"),
        (COMPLETE, "Complete"),
        (TOBEPLANNED, "To be planned"),
ff448d43   Jeremy   Update
507
        (PLANNED, "Planned"),
ddf59dd4   haribo   Remaniement :
508
509
510
511
512
513
514
        (UNPLANNABLE, "Unplannable"),
        (PENDING, "Pending"),
        (EXECUTED, "Executed"),
        (EXECUTING, "Executing"),
        (REJECTED, "Rejected"),
        (CANCELLED, "Cancelled"),
        (INVALID, "Invalid"),
ddf59dd4   haribo   Remaniement :
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
553
554
555
556
557
558
    )

    request = models.ForeignKey(
        Request, on_delete=models.CASCADE, related_name="sequences")
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    is_alert = models.BooleanField(default=False)
    status = models.CharField(
        max_length=11, blank=True, null=True, choices=STATUS_CHOICES)
    target_coords = models.CharField(max_length=100, blank=True, null=True)
    with_drift = models.BooleanField(default=False)
    priority = models.IntegerField(blank=True, null=True)
    analysis_method = models.CharField(max_length=45, blank=True, null=True)
    moon_min = models.IntegerField(blank=True, null=True)
    alt_min = models.IntegerField(blank=True, null=True)
    type = models.CharField(max_length=6, blank=True, null=True)
    img_current = models.CharField(max_length=45, blank=True, null=True)
    img_total = models.CharField(max_length=45, blank=True, null=True)
    not_obs = models.BooleanField(default=False)
    obsolete = models.BooleanField(default=False)
    processing = models.BooleanField(default=False)
    flag = models.CharField(max_length=45, blank=True, null=True)
    jd1 = models.DecimalField(default=0.0, max_digits=15, decimal_places=8)
    jd2 = models.DecimalField(default=0.0, max_digits=15, decimal_places=8)
    t_prefered = models.DecimalField(
        default=-1.0, max_digits=15, decimal_places=8)
    duration = models.DecimalField(
        default=-1.0, max_digits=15, decimal_places=8)
    overhead = models.DecimalField(default=0, max_digits=15, decimal_places=8)

    ra = models.FloatField(blank=True, null=True)
    dec = models.FloatField(blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'sequence'

    def __str__(self):
        return (str(self.name))


class ScheduleHasSequences(models.Model):
05bdcc44   Etienne Pallier   BIG DEMO tests (s...
559
    # (EP) TODO: C'est pas un pb d'utiliser 2 fois le meme nom "shs" pour 2 choses differentes ???!!!
ddf59dd4   haribo   Remaniement :
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
    schedule = models.ForeignKey(
        'Schedule', on_delete=models.CASCADE, related_name="shs")
    sequence = models.ForeignKey(
        'Sequence', on_delete=models.CASCADE, related_name="shs")

    status = models.CharField(
        max_length=11, blank=True, null=True, choices=Sequence.STATUS_CHOICES)
    desc = models.CharField(max_length=45, blank=True, null=True)
    tsp = models.DecimalField(default=-1.0, max_digits=15, decimal_places=8)
    tep = models.DecimalField(default=-1.0, max_digits=15, decimal_places=8)
    deltaTL = models.DecimalField(
        default=-1.0, max_digits=15, decimal_places=8)
    deltaTR = models.DecimalField(
        default=-1.0, max_digits=15, decimal_places=8)

    class Meta:
        managed = True
        db_table = 'schedule_has_sequences'


class SiteWatch(models.Model):
c53a13e0   Jeremy   Updating a lot of...
581
582
583
584
585
    OPEN = "OPEN"
    CLOSE = "CLOSE"
    ON = "ON"
    OFF = "OFF"

ce470283   Jeremy   Plc simulator fin...
586
    global_status = models.CharField(max_length=255, blank=True, null=True)
ddf59dd4   haribo   Remaniement :
587
588
589
590
591
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    lights = models.CharField(max_length=45, blank=True, null=True)
    dome = models.CharField(max_length=45, blank=True, null=True)
    doors = models.CharField(max_length=45, blank=True, null=True)
    temperature = models.FloatField(blank=True, null=True)
ce470283   Jeremy   Plc simulator fin...
592
593
    shutter = models.FloatField(blank=True, null=True)
    pressure = models.FloatField(blank=True, null=True)
fe5613f5   jeremy   Update plc protocol
594
    humidity = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
595
596
597
598
599
600
601

    class Meta:
        managed = True
        db_table = 'sitewatch'
        verbose_name_plural = "Site watches"

    def __str__(self):
678838ed   Jeremy   Weather ans insid...
602
        return (str(self.__dict__))
ddf59dd4   haribo   Remaniement :
603

ce470283   Jeremy   Plc simulator fin...
604
605
606
    # TODO
    def setGlobalStatus(self):
        self.global_status = ""
678838ed   Jeremy   Weather ans insid...
607
        if self.doors and self.doors.find("open") != -1:
ce470283   Jeremy   Plc simulator fin...
608
609
610
            self.global_status += "DOOR_OPEN "
        if self.lights and self.lights == "on":
            self.global_status += "LIGHTS_ON "
678838ed   Jeremy   Weather ans insid...
611
        if self.temperature and float(self.temperature) > 40:
ce470283   Jeremy   Plc simulator fin...
612
            self.global_status += "TOO_HOT "
678838ed   Jeremy   Weather ans insid...
613
        if self.humidity and float(self.humidity) > 80:
ce470283   Jeremy   Plc simulator fin...
614
615
616
617
618
            self.global_status += "HUMIDITY_TOO_HIGH "
        if self.global_status == "":
            self.global_status = "OK"
        return 0

fe5613f5   jeremy   Update plc protocol
619
    # TODO HANDLE FLAT LAMPS ...
ce470283   Jeremy   Plc simulator fin...
620
    def setAttribute(self, key, value):
678838ed   Jeremy   Weather ans insid...
621
        self.doors = ""
fe5613f5   jeremy   Update plc protocol
622
        if key == "InsideHumidity":
ce470283   Jeremy   Plc simulator fin...
623
            self.humidity = value
fe5613f5   jeremy   Update plc protocol
624
        elif key == "Pressure":
ce470283   Jeremy   Plc simulator fin...
625
626
627
628
629
            self.pressure = value
        else:
            return 1
        return 0

ddf59dd4   haribo   Remaniement :
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666

class SiteWatchHistory(models.Model):
    id = models.IntegerField(primary_key=True)

    class Meta:
        managed = True
        db_table = 'sitewatchhistory'
        verbose_name_plural = "Site watch histories"


class StrategyObs(models.Model):
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    xml_file = models.CharField(max_length=45, blank=True, null=True)
    is_default = models.BooleanField(default=False)

    class Meta:
        managed = True
        db_table = 'strategyobs'
        verbose_name_plural = "Strategy obs"

    def __str__(self):
        return (str(self.name))


class TaskId(models.Model):
    task = models.CharField(max_length=45, blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    task_id = models.CharField(max_length=45, blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'task_id'

    def __str__(self):
        return (str(self.task) + " - " + str(self.task_id))

cfc9d09c   Jeremy   Added dome simula...
667

ce470283   Jeremy   Plc simulator fin...
668
669
670
671
672
673
674
675
676
677
678
class Dome(Device):
    DOME = "Dome"

    open = models.BooleanField(default=False, blank=True)

    class Meta:
        managed = True
        db_table = 'dome'

    def __str__(self):
        return str(self.name)
cfc9d09c   Jeremy   Added dome simula...
679

ce470283   Jeremy   Plc simulator fin...
680
681
682
    def device_name(self):
        return self.__str__()
    device_name.short_description = "Name"
cfc9d09c   Jeremy   Added dome simula...
683

ddf59dd4   haribo   Remaniement :
684

abfb02e2   Jeremy   Device Model is n...
685
686
687
class Telescope(Device):
    TELESCOPE = "Telescope"

ddf59dd4   haribo   Remaniement :
688
689
    mount_type = models.CharField(max_length=9, blank=True, null=True)
    diameter = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
    latitude = models.FloatField(blank=True, null=True)
    longitude = models.FloatField(blank=True, null=True)
    sens = models.CharField(max_length=1, blank=True, null=True)
    altitude = models.FloatField(blank=True, null=True)
    readout_time = models.IntegerField(blank=True, null=True)
    slew_time = models.IntegerField(blank=True, null=True)
    slew_dead = models.IntegerField(blank=True, null=True)
    slew_rate_max = models.FloatField(blank=True, null=True)
    horizon_type = models.CharField(max_length=45, blank=True, null=True)
    horizon_def = models.FloatField(blank=True, null=True)
    lim_dec_max = models.FloatField(blank=True, null=True)
    lim_dec_min = models.FloatField(blank=True, null=True)
    lim_ha_rise = models.FloatField(blank=True, null=True)
    lim_ha_set = models.FloatField(blank=True, null=True)
    address = models.CharField(max_length=45, blank=True, null=True)
    night_elev_sun = models.FloatField(blank=True, null=True)
    mpc_code = models.CharField(max_length=45, blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'telescope'

    def __str__(self):
f7dd3df1   Jeremy   Update simulators...
713
        return (self.name)
ddf59dd4   haribo   Remaniement :
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742


class UserLevel(models.Model):
    name = models.CharField(max_length=45, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    priority = models.IntegerField(blank=True, null=True)
    quota = models.FloatField(blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'user_level'

    def __str__(self):
        return (str(self.name))


class Version(models.Model):
    module_name = models.CharField(max_length=45, blank=True, null=True)
    version = models.CharField(max_length=15, blank=True, null=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)

    class Meta:
        managed = True
        db_table = 'version'

    def __str__(self):
        return (str(self.module_name) + " - " + str(self.version))

ce470283   Jeremy   Plc simulator fin...
743

ddf59dd4   haribo   Remaniement :
744
class WeatherWatch(models.Model):
c53a13e0   Jeremy   Updating a lot of...
745
746
747
    WIND_LIMIT = 100
    RAIN_LIMIT = 5

ce470283   Jeremy   Plc simulator fin...
748
749
750
    global_status = models.CharField(max_length=255, blank=True, null=True)
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
    humidity = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
751
    wind = models.FloatField(blank=True, null=True)
fe5613f5   jeremy   Update plc protocol
752
    wind_dir = models.CharField(max_length=45, blank=True, null=True)
ce470283   Jeremy   Plc simulator fin...
753
    temperature = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
754
755
    pressure = models.FloatField(blank=True, null=True)
    rain = models.FloatField(blank=True, null=True)
ce470283   Jeremy   Plc simulator fin...
756
    cloud = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
757
758
759
760
761
762
763

    class Meta:
        managed = True
        db_table = 'weatherwatch'
        verbose_name_plural = "Weather watches"

    def __str__(self):
678838ed   Jeremy   Weather ans insid...
764
        return (str(self.__dict__))
ddf59dd4   haribo   Remaniement :
765

ce470283   Jeremy   Plc simulator fin...
766
767
768
    # TODO
    def setGlobalStatus(self):
        self.global_status = ""
678838ed   Jeremy   Weather ans insid...
769
        if self.rain and float(self.rain) > 10:
ce470283   Jeremy   Plc simulator fin...
770
            self.global_status += "RAINING "
678838ed   Jeremy   Weather ans insid...
771
        if self.wind and float(self.wind) > 80:
ce470283   Jeremy   Plc simulator fin...
772
            self.global_status += "WIND_TOO_STRONG "
678838ed   Jeremy   Weather ans insid...
773
        if self.humidity and float(self.humidity) > 80:
ce470283   Jeremy   Plc simulator fin...
774
            self.global_status += "HUMIDITY_TOO_HIGH "
678838ed   Jeremy   Weather ans insid...
775
        if self.cloud and float(self.cloud) > 10:
ce470283   Jeremy   Plc simulator fin...
776
777
778
779
780
781
            self.global_status += "TOO_MUCH_CLOUDY "
        if self.global_status == "":
            self.global_status = "OK"
        return 0

    def setAttribute(self, key, value):
fe5613f5   jeremy   Update plc protocol
782
        if key == "RainRate":
ce470283   Jeremy   Plc simulator fin...
783
            self.rain = value
fe5613f5   jeremy   Update plc protocol
784
        elif key == "CloudRate":
ce470283   Jeremy   Plc simulator fin...
785
            self.cloud = value
fe5613f5   jeremy   Update plc protocol
786
        elif key == "WindSpeed":
ce470283   Jeremy   Plc simulator fin...
787
            self.wind = value
fe5613f5   jeremy   Update plc protocol
788
        elif key == "WindDir":
ce470283   Jeremy   Plc simulator fin...
789
            self.wind_dir = value
fe5613f5   jeremy   Update plc protocol
790
        elif key == "SensorTemperature":
ce470283   Jeremy   Plc simulator fin...
791
            self.temperature = value
fe5613f5   jeremy   Update plc protocol
792
        elif key == "OutsideHumidity":
ce470283   Jeremy   Plc simulator fin...
793
            self.humidity = value
fe5613f5   jeremy   Update plc protocol
794
        elif key == "Pressure":
ce470283   Jeremy   Plc simulator fin...
795
796
797
798
799
            self.pressure = value
        else:
            return 1
        return 0

ddf59dd4   haribo   Remaniement :
800
801
802

class WeatherWatchHistory(models.Model):
    datetime = models.DateTimeField(blank=True, null=True, auto_now_add=True)
e31b2208   theophile.puhl@epitech.eu   Severals Changes ...
803
    humid_int = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
    humid_ext = models.CharField(max_length=45, blank=True, null=True)
    wind = models.CharField(max_length=45, blank=True, null=True)
    wind_dir = models.CharField(max_length=45, blank=True, null=True)
    temp_int = models.CharField(max_length=45, blank=True, null=True)
    temp_ext = models.CharField(max_length=45, blank=True, null=True)
    pressure = models.CharField(max_length=45, blank=True, null=True)
    rain = models.CharField(max_length=45, blank=True, null=True)
    dwn = models.CharField(max_length=45, blank=True, null=True)

    class Meta:
        managed = True
        db_table = 'weatherwatchhistory'
        verbose_name_plural = "Weather watch histories"

    def __str__(self):
        return (str(self.datetime))
e31b2208   theophile.puhl@epitech.eu   Severals Changes ...
820
821
822


class Config(models.Model):
c5ae1cae   theopuhl   Add send mail + v...
823
824
825
826
827
828
829
    SCHEDULER_STATE = (
    ('0', 'init'),
    ('1', 'sleeping'),
    ('2', 'startup'),
    ('3', 'observing'),
    ('4', 'shutdown'),
    )
e31b2208   theophile.puhl@epitech.eu   Severals Changes ...
830
831
832
833
834
835
836
837
838
839
840
841
842
    id = models.IntegerField(default='1', primary_key=True)
    latitude = models.FloatField(default=1)
    local_time_zone = models.FloatField(default=1)
    longitude = models.FloatField(default=1)
    altitude = models.FloatField(default=1)
    horizon_line = models.FloatField(default=1)
    row_data_save_frequency = models.IntegerField(default='300')
    request_frequency = models.IntegerField(default='300')
    analysed_data_save = models.IntegerField(default='300')
    telescope_ip_address = models.CharField(max_length=45, default="127.0.0.1")
    camera_ip_address = models.CharField(max_length=45, default="127.0.0.1")
    plc_ip_address = models.CharField(max_length=45, default="127.0.0.1")
    global_mode = models.BooleanField(default='True')
c830a3bc   Quentin Durand   PLC ACK + plc tim...
843
    ack = models.BooleanField(default='False')
2c61f856   theopuhl   Url change to pat...
844
    bypass = models.BooleanField(default='True')
c5ae1cae   theopuhl   Add send mail + v...
845
846
    scheduler_state = models.CharField(max_length=1, choices=SCHEDULER_STATE, default=0)
    force_passive_mode = models.BooleanField(default='False')
c830a3bc   Quentin Durand   PLC ACK + plc tim...
847
    plc_timeout_seconds = models.PositiveIntegerField(default=60)
e31b2208   theophile.puhl@epitech.eu   Severals Changes ...
848
849
850
851
852
853
854
855

    class Meta:
        managed = True
        db_table = 'config'
        verbose_name_plural = "Config"

    def __str__(self):
        return (str(self.__dict__))