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}')"