loadsys/cakephp-basic-seed

Provides a simple mechanism for seeding data into a CakePHP application's database.

Tuesday, June 19, 2018
by jtyost2
Repository
9 Watchers
3 Stars
37,479 Installations

PHP
0 Dependents
0 Suggesters
1 Forks
4 Open issues
14 Versions
6 % Grown

The README.md

CakePHP-Basic-Seed

, _(*1)

Provides a simple mechanism for seeding data into your CakePHP application's database., _(*2)

Requirements

PHP 5.6+
CakePHP 3.0+

:warning: Check the cake-2.x branch for the CakePHP v2.x compatible version. The 1.x.x semver series maintains compatibility with CakePHP 2, while ~2 tracks CakePHP 3., _(*3)

Installation

Composer

$ composer require loadsys/cakephp-basic-seed:~2.0

Usage

Add this plugin to your application by adding this line to your bootstrap.php:

Plugin::load('BasicSeed', ['bootstrap' => false, 'routes' => false]);

This is a command line plugin. To use it:, _(*4)

bin/cake BasicSeed.basic_seed
# Runs the `config/seed.php` seed file.

# or
bin/cake BasicSeed.basic_seed --dev
# Runs `config/seed_dev.php` seed file.

You can also specify --file and it will use the file specified (inside of config/), _(*5)

bin/cake BasicSeed.basic_seed --file seed_staging.php
# Will use the file located at `config/seed_staging.php`.
# This option always overrides --dev.

To create a seed.php file, run the init command:, _(*6)

bin/cake BasicSeed.basic_seed init

To create a seed_dev.php file:, _(*7)

bin/cake BasicSeed.basic_seed init --dev

To create a custom seed file, you can use the --file parameter., _(*8)

bin/cake BasicSeed.basic_seed init --file seed_staging.php

Writing a Seed

The plugin provides a number of helper methods to help get data into your application more efficiently. The most notable of these is $this->importTables($data). This method takes an array structure and iterates over it, converting the array data into Entities and saving them into each named table. The generate structure of the array is as follows:, _(*9)

<?php
/**
 * Example BasicSeed plugin data seed file.
 *
 * Typically in `config/seed.php` or `config/seed_dev.php`.
 */

namespace App\Config\BasicSeed;

// Write your data import statements here.

$data = [
    /**
     * Each key in the top-level of the array must be the proper name of a
     * Table into which the contained records will be imported.
     */
    'TableName' => [

        /**
         * When _truncate is enabled, ALL existing records will be removed
         * from the table before loading!
         */
        //'_truncate' => true,

        /**
         * The _entityOptions array is passed to Table::newEntity() and
         * Table::patchEntity(). It can be used to disable validation.
         *
         * Also be aware that the Shell sets
         * `['accessibleFields' => ['*' => true]]` by default in order to
         * more easily "prime" new Entities with all of the values
         * specified in $data, including fixed primary keys. This bypasses
         * your normal Entity `::$_accessible` settings, so it's good to
         * be aware of this if you're using a seed to "refresh" existing
         * data.
         */
        //'_entityOptions' => [
        //  'validate' => false,
        //],

        /**
         * The _saveOptions array is passed to Table::save(). It can be
         * used to disable rules checking.
         */
        //'_saveOptions' => [
        //  'checkRules' => false,
        //],

        /**
         * You can provide default values that will be merged into each
         * record before the Entity is created. Can be used to reduce
         * unnecessary repetition in imported records.
         */
        '_defaults' => [
            'is_active' => true,
        ],

        /**
         * Everything else is counted as a separate record to import.
         * Remember that combined with [_defaults], you only need to specify
         * the **unique** fields for each record.
         */
        [
            /**
             * Existing DB records will be matched and updated using the
             * primary key, if provided. Otherwise, the Shell will simply
             * attempt to insert every record, so be mindful of fields
             * that require uniqueness.
             */
            'id' => 1,
            'name' => 'record 1',
        ],
    ],
];

/**
 * Perform the data import using the array structure above.
 */
$this->importTables($data);

/**
 * If you want to import another seed file in addition to this one (say
 * for example that in development, you want all of your seed_dev data,
 * **plus** all of your seed data from production), you can call the
 * import yourself directly:
 */
$this->hr();
$this->out('<info>Loading production data in addition to dev data...</info>');
$this->includeFile($this->absolutePath('seed.php'));

Remember that the seed file is just an extension of the BasicSeedShell and that seeds do not have to conform to the above structure. You have access to anything you could normally do from inside a Shell, so for example, this is also a valid seed file:, _(*10)

<?php
/**
 * Another example BasicSeed plugin data seed file.
 */

namespace App\Config\BasicSeed;

$Posts = $this->loadModel('Posts');
$posts = [
    ['id' => 1, 'title' => 'Foo', 'body' => 'Lorem ipsum.'],
    ['id' => 2, 'title' => 'Bar', 'body' => 'The meaning of life is 42.'],
];

foreach ($posts as $p) {
    $entity = $Posts->newEntity($p); // Careful, validation is still on!
    if($Posts->save($entity)) {
        $this->out("Saved {$entity->id}");
    } else {
        $this->warning("Save failed where title = {$entity->title}");
    }
}

...although it's worth point out that ::importTables() performs a more robust version of this exact process for you, including dumping validation errors when they are encountered., _(*11)