[odrs-web] Allow the alembic migration to fail when deploying
- From: Richard Hughes <rhughes src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [odrs-web] Allow the alembic migration to fail when deploying
- Date: Tue, 2 Jul 2019 11:10:27 +0000 (UTC)
commit a5c9bc78a1d3dd502267b035bcf99fa05e363f49
Author: Richard Hughes <richard hughsie com>
Date: Tue Jul 2 12:10:05 2019 +0100
Allow the alembic migration to fail when deploying
app_data/migrations/versions/19526c284b29_.py | 29 +++++++++++++++++++--------
1 file changed, 21 insertions(+), 8 deletions(-)
---
diff --git a/app_data/migrations/versions/19526c284b29_.py b/app_data/migrations/versions/19526c284b29_.py
index cd1ec34..55cdc8a 100644
--- a/app_data/migrations/versions/19526c284b29_.py
+++ b/app_data/migrations/versions/19526c284b29_.py
@@ -13,6 +13,7 @@ down_revision = '84deb10331db'
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import mysql
+from sqlalchemy.exc import InternalError
from odrs import db
from odrs.models import User, Moderator, Event, Review, Vote
@@ -24,14 +25,26 @@ def _hash_to_id(user_hash):
return user.user_id
def upgrade():
- op.add_column('eventlog', sa.Column('user_id', sa.Integer(), nullable=True))
- op.add_column('moderators', sa.Column('user_id', sa.Integer(), nullable=True))
- op.add_column('reviews', sa.Column('user_id', sa.Integer(), nullable=True))
- op.add_column('votes', sa.Column('user_id', sa.Integer(), nullable=True))
- op.create_foreign_key(None, 'eventlog', 'users', ['user_id'], ['user_id'])
- op.create_foreign_key(None, 'moderators', 'users', ['user_id'], ['user_id'])
- op.create_foreign_key(None, 'reviews', 'users', ['user_id'], ['user_id'])
- op.create_foreign_key(None, 'votes', 'users', ['user_id'], ['user_id'])
+ try:
+ op.add_column('eventlog', sa.Column('user_id', sa.Integer(), nullable=True))
+ op.create_foreign_key(None, 'eventlog', 'users', ['user_id'], ['user_id'])
+ except InternalError as _:
+ pass
+ try:
+ op.add_column('moderators', sa.Column('user_id', sa.Integer(), nullable=True))
+ op.create_foreign_key(None, 'moderators', 'users', ['user_id'], ['user_id'])
+ except InternalError as _:
+ pass
+ try:
+ op.add_column('reviews', sa.Column('user_id', sa.Integer(), nullable=True))
+ op.create_foreign_key(None, 'reviews', 'users', ['user_id'], ['user_id'])
+ except InternalError as _:
+ pass
+ try:
+ op.add_column('votes', sa.Column('user_id', sa.Integer(), nullable=True))
+ op.create_foreign_key(None, 'votes', 'users', ['user_id'], ['user_id'])
+ except InternalError as _:
+ pass
print('CONVERTING Event')
for val in db.session.query(Event).all():
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]