Is there a slick way in D1 (generated columns, maybe?) to support updatedAt columns? Currently, I'm

Is there a slick way in D1 (generated columns, maybe?) to support updatedAt columns? Currently, I'm using the following.

CREATE TABLE IF NOT EXISTS project (
    id                      INTEGER     NOT NULL    PRIMARY KEY,
    name                    TEXT        NOT NULL,
    slug                    TEXT        NOT NULL    UNIQUE,
    ownerId                 TEXT        NOT NULL,
    createdAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP,
    updatedAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP);

CREATE TRIGGER IF NOT EXISTS project_updatedAt
    AFTER UPDATE ON project
    FOR EACH ROW
    BEGIN
        UPDATE project SET updatedAt = CURRENT_TIMESTAMP WHERE id = OLD.id;
    END;
Was this page helpful?