Not able to Commit data to database (using Python flask MySQL) even after using connection.commit()

Question

My data is not being stored in db inspite of using connection.commit() in Python flask. Here is my code:

from flask import Flask
from flaskext.mysql import MySQL
app = Flask(__name__)

def getMysqlConnection():

    mysql = MySQL()
    app.config['MYSQL_DATABASE_USER'] = "user_name"
    app.config['MYSQL_DATABASE_PASSWORD'] = "pass_string"
    app.config['MYSQL_DATABASE_DB'] = "db_name"
    app.config['MYSQL_DATABASE_HOST'] = "hostname"

    mysql.init_app(app)

    connection = mysql.connect()
    cursor = connection.cursor()
    return {"cursor":cursor,"connection":connection}

cursor = getMysqlConnection()['cursor']   #####global variables####
connection = getMysqlConnection()['connection']

def main_function():
    cursor.execute("Insert into table_name "
                       "(col1,col2,col3,col4) "
                       "Values (%s,%s,%s,%s,%s,%s)",
                       (val1,vla2,val3,val4)
                       )
    connection.commit()

This is not saving code in the database and I don't know why.

yeah @PaulNicolashunter. I m doing that. Any idea why problem is there? — user3457384
– user3457384, Commented Sep 21, 2017 at 16:45

Isma · Accepted Answer · 2017-09-21 16:43:43Z

1

Could it be that the following code initializes the database connection two times?

cursor = getMysqlConnection()['cursor']   #####global variables####
connection = getMysqlConnection()['connection']

Try

db =  getMysqlConnection()
cursor = db['cursor']
connection = db['connection']

answered Sep 21, 2017 at 16:43

Isma

15.3k5 gold badges42 silver badges54 bronze badges

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

1 Comment

user3457384 Over a year ago

Thanks!!!!! @Isma. You are Awesome Buddy. How on earth I could miss that.... Took my 3 hours....

Collectives™ on Stack Overflow

Not able to Commit data to database (using Python flask MySQL) even after using connection.commit()

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related