class EnvInfo(db.Model):
__tablename__ = 'env_info'
id = db.Column(db.Integer, primary_key=True)
env_name = db.Column(db.String(50), unique=True)
base_url = db.Column(db.String(50))
desc = db.Column(db.String(200))
def __repr__(self):
return '<env %s>' % self.env_name
class User(db.Model, UserMixin):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(50), unique=True)
password = db.Column(db.String(200))
create_time = db.Column(db.DateTime)
update_time = db.Column(db.DateTime)
def __repr__(self):
return '<User %s>' % self.username
class CaseInfo(db.Model):
__tablename__ = 'case_info'
id = db.Column(db.Integer, primary_key=True)
case_name = db.Column(db.String(50), unique=True)
author = db.Column(db.String(50))
create_time = db.Column(db.DateTime)
update_time = db.Column(db.DateTime)
module_id = db.Column(db.Integer, db.ForeignKey('module_info.id'))
project_id = db.Column(db.Integer, db.ForeignKey('project_info.id'))
def __repr__(self):
return '<Case %s>' % self.case_name
class ModuleInfo(db.Model):
__tablename__ = 'module_info'
id = db.Column(db.Integer, primary_key=True)
module_name = db.Column(db.String(50), unique=True, nullable=False)
tester = db.Column(db.String(50))
desc = db.Column(db.String(50))
create_time = db.Column(db.DateTime)
update_time = db.Column(db.DateTime)
project_id = db.Column(db.Integer, db.ForeignKey('project_info.id'))
cases = db.relationship('CaseInfo', backref='module_info')
def __repr__(self):
return '<Module %s>' % self.module_name
class ProjectInfo(db.Model):
__tablename__ = 'project_info'
id = db.Column(db.Integer, primary_key=True)
project_name = db.Column(db.String(50), unique=True)
manager = db.Column(db.String(50))
desc = db.Column(db.String(200))
create_time = db.Column(db.DateTime)
update_time = db.Column(db.DateTime)
cases = db.relationship('CaseInfo', backref='project_info', cascade='all')
modules = db.relationship('ModuleInfo',
backref='project_info',
cascade='all')
def __repr__(self):
return '<Project %s>' % self.project_name
class ConfigInfo(db.Model):
__tablename__ = 'config_info'
id = db.Column(db.Integer, primary_key=True)
config_name = db.Column(db.String(50), unique=True)
def __repr__(self):
return '<Config %s>' % self.config_name