Doctrine PHP, tips & tricks

Transcript

1. DOCTRINE ORM Tips & Tricks @inalgnu
2. ORM Un mapping objet-relationnel (ORM) est une technique de programmation informatique qui crée l'illusion d'une base de données orientée objet à partir d'une base de données relationnelle en définissant des correspondances entre cette base de données et les objets du langage utilisé.
3. UN ORM C’EST - Bien(+): - CRUD applications. - Son blog personnel. - Moins bien (-) : - Pour les applications complexes avec beaucoup des relations. - Pour faire des traitements en batch. - Pour faire des applications performantes en PHP .
4. Tips
5. RÉFÉRENCE <?php $locale = $em->getRepository(‘Locale’)—>findById(1); $customer = new Customer(); $customer->setLocale($locale); $em->persist($customer); $em->flush();
6. RÉFÉRENCE <?php $locale = $em->getRepository(‘Locale’)—>findById(1); $customer = new Customer(); $customer->setLocale($locale); $em->persist($customer); $em->flush(); CAUTION SLIPPERY WHEN WET
7. RÉFÉRENCE <?php $locale = $em->getRepository(‘Locale’)—>findById(1); $customer = new Customer(); $customer->setLocale($locale); $em->persist($customer); $em->flush(); CAUTION SLIPPERY WHEN WET <?php $locale = $em->getReference(Locale::class, 1); $customer = new Customer(); $customer->setLocale($locale); $em->persist($customer); $em->flush();
8. VOTRE OPS SERA CONTENT
9. VOTRE OPS SERA CONTENT
10. TRAITEMENT PAR BATCH
11. TRAITEMENT PAR BATCH <?php $entities = $em->yourBigQuery()->getResult(); foreach ($entities as $entity) {
 doSomething($entity); }
12. TRAITEMENT PAR BATCH <?php $entities = $em->yourBigQuery()->getResult(); foreach ($entities as $entity) {
 doSomething($entity); } ->iterate();
13. IN
14. IN <?php //Collection $roles = $em->findRoles(); $ids = []; foreach ($roles as $role) {
 $ids[] = $role->getId(); } $queryBuilder->where(‘customer.role IN (:ids)’) ->setParameters(‘:ids’, $ids);
15. IN <?php //Collection $roles = $em->findRoles(); $ids = []; foreach ($roles as $role) {
 $ids[] = $role->getId(); } $queryBuilder->where(‘customer.role IN (:ids)’) ->setParameters(‘:ids’, $ids); <?php //Collection $roles = $em->findRoles(); $queryBuilder ->where(‘customer.role IN (:roles)’) ->setParameters(‘:roles’, $roles);
16. PERSIST & FLUSH
17. PERSIST & FLUSH <?php function save() { $em->persist(); $em->flush(); } foreach ($users as $user) { $this->save($user); }
18. PERSIST & FLUSH <?php function save() { $em->persist(); $em->flush(); } foreach ($users as $user) { $this->save($user); } <?php foreach ($users as $user) { $em->persist($user); } $em->flush();
19. PERSIST & FLUSH
20. <?php $product = $em->getRepository()->getProduct(1); $product->setPrice(500); //… $em->persist($product); $em->flush(); PERSIST & FLUSH
21. <?php $product = $em->getRepository()->getProduct(1); $product->setPrice(500); //… $em->persist($product); $em->flush(); PERSIST & FLUSH <?php $product = $em->getRepository()->getProduct(1); $product->setPrice(500); //… $em->flush();
22. CACHE
23. CACHE #config_prod.yml doctrine: orm: metadata_cache_driver: apc query_cache_driver: apc result_cache_driver: apc
24. CACHE #config_prod.yml doctrine: orm: metadata_cache_driver: apc query_cache_driver: apc result_cache_driver: apc <?php $query = $qb->select(‘’)->where(‘’)->getQuery(); $query->useResultCache(true); $query->setResultCacheLifetime(600); return $query->getResult();
25. DUMP
26. DUMP <?php $product = $em->getRepository()->getProduct(1); var_dump($product);
27. DUMP <?php $product = $em->getRepository()->getProduct(1); var_dump($product); \Doctrine\Common\Util\Debug::dump($object);
30. HÉRITAGE
31. HÉRITAGE <?php class RestaurantVip extends Restaurant { //… } $qb->select('r') ->from('Model\Restaurant', 'r') ->where('r INSTANCE OF Model\RestaurantVip’)
32. RELATION ABSTRAITE
33. RELATION ABSTRAITE <?php namespace SharedModule\Model; class Reservation { /** * May be Customer, Company or Whatever */ private $owner; }
34. RELATION ABSTRAITE <?php namespace SharedModule\Model; class Reservation { /** * May be Customer, Company or Whatever */ private $owner; } <?php namespace SharedModule\Model; class Reservation { /** * @ManyToOne(targetEntity=“ReservationOwnerIterface”) */ private $owner; }
35. RELATION ABSTRAITE <?php namespace SharedModule\Model; class Reservation { /** * May be Customer, Company or Whatever */ private $owner; } <?php namespace SharedModule\Model; class Reservation { /** * @ManyToOne(targetEntity=“ReservationOwnerIterface”) */ private $owner; } <?php namespace MyApp\Model; class Customer implements ReservationOwnerIterface { }
36. RELATION ABSTRAITE <?php namespace SharedModule\Model; class Reservation { /** * May be Customer, Company or Whatever */ private $owner; } <?php namespace SharedModule\Model; class Reservation { /** * @ManyToOne(targetEntity=“ReservationOwnerIterface”) */ private $owner; } <?php namespace MyApp\Model; class Customer implements ReservationOwnerIterface { } #config.yml doctrine: orm: resolve_target_entities: SharedModule\Model\ReservationOwnerIterface: MyApp\Model\Customer
37. STRATEGIE DE NOMMAGE
38. STRATEGIE DE NOMMAGE <?php /** * @var string $avatarUrl * * @ORM\Column(name=“avatar_url”, type=“string”) */ private $avatarUrl;
39. STRATEGIE DE NOMMAGE <?php /** * @var string $avatarUrl * * @ORM\Column(name=“avatar_url”, type=“string”) */ private $avatarUrl; #config.yml doctrine: #... orm: #... naming_strategy: doctrine.orm.naming_strategy.underscore
40. STRATEGIE DE NOMMAGE <?php /** * @var string $avatarUrl * * @ORM\Column(name=“avatar_url”, type=“string”) */ private $avatarUrl; #config.yml doctrine: #... orm: #... naming_strategy: doctrine.orm.naming_strategy.underscore <?php interface NamingStrategy
 { function classToTableName($className); function propertyToColumnName($propertyName);
 function referenceColumnName();
 function joinColumnName($propertyName);
 function joinTableName($source, $target,$propertyName = null);
 function joinKeyColumnName($entityName, $referencedColumnName = null);
 }
41. EN VRAC ➤ Eviter les findAll. ➤ SingleScalar, ArrayResult. ➤ Rollback ➤ mb4utf8 ➤ ParamConverter
42. Merci; @inalgnu