ActiveRecordのスコープ調整に試行錯誤した

by kaede_kuroda

Slide 1

Slide 1 text

"DUJWF3FDPSEͷ είʔϓௐ੔ʹࢼߦࡨޡͨ͠

Slide 2

Slide 2 text

2 Fablic, inc. Software Engineer ࠇాɹ෨ kaede-kuroda ࣗݾ঺հ ओʹαʔόʔαΠυͷ։ൃΛ୲౰ ্݄०ʹδϣΠϯ

Slide 3

Slide 3 text

3 ϑϦϧ '3*- ʮཉ͍͠ʯ͕Έ͔ͭΔϑϦϚΞϓϦ

Slide 4

Slide 4 text

4 ֓ཁ '3*-ͷ؅ཧը໘ ɾ3VCZPO3BJMTܥ ɾ"DUJWF"ENJO ࠓճͷ໨త ɹϢʔβʔ͔Βͷ໰͍߹ΘͤΛ؅ཧ͢Δը໘ʹ ɹʮཧ༝ͳ͠ʯݕࡧΛ࣮૷͢Δ

Slide 5

Slide 5 text

5 ֓ཁ ໰͍߹Θͤ ɹϢʔβʔ͞Μ͔ΒαʔϏεʹؔ͢Δ࣭໰ ɹ͕ૹΒΕͯ͘Δ ͍͔ͭ͘ͷύλʔϯ͕͋Δ ɹେମͷਓ͸ύλʔϯʹै࣭ͬͯ໰ ɹكʹʮཧ༝ͳ͠ʯͷਓ΋͍Δ

Slide 6

Slide 6 text

6 ֓ཁ σʔλߏ଄ ɹ໰͍߹Θͤཧ༝ *ORVJSZɹˡཧ༝͸࣋ͬͯͳ͍ ˢˣɹͰඥ෇͘ *ORVJSZ5ZQFUZQF

Slide 7

Slide 7 text

7 ֓ཁ ݕࡧ͍ͨ͠σʔλ ໰͍߹Θͤɹͷɹཧ༝ɹ͕ɹͳ͍ɹਓ *ORVJSZɹʹඥ෇͘ *ORVJSZ5ZQFɹͷ UZQFɹ͕ɹOJMͷϨίʔυ Λείʔϓʹࢦఆ͢Δʜ

Slide 8

Slide 8 text

࠷ॳͷ࣮૷ 8

Slide 9

Slide 9 text

9 ࠷ॳͷ࣮૷ ࢀߟίʔυ XIFSF VTFS@JE*ORVJSZ5ZQFXIFSF UZQFUZQF QMVDL VTFS@JE ࣮૷ίʔυ XIFSFOPU VTFS@JE*ORVJSZ5ZQFBMMQMVDL VTFS@JE ?Т? ؆୯̇؆୯̇

Slide 10

Slide 10 text

10 ߜΓࠐΈํ๏ ໰͍߹ΘͤABMMAͰશͯͷ৘ใΛҾ͍͍ͯΔ Ϩίʔυ͕ଟ͍ͱةݥ ໰͍߹Θͤ ཧ༝ ʔ ʹ݁Ռ 3BJMT

Slide 11

Slide 11 text

ޮ཰తͳํ๏ʹվળʹ͢Δ͍ͧ ٩ Т و 11

Slide 12

Slide 12 text

12 ޮ཰తͳ࣮૷ʹվળ "DUJWF3FDPSEɹͷه๏͕ྑ͘Θ͔Βͳ͍ XIFSFɹҐ͔͠ීஈ࢖Θͳ͍͠ʜ ࠷ॳ͸42-Ͱॻ͘͜ͱʹͨ͠

Slide 13

Slide 13 text

13 ޮ཰తͳ࣮૷ʹվળ .Z42-ଆͰ݁߹ͯ͠ ߜΓࠐΜͩ৘ใ͚ͩҾ༷͘ʹͨ͠ ໰͍߹Θͤ ཧ༝ UZQFJTOVMMʹ݁Ռ ʆŋТŋ ɹ+0*/ 3BJMT .Z42-

Slide 14

Slide 14 text

14 ޮ཰తͳ࣮૷ʹվળ 42-ॻ͍ͯΈͨ 4&-&$5$06/5 '30.A*ORVJSZA -&'5+0*/A*ORVJSZ5ZQFA POA*ORVJSZ5ZQFAVTFS@JEA*ORVJSZAVTFS@JE XIFSFUZQFJTOVMM ࠓ·ͰงғؾͰ+0*/͔ͯͨ͠Βษڧʹͳͬͨ

Slide 15

Slide 15 text

15 ޮ཰తͳ࣮૷ʹվળ "DUJWF3FDPSEه๏ʹ௚ͯ͠ΈΔ KPJOTɹ࢖͏ͱɹJOOFSKPJOʹͳͬͯ͠·͏ Ҿ༻ɿIUUQHVJEFTSVCZPOSBJMTPSH

Slide 16

Slide 16 text

16 ޮ཰తͳ࣮૷ʹվળ "DUJWF3FDPSEه๏ʹ௚ͯ͠ΈΔ KPJOTʹੜ42-ॻ͜͏ͱ͚ͨ͠Ͳ͓࡞๏తʹΞϨ ʢྫʣ 1PTUKPJOT -&'5065&3+0*/AVTFSTA0/AVTFSTAAJEA AQPTUTAAVTFS@JEAz

Slide 17

Slide 17 text

17 ޮ཰తͳ࣮૷ʹվળ "DUJWF3FDPSEه๏ʹ௚ͯ͠ΈΔ JODMVEFT࢖͏ͱ*ORVJSZ5ZQF͕ ݟ͔ͭΒͳ͍ͱౖΒΕΔ Ϟσϧڞ௨ԽʹΑΔ໰୊

Slide 18

Slide 18 text

18 ޮ཰తͳ࣮૷ʹվળ PʅЧA ь͸͊ŋŋŋ

Slide 19

Slide 19 text

19 ޮ཰తͳ࣮૷ʹվળ ΊͬͪΌศརͳه๏͋ͬͨ "MFGU@KPJOT C XIFSF C\JEOJM^

Slide 20

Slide 20 text

20 ޮ཰తͳ࣮૷ʹվળ 3BJMTܥͰ͔͠࢖͑ͳ͍

Slide 21

Slide 21 text

21 ޮ཰తͳ࣮૷ʹվળ ݁Ռతʹੜ42-ซ༻ͨ͠ TDPQFJORVJSZ@UZQF@OJM \ KPJOT -&'5+0*/*ORVJSZ5ZQF POA*ORVJSZ5ZQFAVTFS@JEA*ORVJSZAVTFS@JE XIFSF UZQFJTOVMM ^

Slide 22

Slide 22 text

·ͱΊ 22

Slide 23

Slide 23 text

23 ·ͱΊ ؔ࿈ςʔϒϧΛ-FGU@+PJOͯ͠৚݅நग़͍ͨ͠৔߹ ໰͍߹Θͤ ཧ༝ UZQFJTOVMMʹ݁Ռ ʆŋТŋ ɹ+0*/ 3BJMT .Z42-

Slide 24

Slide 24 text

24 ·ͱΊ ํ๏̍ ɹJODMVEFTSFGFSFODFTͰMFGUKPJOʹ͢Δ JODMVEFT ݁߹͍ͨ͠ςʔϒϧ SFGFSFODFT ݁߹͍ͨ͠ςʔϒϧ XIFSF ΧϥϜ໊OJM ํ๏̎ ɹMFGU@KPJOTΛ࢖͏ 3BJMTܥ ɹMFGU@KPJOT ݁߹͍ͨ͠ςʔϒϧ XIFSF ݁߹͍ͨ͠ςʔϒϧ\ΧϥϜ໊OJM^

Slide 25

Slide 25 text

25 ·ͱΊ ੒Ռ ɹ˓ϝϞϦ͕ඈͼ͔Ͷͳ͍ةݥͳΫΤϦΛվળ ɹʷ"3ͰεϚʔτʹهड़͢Δ ɹɹ˓3BJMTܥͰ࢖͑Δه๏Λൃݟ

Slide 26

Slide 26 text

26 ·ͱΊ ·ͱΊ ɹงғؾͰ࢖͍ͬͯͨ"3ͷ࢖͍ํ͕৭ʑΘ͔ͬͨ ɹʢӳޠ͚ͩͲʜυΩϡϝϯτศརɹ͋ͱ42-ઌʹॻ͘ͷศརʣ ɹΫΤϦͷνϡʔχϯάେࣄ ɹʢ͋ͷ··ຊ൪σϓϩΠͨ͠ΒϠόͦ͏ʣ ɹόʔδϣϯΞοϓͨ͠ํ͕ศརͦ͏ ɹʢͰ͖ͳ͍ཧ༝΋͋ΔΑͶʣ

Slide 27

Slide 27 text

͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠