class park_asset(db.Model):
__bind_key__ = 'paaf'
id = db.Column(db.Integer, primary_key=True)
park_id = db.Column(db.Integer, db.ForeignKey('asset.id'))
asset_id = db.Column(db.Integer, db.ForeignKey('asset.id'))
description = db.Column(db.Text)
def __init__(self,park_id=None, asset_id=None,desc=""):
self.park_id=park_id
self.asset_id=asset_id
self.description=desc
class asset_value_domain_attributes(db.Model):
__bind_key__ = 'paaf'
id = db.Column(db.Integer, primary_key=True)
park_id = db.Column(db.Integer, db.ForeignKey('park.id'))
asset_id = db.Column(db.Integer, db.ForeignKey('asset.id'))
value_domain_id = db.Column(db.Integer, db.ForeignKey('value_domain.id'))
inputter_id = db.Column(db.Integer, nullable=False)#ID of whoever entered the survey (randomised)
description = db.Column(db.String(70), nullable=True)
asset_quality = db.Column(db.Integer, default=0)
value_generating_status = db.Column(db.Integer, default=0)
location_descriptor = db.Column(db.String(70), nullable=True)
governance_competency = db.Column(db.Integer, default=0)
def __init__(self, asset_id=None, value_domain_id=None,inputter_id=None,description="",asset_quality=0,value_generating_status=0,location_descriptor="",governance_competency=0):
self.asset_id = asset_id
self.value_domain_id = value_domain_id
self.description=description
self.asset_quality=asset_quality
self.value_generating_status=value_generating_status
self.location_descriptor=location_descriptor
self.governance_competency = governance_competency
self.inputter_id=inputter_id
class value_domain(db.Model):
__bind_key__='paaf'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
description = db.Column(db.Text)
parent_id = db.Column(db.Integer, db.ForeignKey('value_domain.id'))
def __init__(self,name="",description="",parent_id=None):
self.name=name
if not parent_id ==None:
self.parent_id=parent_id
self.description = description
def __repr__(self):
return self.name
def kids(self):
return value_domain.query.filter_by(parent_id=self.id).all()
def parent(self):
return value_domain.query.get_or_404(id=self.parent_id)