class Phone(db.Model):
id = db.Column(db.Integer, primary_key=True)
number = db.Column(db.String(10), unique=True, nullable=False)
phoneType = db.relationship('PhoneType',
backref='phone',
lazy=True,
uselist=False)
class Ticket(db.Model):
id = db.Column(db.Integer, primary_key=True)
problem = db.Column(db.Text)
action = db.Column(db.Text)
dateCreated = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
status = db.Column(db.Integer, db.ForeignKey('status.id'), nullable=False)
class Group(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(25), unique=True, nullable=False)
desc = db.Column(db.Text, nullable=False)
def as_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
def __repr__(self):
return f"Group('{self.id}', '{self.name}', '{self.desc}')"
class Organization(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(40), nullable=False, unique=True)
isActive = db.Column(db.Boolean, nullable=False)
address = db.Column(db.Integer,
db.ForeignKey('organization.id'),
nullable=False)
phone = db.relationship('Phone',
secondary=orgPhone,
backref='organization',
lazy='dynamic')
class Client(db.Model):
id = db.Column(db.Integer, primary_key=True)
firstName = db.Column(db.String(40))
lastName = db.Column(db.String(40))
email = db.Column(db.Integer, db.ForeignKey('email.id'), nullable=False)
notes = db.relationship('Note',
secondary=clientNote,
backref=db.backref('client', lazy='dynamic'))
tickets = db.relationship('Ticket',
secondary=clientTicket,
backref=db.backref('client', lazy='dynamic'))
phones = db.relationship('Phone',
secondary=clientPhone,
backref=db.backref('client', lazy='dynamic'))
class Address(db.Model):
id = db.Column(db.Integer, primary_key=True)
street_1 = db.Column(db.String(100), nullable=False)
street_2 = db.Column(db.String(100))
city = db.Column(db.String(100), nullable=False)
county = db.Column(db.String(100))
state = db.Column(db.String(100), nullable=False)
country = db.Column(db.String(100), nullable=False)
zip = db.Column(db.Integer, nullable=False)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(25), unique=True, nullable=False)
password = db.Column(db.String(64), nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default='default.png')
email = db.Column(db.String(120), unique=True, nullable=False)
fName = db.Column(db.String(40), nullable=False)
lName = db.Column(db.String(40), nullable=False)
isActive = db.Column(db.Boolean)
#themes = db.relationship('Theme', backref='user', lazy=True, uselist=False)
groups = db.relationship('Group',
secondary=userGroup,
backref=db.backref('user', lazy='dynamic'))
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
password = db.Column(db.String(64), nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default='default.png')
email = db.Column(db.String(120), unique=True, nullable=False)
fName = db.Column(db.String(40), nullable=False)
lName = db.Column(db.String(40), nullable=False)
isActive = db.Column(db.Boolean, nullable=False)
group_id = db.Column(db.Integer, db.ForeignKey('group.id'), nullable=False)
group = db.relationship('Group',
backref=db.backref('users',
uselist=True,
cascade='delete,all'))
def as_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class Note(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(60), nullable=False)
content = db.Column(db.Text, nullable=False)
class Group(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(25), unique=True, nullable=False)
class Email(db.Model):
id = db.Column(db.Integer, primary_key=True)
address = db.Column(db.String(64), unique=True, nullable=False)
clientID = db.Column(db.Integer,
db.ForeignKey('client.id'),
nullable=False)
class Status(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(25), unique=True, nullable=False)
from datetime import datetime
from helpdesk import db, login_manager
from flask_login import UserMixin
#@login_manager.user_loaded
#def load_user(user_id):
# return User.query.get(int(user_id))
#-----------------------------------------------------------------------------------------------------------------------
# Last, model connector tables for the many-to-many relationships
#-----------------------------------------------------------------------------------------------------------------------
userGroup = db.Table(
'userGroup',
db.Column('user_id',
db.Integer,
db.ForeignKey('user.id'),
primary_key=True),
db.Column('group_id',
db.Integer,
db.ForeignKey('group.id'),
primary_key=True))
clientNote = db.Table(
'clientNote',
db.Column('client_id',
db.Integer,
db.ForeignKey('client.id'),
primary_key=True),
db.Column('note_id',
db.Integer,
db.ForeignKey('note.id'),
primary_key=True))