30分でDoctrineの仕組みと使い方を完全にマスターする / phpconkagawa 2025 Doctrine

PHPカンファレンス香川2025 の発表資料です。

- https://phpcon.kagawa.jp/2025/
- https://fortee.jp/phpconkagawa-2025
- https://fortee.jp/phpconkagawa-2025/proposal/56209220-8800-4584-a27b-08eb3d4cd2ef

Transcript

1. / 147 30 Doctrine 方 2 025 / 11 / 2 4 PHP 香 2025 @ttskch  1 # #phpconkagawa
2. / 147  2 Doctrine 人 🙋🙋
3. / 147  3 Doctrine 人 🙋🙋
4. / 147  4
5. / 147  5
6. / 147  6 Doctrine
7. / 147  7 日 Doctrine 大風
8. / 147  8 #phpconkagawa 𝕏 🤝✨
9. / 147 PHP 14 Symfony 13 phpcon 2025 行 長 Kannade  9 @ttskch
10. / 147 Doctrine Eloquent 比 Doctrine Doctrine 方  10 🔖
11. / 147 Doctrine Eloquent 比 Doctrine Doctrine 方  11 🔖
12. / 147 Symfony 用 PHP ORM Doctrine OSS Doctrine DBAL Doctrine ORM Doctrine ⾒ Doctrine ORM Doctrine  12
13. / 147 Doctrine ORM Doctrine DBAL 用 Doctrine ORM Doctrine DBAL Doctrine  13
14. / 147 Database Abstraction Layer DB DB DB DB DBAL DB DB 一 Doctrine DBAL  14
15. / 147 Object-Relational Mapper OOP 言 RDB DB PHP ORM Eloquent ORM Laravel ORM Doctrine ORM  15
16. / 147 Doctrine Eloquent 比 Doctrine Doctrine 方  16 🔖
17. / 147 ORM 2 Eloquent Active Record Doctrine Data Mapper PoEAA Eloquent 比  17 https://www.martinfowler.com/eaaCatalog/activeRecord.html https://www.martinfowler.com/eaaCatalog/dataMapper.html
18. / 147 自 DB 👍 手 高 👎 DB DB Active Record  18
19. / 147 DB 👍 DB DB 👎 手 Data Mapper  19
20. / 147 DB 👍 DB DB 👎 手 Data Mapper  20
21. / 147 自 FW 用 ⾒ DB  21
22. / 147 Active Record vs Data Mapper  22 Active Record Data Mapper 手 長 高 比 高
23. / 147 Doctrine Eloquent 比 Doctrine Doctrine 方  23 🔖
24. / 147  24 Doctrine PHP DB
25. / 147  25
26. / 147  26
27. / 147 Doctrine DDD 用 一 2 見  27
28. / 147 Doctrine DDD DDD ⾒ DB 一 1 PoEAA Identity Map  28 https://martinfowler.com/eaaCatalog/identityMap.html
29. / 147 // Eloquent dump(spl_object_hash( Article::find(1), )); dump(spl_object_hash( Article::find(1), )); dump(spl_object_hash( Article::find(1), )); // Doctrine dump(spl_object_hash( $articleRepository->find(1), )); dump(spl_object_hash( $articleRepository->find(1), )); dump(spl_object_hash( $articleRepository->find(1), ));  29 // "000000000000085b0000000000000000" // "000000000000085b0000000000000000" // "000000000000085b0000000000000000" // "00000000000012250000000000000000" // "00000000000011f90000000000000000" // "00000000000011f70000000000000000"
30. / 147 Doctrine Data Mapper 方  30
31. / 147 DB  31 PHP a b c a b c
32. / 147  32 #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; }
33. / 147  33 #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; } POPO Plain Old PHP Object DB
34. / 147  34 POPO Plain Old PHP Object DB
35. / 147  35
36. / 147  36
37. / 147  37 Doctrine PHP DB
38. / 147  38 Doctrine PHP DB 用 Doctrine
39. / 147  39
40. / 147  40
41. / 147  41
42. / 147  42 Doctrine PHP DB DB 用
43. / 147  43 Doctrine PHP DB
44. / 147  44 Doctrine PHP DB
45. / 147 Doctrine Eloquent 比 Doctrine Doctrine 方  45 🔖 10
46. / 147  46
47. / 147 Data Mapper 方 3 見 DB Doctrine  47 DB
48. / 147 言 3 大 Doctrine DB Doctrine  48 Doctrine DB
49. / 147 Doctrine 3 Unit of Work 一 3 Doctrine Doctrine 方  49
50. / 147 Doctrine 口 Doctrine  50
51. / 147 Doctrine DB 一 PoEAA Unit of Work Unit of Work  51 https://www.martinfowler.com/eaaCatalog/unitOfWork.html
52. / 147 DB PoEAA Repository  52 https://martinfowler.com/eaaCatalog/repository.html
53. / 147  53 ・
54. / 147 行 口 Doctrine DB  54
55. / 147 DB  55 Unit of Work DB Doctrine
56. / 147 DB  56 Unit of Work DB 口 Doctrine
57. / 147 DB  57 Unit of Work DB Doctrine
58. / 147 DB  58 Unit of Work DB DB Doctrine
59. / 147 DB  59 Unit of Work DB Unit of Work Doctrine
60. / 147 DB  60 Unit of Work DB Doctrine
61. / 147  61
62. / 147  62
63. / 147  63 DB Unit of Work if 文
64. / 147  64 DB Unit of Work if 文
65. / 147 DB  65 Unit of Work DB Doctrine
66. / 147 DB  66 Unit of Work DB Doctrine
67. / 147 Doctrine DB Unit of Work DB Doctrine DB 口 Doctrine DB  67
68. / 147 DB  68 Unit of Work DB Doctrine
69. / 147 DB  69 Unit of Work DB Doctrine 口
70. / 147 DB  70 Unit of Work DB Doctrine Unit of Work
71. / 147 DB  71 Unit of Work DB Doctrine Unit of Work 自身 DB 行
72. / 147 DB  72 Unit of Work DB Doctrine Unit of Work 自身
73. / 147 DB  73 Unit of Work DB Doctrine 一
74. / 147 DB  74 Unit of Work DB Doctrine
75. / 147 DB  75 Unit of Work DB Doctrine
76. / 147 Doctrine Eloquent 比 Doctrine Doctrine 方  76 🔖 17
77. / 147  77 DB DB
78. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; }
79. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; } Article article
80. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; } ORM Doctrine
81. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; } $id ID Doctrine 自 id integer
82. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; } $title title string 大長 255 文
83. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; } $content content text NULL
84. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; }
85. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; } 方
86. / 147 Symfony Doctrine ⾒ bin/console make:entity 行 大 🙆  86
88. ✨
89. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; }
90. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; }
91. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; } string integer text
92. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; } string integer text 身 文
93. / 147 integer string text Doctrine DBAL DB  93 DBAL MySQL PostgreSQL SQLite integer INT UNSIGNED INT INTEGER string VARCHAR VARCHAR VARCHAR text TEXT TEXT VARCHAR(MAX) https://www.doctrine-project.org/projects/doctrine-dbal/en/ 4 . 3 /reference/types.html#mapping-matrix
94. make:entity ? DBAL 一 見 大 🙆
95. / 147  95 DB DB
96. / 147  96 DB DB
97. / 147  97 DB DB DB
98. / 147 DB  98 Unit of Work DB Doctrine
99. / 147  99 DB
100. / 147 // ΤϯςΟςΟϚωʔδϟʔ͔Β // ArticleΤϯςΟςΟ༻ͷϦϙδτϦΛऔಘ $articleRepository = $entityManager->getRepository(Article::class);  100 DB
101. / 147 // ΤϯςΟςΟϚωʔδϟʔ͔Β // ArticleΤϯςΟςΟ༻ͷϦϙδτϦΛऔಘ $articleRepository = $entityManager->getRepository(Article::class); // ϦϙδτϦܦ༝Ͱ // ID͕1ͷArticleΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1);  101 DB
102. / 147 // ΤϯςΟςΟϚωʔδϟʔ͔Β // ArticleΤϯςΟςΟ༻ͷϦϙδτϦΛऔಘ $articleRepository = $entityManager->getRepository(Article::class); // ϦϙδτϦܦ༝Ͱ // ID͕1ͷArticleΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1);  102 DB Doctrine 色 💡
103. / 147 // ΤϯςΟςΟϚωʔδϟʔ͔Β // ArticleΤϯςΟςΟ༻ͷϦϙδτϦΛऔಘ $articleRepository = $entityManager->getRepository(Article::class); // ϦϙδτϦܦ༝Ͱ // ID͕1ͷArticleΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1);  103 $entityManager
104. / 147 // ΤϯςΟςΟϚωʔδϟʔ͔Β // ArticleΤϯςΟςΟ༻ͷϦϙδτϦΛऔಘ $articleRepository = $entityManager->getRepository(Article::class); // ϦϙδτϦܦ༝Ͱ // ID͕1ͷArticleΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1);  104 $entityManager
105. / 147 #[Route('/article', name: 'article_')] class ArticleController extends AbstractController { #[Route('/', name: 'index', methods: ['GET'])] public function index(EntityManagerInterface $entityManager): Response { $articleRepository = $entityManager->getRepository(Article::class); // ... } }  105 DI Symfony
106. / 147 #[Route('/article', name: 'article_')] class ArticleController extends AbstractController { #[Route('/', name: 'index', methods: ['GET'])] public function index(EntityManagerInterface $entityManager): Response { $articleRepository = $entityManager->getRepository(Article::class); // ... } }  106 DI Symfony
107. / 147 #[Route('/article', name: 'article_')] class ArticleController extends AbstractController { #[Route('/', name: 'index', methods: ['GET'])] public function index(EntityManagerInterface $entityManager): Response { $articleRepository = $entityManager->getRepository(Article::class); // ... } }  107 DI Symfony DI 🙏
108. / 147 // ΤϯςΟςΟϚωʔδϟʔ͔Β // ArticleΤϯςΟςΟ༻ͷϦϙδτϦΛऔಘ $articleRepository = $entityManager->getRepository(Article::class); // ϦϙδτϦܦ༝Ͱ // ID͕1ͷArticleΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1);  108
109. / 147 // ΤϯςΟςΟϚωʔδϟʔ͔Β // ArticleΤϯςΟςΟ༻ͷϦϙδτϦΛऔಘ $articleRepository = $entityManager->getRepository(Article::class); // ϦϙδτϦܦ༝Ͱ // ID͕1ͷArticleΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1);  109 $articleRepository-> fi nd(1)
110. / 147  110 fi nd() fi ndAll() fi ndBy() ⾒ fi ndOneBy() ⾒ 一
111. / 147 // ID͕1ͷArticleΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1); // ͢΂ͯͷArticleΤϯςΟςΟͷ഑ྻΛऔಘ $articles = $articleRepository->findAll(); // ެ։ࡁΈͷArticleΤϯςΟςΟͷ഑ྻΛऔಘ $articles = $articleRepository->findBy(['published' => true]); // ެ։ࡁΈ͔ͭɺλΠτϧ͕ʮPHPΧϯϑΝϨϯε߳઒ʯͰ͋ΔArticleΤϯςΟςΟΛ1ͭऔಘ $article = $articleRepository->findOneBy([ 'published' => true, 'title' => 'PHPΧϯϑΝϨϯε߳઒', ]);  111
112. / 147 // ID͕1ͷArticleΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1); // ͢΂ͯͷArticleΤϯςΟςΟͷ഑ྻΛऔಘ $articles = $articleRepository->findAll(); // ެ։ࡁΈͷArticleΤϯςΟςΟͷ഑ྻΛऔಘ $articles = $articleRepository->findBy(['published' => true]); // ެ։ࡁΈ͔ͭɺλΠτϧ͕ʮPHPΧϯϑΝϨϯε߳઒ʯͰ͋ΔArticleΤϯςΟςΟΛ1ͭऔಘ $article = $articleRepository->findOneBy([ 'published' => true, 'title' => 'PHPΧϯϑΝϨϯε߳઒', ]);  112
113. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->...  113
114. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->...  114 🤔
115. / 147 ⾒ SQL 立  115
116. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->...  116
117. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  117
118. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  118 生 立 Article a
119. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  119 WHERE :published
120. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  120 WHERE :query
121. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  121 ORDER BY
122. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  122 :published :query
123. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  123 立
124. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  124 SQL 行
125. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  125
126. / 147 // ެ։ࡁΈ͔ͭɺ // λΠτϧʹʮPHPΧϯϑΝϨϯε߳઒ʯΛؚΉArticleΤϯςΟςΟͷ഑ྻΛɺ // IDͷ߱ॱͰऔಘ $articles = $articleRepository->createQueryBuilder('a') ->where('a.published = :published') ->andWhere('a.title LIKE :query') ->orderBy('a.id', 'DESC') ->setParameter('published', true) ->setParameter('query', '%PHPΧϯϑΝϨϯε߳઒%') ->getQuery() ->getResult();  126
127. / 147  127 DB DB DB
128. / 147 DB  128 Unit of Work DB Doctrine
129. / 147 // લఏͱͯ͠ϦϙδτϦ͔ΒΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1); // ී௨ʹΤϯςΟςΟͷ಺༰Λมߋ͢Ε͹ // Unit of Work͕ͦͷมߋ಺༰Λݕ஌͢Δ $article->title = '৽͍͠λΠτϧ'; // ͦͯ͠...  129 DB
130. / 147 // લఏͱͯ͠ϦϙδτϦ͔ΒΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1); // ී௨ʹΤϯςΟςΟͷ಺༰Λมߋ͢Ε͹ // Unit of Work͕ͦͷมߋ಺༰Λݕ஌͢Δ $article->title = '৽͍͠λΠτϧ'; // ͦͯ͠... // มߋ಺༰ͷDB΁ͷ൓өΛґཔ $entityManager->flush();  130 DB
131. / 147 // લఏͱͯ͠ϦϙδτϦ͔ΒΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1); // ී௨ʹΤϯςΟςΟͷ಺༰Λมߋ͢Ε͹ // Unit of Work͕ͦͷมߋ಺༰Λݕ஌͢Δ $article->title = '৽͍͠λΠτϧ'; // ͦͯ͠... // มߋ಺༰ͷDB΁ͷ൓өΛґཔ $entityManager->flush();  131 DB DB Unit of Work 💡
132. / 147 // ΤϯςΟςΟΛ৽ن࡞੒ $article = new Article(); $article->title = 'λΠτϧ'; // ΤϯςΟςΟΛUnit of Workʹ௥Ճ $entityManager->persist($article); // มߋ಺༰ͷDB΁ͷ൓өΛґཔ $entityManager->flush();  132
133. / 147 // ΤϯςΟςΟΛ৽ن࡞੒ $article = new Article(); $article->title = 'λΠτϧ'; // ΤϯςΟςΟΛUnit of Workʹ௥Ճ $entityManager->persist($article); // มߋ಺༰ͷDB΁ͷ൓өΛґཔ $entityManager->flush();  133 Unit of Work 行 🤦
134. / 147 // ΤϯςΟςΟΛ৽ن࡞੒ʢ͜ͷ࣌఺Ͱ͸·ͩUnit of Workͷ؅ཧԼʹͳ͍ʣ $article = new Article(); $article->title = 'λΠτϧ'; // ΤϯςΟςΟΛUnit of Workʹొ࿥ $entityManager->persist($article); // มߋ಺༰ʢ৽ن௥ՃΛؚΉʣͷDB΁ͷ൓өΛґཔ $entityManager->flush();  134 fl ush()
135. / 147 // લఏͱͯ͠ϦϙδτϦ͔ΒΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1); // ͦͯ͠...  135
136. / 147 // લఏͱͯ͠ϦϙδτϦ͔ΒΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1); // ͦͯ͠... // ΤϯςΟςΟΛ࡟আ͢ΔҙࢥΛUnit of Workʹ఻͑Δ $entityManager->remove($article); // มߋ಺༰ʢ࡟আΛؚΉʣͷDB΁ͷ൓өΛґཔ $entityManager->flush();  136
137. / 147 // લఏͱͯ͠ϦϙδτϦ͔ΒΤϯςΟςΟΛऔಘ $article = $articleRepository->find(1); // ͦͯ͠... // ΤϯςΟςΟΛ࡟আ͢ΔҙࢥΛUnit of Workʹ఻͑Δ $entityManager->remove($article); // มߋ಺༰ʢ࡟আΛؚΉʣͷDB΁ͷ൓өΛґཔ $entityManager->flush();  137 Unit of Work
138. / 147 // ΤϯςΟςΟΛ৽ن࡞੒ʢ͜ͷ࣌఺Ͱ͸·ͩUnit of Workͷ؅ཧԼʹͳ͍ʣ $article = new Article(); $article->title = 'λΠτϧ'; // ΤϯςΟςΟΛ࡟আ͢ΔҙࢥΛUnit of Workʹ఻͑Δ $entityManager->remove($article); // มߋ಺༰ʢ࡟আΛؚΉʣͷDB΁ͷ൓өΛґཔ $entityManager->flush();  138
139. / 147 // ΤϯςΟςΟΛ৽ن࡞੒ʢ͜ͷ࣌఺Ͱ͸·ͩUnit of Workͷ؅ཧԼʹͳ͍ʣ $article = new Article(); $article->title = 'λΠτϧ'; // ΤϯςΟςΟΛ࡟আ͢ΔҙࢥΛUnit of Workʹ఻͑Δ $entityManager->remove($article); // มߋ಺༰ʢ࡟আΛؚΉʣͷDB΁ͷ൓өΛґཔ $entityManager->flush();  139 Unit of Work 示 行 ✋
140. / 147  140 DB ・ ・ DB DB
141. / 147  141 DB ・ ・ DB DB
142. / 147 Doctrine Eloquent 比 Doctrine Doctrine 方  142 🔖
143. / 147 Doctrine Data Mapper 方 手 ・ 心 Doctrine Doctrine ・ Unit of Work ・ 3 方・ 方 方 ・ ・ 方 30  143
144. / 147  144
145. / 147  145
146. / 147  146
147. / 147  147 ・ 🫰 @ttskch Thanks! ／
148. / 147  148 用
149. / 147  149 $ bin/console make:entity Article
151. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; }
152. / 147  152
153. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; }
154. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] #[ORM\Table(name: 'article')] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(name: 'id', type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(name: 'title', type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(name: 'content', type: Types::TEXT, nullable: true)] public ?string $content = null; }
155. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(type: Types::TEXT, nullable: true)] public ?string $content = null; }
156. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(type: Types::TEXT, nullable: true)] public ?string $content = null; } PHP PHP
157. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column(type: Types::INTEGER)] public ?int $id = null; #[ORM\Column(type: Types::STRING, length: 255)] public ?string $title = null; #[ORM\Column(type: Types::TEXT, nullable: true)] public ?string $content = null; } PHP string DBAL text string 示
158. /xxx ຊจϨϕϧ1 ຊจϨϕϧ2 ຊจϨϕϧ3 ຊจϨϕϧ4 ຊจϨϕϧ5 use Doctrine\DBAL\Types\Types; use Doctrine\ORM\Mapping as ORM; #[ORM\Entity] class Article { #[ORM\Id] #[ORM\GeneratedValue] #[ORM\Column] public ?int $id = null; #[ORM\Column(length: 255)] public ?string $title = null; #[ORM\Column(type: Types::TEXT, nullable: true)] public ?string $content = null; }
161. 1 方 make:entity
162. Symfony src 自 ArticleRepository DI 入
163. / 147  163
164. / 147 #[Route('/article', name: 'article_')] class ArticleController extends AbstractController { #[Route('/', name: 'index', methods: ['GET'])] public function index(ArticleRepository $articleRepository): Response { // ... } }  164
165. / 147  165 2
166. / 147  166
167. / 147  167
168. https://qiita.com/advent-calendar/ 2022 /php-doctrine-orm-vs-eloquent
169. / 147  169