// ----------------------------------------------------------------------------------------------------------------- // 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]; }, \dbeurive\BackendTest\Utils\Pdo::select("SELECT id FROM user ORDER BY id", array(), \PDO::FETCH_NUM)); // ----------------------------------------------------------------------------------------------------------------- // Creating users' profiles. // ----------------------------------------------------------------------------------------------------------------- for ($i = 0; $i < $USER_COUNT; $i++) { $v = array('first_name' => "firstName{$i}", 'last_name' => "name{$i}", 'fk_user_id' => $ids['users'][$i]); $sql = "INSERT INTO profile (first_name, last_name, fk_user_id) " . "VALUES " . "(:first_name, :last_name, :fk_user_id)"; \dbeurive\BackendTest\Utils\Pdo::insert($sql, $v); } $ids['profiles'] = array_map(function ($v) { return $v[0]; }, \dbeurive\BackendTest\Utils\Pdo::select("SELECT id FROM profile", array(), \PDO::FETCH_NUM)); return true; }, $pdo);