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

by shinji.uyama

Slide 1

Slide 1 text

ASBJMTECNJHSBUFAΛ࢖Θͳ͍ εΩʔϚมߋΛܦݧֶͯ͠Μͩ͜ͱ .FHVSPSCBUυϦίϜ TIJOKJVZBNB

Slide 2

Slide 2 text

Ӊࢁ৻ೋ6ZBNB4IJOKJ 'SPOUFOE4FSWFSTJEF&OHJOFFS TIJOKJVZBNB !V@TIJOKJ ΞσΟογϡגࣜձࣾ

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

ͳͥASBJMTECNJHSBUFAΛ࢖Θͳ͍ εΩʔϚมߋΛߦͬͨͷ͔ʁ

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

ͦͷ݁Ռʜ

Slide 8

Slide 8 text

ςʔϒϧϩοΫ͕ൃੜ

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

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

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

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

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

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