class Lab(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), unique=True)
url = db.Column(db.String(256))
type = db.Column(db.String(4096))
fuel_version = db.Column(db.String(64))
ceph_version = db.Column(db.String(64))
lab_general_info = db.Column(db.Text)
lab_meta = db.Column(db.Text)
class Build(db.Model):
id = db.Column(db.Integer, primary_key=True)
build_id = db.Column(db.String(64))
name = db.Column(db.String(64))
md5 = db.Column(db.String(64))
type = db.Column(db.Integer)
def __repr__(self):
return self.build_id + " " + self.name + " " + self.type
class User(db.Model):
def __init__(self, name, username, password, id=None):
self.id = id
self.name = name
self.username = username
self.password = password
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30), nullable=False)
username = db.Column(db.String(100), unique=True, nullable=False)
password = db.Column(db.String(100), unique=True, nullable=False)
def __repr__(self):
return "<User %r>" % self.username
class Result(db.Model):
id = db.Column(db.Integer, primary_key=True)
build_id = db.Column(db.Integer, ForeignKey('build.id'))
lab_id = db.Column(db.Integer, ForeignKey('lab.id'))
date = db.Column(db.DateTime)
param_combination_id = db.Column(db.Integer,
ForeignKey('param_combination.id'))
bandwith = db.Column(db.Float)
meta = db.Column(db.String(4096))
def __repr__(self):
return str(self.bandwith) + " " + str(self.date)
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
body = db.Column(db.Text)
pub_data = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow())
categroy_id = db.Column(db.Integer,
db.ForeignKey('categroy.id'),
nullable=False)
categroy = db.relationship('Categroy',
backref=db.backref('posts', lazy=True))
def __repr__(self):
return '<Post %r> ' % self.title
class Param(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64))
type = db.Column(db.String(64))
descr = db.Column(db.String(4096))
class Categroy(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), nullable=False)
def __repr__(self):
return '<Catrgroy %r> ' % self.title