howyi/conv

Generate MySQL migration queries from actual DB and DDL

v2.1.5 2024-03-21 14:56 UTC

Requires

• php: >=7.1
• ext-pdo: *
• composer/semver: ^1.4 || ^2.0 || ^3.0
• symfony/console: >=2.0

Requires (Dev)

• howyi/conv-test-suite: dev-master
• php-coveralls/php-coveralls: ^2.2
• phpspec/prophecy: ^1.7
• phpstan/phpstan: ^0.12.5
• phpunit/phpunit: ^6.2 || ^7.0
• squizlabs/php_codesniffer: ^3.0
• symfony/var-dumper: ^3.3

MIT

• Hayashi Takuya

README

conv

Core package for howyi/conv-laravel

Generate MySQL migration queries from actual DB and DDL

composer require howyi/conv --dev

Query sample

tbl_user.sql

CREATE TABLE `tbl_user` (
  `user_id` int(11) NOT NULL COMMENT 'User ID',
  `age` tinyint(3) UNSIGNED COMMENT 'User age',
  PRIMARY KEY (`user_id`),
  KEY `id_age` (`user_id`, `age`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='User management table';

Generated migration

UP

CREATE TABLE `tbl_user` (
  `user_id` int(11) NOT NULL COMMENT 'User ID',
  `age` tinyint(3) UNSIGNED COMMENT 'User age',
  PRIMARY KEY (`user_id`),
  KEY `id_age` (`user_id`, `age`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='User management table';

DOWN

DROP TABLE `tbl_user`;

CONTRIBUTING

install

$ composer install

check (before pull-request)

$ composer check-fix