app = Flask(__name__) app.config.from_object(__name__) app.config['SECRET_KEY'] = 'hard to guess string' manager = Manager(app) bootstrap = Bootstrap(app) moment = Moment(app) logger.info(APP_DIR) database = get_db() logger = create_log('{}/gestor.log'.format(APP_DIR)) @app.route('/') def login(): return render_template('login.html') @app.route('/logout') def logout(): session['username'] = "" session['role'] = "" logger.info('cerrando la sesión') logger.info('usuario: {}, rol: {}.'.format(session['username'], session['role'])) print('...sesión cerrada!')
from app.model.logger import create_log from app.model.database import connect_db, execute_query logger = create_log('gestor.log') class User: def __init__(self, username_id, name, email, password, role_id): # self.id = user_id self.username_id = username_id self.name = name self.email = email self.password = password self.role_id = role_id def select_user(username: str): result_set = '' # query3 = "SELECT * FROM users WHERE user_username= '******'".format(user_name) query = "SELECT t1.username_id, t1.name, " \ "t1.email, t1.password, t2.role_name " \ "FROM users AS t1 " \ "JOIN " \ "roles t2 " \ "ON t1.role_id = t2.role_id " \ "WHERE username_id='{}'".format(username) # logger.info(query) cnx = connect_db()
from app.model.logger import create_log from app.model.database import connect_db, execute_query, insert_query from datetime import date, time, datetime import os from app.model.database import execute_query from app.model.db_notify import * from app.model.user import get_supervisor # logger = create_log('controller.log') # logger = create_log('gestor.log') path = os.path.dirname(os.path.abspath(__file__)) logger = create_log('{}/gestor.log'.format(path)) class Status: def __init__(self, incidence_id, username, status_id): self.incidence_id = incidence_id self.username = username self.status_id = status_id self.end_date = None def insert_status(status): query="INSERT INTO status VALUES ('{}','{}','{}','0000-00-00 00:00:00')" \ .format(status.incidence_id, status.username, status.status_id) logger.info(query) cnx = connect_db()