diff --git a/alembic/versions/770149d96e24_nullable_project_for_api_token.py b/alembic/versions/770149d96e24_nullable_project_for_api_token.py new file mode 100644 index 0000000..6e1f4f2 --- /dev/null +++ b/alembic/versions/770149d96e24_nullable_project_for_api_token.py @@ -0,0 +1,35 @@ +"""nullable project for api token + +Revision ID: 770149d96e24 +Revises: 987edda096f5 +Create Date: 2017-03-04 18:05:07.956057 + +""" + +# revision identifiers, used by Alembic. +revision = '770149d96e24' +down_revision = '987edda096f5' + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + """ Make the field 'project_id' of the table tokens be nullable. """ + op.alter_column( + 'tokens', + 'project_id', + nullable=True, + existing_nullable=False, + ) + + +def downgrade(): + """ Make the field 'project_id' of the table tokens be not nullable. + """ + op.alter_column( + 'tokens', + 'project_id', + nullable=False, + existing_nullable=True, + ) diff --git a/pagure/lib/model.py b/pagure/lib/model.py index 2167167..0414aa7 100644 --- a/pagure/lib/model.py +++ b/pagure/lib/model.py @@ -2169,7 +2169,7 @@ class Token(BASE): sa.ForeignKey( 'projects.id', onupdate='CASCADE', ), - nullable=False, + nullable=True, index=True) expiration = sa.Column( sa.DateTime, nullable=False, default=datetime.datetime.utcnow)