Flask mysql data replacement. (UPDATE Statement) [duplicate]

Question

The problem is this: When the command runs, it does not replace the data in the database.

I looked at countless pages but found no solution to the problem.

But it doesn't give an error.

Script:

@app.route('/profil', methods=['GET', 'POST'])
def profil():

    if 'loggedin' in session:
        cursor = mysql.connection.cursor(MySQLdb.cursors.DictCursor)
        cursor.execute('SELECT * FROM users WHERE id = %s', (session['id'],))
        account = cursor.fetchone()

        if request.method == 'POST':
            file = request.files['file']
            filename = secure_filename(file.filename)

            path = os.path.join(app.config['UPLOAD_FOLDER'], filename)
            file.save(path)

            cursor.execute('UPDATE users SET file_name = %s WHERE id = %s', (filename,account['id'],))

            return filename

        return render_template('profil.html', account=account)

    return redirect(url_for('login'))```

You need to call the connection's commit method to commit the change to the database. — snakecharmerb
– snakecharmerb, Commented Jun 13, 2021 at 10:37

Kugge · Accepted Answer · 2021-06-13 10:40:40Z

1

When doing an UPDATE you need to commit explicitly with .commit:

cnx = mysql.connector.connect(...)
cursor = cnx.cursor()
cursor.execute('UPDATE .....')
cnx.commit()

https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-commit.html

You can autocommit with cnx.autocommit = True.

answered Jun 13, 2021 at 10:40

Kugge

381 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Flask mysql data replacement. (UPDATE Statement) [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related