Flask mysql-Ohimma
## 插入 ...........inset=User(username='itmin', email='itmin@qq.com', phone='13812345678')
db.session.add(inset)
db.session.commit()
## 更新
..............
news=User.query.all()
print news
news.username='test'
db.session.commit()
## 删除
name=User.query.filter_by(username = 'bb').first()
db.session.delete(name)
db.session.commit()
## 查询
1、精确匹配
select_=User.query.filter_by(username='itmin').first()
print(select_.id)
2、模糊匹配
query = User.query.filter(User.email.endswith('@qq.com')).all()
print(query)
3、反向查询
query = User.query.filter(User.username != 'yoyo').first()
print(query)
4、或查询
query = User.query.filter(or_(User.username != 'yoyo', User.email.endswith('@example.com'))).first()
print(query)
5、与查询
query = User.query.filter(and_(User.username != 'yoyo', User.email.endswith('@example.com'))).first()
print(query)
6、查询返回数据的数目
num = User.query.limit(10).all()
print(num)
7、查询全部
data_all = User.query.all()
print(data_all)
for i in range(len(data_all)):
print(data_all.username+" "+data_all.email+" "+data_all.phone)
页:
[1]