class virtual_domains(db.Model):
__tablename__ = 'virtual_domains'
out = "std"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(100))
def __init__(self, out, id, name):
self.id = id
self.name = name
self.out = out
def __repr__(self):
if self.out == "std":
return '{"id": %d , "name": "%s" }' % (self.id, self.name)
else:
return '<vdom( %d , "%s" )' % (self.id, self.name)
class virtual_aliases(db.Model):
__tablename__ = 'virtual_aliases'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
domain_id = db.Column(db.Integer, default=0, nullable=False)
source = db.Column(db.String(100), nullable=False)
destination = db.Column(db.String(100), nullable=False)
def __init__(self, id, domain_id, destination):
self.id = id
self.domain_id = domain_id
self.source = source
self.destination = destination
def __repr__(self):
return '{"id" : %d, "domain_id": %d ,"source": %s, "destination": %s}' % (
self.id, self.domain_id, self.source, self.destination)
class virtual_users(db.Model):
__tablename__ = 'virtual_users'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
domain_id = db.Column(db.Integer, default=0, nullable=False)
password = db.Column(db.String(106), nullable=False)
email = db.Column(db.String(100), nullable=False)
name = db.Column(db.String(100), nullable=False)
def __init__(self, id, name, domain_id, password, email):
self.id = id
self.name = name
self.domain_id = domain_id
self.password = password
self.email = email
def __repr__(self):
return '{"id" : %d, "domain_id": %d ,"email": %s, "name": %s}' % (
self.id, self.domain_id, self.email, self.name)
class User(UserMixin, db.Model):
__tablename__ = "tUser"
__table_args__ = {'extend_existing': True}
id = db.Column(db.String(36),
primary_key=True,
index=True,
unique=True,
nullable=False)
username = db.Column(db.String(64), index=True, unique=True)
email = db.Column(db.String(120), index=True, unique=True)
password_hash = db.Column(db.String(128))
role = db.Column(db.String(128)) #for later purpose
def set_password(self, password):
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
def __repr__(self):
return '<User {}>'.format(self.username)
class CovidTracking(db.Model):
__tablename__ = "tCovidTracking"
__jsonName__ = "covidtrackings"
__curratedValue__ = {
'refDistributionPointId': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'firstname': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'lastname': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'telephone': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'email': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'numberOfPerson': {
'isMandatory': True,
'forbidenvalues': [None, '']
}
}
__unicityCriteria__ = [] #
__unicityCriteriaOr__ = [] # unicity is telephone OR email.
__publicNoLoadOptions__ = []
__checkReferenceFields__ = {'refDistributionPointId': DistributionPoint}
# mandatory
id = db.Column(db.String(36),
primary_key=True,
index=True,
unique=True,
nullable=False)
# fiels
firstname = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
lastname = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
telephone = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
email = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
numberOfPerson = db.Column(db.Integer,
index=False,
unique=False,
nullable=False)
# references
refDistributionPointId = db.Column(db.String(36),
db.ForeignKey('tDistributionPoint.id'),
index=False,
nullable=False)
# children
# traceability
created_on = db.Column(db.DateTime, server_default=db.func.now())
updated_on = db.Column(db.DateTime,
server_default=db.func.now(),
server_onupdate=db.func.now())
def __repr__(self):
return '<object id={}>'.format(id)
@property
def serialize_public(self):
return {
'id': self.id,
'firstname': self.firstname,
'lastname': self.lastname,
'telephone': self.telephone,
'email': self.email,
'numberOfPerson': self.numberOfPerson,
}
@property
def serialize(self):
return {
'id': self.id,
'created_on': self.created_on.strftime(variables.DATETIME_PATTERN),
'updated_on': self.updated_on.strftime(variables.DATETIME_PATTERN),
'firstname': self.firstname,
'lastname': self.lastname,
'telephone': self.telephone,
'email': self.email,
'numberOfPerson': self.numberOfPerson,
'refDistributionPoint': self.refDistributionPointId
}
class RecurringSlotsTemplate(db.Model):
__tablename__ = "tRecurringSlotsTemplate"
__jsonName__ = "RecurringSlotsTemplate"
__curratedValue__ = {
'name': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'slotLength': {
'isMandatory': True,
'forbidenvalues': [''],
'allowedvalues': [0, 15, 30, 45, 60, 90, 120, 150, 180, 210, 240]
},
'slotCapacity': {
'isMandatory': True,
'forbidenvalues': [0, '']
},
'description': {
'isMandatory': False,
'replaceValue': '',
'forbidenvalues': [None]
}
}
__unicityCriteria__ = ['name']
__unicityCriteriaOr__ = []
__publicNoLoadOptions__ = []
__checkReferenceFields__ = {}
# mandatory
id = db.Column(db.String(36),
primary_key=True,
index=True,
unique=True,
nullable=False)
#fiels
name = db.Column(db.String(255), index=False, unique=False, nullable=False)
description = db.Column(db.String(255),
index=False,
unique=False,
nullable=True)
slotLength = db.Column(db.Integer,
index=False,
unique=False,
nullable=False)
slotCapacity = db.Column(db.Integer,
index=False,
unique=False,
nullable=False)
# traceability
created_on = db.Column(db.DateTime, server_default=db.func.now())
updated_on = db.Column(db.DateTime,
server_default=db.func.now(),
server_onupdate=db.func.now())
def __repr__(self):
return '<object id={}>'.format(id)
@property
def serialize_public(self):
return self.serialize
@property
def serialize(self):
return {
'id': self.id,
'created_on': self.created_on.strftime(variables.DATETIME_PATTERN),
'updated_on': self.updated_on.strftime(variables.DATETIME_PATTERN),
'name': self.name,
'description': self.description,
'slotCapacity': self.slotCapacity,
'slotLength': self.slotLength
}
class BookableSlot(db.Model):
__tablename__ = "tBookableSlot"
__jsonName__ = "bookableslot"
__curratedValue__ = {
'dateStart': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'dateEnd': {
'isMandatory': False,
'forbidenvalues': []
},
'maxCapacity': {
'isMandatory': True,
'forbidenvalues': [0, '']
},
'refDistributionPointId': {
'isMandatory': True,
'forbidenvalues': [None, '']
}
}
__unicityCriteria__ = ['refDistributionPointId', 'dateStart'] #
__unicityCriteriaOr__ = [] #
__publicNoLoadOptions__ = [
'openingHoursTemplate', 'recurringSlotsTemplate'
]
__checkReferenceFields__ = {'refDistributionPointId': DistributionPoint}
# mandatory
id = db.Column(db.String(36),
primary_key=True,
index=True,
unique=True,
nullable=False)
# fiels
dateStart = db.Column(db.DateTime,
index=False,
unique=False,
nullable=False)
dateEnd = db.Column(db.DateTime, index=False, unique=False, nullable=False)
maxCapacity = db.Column(db.Integer,
index=False,
unique=False,
nullable=False)
currentCapacity = db.Column(db.Integer,
index=False,
unique=False,
nullable=False)
# references
refDistributionPointId = db.Column(db.String(36),
db.ForeignKey('tDistributionPoint.id'),
index=False,
nullable=False)
# children
bookedSlots = db.relationship(
'BookedSlot',
primaryjoin="and_(BookedSlot.refBookableSlotId==BookableSlot.id)",
backref="tBookableSlot")
# traceability
created_on = db.Column(db.DateTime, server_default=db.func.now())
updated_on = db.Column(db.DateTime,
server_default=db.func.now(),
server_onupdate=db.func.now())
def __repr__(self):
return '<object id={}>'.format(id)
@property
def serialize_public(self):
return {
'id': self.id,
'created_on': self.created_on.strftime(variables.DATETIME_PATTERN),
'updated_on': self.updated_on.strftime(variables.DATETIME_PATTERN),
'dateStart': self.dateStart.strftime(variables.DATETIME_PATTERN),
'dateEnd': self.dateEnd.strftime(variables.DATETIME_PATTERN),
'maxCapacity': self.maxCapacity,
'currentCapacity': self.currentCapacity,
'refDistributionPointId': self.refDistributionPointId
}
@property
def serialize(self):
return {
'id': self.id,
'created_on': self.created_on.strftime(variables.DATETIME_PATTERN),
'updated_on': self.updated_on.strftime(variables.DATETIME_PATTERN),
'dateStart': self.dateStart.strftime(variables.DATETIME_PATTERN),
'dateEnd': self.dateEnd.strftime(variables.DATETIME_PATTERN),
'maxCapacity': self.maxCapacity,
'currentCapacity': self.currentCapacity,
'refDistributionPointId': self.refDistributionPointId,
'bookedSlots': [item.serialize for item in self.bookedSlots]
}
class DistributionPoint(db.Model):
__tablename__ = "tDistributionPoint"
__jsonName__ = "distributionpoint"
__curratedValue__ = {
'name': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'description': {
'isMandatory': False,
'replaceValue': '',
'forbidenvalues': []
},
'logoUrl': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'telephone': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'email': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'maxCapacity': {
'isMandatory': True,
'forbidenvalues': [None, 0]
},
'refAddressId': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'refDistributionOwnerId': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'refOpeningHoursTemplateId': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'refRecurringSlotsTemplateId': {
'isMandatory': True,
'forbidenvalues': [None, '']
}
}
__unicityCriteria__ = [] #
__unicityCriteriaOr__ = ['telephone', 'email']
__publicNoLoadOptions__ = [
'openingHoursTemplate', 'recurringSlotsTemplate'
]
__checkReferenceFields__ = {
'refDistributionOwnerId': DistributionOwner,
'refOpeningHoursTemplateId': OpeningHoursTemplate,
'refRecurringSlotsTemplateId': RecurringSlotsTemplate,
'refAddressId': Address
}
# mandatory
id = db.Column(db.String(36),
primary_key=True,
index=True,
unique=True,
nullable=False)
#fiels
name = db.Column(db.String(255), index=False, unique=False, nullable=False)
description = db.Column(db.String(255),
index=False,
unique=False,
nullable=True)
logoUrl = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
telephone = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
email = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
maxCapacity = db.Column(db.Integer,
index=False,
unique=False,
nullable=False)
# references & children
refAddressId = db.Column(db.String(36),
db.ForeignKey('tAddress.id'),
index=False,
nullable=False)
address = db.relationship(
'Address',
primaryjoin="and_(DistributionPoint.refAddressId==Address.id)",
backref="tDistributionPoint")
refDistributionOwnerId = db.Column(db.String(36),
db.ForeignKey('tDistributionOwner.id'),
index=False,
nullable=False)
refOpeningHoursTemplateId = db.Column(
db.String(36),
db.ForeignKey('tOpeningHoursTemplate.id'),
index=False,
nullable=False)
openingHoursTemplate = db.relationship(
'OpeningHoursTemplate',
primaryjoin=
"and_(DistributionPoint.refOpeningHoursTemplateId==OpeningHoursTemplate.id)",
backref="tDistributionPoint")
refRecurringSlotsTemplateId = db.Column(
db.String(36),
db.ForeignKey('tRecurringSlotsTemplate.id'),
index=False,
nullable=False)
recurringSlotsTemplate = db.relationship(
'RecurringSlotsTemplate',
primaryjoin=
"and_(DistributionPoint.refRecurringSlotsTemplateId==RecurringSlotsTemplate.id)",
backref="tDistributionPoint")
# children
# traceability
created_on = db.Column(db.DateTime, server_default=db.func.now())
updated_on = db.Column(db.DateTime,
server_default=db.func.now(),
server_onupdate=db.func.now())
def __repr__(self):
return '<object id={}>'.format(id)
@property
def serialize(self):
return {
'id': self.id,
'created_on': self.created_on.strftime(variables.DATETIME_PATTERN),
'updated_on': self.updated_on.strftime(variables.DATETIME_PATTERN),
'name': self.name,
'description': self.description,
'logoUrl': self.logoUrl,
'telephone': self.telephone,
'email': self.email,
'maxCapacity': self.maxCapacity,
'address': self.address.serialize,
'refAddressId': self.refAddressId,
'refDistributionOwnerId': self.refDistributionOwnerId,
'refOpeningHoursTemplate': self.refOpeningHoursTemplateId,
'refRecurringSlotsTemplateId': self.refRecurringSlotsTemplateId,
'openingHoursTemplate': self.openingHoursTemplate.serialize,
'recurringSlotsTemplate': self.recurringSlotsTemplate.serialize
}
@property
def serialize_public(self):
return {
'id': self.id,
'created_on': self.created_on.strftime(variables.DATETIME_PATTERN),
'updated_on': self.updated_on.strftime(variables.DATETIME_PATTERN),
'name': self.name,
'description': self.description,
'logoUrl': self.logoUrl,
'telephone': self.telephone,
'email': self.email,
'maxCapacity': self.maxCapacity,
'address': self.address.serialize
}
class DistributionOwner(db.Model):
__tablename__ = "tDistributionOwner"
__jsonName__ = "distributionowner"
__curratedValue__ = {
'name': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'description': {
'isMandatory': False,
'replaceValue': '',
'forbidenvalues': []
},
'logoUrl': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'telephone': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'email': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'refAddressId': {
'isMandatory': True,
'forbidenvalues': [None, '']
}
}
__unicityCriteria__ = [] #
__unicityCriteriaOr__ = ['telephone',
'email'] # unicity is telephone OR email.
__publicNoLoadOptions__ = ['distributionPoints']
__checkReferenceFields__ = {'refAddressId': Address}
# mandatory
id = db.Column(db.String(36),
primary_key=True,
index=True,
unique=True,
nullable=False)
#fiels
name = db.Column(db.String(255), index=False, unique=False, nullable=False)
description = db.Column(db.String(255),
index=False,
unique=False,
nullable=True)
logoUrl = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
telephone = db.Column(db.String(255),
index=False,
unique=True,
nullable=False)
email = db.Column(db.String(255), index=False, unique=True, nullable=False)
# references & children
refAddressId = db.Column(db.String(36),
db.ForeignKey('tAddress.id'),
index=False,
nullable=False)
# children
address = db.relationship(
'Address',
primaryjoin="and_(DistributionOwner.refAddressId==Address.id)",
backref="tDistributionOwner")
distributionPoints = db.relationship(
'DistributionPoint',
primaryjoin=
"and_(DistributionPoint.refDistributionOwnerId==DistributionOwner.id)",
backref="tDistributionOwner")
# traceability
created_on = db.Column(db.DateTime, server_default=db.func.now())
updated_on = db.Column(db.DateTime,
server_default=db.func.now(),
server_onupdate=db.func.now())
def __repr__(self):
return '<object id={} - Name={} >'.format(id, self.name)
@property
def serialize_public(self):
return self.serialize
@property
def serialize(self):
return {
'id':
self.id,
'created_on':
self.created_on.strftime(variables.DATETIME_PATTERN),
'updated_on':
self.updated_on.strftime(variables.DATETIME_PATTERN),
'name':
self.name,
'description':
self.description,
'logoUrl':
self.logoUrl,
'telephone':
self.telephone,
'email':
self.email,
'address':
self.address.serialize,
'distributionPoints':
[item.serialize for item in self.distributionPoints]
}
class Address(db.Model):
__tablename__ = "tAddress"
__jsonName__ = "Address"
__curratedValue__ = {
'street': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'number': {
'isMandatory': False,
'replaceValue': '',
'forbidenvalues': [0, None, '']
},
'zipcode': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
"city": {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'country': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'state': {
'isMandatory': True,
'forbidenvalues': [None, '']
}
}
__unicityCriteria__ = [] # means an address is not unique
__unicityCriteriaOr__ = []
__publicNoLoadOptions__ = []
__checkReferenceFields__ = {}
# mandatory
id = db.Column(db.String(36),
primary_key=True,
index=True,
unique=True,
nullable=False)
# fiels
street = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
number = db.Column(db.String(10), index=False, unique=False, nullable=True)
zipcode = db.Column(db.String(10),
index=False,
unique=False,
nullable=False)
city = db.Column(db.String(255), index=False, unique=False, nullable=False)
country = db.Column(db.String(255),
index=False,
unique=False,
nullable=False)
state = db.Column(db.String(255), index=False, unique=False, nullable=True)
# references
# traceability
created_on = db.Column(db.DateTime, server_default=db.func.now())
updated_on = db.Column(db.DateTime,
server_default=db.func.now(),
server_onupdate=db.func.now())
def __repr__(self):
return '<object id={}>'.format(id)
@property
def serialize_public(self):
return self.serialize
@property
def serialize(self):
return {
'id': self.id,
'street': self.street,
'number': self.number,
'zipcode': self.zipcode,
'city': self.city,
'country': self.country,
'state': self.state,
'created_on': self.created_on.strftime(variables.DATETIME_PATTERN),
'updated_on': self.updated_on.strftime(variables.DATETIME_PATTERN)
}
class OpeningHoursTemplate(db.Model):
__tablename__ = "tOpeningHoursTemplate"
__jsonName__ = "OpeningHoursTemplate"
__curratedValue__ = {
'name': {
'isMandatory': True,
'forbidenvalues': [None, '']
},
'mon': {
'isMandatory': False,
'replaceValue': '///',
'forbidenvalues': [None]
},
'tue': {
'isMandatory': False,
'replaceValue': '///',
'forbidenvalues': [None]
},
'wed': {
'isMandatory': False,
'replaceValue': '///',
'forbidenvalues': [None]
},
'thu': {
'isMandatory': False,
'replaceValue': '///',
'forbidenvalues': [None]
},
'fri': {
'isMandatory': False,
'replaceValue': '///',
'forbidenvalues': [None]
},
'sat': {
'isMandatory': False,
'replaceValue': '///',
'forbidenvalues': [None]
},
'sun': {
'isMandatory': False,
'replaceValue': '///',
'forbidenvalues': [None]
},
'description': {
'isMandatory': False,
'replaceValue': '',
'forbidenvalues': [None]
}
}
__unicityCriteria__ = ['name']
__unicityCriteriaOr__ = []
__publicNoLoadOptions__ = []
__checkReferenceFields__ = {}
# mandatory
id = db.Column(db.String(36),
primary_key=True,
index=True,
unique=True,
nullable=False)
#fiels
name = db.Column(db.String(255), index=False, unique=False, nullable=False)
description = db.Column(db.String(255),
index=False,
unique=False,
nullable=True)
# Each configuration must be a json structure of kind
mon = db.Column(db.String(255),
index=False,
unique=False,
nullable=True,
default="///")
tue = db.Column(db.String(255),
index=False,
unique=False,
nullable=True,
default="///")
wed = db.Column(db.String(255),
index=False,
unique=False,
nullable=True,
default="///")
thu = db.Column(db.String(255),
index=False,
unique=False,
nullable=True,
default="///")
fri = db.Column(db.String(255),
index=False,
unique=False,
nullable=True,
default="///")
sat = db.Column(db.String(255),
index=False,
unique=False,
nullable=True,
default="///")
sun = db.Column(db.String(255),
index=False,
unique=False,
nullable=True,
default="///")
# references
# children
#openingHoursDetails = db.relationship('OpeningHoursDetails',
# primaryjoin="and_(OpeningHoursDetails.refOpeningHoursTemplateId==OpeningHoursTemplate.id)",
# backref="tOpeningHoursTemplate")
# traceability
created_on = db.Column(db.DateTime, server_default=db.func.now())
updated_on = db.Column(db.DateTime,
server_default=db.func.now(),
server_onupdate=db.func.now())
def __repr__(self):
return '<object id={}>'.format(id)
@property
def serialize_public(self):
return self.serialize
@property
def serialize(self):
return {
'id': self.id,
'name': self.name,
'description': self.description,
'mon': self.mon,
'tue': self.tue,
'wed': self.wed,
'thu': self.thu,
'fri': self.fri,
'sat': self.sat,
'sun': self.sun,
'created_on': self.created_on.strftime(variables.DATETIME_PATTERN),
'updated_on': self.updated_on.strftime(variables.DATETIME_PATTERN)
}
