Doctrine aktualizacja pola

Question

Cześć.

Próbuje zaktualizować wybrane pole w MySql tą metodą:

 $en = $this->getDoctrine()->getManager();
               $users = $en->getRepository(User::class);//->findBy(['username' => $lastUsername]);

                $query = $users->createQueryBuilder('u')
                     ->update('User')
                     ->where('u.username :lastUser')
                     ->setParameter('lastUser', $lastUsername)
                     ->set('u.loginAttempt','4')
                     ->getQuery();

                  $update = $query->getResult();

Lecz dostaje taki błąd :

[Semantical Error] line 0, col 7 near 'User SET u.loginAttempt': Error: Class 'User' is not defined.

Czy ktoś ma jakiś pomysł ?

Answer 1

Doctrine nie rozumie co to User. Musisz mi podać FQCN albo User::class.

Comments

User::class 

class User
{
    /** @var Id */
    private $id;

    /** @var string */
    private $username;

    /** @var string */
    private $email;

    /** @var string */
    private $password;

    /** @var null|string */
    private $firstName;

    /** @var string */
    private $lastName;

    /** @var \DateTime */
    private $createdAt;

    /** @var \DateTime */
    private $deletedAt;

    /** @var \DateTime */
    private $passwordRequestedAt;

    /** @var null|string */
    private $phoneNumber;

/** @var string */
    private $loginAttempt;
/**
     * @param Id $id
     * @param string $username
     * @param string $email
     * @param string $password
     * @param string $lastName
     * @param Role $role
     * @param null|string $firstName
     * @param null|string $phoneNumber
     */
    public function __construct(
        Id $id,
        string $username,
        string $email,
        string $password,
        string $lastName,
        ?string $firstName = null,
        ?string $phoneNumber = null,
    ) {
        $this->id = $id;
        $this->username = $username;
        $this->email = $email;
        $this->password = $password;
        $this->lastName = $lastName;
        $this->setRole($role);
        $this->firstName = $firstName;
        $this->phoneNumber = $phoneNumber;
        $this->loginAttempt = $loginAttempt;
    }

    /**
     * @return Id
     */
    public function getId(): Id
    {
        if (is_string($this->id)) {
            return Id::fromString($this->id);
        }

        return $this->id;
    }
 /**
     * @return string
     */
    public function getUsername(): string
    {
        return $this->username;
    }

    /**
     * @param string $username
     */
    public function setUsername(string $username): void
    {
        $this->username = $username;
    }

    /**
     * @return string
     */
    public function getEmail(): string
    {
        return $this->email;
    }

    /**
     * @param string $email
     */
    public function setEmail(string $email): void
    {
        $this->email = $email;
    }

    /**
     * @return string
     */
    public function getPassword(): string
    {
        return $this->password;
    }

    /**
     * @param string $password
     */
    public function setPassword(string $password): void
    {
        $this->password = $password;
    }

    /**
     * @return null|string
     */
    public function getFirstName(): ?string
    {
        return $this->firstName;
    }

    /**
     * @param null|string $firstName
     */
    public function setFirstName(?string $firstName): void
    {
        $this->firstName = $firstName;
    }

    /**
     * @return string
     */
    public function getLastName(): string
    {
        return $this->lastName;
    }

    /**
     * @param string $lastName
     */
    public function setLastName(string $lastName): void
    {
        $this->lastName = $lastName;
    }

    /**
     * @return \DateTime
     */
    public function getCreatedAt(): \DateTime
    {
        return $this->createdAt;
    }

    /**
     * @return \DateTime
     */
    public function getDeletedAt(): ?\DateTime
    {
        return $this->deletedAt;
    }

    /**
     * @param \DateTime $deletedAt
     */
    public function setDeletedAt(?\DateTime $deletedAt): void
    {
        $this->deletedAt = $deletedAt;
    }

    /**
     * @return \DateTime
     */
    public function getPasswordRequestedAt(): \DateTime
    {
        return $this->passwordRequestedAt;
    }

    /**
     * @param \DateTime $passwordRequestedAt
     */
    public function setPasswordRequestedAt(\DateTime $passwordRequestedAt): void
    {
        $this->passwordRequestedAt = $passwordRequestedAt;
    }

    /**
     * @return null|string
     */
    public function getPhoneNumber(): ?string
    {
        return $this->phoneNumber;
    }

    /**
     * @param null|string $phoneNumber
     */
    public function setPhoneNumber(?string $phoneNumber): void
    {
        $this->phoneNumber = $phoneNumber;
    }
 /**
     * @return string
     */
    public function getLoginAttempt(): string
    {
        return $this->loginAttempt;
    }

    /**
     * @param string $loginAttempt
     */
    public function setLoginAttempt(string $loginAttempt): void
    {
        $this->loginAttempt = $loginAttempt;
    }

Cała klasa Users

---

W argumencie update daj User::class

---

Działa pomogło.

Dziękuje za pomoc.