Timestamps

[HValG]

Hello,

I started using denodb recently, in the getting started part I saw the possibility to use
static timestamps = true;

This should add and update created_at and updated_at field in my table if I'm write.
For that I created a table containing the two fields as:
created_at: DataTypes.DATE,
updated_at: DataTypes.DATE

But whenhever I insert something is this table using the api there is null value on both fields.

I am probably doing something wrong but actually I don't know what, do you see something ?

[eveningkid]

Hi,

Thank you for asking the question!

Adding:

static timestamps = true;

Will automatically create createdAt and updatedAt fields for you.

You don't have to add them yourself inside your Model.fields.

Hope this solves your problem, have a great day :)

[HValG]

Hello,

Thank for answer !
Ok I removed the fields, but whenever I create an element and select them all I have:
Wallet { id: 3, name: "test_name", createdat: null, updatedat: null }

Seems like the timestamp is not persisted to db. What is the setup on DB side for this fields to have ?

[flintforge]

Hello.
May I advise an option to allow the insertion of the updatedAt field only,
when activating timestamps and not both creation and update date at the same time ?
In the case of MongoDB, adding a createdAt field is superfluous since it's already encoded in the OID.