[bugfix] sqlite ALTER issue
diff --git a/panoramix/migrations/versions/1a48a5411020_adding_slug_to_dash.py b/panoramix/migrations/versions/1a48a5411020_adding_slug_to_dash.py
index e3609ab..c6b8864 100644
--- a/panoramix/migrations/versions/1a48a5411020_adding_slug_to_dash.py
+++ b/panoramix/migrations/versions/1a48a5411020_adding_slug_to_dash.py
@@ -15,7 +15,10 @@
def upgrade():
op.add_column('dashboards', sa.Column('slug', sa.String(length=255), nullable=True))
- op.create_unique_constraint('idx_unique_slug', 'dashboards', ['slug'])
+ try:
+ op.create_unique_constraint('idx_unique_slug', 'dashboards', ['slug'])
+ except:
+ pass
def downgrade():
diff --git a/panoramix/migrations/versions/315b3f4da9b0_adding_log_model.py b/panoramix/migrations/versions/315b3f4da9b0_adding_log_model.py
index 789f46f..d9fdfac 100644
--- a/panoramix/migrations/versions/315b3f4da9b0_adding_log_model.py
+++ b/panoramix/migrations/versions/315b3f4da9b0_adding_log_model.py
@@ -13,17 +13,17 @@
from alembic import op
import sqlalchemy as sa
+
def upgrade():
op.create_table('logs',
- sa.Column('id', sa.Integer(), nullable=False),
- sa.Column('action', sa.String(length=512), nullable=True),
- sa.Column('user_id', sa.Integer(), nullable=True),
- sa.Column('json', sa.Text(), nullable=True),
- sa.Column('dttm', sa.DateTime(), nullable=True),
- sa.ForeignKeyConstraint(['user_id'], ['ab_user.id'], ),
- sa.PrimaryKeyConstraint('id')
+ sa.Column('id', sa.Integer(), nullable=False),
+ sa.Column('action', sa.String(length=512), nullable=True),
+ sa.Column('user_id', sa.Integer(), nullable=True),
+ sa.Column('json', sa.Text(), nullable=True),
+ sa.Column('dttm', sa.DateTime(), nullable=True),
+ sa.ForeignKeyConstraint(['user_id'], ['ab_user.id'], ),
+ sa.PrimaryKeyConstraint('id')
)
- op.drop_table('birth_names')
def downgrade():