Newer
Older
from sqlalchemy import Column, Integer, ForeignKey, String, Boolean, BigInteger, 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 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 UserDataType(Base):
__tablename__ = "user_data"
id = Column(Integer, primary_key=True)
owner = Column(String)
data = Column(String)