X-Git-Url: http://xvm.mit.edu/gitweb/invirt/packages/invirt-database.git/blobdiff_plain/00e20d087e5980f47d202a6e7c363754a1602b93..615ac39d7b28b7e82dcea456d87f8e806a2b33c5:/sipb_xen_database/models.py?ds=sidebyside diff --git a/sipb_xen_database/models.py b/sipb_xen_database/models.py index fdfe84c..16deb8d 100644 --- a/sipb_xen_database/models.py +++ b/sipb_xen_database/models.py @@ -3,6 +3,17 @@ from sqlalchemy import * from sqlalchemy.ext.sessioncontext import SessionContext from sqlalchemy.ext.assignmapper import assign_mapper +__all__ = ['meta', + 'ctx', + 'machine_table', + 'nic_table', + 'disk_table', + 'types_table', + 'Machine', + 'NIC', + 'Disk', + 'Type'] + meta = DynamicMetaData() ctx = SessionContext(create_session) @@ -20,9 +31,9 @@ machine_table = Table('machines', meta, nic_table = Table('nics', meta, Column('machine_id', Integer, ForeignKey('machines.machine_id'), nullable=True), - Column('mac_addr', String, nullable=False), - Column('ip', String, nullable=False), - Column('hostname', String, primary_key=True, nullable=False)) + Column('mac_addr', String, nullable=False, primary_key=True), + Column('ip', String, nullable=False, unique=True), + Column('hostname', String, nullable=True)) disk_table = Table('disks', meta, Column('machine_id', Integer, ForeignKey('machines.machine_id'), nullable=False), @@ -43,7 +54,11 @@ class Machine(object): pass class NIC(object): - pass + def __init__(self, machine_id, mac_addr, ip, hostname): + self.machine_id = machine_id + self.mac_addr = mac_addr + self.ip = ip + self.hostname = hostname class Disk(object): pass