A simple sql migrations file gen tool
grate --name party --path migrations
✅ created ./migrations/1678912821_party.up.sql
✅ created ./migrations/1678912821_party.down.sql
name
- required. the name of the migration, will be appended to the file name after the timestamp.path
- optional. defaults to./migrations
. will generate a new directory if non exists.format
- optional. defaults toauto
. Options areauto
,unix
,datetime
,milli
,int
. Determines the format of the file prefix (ie{prefix}_{name}.up.sql
). When using theauto
format, the tool looks into the path you supplied and finds the most recent file, then uses that convention.