Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
migrationツールについて
Search
carotene4035
December 18, 2018
0
88
migrationツールについて
carotene4035
December 18, 2018
Tweet
Share
More Decks by carotene4035
See All by carotene4035
GraphQLのN+1問題を解決したい
carotene4035
1
220
読者を置き去りにする技術
carotene4035
13
8.2k
Aws is emotional.
carotene4035
2
280
名称未設定.pdf
carotene4035
0
210
AWSネットワーク入門
carotene4035
3
320
adtech history
carotene4035
0
75
ファイルアクセスに関する脆弱性
carotene4035
0
110
僕らだけのアニメを放映する
carotene4035
3
1.3k
使いやすい広告管理画面について考えてみる
carotene4035
0
47
Featured
See All Featured
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
162
15k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
46
7.6k
It's Worth the Effort
3n
187
28k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
48
9.7k
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
9
850
Statistics for Hackers
jakevdp
799
220k
KATA
mclloyd
32
15k
How to train your dragon (web standard)
notwaldorf
96
6.3k
A designer walks into a library…
pauljervisheath
209
24k
Docker and Python
trallard
46
3.6k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
31
9.7k
Mobile First: as difficult as doing things right
swwweet
224
10k
Transcript
migration πʔϧʹ͍ͭͯ Carotene4035
։ൃதʹࠔΔ͜ͱ • ζϨ • ։ൃڥͷζϨ • ιʔείʔυͷόʔδϣϯͷζϨ • ڥมͷζϨ •
DBͷεΩʔϚͷζϨ
DBεΩʔϚͷζϨ • ιʔείʔυಉ͡ɺ ͰDBεΩʔϚ͕ζϨ͍ͯΔͱΤϥʔ͕ͰΔ ʢଘࡏ͠ͳ͍ΧϥϜΛࢀরͯ͠͠·ͬͨΓͳͲʣ • ։ൃڥͱຊ൪ڥͰDBεΩʔϚ͕ζϨΔͱ ҙਤ͠ͳ͍όά͕͋Δ͔
ζϨΛ͙ʹ • ͦͷ̍ confluenceͳͲͷπʔϧͰཧ • ͦͷ̎ migrationπʔϧͰཧ
ͦͷ̍ • confluenceͳͲͰཧ • ॳΊશ෦createจͰཧ • ঃʑʹalterจΛͳΒͯεΩʔϚมߋΛ͚Ճ͍͑ͯ͘ • نʹΑͬͯಛʹͳ͍
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮ͜ͷڥͰɺͲͷalter·Ͱྲྀ͚ͨͬ͠ʯ • ڥ͝ͱʹͲ͜·Ͱྲྀ͔ͨ͠ΛϝϞ͢ΕOK
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮࣗͷڥͰͲ͜·Ͱྲྀ͚ͨͬ͠…ʯ • ͓͚֮͑ͯOKʢ͠ΜͲ͘ͳ͖ͬͯͨʣ
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮࠓͷιʔείʔυͷ࣌ͬͯͲ͏͍͏εΩʔϚ͚ͩͬʯ
ζϨΛ͙ʹ • ʮͲͷڥʯͰʮͲͷSQLʯΛʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ ͕Θ͔͚ΕΑ͍
ͦͷ̎ • migrationπʔϧ • ʮͲ͜·Ͱྲྀ͔ͨ͠ʯΛςʔϒϧ্Ͱཧ • ʮͲͷڥʯͰʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ͕Θ͔Δ • ͔͠ɺ·ͩྲྀ͍ͯ͠ͳ͍sqlΛྲྀ͢ʹ sql-migrate
up ͱ͢Δ͚ͩͰྲྀΕΔ
͚ͬ͜͏͍Ζ͍Ζ͋Δ
࣮ԋ