search

CareSet / DURC

DURC is reverse CRUD
MIT License
3 stars 2 forks source link

Support Temporal Tables in a sensible manner #45

Open ftrotter opened 4 years ago

ftrotter commented 4 years ago

Currently, DURC assumes that created_at and updated_at should be DATETIME types.

DURC should be smart enough to detect and work with MariaDB temporal tables

https://mariadb.com/kb/en/library/temporal-data-tables/

ftrotter commented 4 years ago

I have confirmed that when you use the temporal tables, without creating the explicit variables, that DURC works just fine. Since a table with temporal tables can look just like one that does not, the real feature is going to be checking every MariaDB table to see if it has a "history" and then, when it does, provide some additional version report... (but do nothing for regular tables).

Closing this as a 1.0 consideration