Dynamicaly connect two models in Django

Question

let's suppose i have two models like below:

class Client(models.Model):
    login = models.CharField(max_length=100)
    password = models.CharField(max_length=100)

class Users(models.Model):
    user_login = models.CharField(max_length=100)
    user_pass = models.CharField(max_length=100)

One model [Users] is filled with data, second [Client] is empty. First i can populate Client based on Users. Now all Django data changes will by held only on Client model.

Question:

How to dynamically connect this two models fields? For example if some data is changed on model Client then according data will by changed also on Users model.

Solution suggestion:

I can update or populate Client data and simultaneously update or populate Users data. Is there another solution to do this?

@WillemVanOnsem there need to by relation one to one. Id of record in one model need to by same as id in second one. If one field is changed then update is held in second model in the same id. — Zaraki Kenpachi, Nov 19 '19 at 11:16

score 0 · Answer 1 · answered Nov 21 '19 at 12:20

0

if login is unique then no need to maintain foreign key relations, You can override the save() methods in both models else You have to maintain the foreign key relation and override the save() methods.

answered Nov 21 '19 at 12:20

Dinesh Gawali

56
5

score 0 · Answer 2 · answered Nov 21 '19 at 13:03

With help of this post i manage to link two models with below code:

class Client(models.Model):
    login = models.CharField(max_length=100)
    password = models.CharField(max_length=100)

    # save previous instance
    def __init__(self, *args, **kwargs):
        super(Invoice, self).__init__(*args, **kwargs)
        self.original_login = self.login

    # override save method to update another model fields
    def save(self, *args, **kwargs):
        # import in place to avoid circular imports
        from app.models import Users

        if self.login != self.original_login:
            Users.objects.filter(id=self.id).update(user_login=self.login)

        # save changed data on Client model
        super(Client, self).save(*args, **kwargs)

The same method goes to the Users model. Note that this two model are in different apps.

Dynamicaly connect two models in Django

2 Answers2