Postgres 和 alembic - 假设 SERIAL 序列

使用Postgres和alembic创建SERIAL序列

sql
CREATE DATABASE mydatabase;

bash
pip install alembic

bash
alembic init mydatabase

bash
alembic revision --autogenerate -m "create serial sequence"

python
from alembic import op
import sqlalchemy as sa
def upgrade():
    op.execute(sa.text('CREATE SEQUENCE mysequence START 1;'))
def downgrade():
    op.execute(sa.text('DROP SEQUENCE mysequence;'))

bash
alembic upgrade head

python
from sqlalchemy import create_engine, Column, Integer
engine = create_engine('postgresql://username:password@localhost/mydatabase')
    
class MyTable(Base):
    __tablename__ = 'mytable'
    id = Column(Integer, primary_key=True, default=sa.text('nextval(\'mysequence\')'))
    # 其他列...