Changeset 2535 for trunk/packages/invirt-database/python/database/models.py

Timestamp:

Oct 29, 2009, 3:40:41 AM (14 years ago)

Author:

broder

Message:

Add builds and build_logs tables to invirt-database for tracking build
history and logs.

File:

• trunk/packages/invirt-database/python/database/models.py (modified) (6 diffs)

trunk/packages/invirt-database/python/database/models.py

@@ -5 +5 @@
 from sqlalchemy.ext.sessioncontext import SessionContext
 from sqlalchemy.ext.assignmapper import assign_mapper
+
+import datetime
 
 from invirt.database import record
@@ -21 +23 @@
            'owners_table',
            'admins_table',
+           'builds_table',
            'Machine',
            'MachineAccess',
@@ -31 +34 @@
            'Owner',
            'Admin',
+           'Build',
            'or_',
            ]
@@ -99 +103 @@
        Column('vms_quota_active', Integer, nullable=True, default=None))
 
+builds_table = Table('builds', meta,
+       Column('build_id', Integer, primary_key=True, nullable=False),
+       Column('package', String, nullable=False),
+       Column('pocket', String, nullable=False),
+       Column('commit', String, nullable=False),
+       Column('version', String, nullable=True, default=None),
+       Column('principal', String, nullable=False),
+       Column('succeeded', Boolean, nullable=False),
+       Column('failed_stage', String, nullable=True, default=None),
+       Column('inserted_at', DateTime, nullable=False, default=datetime.datetime.utcnow))
+
 machine_access_table = Table('machine_access', meta,
        Column('machine_id', Integer, ForeignKey('machines.machine_id', ondelete='CASCADE'), nullable=False, index=True),
@@ -134 +149 @@
     _identity_field = 'user'
 
+class Build(record.Record):
+    _identity_field = 'build_id'
+
 from invirt.database.owner import Owner
 
@@ -151 +169 @@
 session.mapper(Owner, owners_table)
 session.mapper(Admin, admins_table)
+session.mapper(Build, builds_table)
 
 def clear_cache():