Django - create dictionary of associated objects

manpreet Best Answer 2 years ago

I'm attempting to build a query which will return a list of all technologies and the score of each user associated with each technology. This is based on the following models:

class Technology(models.Model):
    technology = models.CharField(max_length=64)

class Result(models.Model):
    user = models.ForeignKey(User, on_delete=models.CASCADE)
    technology = models.ForeignKey(technology, on_delete=models.CASCADE)
    skill_level = models.ForeignKey(skill, to_field='level', on_delete=models.CASCADE)

class Skill(models.Model):
    level = models.IntegerField(unique=True)

Essentially I'd like to see somthing similar to the following:

{technology: Cisco, users: {Alex: {skill_level: 1}}, {James: {skill_level: 2}}

I'm not sure whether this can be acheived with a simple query or whether custom joins will need to be done?

I'm also not sure whether I should be building this on the Technologymodel or the Result model?