我正面临一个非常奇怪的问题。我的数据没有被存储在数据库中连接.提交()在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()
这不是在数据库中保存代码。不知道为什么。在
任何帮助都会有帮助的。谢谢
下面的代码是否会初始化数据库连接两次?在
试试看
^{pr2}$相关问题 更多 >
编程相关推荐