models.py 3.33 KB
Newer Older
1
# Copyright 2012, 2013 GRNET S.A. All rights reserved.
Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
#
# Redistribution and use in source and binary forms, with or
# without modification, are permitted provided that the following
# conditions are met:
#
#   1. Redistributions of source code must retain the above
#      copyright notice, this list of conditions and the following
#      disclaimer.
#
#   2. Redistributions in binary form must reproduce the above
#      copyright notice, this list of conditions and the following
#      disclaimer in the documentation and/or other materials
#      provided with the distribution.
#
# THIS SOFTWARE IS PROVIDED BY GRNET S.A. ``AS IS'' AND ANY EXPRESS
# OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
# WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
# PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL GRNET S.A OR
# CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
# SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
# LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
# USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
# AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
# LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
# ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
# POSSIBILITY OF SUCH DAMAGE.
#
# The views and conclusions contained in the software and
# documentation are those of the authors and should not be
# interpreted as representing official policies, either expressed
# or implied, of GRNET S.A.

34
from django.db.models import (Model, BigIntegerField, CharField, DateTimeField,
35
                              ForeignKey, AutoField)
36

Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
37

38
39
class Holding(Model):

Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
40
41
42
    holder = CharField(max_length=4096, db_index=True)
    source = CharField(max_length=4096, null=True)
    resource = CharField(max_length=4096, null=False)
43

44
45
46
    limit = BigIntegerField()
    usage_min = BigIntegerField(default=0)
    usage_max = BigIntegerField(default=0)
47
48

    class Meta:
49
        unique_together = (('holder', 'source', 'resource'),)
50
51
52
53


class Commission(Model):

Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
54
    serial = AutoField(primary_key=True)
55
    name = CharField(max_length=4096, default="")
Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
56
    clientkey = CharField(max_length=4096, null=False)
57
    issue_datetime = DateTimeField()
Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
58

59
60
61

class Provision(Model):

Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
62
63
64
65
66
67
    serial = ForeignKey(Commission,
                        to_field='serial',
                        related_name='provisions')
    holder = CharField(max_length=4096, db_index=True)
    source = CharField(max_length=4096, null=True)
    resource = CharField(max_length=4096, null=False)
68

69
    quantity = BigIntegerField()
70

71
    def todict(self):
72
73
74
        return {'holder':   self.holder,
                'source':   self.source,
                'resource': self.resource,
75
76
77
                'quantity': self.quantity,
                }

78
79
80
    def holding_key(self):
        return (self.holder, self.source, self.resource)

81

Georgios D. Tsoukalas's avatar
Georgios D. Tsoukalas committed
82
83
class ProvisionLog(Model):

Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
84
    serial = BigIntegerField()
85
    name = CharField(max_length=4096)
86
87
    issue_time = CharField(max_length=4096)
    log_time = CharField(max_length=4096)
Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
88
89
90
    holder = CharField(max_length=4096)
    source = CharField(max_length=4096, null=True)
    resource = CharField(max_length=4096)
91
92
93
94
    limit = BigIntegerField()
    usage_min = BigIntegerField()
    usage_max = BigIntegerField()
    delta_quantity = BigIntegerField()
Giorgos Korfiatis's avatar
Giorgos Korfiatis committed
95
    reason = CharField(max_length=4096)