01-Python Flask系列-mac安装MySQL-Python Flask零基础到项目实战系列-QLAlchemy数据库
热门回复:
- 嘉文肥肥:No module named 'MySQLdb' 怎么解决吗???尝试安装过了mysqlclient、pymysql
- firstoneyuan:使用pymysql时, 创建orm模型:
class User(db.Model):
__tablename__='user'
id = db.Column(db.Integer,primary_key=True,autoincrement=True)
username = db.Column(db.String(100),nullable=False)
class Article(db.Model):
__tablename__='article'
id = db.Column(db.Integer,primary_key=True,autoincrement=True)
title = db.Column(db.String(100),nullable=False)
content = db.Column(db.Text,nullable=False)
# author_id引用user表中的id,author_id就是User中的id
author_id = db.Column(db.Integer,db.ForeignKey('user.id'))
# 需要添加下列这一行, 否则在mysql5.7数据库,这个外键关联不生效.
author = db.relationship('User',backref=db.backref('articles'))
- shyou8133:学数据库的时候报错{SQLAlchemy' object has no attribute 'Cloumn'}啦,
连接:https://www.jianshu.com/p/524aa7d6ae0d
- 溢熙:[大哭]啊...表里没东西怎么办呐
- 流年ol:赞赞赞!!!!