linkorb/haigha

Alice fixtures for database tables

Friday, July 27, 2018
by joostfaassen
Repository
9 Watchers
23 Stars
5,138 Installations

PHP
3 Dependents
0 Suggesters
6 Forks
1 Open issues
19 Versions
3 % Grown

The README.md

[!TIP] Haigha has been superseeded by the brand new Hatter - similar features, still application independant, but no longer trying to use Alice in a way that it wasn't designed for., _(*1)

Haigha: Alice fixtures for tables

, _(*2)

Alice is an awesome database fixtures library. It works with Doctrine out-of-the-box, but if you don't use the Doctrine ORM, you'll need custom persisters..., _(*3)

This is where Haigha comes in:, _(*4)

Haigha lets you use Alice directly with database tables!, _(*5)

Features

Supports all standard Alice functionality (ranges, optional data, references, inheritence, etc)
Supports Faker data providers
Supports any PDO connection
No need to write classes, directly persist from yml to your sql database

Example fixture file

Haigha uses Alice to load fixture files, so the format is identical (Details). The only thing to keep in mind is that you use tablenames instead of classnames. Prefix your tablenames with table.. For example, if your tablename is called user, you use it like this:, _(*6)

table.group:
  group_random_users:
    id: 1 # This is important for version ~2.0
    name: Random users

table.user:
  random_user{0..9}:
    group_id: @group_random_users
    username: <userName()>
    firstname: <firstName()>
    lastname: <lastName()>
    password: <password()>
    email: <email()>

How to use Haigha in your application

Simply add the following to your require or require-dev section in your composer.json and run composer update:, _(*7)

"require": {
  "linkorb/haigha": "^2.0"
}

You can now use Haigha in your applications, or use the included command-line tool to load fixtures into your database:, _(*8)

Command-line usage

The haigha command-line tool knows one sub-command: fixtures:load., _(*9)

The first argument is the filename of your fixture definition (yaml)., _(*10)

The second argument is the (optional) database url. If no database url is specified, haigha used your PDO environment variable instead., _(*11)

Database URL

A full URL containing username, password, hostname and dbname. For example:, _(*12)

./vendor/bin/haigha fixtures:load examples/random_users.yml mysql://username:password@hostname/dbname

Just a dbname

In this case linkorb/database-manager is used for loading database connection details (server, username, password, etc) from .conf files (read project readme for more details)., _(*13)

In a nutshell - you must have a database_name.conf file at /share/config/database/ as described at database-manager's documentation., _(*14)

./vendor/bin/haigha fixtures:load examples/random_users.yml dbname

Library usage:

You can use Haigha in your own application like this:, _(*15)

// Instantiate a new Alice loader
$loader = new Nelmio\Alice\Fixtures\Loader();

// Add the Haigha instantiator
$instantiator = new Haigha\TableRecordInstantiator();
$loader->addInstantiator($instantiator);

// Load (Haigha) objects from a Alice yml file
$objects = $loader->load('examples/random_users.yml');

// Instantiate the Haigha PDO persister, and pass a PDO connection
$persister = new PdoPersister($pdo);

// Persist the Haigha objects on the PDO connection
$persister->persist($objects);

Test

Customize phpunit.xml:, _(*16)

cp phpunit.xml.dist phpunit.xml

Run:, _(*17)

vendor/bin/phpunit

License

MIT (see LICENSE.md), _(*18)

Brought to you by the LinkORB Engineering team

Check out our other projects at linkorb.com/engineering., _(*19)

Btw, we're hiring!, _(*20)

The Versions

27/07 2018

dev-master

9999999-dev

Alice fixtures for database tables

library haigha

Alice fixtures for database tables

linkorb/haigha

The README.md

Haigha: Alice fixtures for tables

Features

Example fixture file

How to use Haigha in your application

Command-line usage

Database URL

Just a dbname

Library usage:

Test

License

Brought to you by the LinkORB Engineering team

The Versions

dev-master

The Requires

The Development Requires

by Joost Faassen

v2.6.0

The Requires

The Development Requires

by Joost Faassen

v2.5.0

The Requires

The Development Requires

by Joost Faassen

v2.4.1

The Requires

The Development Requires

by Joost Faassen

v2.4.0

The Requires

The Development Requires

by Joost Faassen

v2.3.0

The Requires

The Development Requires

by Joost Faassen

v2.2.0

The Requires

The Development Requires

by Joost Faassen

v2.1.0

The Requires

The Development Requires

by Joost Faassen

v2.0.0

The Requires

by Joost Faassen

v1.2.0

The Requires

by Joost Faassen

v1.1.0

The Requires

by Joost Faassen

v1.0.7

The Requires

by Joost Faassen

v1.0.6

The Requires

by Joost Faassen

v1.0.5

The Requires

by Joost Faassen

v1.0.4

The Requires

by Joost Faassen

v1.0.3

The Requires

by Joost Faassen

v1.0.2

The Requires

by Joost Faassen

1.0.1

The Requires

The Development Requires

by Joost Faassen

v1.0.0