In SQLAlchemy, how do I create a 'MySQL date' column?

Question

class Posts(Base):
    __tablename__ = 'posts_posts'
    id = Column(Integer, primary_key = True)
    user_id = Column(Integer, nullable=False)
    body = Column(Text, nullable=True)

    created_at = Column(Date) << is this right?
    updated_at = Column(Date) ??

I would also like the created_at column to automatically set the date when it's created. And also, the updated_at column to set the date anytime this row is changed.

van · Accepted Answer · 2011-11-26 13:15:40Z

29

You can provide default and onupdate parameters to Column:

def _get_date():
    return datetime.datetime.now()

class Posts(Base):
    #...
    created_at = Column(Date, default=_get_date)
    updated_at = Column(Date, onupdate=_get_date)

See Column documentation for more info on this one.

answered Nov 26, 2011 at 13:15

van

77.6k13 gold badges174 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

plaes Over a year ago

There's even easier way: updated_at = Column(Date, onupdate=datetime.datetime.now)

Mikko Ohtamaa Over a year ago

Any tips to how to make datetime.datetime.now() timezone aware in SQL Alchemy context?

van Over a year ago

@MikkoOhtamaa: sqlalchemy.types.Datetime takes a parameter timezone with default value of False.

Collectives™ on Stack Overflow

In SQLAlchemy, how do I create a 'MySQL date' column?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related