Skip to content

sql-dumper.md

Latest commit

 

History

History
20 lines (14 loc) · 730 Bytes

sql-dumper.md

File metadata and controls

20 lines (14 loc) · 730 Bytes
Raw

SqlDumper

SqlDumper generates SQL queries (CREATE TABLE, ALTER TABLE,...) and saves it into file in given directory. File name has format YYYY-MM-DD-HHMMSS-label.sql. It's compatible with Nextras\Migrations.

$dumper = new Inlm\SchemaGenerator\Dumpers\SqlDumper(__DIR__ . '/migrations/structures/');
$dumper->setHeader(array(
	'SET foreign_key_checks = 1;',
));

You can enable deep structure and save files to subdirectories:

$dumper->setOutputStructure($dumper::YEAR_MONTH); // YYYY/MM/YYYY-MM-DD-HHMMSS.sql
$dumper->setOutputStructure($dumper::YEAR); // YYYY/YYYY-MM-DD-HHMMSS.sql
$dumper->setOutputStructure($dumper::FLAT); // YYYY-MM-DD-HHMMSS.sql