class KomentariNaVideu(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
komentar = db.Column(db.Text(400), nullable=False)
napisano = db.Column(db.DateTime(),
nullable=False,
default=datetime.datetime.utcnow)
video = db.Column(db.Integer(), db.ForeignKey("videos.id"))
napisao = db.Column(db.Integer(), db.ForeignKey("users.id"))
korisnici = db.relationship('Users',
backref=db.backref('napisao', lazy='dynamic'))
def __repr__(self):
return self.id
class Feature(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255))
description = db.Column(db.Text(2048))
priority = db.Column(db.Integer)
target_date = db.Column(db.Date)
area_id = db.Column(db.Integer, db.ForeignKey('area.id'))
area = db.relationship('Area',
backref=db.backref('features', lazy='dynamic'))
client_id = db.Column(db.Integer, db.ForeignKey('client.id'))
client = db.relationship('Client',
backref=db.backref('features', lazy='dynamic'))
def __repr__(self):
return '<Feature %d>' % self.id
class Message(db.Model):
__tablename__='messages'
messages_id = db.Column(db.Integer, primary_key=True)
messages_date = db.Column(db.DateTime, unique=False, nullable = False, server_default=func.now())
messages_content = db.Column(db.Text(20000), unique=False, nullable = False)
user_id = db.Column(db.Integer, db.ForeignKey('users.users_id'))
def __repr__(self):
return '<Message %r>' % self.messages_id, self.messages_date, messages_content
def serialize(self):
return {
"messages_id": self.messages_id,
"messages_date": self.messages_date,
"messages_content": self.messages_content
}
class User(db.Model):
__tablename__='users'
users_id = db.Column(db.Integer, primary_key=True)
users_name = db.Column(db.String(30), unique=False, nullable=False)
users_issue_subject = db.Column(db.String(30), unique=False, nullable=False)
users_issue_description = db.Column(db.Text(300), unique=False, nullable =False)
messages = db.relationship('Message', backref='users')
lawyer_id = db.Column(db.Integer, db.ForeignKey('lawyers.lawyers_id'))
user_case = db.relationship('Case', backref='case_author', lazy=True)
def __repr__(self):
return '<User %r>' % self.users_id, self.users_name, self.users_issue_subject, self.users_issue_description
def serialize(self):
return {
"users_id": self.users_id,
"users_name": self.users_name,
"users_issue_subject": self.users_issue_subject,
"users_issue_description": self.users_issue_description
}
class Case(db.Model):
__tablename__ ='cases'
cases_id = db.Column(db.Integer, primary_key=True)
cases_matter = db.Column(db.String(20), unique=False, nullable=False)
cases_date = db.Column(db.DateTime, unique=False, nullable=False)
cases_description = db.Column(db.Text(300), unique=False, nullable=False)
client_id = db.Column(db.Integer, db.ForeignKey('clients.clients_id'))
cases_documents = db.relationship('Document', backref='Case', lazy=True)
lawyers_case = db.relationship('Lawyer', secondary=lawyer_case, lazy='subquery', backref=db.backref('case', lazy=True))
def __repr__(self):
return '<Case %r>' % self.cases_id, self.cases_matter, self.cases_date, self.cases_description
def serialize(self):
return {
"cases_id": self.cases_id,
"cases_matter": self.cases_matter,
"cases_date": self.cases_date,
"cases_description": self.cases_description,
"users_id":self.users_author.id,
"users_name":self.users_author.name,
"users_issue_subject":self.users_author.issue_subject,
"users_issue_description":self.users_author.issue_description
}