How to forbid assigning id to fields of ForignKey of that object, whose certain field is equal to False?

Question

MySQL

There is a model:

class SomeObj(models.Model):
    name = models.CharField(verbose_name='Название', max_lenght=100)
    active = models.BooleanField(verbose_name='Активный', default=True)
    desc = models.TextField('Примечание', blank=True)

Other models have ForignKey fields on this model. You need to write something like checking if the project is active when assigning the id of this model in the field to another. I know that this can be done using signals and I can roughly imagine how, but signals need to be hung on all tables whose objects need to be checked when saving. Is there a way to do this in a more elegant and versatile way? Thank you!

Answer 1

I understand that in the resulting array you immediately want to group the values ​​​​by attributes.

[loc_work] => Array( тут 1 и более )
[profession] => Array(тут 1 и более )
[com_name] => Array(тут 1 и более )
[com_inds] => Array(тут 1 и более )

For this, group_concat may suit you
https://dev.mysql.com/doc/refman/8.0/en/group-by-f...

Answer 2

If there are connections, they should be described, as I understand it, you need join

Answer 3

do a JOIN and select all the data you need from all tables

Answer 4

You can:
1. Validator for the form ( https://docs.djangoproject.com/en/3.2/topics/forms... )
2. Override the save() of the model ( https://docs.djangoproject.com/en/3.2 /topics/db/mo... )
3. Override form save() ( https://docs.djangoproject.com/en/3.2/topics/forms... )