class Tarefa(db.Model):
__tablename__ = 'tarefas'
id = db.Column(db.Integer, primary_key=True)
titulo = db.Column(db.String, nullable=False)
def __init__(self, titulo):
self.titulo = titulo
class Data(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
email = db.Column(db.String(100))
phone = db.Column(db.String(100))
def __init__(self, name, email, phone):
self.name = name
self.email = email
self.phone = phone
class Emp(db.Model):
__tablename__ = 'emp'
id = db.Column(db.Integer(), primary_key=True)
fname = db.Column(db.String(30))
lname = db.Column(db.String(30))
dept = db.Column(db.String(30))
sal = db.Column(db.Integer())
def __init__(self, fname, lname, dept, sal):
self.fname = fname
self.lname = lname
self.dept = dept
self.sal = sal
def __repr__(self):
return '<Emp %r>' % self.id
class Messages(db.Model):
id = db.Column(db.Integer, primary_key=True)
nickname = db.Column(db.String(60))
date_message = db.Column(db.DateTime)
message = db.Column(db.String(140))
def __init__(self, nickname):
self.nickname = nickname
@property
def serialize(self):
return {
'id': self.id,
'nickname': self.nickname,
'date': self.date_message,
'message': self.message
}
class List(db.Model):
id = db.Column(db.Integer, primary_key=True)
item = db.Column(db.String, nullable=False)
def __repr__(self):
return f"List('{self.id}', '{self.item}')"
class Book(db.Model):
id = db.Column(db.String(120), primary_key=True)
title = db.Column(db.String(80), nullable=False)
def __repr__(self):
return f"Book('{self.title}')"