class DocumentsPhoto(db.Model):
id = db.Column(db.Integer, primary_key=True)
pasportMainPagePhotoURL = db.Column(db.String, unique=True)
pasportRegistrationPagePhotoURL = db.Column(db.String, unique=True)
SNILSPhotoURL = db.Column(db.String, unique=True)
INNPhotoUrl = db.Column(db.String, unique=True)
#courierId = db.Column(db.Integer, db.ForeignKey('courier.id'))
#managerId = db.Column(db.Integer, db.ForeignKey('manager.id'))
courier = db.relationship('Courier',
uselist=False,
backref=db.backref('documentsPhoto'))
manager = db.relationship('Manager',
uselist=False,
backref=db.backref('documentsPhoto'))
def __init__(self,
pasportMainPagePhotoURL=None,
pasportRegistrationPagePhotoURL=None,
SNILSPhotoURL=None,
INNPhotoUrl=None):
super(DocumentsPhoto, self).__init__(pasportMainPagePhotoURL = None, pasportRegistrationPagePhotoURL = None, \
SNILSPhotoURL = None, INNPhotoUrl = None)
self.pasportMainPagePhotoURL = pasportMainPagePhotoURL
self.pasportRegistrationPagePhotoURL = pasportRegistrationPagePhotoURL
self.SNILSPhotoURL = SNILSPhotoURL
self.INNPhotoUrl = INNPhotoUrl
def __repr__(self):
return '<Id {}.\nPhoto pasport: main-{}, \nregistration-{}>'.format(self.id, self.pasportMainPagePhotoURL,\
self.pasportRegistrationPagePhotoURL)
class CourierType(db.Model):
id = db.Column(db.Integer, primary_key = True)
name = db.Column(db.String(140), unique = True)
courierBalanceId = db.Column(db.Integer, db.ForeignKey('courier.id'))
def __init__(self, name = None):
super(CourierType, self).__init__(name = None)
self.name = name
def __repr__(self):
return '<Id: {}. Name: {}>'.format(self.id, self.name)
class OperationStatus(db.Model):
id = db.Column(db.Integer, primary_key = True)
name = db.Column(db.String(140), unique = True)
operationId = db.Column(db.Integer, db.ForeignKey('operation.id'))
def __init__(self, name = None):
super(OperationStatus, self).__init__(name = None)
self.name = name
def __repr__(self):
return '<Id: {}. Name: {}>'.format(self.id, self.name)
class DestinationType(db.Model):
id = db.Column(db.Integer, primary_key = True)
name = db.Column(db.String(140), unique = True)
destinationTypeId = db.Column(db.Integer, db.ForeignKey('issuePoint.id'))
def __init__(self, name = None):
super(DestinationType, self).__init__(name = None)
self.name = name
def __repr__(self):
return '<Id: {}. Name: {}>'.format(self.id, self.name)
class OrderType(db.Model):
id = db.Column(db.Integer, primary_key = True)
name = db.Column(db.String(140), unique = True)
orderId = db.Column(db.Integer, db.ForeignKey('order.id'))
def __init__(self, name = None):
super(OrderType, self).__init__(name = None, orderId = None)
self.name = name
self.orderId = orderId
def __repr__(self):
return '<Id: {}. Name: {}>'.format(self.id, self.name)
class OperationStatus(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(140), unique=True)
issuePoint = db.relationship('Operation',
uselist=False,
backref=db.backref('operationStatus'))
def __init__(self, name=None):
super(OperationStatus, self).__init__(name=None)
self.name = name
def __repr__(self):
return '<Id: {}. Name: {}>'.format(self.id, self.name)
class CourierType(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(140), unique=True)
courier = db.relationship('Courier',
uselist=False,
backref=db.backref('courierType'))
def __init__(self, name=None):
super(CourierType, self).__init__(name=None)
self.name = name
def __repr__(self):
return '<Id: {}. Name: {}>'.format(self.id, self.name)
class OrderStatus(db.Model):
__tablename__ = 'orderStatus'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(140), unique=True)
orders = db.relationship('Order',
uselist=False,
backref=db.backref('orderStatus'))
def __init__(self, name=None):
super(OrderStatus, self).__init__(name=None)
self.name = name
def __repr__(self):
return '<Id: {}. Name: {}>'.format(self.id, self.name)
class DestinationType(db.Model):
__tablename__ = 'destinationType'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(140), unique=True)
issuePoint = db.relationship('IssuePoint',
uselist=False,
backref=db.backref('destinationType'))
def __init__(self, name=None):
super(DestinationType, self).__init__(name=None)
self.name = name
def __repr__(self):
return '<Id: {}. Name: {}>'.format(self.id, self.name)
class Manager(db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(140), unique=True)
name = db.Column(db.String(140))
surname = db.Column(db.String(140))
patronymic = db.Column(db.String(140))
password = db.Column(db.String(140))
phoneNumber = db.Column(db.String(140))
photoUrl = db.Column(db.String(140))
personalInformation = db.relationship('PersonalInformation',
uselist=False,
backref=db.backref('manager'))
documentsPhoto = db.relationship('DocumentsPhoto',
uselist=False,
backref=db.backref('manager'))
lastSeen = db.Column(db.DateTime)
def __init__(self,
name=None,
surname=None,
patronymic=None,
phoneNumber=None,
photoUrl=None,
email=None,
password=None):
super(Manager, self).__init__(name = None, surname = None, patronymic = None, phoneNumber = None, \
photoUrl = None, email = None, password = None)
self.name = name
self.surname = surname
self.patronymic = patronymic
self.phoneNumber = phoneNumber
self.email = email
self.password = password
def is_authenticated(self):
return True
def is_active(self):
return True
def is_anonymous(self):
return False
def get_id(self):
try:
return unicode(self.id) #python 2
except NameError:
return str(self.id) #python 3
def __repr__(self):
return '<Id: {}.\nManager\n{} {} {}. Phone number: {}\n{}>'.format(
self.id, self.surname, self.name, self.patronymic,
self.phoneNumber, self.email)
class Order(db.Model):
id = db.Column(db.Integer, primary_key = True)
orderType = db.relationship('OrderType', uselist = False, backref = db.backref('order'))
clientId = db.Column(db.Integer, db.ForeignKey('client.id'))
courierId = db.Column(db.Integer, db.ForeignKey('courier.id'))
orderStatus = db.relationship('OrderStatus', uselist = False, backref = db.backref('order'))
issuePoint = db.relationship('IssuePoint', backref = db.backref('order'))
operationId = db.Column(db.Integer, db.ForeignKey('operation.id'))
numberOfAddresses = db.Column(db.Integer)
informationAboutAddresses = db.Column(db.Text)
dateOfCreation = db.Column(db.DateTime)
description = db.Column(db.Text)
photoUrl = db.Column(db.String(250))
#dateOfCompletion = db.Column(db.DateTime)
cost = db.Column(db.Integer)
def __init__(self, clientId = None, courierId = None, operationId = None, numberOfAddresses = None, \
informationAboutAddresses = None, description = None, photoUrl = None, \
cost = None):
super(Order, self).__init__(clientId = None, courierId = None, operationId = None, numberOfAddresses = None, \
informationAboutAddresses = None, description = None, photoUrl = None, \
cost = None)
self.clientId = clientId
self.courierId = courierId
self.operationId = operationId
self.numberOfAddresses = numberOfAddresses
self.informationAboutAddresses = informationAboutAddresses
#self.dateOfCreation = datetime.utcnow()
self.description = description
self.photoUrl = photoUrl
#self.dateOfCompletion = dateOfCompletion
self.cost = cost
def is_active(self):
return True
def get_id(self):
try:
return unicode(self.id) #python 2
except NameError:
return str(self.id) #python 3
def __repr__(self):
return '<{}. {}>'.format(self.id, self.description)
class IssuePoint(db.Model):
id = db.Column(db.Integer, primary_key=True)
orders = db.relationship('Order',
uselist=False,
backref=db.backref('issuePoint'))
destinationTypeId = db.Column(db.Integer,
db.ForeignKey('destinationType.id'))
orderNumber = db.Column(db.String)
humanFIO = db.Column(db.String)
description = db.Column(db.String)
phoneNumber = db.Column(db.String)
address = db.Column(db.String)
def __init__(self, destinationTypeId = None, orderNumber = None, humanFIO = None, \
description = None, phoneNumber = None, address = None):
super(IssuePoint, self).__init__(destinationTypeId = None, orderNumber = None, humanFIO = None, \
description = None, phoneNumber = None, address = None)
self.destinationTypeId = destinationTypeId
self.orderNumber = orderNumber
self.humanFIO = humanFIO
self.description = description
self.phoneNumber = phoneNumber
self.address = address
def __repr__(self):
return '<Id: {}. Description: {}>'.format(self.id, self.description)
class Client(db.Model):
__tablename__ = 'client'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(140), unique=True)
name = db.Column(db.String(140))
surname = db.Column(db.String(140))
patronymic = db.Column(db.String(140))
password = db.Column(db.String(140))
phoneNumber = db.Column(db.String(140))
photoUrl = db.Column(db.String(140))
orders = db.relationship('Order', backref=db.backref('client'))
lastSeen = db.Column(db.DateTime)
def __init__(self,
name=None,
surname=None,
patronymic=None,
phoneNumber=None,
photoUrl=None,
email=None,
password=None):
super(Client, self).__init__(name = None, surname = None, patronymic = None, phoneNumber = None, \
photoUrl = None, email = None, password = None)
self.name = name
self.surname = surname
self.patronymic = patronymic
self.phoneNumber = phoneNumber
self.photoUrl = photoUrl
self.email = email
self.password = password
def is_authenticated(self):
return True
def is_active(self):
return True
def is_anonymous(self):
return False
def get_id(self):
try:
return unicode(self.id) #python 2
except NameError:
return str(self.id) #python 3
def __repr__(self):
return '<Id: {}. {} {} {}. Phone number: {}\n{}>'.format(
self.id, self.surname, self.name, self.patronymic,
self.phoneNumber, self.email)
class Operation(db.Model):
id = db.Column(db.Integer, primary_key = True)
operationType = db.relationship('OperationType', uselist = False, backref = db.backref('operation'))
operationStatus = db.relationship('OperationStatus', uselist = False, backref = db.backref('operation'))
courier = db.Column(db.Integer, db.ForeignKey('courier.id'))
date = db.Column(db.DateTime)
orderId = db.relationship('Order', uselist = False, backref = db.backref('operation'))
def __init__(self, operationTypeId = None, operationStatusId = None, courierId = None, orderId = None):
super(Operation, self).__init__(operationTypeId = None, operationStatusId = None, courierId = None, \
orderId = None)
self.operationTypeId = operationTypeId
self.operationStatusId = operationStatusId
self.courierId = courierId
self.orderId = orderId
def __repr__(self):
return '<Id: {}. Type- {}, Status- {}>'.format(self.id, self.operationTypeId, self.operationStatusId)
class PersonalInformation(db.Model):
__tablename__ = 'personalInformation'
id = db.Column(db.Integer, primary_key=True)
passportNumber = db.Column(db.String, unique=True)
passportSeries = db.Column(db.String, unique=True)
issuedByPasport = db.Column(db.String)
dateOfIssueOfPasport = db.Column(db.String)
dateOfBirth = db.Column(db.DateTime)
placeOfRegistration = db.Column(db.String)
SNILSNumber = db.Column(db.String, unique=True)
INNNumber = db.Column(db.String, unique=True)
actualAddressOfResidence = db.Column(db.String)
#courierId = db.Column(db.Integer, db.ForeignKey('courier.id'))
#managerId = db.Column(db.Integer, db.ForeignKey('manager.id'))
courier = db.relationship('Courier',
uselist=False,
backref=db.backref('personalInformation'))
manager = db.relationship('Manager',
uselist=False,
backref=db.backref('personalInformation'))
def __init__(self, passportNumber = None, passportSeries = None, issuedByPasport = None, dateOfIssueOfPasport = None, \
placeOfRegistration = None, SNILSNumber = None, INNNumber = None, actualAddressOfResidence = None):
super(PersonalInformation, self).__init__(passportNumber = None, passportSeries = None, issuedByPasport = None, \
dateOfIssueOfPasport = None, placeOfRegistration = None, SNILSNumber = None, INNNumber = None, \
actualAddressOfResidence = None)
self.passportNumber = passportNumber
self.passportSeries = passportSeries
self.issuedByPasport = issuedByPasport
self.dateOfIssueOfPasport = dateOfIssueOfPasport
self.placeOfRegistration = placeOfRegistration
self.SNILSNumber = SNILSNumber
self.INNNumber = INNNumber
self.actualAddressOfResidence = actualAddressOfResidence
def __repr__(self):
return '<Id {}.\nPasport: Series-{}, Number-{}, dateOfIssueOfPasport-{}.>'.format(self.id, self.passportSeries,\
self.passportNumber, self.dateOfIssueOfPasport)
class Operation(db.Model):
__tablename__ = 'operation'
id = db.Column(db.Integer, primary_key=True)
operationTypeId = db.Column(db.Integer, db.ForeignKey('operationType.id'))
operationStatusId = db.Column(db.Integer,
db.ForeignKey('operationStatus.id'))
courierId = db.Column(db.Integer, db.ForeignKey('courier.id'))
date = db.Column(db.DateTime)
orderId = db.Column(db.Integer, db.ForeignKey('order.id'))
def __init__(self,
operationTypeId=None,
operationStatusId=None,
courierId=None,
orderId=None):
super(Operation, self).__init__(operationTypeId = None, operationStatusId = None, courierId = None, \
orderId = None)
self.operationTypeId = operationTypeId
self.operationStatusId = operationStatusId
self.courierId = courierId
self.orderId = orderId
def __repr__(self):
return '<Id: {}. Type- {}, Status- {}>'.format(self.id,
self.operationTypeId,
self.operationStatusId)
class post(db.Model):
id = db.Column(db.Integer, primary_key = True)
title = db.Column(db.String(140))
slug = db.Column(db.String(140), unique = True)
body = db.Column(db.Text)
created = db.Column(db.DateTime, default = datetime.now())
def __init__(self, *args, **kwargs):
super(post, self).__init__(*args, **kwargs)
self.generate_slug()
def generate_slug(self):
if self.title:
self.slug = slugify(self.title)
def __repr__(self):
return '<Post: id {}, title: {}>'.format(self.id, self.title)
class Courier(db.Model):
id = db.Column(db.Integer, primary_key = True)
email = db.Column(db.String(140), unique = True)
name = db.Column(db.String(140))
surname = db.Column(db.String(140))
patronymic = db.Column(db.String(140))
password = db.Column(db.String(140))
phoneNumber = db.Column(db.String(140))
photoUrl = db.Column(db.String(140))
orders = db.relationship('Order', backref = db.backref('courier'))
courierType = db.relationship('CourierType', uselist = False, backref = db.backref('courier'))
operationId = db.relationship('Operation', backref = db.backref('courier'))
courierBalance = db.Column(db.Integer)
personalInformation = db.relationship('PersonalInformation', uselist = False, backref = db.backref('courier'))
documentsPhoto = db.relationship('DocumentsPhoto', uselist = False, backref = db.backref('courier'))
lastSeen = db.Column(db.DateTime)
def __init__(self, name = None, surname = None, patronymic = None, phoneNumber = None, photoUrl = None, \
email = None, password = None, courierBalance = None):
super(Courier, self).__init__(name = None, surname = None, patronymic = None, phoneNumber = None, \
photoUrl = None, email = None, password = None, courierBalance = None)
self.name = name
self.surname = surname
self.patronymic = patronymic
self.phoneNumber = phoneNumber
self.email = email
self.password = password
self.courierBalance = courierBalance
def __repr__(self):
return '<Id: {}. {} {} {}. Phone number: {}\n{}. \n\nPersonalInformation: {}\nDocumentsPhotoId:{}\nBalance: {}>'.format(self.id, \
self.surname, self.name, self.patronymic, self.phoneNumber, self.email, self.personalInformationId, \
self.documentsPhotoId, self.courierBalance)
