CPanel 如何在 flask 使用 mysql 資料庫

woff

環境 python 3.9

安裝模組

1. pip install flask
   
2. pip install pymysql
   
3. pip install mariadb
   
4. pip install json

複製代碼

建立資料庫flask_tw
建立資料表
Id, FristName, LastName, Addr, City


程式碼

1. import pymysql
   
2. from flask import Flask
   
3. pymysql.install_as_MySQLdb()  # Install MySQL driver
   
4. import json
   
5. import mariadb
   
6. config = {
   
7.     'host': '127.0.0.1',
   
8.     'port': 3306,
   
9.     'user': 'flask_tw',
   
10.     'password': 'password',
    
11.     'database': 'flask_tw'
    
12. }
    
13. 
    
14. app = Flask(__name__)
    
15. 
    
16. @app.route("/")
    
17. def index():
    
18.     return "connect success!!"
    
19. 
    
20. @app.route('/api/people', methods=['GET'])
    
21. def dbtest():
    
22.    # connection for MariaDB
    
23.    conn = mariadb.connect(**config)
    
24.    # create a connection cursor
    
25.    cur = conn.cursor()
    
26.    # execute a SQL statement
    
27.    cur.execute("select * from people")
    
28. 
    
29.    # serialize results into JSON
    
30.    row_headers=[x[0] for x in cur.description]
    
31.    rv = cur.fetchall()
    
32.    json_data=[]
    
33.    for result in rv:
    
34.         json_data.append(dict(zip(row_headers,result)))
    
35. 
    
36.    # return the results!
    
37.    return json.dumps(json_data)
    
38. 
    
39. if __name__ == '__main__':
    
40.     app.run()

複製代碼

新增資料 加入

1. @app.route("/insert")
   
2. def insert():
   
3.     insertStatement = "INSERT INTO people (id, LastName, FirstName,Address,City) VALUES (5,'woff2','lin2','hsinchu2','city2')";
   
4.     conn = mariadb.connect(**config)
   
5.     # create a connection cursor
   
6.     cur = conn.cursor()
   
7.     cur.execute(insertStatement)
   
8.     return ("Successfully added entry to database")

複製代碼

測試網址
http://flask.netyea.com/test/api/people

flask mysql 資料庫

文章出處: NetYea 網頁設計

https://hackernoon.com/getting-s ... -and-flask-pa1i3ya3