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()