[Python] Tortoise database ORM: Aerich migration tool смотреть онлайн

Use Aerich migration tool of Tortoise orm to manage db table and column easily.

#pythontutorial #api #sql #mysql #sqlite #python教學 #fastapi #github #database #postgresql #vscode #codespaces #tortoiseorm #pythondatascience

Source codes:
https://github.com/IOInfinity-NIU/FastAPI-TortoiseORM-SQLite

Video Section:
0:00 How to use Aerich migration tool of Tortoise ORM
0:04 Install the VSCode extension of Python
0:46 Install the VSCode extension of Material icon theme
0:58 Install the VSCode extension of SQLite
1:10 Create SQLite database (product.db)
1:25 Connect SQLite database with SQLite client (product.db)
1:56 Install Aerich, Tortoise ORM and FastAPI libraries (requirements.txt)
3:22 $ pip install -r requirements.txt
3:54 create Aerich configuration file (aerich_config.py)
4:13 Modify the aerich_config.py file (wrong apps structure)
9:53 Create files(tortoise_models.py, modols.py, __init__.py) and folders(tests, aerich) for aerich_config.py
11:41 Modify the tortoise_models.py for product model(dababase table)
17:15 Open new terminal to execute Aerich commands
17:36 Check tortoise_models.py file again
18:31 $ aerich init -t aerich_config.ORM_MIGRATION_SQLITE
20:00 $ aerich init-db (initialize database)
20:37 Raise error message about wrong model struture
20:51 Fix the wrong model struture
22:08 $ aerich init-db (initialize database again after fix above bug)
22:17 Raise error message about "Inited models already, or delete migration/models and try again"
22:30 Remove migrations/models folder
22:08 $ aerich init-db (initialize database again after you remove above models folder)
23:32 Use SQLite client to check the result of db initialization
24:10 Add create_time and update_time fields(variables) to product model
26:26 You open a terminal again for executing aerich commands
26:46 $ aerich migrate (prepare the update script, not access database)
27:24 $ aerich upgrade (access database)
28:16 Remember to subscribe our channel - IOInfinity x 源碼無限

Commands:
$ aerich init -t aerich_config.ORM_MIGRATION_SQLITE
$ aerich init-db
$ aerich migrate
$ aerich upgrade