class User(db.Model): """ """ __tablename__ = "users" id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String, unique=True) password = db.Column(db.String) name = db.Column(db.String) email = db.Column(db.String, unique=True) @property def is_authenticated(self): return True @property def is_active(self): return True @property def is_anonymous(self): return False def get_id(self): return str(self.id) def __init__(self, username, password, name, email): self.username = username self.password = password self.name = name self.email = email def __repr__(self): return "<User %r>" % self.username
class TelegramToken(db.Model): """ """ __tablename__ = "telegramtokens" id = db.Column(db.Integer, primary_key=True) token = db.Column(db.String, unique=True) name = db.Column(db.String) @property def is_authenticated(self): return True @property def is_active(self): return True @property def is_anonymous(self): return False def get_id(self): return str(self.id) def __init__(self, name, token): self.name = name self.token = token def __repr__(self): return {"name": self.name, "token": self.token}
class Curiosidade(db.Model): """ """ __tablename__ = "curiosidades" id = db.Column(db.Integer, primary_key=True) curiosidade = db.Column(db.String, unique=True) def get_id(self): return str(self.id) def __init__(self, curiosidade): self.curiosidade = curiosidade def __repr__(self): return "<Nome %r>" % self.curiosidade
class Piada(db.Model): """ """ __tablename__ = "piadas" id = db.Column(db.Integer, primary_key=True) piada = db.Column(db.String, unique=True) def get_id(self): return str(self.id) def __init__(self, piada): self.piada = piada def __repr__(self): return "<Nome %r>" % self.piada
class Pergunta(db.Model): """ """ __tablename__ = "perguntas" id = db.Column(db.Integer, primary_key=True) pergunta = db.Column(db.String, unique=True) resposta = db.Column(db.String) def get_id(self): return str(self.id) def __init__(self, pergunta, resposta): self.pergunta = pergunta self.resposta = resposta def __repr__(self): return "<Nome %r>" % self.pergunta
class Proverbio(db.Model): """ """ __tablename__ = "proverbios" id = db.Column(db.Integer, primary_key=True) proverbio = db.Column(db.String, unique=True) autor = db.Column(db.String) def get_id(self): return str(self.id) def __init__(self, proverbio, autor): self.proverbio = proverbio self.autor = autor def __repr__(self): return "<Nome %r>" % self.proverbio
class Citacao(db.Model): """ """ __tablename__ = "citacoes" id = db.Column(db.Integer, primary_key=True) citacao = db.Column(db.String, unique=True) autor = db.Column(db.String) def get_id(self): return str(self.id) def __init__(self, citacao, autor): self.citacao = citacao self.autor = autor def __repr__(self): return "<Nome %r>" % self.citacao
class Charada(db.Model): """ """ __tablename__ = "charadas" id = db.Column(db.Integer, primary_key=True) charada = db.Column(db.String, unique=True) resposta = db.Column(db.String) def get_id(self): return str(self.id) def __init__(self, charada, resposta): self.charada = charada self.resposta = resposta def __repr__(self): return "<Nome %r>" % self.charada
class DataBase(db.Model): """ """ __tablename__ = "databases" id = db.Column(db.Integer, primary_key=True) host = db.Column(db.String) database = db.Column(db.String) user = db.Column(db.String) password = db.Column(db.String) database_url = db.Column(db.String, unique=True) def get_id(self): return str(self.id) def __init__(self, host, database, user, password): self.host = host self.database = database self.user = user self.password = password self.database_url = 'mysql+pymysql://' + str(user) + ':@' + str( password) + '@' + str(host) + '/' + str(database) def __repr__(self): return "<Nome %r>" % self.database_url
class Quiz(db.Model): """ """ __tablename__ = "quiz" id = db.Column(db.Integer, primary_key=True) pergunta = db.Column(db.String, unique=True) alternativa1 = db.Column(db.String) alternativa2 = db.Column(db.String) alternativa3 = db.Column(db.String) alternativa4 = db.Column(db.String) alternativa5 = db.Column(db.String) resposta = db.Column(db.Integer) url_imagem = db.Column(db.String) def get_id(self): return str(self.id) def __init__(self, pergunta, alternativa1, alternativa2, alternativa3, alternativa4, alternativa5, resposta, url_imagem=None): self.pergunta = pergunta self.alternativa1 = alternativa1 self.alternativa2 = alternativa2 self.alternativa3 = alternativa3 self.alternativa4 = alternativa4 self.alternativa5 = alternativa5 self.resposta = resposta self.url_imagem = url_imagem def __repr__(self): return "<Nome %r>" % self.pergunta
class Message(db.Model): id = db.Column(db.Integer, primary_key=True) body = db.Column(db.String(1024)) to_phone_number = db.Column(db.String(16)) from_phone_number = db.Column(db.String(16)) direction = db.Column(db.String(16)) dateSent = db.Column(db.String(32)) def __init__(self, body, to_phone_number, from_phone_number, direction, dateSent): self.body = body self.to_phone_number = to_phone_number self.from_phone_number = from_phone_number self.direction = direction self.dateSent = dateSent def __repr__(self): return '<Message %r>' % self.body