phalcon / phalcon/migrations

[NFR] sql export function

Open
#25 0 comments 0 reactions 2 assignees View on GitHub

@niden is already working on this.

Since Jul 4, 2026.

NFR
Dominant language
PHP
Stars
28
Forks
25
Avg merge
9h 39m
Merged PRs (30d)
2

Description

Sometimes it can be useful to have an export function to export a schema.
A use case could be using your migrations for your testing framework.
To setup the database for the test you want to import an sql dump. It would be great if migrations can export the latest schema without the need to run all the migrations from version 1.

For example:

vendor/bin/phalcon-migrations migrations export 

Will output a full sql dump of the latest migration. For example this could be used with Codeception in the following way.

modules:
   enabled:
      - Db:
         dsn: 'mysql:host=localhost;dbname=testdb'
         user: 'root'
         password: ''
         populate: true # run populator before all tests
         cleanup: true # run populator before each test
         populator: 'mysql -u $user -h $host $dbname < `vendor/bin/phalcon-migrations migrations export `'

Or save a specific version (1.2.1) like

vendor/bin/phalcon-migrations migrations export 1.2.1  > export.sql

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.