laykou / schema
Schema saving and loading from file for CakePHP 3.0
This package's canonical repository appears to be gone and the package has been frozen as a result.
Installs: 1 538
Dependents: 0
Suggesters: 0
Security: 0
Stars: 3
Watchers: 2
Forks: 2
Type:cakephp-plugin
Requires
- php: >=5.4
- cakephp/cakephp: ~3.0
Requires (Dev)
- cakephp/bake: dev-master
- phpunit/phpunit: *
This package is not auto-updated.
Last update: 2023-03-10 15:15:41 UTC
README
Save the schema into one file and then restore the database from the schema file. The schema is automatically saved when executing cake migrations migrate
.
Supported datasources
- Postgres
- MySQL
- SQL Server
SQLitenot yet
Installation
You can install this plugin into your CakePHP application using composer.
The recommended way to install composer packages is:
composer require-dev laykou/schema
Update your `config/bootstrap.php``:
Plugin::load('Schema', ['bootstrap' => true]);
Usage
The plugin saves the schema of the default
connection to the config/schema.php
file. The structure is similiar to the fixtures fields.
cake schema save
To load the schema back execute
cake schema load
All existing tables in the database are dropped before loading. You will be asked
Loading the schema from the file Database is not empty. 37 tables will be deleted.
Do you want to continue? (y/n)
To disable the question (and answer with yes) run
cake schema load --no-interaction
Seed
The Schema plugin allows you to seed data from the config/seed.php
file. The seed.php
file should return array of tables and rows:
<?php // You can work with custom libraries here or use the Cake's ORM return [ 'articles' => [ [ 'id' => 1, 'category_id' => 1, 'label' => 'CakePHP' ], [ 'id' => 2, 'label' => 'Schema plugin' ] ], 'categories' => [ [ 'id' => 2, 'label' => 'Frameworks' ] ] ];
Other examples
cake schema save --connection test cake schema save --path config/schema/schema.lock cake schema load --connection test --path config/schema/schema.lock --no-interaction # To only drop all tables in database cake schema drop cake schema drop --connection test # Truncate tables before inserting. Otherwise duplicate ID exception is thrown. cake schema seed --truncate cake schema seed --seed custom/path/to/seed.php cake schema seed --connection test --truncate
To seed the data into database run following command:
cake schema seed
TODO
- Auto-creation of the schema.php file after
cake migrations migrate
- Data seeding
- Tests
- More options and configuration
- Refactoring and cleaning the code
Known issues
- SQLite is not fully supported