PhpSchool\LearnYouPhp\Exercise\DatabaseRead

Complexity

Total Complexity

8

Size/Duplication

Total Lines	85
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	3
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	getName()	0	4	1
A	getDescription()	0	4	1
A	getArgs()	0	4	1
A	seed()	0	20	3
A	verify()	0	10	1

<?php

namespace PhpSchool\LearnYouPhp\Exercise;

use Faker\Generator;
use PDO;
use PhpSchool\PhpWorkshop\Exercise\AbstractExercise;
use PhpSchool\PhpWorkshop\Exercise\ExerciseInterface;
use PhpSchool\PhpWorkshop\ExerciseCheck\DatabaseExerciseCheck;
use PhpSchool\PhpWorkshop\SubmissionPatch;
use Symfony\Component\Filesystem\Filesystem;

/**
 * Class DatabaseRead
 * @package PhpSchool\LearnYouPhp\Exercise
 * @author Michael Woodawrd <mikeymike.mw@gmail.com>
 * @author Aydin Hassan <aydin@hotmail.co.uk>
 */
class DatabaseRead extends AbstractExercise implements ExerciseInterface, DatabaseExerciseCheck
{

    /**
     * @var Generator
     */
    private $faker;

    /**
     * @var array
     */
    private $randomRecord;

    /**
     * @param Generator $faker
     */
    public function __construct(Generator $faker)
    {
        $this->faker = $faker;
    }

    /**
     * @return string
     */
    public function getName()
    {
        return 'Database Read';
    }

    /**
     * @return string
     */
    public function getDescription()
    {
        return 'Read an SQL databases contents';
    }

    /**
     * @return array
     */
    public function getArgs()
    {
        return [$this->randomRecord['name']];
    }
    
    /**
     * @param PDO $db
     * @return void
     */
    public function seed(PDO $db)
    {
        $db
            ->exec('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT, age INTEGER, gender TEXT)');
        $stmt = $db->prepare('INSERT INTO users (name, age, gender) VALUES (:name, :age, :gender)');

        $names = [];
        for ($i = 0; $i < $this->faker->numberBetween(5, 15); $i++) {
            $name   = $this->faker->name;
            $age    = rand(18, 90);
            $gender = rand(0, 100) % 2 ? 'male' : 'female';

            $stmt->execute([':name' => $name, ':age' => $age, ':gender' => $gender]);
            $id = $db->lastInsertId();
            $names[$id] = $name;
        }

        $randomId = array_rand($names);
        $this->randomRecord = ['id' => $randomId, 'name' => $names[$randomId]];
    }

    /**
     * @param PDO $db
     * @return bool
     */
    public function verify(PDO $db)
    {
        $sql = 'SELECT name FROM users WHERE id = :id';
        $stmt = $db->prepare($sql);

        $stmt->execute([':id' => $this->randomRecord['id']]);
        $result = $stmt->fetchColumn();
        
        return $result === 'David Attenborough';
    }
}