class Project(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    region = db.Column(db.Integer, db.ForeignKey('regions.id'))

class Region(db.Model):
    name = db.Column(db.String(30))
    id = db.Column(db.Integer, primary_key=True)

@deliverables.route('/<int:cid>')
def deliv_view(cid):
    projects = Project.query.filter(Project.id == cid).all()
    return render_template('ginn/deliview.html', projects = projects)

3

class Region(db.Model):
    id = db.Column(db.Integer, primary_key=True)

class Project(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    region_id = db.Column(db.ForeignKey(Region.id), nullable=False)
    region = db.relationship(Region, backref='projects')

project = Project.query.get(1)
print(project.region.name)