Image.py

from sqlalchemy import Column, Integer, ForeignKey, String, Boolean, DateTime

from pilab.database import Base, MAC, SERIAL, IP



class ScriptType(Base):
    __tablename__ = "scripts"
    id = Column(Integer, primary_key=True)
    name = Column(String)
    owner = Column(String)
    read_only = Column(Boolean)
    script = Column(String)
    script_chroot = Column(String)

class ScriptBindingType(Base):
    __tablename__ = "script_bindings"
    script_id = Column(Integer, ForeignKey('scripts.id'), primary_key=True)
    pi_id = Column(Integer, ForeignKey('pis.host_id'), primary_key=True)

class ImageType(Base):
    __tablename__ = "images"
    id = Column(Integer, primary_key=True)
    name = Column(String)
    version = Column(String)
    owner = Column(String)
    size = Column(Integer)
    public = Column(Boolean)
    cloud_init = Column(Boolean)
    change = Column(DateTime)
    script_id = Column(Integer, ForeignKey('scripts.id'))

class ImageBindingType(Base):
    __tablename__ = "image_bindings"
    image_id = Column(Integer, ForeignKey('images.id'), primary_key=True)
    pi_id = Column(Integer, ForeignKey('pis.host_id'), primary_key=True)

class UserDataType(Base):
    __tablename__ = "user_data"
    id = Column(Integer, primary_key=True)
    owner = Column(String)
    data = Column(String)

class UserDataBindingType(Base):
    __tablename__ = "user_data_bindings"
    user_data_id = Column(Integer, ForeignKey('user_data.id'), primary_key=True)
    pi_id = Column(Integer, ForeignKey('pis.host_id'), primary_key=True)