Auto save into database django

Question

I have a simple DB schema:

class testModel(models.Model):
    modified_by = models.CharField(max_length=50, verbose_name="Modified by")
    modify_date = models.DateTimeField(auto_now_add=True, auto_now=False)
    week = models.DateField( verbose_name="Week date" )
    type = models.CharField(max_length=10, verbose_name="Type")
    value = models.CharField(max_length=4, verbose_name="value")

    def __unicode__(self):
        return str(self.type)

what i want to do is save each action into second table , e.g. testModel_history.

I know I can create such table and import record during each change in first table, but I would like to ask you whether is there the better way to do this ?

Thanks in advance,

Max M · Accepted Answer · 2017-08-09 05:55:59Z

1

Try with an inherited model:

class testModel2(testModel):
    def __init__(testModelObj, self):
        #for every field: self.field_name = testModelObj.field_name

    class Meta:
        db_table = 'your_db_table' #if you want a specific one

Additionally rewrite the save method in testModel:

#in class testModel
def save(self):
    testModel2(self).save()
    super().save()

answered Aug 9, 2017 at 5:55

Max M

5815 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

naren · Accepted Answer · 2017-08-09 06:22:47Z

0

If you really are trying to save only history of actions use Django simple history. https://django-simple-history.readthedocs.io/en/latest/usage.html

Allyou need to do is add history = HistoricalRecords() to all the models you need to track

Eg:

class testModel(models.Model):
    modified_by = models.CharField(max_length=50, verbose_name="Modified by")
    modify_date = models.DateTimeField(auto_now_add=True, auto_now=False)
    week = models.DateField( verbose_name="Week date" )
    type = models.CharField(max_length=10, verbose_name="Type")
    value = models.CharField(max_length=4, verbose_name="value")

    history = HistoricalRecords()

    def __unicode__(self):
        return str(self.type)

answered Aug 9, 2017 at 6:22

naren

15.3k5 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

Auto save into database django

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related