/** * 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()); }