X-Git-Url: http://xvm.mit.edu/gitweb/invirt/packages/invirt-database.git/blobdiff_plain/9cf145e794628fbc4bf11b663fa301404cb0759a..01469c3d7e7c47ece091abdbbd2b342112901b9d:/python/database/models.py diff --git a/python/database/models.py b/python/database/models.py index 798934a..6b53a2a 100644 --- a/python/database/models.py +++ b/python/database/models.py @@ -5,6 +5,9 @@ from sqlalchemy.orm import create_session, relation from sqlalchemy.ext.sessioncontext import SessionContext from sqlalchemy.ext.assignmapper import assign_mapper +from record import * +from owner import Owner + __all__ = ['meta', 'session', 'clear_cache', @@ -86,51 +89,41 @@ autoinstalls_table = Table('autoinstalls', meta, owners_table = Table('owners', meta, Column('owner_id', String, primary_key=True, nullable=False), - Column('ram_quota_total', Integer, nullable=True), - Column('ram_quota_single', Integer, nullable=True), - Column('disk_quota_total', Integer, nullable=True), - Column('disk_quota_single', Integer, nullable=True), - Column('vms_quota_total', Integer, nullable=True), - Column('vms_quota_active', Integer, nullable=True)) + 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), PrimaryKeyConstraint('machine_id', 'user')) -class Machine(object): - def __repr__(self): - return "" % (self.machine_id, self.name, self.owner) +class Machine(Record): + _identity_field = 'name' -class MachineAccess(object): - def __repr__(self): - return "" % (self.machine, self.user) +class MachineAccess(Record): + pass -class NIC(object): - def __repr__(self): - return "" % (self.mac_addr, self.machine_id, self.ip, self.hostname) +class NIC(Record): + pass -class Disk(object): - def __repr__(self): - return "" % (self.machine_id, self.guest_device_name, self.size) +class Disk(Record): + pass -class Type(object): - def __repr__(self): - return "" % (self.type_id, self.description) +class Type(Record): + _identity_field = 'type_id' -class Mirror(object): - def __repr__(self): - return "" % (self.mirror_id) +class Mirror(Record): + _identity_field = 'mirror_id' -class CDROM(object): - def __repr__(self): - return "" % (self.cdrom_id, self.description) +class CDROM(Record): + _identity_field = 'cdrom_id' -class Autoinstall(object): - def __repr__(self): - return "" % (self.autoinstall_id, self.description, self.type.type_id) - -from owner import Owner +class Autoinstall(Record): + _identity_field = 'autoinstall_id' session.mapper(Machine, machine_table, properties={'nics': relation(NIC, backref="machine"),