[copr] bkabrda-workspace: Add some more data that we may use in future, regenerate the alembic initial DB setup (noone is using this, so no migrations are needed yet) (36c1716)
bkabrda at fedoraproject.org
bkabrda at fedoraproject.org
Mon Nov 26 07:05:10 UTC 2012
Repository : http://git.fedorahosted.org/cgit/copr.git
On branch : bkabrda-workspace
>---------------------------------------------------------------
commit 36c17162b573ba930e172251ea80081972cc6bc9
Author: Bohuslav Kabrda <bkabrda at redhat.com>
Date: Mon Nov 26 08:04:57 2012 +0100
Add some more data that we may use in future, regenerate the alembic initial DB setup (noone is using this, so no migrations are needed yet)
>---------------------------------------------------------------
...b_setup.py => 2d24d28534b6_initial_db_setup.py} | 9 ++++++---
wsgi/coprs/models.py | 3 +++
2 files changed, 9 insertions(+), 3 deletions(-)
diff --git a/wsgi/alembic/versions/2999fd4de2a7_initial_db_setup.py b/wsgi/alembic/versions/2d24d28534b6_initial_db_setup.py
similarity index 90%
rename from wsgi/alembic/versions/2999fd4de2a7_initial_db_setup.py
rename to wsgi/alembic/versions/2d24d28534b6_initial_db_setup.py
index 8c0f24f..8ca01d7 100644
--- a/wsgi/alembic/versions/2999fd4de2a7_initial_db_setup.py
+++ b/wsgi/alembic/versions/2d24d28534b6_initial_db_setup.py
@@ -1,13 +1,13 @@
"""Initial DB setup
-Revision ID: 2999fd4de2a7
+Revision ID: 2d24d28534b6
Revises: None
-Create Date: 2012-11-19 13:09:17.167104
+Create Date: 2012-11-26 08:02:34.063991
"""
# revision identifiers, used by Alembic.
-revision = '2999fd4de2a7'
+revision = '2d24d28534b6'
down_revision = None
from alembic import op
@@ -19,7 +19,9 @@ def upgrade():
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('openid_name', sa.String(length=100), nullable=False),
+ sa.Column('mail', sa.String(length=150), nullable=False),
sa.Column('proven', sa.Boolean(), nullable=True),
+ sa.Column('admin', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('copr',
@@ -27,6 +29,7 @@ def upgrade():
sa.Column('name', sa.String(length=100), nullable=False),
sa.Column('chroots', sa.Text(), nullable=False),
sa.Column('repos', sa.Text(), nullable=True),
+ sa.Column('created_on', sa.Integer(), nullable=True),
sa.Column('build_count', sa.Integer(), nullable=True),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['owner_id'], ['user.id'], ),
diff --git a/wsgi/coprs/models.py b/wsgi/coprs/models.py
index b36315e..3e4f3ae 100644
--- a/wsgi/coprs/models.py
+++ b/wsgi/coprs/models.py
@@ -50,7 +50,9 @@ class Serializer(object):
class User(db.Model, Serializer):
id = db.Column(db.Integer, primary_key = True)
openid_name = db.Column(db.String(100), nullable = False)
+ mail = db.Column(db.String(150), nullable = False)
proven = db.Column(db.Boolean, default = False)
+ admin = db.Column(db.Boolean, default = False)
@property
def name(self):
@@ -86,6 +88,7 @@ class Copr(db.Model, Serializer):
name = db.Column(db.String(100), nullable = False)
chroots = db.Column(db.Text, nullable = False)
repos = db.Column(db.Text)
+ created_on = db.Column(db.Integer)
# duplicate information, but speeds up a lot and makes queries simpler
build_count = db.Column(db.Integer, default = 0)
More information about the copr-devel
mailing list