flask连接不到mysql数据库,即使使用了python flask mysql，也无法将数据提交到数据库（使用python flask mysql）连接.提交()...

我正面临一个非常奇怪的问题。我的数据没有被存储在数据库中连接.提交()在Python瓶里。这是我的代码：-在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()

这不是在数据库中保存代码。不知道为什么。在

任何帮助都会有帮助的。谢谢