MySQL insert query - FLASK

Question

query="""insert into serial_ids values (%s,%s)"""
cur.execute(query, (serial,model))

I am using MySQL in Flask framework but I dont see the row inserted. The same code piece is working with python (no framework).

Also, is there any way to do autocommit true in Flask or some workaround?

Burhan Khalid · Accepted Answer · 2014-07-11 19:29:41Z

1

You need to commit the transaction, with con.commit(), where con is your connection.

Have a read through the documentation for SQLAlchemy - using sqlalchemy will automatically commit the transactions.

answered Jul 11, 2014 at 19:29

Burhan Khalid

175k20 gold badges254 silver badges291 bronze badges

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

1 Comment

thanks burhan, I did the split of instantiating cursor and did the commit. Although thanks for the link. will look into it.