X-Git-Url: http://xvm.mit.edu/gitweb/invirt/packages/invirt-database.git/blobdiff_plain/a0c92a1e797ab2835921564f36e787ea05274051..5ee142854cff1ace07f40fcf600814f5b70203d3:/sipb_xen_database/models.py?ds=inline diff --git a/sipb_xen_database/models.py b/sipb_xen_database/models.py index d07950a..3f54821 100644 --- a/sipb_xen_database/models.py +++ b/sipb_xen_database/models.py @@ -5,18 +5,22 @@ from sqlalchemy.ext.assignmapper import assign_mapper __all__ = ['meta', 'ctx', + 'clear_cache', 'machine_table', 'machine_access_table', 'nic_table', 'disk_table', 'types_table', 'cdroms_table', + 'autoinstalls_table', 'Machine', 'MachineAccess', 'NIC', 'Disk', 'Type', - 'CDROM'] + 'CDROM', + 'Autoinstall', + ] meta = DynamicMetaData() ctx = SessionContext(create_session) @@ -57,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), @@ -86,13 +95,26 @@ 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), - 'users': relation(MachineAccess, backref="machine")}); + 'acl': relation(MachineAccess, backref="machine")}); 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. + + This _seems_ to be the way; it works, but the docs don't mention + it. Why is this so obscure?""" + + ctx.registry.clear()