Need to find matching MessageLogs by email address about django-mailer HOT 2 CLOSED

The only way to do it is as follows:

for log in MessageLog.objects.all():
    if "[email protected]" in log.email.to:
        do_something()

This is very bad in terms of performance - you have to load all the MessageLog records from the DB to find the one you are interested in. There is no way to do the filtering in the DB, because we don't store that field separately, and it is found only in data stored using Python's "pickle" format. This is because MesssageLog is just not designed for this - it is designed with django-mailers needs in mind, not your use case.

The answer is "don't do this". If you need a list of all messages sent to a user, create your own model that has a foreign key to your 'person' model, and use this. At the same time as sending mail (with django-mailer or any other mail backend), you should store a record in this table, storing all the details you need. To populate this table initially you may be able to use the data in the MessageLog table. After this initial population, you shouldn't be using MessageLog at all.

from django-mailer.

Thank you for that code. I was not able to get that much working before and when/if needed that will definitely come in handy. As to the separate model, I have started doing this but every once in a while I need to go back to the original message ID and stats returned from the SMTP server so will reserve the above code for an admin details sort of function.

This is VERY much appreciated.

from django-mailer.