Vz3ipq7t

1from flask import Flask, render_template, flash, redirect
2from flask_wtf import FlaskForm
3from flaskext.mysql import MySQL
4from wtforms import StringField, SubmitField
5from wtforms.validators import DataRequired
6
7SECRET_KEY='5f352379324c22463451387a0aec5d2f'
8
9mydb = MySQL(host='127.0.0.1', user='testusr', password='ttest', db='testdb') 
10app = Flask(__name__)
11app.secret_key = SECRET_KEY
12mydb.init_app(app)
13
14class QueryForm(FlaskForm):
15    username = StringField('Nombre de Usuario', validators=[DataRequired()])
16    submit = SubmitField('Consultar')
17    
18@app.route("/", methods=['GET', 'POST'])
19def main():
20        form = QueryForm()
21        cursor = mydb.get_db().cursor()
22        
23        if form.validate_on_submit():
24                query = f"select * from compras inner join clientes where usuario == {form.username.data}"
25                cursor.execute(query)
26                
27                results = cursor.fetchall()
28                
29                for data in mycursor:
30                        print(data)
31                 
32                return redirect('/')
33        
34        return render_template('login.html', title='Consulta compras', form=form)
35        
36if __name__ == "__main__":
37        #app.run(host='0.0.0.0', port=80)
38        app.run(host='localhost', port=5002)
39