Symfony2で利用されているDoctrineについて

今回からは、Symfonyで利用されているORMである Doctrine について紹介したいと思います。

Doctrineとは、Symfonyで利用されているORMです。つまり、DBから取得した情報を、特定のクラスと関連付けてオブジェクト化する仕組みです。この仕組みにより、直接オブジェクトとして保存や取得することができます。

以下がDoctrineを使ったCreate（生成）、Read（読み取り）、Update（更新）、Delete（削除）の簡単な例です。


&lt;span class="token comment"&gt;/**
&lt;/span&gt;&lt;/code&gt;&lt;code class=" language-php"&gt;&lt;span class="token comment"&gt; *&lt;/span&gt;&lt;/code&gt;&lt;code class=" language-php"&gt;&lt;span class="token comment"&gt; @ORM\Entity&lt;/span&gt;&lt;/code&gt;&lt;code class=" language-php"&gt;
&lt;/code&gt;&lt;code class=" language-php"&gt;&lt;span class="token comment"&gt; * @ORM\Table(name="user")
 */&lt;/span&gt;
&lt;span class="token keyword"&gt;class&lt;/span&gt; &lt;span class="token class-name"&gt;User&lt;/span&gt;
&lt;span class="token punctuation"&gt;{&lt;/span&gt;
   &lt;span class="token comment"&gt;/**
    * @ORM\Id
    * @ORM\Column(type="integer")
    * @ORM\GeneratedValue(strategy="AUTO")
    */&lt;/span&gt;
    &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$id&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

   &lt;span class="token comment"&gt;/**
    * @var string
    */&lt;/span&gt;
    &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$name&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

   &lt;span class="token comment"&gt;/**
    * @var string
    */&lt;/span&gt;    
    &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$email&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

   &lt;span class="token comment"&gt;/**
    * @var string
    */&lt;/span&gt;
    &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$password&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @ORM\Column(type="datetime")
     */&lt;/span&gt;
     &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$createdAt&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @ORM\ManyToOne(targetEntity="Group", inversedBy="users")
     * @ORM\JoinColumn(name="group_id", referencedColumnName="id")
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$group&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @return mixed
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;getId&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token keyword"&gt;return&lt;/span&gt; &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;id&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @param mixed $id
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;setId&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token variable"&gt;$id&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;id&lt;/span&gt; &lt;span class="token operator"&gt;=&lt;/span&gt; &lt;span class="token variable"&gt;$id&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @return mixed
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;getName&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token keyword"&gt;return&lt;/span&gt; &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;name&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @param mixed $name
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;setName&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token variable"&gt;$name&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;name&lt;/span&gt; &lt;span class="token operator"&gt;=&lt;/span&gt; &lt;span class="token variable"&gt;$name&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @return mixed
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;getEmail&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token keyword"&gt;return&lt;/span&gt; &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;email&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @param mixed $email
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;setEmail&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token variable"&gt;$email&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;email&lt;/span&gt; &lt;span class="token operator"&gt;=&lt;/span&gt; &lt;span class="token variable"&gt;$email&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @return mixed
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;getPassword&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token keyword"&gt;return&lt;/span&gt; &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;password&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @param mixed $password
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;setPassword&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token variable"&gt;$password&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;password&lt;/span&gt; &lt;span class="token operator"&gt;=&lt;/span&gt; &lt;span class="token variable"&gt;$password&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @return mixed
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;getCreatedAt&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token keyword"&gt;return&lt;/span&gt; &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;createdAt&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

    &lt;span class="token comment"&gt;/**
     * @param mixed $createdAt
     */&lt;/span&gt;
    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;setCreatedAt&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token variable"&gt;$createdAt&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;createdAt&lt;/span&gt; &lt;span class="token operator"&gt;=&lt;/span&gt; &lt;span class="token variable"&gt;$createdAt&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

&lt;span class="token punctuation"&gt;}
&lt;/span&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

/**

</code><code class=" language-php"> *</code><code class=" language-php"> @ORM\Entity</code><code class=" language-php">

</code><code class=" language-php"> * @ORM\Table(name="user")

*/

class User

{

/**

* @ORM\Id

* @ORM\Column(type="integer")

* @ORM\GeneratedValue(strategy="AUTO")

*/

private $id;

/**

* @var string

*/

private $name;

/**

* @var string

*/

private $email;

/**

* @var string

*/

private $password;

/**

* @ORM\Column(type="datetime")

*/

private $createdAt;

/**

* @ORM\ManyToOne(targetEntity="Group", inversedBy="users")

* @ORM\JoinColumn(name="group_id", referencedColumnName="id")

*/

private $group;

/**

* @return mixed

*/

public function getId()

{

return $this->id;

}

/**

* @param mixed $id

*/

public function setId($id)

{

$this->id = $id;

}

/**

* @return mixed

*/

public function getName()

{

}

/**

* @param mixed $name

*/

public function setName($name)

{

$this->name = $name;

}

/**

* @return mixed

*/

public function getEmail()

{

}

/**

* @param mixed $email

*/

public function setEmail($email)

{

$this->email = $email;

}

/**

* @return mixed

*/

public function getPassword()

{

}

/**

* @param mixed $password

*/

public function setPassword($password)

{

$this->password = $password;

}

/**

* @return mixed

*/

public function getCreatedAt()

{

}

/**

* @param mixed $createdAt

*/

public function setCreatedAt($createdAt)

{

$this->createdAt = $createdAt;

}

}


&lt;span class="token comment"&gt;// src/AppBundle/Entity/Group.php&lt;/span&gt;
&lt;span class="token comment"&gt;/**
 * @ORM\Entity
 * @ORM\Table(name="group")
 */&lt;/span&gt;
&lt;span class="token keyword"&gt;class&lt;/span&gt; &lt;span class="token class-name"&gt;Group&lt;/span&gt;
&lt;span class="token punctuation"&gt;{&lt;/span&gt;
   &lt;span class="token comment"&gt;/**
    * @ORM\Id
    * @ORM\Column(type="integer")
    * @ORM\GeneratedValue(strategy="AUTO")
    */&lt;/span&gt;
    &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$id&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

   &lt;span class="token comment"&gt;/**
    * @var string
    */&lt;/span&gt;
    &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$name&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

   &lt;span class="token comment"&gt;/**
    * @ORM\Column(nullable=true) 
    * @ORM\Column(type="text")
    */&lt;/span&gt;    
    &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$description&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

   &lt;span class="token comment"&gt;/**
    * @ORM\OneToMany(targetEntity="User", mappedBy="group")
    */&lt;/span&gt;
    &lt;span class="token keyword"&gt;private&lt;/span&gt; &lt;span class="token variable"&gt;$users&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

    &lt;span class="token keyword"&gt;public&lt;/span&gt; &lt;span class="token keyword"&gt;function&lt;/span&gt; &lt;span class="token function"&gt;__construct&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
    &lt;span class="token punctuation"&gt;{&lt;/span&gt;
        &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token property"&gt;users&lt;/span&gt; &lt;span class="token operator"&gt;=&lt;/span&gt; &lt;span class="token keyword"&gt;new&lt;/span&gt; &lt;span class="token class-name"&gt;ArrayCollection&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
    &lt;span class="token punctuation"&gt;}&lt;/span&gt;

&lt;span class="token punctuation"&gt;}&lt;/span&gt;

// src/AppBundle/Entity/Group.php

/**

* @ORM\Entity

* @ORM\Table(name="group")

*/

class Group

{

/**

* @ORM\Id

* @ORM\Column(type="integer")

* @ORM\GeneratedValue(strategy="AUTO")

*/

private $id;

/**

* @var string

*/

private $name;

/**

* @ORM\Column(nullable=true)

* @ORM\Column(type="text")

*/

private $description;

/**

* @ORM\OneToMany(targetEntity="User", mappedBy="group")

*/

private $users;

public function __construct()

{

$this->users = new ArrayCollection();

}

Create（生成）


&lt;span class="token variable"&gt;$group&lt;/span&gt; &lt;span class="token operator"&gt;=&lt;/span&gt; &lt;span class="token keyword"&gt;new&lt;/span&gt; &lt;span class="token class-name"&gt;Group&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
&lt;span class="token variable"&gt;$group&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;setName&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token single-quoted-string string"&gt;'Administrator'&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
&lt;span class="token variable"&gt;$group&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;setDescription&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token single-quoted-string string"&gt;'Users with highest privileges in the system'&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt; 

&lt;span class="token variable"&gt;$em&lt;/span&gt; &lt;span class="token operator"&gt;=&lt;/span&gt; &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getDoctrine&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getManager&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

&lt;span class="token comment"&gt;// Tells Doctrine you want to save the group (no queries yet)&lt;/span&gt;
&lt;span class="token variable"&gt;$em&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;persist&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token variable"&gt;$group&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

&lt;span class="token comment"&gt;// This line actually executes the SQL query&lt;/span&gt;
&lt;span class="token variable"&gt;$em&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;flush&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

$group = new Group();

$group->setName('Administrator');

$group->setDescription('Users with highest privileges in the system');

$em = $this->getDoctrine()->getManager();

// Tells Doctrine you want to save the group (no queries yet)

$em->persist($group);

// This line actually executes the SQL query

$em->flush();

Idを調べる


&lt;span class="token variable"&gt;$group&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getId&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

1	<span class="token variable">$group</span><span class="token operator">-</span><span class="token operator">></span><span class="token function">getId</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

データーベースからデーターを調べる


&lt;span class="token variable"&gt;$group&lt;/span&gt; &lt;span class="token operator"&gt;=&lt;/span&gt; &lt;span class="token variable"&gt;$this&lt;/span&gt;&lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getDoctrine&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;
        &lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getRepository&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;'AppBundle&lt;span class="token punctuation"&gt;:&lt;/span&gt;Group&lt;span class="token punctuation"&gt;)&lt;/span&gt;
        &lt;span class="token operator"&gt;-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;find&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token variable"&gt;$groupId&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

$group = $this->getDoctrine()

->getRepository('AppBundle:Group)

->find($groupId);

データーベースのデーターをUpdate（更新）


&lt;span class="token comment"&gt;// Fetch the group&lt;/span&gt;
$em &lt;span class="token operator"&gt;=&lt;/span&gt; $this&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getDoctrine&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getManager&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
$group &lt;span class="token operator"&gt;=&lt;/span&gt; $em&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getRepository&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token lifetime-annotation symbol"&gt;'AppBundle:Group)-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;find&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;$groupId&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

&lt;span class="token comment"&gt;// If the group does not exist, throw an exception&lt;/span&gt;
&lt;span class="token keyword"&gt;if&lt;/span&gt; &lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token operator"&gt;!&lt;/span&gt;$group&lt;span class="token punctuation"&gt;)&lt;/span&gt; &lt;span class="token punctuation"&gt;{&lt;/span&gt;
   throw $this&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;createNotFoundException&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;
      &lt;span class="token lifetime-annotation symbol"&gt;'Group&lt;/span&gt; not found'
   &lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
&lt;span class="token punctuation"&gt;}&lt;/span&gt;

&lt;span class="token comment"&gt;// Update data&lt;/span&gt;
$group&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;setDescription&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token lifetime-annotation symbol"&gt;'New&lt;/span&gt; group description&lt;span class="token punctuation"&gt;.&lt;/span&gt;&lt;span class="token lifetime-annotation symbol"&gt;');&lt;/span&gt;
$em&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;flush&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

// Fetch the group

$em = $this->getDoctrine()->getManager();

$group = $em->getRepository('AppBundle:Group)->find($groupId);

// If the group does not exist, throw an exception

if (!$group) {

throw $this->createNotFoundException(

'Group not found'

);

}

// Update data

$group>setDescription('New group description.');

$em->flush();

データーベースからデーターをDelete（削除）


&lt;span class="token comment"&gt;// Fetch group&lt;/span&gt;
$em &lt;span class="token operator"&gt;=&lt;/span&gt; $this&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getDoctrine&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getManager&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
$group &lt;span class="token operator"&gt;=&lt;/span&gt; $em&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;getRepository&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token lifetime-annotation symbol"&gt;'AppBundle:Group)-&lt;/span&gt;&lt;span class="token operator"&gt;&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;find&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;$groupId&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

&lt;span class="token comment"&gt;// Remove group&lt;/span&gt;
$em&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;remove&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;$group&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;
$em&lt;span class="token punctuation"&gt;-&amp;gt;&lt;/span&gt;&lt;span class="token function"&gt;flush&lt;/span&gt;&lt;span class="token punctuation"&gt;(&lt;/span&gt;&lt;span class="token punctuation"&gt;)&lt;/span&gt;&lt;span class="token punctuation"&gt;;&lt;/span&gt;

// Fetch group

// Remove group

$em->remove($group);

Doctrineで情報取得するまでの流れは、以下のようになっています。

アプリからDoctrineを呼び出し、情報取得の依頼をする。
データーベースの情報が記述されているマッピング定義を読み込む。
Doctrineがデーターベースにアクセスし、リクエストに対応する情報を取得する。
マッピング定義から、リクエストに対応するエンティティクラスを特定し、読み込む。
データーベースから取得した情報をプロパティに設定し、インスタンス化する。
インスタンス化したエンティティを呼び出し元に返す。

PHP Symfony

WRITER

スターフィールド編集部

この著者の記事を見る

PREV最短1か月で中国越境EC始動！バイドゥの百分百(baifenbai)×助成金で、最大限に負担を減らした越境ECソリューションをご紹介！セミナーレポート NEXT最近APIで使われるGraphQLについて調べてみました

Symfony2で利用されているDoctrineについて

Related