Django Models, cyclic foreign keys

Question

How to model the following relationship:

class Country(models.Model):
  # The capital city of this country
  capital = models.ForeignKey(City)
  ## other country stuff

class City(models.Model):
  # The country where this city lies in
  country = models.ForeignKey(Country)
  ## other city stuff

This obviously doesn't compile. (City is undefined in the definition of Country). Any suggestions?

score 3 · Accepted Answer · edited May 23 '17 at 12:28

3

You can refer to the model by using string instead of a model class:

class Country(models.Model):
  # The capital city of this country
  capital = models.ForeignKey('City', related_name='+')
  ## other country stuff

Also see:

edited May 23 '17 at 12:28

Community

1
1

answered Sep 23 '13 at 19:09

alecxe

462,703
120
1,088
1,195

Works, but need to add related_name parameter. Edited the solution to include this. – Scrontch Sep 23 '13 at 19:25

Django Models, cyclic foreign keys

1 Answers1