


Introduction to the use of flask_migrate and flask_script in python (with code)
This article brings you an introduction to the use of flask_migrate and flask_script in Python (with code). It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.
flask_migrate
When using falsk_sqlalchemy, using 'db.create_all' to modify the database table fields later will not be automatically mapped to the database and must be deleted. Table,
Then re-run 'db.create_all' to remap. This does not meet our requirements, so flask-migrate is to solve
this problem. It can map the modified fields to the database after each modification of the model (class)
from flask_sqlalchemy import SQLAlchemy from flask import Flask import pymysql from sqlalchemy import desc from flask_bootstrap import Bootstrap app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:sheen@localhost/migrate_sql' app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True db = SQLAlchemy(app) app.config['SECRET_KEY'] = 'SHEEN' bootstrap = Bootstrap(app) class User(db.Model): id = db.Column(db.INTEGER,autoincrement=True,primary_key=True) # 用户名唯一且不能为空 name = db.Column(db.String(30),unique=True,nullable=False) # 测试:添加gender属性 gender = db.Column(db.BOOLEAN,default=True) todos = db.relationship('Todo',backref='user') class Todo(db.Model): id = db.Column(db.INTEGER, autoincrement=True, primary_key=True) # unique: 指定该列信息是唯一的; name = db.Column(db.String(50)) user_id = db.Column(db.INTEGER,db.ForeignKey('user.id')) if __name__ == '__main__': db.create_all()
When the database tables user and todo have been generated, and the tables contain data. At this time, we are required to add attributes (user gender) to the database table without affecting user usage. We use database migration to handle it, and add the code to generate attributes in the original database operation file model
# 测试:添加gender属性 gender = db.Column(db.BOOLEAN,default=True)
migrate main attributes
Create migration warehouse (migrations directory)
python manager.py db init
Read the content of the class and generate the version file, without actually adding or deleting it in the database;
python manager.py db migrate -m "添加性别"
Has been deleted in the database;
python manager.py db upgrade
Go to view the historical status of changes;
python manager.py db history
Return to the specified version status;
python manager.py db downgrade base
Manage database changes
Create a new manage.py file to manage database changes
from flask_script import Manager from flask_migrate import Migrate, MigrateCommand from models import app,db migrate = Migrate(app,db) manager = Manager(app) manager.add_command('db',MigrateCommand) if __name__ == '__main__': manager.run()
Steps:
1. 初始化(自动生成migrations目录) python manager.py db init 2. 生成最初的迁移 python manager.py db migrate -m '添加用户性别' 出现语句:Detected added column 'user.gender',表明对model有所改动 3.数据库升级 python manager.py db upgrade 生成数据库历史版本的py文件:Running upgrade -> 202a710ebeb6, '添加用户性别'
flask_script
Flask Script extension provides the function of inserting external scripts into Flask, which separates the script from the system
Overall framework
First, create a The Python template runs the command script, which can be named script.py
In this file, there must be a Manager instance. The Manager class tracks the calling and running status of all commands and processing procedures called on the command line.
Manager only has One parameter - Flask instance
from flask_script import Command,Manager from flask import Flask app = Flask(__name__) manager = Manager(app) if __name__ == '__main__': manager.run()
Create command
Secondly, create and add the command.
There are three ways to create commands, namely creating a Command subclass, using the @command modifier, and using the @option modifier
The first one--Creating a Command subclass
The subclass must define a run method
Create the Hello command and add the Hello command to the Manager instance
class Hello(Command): """欢迎信息""" def run(self): print('hello,sheen') manager.add_command('hello',Hello)
The second type - use the @command modifier of the Command instance
@manager.command def add_user(): """添加用户信息""" print('添加用户成功')
The third type - use Command The @option modifier of the instance
It is recommended to use @option;, multiple parameters can be passed in
@manager.option('-n','--name',help='删除用户') def del_user(name): """删除用户信息""" if name: print('删除用户%s成功' %(name)) else: print('用户名为空!')
Complete example
# script.py from flask_script import Command,Manager from flask import Flask app = Flask(__name__) manager = Manager(app) class Hello(Command): """欢迎信息""" def run(self): print('hello,sheen') manager.add_command('hello',Hello) @manager.command def add_user(): """添加用户信息""" print('添加用户成功') @manager.option('-n','--name',help='删除用户') def del_user(name): """删除用户信息""" if name: print('删除用户%s成功' %(name)) else: print('用户名为空!') if __name__ == '__main__': manager.run()
The above is the detailed content of Introduction to the use of flask_migrate and flask_script in python (with code). For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Under the BeegoORM framework, how to specify the database associated with the model? Many Beego projects require multiple databases to be operated simultaneously. When using Beego...

Two solutions for data consistency between MySQL and Redis: delayed double deletion and first modifying the database and then deleting cache are used to handle data consistency problems in MySQL and Redis, ...

Modifying XML content requires programming, because it requires accurate finding of the target nodes to add, delete, modify and check. The programming language has corresponding libraries to process XML and provides APIs to perform safe, efficient and controllable operations like operating databases.

Issues of defining string constant enumeration in protobuf When using protobuf, you often encounter situations where you need to associate the enum type with string constants...

For small XML files, you can directly replace the annotation content with a text editor; for large files, it is recommended to use the XML parser to modify it to ensure efficiency and accuracy. Be careful when deleting XML comments, keeping comments usually helps code understanding and maintenance. Advanced tips provide Python sample code to modify comments using XML parser, but the specific implementation needs to be adjusted according to the XML library used. Pay attention to encoding issues when modifying XML files. It is recommended to use UTF-8 encoding and specify the encoding format.

Modifying XML with SAX is an event-based strategy involving the following steps: Read XML content and listen for element events. Determine whether the element needs to be modified. Modify in text events. Write the modified content in the end element event.

XML node content modification skills: 1. Use the ElementTree module to locate nodes (findall(), find()); 2. Modify text attributes; 3. Use XPath expressions to accurately locate them; 4. Consider encoding, namespace and exception handling; 5. Pay attention to performance optimization (avoid repeated traversals)

To generate images through XML, you need to use graph libraries (such as Pillow and JFreeChart) as bridges to generate images based on metadata (size, color) in XML. The key to controlling the size of the image is to adjust the values of the <width> and <height> tags in XML. However, in practical applications, the complexity of XML structure, the fineness of graph drawing, the speed of image generation and memory consumption, and the selection of image formats all have an impact on the generated image size. Therefore, it is necessary to have a deep understanding of XML structure, proficient in the graphics library, and consider factors such as optimization algorithms and image format selection.
