Graphql-engine: enable automatic addition of commonly used fields when creating tables

[tombroens]

Corresponds to idea's raised in #1077.

Currently can be implemented with a default now() for created_at and an update trigger for updated_at. Nevertheless, this has to be added manually for every table.

Add an option to be ticked by the developer in the console when creating a table that adds these fields, default and trigger automatically.

[tombroens]

I see (for now already) two options to alter the console:

1. add a checkbox 'add created and updated timestamps' to the checkboxes while creating a table
2. add a button to the modify table page 'add created and update timestamps'
3. more....

The first only enables the user to add them at creation time of the table. The second enables the user to add them at anytime but requires some more logic to check if the fields where already added previously.

[mnlbox]

@tombroens, @0x777 Any news about this?
I think it can be very useful. :wink:

[0x777]

You can use this for now till we add it in the console:

[dsandip]

Commonly used fields:
1) created_at (timestamp; defaults to now())
2) updated_at (timestamp; is set by trigger to now())
3) Primary Key - Id (Integer auto-increment; automatically added as PKey)
4) Primary Key - UUID (UUID; defaults to gen_random_uuid(); automatically added as PKey)

[mnlbox]

@dsandip, @wawhal Maybe relate: #1936, #1980
Add deleted_at for soft delete support based on current docs.

[napalm272]

Is there an eta for this?

[rikinsk-zz]

@napalm272 This feature has been implemented and is under review. It should be released sometime next week

[napalm272]

has this been released yet?

[rikinsk-zz]

@napalm272 Sorry for the delay in this. There were a couple of issues which had been highlighted during the review. Hence some further changes needed to be made. They are done now and this is back up for review. It should be released in a day or two now ideally.