Enforce a unique constraint on the machine name column.

[invirt/packages/invirt-database.git] / python / database / models.py

diff --git a/python/database/models.py b/python/database/models.py
index 06e7f3d..77f4109 100644 (file)
--- a/python/database/models.py
+++ b/python/database/models.py
@@ -42,7 +42,7 @@ session = orm.scoped_session(orm.sessionmaker(transactional=False, autoflush=Fal
 
 machine_table = Table('machines', meta,
        Column('machine_id', Integer, primary_key=True, nullable=False),
 
 machine_table = Table('machines', meta,
        Column('machine_id', Integer, primary_key=True, nullable=False),

-       Column('name', String, nullable=False),
+       Column('name', String, nullable=False, unique=True),

        Column('description', String, nullable=False),
        Column('memory', Integer, nullable=False),
        Column('owner', String, nullable=False),
        Column('description', String, nullable=False),
        Column('memory', Integer, nullable=False),
        Column('owner', String, nullable=False),

@@ -111,6 +111,7 @@ builds_table = Table('builds', meta,
        Column('principal', String, nullable=False),
        Column('succeeded', Boolean, nullable=False),
        Column('failed_stage', String, nullable=True, default=None),
        Column('principal', String, nullable=False),
        Column('succeeded', Boolean, nullable=False),
        Column('failed_stage', String, nullable=True, default=None),

+       Column('traceback', String, nullable=True, default=None),

        Column('inserted_at', DateTime, nullable=False, default=datetime.datetime.utcnow))
 
 machine_access_table = Table('machine_access', meta,
        Column('inserted_at', DateTime, nullable=False, default=datetime.datetime.utcnow))
 
 machine_access_table = Table('machine_access', meta,