from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:[email protected]/flask_books'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db: SQLAlchemy = SQLAlchemy(app)
class Author(db.Model):
__tablename__ = 'authors'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(16), unique=True)
books = db.relationship('Book', backref='author')
def __repr__(self):
return 'Author:%s' % self.name
class Book(db.Model):
__tablename__ = 'books'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(16), unique=True)
author_id = db.Column(db.Integer, db.ForeignKey('authors.id'))
def __repr__(self):
return 'Book: %s %s' % (self.name, self.author_id)
@app.route('/')
def hello_world():
return 'Hello World!'
if __name__ == '__main__':
# 為了演示方便,先洗掉所有表,再創建
db.drop_all()
db.create_all()
# 添加測驗資料庫
# 生成資料
au1 = Author(name='老王')
au2 = Author(name='老尹')
au3 = Author(name='老劉')
# 把資料提交給用戶會話
db.session.add_all([au1, au2, au3])
# 提交會話
db.session.commit()
bk1 = Book(name='老投訓憶錄', author_id=au1.id)
bk2 = Book(name='我讀書少，你別騙我', author_id=au1.id)
bk3 = Book(name='如何才能讓自己更騷', author_id=au2.id)
bk4 = Book(name='怎樣征服美麗少女', author_id=au3.id)
bk5 = Book(name='如何征服英俊少男', author_id=au3.id)
# 把資料提交給用戶會話
db.session.add_all([bk1, bk2, bk3, bk4, bk5])
# 提交會話
db.session.commit()
app.run(debug=True)
uj5u.com熱心網友回復：
真的快裂開了轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/263079.html
標籤：MySQL
下一篇：數倉