def init_zupc(self):
zupc = ZUPC()
zupc.insee = '75056'
zupc.nom = 'Paris'
poly = Polygon([(48,2), (49,2), (49,3), (48,3)])
zupc.shape = from_shape(MultiPolygon([poly]), srid=4326)
db.session.add(zupc)
db.session.commit()
zupc.parent_id = zupc.id
zupc2 = ZUPC()
zupc2.insee = '93048'
zupc2.nom = 'Montreuil'
zupc2.parent_id = zupc.id
db.session.add(zupc2)
db.session.commit()
def dashboard():
zupc_parent_id = set()
zupc_parent = []
logger = current_app.logger
query = db.session.query(ADS.zupc_id)
if not current_user.has_role('admin'):
query.filter_by(added_by = current_user.id)
for zupc_tuple in query.distinct():
if not zupc_tuple.zupc_id or zupc_tuple.zupc_id in zupc_parent_id:
continue
zupc = ZUPC.get(zupc_tuple.zupc_id)
if not zupc:
logger.info('Unable to find ZUPC with id: {}'.format(zupc_tuple.zupc_id))
continue
if not zupc.parent:
logger.info('Unable to find a ZUPC parent with id: {}'.format(zupc.parent_id))
continue
if zupc.parent.id in zupc_parent_id:
continue
zupc_parent.append({"insee": zupc.parent.insee, "name": zupc.parent.nom})
zupc_parent_id.add(zupc.parent.id)
return render_template('dash.html', apikey=current_user.apikey, zupc_list=zupc_parent)