Metodos.py 文件源码

def editP():
    conectar = mysql.connection.cursor()
    f = ""
    subCat = ""

    if request.form["categoria"]=="1":
        subCat = request.form['cat1']
    elif request.form["categoria"]=="2":
        subCat = request.form['cat2']
    elif request.form["categoria"]=="3":
        subCat = request.form['cat3']
    elif request.form["categoria"]=="4":
        subCat = request.form['cat4']
    elif request.form["categoria"]=="5":
        subCat = request.form['cat5']
    else:
        subCat = ""

    idU = escape(session['id'])
    try:
        f = photos.save(request.files['file'])

        conectar.execute("""UPDATE Publicacion SET titulo = (%s), cuerpo = (%s), categoria = (%s), 
            subCategoria = (%s), portada = (%s) WHERE idPublicacion = (%s) and  Usuario_idUsuario = (%s)
            """, [[request.form['titulo']], [request.form['publicacion']], [request.form['categoria']], [subCat], [f], [request.form['xpubxid']], [idU]])
        mysql.connection.commit()
    except:
        conectar.execute("""UPDATE Publicacion SET titulo = (%s), cuerpo = (%s), categoria = (%s), 
            subCategoria = (%s) WHERE idPublicacion = (%s) and  Usuario_idUsuario = (%s)
            """, [[request.form['titulo']], [request.form['publicacion']], [request.form['categoria']], [subCat], [request.form['xpubxid']], [idU]])
        mysql.connection.commit()
    return redirect("/publicacion?ID="+request.form['xpubxid'])