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 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 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 Courier(db.Model):
__tablename__ = 'courier'
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'))
operations = db.relationship('Operation', backref=db.backref('courier'))
courierBalance = db.Column(db.Integer)
personalInformationId = db.Column(db.Integer,
db.ForeignKey('personalInformation.id'))
#db.relationship('PersonalInformation', uselist = False, backref = db.backref('courier'))
documentsPhotoId = db.Column(db.Integer,
db.ForeignKey('documentsPhoto.id'))
#db.relationship('DocumentsPhoto', uselist = False, backref = db.backref('courier'))
lastSeen = db.Column(db.DateTime)
courierTypeId = db.Column(db.Integer, db.ForeignKey('courierType.id'))
def __init__(self, name = None, surname = None, patronymic = None, phoneNumber = None, photoUrl = None, \
email = None, password = None, courierTypeId = None, personalInformationId = None, \
documentsPhotoId = None, courierBalance = None):
super(Courier, self).__init__(name = None, surname = None, patronymic = None, phoneNumber = None, \
photoUrl = None, email = None, password = None, courierTypeId = None, personalInformationId = None, \
documentsPhotoId = None, courierBalance = None)
self.name = name
self.surname = surname
self.patronymic = patronymic
self.phoneNumber = phoneNumber
self.photoUrl = photoUrl
self.email = email
self.password = password
self.courierTypeId = courierTypeId
self.personalInformationId = personalInformationId
self.documentsPhotoId = documentsPhotoId
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)
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 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 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 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 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 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 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)
