class ComplaintType(db.Model):
id=db.Column(db.Integer, primary_key=True)
name=db.Column(db.String(20), unique=True)
description=db.Column(db.String(100))
service_id=db.Column(db.Integer, db.ForeignKey('service.id'))
service=db.relationship('Service', backref=db.backref('complaint_types', lazy='dynamic'))
class Role(db.Model, RoleMixin): id=db.Column(db.Integer, primary_key=True) name=db.Column(db.String(25), unique=True) description=db.Column(db.String(100)) # def __init__(self, name): # self.name=name def __repr__(self): return '<User Type %r>' % self.name
class User(db.Model, UserMixin):
id=db.Column(db.Integer, primary_key=True)
name=db.Column(db.String(25))
email=db.Column(db.String(20), unique=True)
password=db.Column(db.String(40))
active=db.Column(db.Boolean())
confirmed_at = db.Column(db.DateTime())
roles = db.relationship('Role', secondary=roles_users, backref=db.backref('users', lazy='dynamic'))
# def __init__(self, name, user_name, password, user_type_id):
# self.name=name
# self.user_name=user_name
# self.password=password
# self.user_type_id=user_type_id
def __repr__(self):
return '<User %r>' % self.email
class Complaint(db.Model):
id=db.Column(db.Integer, primary_key=True)
cust_id=db.Column(db.String(25))
cust_name=db.Column(db.String(30))
cust_address=db.Column(db.String(100))
cust_phone=db.Column(db.String(15))
complaint_phone=db.Column(db.String(15))
no_calls=db.Column(db.Integer, default=1)
date_time=db.Column(db.DateTime, default=datetime.utcnow())
priority=db.Column(db.Float, default=0.00)
service_id=db.Column(db.Integer, db.ForeignKey('service.id'))
service=db.relationship('Service', backref=db.backref('complaints', lazy='dynamic'))
complaint_type_id=db.Column(db.Integer, db.ForeignKey('complaint_type.id'))
complaint_type=db.relationship('ComplaintType', backref=db.backref('complaints', lazy='dynamic'))
status_id=db.Column(db.Integer, db.ForeignKey('complaint_status.id'))
status=db.relationship('ComplaintStatus', backref=db.backref('complaints', lazy='dynamic'))
source_id=db.Column(db.Integer, db.ForeignKey('complaint_source.id'))
source=db.relationship('ComplaintSource', backref=db.backref('complaints', lazy='dynamic'))
# def __init__(self, cust_id, cust_name, cust_address, cust_phone, complaint_phone, service_id=None, complaint_type_id=None, status_id=None, date_time=None):
# self.cust_id=cust_id
# self.cust_name=cust_name
# self.cust_address=cust_address
# self.cust_phone=cust_phone
# self.complaint_phone=complaint_phone
# self.service_id=service_id
# self.complaint_type_id=complaint_type_id
# self.status_id=status_id
# if date_time is None:
# date_time=datetime.utcnow()
# self.date_time=date_time
def __repr__(self):
return '<Complaint id:%r p:%r d:%r c_id:%r status_id:%r>' %(self.id,self.priority,self.date_time,self.cust_id,self.status_id)
class ComplaintSource(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20), unique=True) description = db.Column(db.String(100))
from resolver import db
from datetime import datetime
from marshmallow import Schema, fields, post_load
from flask_security import UserMixin, RoleMixin
# from resolver import app
"""If you want to use many-to-many relationships you will need to
define a helper table that is used for the relationship.
For this helper table it is strongly recommended to not use a model but an actual table"""
roles_users = db.Table('roles_users',\
db.Column('user_id', db.Integer(), db.ForeignKey('user.id')),\
db.Column('role_id', db.Integer(), db.ForeignKey('role.id')))
class User(db.Model, UserMixin):
id=db.Column(db.Integer, primary_key=True)
name=db.Column(db.String(25))
email=db.Column(db.String(20), unique=True)
password=db.Column(db.String(40))
active=db.Column(db.Boolean())
confirmed_at = db.Column(db.DateTime())
roles = db.relationship('Role', secondary=roles_users, backref=db.backref('users', lazy='dynamic'))
# def __init__(self, name, user_name, password, user_type_id):
# self.name=name
# self.user_name=user_name
# self.password=password
# self.user_type_id=user_type_id
def __repr__(self):
return '<User %r>' % self.email