如何在 flask 使用 postgresql 資料庫

woff

環境 python 3.9


安裝模組

1. pip install flask
   
2. conda install sqlalchemy
   
3. pip install flask_sqlalchemy
   
4. pip install psycopg2

複製代碼

安裝postgresql，到 https://www.postgresql.org/download/ 下載
設定帳號 admin 密碼 123456

程式碼

1. from flask import Flask
   
2. from flask_sqlalchemy import SQLAlchemy
   
3. db = SQLAlchemy()
   
4. # creates a Flask application
   
5. app = Flask(__name__)
   
6. 
   
7. app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://admin:123456@127.0.0.1:5432/testdb'
   
8. db = SQLAlchemy(app)
   
9. 
   
10. class students(db.Model):
    
11.     __tablename__ = 'students'
    
12.     sid = db.Column(db.Integer, primary_key = True)
    
13.     name = db.Column(db.String(50), nullable = False)
    
14.     tel = db.Column(db.String(50))
    
15.     addr = db.Column(db.String(200))
    
16.     email = db.Column(db.String(200))
    
17. 
    
18.     def __init__(self,name,tel,addr ,email):
    
19.         self.name =name
    
20.         sel,rel=tel
    
21.         self.addr = addr
    
22.         self.email = email
    
23. 
    
24. @app.route("/")
    
25. def index():
    
26.     db.create_all()
    
27.     return "connect success!!"
    
28. 
    
29. # Press the green button in the gutter to run the script.
    
30. if __name__ == '__main__':
    
31.     app.run()

複製代碼

最後到 pgAdmin 4 檢查是否成功

flask postgresql 資料庫

文章出處: NetYea 網頁設計