Newer
Older
from sqlalchemy import Column, Integer, ForeignKey
from pilab.database import Base, MAC, SERIAL, IP
class PiType(Base):
__tablename__ = "pis"
host_id = Column(Integer, ForeignKey('hosts.id'), primary_key=True)
cube_id = Column(Integer, ForeignKey('cubes.id'), primary_key=True)
serial = Column(SERIAL())
position = Column(Integer)
user_data_id = Column(Integer, ForeignKey('user_data.id'))
image_id = Column(Integer, ForeignKey('images.id'))
playbook_id = Column(Integer)
key_id = Column(Integer, ForeignKey('keys.id'))