开发者

Django: Many-to-many through a table with (only) compound key

开发者 https://www.devze.com 2023-01-04 13:03 出处:网络
I have a legacy database with a table storing a many-to-many relationship, but without a single primary key column. Is there any way to convince Django to use it anyway?

I have a legacy database with a table storing a many-to-many relationship, but without a single primary key column. Is there any way to convince Django to use it anyway?

Schematically:

Product 1<---->* Labeling *<---->1 Label

The Labeling table uses (product_id,label_id) as a compound primary key, and I don't see any way to inform Django about this. (Just using through gives m开发者_如何学编程e Unknown column 'labeling.id' in 'field list'.)

Do I need to fall back to custom SQL? Or am I missing something?


hope this helps you,

http://docs.djangoproject.com/en/dev/ref/models/options/#unique-together

http://docs.djangoproject.com/en/dev/ref/models/fields/#django.db.models.Field.db_index


If you add a unique_together to the model for the many-to-many table, Django will use those columns instead of expecting a primary key called id.

0

精彩评论

暂无评论...
验证码 换一张
取 消