Statistics
| Branch: | Tag: | Revision:

root / snf-astakos-app / astakos / quotaholder / models.py @ 68b991bc

History | View | Annotate | Download (3.7 kB)

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

    
34
from datetime import datetime
35
from snf_django.lib.db.fields import intDecimalField
36

    
37
from django.db.models import (Model, BigIntegerField, CharField,
38
                              ForeignKey, AutoField)
39
from django.db import transaction
40
from snf_django.lib.db.managers import ForUpdateManager
41

    
42

    
43
class Holding(Model):
44

    
45
    holder = CharField(max_length=4096, db_index=True)
46
    source = CharField(max_length=4096, null=True)
47
    resource = CharField(max_length=4096, null=False)
48

    
49
    limit = intDecimalField()
50
    usage_min = intDecimalField(default=0)
51
    usage_max = intDecimalField(default=0)
52

    
53
    objects = ForUpdateManager()
54

    
55
    class Meta:
56
        unique_together = (('holder', 'source', 'resource'),)
57

    
58

    
59
def now():
60
    return datetime.utcnow().strftime('%Y-%m-%dT%H:%M:%S.%f')[:24]
61

    
62

    
63
class Commission(Model):
64

    
65
    serial = AutoField(primary_key=True)
66
    name = CharField(max_length=4096, default="")
67
    clientkey = CharField(max_length=4096, null=False)
68
    issue_time = CharField(max_length=24)
69

    
70
    objects = ForUpdateManager()
71

    
72

    
73
class Provision(Model):
74

    
75
    serial = ForeignKey(Commission,
76
                        to_field='serial',
77
                        related_name='provisions')
78
    holder = CharField(max_length=4096, db_index=True)
79
    source = CharField(max_length=4096, null=True)
80
    resource = CharField(max_length=4096, null=False)
81

    
82
    quantity = intDecimalField()
83

    
84
    objects = ForUpdateManager()
85

    
86
    def todict(self):
87
        return {'holder':   self.holder,
88
                'source':   self.source,
89
                'resource': self.resource,
90
                'quantity': self.quantity,
91
                }
92

    
93
    def holding_key(self):
94
        return (self.holder, self.source, self.resource)
95

    
96

    
97
class ProvisionLog(Model):
98

    
99
    serial = BigIntegerField()
100
    name = CharField(max_length=4096)
101
    issue_time = CharField(max_length=4096)
102
    log_time = CharField(max_length=4096)
103
    holder = CharField(max_length=4096)
104
    source = CharField(max_length=4096, null=True)
105
    resource = CharField(max_length=4096)
106
    limit = intDecimalField()
107
    usage_min = intDecimalField()
108
    usage_max = intDecimalField()
109
    delta_quantity = intDecimalField()
110
    reason = CharField(max_length=4096)
111

    
112
    objects = ForUpdateManager()