Пример #1
0
class rDevice(rObject.rObject):
    def __init__(self, **kkw):
        rObject.rObject.__init__(self, table="device", **kkw)
        self._roles = GenericQueryRecordList()
        self._interfaces = GenericQueryRecordList()
        self._ipaddresses = GenericQueryRecordList()

    def reloadIpReservations(self):
        self._ipreservations.query = (
            "SELECT ip.* FROM {0}.ip_reservation ip INNER JOIN {0}.service s "
            +
            "ON ip.ownerid = s.objectid WHERE s.subscriberid = {1} ORDER BY ip.address"
        ).format(CFG.DB.SCHEMA, self.objectid)
        self._ipreservations.reload(feed=True)

    def reloadInterfaces(self):
        self._interfaces.query = (
            "SELECT mac.* FROM {0}.mac_interface mac WHERE mac.deviceid = {1} ORDER BY mac.deviceid, mac.mac"
        ).format(CFG.DB.SCHEMA, self.objectid)
        self._interfaces.reload(feed=True)

    def getFirstIP(self):
        if not self.getExtraRecordData("first_ip"):
            self.setExtraRecordData(
                "first_ip",
                CFG.CX.getcell("SELECT {0}.get_device_first_ip({1})".format(
                    CFG.DB.SCHEMA, self.objectid)))
        return self.getExtraRecordData("first_ip")

    def _get_ipreservations(self):
        return self._ipreservations

    ipreservations = property(_get_ipreservations)

    def _get_interfaces(self):
        return self._interfaces

    interfaces = property(_get_interfaces)

    def _get_devices(self):
        return self._devices

    devices = property(_get_devices)
Пример #2
0
class rDevice (rObject.rObject):
    def __init__(self, **kkw):
        rObject.rObject.__init__(self, table="device", **kkw)        
        self._roles = GenericQueryRecordList ()
        self._interfaces = GenericQueryRecordList ()        
        self._ipaddresses = GenericQueryRecordList ()        
        
    def reloadIpReservations(self):
        self._ipreservations.query = ("SELECT ip.* FROM {0}.ip_reservation ip INNER JOIN {0}.service s " +
            "ON ip.ownerid = s.objectid WHERE s.subscriberid = {1} ORDER BY ip.address").format (
                CFG.DB.SCHEMA, self.objectid )
        self._ipreservations.reload ( feed=True )

    def reloadInterfaces(self):
        self._interfaces.query = ("SELECT mac.* FROM {0}.mac_interface mac WHERE mac.deviceid = {1} ORDER BY mac.deviceid, mac.mac").format (
                CFG.DB.SCHEMA, self.objectid )
        self._interfaces.reload ( feed=True )    
    
    def getFirstIP(self):
        if not self.getExtraRecordData("first_ip"):
            self.setExtraRecordData("first_ip", CFG.CX.getcell ( "SELECT {0}.get_device_first_ip({1})".format (CFG.DB.SCHEMA, self.objectid) ))
        return self.getExtraRecordData("first_ip")        
        
    def _get_ipreservations(self):
        return self._ipreservations
    ipreservations = property(_get_ipreservations)

    def _get_interfaces(self):
        return self._interfaces
    interfaces = property(_get_interfaces)

    def _get_devices(self):
        return self._devices
    devices = property(_get_devices)

        
    
Пример #3
0
class rSubscriber(rObject.rObject):
    def __init__(self, **kkw):
        from rDevice import rDevice
        rObject.rObject.__init__(self, table="subscriber", **kkw)
        self._ipreservations = GenericQueryRecordList()
        self._macaddresses = GenericQueryRecordList()
        self._devices = GenericQueryRecordList(recordclass=rDevice)

    def reloadIpReservations(self):
        self._ipreservations.query = (
            "SELECT ip.* FROM {0}.ip_reservation ip INNER JOIN {0}.service s "
            +
            "ON ip.ownerid = s.objectid WHERE s.subscriberid = {1} ORDER BY ip.address"
        ).format(CFG.DB.SCHEMA, self.objectid)
        self._ipreservations.reload(feed=True)

    def reloadMACAddresses(self):
        self._macaddresses.query = (
            "SELECT mac.* FROM {0}.mac_interface mac INNER JOIN {0}.service s "
            +
            "ON mac.ownerid = s.objectid WHERE s.subscriberid = {1} ORDER BY mac.mac"
        ).format(CFG.DB.SCHEMA, self.objectid)
        self._macaddresses.reload(feed=True)

    def reloadDevices(self):
        self._devices.query = (
            "SELECT dev.* FROM {0}.service s INNER JOIN {0}._mtm_service_device mtm "
            +
            " ON mtm.serviceid = s.objectid INNER JOIN {0}.device dev ON mtm.deviceid = dev.objectid "
            + " WHERE s.subscriberid= {1} ").format(CFG.DB.SCHEMA,
                                                    self.objectid)
        self._devices.reload(feed=True)

    def _get_ipreservations(self):
        return self._ipreservations

    ipreservations = property(_get_ipreservations)

    def _get_macaddresses(self):
        return self._macaddresses

    macaddresses = property(_get_macaddresses)

    def _get_devices(self):
        return self._devices

    devices = property(_get_devices)
Пример #4
0
class rSubscriber (rObject.rObject):
    def __init__(self, **kkw):
        from rDevice import rDevice
        rObject.rObject.__init__(self, table="subscriber", **kkw)
        self._ipreservations = GenericQueryRecordList ()
        self._macaddresses = GenericQueryRecordList ()
        self._devices = GenericQueryRecordList ( recordclass = rDevice )
        
    def reloadIpReservations(self):
        self._ipreservations.query = ("SELECT ip.* FROM {0}.ip_reservation ip INNER JOIN {0}.service s " +
            "ON ip.ownerid = s.objectid WHERE s.subscriberid = {1} ORDER BY ip.address").format (
                CFG.DB.SCHEMA, self.objectid )
        self._ipreservations.reload ( feed=True )

    def reloadMACAddresses(self):
        self._macaddresses.query = ("SELECT mac.* FROM {0}.mac_interface mac INNER JOIN {0}.service s " +
            "ON mac.ownerid = s.objectid WHERE s.subscriberid = {1} ORDER BY mac.mac").format (
                CFG.DB.SCHEMA, self.objectid )
        self._macaddresses.reload ( feed=True )

    def reloadDevices(self):
        self._devices.query = ("SELECT dev.* FROM {0}.service s INNER JOIN {0}._mtm_service_device mtm " +
            " ON mtm.serviceid = s.objectid INNER JOIN {0}.device dev ON mtm.deviceid = dev.objectid " +
            " WHERE s.subscriberid= {1} ").format (
                CFG.DB.SCHEMA, self.objectid )
        self._devices.reload ( feed=True )
        
    def _get_ipreservations(self):
        return self._ipreservations
    ipreservations = property(_get_ipreservations)

    def _get_macaddresses(self):
        return self._macaddresses
    macaddresses = property(_get_macaddresses)

    def _get_devices(self):
        return self._devices
    devices = property(_get_devices)

        
    
Пример #5
0
 def __init__(self, **kkw):
     from rDevice import rDevice
     rObject.rObject.__init__(self, table="subscriber", **kkw)
     self._ipreservations = GenericQueryRecordList()
     self._macaddresses = GenericQueryRecordList()
     self._devices = GenericQueryRecordList(recordclass=rDevice)
Пример #6
0
 def __init__(self, **kkw):
     rObject.rObject.__init__(self, table="device", **kkw)        
     self._roles = GenericQueryRecordList ()
     self._interfaces = GenericQueryRecordList ()        
     self._ipaddresses = GenericQueryRecordList ()        
Пример #7
0
 def __init__(self, **kkw):
     rObject.rObject.__init__(self, table="device", **kkw)
     self._roles = GenericQueryRecordList()
     self._interfaces = GenericQueryRecordList()
     self._ipaddresses = GenericQueryRecordList()
Пример #8
0
 def __init__(self, **kkw):
     from rDevice import rDevice
     rObject.rObject.__init__(self, table="subscriber", **kkw)
     self._ipreservations = GenericQueryRecordList ()
     self._macaddresses = GenericQueryRecordList ()
     self._devices = GenericQueryRecordList ( recordclass = rDevice )