auto_now not working

[lichen404]

Describe the bug I use auto_now in my model,but when I use update method ,its updated time doesn't update

update mtheod

model

Expected behavior auto_now works when I update data

[daudln]

auto_now fields are not updated on calling .update() method.

auto_now fields are updated only if .save() method is called on model instance.

Be aware that update() does an update at the SQL level and, thus, does not call any save() methods on your models, nor does it emit the pre_save or post_save signals (which are a consequence of calling Model.save()

Based on your scenario, you need to get item, set attribute you want to update and save the instance

@app.put("/movies/{pk}")
async def update_movie(pk: int, movie_in: MovieIn):
    movie = await Movie.filter(id=pk).first()
    if movie:
        # Your staffs
        await movie.save()
        return  # Your staffs
    return  # Your staffs

[waketzheng]

A few months ago, both auto_now and auto_now_add not work at my code. But after I change database from sqlite3 to MySQL, they work fine.