예제 #1
0
def login():
    if request.method == 'POST':
        username = request.form['username']
        password = request.form['password']
        db,c = get_db()
        error = None
        c.execute(
            'select * from user where username = %s',(username,)
        )
        user = c.fetchone()
        if user is None:
            error = 'El usuario no existe'
        elif not check_password_hash(user['password'],password):
            error = 'El usuario no existe'
        if error is  None and user['permisos'] == 1:
            session.clear()
            session['user_id'] = user['id']
            return redirect(url_for('receta.index_adm'))
        if error is None and user['permisos'] == 0:
            session.clear()
            session['user_id'] = user['id']
            return redirect(url_for('receta.index'))

        flash(error)

    return render_template('auth/login.html')
예제 #2
0
def register():
    if request.method == 'POST':
        username = request.form['username']
        password = request.form['password']
        nombre = request.form['nombre']
        apellido = request.form['apellido']
        email = request.form['email']
        sexo = request  .form['sexo']
        db, c = get_db()
        error = None
        c.execute(
            'select * from user where username = %s',(username,)
        )
        if not username:
            error = 'Username requerido'
        if not password:
            error = 'Password es requerido'
        elif c.fetchone() is not None:
            error = 'El usuario ya se encuentra registrado'

        if error is None:
            c.execute(
                'insert into user (username,password,nombre,apellido,correo,permisos,sexo) values (%s,%s,%s,%s,%s,%s,%s)',
                (username,generate_password_hash(password),nombre,apellido,email,0,sexo)
            )
            db.commit()
            return redirect(url_for('auth.login'))
    return render_template('auth/register.html')
예제 #3
0
def get_recipe(id):
    db, c = get_db()
    c.execute('select * from receta where id = %s', (id, ))
    receta = c.fetchone()

    if receta is None:
        abort(404, "El todo de id {0} no existe".format(id))
    return receta
예제 #4
0
def load_logged_in_user():
    user_id = session.get('user_id')

    if user_id is None:
        g.user = None
    else:
        db, c = get_db()
        c.execute(
            'select * from user where id = %s', (user_id,)
        )
        g.user = c.fetchone()
예제 #5
0
def create():
    if request.method == 'POST':
        titulo = request.form['titulo']
        descripcion = request.form['descripcion']
        ingredientes = request.form['ingredientes']
        preparacion = request.form['preparacion']
        categoria = request.form['categoria']
        url = request.form['url']
        db, c = get_db()
        c.execute(
            'insert into receta (titulo,descripcion,ingredientes,preparacion,categoria,url) values (%s,%s,%s,%s,%s,%s)',
            (titulo, descripcion, ingredientes, preparacion, categoria, url))
        db.commit()
        return redirect(url_for('receta.index_adm'))
    return render_template('recetas/create.html')
예제 #6
0
def index():
    db, c = get_db()
    c.execute('select r.ingredientes from receta r')
    ingredientes = c.fetchall()
    rows = 0
    rows_list = []
    linea = 0
    for i in range(len(ingredientes)):
        for j in ingredientes[i]['ingredientes']:
            if j == '\n':
                rows += 1
        rows_list.append(rows)
        rows = 0
    c.execute('select * from receta')
    receta = c.fetchall()
    size = len(receta)
    return render_template('recetas/index.html',
                           receta=receta,
                           rows=rows_list,
                           size=size)
예제 #7
0
def mostrar_categoria_user(categoria):
    db, c = get_db()
    c.execute('select r.ingredientes from receta r where categoria = %s',
              (categoria, ))
    ingredientes = c.fetchall()
    rows = 0
    rows_list = []
    linea = 0
    for i in range(len(ingredientes)):
        for j in ingredientes[i]['ingredientes']:
            if j == '\n':
                rows += 1
        rows_list.append(rows)
        rows = 0
    c.execute('select * from receta where categoria = %s', (categoria, ))
    receta = c.fetchall()
    size = len(receta)
    return render_template('recetas/mostrar_categoria_user.html',
                           receta=receta,
                           rows=rows_list,
                           size=size)
예제 #8
0
def categorias():
    db, c = get_db()
    c.execute('select * from receta')
    receta = c.fetchall()
    return render_template('recetas/categorias.html', receta=receta)
예제 #9
0
def recipe_user():
    db, c = get_db()
    c.execute('select * from receta')
    receta = c.fetchall()
    return render_template('recetas/recipe_user.html', receta=receta)