接下我们对下表进行操作
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)
一、增加数据
arricle = Article(title="aaa", content="bbb") db.session.add(arricle) db.session.commit()
二、查询数据
#filter: result = Article.query.filter(Article.title=='mark').first() #filter_by: result = Article.query.filter_by(title='mark').first() #查询不到返回404 result= Article.query.get_or_404(id) #关联查询join page_data = Movie.query.join(Tag).filter( Tag.id == Movie.tag_id ).order_by( Movie.addtime ).paginate(page=page, per_page=5) #进行分页 #模糊查询like and统计count movie_count=Movie.query.filter( Movie.title.ilike("%"+key+"%")).count()
三、修改数据
- 查询到要改的数据 拿到Article对象
- 更新 article1.title=’new title’
- db.session.commit()
result = Article.query.filter(Article.title=='success').first() old_title = result.title result.title = 'success2018' db.session.commit()
四、删除
- 查出要删除的数据 拿到Article对象
- db.session.delete(article)
- db.session.commit()
result=Article.query.filter(Article.title=='success2018').first() db.session.delete(result) db.session.commit()