`rails db:migrate`を使わない スキーマ変更を経験して学んだこと

Transcript

1. ASBJMT
   ECNJHSBUFAΛ࢖Θͳ͍
   εΩʔϚมߋΛܦݧֶͯ͠Μͩ͜ͱ 
   .FHVSPSC
   BU
   υϦίϜ
   TIJOKJVZBNB

2. Ӊࢁ৻ೋ
   
   6ZBNB
   4IJOKJ
   
   'SPOUFOE
   
   4FSWFSTJEF
   &OHJOFFS
   TIJOKJVZBNB !V@TIJOKJ ΞσΟογϡגࣜձࣾ

3. ࠓ೔࿩͢Δ͜ͱ w ͳͥASBJMT
   ECNJHSBUFAΛ࢖Θͳ͍εΩʔϚมߋΛͨ͠ʁ
   w ͦͷࡍʹֶΜͩ͜ͱ

4. ͳͥASBJMT
   ECNJHSBUFAΛ࢖Θͳ͍
   εΩʔϚมߋΛߦͬͨͷ͔ʁ

5. ࣄͷൃ୺ ֎෦੍໿ΩʔͷมߋΛ͔ͨͬͨ͠

6. ࣄͷൃ୺ ˢ࣮ߦ͞ΕΔ42-จ ֎෦੍໿ΩʔͷมߋΛ͔ͨͬͨ͠

7. ͦͷ݁Ռʜ

8. ςʔϒϧϩοΫ͕ൃੜ

9. ֎෦੍໿Ωʔ௥Ճ͸௨ৗςʔϒϧϩοΫ͞ΕΔ IUUQTEFWNZTRMDPNEPDSFGNBOKBJOOPECDSFBUFJOEFYPWFSWJFXIUNM ࢀর
   .Z42-
   ϦϑΝϨϯεɿΦϯϥΠϯ%%-

10. ςʔϒϧϩοΫͤ͞ͳ͍Α͏ʹ͢ΔͨΊʹ
    ASBJMT
    ECNJHSBUFAΛ࢖Θͳ͍εΩʔϚมߋ͔ΒֶΜͩ͜ͱ

11. ֶͼ w ATDIFNB@NJHSBUJPOTAςʔϒϧͷ໾ׂ
    w ASBJMT
    ECNJHSBUFAͰ࡞ΒΕΔΠϯσοΫεͷ໊લ

12. ςʔϒϧϩοΫ͞ΕΔ໰୊ͷରԠ͸ʁ

13. ରԠࡦ ઐ༻ͷϚΠάϨʔγϣϯπʔϧΛ࢖͏͜ͱͰ
    ςʔϒϧϩοΫΛ͠ͳ͍ঢ়ଶͰεΩʔϚมߋ

14. ରԠϑϩʔ #VJME %#
    .JHSBUJPO %FQMPZNFOU ಛผରԠ࣌ͷσϓϩΠϑϩʔ πʔϧΛ࢖ͬͨ
    %#
    .JHSBUJPO 3BJMTͷ%#
    .JHSBUJPOΛεΩοϓ ࣗಈσϓϩΠ खಈରԠ

15. ಛఆͷ%#
    .JHSBUJPOΛͲ͏΍ͬͯεΩοϓ͢Δͷʁ

16. ATDIFNB@NJHSBUJPOTAςʔϒϧ %#
    .JHSBUJPOͷ؅ཧΛߦ͏ςʔϒϧ

17. ATDIFNB@NJHSBUJPOTAςʔϒϧ %#
    .JHSBUJPOͷ؅ཧΛߦ͏ςʔϒϧ ಛఆͷ%#ϚΠάϨʔγϣϯΛεΩοϓ͚ͨ͠Ε͹ɺ
    ࢦఆͷϑΝΠϧࣝผࢠΛࣄલʹςʔϒϧʹΠϯαʔτ͢Ε͹Α͍ʂ

18. πʔϧʹΑΔ%#
    .JHSBUJPOͰɺଞʹ֬ೝ͢΂͖͜ͱ͋Δʁ

19. πʔϧΛ࢖͏ࡍͷ֬ೝࣄ߲ πʔϧʹΑΔ%#
    .JHSBUJPO 3BJMTʹΑΔ%#
    .JHSBUJPO ̎ͭͷํ๏ͷ݁ՌͷؒͰ
    ςʔϒϧߏ଄ͷҧ͍͕ͳ͍Α͏ʹ͍ͨ͠

20. Կ΋ߟ͑ͣʹ΍ͬͯΈΔ ֎෦੍໿ͷ௥Ճ

21. ̎ͭͷํ๏ͷؒͰ͕ࠩੜ·Δ w 3BJMTͷ%#
    .JHSBUJPOͷ৔߹ɺݻ༗ͷΠϯσοΫε໊ͷࢦఆΛߦͳͬ ͍ͯΔ
    w 3BJMTͷ%#
    .JHSBUJPO࣌ͷ໋໊ͱҟͳΔ৔߹ɺTDIFNBSCʹΠϯ σοΫε໊͕දࣔ͞ΕΔ TDIFNBSCͷࠩ෼

22. ΠϯσοΫε໊ͷࢦఆ͸ඞཁ

23. ·ͱΊ w ಛఆͷ%#
    .JHSBUJPOͷεΩοϓ͍ͨ͠৔߹͸ɺ ATDIFNB@NJHSBUJPOTAςʔϒϧ͕໾ཱͭ w ASBJMT
    ECNJHSBUFAҎ֎ͷํ๏ͰΠϯσοΫε࡞੒Λ͢Δ৔߹͸ɺ
 ద੾ͳΠϯσοΫε໊Λࢦఆ͢Δ͜ͱ w A"-5&3
    5"#-&A͢Δࡍ͸ɺςʔϒϧϩοΫʹؾΛ͚ͭͯʜ

24. ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠