Blame view

src/common/models.py 41.5 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
from django.db import models
bb697c31   Unknown   Auto stash before...
5
from enum import Enum
3df2d31a   haribo   #3430 : dates are...
6

a5f1e984   Etienne Pallier   cleanup common/mo...
7
8
9
10
11
12
13
14
15
16
17
18
19
20

''' 
NOT USED - to be removed
class PyrosState(Enum):
    START = 'Starting'
    PA = 'Passive'
    INI = "INIT"
    STAND = "Standby"
    SCHED_START = 'Scheduler startup'
    SCHED = 'Scheduler'
    SCHED_CLOSE = 'Scheduler closing'
'''


01348735   Etienne Pallier   Bugfix pyros.py s...
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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

"""
STYLE RULES
===========
(https://simpleisbetterthancomplex.com/tips/2018/02/10/django-tip-22-designing-better-models.html)

- The model definition is a class, so always use CapWords convention (no underscores)
    E.g. User, Permission, ContentType, etc.

- For the model’s attributes use snake_case.
    E.g. first_name, last_name, etc

- Always name your models using singular.
    Call it Company instead of Companies. 
    A model definition is the representation of a single object (the object in this example is a company), 
    and not a collection of companies

- Blank and Null Fields
    - Null: It is database-related. Defines if a given database column will accept null values or not.
    - Blank: It is validation-related. It will be used during forms validation, when calling form.is_valid().
    Do not use null=True for text-based fields that are optional.
    Otherwise, you will end up having two possible values for “no data”,
    that is: None and an empty string.
    Having two possible values for “no data” is redundant.
    The Django convention is to use the empty string, not NULL.
    Example:
        # The default values of `null` and `blank` are `False`.
        class Person(models.Model):
            name = models.CharField(max_length=255)  # Mandatory
            bio = models.TextField(max_length=500, blank=True)  # Optional (don't put null=True)
            birth_date = models.DateField(null=True, blank=True) # Optional (here you may add null=True)

- Reverse Relationships

    - related_name :
    Rule of thumb: if you are not sure what would be the related_name, 
    use the plural of the model holding the ForeignKey.
    ex:
        class Company:
            name = models.CharField(max_length=30)
        class Employee:
            first_name = models.CharField(max_length=30)
            last_name = models.CharField(max_length=30)
            company = models.ForeignKey(Company, on_delete=models.CASCADE, related_name='employees')
    usage:
        google = Company.objects.get(name='Google')
        google.employees.all()
        You can also use the reverse relationship to modify the company field on the Employee instances:
        vitor = Employee.objects.get(first_name='Vitor')
        google = Company.objects.get(name='Google')
        google.employees.add(vitor)

    - related_query_name :
        This kind of relationship also applies to query filters. 
        For example, if I wanted to list all companies that employs people named ‘Vitor’, I could do the following:
        companies = Company.objects.filter(employee__first_name='Vitor')
        If you want to customize the name of this relationship, here is how we do it:
            class Employee:
                first_name = models.CharField(max_length=30)
                last_name = models.CharField(max_length=30)
                company = models.ForeignKey(
                    Company,
                    on_delete=models.CASCADE,
                    related_name='employees',
                    related_query_name='person'
                )
        Then the usage would be:
        companies = Company.objects.filter(person__first_name='Vitor')

    To use it consistently, related_name goes as plural and related_query_name goes as singular.


GENERAL EXAMPLE
=======

from django.db import models
from django.urls import reverse

class Company(models.Model):
    # CHOICES
    PUBLIC_LIMITED_COMPANY = 'PLC'
    PRIVATE_COMPANY_LIMITED = 'LTD'
    LIMITED_LIABILITY_PARTNERSHIP = 'LLP'
    COMPANY_TYPE_CHOICES = (
        (PUBLIC_LIMITED_COMPANY, 'Public limited company'),
        (PRIVATE_COMPANY_LIMITED, 'Private company limited by shares'),
        (LIMITED_LIABILITY_PARTNERSHIP, 'Limited liability partnership'),
    )

    # DATABASE FIELDS
    name = models.CharField('name', max_length=30)
    vat_identification_number = models.CharField('VAT', max_length=20)
    company_type = models.CharField('type', max_length=3, choices=COMPANY_TYPE_CHOICES)

    # MANAGERS
    objects = models.Manager()
    limited_companies = LimitedCompanyManager()

    # META CLASS
    class Meta:
        verbose_name = 'company'
        verbose_name_plural = 'companies'

    # TO STRING METHOD
    def __str__(self):
        return self.name

    # SAVE METHOD
    def save(self, *args, **kwargs):
        do_something()
        super().save(*args, **kwargs)  # Call the "real" save() method.
        do_something_else()

    # ABSOLUTE URL METHOD
    def get_absolute_url(self):
        return reverse('company_details', kwargs={'pk': self.id})

    # OTHER METHODS
    def process_invoices(self):
        do_something()

"""



a5f1e984   Etienne Pallier   cleanup common/mo...
146
147
148
149
150
151
152
"""
------------------------
   BASE MODEL CLASSES
------------------------
"""

class Device(models.Model):
ddf59dd4   haribo   Remaniement :
153
154
155
156
    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)
a5f1e984   Etienne Pallier   cleanup common/mo...
157
158
159
160
161
162
163
164
165
166
    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))

a5f1e984   Etienne Pallier   cleanup common/mo...
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
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)
ddf59dd4   haribo   Remaniement :
182
    complete = models.BooleanField(default=False)
a5f1e984   Etienne Pallier   cleanup common/mo...
183
    submitted = models.BooleanField(default=False)
ddf59dd4   haribo   Remaniement :
184
185
186

    class Meta:
        managed = True
a5f1e984   Etienne Pallier   cleanup common/mo...
187
        db_table = 'request'
ddf59dd4   haribo   Remaniement :
188
189
190
191
192

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


a5f1e984   Etienne Pallier   cleanup common/mo...
193
194
195
196
197
198
199

"""
------------------------
   OTHER MODEL CLASSES
------------------------
"""

a3015e31   Etienne Pallier   table des commandes
200
201
202
203
204
205
206
207
class AgentsCommand(models.Model):
    """
    | id | sender | receiver | command | validity_duration_sec (default=60) | sender_deposit_time | receiver_read_time
    (l'agent destinataire en profite pour supprimer les commandes périmées qui le concernent)
    """
    #sender = models.CharField(max_length=50, blank=True, null=True, unique=True)
    sender = models.CharField(max_length=50, unique=True)
    receiver = models.CharField(max_length=50, unique=True)
968d1a72   Alain Klotz   Modfis database s...
208
209
    command = models.CharField(max_length=400)
    validity_duration_sec = models.PositiveIntegerField(default=60)
a3015e31   Etienne Pallier   table des commandes
210
211
    sender_deposit_time = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    receiver_read_time = models.DateTimeField(blank=True, null=True, auto_now=True)
968d1a72   Alain Klotz   Modfis database s...
212
    receiver_error_code = models.IntegerField(default=1)
a3015e31   Etienne Pallier   table des commandes
213
214
215
216
217
218
219
220
221
222
223

    class Meta:
        managed = True
        db_table = 'agents_command'
        #verbose_name = "agent survey"
        #verbose_name_plural = "agents survey"

    def __str__(self):
        return (f"Agent {self.sender} sent commmand {self.command} to {self.receiver} at {self.sender_deposit_time}")


a5f1e984   Etienne Pallier   cleanup common/mo...
224
class AgentsSurvey(models.Model):
0d065f79   Etienne Pallier   new migration fil...
225
    """
a3015e31   Etienne Pallier   table des commandes
226
    | id | name | created | updated | validity_duration_sec (default=1mn) | mode (active/idle) | status (launch/init/loop/exit/...) |
0d065f79   Etienne Pallier   new migration fil...
227
    """
01348735   Etienne Pallier   Bugfix pyros.py s...
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
    # Statuses
    STATUS_LAUNCH = "LAUNCHED"
    STATUS_INIT = "INITIALIZING"
    STATUS_MAIN_LOOP = "IN_MAIN_LOOP"
    STATUS_PROCESS_LOOP = "IN_PROCESS_LOOP"
    STATUS_EXIT = "EXITING"

    # Modes
    MODE_ACTIVE = "ACTIVE"
    MODE_IDLE = "IDLE"

    MODE_CHOICES = (
        (MODE_ACTIVE, 'Active mode'),
        (MODE_IDLE, 'Idle mode'),
    )

    STATUS_CHOICES = (
        (STATUS_LAUNCH, "LAUNCHED"),
        (STATUS_INIT, "INITIALIZING"),
        (STATUS_MAIN_LOOP, "IN_MAIN_LOOP"),
        (STATUS_PROCESS_LOOP, "IN_PROCESS_LOOP"),
        (STATUS_EXIT, "EXITING"),
    )

24d6b29e   Etienne Pallier   Agent with db_sur...
252
    name = models.CharField(max_length=50, blank=True, null=True, unique=True)
a3015e31   Etienne Pallier   table des commandes
253
254
    #created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
a5f1e984   Etienne Pallier   cleanup common/mo...
255
    updated = models.DateTimeField(blank=True, null=True, auto_now=True)
01348735   Etienne Pallier   Bugfix pyros.py s...
256
257
258
    validity_duration_sec = models.PositiveIntegerField(blank=True, null=True)
    mode = models.CharField('agent mode', max_length=15, blank=True, null=True, choices=MODE_CHOICES)
    status = models.CharField(max_length=15, blank=True, null=True, choices=STATUS_CHOICES)
ddf59dd4   haribo   Remaniement :
259
260
261

    class Meta:
        managed = True
a5f1e984   Etienne Pallier   cleanup common/mo...
262
        db_table = 'agents_survey'
01348735   Etienne Pallier   Bugfix pyros.py s...
263
264
        #verbose_name = "agent survey"
        #verbose_name_plural = "agents survey"
ddf59dd4   haribo   Remaniement :
265
266

    def __str__(self):
24d6b29e   Etienne Pallier   Agent with db_sur...
267
        return (f"Agent {self.name} at {self.updated} in mode {self.mode} and status {self.status}")
ddf59dd4   haribo   Remaniement :
268

ce470283   Jeremy   Plc simulator fin...
269

a5f1e984   Etienne Pallier   cleanup common/mo...
270
271
272
273
274
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)
abfb02e2   Jeremy   Device Model is n...
275
276
277
278
    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)
a5f1e984   Etienne Pallier   cleanup common/mo...
279
    complete = models.BooleanField(default=False)
abfb02e2   Jeremy   Device Model is n...
280
281

    class Meta:
a5f1e984   Etienne Pallier   cleanup common/mo...
282
283
        managed = True
        db_table = 'album'
01348735   Etienne Pallier   Bugfix pyros.py s...
284
        #verbose_name_plural = "Albums"
abfb02e2   Jeremy   Device Model is n...
285
286
287
288

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

a5f1e984   Etienne Pallier   cleanup common/mo...
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307

class Alert(Request):
    request = models.OneToOneField('Request', on_delete=models.CASCADE, default='', parent_link=True)
    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)
6c2793c2   jeremy   Update
308
309
310

    class Meta:
        managed = True
a5f1e984   Etienne Pallier   cleanup common/mo...
311
        db_table = 'alert'
6c2793c2   jeremy   Update
312
313

    def __str__(self):
a5f1e984   Etienne Pallier   cleanup common/mo...
314
        return str(self.trig_id)
6c2793c2   jeremy   Update
315

a5f1e984   Etienne Pallier   cleanup common/mo...
316
317
    def request_name(self):
        return self.__str__()
fe5613f5   jeremy   Update plc protocol
318

a5f1e984   Etienne Pallier   cleanup common/mo...
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
    request_name.short_description = "Name"



class Config(models.Model):
    PYROS_STATE = ["Starting", "Passive", "Standby", "Remote", "Startup", "Scheduler", "Closing" ]

    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")
6973f7df   Quentin Durand   PLC STATE + MODE
338

a5f1e984   Etienne Pallier   cleanup common/mo...
339
340
341
342
343
344
345
346
347
348
349
350
351
    # TODO: changer ça, c'est pas clair du tout...
    # True = mode Scheduler-standby, False = mode Remote !!!!
    global_mode = models.BooleanField(default='True')

    ack = models.BooleanField(default='False')
    bypass = models.BooleanField(default='True')
    lock = models.BooleanField(default='False')
    pyros_state = models.CharField(max_length=25, default=PYROS_STATE[0])
    force_passive_mode = models.BooleanField(default='False')
    plc_timeout_seconds = models.PositiveIntegerField(default=60)
    majordome_state = models.CharField(max_length=25, default="")
    ntc = models.BooleanField(default='False')
    majordome_restarted = models.BooleanField(default='False')
6c2793c2   jeremy   Update
352
353
354

    class Meta:
        managed = True
a5f1e984   Etienne Pallier   cleanup common/mo...
355
356
        db_table = 'config'
        verbose_name_plural = "Config"
6c2793c2   jeremy   Update
357
358

    def __str__(self):
a5f1e984   Etienne Pallier   cleanup common/mo...
359
        return (str(self.__dict__))
6c2793c2   jeremy   Update
360
361


a5f1e984   Etienne Pallier   cleanup common/mo...
362
363
364
365
366
367
368
369
370
371
372
373
374

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))
6c2793c2   jeremy   Update
375

abfb02e2   Jeremy   Device Model is n...
376
377
378
379

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

ddf59dd4   haribo   Remaniement :
381
382
    telescope = models.ForeignKey(
        'Telescope', models.DO_NOTHING, related_name="detectors")
ddf59dd4   haribo   Remaniement :
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
    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...
402
        return str(self.name)
ddf59dd4   haribo   Remaniement :
403
404
405
406
407
408

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


a5f1e984   Etienne Pallier   cleanup common/mo...
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
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)

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



abfb02e2   Jeremy   Device Model is n...
427
class Filter(Device):
ddf59dd4   haribo   Remaniement :
428
429
430
431
432
    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 :
433
434
435
436
437
438
439
440
441
442
443
    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...
444
        return (str(self.name))
ddf59dd4   haribo   Remaniement :
445
446
447
448
449
450

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


abfb02e2   Jeremy   Device Model is n...
451
class FilterWheel(Device):
ce470283   Jeremy   Plc simulator fin...
452
453
    detector = models.OneToOneField(Detector, on_delete=models.CASCADE,
                                    related_name="filter_wheel", blank=True, null=True)
ddf59dd4   haribo   Remaniement :
454
455
456
457
458
459

    class Meta:
        managed = True
        db_table = 'filter_wheel'

    def __str__(self):
f7dd3df1   Jeremy   Update simulators...
460
        return (str(self.name))
ddf59dd4   haribo   Remaniement :
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

    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
a5f1e984   Etienne Pallier   cleanup common/mo...
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
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
        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))




class PlcDeviceStatus(models.Model):
    device = models.ForeignKey('PlcDevice', on_delete=models.CASCADE, related_name='current_status')
    created = models.DateTimeField(auto_now_add=True, editable=False, blank=True)
    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)
    wind_dir_cardinal = models.CharField(max_length=45, blank=True, null=True)
    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)
    is_safe = models.BooleanField(default=True)
    plc_mode = models.CharField(max_length=4, null=True)
    lights = models.CharField(max_length=3, null=True)
    shutters = models.CharField(max_length=5, null=True)

    class Meta:
        managed = True
        db_table = 'plc_devices_status'
ddf59dd4   haribo   Remaniement :
596
597

    def __str__(self):
a5f1e984   Etienne Pallier   cleanup common/mo...
598
        return (str(self.__dict__))
ddf59dd4   haribo   Remaniement :
599

a5f1e984   Etienne Pallier   cleanup common/mo...
600
601
602
603
604
605
    '''
        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=""):
8c772a38   Patrick Maeght   document it
606
        if key == "Temperature_outside":
a5f1e984   Etienne Pallier   cleanup common/mo...
607
608
            self.outside_temp = value
            self.outside_temp_unit = unit
8c772a38   Patrick Maeght   document it
609
        elif key == "Humidity_outside":
a5f1e984   Etienne Pallier   cleanup common/mo...
610
611
            self.outside_humidity = value
            self.outside_humidity_unit = unit
8c772a38   Patrick Maeght   document it
612
        elif key == "_Pressure":
a5f1e984   Etienne Pallier   cleanup common/mo...
613
614
            self.pressure = value
            self.pressure_unit = unit
8c772a38   Patrick Maeght   document it
615
        elif key == "Rain_boolean": # RainRate
a5f1e984   Etienne Pallier   cleanup common/mo...
616
            self.rain_rate = value
8c772a38   Patrick Maeght   document it
617
618
            self.rain_rate_unit = 'boulean'
        elif key == "Wind_speed":
a5f1e984   Etienne Pallier   cleanup common/mo...
619
620
            self.wind_speed = value
            self.wind_speed_unit = unit
8c772a38   Patrick Maeght   document it
621
        elif key == "Wind_dir":
a5f1e984   Etienne Pallier   cleanup common/mo...
622
623
            self.wind_dir = value
            self.wind_dir_unit = unit
8c772a38   Patrick Maeght   document it
624
        elif key == "_DewPoint":
a5f1e984   Etienne Pallier   cleanup common/mo...
625
626
            self.dew_point = value
            self.dew_point_unit = unit
8c772a38   Patrick Maeght   document it
627
        elif key == "_analog":
a5f1e984   Etienne Pallier   cleanup common/mo...
628
629
            self.analog = value
            self.analog_unit = unit
8c772a38   Patrick Maeght   document it
630
        elif key == "_digital":
a5f1e984   Etienne Pallier   cleanup common/mo...
631
632
            self.digital = value
            self.digital_unit = unit
8c772a38   Patrick Maeght   document it
633
        elif key == "_InsideTemp":
a5f1e984   Etienne Pallier   cleanup common/mo...
634
635
            self.inside_temp = value
            self.inside_temp_unit = unit
8c772a38   Patrick Maeght   document it
636
        elif key == "_InsideHumidity":
a5f1e984   Etienne Pallier   cleanup common/mo...
637
638
            self.inside_humidity = value
            self.inside_humidity_unit = unit
8c772a38   Patrick Maeght   document it
639
        elif key == "_WindDirCardinal":
a5f1e984   Etienne Pallier   cleanup common/mo...
640
641
            self.wind_dir_cardinal = value
            self.wind_dir_cardinal_unit = unit
8c772a38   Patrick Maeght   document it
642
        elif key == "_SensorTemperature":
a5f1e984   Etienne Pallier   cleanup common/mo...
643
644
            self.sensor_temperature = value
            self.sensor_temperature_unit = unit
8c772a38   Patrick Maeght   document it
645
        elif key == "_SkyTemperature":
a5f1e984   Etienne Pallier   cleanup common/mo...
646
647
            self.sky_temperature = value
            self.sky_temperature_unit = unit
8c772a38   Patrick Maeght   document it
648
649
        # PM 20190222 try patch
        elif key == "Error_code":
a5f1e984   Etienne Pallier   cleanup common/mo...
650
651
652
653
654
655
656
657
658
659
660
661
662
            self.status = value
        elif key == "current":
            self.current = value
            self.current_unit = unit
        elif key == "mode":
            self.plc_mode = value
        elif key == "is_safe":
            self.is_safe = value
        elif key == "LIGHTS":
            self.lights = value
        elif key == "SHUTTERS":
            self.shutters = value
        else:
8c772a38   Patrick Maeght   document it
663
664
665
            # PM 20190222 ignore unrecognized
            #raise KeyError("Key " + str(key) + " unrecognized")
            pass
ddf59dd4   haribo   Remaniement :
666

a5f1e984   Etienne Pallier   cleanup common/mo...
667
668
class PlcDevice(Device):
    #device = models.ForeignKey('Plc', on_delete=models.CASCADE, related_name='plc_devices')
ddf59dd4   haribo   Remaniement :
669
670
671
672
    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)
a5f1e984   Etienne Pallier   cleanup common/mo...
673

ddf59dd4   haribo   Remaniement :
674
675
676

    class Meta:
        managed = True
a5f1e984   Etienne Pallier   cleanup common/mo...
677
        db_table = 'plc_devices'
ddf59dd4   haribo   Remaniement :
678
679

    def __str__(self):
a5f1e984   Etienne Pallier   cleanup common/mo...
680
        return str(self.name)
ddf59dd4   haribo   Remaniement :
681

ddf59dd4   haribo   Remaniement :
682

a5f1e984   Etienne Pallier   cleanup common/mo...
683
684
685
686
687
688
#class Plc(Device):
 #   last_update_status = models.DateTimeField(blank=True, null=True)
#    i
 #   class Meta:
  #      managed = True
   #     db_table = 'plc'
ddf59dd4   haribo   Remaniement :
689

ddf59dd4   haribo   Remaniement :
690
691


53787d30   Jeremy   Alert now inherit...
692
class PyrosUser(AbstractUser):
2c61f856   theopuhl   Url change to pat...
693
    username = models.CharField(max_length=255, blank=False, null=False, unique=True)
c5ae1cae   theopuhl   Add send mail + v...
694
695
    is_active = models.BooleanField(default='False')
    first_time = models.BooleanField(default='False')
ddf59dd4   haribo   Remaniement :
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
    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...
724
        return (str(self.get_username()))
ddf59dd4   haribo   Remaniement :
725
726
727
728
729
730

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


53787d30   Jeremy   Alert now inherit...
731

53787d30   Jeremy   Alert now inherit...
732

53787d30   Jeremy   Alert now inherit...
733

ddf59dd4   haribo   Remaniement :
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
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

# 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
795
    PLANNED = "PLND"
ddf59dd4   haribo   Remaniement :
796
    PENDING = "PNDG"
ddf59dd4   haribo   Remaniement :
797
    EXECUTING = "EXING"
ff448d43   Jeremy   Update
798
    EXECUTED = "EXD"
ddf59dd4   haribo   Remaniement :
799
    REJECTED = "RJTD"
ddf59dd4   haribo   Remaniement :
800
    INVALID = "INVL"
ff448d43   Jeremy   Update
801
802
    CANCELLED = "CNCLD"
    UNPLANNABLE = "UNPLN"
ddf59dd4   haribo   Remaniement :
803
804
805
806
    STATUS_CHOICES = (
        (INCOMPLETE, "Incomplete"),
        (COMPLETE, "Complete"),
        (TOBEPLANNED, "To be planned"),
ff448d43   Jeremy   Update
807
        (PLANNED, "Planned"),
ddf59dd4   haribo   Remaniement :
808
809
810
811
812
813
814
        (UNPLANNABLE, "Unplannable"),
        (PENDING, "Pending"),
        (EXECUTED, "Executed"),
        (EXECUTING, "Executing"),
        (REJECTED, "Rejected"),
        (CANCELLED, "Cancelled"),
        (INVALID, "Invalid"),
ddf59dd4   haribo   Remaniement :
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
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
    )

    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...
859
    # (EP) TODO: C'est pas un pb d'utiliser 2 fois le meme nom "shs" pour 2 choses differentes ???!!!
ddf59dd4   haribo   Remaniement :
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
    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...
881
882
883
884
885
    OPEN = "OPEN"
    CLOSE = "CLOSE"
    ON = "ON"
    OFF = "OFF"

ce470283   Jeremy   Plc simulator fin...
886
    global_status = models.CharField(max_length=255, blank=True, null=True)
ddf59dd4   haribo   Remaniement :
887
888
889
890
891
    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...
892
893
    shutter = models.FloatField(blank=True, null=True)
    pressure = models.FloatField(blank=True, null=True)
fe5613f5   jeremy   Update plc protocol
894
    humidity = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
895
896
897
898
899
900
901

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

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

ce470283   Jeremy   Plc simulator fin...
904
905
906
    # TODO
    def setGlobalStatus(self):
        self.global_status = ""
678838ed   Jeremy   Weather ans insid...
907
        if self.doors and self.doors.find("open") != -1:
ce470283   Jeremy   Plc simulator fin...
908
909
910
            self.global_status += "DOOR_OPEN "
        if self.lights and self.lights == "on":
            self.global_status += "LIGHTS_ON "
678838ed   Jeremy   Weather ans insid...
911
        if self.temperature and float(self.temperature) > 40:
ce470283   Jeremy   Plc simulator fin...
912
            self.global_status += "TOO_HOT "
678838ed   Jeremy   Weather ans insid...
913
        if self.humidity and float(self.humidity) > 80:
ce470283   Jeremy   Plc simulator fin...
914
915
916
917
918
            self.global_status += "HUMIDITY_TOO_HIGH "
        if self.global_status == "":
            self.global_status = "OK"
        return 0

fe5613f5   jeremy   Update plc protocol
919
    # TODO HANDLE FLAT LAMPS ...
ce470283   Jeremy   Plc simulator fin...
920
    def setAttribute(self, key, value):
678838ed   Jeremy   Weather ans insid...
921
        self.doors = ""
fe5613f5   jeremy   Update plc protocol
922
        if key == "InsideHumidity":
ce470283   Jeremy   Plc simulator fin...
923
            self.humidity = value
fe5613f5   jeremy   Update plc protocol
924
        elif key == "Pressure":
ce470283   Jeremy   Plc simulator fin...
925
            self.pressure = value
d66e0d93   Quentin Durand   observatory statu...
926
927
        elif key == "InsideTemp":
            self.temperature = value
ce470283   Jeremy   Plc simulator fin...
928
929
930
931
        else:
            return 1
        return 0

ddf59dd4   haribo   Remaniement :
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

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))


5e45ba9f   Etienne Pallier   Bye Bye Celery (f...
957
#TODO: à virer car utilisé pour Celery (ou bien à utiliser pour les agents)
ddf59dd4   haribo   Remaniement :
958
959
960
961
962
963
964
965
966
967
968
969
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...
970

ddf59dd4   haribo   Remaniement :
971

abfb02e2   Jeremy   Device Model is n...
972
973
974
class Telescope(Device):
    TELESCOPE = "Telescope"

ddf59dd4   haribo   Remaniement :
975
976
    mount_type = models.CharField(max_length=9, blank=True, null=True)
    diameter = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
    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)
ddf59dd4   haribo   Remaniement :
994
995
996
997
998
    class Meta:
        managed = True
        db_table = 'telescope'

    def __str__(self):
f7dd3df1   Jeremy   Update simulators...
999
        return (self.name)
ddf59dd4   haribo   Remaniement :
1000
1001


a5f1e984   Etienne Pallier   cleanup common/mo...
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
class TelescopeCommand(models.Model):
    created = models.DateTimeField(blank=True, null=True, auto_now_add=True)
    answered = models.DateTimeField(blank=True, null=True)
    request = models.CharField(blank=False, null=False, max_length=255)
    answer = models.TextField(null=True, blank=True)
    class Meta:
        managed = True
        db_table = "telescopecommand"

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


ddf59dd4   haribo   Remaniement :
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
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...
1042

ddf59dd4   haribo   Remaniement :
1043
class WeatherWatch(models.Model):
c53a13e0   Jeremy   Updating a lot of...
1044
1045
1046
    WIND_LIMIT = 100
    RAIN_LIMIT = 5

ce470283   Jeremy   Plc simulator fin...
1047
1048
1049
    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 :
1050
    wind = models.FloatField(blank=True, null=True)
fe5613f5   jeremy   Update plc protocol
1051
    wind_dir = models.CharField(max_length=45, blank=True, null=True)
ce470283   Jeremy   Plc simulator fin...
1052
    temperature = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
1053
1054
    pressure = models.FloatField(blank=True, null=True)
    rain = models.FloatField(blank=True, null=True)
ce470283   Jeremy   Plc simulator fin...
1055
    cloud = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
1056
1057
1058
1059
1060
1061
1062

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

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

ce470283   Jeremy   Plc simulator fin...
1065
1066
    # TODO
    def setGlobalStatus(self):
fac9194f   Patrick Maeght   get_sensor set d...
1067
        #print(self.rain)
ce470283   Jeremy   Plc simulator fin...
1068
        self.global_status = ""
e15030dc   Patrick Maeght   penelope work part 2
1069
        if self.rain and float(self.rain) > 0:
ce470283   Jeremy   Plc simulator fin...
1070
            self.global_status += "RAINING "
678838ed   Jeremy   Weather ans insid...
1071
        if self.wind and float(self.wind) > 80:
ce470283   Jeremy   Plc simulator fin...
1072
            self.global_status += "WIND_TOO_STRONG "
678838ed   Jeremy   Weather ans insid...
1073
        if self.humidity and float(self.humidity) > 80:
ce470283   Jeremy   Plc simulator fin...
1074
            self.global_status += "HUMIDITY_TOO_HIGH "
678838ed   Jeremy   Weather ans insid...
1075
        if self.cloud and float(self.cloud) > 10:
ce470283   Jeremy   Plc simulator fin...
1076
1077
1078
1079
1080
1081
            self.global_status += "TOO_MUCH_CLOUDY "
        if self.global_status == "":
            self.global_status = "OK"
        return 0

    def setAttribute(self, key, value):
e15030dc   Patrick Maeght   penelope work part 2
1082
        if key == "Rain_boolean":
ce470283   Jeremy   Plc simulator fin...
1083
            self.rain = value
e15030dc   Patrick Maeght   penelope work part 2
1084
        elif key == "_CloudRate":
ce470283   Jeremy   Plc simulator fin...
1085
            self.cloud = value
e15030dc   Patrick Maeght   penelope work part 2
1086
        elif key == "Wind_speed":
ce470283   Jeremy   Plc simulator fin...
1087
            self.wind = value
e15030dc   Patrick Maeght   penelope work part 2
1088
        elif key == "Wind_direction":
ce470283   Jeremy   Plc simulator fin...
1089
            self.wind_dir = value
e15030dc   Patrick Maeght   penelope work part 2
1090
        elif key == "Temperature_outside":
ce470283   Jeremy   Plc simulator fin...
1091
            self.temperature = value
e15030dc   Patrick Maeght   penelope work part 2
1092
        elif key == "Humidity_outside":
ce470283   Jeremy   Plc simulator fin...
1093
            self.humidity = value
e15030dc   Patrick Maeght   penelope work part 2
1094
        elif key == "_Pressure":
ce470283   Jeremy   Plc simulator fin...
1095
1096
1097
1098
1099
            self.pressure = value
        else:
            return 1
        return 0

ddf59dd4   haribo   Remaniement :
1100
1101
1102

class WeatherWatchHistory(models.Model):
    datetime = models.DateTimeField(blank=True, null=True, auto_now_add=True)
e31b2208   theophile.puhl@epitech.eu   Severals Changes ...
1103
    humid_int = models.FloatField(blank=True, null=True)
ddf59dd4   haribo   Remaniement :
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
    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 ...

e31b2208   theophile.puhl@epitech.eu   Severals Changes ...

e6eb923f   Quentin Durand   Prototype agent t...

e6eb923f   Quentin Durand   Prototype agent t...