PHP Classes
elePHPant
Icontem

File: tests/EasyDBWriteTest.php

Recommend this page to a friend!
  Classes of Scott Arciszewski  >  EasyDB  >  tests/EasyDBWriteTest.php  >  Download  
File: tests/EasyDBWriteTest.php
Role: Class source
Content type: text/plain
Description: Class source
Class: EasyDB
Simple Database Abstraction Layer around PDO
Author: By
Last change: Fix boolean support with insert()
Date: 11 months ago
Size: 2,811 bytes
 

Contents

Class file image Download
<?php
declare(strict_types=1);

namespace
ParagonIE\EasyDB\Tests;

use
Exception;
use
ParagonIE\EasyDB\Factory;

/**
 * Class EasyDBTest
 * @package ParagonIE\EasyDB\Tests
 */
abstract class EasyDBWriteTest extends EasyDBTest
{

   
/**
    * EasyDB data provider
    * Returns an array of callables that return instances of EasyDB
    * @return array
    * @see EasyDBTest::goodFactoryCreateArgumentProvider()
    */
   
public function goodFactoryCreateArgument2EasyDBProvider()
    {
        return
array_map(
            function (array
$arguments) {
               
$dsn = $arguments[1];
               
$username = isset($arguments[2]) ? $arguments[2] : null;
               
$password = isset($arguments[3]) ? $arguments[3] : null;
               
$options = isset($arguments[4]) ? $arguments[4] : [];
                return [
                    function () use (
$dsn, $username, $password, $options) {
                       
$factory = Factory::create(
                           
$dsn,
                           
$username,
                           
$password,
                           
$options
                       
);
                        try {
                           
$factory->run(
                               
'CREATE TABLE irrelevant_but_valid_tablename (foo char(36) PRIMARY KEY)'
                           
);
                           
$factory->run(
                               
'CREATE TABLE table_with_bool (foo char(36) PRIMARY KEY, bar BOOLEAN)'
                           
);
                        } catch (
Exception $e) {
                           
$this->markTestSkipped($e->getMessage());
                            return
null;
                        }
                        return
$factory;
                    }
                ];
            },
           
$this->goodFactoryCreateArgumentProvider()
        );
    }

   
/**
    * Remaps EasyDBWriteTest::goodFactoryCreateArgument2EasyDBProvider()
    */
   
public function goodFactoryCreateArgument2EasyDBInsertManyProvider()
    {
       
$cbArgsSets = $this->goodFactoryCreateArgument2EasyDBProvider();
       
$args = [
            [
                [
                    [
'foo' => '1'],
                    [
'foo' => '2'],
                    [
'foo' => '3'],
                ],
            ],
        ];

        return \
array_reduce(
           
$args,
            function (array
$was, array $is) use ($cbArgsSets) {
                foreach (
$cbArgsSets as $cbArgs) {
                   
$args = array_values($is);
                    foreach (
array_reverse($cbArgs) as $cbArg) {
                       
array_unshift($args, $cbArg);
                    }
                   
$was[] = $args;
                }

                return
$was;
            },
            []
        );
    }
}