X-Git-Url: http://xvm.mit.edu/gitweb/invirt/packages/invirt-database.git/blobdiff_plain/338300a538a25a187485c5929812100aa19964de..abf474c8d08537a4ce66068b0bfbd5639391efcb:/python/database/models.py diff --git a/python/database/models.py b/python/database/models.py index e3f2996..f93557c 100644 --- a/python/database/models.py +++ b/python/database/models.py @@ -5,6 +5,8 @@ from sqlalchemy.orm import create_session, relation from sqlalchemy.ext.sessioncontext import SessionContext from sqlalchemy.ext.assignmapper import assign_mapper +from owner import Owner + __all__ = ['meta', 'session', 'clear_cache', @@ -16,6 +18,7 @@ __all__ = ['meta', 'cdroms_table', 'mirrors_table', 'autoinstalls_table', + 'owners_table', 'Machine', 'MachineAccess', 'NIC', @@ -24,6 +27,7 @@ __all__ = ['meta', 'CDROM', 'Mirror', 'Autoinstall', + 'Owner', 'or_', ] @@ -82,6 +86,15 @@ autoinstalls_table = Table('autoinstalls', meta, Column('mirror', String, nullable=False), Column('arch', String, nullable=False)) +owners_table = Table('owners', meta, + Column('owner_id', String, primary_key=True, nullable=False), + Column('ram_quota_total', Integer, nullable=True, default=None), + Column('ram_quota_single', Integer, nullable=True, default=None), + Column('disk_quota_total', Integer, nullable=True, default=None), + Column('disk_quota_single', Integer, nullable=True, default=None), + Column('vms_quota_total', Integer, nullable=True, default=None), + Column('vms_quota_active', Integer, nullable=True, default=None)) + machine_access_table = Table('machine_access', meta, Column('machine_id', Integer, ForeignKey('machines.machine_id', ondelete='CASCADE'), nullable=False, index=True), Column('user', String, nullable=False, index=True), @@ -132,6 +145,7 @@ session.mapper(Mirror, mirrors_table) session.mapper(CDROM, cdroms_table, properties={'mirror': relation(Mirror, backref="cdroms")}) session.mapper(Autoinstall, autoinstalls_table) +session.mapper(Owner, owners_table) def clear_cache(): """Clear sqlalchemy's cache