from flask import Flask from flask_mysql_connector import MySQL app = Flask(__name__) MySQL.init_app(app) @app.route("/") def hello(): query = "SELECT 'Hello_World';" db = MySQL() with db.cursor(dictionary=True) as cursor: cursor.execute(query) rv = cursor.fetchone() return rv
from flask import Flask, render_template, request, redirect, url_for, flash from flask_mysql_connector import MySQL app = Flask(__name__) app.config['MYSQL_HOST'] = 'localhost' app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DATABASE'] = 'tallermvc1' app.config['MYSQL_PORT'] = '3307' mysql = MySQL(app) mysql = MySQL() mysql.init_app(app) app.secret_key = "mysecretkey" @app.route('/') def Index(): cur = mysql.connection.cursor() cur.execute('SELECT * FROM persona') data = cur.fetchall() cur.close() return render_template('index.html', persona = data) @app.route('/add_persona', methods=['POST']) def add_persona():