class Tabela_chaves(db.Model):
__bind_key__ = 'chaves_privadas'
__tablename__ = 'tabela_chaves'
id = db.Column(db.Integer, primary_key=True)
chave_privada = db.Column(db.LargeBinary(length=None), nullable=False)
id_usuario = db.Column(db.Integer, nullable=False)
email = db.Column(db.String(60), nullable=False)
def __repr__(self):
return f'<Tabela_chaves {self.id}>'
class Usuario(db.Model):
__bind_key__ = 'banco_principal'
__tablename__ = 'usuarios'
id_usuario = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.LargeBinary(length=None), nullable=False)
email = db.Column(db.String(60), nullable=False)
password = db.Column(db.LargeBinary(length=None), nullable=False)
data_nascimento = db.Column(db.LargeBinary(length=None), nullable=False)
cpf = db.Column(db.LargeBinary(length=None), nullable=False)
funcionario = db.Column(db.Boolean, nullable=False)
chave_publica = db.Column(db.LargeBinary(length=None), nullable=False)
agendamentos = db.relationship('Agendamento', backref='usuario')
endereco = db.relationship('Endereco', backref='usuario')
telefones = db.relationship('Telefone',
backref=db.backref('usuario', lazy=True))
def __repr__(self):
return f'<Usuario {self.id_usuario}>'
class Usuario(db.Model):
__bind_key__ = 'banco_principal'
__tablename__ = 'usuarios'
id_usuario = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.LargeBinary(length=None), nullable=False)
email = db.Column(db.LargeBinary(length=None), nullable=False)
password = db.Column(db.LargeBinary(length=None), nullable=False)
data_nascimento = db.Column(db.LargeBinary(length=None), nullable=False)
cpf = db.Column(db.LargeBinary(length=None), nullable=False)
funcionario = db.Column(db.LargeBinary(length=None), nullable=False)
agendamentos = db.relationship('Agendamento', backref='usuario')
endereco = db.relationship('Endereco', backref='usuario')
telefones = db.relationship('Telefone', backref=db.backref('usuario', lazy=True))
@property
def is_authenticated(self):
return True
@property
def is_active(self):
return True
@property
def is_anonymous(self):
return True
def get_id(self):
return f'{self.id_usuario}'
def __repr__(self):
return f'<Usuario {self.id_usuario}>'
class FcmServerModel(ModelBase):
__tablename__ = 'fcm_servers'
uuid = db.Column(db.String(80), primary_key=True, nullable=False)
key = db.Column(db.LargeBinary(), nullable=False)
@classmethod
def find_one(cls):
return db.session.query(FcmServerModel).first()
@classmethod
def get_key(cls) -> str:
fcm_server = db.session.query(FcmServerModel).first()
if fcm_server:
return aes_decrypt(fcm_server.key)
return ''