How to monitor mysql table change in django?

Question

In order to monitor mysql table change in django, I have written some codes as follows,

while not find_close_signal():
    time.sleep(10)
    if MyProject.models.MyModel.objects.all().exists():
        some_execution()

However, it doesn't work. If there is no entries in the table at the beginning, then some_execution() will never run even later there are records populated into that table through other out-band ways.

Does anyone ever meet such kind of issue?

I also found in "manage.py shell", this problem happens exactly the same: any other entries added into db out of this shell can not be found in this shell. Is this true or I've made some mistake? Thanks

score 1 · Answer 1 · answered Mar 22 '11 at 13:10

1

not sure that this is an issue, but it may be that you have this code executed inside a transaction, so in such a case you can't see any changes.

one more thing is that you can skip ".all()" in this check.

answered Mar 22 '11 at 13:10

Jerzyk

3,662
23
40

score 0 · Accepted Answer · edited May 23 '17 at 12:31

0

Take a look at my answers here:

Why doesn't this loop display an updated object count every five seconds?

How do I deal with this race condition in django?

edited May 23 '17 at 12:31

Community

1
1

answered Mar 22 '11 at 13:46

Tomasz Zieliński

16,136
7
59
83

score 0 · Answer 3 · answered Mar 22 '11 at 14:55

0

You can mark the db as 'dirty' so to make Django discarding cached results:

from django.db import transaction
transaction.set_dirty()

answered Mar 22 '11 at 14:55

Don

16,928
12
63
101

How to monitor mysql table change in django?

3 Answers3