Output generated DDL for ecto migrations

Question

Is it possible to output the DDL generated by migrations in ecto? I would imagine a command similar to:

mix ecto.migrate --verbose

If we have a create_user migration, it would output something like:

CREATE TABLE users( id int unsigned auto_increment primary key, username varchar(255) not null )

Answer 1

It is now possible to output the migration SQL like this:

 mix ecto.migrate --log-sql > file.sql

Answer 2

Unfortunately, according to the latest doc, there's no option like that. Consider creating issue for that in Ecto.