Writing Readable Migrations with Nextras Migrations

Transcript

1. Jan Tvrdík
3. but not limited to database snapshot approach mostly not usable delta approach is hard to get right
9. Business Critical Code
10. doctrine:migrations:diff \ --formatted
13. queries wrapped in strings strings wrapped in method calls method calls wrapped in a method body method body wrapped in a class
14. let's give each migration a descriptive name let's make the content match the name let's remove all the noise by using SQL
17. easy to write code completion works well easy to format „Reformat Code“ just works easy to read no noise & well formatted easy to test „Run“ just works „Copy & Paste“ just works no limitations
18. migrations/ ├── 001.sql ├── 002.sql └── ... +---------+----------+---------------------+----+ | file | checksum | executed | ok | +---------+----------+---------------------+----+ | 001.sql | 78634... | 2015-08-28 17:05:03 | 1 | | 002.sql | dda40... | 2015-08-28 17:05:03 | 1 | | 003.sql | 5b9c6... | 2015-08-28 17:05:03 | 1 | +---------+----------+---------------------+----+
19. order is strictly defined new migrations can be only at the end you must always „rebase“ your migrations once executed migration cannot be changed
20. migrations/ ├── structures/ │ ├── 2015-07-21-170126-init.sql │ └── 2015-07-22-144133-photo-description.sql ├── basic-data/ │ └── ... └── dummy-data/ └── ...
21. S B P D L Structures Basic data Dummy data Production Localhost
22. structures DDL only + DML required for DDL basic data DML for tables in 2 (countries, languages…) dummy data for testing app on localhost w/o strict rules because not used on production
23. Symfony commands migrations:continue migrations:reset migrations:create
24. simple web interface when CLI is not available
25. PHP 5.4+ databases PostgreSQL MySQL DBALs Nextras DBAL Nette Database Doctrine DBAL dibi
26. SQL executes all queries in *.sql file PHP for complex migrations
27. extensions: migrations: Nextras\Migrations\Bridges\NetteDI\MigrationsExtension migrations: dir: %appDir%/../migrations # base directory driver: pgsql # pgsql or mysql dbal: doctrine # nextras, nette, doctrine or dibi diffGenerator: doctrine ignoredQueriesFile: "%appDir%/../migrations/ignored.sql"
28. new \Nextras\Migrations\Bridges\SymfonyBundle\NextrasMigrationsBundle(); nextras_migrations: dir: "%kernel.root_dir%/migrations" driver: pgsql # pgsql or mysql dbal: nextras # nextras, nette, doctrine or dibi diff_generator: doctrine ignored_queries_file: "%kernel.root_dir%/migrations/ignored.sql"
29. https://github.com/nextras/migrations https://nextras.org/migrations/docs/
30. Twitter + GitHub @JanTvrdik nextras.org