for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace TheCodingMachine\TDBM\Dao;
use Porpaginas\Result;
use TheCodingMachine\TDBM\Test\Dao\Bean\CountryBean;
use TheCodingMachine\TDBM\Test\Dao\Generated\CountryBaseDao;
/**
* The CountryDao class will maintain the persistence of CountryBean class into the country table.
*/
class TestCountryDao extends CountryBaseDao
{
* @return CountryBean[]|Result
public function getCountriesByUserCount()
$sql = <<<SQL
SELECT country.*
FROM country
LEFT JOIN users ON users.country_id = country.id
GROUP BY country.id
ORDER BY COUNT(users.id) DESC
SQL;
return $this->findFromRawSql($sql);
}
public function getCountriesUsingUnion()
WHERE country.id = 1
UNION
WHERE country.id = 2
thecodingmachine /
tdbm
