def baterPonto(user_pin, tipo):
user_id = UserModel.get_id_by_pin(user_pin)
if tipo == "entrar":
DB().run(
"INSERT INTO ponto (user_id) VALUES ({});".format(user_id))
else:
DB().run(
"UPDATE ponto SET fim = CURRENT_TIMESTAMP WHERE user_id = {} AND fim IS NULL;"
.format(user_id))
def login(email, password):
db_password = DB().getPasswordByEmail(email)['password']
if email is None or not check_password_hash(db_password, password):
return False
expires = timedelta(days=1)
return create_access_token(identity=email, expires_delta=expires)
def pontoAberto(user_pin):
user_id = UserModel.get_id_by_pin(user_pin)
ponto = DB().run_fr(
"SELECT inicio FROM ponto WHERE user_id = {} AND fim is NULL;".
format(user_id))
if ponto is None:
return False
return True
def get(user_pin):
return DB().run_fr("SELECT nome, batalhao, patente FROM user WHERE pin = {};".format(user_pin))
def all():
return DB().run_fa("SELECT nome, UF FROM estado;")
def get_id_by_pin(user_pin):
return DB().run_fv("SELECT id FROM user WHERE pin = {};".format(user_pin), "id")
def get_by_id(self):
return DB().run_fr("SELECT nome, UF FROM estado WHERE id = {};".format(
self.id))
def all():
return DB().run_fa("SELECT nome FROM cidade WHERE active = 1;")
def get_by_id(self):
return DB().run_fr("SELECT nome, active FROM cidade WHERE id = {};".format(self.id))
def get_by_id(self):
return DB().run_fr(
"SELECT nome FROM categoria WHERE removed = 0 AND id = {};".format(
self.id))
def all():
return DB().run_fa("SELECT nome FROM categoria WHERE removed = 0;")