public function testMysqlConnect()
{
$connector = new \dbeurive\Backend\Cli\Adapter\Database\Connector\MySqlPdo($this->__mySqlConnectorConfiguration);
$connector->connect();
/** @var \PDO $pdo */
$pdo = $connector->getDatabaseHandler();
// The connexion is not established.
Utils\Pdo::setPdo($pdo);
$result = Utils\Pdo::select("SELECT COUNT(id) FROM user;");
$this->assertCount(1, $result);
}
<?php
return call_user_func(function (\PDO $inPdo) {
// -----------------------------------------------------------------------------------------------------------------
// Configuration.
// -----------------------------------------------------------------------------------------------------------------
$USER_COUNT = 10;
// -----------------------------------------------------------------------------------------------------------------
// Initialization.
// -----------------------------------------------------------------------------------------------------------------
$ids = ['users' => [], 'profiles' => []];
$inPdo->setAttribute(\PDO::ATTR_EMULATE_PREPARES, false);
$inPdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
\dbeurive\BackendTest\Utils\Pdo::setPdo($inPdo);
// -----------------------------------------------------------------------------------------------------------------
// Clean the database.
// ----------------------------------------------------------------------------------------------------------------
\dbeurive\BackendTest\Utils\Pdo::delete("DELETE FROM profile");
\dbeurive\BackendTest\Utils\Pdo::delete("DELETE FROM user");
// -----------------------------------------------------------------------------------------------------------------
// Creating users.
// Please note that we create a special user with no profile.
// This special user is the one the the last ID (the greatest ID's value).
// -----------------------------------------------------------------------------------------------------------------
for ($i = 1; $i <= $USER_COUNT + 1; $i++) {
$v = array('login' => "login{$i}", 'password' => "password{$i}", 'description' => "description{$i}");
$sql = "INSERT INTO user (login, password, description) " . "VALUES " . "(:login, :password, :description)";
\dbeurive\BackendTest\Utils\Pdo::insert($sql, $v);
}
$ids['users'] = array_map(function ($v) {
return $v[0];
