flask使用藍圖
1.首先創(chuàng)建藍圖對象
2.在app/__init__.py注冊藍本
3.藍本定義的程序路由
flask連接mysql數(shù)據(jù)庫和數(shù)據(jù)庫遷移
1.在config.py的文件中配置數(shù)據(jù)庫信息
2.在app/__init__.py完成app和數(shù)據(jù)的關(guān)聯(lián)最住,并生成一個可以操作app數(shù)據(jù)庫的SQLAlchemy實例db
3.創(chuàng)建models模塊 models.py
4.進入shell 導(dǎo)入db 創(chuàng)建表
5.首先在虛擬環(huán)境中安裝Flask-Migrate:
(venv) $ pip install flask-migrate
6.在manage.py配置Falsk-Migrate
7.在維護數(shù)據(jù)庫遷移之前咽笼,要使用init 子命令創(chuàng)建遷移倉庫:
(venv) $ python hello.py db init
8.migrate 子命令用來自動創(chuàng)建遷移腳本:
(venv) $ python hello.py db migrate -m "initial migration"
INFO [alembic.migration] Context impl SQLiteImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.autogenerate] Detected added table 'roles'
INFO [alembic.autogenerate] Detected added table 'users'
INFO [alembic.autogenerate.compare] Detected added index
'ix_users_username' on '['username']'
Generating /home/flask/flasky/migrations/versions/1bc
594146bb5_initial_migration.py...done
9.更新數(shù)據(jù)庫
(venv) $ python hello.py db upgrade
INFO [alembic.migration] Context impl SQLiteImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.migration] Running upgrade None -> 1bc594146bb5, initial migration