pvl/verkko/db.py
changeset 6 0f243c59d5d1
parent 2 b0659c867226
child 14 02c21749cb4f
equal deleted inserted replaced
5:91970ce3fc6b 6:0f243c59d5d1
     4 import logging; log = logging.getLogger('pvl.verkko.db')
     4 import logging; log = logging.getLogger('pvl.verkko.db')
     5 
     5 
     6 # schema
     6 # schema
     7 metadata = MetaData()
     7 metadata = MetaData()
     8 
     8 
       
     9 # TODO: count, completely separate dhcp_events?
     9 dhcp_hosts = Table('dhcp_hosts', metadata,
    10 dhcp_hosts = Table('dhcp_hosts', metadata,
    10     Column('rowid',         Integer, primary_key=True),
    11     Column('rowid',         Integer, primary_key=True),
    11 
    12 
    12     # unique
    13     # unique
    13     Column('ip',            String),
    14     Column('ip',            String),