nezarfadle/dbfixture

Light fixtures loader

DbFixture

This is a light class library working as SQL scripts Executer., _(*1)

Installation

composer require nezarfadle/dbfixture, _(*2)

Usage

1. Create a Database and name it dbfixture ( This could be any name )., _(*3)

2. Create a folder and name it fixtures and save your fixtures files inside it:, _(*4)

fixtures/articles.create.sql
############################

CREATE TABLE IF NOT EXISTS `articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

fixtures/articles.drop.sql
##########################

DROP TABLE IF EXISTS articles;

fixtures/articles.insert.sql
############################

INSERT INTO articles values (1, 'PHP')

1. Create your own Fixture Class by extending the DbFixture class:

// MysqlDbFixture.php 
<?php

use DbFixture\DbFixture;

class MysqlDbFixture extends DbFixture
{

    public function __construct( $dsn, $username, $password )
    {

        $pdo = new \PDO( $dsn, $username, $password, 
            [
                    \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION
            ]
        );

        parent::__construct( $pdo );


    }
}

instantiate a new MysqlDbFixture instance and start using it:, _(*5)

$fixture = new MysqlDbFixture( 'mysql:host=localhost;dbname=dbfixture', 'root', 'password' );

$fixture->runScript('fixtures/articles.create.sql');
$fixture->runScript('fixtures/articles.insert.sql');
$fixture->runScript('fixtures/articles.drop.sql');

Use the basePath method to tell the DbFixture where to find the fixtures files:, _(*6)

$fixture->basePath(__DIR__ . '/fixtures/'); 

$fixture->runScript('articles.create.sql');
$fixture->runScript('articles.insert.sql');
$fixture->runScript('articles.drop.sql');

To load multiple scripts use runScripts method:, _(*7)

$fixture->basePath(__DIR__ . '/fixtures/'); 

$fixture->runScripts( 
    [ 
        'articles.create.sql', 
        'articles.insert.sql',
        'articles.drop.sql'
    ]
);

Use the run method to execute raw SQL statment:, _(*8)

$fixture->run( "INSERT INTO articles values (1, 'PHP')" );

How to run the Test

1. Create a database and name it dbfixture ( This could be any name )
2. Edit the tests/config.php file and set the database credentials

3. run phpunit :, _(*9)

   phpunit