/**
* Updates a user entry in the database
*
* @param User $user
* @return \Doctrine\DBAL\Driver\Statement|int
*/
protected function updateUser(User $user)
{
return $this->query()->update('User')->where('username = ?')->setParameter(0, strtolower($user->getUsername()))->set('password', '?')->setParameter(1, $user->getPassword())->set('roles', '?')->setParameter(2, join(',', $user->getRoles()))->set('enabled', '?')->setParameter(3, $user->isEnabled())->set('expired', '?')->setParameter(4, !$user->isAccountNonExpired())->set('credentialsExpired', '?')->setParameter(5, !$user->isCredentialsNonExpired())->set('locked', '?')->setParameter(6, !$user->isAccountNonLocked())->execute();
}
/**
* {@inheritdoc}
*/
public function loadUserByUsername($username)
{
if (isset($this->users[$username])) {
$user = $this->users[$username];
} else {
$user = new User($username, '', array('ROLE_CONNECT_USER'), true, true, true, true);
}
return new User($user->getUsername(), $user->getPassword(), $user->getRoles(), $user->isEnabled(), $user->isAccountNonExpired(), $user->isCredentialsNonExpired(), $user->isAccountNonLocked());
}
public function getProjectsForUser(User $user)
{
$sql = 'SELECT project_id as id, project_name as name FROM projects WHERE EXISTS (SELECT * FROM project_user JOIN users ON users.username = :un WHERE project_user.project_id = projects.project_id)';
try {
$query = $this->db->prepare($sql);
$query->execute(['un' => $user->getUsername()]);
$projects = $query->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
// TODO: Fail safe
throw $e;
}
return $projects;
}
/**
* @dataProvider advancedUserProvider
*/
public function testAdvancedUser($username, $password, $roles, $enabled, $userNonExpired, $credentialsNonExpired, $userNonLocked)
{
$originalUser = new User($username, $password, $roles, $enabled, $userNonExpired, $credentialsNonExpired, $userNonLocked);
$user = new UserWrapped($originalUser, $this->apiUser);
$this->assertSame($username, (string) $user);
$this->assertSame($username, $user->getUsername());
$this->assertSame($password, $user->getPassword());
$this->assertSame($roles, $user->getRoles());
$this->assertSame($enabled, $user->isEnabled());
$this->assertSame($userNonExpired, $user->isAccountNonExpired());
$this->assertSame($credentialsNonExpired, $user->isCredentialsNonExpired());
$this->assertSame($userNonLocked, $user->isAccountNonLocked());
$this->assertSame($originalUser->getSalt(), $user->getSalt());
$this->assertSame($originalUser->getUsername(), $user->getWrappedUser()->getUsername());
$this->assertSame($originalUser->isEnabled(), $user->getWrappedUser()->isEnabled());
$this->assertSame($originalUser, $user->getWrappedUser());
}
/**
* @covers Symfony\Component\Security\Core\User\User::__construct
* @covers Symfony\Component\Security\Core\User\User::getUsername
*/
public function testGetUsername()
{
$user = new User('fabien', 'superpass');
$this->assertEquals('fabien', $user->getUsername());
}
