halvardssm / deno-nessie

A modular Deno library for PostgreSQL, MySQL, MariaDB and SQLite migrations
MIT License
527 stars 31 forks source link

Change migrations timestamps #98

Closed halvardssm closed 3 years ago

halvardssm commented 3 years ago

Is your feature request related to a problem? Please describe. The generated migrations should to be of format YYYYMMddHHmmss for better readability and future proofing.

Describe the solution you'd like Add a command to the cli for converting timestamps to to datetime format. Also add a new option in settings for telling Nessie that the migrations are in datetime format when generating new migrations.

In v2 this option should be datetime by default and there should be a legacy option to allow for timestamps until first minor update of Nessie.

When running Nessie in legacy mode, a warning should show up in the console and tell the user how to switch to the new format.