X-Git-Url: http://xvm.mit.edu/gitweb/invirt/packages/invirt-database.git/blobdiff_plain/be9ccbda3c523e5d1ab3845734943fe55e9fac36..99531f4aebd766e3e29ecebc745b52c7b308e12e:/sipb_xen_database/models.py diff --git a/sipb_xen_database/models.py b/sipb_xen_database/models.py index b075886..1090531 100644 --- a/sipb_xen_database/models.py +++ b/sipb_xen_database/models.py @@ -12,12 +12,15 @@ __all__ = ['meta', 'disk_table', 'types_table', 'cdroms_table', + 'autoinstalls_table', 'Machine', 'MachineAccess', 'NIC', 'Disk', 'Type', - 'CDROM'] + 'CDROM', + 'Autoinstall', + ] meta = DynamicMetaData() ctx = SessionContext(create_session) @@ -58,6 +61,11 @@ cdroms_table = Table('cdroms', meta, Column('cdrom_id', String, primary_key=True, nullable=False), Column('description', String, nullable=False)) +autoinstalls_table = Table('autoinstalls', meta, + Column('autoinstall_id', String, primary_key=True, nullable=False), + Column('description', String, nullable=False), + Column('type_id', String, ForeignKey('types.type_id'), nullable=False)) + machine_access_table = Table('machine_access', meta, Column('machine_id', Integer, ForeignKey('machines.machine_id'), nullable=False, index=True), Column('user', String, nullable=False, index=True), @@ -87,16 +95,21 @@ class CDROM(object): def __repr__(self): return "" % (self.cdrom_id, self.description) +class Autoinstall(object): + def __repr__(self): + return "" % (self.autoinstall_id, self.description, self.type.type_id) + assign_mapper(ctx, Machine, machine_table, - properties={'nics': relation(NIC, backref="machine"), - 'disks': relation(Disk, backref="machine"), - 'type': relation(Type), - 'acl': relation(MachineAccess, backref="machine")}); + properties={'nics': relation(NIC, backref="machine", lazy=False), + 'disks': relation(Disk, backref="machine", lazy=False), + 'type': relation(Type, lazy=False), + 'acl': relation(MachineAccess, backref="machine", lazy=False)}); assign_mapper(ctx, MachineAccess, machine_access_table) assign_mapper(ctx, NIC, nic_table) assign_mapper(ctx, Disk, disk_table) assign_mapper(ctx, Type, types_table) assign_mapper(ctx, CDROM, cdroms_table) +assign_mapper(ctx, Autoinstall, autoinstalls_table) def clear_cache(): """Clear sqlalchemy's cache.