fromflaskimportFlaskfromflask_mysql_connectorimportMySQLapp=Flask(__name__)
app.config['MYSQL_USER'] ='root'app.config['MYSQL_DATABASE'] ='sys'mysql=MySQL(app)
EXAMPLE_SQL='select * from sys.user_summary'# using the new_cursor() method@app.route('/new_cursor')defnew_cursor():
cur=mysql.new_cursor(dictionary=True)
cur.execute(EXAMPLE_SQL)
output=cur.fetchall()
returnstr(output)
# using the connection property@app.route('/connection')defconnection():
conn=mysql.connectioncur=conn.cursor()
cur.execute(EXAMPLE_SQL)
output=cur.fetchall()
returnstr(output)
# using the execute_sql() method to easily# select sql and optionally output to Pandas@app.route('/easy_execute')defeasy_execute():
df=mysql.execute_sql(EXAMPLE_SQL, to_pandas=True)
returnstr(df.to_dict())
if__name__=='__main__':
app.run(debug=True)
The Tidelift Subscription provides access to a continuously curated stream of human-researched and maintainer-verified data on open source packages and their licenses, releases, vulnerabilities, and development practices.