manage.py

监控大型网络的软件。能够自动发现拓扑结构

"""Database wrappers manage
Autogenerated by forgetsql-generate 2006-11-27.
"""

import forgetSQL

#import psycopg

class _Wrapper(forgetSQL.Forgetter):
    """Just a simple wrapper class so that you may
    easily change stuff for all forgetters. Typically
    this involves subclassing MysqlForgetter instead."""

    # Only save changes on .save()
    _autosave = False

    # Example database connection (might lack password)
    #_dbModule = psycopg
    #_dbConnection = psycopg.connect(user='mvold', database='test')
    #def cursor(cls):
    #    return cls._dbConnection.cursor()
    #cursor = classmethod(cursor)


class Alertengine(_Wrapper):
        _sqlTable =  'alertengine'
        _userClasses =  {}
        _sqlFields =  {'lastalertqid': 'lastalertqid'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Alerthist(_Wrapper):
        _sqlTable =  'alerthist'
        _userClasses =  {'alerttype': 'Alerttype',
                          'device': 'Device',
                          'eventtype': 'Eventtype',
                          'netbox': 'Netbox'}
        _sqlFields =  {'alerthistid': 'alerthistid',
                        'alerttype': 'alerttypeid',
                        'device': 'deviceid',
                        'end_time': 'end_time',
                        'eventtype': 'eventtypeid',
                        'netbox': 'netboxid',
                        'severity': 'severity',
                        'source': 'source',
                        'start_time': 'start_time',
                        'subid': 'subid',
                        'value': 'value'}
        _sqlLinks =  {}
        _sqlPrimary =  ('alerthistid',)
        _shortView =  ()
        _descriptions =  {}

class Alerthistmsg(_Wrapper):
        _sqlTable =  'alerthistmsg'
        _userClasses =  {'alerthist': 'Alerthist'}
        _sqlFields =  {'alerthist': 'alerthistid',
                        'language': 'language',
                        'msg': 'msg',
                        'msgtype': 'msgtype',
                        'state': 'state'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Alerthistvar(_Wrapper):
        _sqlTable =  'alerthistvar'
        _userClasses =  {'alerthist': 'Alerthist'}
        _sqlFields =  {'var': 'var', 'alerthist': 'alerthistid', 'state': 'state', 'val': 'val'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Alertq(_Wrapper):
        _sqlTable =  'alertq'
        _userClasses =  {'alerttype': 'Alerttype',
                          'device': 'Device',
                          'eventtype': 'Eventtype',
                          'netbox': 'Netbox'}
        _sqlFields =  {'alertqid': 'alertqid',
                        'alerttype': 'alerttypeid',
                        'device': 'deviceid',
                        'eventtype': 'eventtypeid',
                        'netbox': 'netboxid',
                        'severity': 'severity',
                        'source': 'source',
                        'state': 'state',
                        'subid': 'subid',
                        'time': 'time',
                        'value': 'value'}
        _sqlLinks =  {}
        _sqlPrimary =  ('alertqid',)
        _shortView =  ()
        _descriptions =  {}

class Alertqmsg(_Wrapper):
        _sqlTable =  'alertqmsg'
        _userClasses =  {'alertq': 'Alertq'}
        _sqlFields =  {'alertq': 'alertqid',
                        'language': 'language',
                        'msg': 'msg',
                        'msgtype': 'msgtype'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Alertqvar(_Wrapper):
        _sqlTable =  'alertqvar'
        _userClasses =  {'alertq': 'Alertq'}
        _sqlFields =  {'var': 'var', 'val': 'val', 'alertq': 'alertqid'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Alerttype(_Wrapper):
        _sqlTable =  'alerttype'
        _userClasses =  {'eventtype': 'Eventtype'}
        _sqlFields =  {'alerttype': 'alerttype',
                        'alerttypedesc': 'alerttypedesc',
                        'alerttypeid': 'alerttypeid',
                        'eventtype': 'eventtypeid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('alerttype',)
        _shortView =  ()
        _descriptions =  {}

class Arp(_Wrapper):
        _sqlTable =  'arp'
        _userClasses =  {'netbox': 'Netbox', 'prefix': 'Prefix'}
        _sqlFields =  {'arpid': 'arpid',
                        'end_time': 'end_time',
                        'ip': 'ip',
                        'mac': 'mac',
                        'netbox': 'netboxid',
                        'prefix': 'prefixid',
                        'start_time': 'start_time',
                        'sysname': 'sysname'}
        _sqlLinks =  {}
        _sqlPrimary =  ('arpid',)
        _shortView =  ()
        _descriptions =  {}

class Cabling(_Wrapper):
        _sqlTable =  'cabling'
        _userClasses =  {'room': 'Room'}
        _sqlFields =  {'building': 'building',
                        'cablingid': 'cablingid',
                        'category': 'category',
                        'descr': 'descr',
                        'jack': 'jack',
                        'room': 'roomid',
                        'targetroom': 'targetroom'}
        _sqlLinks =  {}
        _sqlPrimary =  ('cablingid',)
        _shortView =  ()
        _descriptions =  {}

class Cam(_Wrapper):
        _sqlTable =  'cam'
        _userClasses =  {'netbox': 'Netbox', 'module': 'Module'}
        _sqlFields =  {'camid': 'camid',
                        'end_time': 'end_time',
                        'ifindex': 'ifindex',
                        'mac': 'mac',
                        'misscnt': 'misscnt',
                        'module': 'module',
                        'netbox': 'netboxid',
                        'port': 'port',
                        'start_time': 'start_time',
                        'sysname': 'sysname'}
        _sqlLinks =  {}
        _sqlPrimary =  ('camid',)
        _shortView =  ()
        _descriptions =  {}

class Cat(_Wrapper):
        _sqlTable =  'cat'
        _userClasses =  {}
        _sqlFields =  {'req_snmp': 'req_snmp', 'descr': 'descr', 'catid': 'catid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('catid',)
        _shortView =  ()
        _descriptions =  {}

class Device(_Wrapper):
        _sqlTable =  'device'
        _userClasses =  {'product': 'Product', 'deviceorder': 'Deviceorder'}
        _sqlFields =  {'active': 'active',
                        'auto': 'auto',
                        'deviceid': 'deviceid',
                        'deviceorder': 'deviceorderid',
                        'discovered': 'discovered',
                        'fw_ver': 'fw_ver',
                        'hw_ver': 'hw_ver',
                        'product': 'productid',
                        'serial': 'serial',
                        'sw_ver': 'sw_ver'}
        _sqlLinks =  {}
        _sqlPrimary =  ('deviceid',)
        _shortView =  ()
        _descriptions =  {}

class Deviceorder(_Wrapper):
        _sqlTable =  'deviceorder'
        _userClasses =  {'org': 'Org', 'product': 'Product'}
        _sqlFields =  {'arrived': 'arrived',
                        'comment': 'comment',
                        'deviceorderid': 'deviceorderid',
                        'lastupdated': 'lastupdated',
                        'ordered': 'ordered',
                        'ordernumber': 'ordernumber',
                        'org': 'orgid',
                        'product': 'productid',
                        'registered': 'registered',
                        'retailer': 'retailer',
                        'updatedby': 'updatedby',
                        'username': 'username'}
        _sqlLinks =  {}
        _sqlPrimary =  ('deviceorderid',)
        _shortView =  ()
        _descriptions =  {}

class Eventq(_Wrapper):
        _sqlTable =  'eventq'
        _userClasses =  {'device': 'Device', 'eventtype': 'Eventtype', 'netbox': 'Netbox'}
        _sqlFields =  {'device': 'deviceid',
                        'eventqid': 'eventqid',
                        'eventtype': 'eventtypeid',
                        'netbox': 'netboxid',
                        'severity': 'severity',
                        'source': 'source',
                        'state': 'state',
                        'subid': 'subid',
                        'target': 'target',
                        'time': 'time',
                        'value': 'value'}
        _sqlLinks =  {}
        _sqlPrimary =  ('eventqid',)
        _shortView =  ()
        _descriptions =  {}

class Eventqvar(_Wrapper):
        _sqlTable =  'eventqvar'
        _userClasses =  {'eventq': 'Eventq'}
        _sqlFields =  {'var': 'var', 'val': 'val', 'eventq': 'eventqid'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Eventtype(_Wrapper):
        _sqlTable =  'eventtype'
        _userClasses =  {}
        _sqlFields =  {'eventtypedesc': 'eventtypedesc',
                        'eventtypeid': 'eventtypeid',
                        'stateful': 'stateful'}
        _sqlLinks =  {}
        _sqlPrimary =  ('eventtypeid',)
        _shortView =  ()
        _descriptions =  {}

class Gwport(_Wrapper):
        _sqlTable =  'gwport'
        _userClasses =  {'module': 'Module'}
        _sqlFields =  {'gwportid': 'gwportid',
                        'ifindex': 'ifindex',
                        'interface': 'interface',
                        'link': 'link',
                        'masterindex': 'masterindex',
                        'metric': 'metric',
                        'module': 'moduleid',
                        'portname': 'portname',
                        'speed': 'speed',
                        'to_netboxid': 'to_netboxid',
                        'to_swportid': 'to_swportid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('gwportid',)
        _shortView =  ()
        _descriptions =  {}

class Gwportprefix(_Wrapper):
        _sqlTable =  'gwportprefix'
        _userClasses =  {'prefix': 'Prefix', 'gwport': 'Gwport'}
        _sqlFields =  {'hsrp': 'hsrp', 'gwport': 'gwportid', 'prefix': 'prefixid', 'gwip': 'gwip'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Location(_Wrapper):
        _sqlTable =  'location'
        _userClasses =  {}
        _sqlFields =  {'locationid': 'locationid', 'descr': 'descr'}
        _sqlLinks =  {}
        _sqlPrimary =  ('locationid',)
        _shortView =  ()
        _descriptions =  {}

class Maint_component(_Wrapper):
        _sqlTable =  'maint_component'
        _userClasses =  {'maint_task': 'Maint_task'}
        _sqlFields =  {'maint_task': 'maint_taskid', 'value': 'value', 'key': 'key'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Maint_task(_Wrapper):
        _sqlTable =  'maint_task'
        _userClasses =  {}
        _sqlFields =  {'author': 'author',
                        'description': 'description',
                        'maint_end': 'maint_end',
                        'maint_start': 'maint_start',
                        'maint_taskid': 'maint_taskid',
                        'state': 'state'}
        _sqlLinks =  {}
        _sqlPrimary =  ('maint_taskid',)
        _shortView =  ()
        _descriptions =  {}

class Mem(_Wrapper):
        _sqlTable =  'mem'
        _userClasses =  {'device': 'Device', 'netbox': 'Netbox'}
        _sqlFields =  {'device': 'device',
                        'memid': 'memid',
                        'memtype': 'memtype',
                        'netbox': 'netboxid',
                        'size': 'size',
                        'used': 'used'}
        _sqlLinks =  {}
        _sqlPrimary =  ('memid',)
        _shortView =  ()
        _descriptions =  {}

class Message(_Wrapper):
        _sqlTable =  'message'
        _userClasses =  {}
        _sqlFields =  {'author': 'author',
                        'description': 'description',
                        'last_changed': 'last_changed',
                        'messageid': 'messageid',
                        'publish_end': 'publish_end',
                        'publish_start': 'publish_start',
                        'replaced_by': 'replaced_by',
                        'replaces_message': 'replaces_message',
                        'tech_description': 'tech_description',
                        'title': 'title'}
        _sqlLinks =  {}
        _sqlPrimary =  ('messageid',)
        _shortView =  ()
        _descriptions =  {}

class Message_to_maint_task(_Wrapper):
        _sqlTable =  'message_to_maint_task'
        _userClasses =  {'maint_task': 'Maint_task', 'message': 'Message'}
        _sqlFields =  {'maint_task': 'maint_taskid', 'message': 'messageid'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Module(_Wrapper):
        _sqlTable =  'module'
        _userClasses =  {'device': 'Device', 'netbox': 'Netbox'}
        _sqlFields =  {'descr': 'descr',
                        'device': 'deviceid',
                        'downsince': 'downsince',
                        'model': 'model',
                        'module': 'module',
                        'moduleid': 'moduleid',
                        'netbox': 'netboxid',
                        'up': 'up'}
        _sqlLinks =  {}
        _sqlPrimary =  ('moduleid',)
        _shortView =  ()
        _descriptions =  {}

class Netbox(_Wrapper):
        _sqlTable =  'netbox'
        _userClasses =  {'cat': 'Cat',
                          'device': 'Device',
                          'org': 'Org',
                          'prefix': 'Prefix',
                          'room': 'Room',
                          'subcat': 'Subcat',
                          'type': 'Type'}
        _sqlFields =  {'cat': 'catid',
                        'device': 'deviceid',
                        'discovered': 'discovered',
                        'ip': 'ip',
                        'netboxid': 'netboxid',
                        'org': 'orgid',
                        'prefix': 'prefixid',
                        'ro': 'ro',
                        'room': 'roomid',
                        'rw': 'rw',