root / snf-astakos-app / astakos / quotaholder_app / models.py @ 2e7924de
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 snf_django.lib.db.managers import ForUpdateManager |
40 |
|
41 |
|
42 |
class Holding(Model): |
43 |
|
44 |
holder = CharField(max_length=4096, db_index=True) |
45 |
source = CharField(max_length=4096, null=True) |
46 |
resource = CharField(max_length=4096, null=False) |
47 |
|
48 |
limit = intDecimalField() |
49 |
usage_min = intDecimalField(default=0)
|
50 |
usage_max = intDecimalField(default=0)
|
51 |
|
52 |
objects = ForUpdateManager() |
53 |
|
54 |
class Meta: |
55 |
unique_together = (('holder', 'source', 'resource'),) |
56 |
|
57 |
|
58 |
def now(): |
59 |
return datetime.utcnow().strftime('%Y-%m-%dT%H:%M:%S.%f')[:24] |
60 |
|
61 |
|
62 |
class Commission(Model): |
63 |
|
64 |
serial = AutoField(primary_key=True)
|
65 |
name = CharField(max_length=4096, default="") |
66 |
clientkey = CharField(max_length=4096, null=False) |
67 |
issue_time = CharField(max_length=24)
|
68 |
|
69 |
objects = ForUpdateManager() |
70 |
|
71 |
|
72 |
class Provision(Model): |
73 |
|
74 |
serial = ForeignKey(Commission, |
75 |
to_field='serial',
|
76 |
related_name='provisions')
|
77 |
holder = CharField(max_length=4096, db_index=True) |
78 |
source = CharField(max_length=4096, null=True) |
79 |
resource = CharField(max_length=4096, null=False) |
80 |
|
81 |
quantity = intDecimalField() |
82 |
|
83 |
objects = ForUpdateManager() |
84 |
|
85 |
def todict(self): |
86 |
return {'holder': self.holder, |
87 |
'source': self.source, |
88 |
'resource': self.resource, |
89 |
'quantity': self.quantity, |
90 |
} |
91 |
|
92 |
def holding_key(self): |
93 |
return (self.holder, self.source, self.resource) |
94 |
|
95 |
|
96 |
class ProvisionLog(Model): |
97 |
|
98 |
serial = BigIntegerField() |
99 |
name = CharField(max_length=4096)
|
100 |
issue_time = CharField(max_length=4096)
|
101 |
log_time = CharField(max_length=4096)
|
102 |
holder = CharField(max_length=4096)
|
103 |
source = CharField(max_length=4096, null=True) |
104 |
resource = CharField(max_length=4096)
|
105 |
limit = intDecimalField() |
106 |
usage_min = intDecimalField() |
107 |
usage_max = intDecimalField() |
108 |
delta_quantity = intDecimalField() |
109 |
reason = CharField(max_length=4096)
|
110 |
|
111 |
objects = ForUpdateManager() |