[PYTHON] (For myself) Flask_7 (Open database from Flask)

item

1. Open the database from Flask
   (I'm tired today, so that's it)

1. Open the database from Flask

python

from flask import Flask, render_template
import pymysql
app = Flask(__name__)

def getConnection():
    return pymysql.connect(
        host='localhost',
        db='mydb',
        user='root',
        password='',
        charset='utf8',
        cursorclass=pymysql.cursors.DictCursor
    )

@app.route('/')
def select_sql():
    connection = getConnection()

    sql = "SELECT * FROM players"
    cursor = connection.cursor()
    cursor.execute(sql)
    players = cursor.fetchall()

    cursor.close()
    connection.close()

    return render_template('view.html', players = players)

--As for the python side, basically the combination so far --I made it possible to use MySQL in Python with ʻimport pymysql that I did last time. --def getConnection (): return pymysql.connect (), when you call getConnection () , you can get the material to call db. --Enter the information to call in connection with connection = getConnection () --Some of the movements below are the same as last time --And then put the variable assigned toreturn` in Flask's procedure so that it can be used on the html side as well.

view.html

{% for player in players %}
    <p>{{ player }}</p>
{% endfor %}

――A ritual to display the variable passed from the ordinary py side with a for statement ――If you put this in, it's OK for the time being

After that, if you start Flask normally, it will be completed (I will put that of the start below for the time being)

Terminal

$ cd <The name of the folder that contains the working directory>
$ FLASK_APP=<Working py directory name> FLASK_ENV=development flask run

2. At the end

--Quite short ――It seems that you only sleep for 3 hours in 48 hours, so take a break today. ――We will leave it tomorrow (today?) To delete data with SQL or borrow AWS in earnest and move it.