Generate migrations from blueprint

[duncanmcclean]

What would you like to see added?

This is something I've told a couple of people about but essentially, my plan at some point is to build a way to automatically generate database migrations, based on field configurations from your blueprint.

How would it work?

It would be smart enough to know which column type each builtin fieldtype should be and it would be clever to change that if max_assets is defined.

If we don't know which column type to use (eg. custom fieldtype) we could maybe just leave it as a string/json column and give the user an error?

This would be some sort of command, like: php please runway:migration order

Considerations

• It would also need to know how to handle changes in a blueprint (eg. field added, field removed, field config changed, etc). I guess in that case we'd just need to do a comparison to what's there and make a new migration with the relevant changes.

Is there a workaround you can use in the meantime?

You could just do it by hand, which is a bit of a sucky option because you then have to define everything twice.

Priority wise - where's this feature for you?

This is just a nice to have. I can deal without.

[johncarter-]

I was thinking about this the other day, nearly started a PR.

It would also be good to have a php please runway:blueprint Order. Where the schema of the model could be mapped or best guessed to a fieldtype and generate a blueprint based on that.

Both are useful, because sometimes you already have an app with your migrations and models already existing, and other times on greenfield projects it would be good to use the blueprint builder to make the migration for you.

[duncanmcclean]

Yeah that's a good idea. Didn't think about the other side of it.

[johncarter-]

It would be a bit of guess work on what column is what fieldtype, but defaulting to text would be okay.

Especially if the Statamic PR for addons registering their own blueprints gets merged, then you can go in and make the tweaks in the CP blueprint builder.

[duncanmcclean]

I've created a pull request for creating migrations from blueprints, it's pretty much ready to merge, just need to check over it again.

Would you mind opening another issue for the 'migration > blueprint' flow? As this one will be closed when the PR is merged.