DateTimeFields with auto_now and auto_now_add don't change in place

[Andreas]

When saving an instance of a model that includes a DateTimeField with auto_now or auto_now_add, the automatically inserted date will not show up until the instance is reloaded from the db.

Model:

class Task(meta.Model):
    create_date = meta.DateTimeField("Created on", auto_now_add=True)
    title = meta.CharField(maxlength=200)

Behavior:

>>> from django.models.tasks import *
>>> t = Task(title="task")
>>> print 'presave', t.create_date
presave
>>> t.save()
>>> # Now t has a create_date
>>> print 'postsave', t.create_date
postsave
>>> # But it shows only in the database, not in the instance t.

[Andreas]

Ugly workaround:

    def _post_save(self):
        from django.core.db import db 
        cursor = db.cursor() 
        cursor.execute("SELECT tasks_tasks.create_date FROM tasks_tasks WHERE tasks_tasks.id = %s" % str(self.id)) 
        self.create_date = cursor.fetchone()[0]

[richie@…]

I've just been bitten by this, and it took a *long* time to figure out what was going on. Andreas, many thanks for the workaround - ugly or not, it does the job!

[Maniac <Maniac@…>]

It also prevents an object with auto_now_add from being saved twice because it tries to set create_date to :

t.save()
t.title='Another title'
t.save()

gives:

psycopg.ProgrammingError: ERROR: invalid input syntax for type timestamp with time zone: ""

UPDATE "tasks_tasks" SET "id"=1,"create_date"=,"title"='Another title' WHERE "id"=1

[eric@…]

Patch to update date/time fields with whatever was saved into the database.

[eric@…]

I just added a patch that updates the object's date-like fields after saving to the database with the same values that were saved to the database.

[Chris Beaven]

auto_now and auto_now_add have been removed altogether