Support for custom directory

[vinnymac]

Thanks for making srtd, great project!

My project utilizes a different structure for storing sql migrations than the one srtd specifies. My team is currently working around this issue by moving files after srtd runs via a script.

---

Example

My migrations are currently stored in the following format:
migrations/[migration_name_with_prefix]/migrate.sql

I would like to keep using my existing pattern, but the migrations that srtd creates are written as:
migrations/[migration_name_with_prefix].sql

---

Would you consider adding support for custom directories?

[t1mmen]

Hey @vinnymac!

This should already work, have you tied adjusting the configuration?

You can initialize default config with npx @t1mmen/srtd init and adjust the paths to your needs, ref https://github.com/t1mmen/srtd/blob/main/srtd.config.json

(Sorry for the late response, didn't catch the issue)

[vinnymac]

Apologies if I am missing something obvious.

Are there some kind of template variables such as $migrationName in the path I can use? I need the path to by dynamic, for example something like:
"migrationDir": "migrations/$migrationName",

And then the file name within those directories is migrate.sql.

[t1mmen]

@vinnymac FYI, you can now customize your migration filenames. Let me know if you run into any trouble :)

[vinnymac]

@t1mmen 👋🏼 just got back from holiday and saw you closed this. Was able to test it out, and it works great 🎉 Tysm