# -*- coding: ISO8859-1 -*-

"""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',
                        'snmp_agent': 'snmp_agent',
                        'snmp_version': 'snmp_version',
                        'subcat': 'subcat',
                        'sysname': 'sysname',
                        'type': 'typeid',
                        'up': 'up',
                        'upsince': 'upsince',
                        'uptodate': 'uptodate'}
        _sqlLinks =  {}
        _sqlPrimary =  ('netboxid',)
        _shortView =  ()
        _descriptions =  {}

class Netbox_vtpvlan(_Wrapper):
        _sqlTable =  'netbox_vtpvlan'
        _userClasses =  {'netbox': 'Netbox'}
        _sqlFields =  {'netbox': 'netboxid', 'vtpvlan': 'vtpvlan'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Netboxcategory(_Wrapper):
        _sqlTable =  'netboxcategory'
        _userClasses =  {'netbox': 'Netbox'}
        _sqlFields =  {'category': 'category', 'netbox': 'netboxid'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Netboxinfo(_Wrapper):
        _sqlTable =  'netboxinfo'
        _userClasses =  {'netbox': 'Netbox'}
        _sqlFields =  {'key': 'key',
                        'netbox': 'netboxid',
                        'netboxinfoid': 'netboxinfoid',
                        'val': 'val',
                        'var': 'var'}
        _sqlLinks =  {}
        _sqlPrimary =  ('netboxinfoid',)
        _shortView =  ()
        _descriptions =  {}

class Netboxsnmpoid(_Wrapper):
        _sqlTable =  'netboxsnmpoid'
        _userClasses =  {'netbox': 'Netbox', 'snmpoid': 'Snmpoid'}
        _sqlFields =  {'netbox': 'netboxid', 'frequency': 'frequency', 'snmpoid': 'snmpoidid'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Nettype(_Wrapper):
        _sqlTable =  'nettype'
        _userClasses =  {}
        _sqlFields =  {'edit': 'edit', 'nettypeid': 'nettypeid', 'descr': 'descr'}
        _sqlLinks =  {}
        _sqlPrimary =  ('nettypeid',)
        _shortView =  ()
        _descriptions =  {}

class Org(_Wrapper):
        _sqlTable =  'org'
        _userClasses =  {}
        _sqlFields =  {'descr': 'descr',
                        'opt1': 'opt1',
                        'opt2': 'opt2',
                        'opt3': 'opt3',
                        'orgid': 'orgid',
                        'parent': 'parent'}
        _sqlLinks =  {}
        _sqlPrimary =  ('orgid',)
        _shortView =  ()
        _descriptions =  {}

class Patch(_Wrapper):
        _sqlTable =  'patch'
        _userClasses =  {'swport': 'Swport', 'cabling': 'Cabling'}
        _sqlFields =  {'cabling': 'cablingid',
                        'patchid': 'patchid',
                        'split': 'split',
                        'swport': 'swportid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('patchid',)
        _shortView =  ()
        _descriptions =  {}

class Prefix(_Wrapper):
        _sqlTable =  'prefix'
        _userClasses =  {'vlan': 'Vlan'}
        _sqlFields =  {'prefixid': 'prefixid', 'vlan': 'vlanid', 'netaddr': 'netaddr'}
        _sqlLinks =  {}
        _sqlPrimary =  ('prefixid',)
        _shortView =  ()
        _descriptions =  {}

class Product(_Wrapper):
        _sqlTable =  'product'
        _userClasses =  {'vendor': 'Vendor'}
        _sqlFields =  {'descr': 'descr',
                        'productid': 'productid',
                        'productno': 'productno',
                        'vendor': 'vendorid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('productid',)
        _shortView =  ()
        _descriptions =  {}

class Range(_Wrapper):
        _sqlTable =  'range'
        _userClasses =  {}
        _sqlFields =  {'num': 'num'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Room(_Wrapper):
        _sqlTable =  'room'
        _userClasses =  {'location': 'Location'}
        _sqlFields =  {'descr': 'descr',
                        'location': 'locationid',
                        'opt1': 'opt1',
                        'opt2': 'opt2',
                        'opt3': 'opt3',
                        'opt4': 'opt4',
                        'roomid': 'roomid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('roomid',)
        _shortView =  ()
        _descriptions =  {}

class Rrd_datasource(_Wrapper):
        _sqlTable =  'rrd_datasource'
        _userClasses =  {'rrd_file': 'Rrd_file'}
        _sqlFields =  {'delimiter': 'delimiter',
                        'descr': 'descr',
                        'dstype': 'dstype',
                        'max': 'max',
                        'name': 'name',
                        'rrd_datasourceid': 'rrd_datasourceid',
                        'rrd_file': 'rrd_fileid',
                        'threshold': 'threshold',
                        'thresholdstate': 'thresholdstate',
                        'units': 'units'}
        _sqlLinks =  {}
        _sqlPrimary =  ('rrd_datasourceid',)
        _shortView =  ()
        _descriptions =  {}

class Rrd_file(_Wrapper):
        _sqlTable =  'rrd_file'
        _userClasses =  {'subsystem': 'Subsystem', 'netbox': 'Netbox'}
        _sqlFields =  {'filename': 'filename',
                        'key': 'key',
                        'netbox': 'netboxid',
                        'path': 'path',
                        'rrd_fileid': 'rrd_fileid',
                        'step': 'step',
                        'subsystem': 'subsystem',
                        'value': 'value'}
        _sqlLinks =  {}
        _sqlPrimary =  ('rrd_fileid',)
        _shortView =  ()
        _descriptions =  {}

class Service(_Wrapper):
        _sqlTable =  'service'
        _userClasses =  {'netbox': 'Netbox'}
        _sqlFields =  {'active': 'active',
                        'handler': 'handler',
                        'netbox': 'netboxid',
                        'serviceid': 'serviceid',
                        'up': 'up',
                        'version': 'version'}
        _sqlLinks =  {}
        _sqlPrimary =  ('serviceid',)
        _shortView =  ()
        _descriptions =  {}

class Serviceproperty(_Wrapper):
        _sqlTable =  'serviceproperty'
        _userClasses =  {'service': 'Service'}
        _sqlFields =  {'property': 'property', 'service': 'serviceid', 'value': 'value'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Snmpoid(_Wrapper):
        _sqlTable =  'snmpoid'
        _userClasses =  {}
        _sqlFields =  {'decodehex': 'decodehex',
                        'defaultfreq': 'defaultfreq',
                        'descr': 'descr',
                        'getnext': 'getnext',
                        'match_regex': 'match_regex',
                        'mib': 'mib',
                        'oidkey': 'oidkey',
                        'oidname': 'oidname',
                        'oidsource': 'oidsource',
                        'snmpoid': 'snmpoid',
                        'snmpoidid': 'snmpoidid',
                        'uptodate': 'uptodate'}
        _sqlLinks =  {}
        _sqlPrimary =  ('snmpoidid',)
        _shortView =  ()
        _descriptions =  {}

class Status(_Wrapper):
        _sqlTable =  'status'
        _userClasses =  {}
        _sqlFields =  {'boksid': 'boksid',
                        'fra': 'fra',
                        'statusid': 'statusid',
                        'til': 'til',
                        'tilstandsfull': 'tilstandsfull',
                        'trap': 'trap',
                        'trapdescr': 'trapdescr',
                        'trapsource': 'trapsource'}
        _sqlLinks =  {}
        _sqlPrimary =  ('statusid',)
        _shortView =  ()
        _descriptions =  {}

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

class Subsystem(_Wrapper):
        _sqlTable =  'subsystem'
        _userClasses =  {}
        _sqlFields =  {'name': 'name', 'descr': 'descr'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Swp_netbox(_Wrapper):
        _sqlTable =  'swp_netbox'
        _userClasses =  {'netbox': 'Netbox'}
        _sqlFields =  {'ifindex': 'ifindex',
                        'misscnt': 'misscnt',
                        'netbox': 'netboxid',
                        'swp_netboxid': 'swp_netboxid',
                        'to_netboxid': 'to_netboxid',
                        'to_swportid': 'to_swportid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('swp_netboxid',)
        _shortView =  ()
        _descriptions =  {}

class Swport(_Wrapper):
        _sqlTable =  'swport'
        _userClasses =  {'vlan': 'Vlan', 'module': 'Module'}
        _sqlFields =  {'duplex': 'duplex',
                        'ifindex': 'ifindex',
                        'interface': 'interface',
                        'link': 'link',
                        'media': 'media',
                        'module': 'moduleid',
                        'port': 'port',
                        'portname': 'portname',
                        'speed': 'speed',
                        'swportid': 'swportid',
                        'to_netboxid': 'to_netboxid',
                        'to_swportid': 'to_swportid',
                        'trunk': 'trunk',
                        'vlan': 'vlan'}
        _sqlLinks =  {}
        _sqlPrimary =  ('swportid',)
        _shortView =  ()
        _descriptions =  {}

class Swportallowedvlan(_Wrapper):
        _sqlTable =  'swportallowedvlan'
        _userClasses =  {'swport': 'Swport'}
        _sqlFields =  {'hexstring': 'hexstring', 'swport': 'swportid'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Swportblocked(_Wrapper):
        _sqlTable =  'swportblocked'
        _userClasses =  {'swport': 'Swport', 'vlan': 'Vlan'}
        _sqlFields =  {'swport': 'swportid', 'vlan': 'vlan'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Swportvlan(_Wrapper):
        _sqlTable =  'swportvlan'
        _userClasses =  {'swport': 'Swport', 'vlan': 'Vlan'}
        _sqlFields =  {'direction': 'direction',
                        'swport': 'swportid',
                        'swportvlanid': 'swportvlanid',
                        'vlan': 'vlanid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('swportvlanid',)
        _shortView =  ()
        _descriptions =  {}

class Type(_Wrapper):
        _sqlTable =  'type'
        _userClasses =  {'vendor': 'Vendor'}
        _sqlFields =  {'cdp': 'cdp',
                        'chassis': 'chassis',
                        'cs_at_vlan': 'cs_at_vlan',
                        'descr': 'descr',
                        'frequency': 'frequency',
                        'sysobjectid': 'sysobjectid',
                        'tftp': 'tftp',
                        'typeid': 'typeid',
                        'typename': 'typename',
                        'vendor': 'vendorid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('typeid',)
        _shortView =  ()
        _descriptions =  {}

class Usage(_Wrapper):
        _sqlTable =  'usage'
        _userClasses =  {}
        _sqlFields =  {'usageid': 'usageid', 'descr': 'descr'}
        _sqlLinks =  {}
        _sqlPrimary =  ('usageid',)
        _shortView =  ()
        _descriptions =  {}

class Vendor(_Wrapper):
        _sqlTable =  'vendor'
        _userClasses =  {}
        _sqlFields =  {'vendorid': 'vendorid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('vendorid',)
        _shortView =  ()
        _descriptions =  {}

class Vlan(_Wrapper):
        _sqlTable =  'vlan'
        _userClasses =  {'usage': 'Usage', 'org': 'Org', 'nettype': 'Nettype'}
        _sqlFields =  {'description': 'description',
                        'netident': 'netident',
                        'nettype': 'nettype',
                        'org': 'orgid',
                        'usage': 'usageid',
                        'vlan': 'vlan',
                        'vlanid': 'vlanid'}
        _sqlLinks =  {}
        _sqlPrimary =  ('vlanid',)
        _shortView =  ()
        _descriptions =  {}

class Vp_netbox_grp(_Wrapper):
        _sqlTable =  'vp_netbox_grp'
        _userClasses =  {'vp_netbox_grp_info': 'Vp_netbox_grp_info'}
        _sqlFields =  {'pnetboxid': 'pnetboxid', 'vp_netbox_grp_info': 'vp_netbox_grp_infoid'}
        _sqlLinks =  {}
        _shortView =  ()
        _descriptions =  {}

class Vp_netbox_grp_info(_Wrapper):
        _sqlTable =  'vp_netbox_grp_info'
        _userClasses =  {}
        _sqlFields =  {'hideicons': 'hideicons',
                        'iconname': 'iconname',
                        'name': 'name',
                        'vp_netbox_grp_infoid': 'vp_netbox_grp_infoid',
                        'x': 'x',
                        'y': 'y'}
        _sqlLinks =  {}
        _sqlPrimary =  ('vp_netbox_grp_infoid',)
        _shortView =  ()
        _descriptions =  {}

class Vp_netbox_xy(_Wrapper):
        _sqlTable =  'vp_netbox_xy'
        _userClasses =  {'vp_netbox_grp_info': 'Vp_netbox_grp_info'}
        _sqlFields =  {'pnetboxid': 'pnetboxid',
                        'vp_netbox_grp_info': 'vp_netbox_grp_infoid',
                        'vp_netbox_xyid': 'vp_netbox_xyid',
                        'x': 'x',
                        'y': 'y'}
        _sqlLinks =  {}
        _sqlPrimary =  ('vp_netbox_xyid',)
        _shortView =  ()
        _descriptions =  {}



# Prepare them all. We need to send in our local
# namespace.
forgetSQL.prepareClasses(locals())

