Is there a way to add updated_at column in piccolo ?

[sumitsharansatsangi]

How can I add a table as follows:

class Pet(Table):
    id=UUID(primary_key=True)
    name=Varchar()
    created_at =Timestamp(default=datetime.now())
    updated_at =Timestamp(default=datetime.now())  # Not a right way 

What is happening here is that updated_at is not updating while we update the row using piccolo_admin, the behavior is understood.

One way to do this is using Hooks , but if it has to be done in lots of table, Then it can be quite tedious work.
If piccolo can have something like follows as in django, it will be helpful

class Pet(Table):
    id=UUID(primary_key=True)
    name=Varchar()
    created_at =Timestamp(default=datetime.now())
    updated_at =Timestamp(default_updated=datetime.now()) 

Other way it can be done is using custom datatype, but I don't feel comfortable with it because I have not understood it properly.

[dantownsend]

Give auto_update a try - it should do what you need:

import datetime

class MyTable(Table):
    updated_date = Timestamp(auto_update=datetime.datetime.now)

[sumitsharansatsangi]

Let me try, please.

[sumitsharansatsangi]

Thanks, it works as expected.