Pi.py

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)