class Users(db.Model,UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20),unique=True,nullable=False)
password = db.Column(db.String(60),nullable=False)
admin = db.Column(db.Boolean, nullable=False)
expert = db.Column(db.Boolean, nullable=False)
projects = db.relationship('Projects', backref='author', lazy=True)
tickets = db.relationship('Tickets',backref='author',lazy=True)
def __repr__(self):
return f"{self.username}"
class Attachment(db.Model):
id = db.Column(db.Integer, primary_key=True)
file = db.Column(db.String(140))
ticket_id = db.Column(db.Integer, db.ForeignKey('tickets.id'), nullable=False)
def __repr__(self):
return f"{self.file}"
class Tickets(db.Model):
id = db.Column(db.Integer,primary_key=True)
title = db.Column(db.String(100),nullable=False)
ticket_text = db.Column(db.Text,nullable=False)
date_posted = db.Column(db.DateTime,nullable=False,default=datetime.utcnow)
status = db.Column(db.String(30), nullable=False)
priority = db.Column(db.String(30), nullable=False)
created_by_id = db.Column(db.Integer, nullable=False)
expert_id = db.Column(db.Integer, db.ForeignKey('users.id'),nullable=False)
project_id = db.Column(db.Integer, db.ForeignKey('projects.id'),nullable=False)
comment = db.relationship('Comment', backref='title', cascade="all,delete",lazy='dynamic')
attach = db.relationship('Attachment', backref='ticket', cascade="all,delete", lazy='dynamic')
#projects = db.relationship('Projects', backref=db.backref('ticketso', uselist=False), lazy=True)
def __repr__(self):
return f"Tickets('{self.title}','{self.date_posted}')"
class Projects(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable = False)
description = db.Column(db.Text, nullable = False)
created_by_id = db.Column(db.Integer, nullable = False)
expert_id = db.Column(db.Integer, db.ForeignKey('users.id'))
tickets = db.relationship('Tickets',backref='ticketso',lazy=True)
def __repr__(self):
return f"{self.title}"
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.String(140))
timestamp = db.Column(db.DateTime,default=datetime.utcnow)
author = db.Column(db.Integer,nullable=True)
ticket_id = db.Column(db.Integer, db.ForeignKey('tickets.id'),nullable=False)