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.1k
Aws is emotional.
carotene4035
2
280
名称未設定.pdf
carotene4035
0
210
AWSネットワーク入門
carotene4035
2
310
adtech history
carotene4035
0
74
ファイルアクセスに関する脆弱性
carotene4035
0
110
僕らだけのアニメを放映する
carotene4035
3
1.3k
使いやすい広告管理画面について考えてみる
carotene4035
0
46
Featured
See All Featured
Measuring & Analyzing Core Web Vitals
bluesmoon
9
570
StorybookのUI Testing Handbookを読んだ
zakiyama
30
6k
Improving Core Web Vitals using Speculation Rules API
sergeychernyshev
18
1.1k
Designing for humans not robots
tammielis
253
25k
How to Ace a Technical Interview
jacobian
279
23k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
36
2.5k
Building Applications with DynamoDB
mza
96
6.6k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
Being A Developer After 40
akosma
90
590k
Fantastic passwords and where to find them - at NoRuKo
philnash
51
3.4k
Faster Mobile Websites
deanohume
309
31k
Transcript
migration πʔϧʹ͍ͭͯ Carotene4035
։ൃதʹࠔΔ͜ͱ • ζϨ • ։ൃڥͷζϨ • ιʔείʔυͷόʔδϣϯͷζϨ • ڥมͷζϨ •
DBͷεΩʔϚͷζϨ
DBεΩʔϚͷζϨ • ιʔείʔυಉ͡ɺ ͰDBεΩʔϚ͕ζϨ͍ͯΔͱΤϥʔ͕ͰΔ ʢଘࡏ͠ͳ͍ΧϥϜΛࢀরͯ͠͠·ͬͨΓͳͲʣ • ։ൃڥͱຊ൪ڥͰDBεΩʔϚ͕ζϨΔͱ ҙਤ͠ͳ͍όά͕͋Δ͔
ζϨΛ͙ʹ • ͦͷ̍ confluenceͳͲͷπʔϧͰཧ • ͦͷ̎ migrationπʔϧͰཧ
ͦͷ̍ • confluenceͳͲͰཧ • ॳΊશ෦createจͰཧ • ঃʑʹalterจΛͳΒͯεΩʔϚมߋΛ͚Ճ͍͑ͯ͘ • نʹΑͬͯಛʹͳ͍
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮ͜ͷڥͰɺͲͷalter·Ͱྲྀ͚ͨͬ͠ʯ • ڥ͝ͱʹͲ͜·Ͱྲྀ͔ͨ͠ΛϝϞ͢ΕOK
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮࣗͷڥͰͲ͜·Ͱྲྀ͚ͨͬ͠…ʯ • ͓͚֮͑ͯOKʢ͠ΜͲ͘ͳ͖ͬͯͨʣ
ͦͷ̍ • ߟ͑ΒΕ͏Δ • ʮࠓͷιʔείʔυͷ࣌ͬͯͲ͏͍͏εΩʔϚ͚ͩͬʯ
ζϨΛ͙ʹ • ʮͲͷڥʯͰʮͲͷSQLʯΛʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ ͕Θ͔͚ΕΑ͍
ͦͷ̎ • migrationπʔϧ • ʮͲ͜·Ͱྲྀ͔ͨ͠ʯΛςʔϒϧ্Ͱཧ • ʮͲͷڥʯͰʮͲ͜·Ͱྲྀ͍ͯ͠Δ͔ʯ͕Θ͔Δ • ͔͠ɺ·ͩྲྀ͍ͯ͠ͳ͍sqlΛྲྀ͢ʹ sql-migrate
up ͱ͢Δ͚ͩͰྲྀΕΔ
͚ͬ͜͏͍Ζ͍Ζ͋Δ
࣮ԋ