PHP code example of nezarfadle / dbfixture

1. Go to this page and download the library: Download nezarfadle/dbfixture library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

nezarfadle / dbfixture example snippets


// MysqlDbFixture.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 );

        
    }
}


$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');



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

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



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

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



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

 tests/config.php