TheCodingMachine\TDBM\Dao\TestCountryDao

Complexity

Total Complexity

4

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getCountriesByUserCount()	0	11	1
A	getCountriesUsingSimpleQuery()	0	9	1
A	getCountriesUsingDistinctQuery()	0	12	1
A	getCountriesUsingUnion()	0	13	1

<?php

declare(strict_types=1);

namespace TheCodingMachine\TDBM\Dao;

use TheCodingMachine\TDBM\ResultInterface;
use TheCodingMachine\TDBM\Test\Dao\Bean\CountryBean;

The type TheCodingMachine\TDBM\Test\Dao\Bean\CountryBean was not found. Maybe you did not declare it correctly or list all dependencies?

use TheCodingMachine\TDBM\Test\Dao\Generated\CountryBaseDao;

The type TheCodingMachine\TDBM\Test\Dao\Generated\CountryBaseDao was not found. Maybe you did not declare it correctly or list all dependencies?

/**
 * The CountryDao class will maintain the persistence of CountryBean class into the country table.
 */
class TestCountryDao extends CountryBaseDao
{
    /**
     * @return CountryBean[]|ResultInterface
     */
    public function getCountriesByUserCount()
    {
        $sql = <<<SQL
SELECT country.*
FROM country
LEFT JOIN users ON users.country_id = country.id
GROUP BY country.id, country.label
ORDER BY COUNT(users.id) DESC
SQL;

        return $this->findFromRawSql($sql);
    }

    /**
     * @return CountryBean[]|ResultInterface
     */
    public function getCountriesUsingUnion()
    {
        $sql = <<<SQL
SELECT country.*
FROM country
WHERE country.id = 1
UNION
SELECT country.*
FROM country
WHERE country.id = 2
SQL;

        return $this->findFromRawSql($sql);
    }

    /**
     * @return CountryBean[]|ResultInterface
     */
    public function getCountriesUsingSimpleQuery()
    {
        $sql = <<<SQL
SELECT country.*
FROM country
WHERE country.id = 1
SQL;

        return $this->findFromRawSql($sql);
    }

    /**
     * @return CountryBean[]|ResultInterface
     */
    public function getCountriesUsingDistinctQuery()
    {
        // Note: there are many users whose country is ID 2 (UK).
        // But the distinct should return only one country (including the count() call)
        $sql = <<<SQL
SELECT DISTINCT country.*
FROM country
LEFT JOIN users ON users.country_id = country.id 
WHERE country_id=2
SQL;

        return $this->findFromRawSql($sql);
    }
}