DoctrineとPostgreSQLの便利な機能、どっちも諦めたくない！

DoctrineORMの便利な機能とPostgreSQLの便利な機能、欲張りセットしていきましょう。
参考リンク集:
* Eventを使う https://www.doctrine-project.org/projects/doctrine-orm/en/3.3/reference/events.html#events
* DQLのカスタム関数を作る https://tech.quartetcom.co.jp/2015/12/01/doctrine-date-function-extension/
* Doctrineのカスタム型を作る https://tech.quartetcom.co.jp/2015/10/30/doctrine-custom-mapping-type/
* DoctrineのAttributeを自作する（Eventを使う、の上級編） https://github.com/77web/doctrine-postgresql-row-level-security

Transcript

1. UI
   /PW
   
   BU
   3"#0
   
   -JOLBHF
   TUVEZ
   CZ
   !XFC %PDUSJOFͱ1PTUHSF42-ͷศར ͳػೳɺͲͬͪ΋ఘΊͨ͘ͳ͍ʂ
2. %PDUSJOFʢ03.ʣศར w جຊతͳ03.ػೳ
   w JOTFSUVQEBUF
   w IZESBUJPO
   w RVFSZ#VJMEFS
   w NJHSBUJPO
   w ๭-ͷϑϨʔϜϫʔΫͷ&ͷ03.ʹ͸ແ͍ศརͳػೳ
   w 45*
   w VTJOH
   GPSFJHO
   LFZ
   PS
   DPNQPTJUF
   LFZ
   BT
   QSJNBSZ
   LFZ
   w FUD
3. 1PTUHSF42-ศར w CVJMUJO
   SBOHF
   UZQFT
   w CVJMUJO
   FOVN
   w SPX
   MFWFM
   TFDVSJUZ
4. %PDUSJOF 03. ෆศ w BCTUSBDUJPO
   w 1PTUHSF42-ͷศརͳػೳͰ΋.Z42-౳ଞͷ%#.4ʹແ͍΋ͷ͸ఏڙ͞Ε ͳ͍ʢجຊతʹʣ
   w KTPOCͳͲΦϓγϣϯࢦఆͰ࢖͑Δ΋ͷ΋͋Δ
5. %PDUSJOF 03. ศརʂʂ w %PDUSJOF͸֦ுͰ͖Δʂ
   w ֦ுϙΠϯτ͕༻ҙ͞Ε͍ͯΔ
   w &WFOU
   w $VTUPN5ZQF
   w $VTUPN'VODUJPO
6. %PDUSJOF֦ுʁ w %PDUSJOF&YUFOTJPOT͕༗໊
   IUUQTHJUIVCDPNEPDUSJOFFYUFOTJPOT %PDUSJOF&YUFOTJPOT
   w 5JNFTUBNQBCMF
   w 4PGU%FMFUF
   w -PHHBCMF
   w 5SFF
7. %PDUSJOF֦ுΛࣗ࡞͢Δ w &WFOUΛ࢖͏
   w %2-ͷΧελϜؔ਺Λ࡞Δ
   w %PDUSJOFͷΧελϜܕΛ࡞Δ
   w %2-ͷΧελϜԋࢉࢠΛ࡞Δ
   w %PDUSJOFͷ"UUSJCVUFΛࣗ࡞͢Δʢ&WFOUΛ࢖͏ɺͷ্ڃฤʣ
8. %PDUSJOF֦ுΛࣗ࡞͢Δ w &WFOUΛ࢖͏
   IUUQTXXXEPDUSJOFQSPKFDUPSHQSPKFDUTEPDUSJOFPSNFO SFGFSFODFFWFOUTIUNMFWFOUT
   w %2-ͷΧελϜؔ਺Λ࡞Δ
   IUUQTUFDIRVBSUFUDPNDPKQEPDUSJOFEBUF GVODUJPOFYUFOTJPO
   w %PDUSJOFͷΧελϜܕΛ࡞Δ
   IUUQTUFDIRVBSUFUDPNDPKQEPDUSJOF DVTUPNNBQQJOHUZQF
   w %2-ͷΧελϜԋࢉࢠΛ࡞Δ
   ʢະୡʣ
   w %PDUSJOFͷ"UUSJCVUFΛࣗ࡞͢Δʢ&WFOUΛ࢖͏ɺͷ্ڃฤʣ
   IUUQTHJUIVCDPNXFC EPDUSJOFQPTUHSFTRMSPXMFWFMTFDVSJUZ
   ʢಓ൒͹Ͱ͢ʣ
9. %PDUSJOF֦ுΛࣗ࡞͢Δ w &WFOUΛ࢖͏
   w %2-ͷΧελϜؔ਺Λ࡞Δ
   w %PDUSJOFͷΧελϜܕΛ࡞Δ
   w %2-ͷΧελϜԋࢉࢠΛ࡞Δ
   w %PDUSJOFͷ"UUSJCVUFΛࣗ࡞͢Δʢ&WFOUΛ࢖͏ɺͷ্ڃฤʣ
10. MJOLBHFEPDUSJOFQPTUHSFTRMUTU[SBOHF w ࡞Γ·ͨ͠
    IUUQTHJUIVCDPNXFCEPDUSJOFQPTUHSFTRMUTU[SBOHF
11. ʮखΛಈ͔ͨ͠ऀ͚͕ͩੈքΛม͑Δʯ w %PDUSJOFͱ1PTUHSF42-ͷศརͳػೳɺཉுΓηοτ͍ͯ͜͠͏
12. 5IBOL
    ZPV