1、ipython(shell)的安装与使用:
安装:直接在pycharm中下载ipython包即可。
使用:直接在pycharm下的console中键入即可。
2、sql增删改:
'''
In [1]: from Flask_SQLalchemy_demo import *
添加数据:
In [2]: role = Role(name = 'admin')
In [3]: db.session.add(role)
In [4]: db.session.commit()
In [5]: role = Role(name = 'xue')
In [6]: db.session.add(role)
In [7]: db.session.commit
Out[7]: <bound method instrument.<locals>.do of <sqlalchemy.orm.scoping.scoped_session object at 0x000002B79DE074A8>>
In [8]: db.session.commit()
In [9]: user = User(name = 'heima', role_id = role.id)
In [10]: db.session.add(user)
In [11]: db.session.commit()
修改数据:
In [12]: user.name = 'chengxuyuan'
In [13]: db.session.commit()
删除数据:
In [14]: db.session.delete(user)
In [15]: db.session.commit()
'''