def get_tags(self): self.__connect() self.curs.execute(TAG_QUERY) tags = self.curs.fetchall() print "Deleting all tags" Tag.objects.all().delete() print "Adding tags" for tag in tags: t = Tag(**tag) t.save() print "Deleting tag hierarchy" TagHierarchy.objects.all().delete() print "Adding tag hierarchy" self.curs.execute(TAG_HIERARCHY_QUERY) tag_hierarchy = self.curs.fetchall() for t in tag_hierarchy: tag = Tag.objects.get(old_id=t.get('tid', None)) if not t.get('parent') == 0: parent = Tag.objects.get(old_id=t.get('parent', None)) else: parent = None t = TagHierarchy(tag=tag, parent=parent) t.save() self.__disconnect()
def get_tags(self): self.__connect() self.curs.execute(TAG_QUERY) tags = self.curs.fetchall() print "Deleting all tags" Tag.objects.all().delete() print "Adding tags" for tag in tags: t = Tag(**tag) t.save() print "Deleting tag hierarchy" TagHierarchy.objects.all().delete() print "Adding tag hierarchy" self.curs.execute(TAG_HIERARCHY_QUERY) tag_hierarchy = self.curs.fetchall() for t in tag_hierarchy: tag = Tag.objects.get(old_id=t.get('tid', None)) if not t.get('parent') == 0: parent = Tag.objects.get(old_id=t.get('parent', None)) else: parent = None t = TagHierarchy(tag=tag, parent=parent) t.save() self.__disconnect()
def get_tags(self): self.__connect() self.curs.execute(TAG_QUERY) tags = self.curs.fetchall() print "Deleting all tags" Tag.objects.all().delete() print "Adding tags" for tag in tags: print tag t = Tag(**tag) t.name = my_decoder(t.name) t.description = my_decoder(t.description) t.save() print "Deleting tag hierarchy" TagHierarchy.objects.all().delete() print "Adding tag hierarchy" self.curs.execute(TAG_HIERARCHY_QUERY) tag_hierarchy = self.curs.fetchall() for t in tag_hierarchy: tag = Tag.objects.get(old_id=t.get('tid', None)) if not t.get('parent') == 0: parent = Tag.objects.get(old_id=t.get('parent', None)) else: parent = None t = TagHierarchy(tag=tag, parent=parent) t.save() # Tag export to CSV #self.__write_tags_to_csv(tags) self.__disconnect()