[copr] master: Add alembic revision to update the database scheme (e6d24e5)

bkabrda at fedoraproject.org bkabrda at fedoraproject.org
Tue Jan 8 12:34:17 UTC 2013


Repository : http://git.fedorahosted.org/cgit/copr.git

On branch  : master

>---------------------------------------------------------------

commit e6d24e582bea3d0e12d70500742a9772c99b6894
Author: Pierre-Yves Chibon <pingou at pingoured.fr>
Date:   Tue Jan 8 11:41:31 2013 +0100

    Add alembic revision to update the database scheme


>---------------------------------------------------------------

 .../versions/32ba137a3d56_add_token_informatio.py  |   33 ++++++++++++++++++++
 1 files changed, 33 insertions(+), 0 deletions(-)

diff --git a/coprs_frontend/alembic/versions/32ba137a3d56_add_token_informatio.py b/coprs_frontend/alembic/versions/32ba137a3d56_add_token_informatio.py
new file mode 100644
index 0000000..64c7515
--- /dev/null
+++ b/coprs_frontend/alembic/versions/32ba137a3d56_add_token_informatio.py
@@ -0,0 +1,33 @@
+"""Add token information to the user table
+
+Revision ID: 32ba137a3d56
+Revises: 595a31c145fb
+Create Date: 2013-01-07 20:56:14.698735
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = '32ba137a3d56'
+down_revision = '595a31c145fb'
+
+from alembic import op
+import sqlalchemy as sa
+
+import datetime
+
+
+def upgrade():
+    """ Add the coluns api_token and api_token_expiration to the user table.
+    """
+    op.add_column('user', sa.Column('api_token', sa.String(40),
+        nullable=False), default='default_token')
+    op.add_column('user', sa.Column('api_token_expiration', sa.Date,
+        nullable=False, default=datetime.date(2000, 1, 1)))
+
+
+def downgrade():
+    """ Drop the coluns api_token and api_token_expiration to the user table.
+    """
+    op.drop_column('user', 'api_token')
+    op.drop_column('user', 'api_token_expiration')
+



More information about the copr-devel mailing list