ref: configuration
src/alembic/versions/6454dfce4c2d_add_price_to_product.py
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
"""add price to product Revision ID: 6454dfce4c2d Revises: 6e334556e8f8 Create Date: 2019-12-17 00:18:19.738236 """ from alembic import op import sqlalchemy as sa from sqlalchemy import Column from sqlalchemy.types import DECIMAL # revision identifiers, used by Alembic. revision = '6454dfce4c2d' down_revision = '6e334556e8f8' branch_labels = None depends_on = None def upgrade(): op.add_column('products', Column('price', DECIMAL(10, 2), nullable = False, default = 0) ) def downgrade(): op.drop_column('products', 'price') |