Fix duplicate tags by using the name as the id

Created by: Tirokk

Authored by roschaefer May 23, 2019 Merged May 28, 2019

---

@ulfgebhardt: I wondered about the list of tags after importing the legacy db. It seems, each tag has at most 1 contribution. I guess it's because we create a unique id for each tag, so two tags with the same name e.g. #hashtag and #hashtag are not de-duplicated.

I'm currently sitting in the train and cannot run the data import myself, could you double-check?

Pullrequest

Issues

• None

Todo

• None

deployment/legacy-migration/maintenance-worker/migration/neo4j/contributions.cql

@@ -20,6 +20,6 @@ MATCH (c:Category {id: categoryId})
 MERGE (p)-[:CATEGORIZED]->(c)
 WITH p, post.tags AS tags
 UNWIND tags AS tag
-MERGE (t:Tag {id: apoc.create.uuid(), name: tag})
+MERGE (t:Tag {id: tag, name: tag})
 MERGE (p)-[:TAGGED]->(t)
 ;