Alembic

From 탱이의 잡동사니
Revision as of 12:37, 31 August 2020 by Pchero (talk | contribs) (→‎Overview)
Jump to navigation Jump to search

Overview

SQLAlchemy based database migration tool alembic 내용 정리

Add revision

alembic revision 을 사용하면 새로운 변경사항을 추가할 수 있다.

$ alembic -c config.ini revision -m "increse_reg_server_size" 

=== Example ===

$ alembic -c config.ini revision -m "increse_reg_server_size"

 Generating /home/pchero/gittmp/asterisk/contrib/ast-db-manage/config/versions/1ae0609b6646_increse_reg_server_size.py ...  done

Example

<source lang=bash> $ alembic init myproject Creating directory /home/pchero/github/etc_examples/alembic_example/simple_test/myproject ... done Creating directory /home/pchero/github/etc_examples/alembic_example/simple_test/myproject/versions ... done Generating /home/pchero/github/etc_examples/alembic_example/simple_test/myproject/env.py ... done Generating /home/pchero/github/etc_examples/alembic_example/simple_test/myproject/script.py.mako ... done Generating /home/pchero/github/etc_examples/alembic_example/simple_test/myproject/README ... done Generating /home/pchero/github/etc_examples/alembic_example/simple_test/alembic.ini ... done Please edit configuration/connection/logging settings in '/home/pchero/github/etc_examples/alembic_example/simple_test/alembic.ini' before proceeding. $ tree . . ├── alembic.ini └── myproject ├── env.py ├── README ├── script.py.mako └── versions </source>

See also

* https://blog.outsider.ne.kr/1143