Skip to main content

Relationships

I started getting bored with looking at student pull requests that hardly ever included more than one model. So I decided to make their lives a little more challenging. I'll admit, it was mostly for my benefit, but hey, it's good for them to experiment with relating models to each other too! So now, they are asked to add at least 2 related models to their apps. A little optional challenge.

In Django, there are 3 different fields you can use to represent relationships between models:

1. ForeignKey

This represents a many-to-one relationship. Like pets to a household. This field requires 2 arguments- the related class(the model it is related to) and the on_delete option. So it looks like this:


class Pet(models.Model):

    owner = models.ForeignKey('Owner', on_delete=models.CASCADE)

class Owner(models.Model):

    [insert whatever fields you choose to include in this class here]


On delete >>> cascade is an example often used online. But there are more options than just cascade. Django documentation says you can  CASCADE/ PROTECT/ RESTRICT/ SET_NULL/ SET_DEFAULT/ SET()/ DO_NOTHING. This site provides a pretty good explanation of what these options mean. You can also look at the official Django Docs . 


2. ManyToManyField

This represents a many-to-many relationship. Like pizza and toppings. It has one required argument- the related class(model). When you run the command 'python manage.py migrate', you'll notice that an intermediary join table is generated by Django to represent this relationship. It is named using the field name and the name of the model.


class Topping(models.Model):

    topping = models.ManyToManyField('Pizza')

class Pizza(models.Model):

    [insert whatever fields you choose to include in this class here]


This field also accepts optional arguments and you can read about them in the official Django Docs. 


3. OneToOneField

This represents a one-to-one relationship. No surprises there. According to the Django docs, you can sort of create this relationship with a ForeignKey as long as you indicate that unique=True. The difference is that the relationship will always return a single object. Whereas when using a ForeignKey, a list will be returned. One argument is required- the related class. You can specify a related_name argument. But if you don't, Django will generate one for you using the lowercase name of the current model.


class Toothbrush(models.Model):

    toothbrush = models.OneToOneField('User')

class User(models.Model):

    [insert whatever fields you choose to include in this class here]


Part of designing your database schema is determining how your models should relate to each other. I'm still trying to learn and better understand this better.

Comments

Popular posts from this blog

Deviants in a normal world

It's definitely been a bit since I've seen this graphy. Anyone who has learnt about standard deviation knows this graph. Standard Deviation Standard deviation shows us how spread out all the values in a set are from the mean. The higher the standard deviation, the more spread out the values are over a wider range and the flatter this curve. In a normal distribution, most values are within 1 standard deviation from the mean(the green part of the graph). Apparently NumPy can calculate standard deviation too! import numpy numSet = [ *lots of numbers* ] numSetStdDev = numpy.std(numSet) Variance The variance also indicates how spread out the values in a set are. It measures the average degree to which each value differs from the mean. variance = standard deviation ^2 import numpy numSet = [ *lots of numbers * ] numSetVar = numpy.var(numSet) Source:  https://www.w3schools.com/python/python_ml_standard_deviation.asp

Snakes and ladders

I've started on my Python course. So far, the code has been familiar because the first few basic codes are similar to Javascript. And then modules happened. Confusion and despair! What is the world is 'if __name__ == "__main__": ' and why must I reach this section of my course on a public holiday when none of the instructors are in :( Stack overflow to the rescue, providing me a lifeline while I was drowning in a pit of serpents. I feel eternally indebted to a particular Mr Fooz.  Picture from  here From my understanding, when the Python interpreter reads a source file, it first sets the variable __name__ and then it executes all the code in the file. If that particular file that you are running(i.e. your module) is the main program, the interpreter will assign '__name__ = "__main__" '. Thereafter, any code in the aforementioned 'if' statement is run. If you have, instead, imported a module, the interpreter assigns '__name__ ...

Fizzbuzz

I was today years old when I found out what fizzbuzz was. Yes, I'm late to the party. I was in an interview where the interviewer mentioned that ordinarily they would ask interviewees in for a round of fizzbuzz challenges, as I know. Actually sir, no, I don't know 👀 But he sounded so certain that I must surely know what it is that I was afraid to say anything so I did what I always do when I panic. Look right back saying not a word. I googled this mysterious fizzbuzz problem:  It looks pretty easy. I don't think he meant this actual problem, but problems like this. Because this problem is way too easy to be an actual problem someone asks in an interview. I decided to work on it for fun:  Yup. Super easy. I wish this is all I were asked in an interview 😄