theiconic/fixtures

Load fixtures into database from different formats: Yaml, XML, etc.

Wednesday, May 9, 2018
by mjsilva
Repository
56 Watchers
10 Stars
929 Installations

PHP
0 Dependents
0 Suggesters
5 Forks
4 Open issues
26 Versions
10 % Grown

The README.md

THE ICONIC Database Fixtures

, _(*1)

Description

Fixture manager that allows you to easily load your test data fixtures from different formats into your test database. With an extensible design, it currently support fixtures in the following formats:, _(*2)

Yaml
JSON
MySQL XML Dump

And it currently supports the following databases:, _(*3)

MySQL
Redis

The fixture manager also allows you to replace placeholders in your fixtures programatically. See examples below., _(*4)

Usage

Suppose that you have two fixtures for your country and employee tables called country.xml and employee.yml, respectively. You load them into a MySQL database with a few lines of code:, _(*5)

use TheIconic\Fixtures\FixtureManager\FixtureManager;

// Declare an array with the path to your fixtures
$fixtures = ['./fixtures/country.xml', './fixtures/employee.yml'];

// Create a new Fixture Manager passing such array
$fixtureManager = FixtureManager::create($fixtures);

// Persist the fixtures into your test database as follow
// Create a Default PDO Persister (currently MySQL is default)
// Here you pass host, database name, username and password
$fixtureManager->setDefaultPDOPersister('127.0.0.1', 'test_database', 'root', '123abc');

// Finally, insert fixtures into database, each table will be cleaned before insertion
$fixtureManager->persist();

// You may clean your database if needed at any point doing
$fixtureManager->cleanStorage();

That's it!, _(*6)

Also, FixtureManager has a fluent interface, this means you can chain method calls like..., _(*7)

$fixtureManager
    ->setDefaultPDOPersister('127.0.0.1', 'test_database', 'root', '123abc')
    ->cleanStorage()
    ->persist();

In the values for your fixtures files you can put placeholders instead of real values, this allows you to change the values dynamically, such as, place the current date., _(*8)

To do this, when creating the Fixture Manager pass an array with the keys in the form "fx:placeholder:" inside another array with names of the fixture as key. For example:, _(*9)

use TheIconic\Fixtures\FixtureManager\FixtureManager;

// Declare an array with the path to your fixtures
$fixtures = ['./fixtures/employee.yml'];

// Create a new Fixture Manager passing such array
$fixtureManager = FixtureManager::create(
    $fixtures,
    [
        'employee' => [
            'fx:placeholder:age' => 33
        ]
    ]
);

And the employee.xml file would be (notice the value of "age" field):, _(*10)

<?xml version="1.0"?>
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database name="my_database">
    <table_data name="employee">
        <row>
            <field name="id">1</field>
            <field name="name">John Smith</field>
            <field name="age"/>fx:placeholder:age</field>
        </row>
    </table_data>
</database>
</mysqldump>

You can pass any value you want, just calculate it before passing it to the create static method., _(*11)

Installation

Use Composer to install this package., _(*12)

{
    "require": {
        "theiconic/fixtures": "~1.5"
    }
}

Fixtures Files Examples

XML, use it when you are dealing with fixtures that have NULL values and dates., _(*13)

<?xml version="1.0"?>
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database name="my_database">
    <table_data name="country">
        <row>
            <field name="id">1</field>
            <field name="name">Australia</field>
            <field name="size" xsi:nil="true" />
        </row>
    </table_data>
</database>
</mysqldump>

As an example, you can generate MySQL XML dumps from the commmand line like so, _(*14)

mysqldump -u <USERNAME> -p<PASSWORD> --xml -t my_database my_table > ~/fixtures/my_table.xml

Yaml, use it for simple data that does not has NULL values or dates., _(*15)

country:
  -
    id_country: 2
    iso2_code: AD
    iso3_code: AND
    name: Andorra

JSON, _(*16)

{
  "country": [
    {
      "id_country": 2,
      "iso2_code": "AD",
      "iso3_code": "AND",
      "name": "Andorra"
    }
  ]
}

Contributors

Jorge A. Borges - Main Developer (http://jorgeborges.me)
Aaron Weatherall - (http://www.aaronweatherall.com)
Ollie Brennan - (http://www.epicarena.com)

License

THE ICONIC Database Fixtures is released under the MIT License., _(*17)

The Versions

09/05 2018

dev-feature/add-notifier-interface

Load fixtures into database from different formats: Yaml, XML, etc.

library fixtures

Load fixtures into database from different formats: Yaml, XML, etc.

theiconic/fixtures

The README.md

THE ICONIC Database Fixtures

Description

Usage

Installation

Fixtures Files Examples

Contributors

License

The Versions

dev-feature/add-notifier-interface

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

dev-master

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.5.3

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

dev-update-dependencies

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.5.2

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

dev-feature/json-parser

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

dev-new-symfony-filesystem-test

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.5.1

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.5.0

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.4.1

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.4.0

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.3.0

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.2.8

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.2.7

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.2.6

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.2.5

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM

v1.2.4

The Requires

The Development Requires

by THE ICONIC ENGINEERING TEAM