Synnefo

# Copyright 2012, 2013 GRNET S.A. All rights reserved.

#

# 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.

from synnefo.lib.db.intdecimalfield import intDecimalField

from django.db.models import (Model, BigIntegerField, CharField,

                              ForeignKey, AutoField)

from django.db import transaction

from synnefo.lib.db.managers import ForUpdateManager

class Holding(Model):

    holder      =   CharField(max_length=4096, db_index=True)

    resource    =   CharField(max_length=4096, null=False)

    capacity    =   intDecimalField()

    flags       =   BigIntegerField(null=False, default=0)

    imported_min    =   intDecimalField(default=0)

    imported_max    =   intDecimalField(default=0)

    stock_min       =   intDecimalField(default=0)

    stock_max       =   intDecimalField(default=0)

    objects     =   ForUpdateManager()

    class Meta:

        unique_together = (('holder', 'resource'),)

from datetime import datetime

def now():

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

class Commission(Model):

    serial      =   AutoField(primary_key=True)

    holder      =   CharField(max_length=4096, db_index=True)

    name        =   CharField(max_length=4096, null=True)

    clientkey   =   CharField(max_length=4096, null=False)

    issue_time  =   CharField(max_length=24, default=now)

    objects     =   ForUpdateManager()

class Provision(Model):

    serial      =   ForeignKey( Commission,

                                to_field='serial',

                                related_name='provisions'   )

    holder      =   CharField(max_length=4096, db_index=True, null=True)

    resource    =   CharField(max_length=4096, null=False)

    quantity    =   intDecimalField()

    objects     =   ForUpdateManager()

class ProvisionLog(Model):

    serial              =   BigIntegerField()

    source              =   CharField(max_length=4096, null=True)

    target              =   CharField(max_length=4096)

    name                =   CharField(max_length=4096)

    issue_time          =   CharField(max_length=4096)

    log_time            =   CharField(max_length=4096)

    resource            =   CharField(max_length=4096)

    source_capacity     =   intDecimalField(null=True)

    source_imported_min =   intDecimalField(null=True)

    source_imported_max =   intDecimalField(null=True)

    source_stock_min    =   intDecimalField(null=True)

    source_stock_max    =   intDecimalField(null=True)

    target_capacity     =   intDecimalField()

    target_imported_min =   intDecimalField()

    target_imported_max =   intDecimalField()

    target_stock_min    =   intDecimalField()

    target_stock_max    =   intDecimalField()

    delta_quantity      =   intDecimalField()

    reason              =   CharField(max_length=4096)

    objects     =   ForUpdateManager()

def _get(*args, **kwargs):

    model = args[0]

    args = args[1:]

    o = model.objects

    for_update = kwargs.pop('for_update', False)

    f = o.get_for_update if for_update else o.get

    return f(*args, **kwargs)

def _filter(*args, **kwargs):

    model = args[0]

    args = args[1:]

    o = model.objects

    for_update = kwargs.pop('for_update', False)

    q = o.filter(*args, **kwargs)

    q = q.select_for_update() if for_update else q

    return q

def db_get_holding(*args, **kwargs):

    return _get(Holding, *args, **kwargs)

def db_get_commission(*args, **kwargs):

    return _get(Commission, *args, **kwargs)

def db_filter_provision(*args, **kwargs):

    return _filter(Provision, *args, **kwargs)