Closed
Bug 1442008
Opened 8 years ago
Closed 8 years ago
Lando should include timestamps when storing dates in the database
Categories
(Conduit :: Lando, enhancement)
Conduit
Lando
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: smacleod, Assigned: smacleod)
References
Details
(Keywords: conduit-triaged)
Lando API is storing some of the dates it tracks as "timestamp without time zone" types in the postgres database. We should ensure all the dates are being stored with timezone support (set as UTC).
Examples:
- landoapi.models.landing:Landing.updated_at (`db.Column(db.DateTime(), nullable=False`)
- landoapi.models.landing:Landing.created_at (`db.Column(db.DateTime(), nullable=False`)
To get proper timezone support the columns should be using something like:
```
db.Column(db.TIMESTAMP(timezone=True), server_default='NOW()', nullable=False)
```
(server_default is useful for things like created_at timestamps).
Updated•8 years ago
|
Keywords: conduit-triaged
| Assignee | ||
Updated•8 years ago
|
Assignee: nobody → smacleod
| Assignee | ||
Updated•8 years ago
|
Status: NEW → RESOLVED
Closed: 8 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•