# Verknüpfte Anhänge
attachments = db.get_attachments_by_submission_id(submission['submission_id'])
for attachment in attachments:
#print "###### Anhang:", attachment['attachment_role'], attachment['attachment_filename']
if attachment['attachment_content'] is not None:
dehyphenated = fix_hyphenation(strip_tags(attachment['attachment_content'].decode('utf-8')), hyphenation_map)
solr_attachment_bodies[int(attachment['attachment_id'])] = dehyphenated
solr_attachments[attachment['attachment_id']] = str(attachment['attachment_id']) + ' ' + attachment['attachment_role'].decode('utf-8')
matching_streets_attachments = match_streets(streets, dehyphenated.encode('utf-8'))
if matching_streets_attachments is not None:
for street in matching_streets_attachments:
solr_streets[street.decode('utf-8')] = True
# Verknuepfte Personen
people = db.get_attending_people_by_submission_id(int(submission['submission_id']))
if people is not None:
for person in people:
if person['person_name'] is not None:
personstring = str(person['person_id']) + ' ' + person['person_name'].decode('utf-8')
if person['person_organization'] is not None:
personstring += ' ('+ person['person_organization'].decode('utf-8') +')'
solr_people[person['person_id']] = personstring
s.add(id='submission' + str(submission['submission_id']),
betreff=submission['submission_subject'].decode('utf-8'),
aktenzeichen=submission['submission_identifier'].decode('utf-8'),
anhang=solr_attachments.values(),
sitzung=solr_sessions.values(),
gremium=solr_committees.values(),
strasse=unique(solr_streets.keys()),
