Exemplo n.º 1
0
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
Exemplo n.º 2
0
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():