Rails産でないDBを Railsに引っ越すHACK - Omotesando.rb #110

Omotesando.rb #110 のLT資料です
「Rails産でないDBをRailsに引っ越すHACK」

Transcript

1. 3BJMT࢈Ͱͳ͍%#Λ
   3BJMTʹҾͬӽ͢)"$, 0NPUFTBOEPSC
   
   
   !-OJ@5
   
   ϧχ
2. ࣗݾ঺հ w5XJUUFS 9
   *%
   !MOJ@5
   
   ϧχ
   w.FE1FFS ג ͷ3BJMTΤϯδχΞ
   w+BWBΛ3BJMTʹϦϓϨΠεͨ͠Γ
   1)1Λ3BJMTʹϦϓϨΠεͨ͠Γɹͯ͠ੜܭΛཱͯΔ ʘΑΖ͘͠Ͷʗ
5. ͸͡Ίʹ
6. ຊ೔ͷςʔϚ 3BJMT
7. ຊ೔ͷςʔϚ "DUJWF3FDPSE
8. "DUJWF3FDPSE
   ࢖͍ͬͯ·͔͢ʁ
9. "DUJWF3FDPSE  .7$ΞʔΩςΫνϟ
   ͷ
   .PEFM
   ෦෼
    .PEFM ॲཧ 7JFX දࣔ $POUSPMMFS ೖྗ఻ୡ
    ڧྗͳ03
   .BQQFS
    ϓϩάϥϛϯάݴޠͷΦϒδΣΫτͱ3%#.4Λ઀ଓ͢Δٕज़
    ΦϒδΣΫτͷଐੑ΍ؔ࿈ΛఆٛͰ͖Δ
    42-Λ௚઀هड़ͤͣɺอଘ΍औಘ͕Ͱ͖Δ
10. ศརʂ 3BJMTΤϯδχΞ͸
    42-͕ॻ͚ͳ͍ʂ
11. ҰํͰ
12. ن໿͕ఆΊΒΕ͍ͯΔ
13. ͍Ζ͍Ζͳن໿  ςʔϒϧ໊͸Ϟσϧ໊ͷෳ਺ܗ
    
    TOBLF@DBTF
     #PPL$MVC
    
    CPPL@DMVCT
     αϩήʔτΩʔ ػցతͳओΩʔ ͷར༻
     Կ΋ࢦఆ͠ͳ͚Ε͹
    JE
    ΧϥϜ͕ࣗಈੜ੒͞ΕΔ
     ֎෦Ωʔͷ໋໊͸
    ୯਺ܗͷςʔϒϧ໊@JE
    ύλʔϯ
14. ͍Ζ͍Ζͳن໿  ςʔϒϧ໊͸Ϟσϧ໊ͷෳ਺ܗ
    
    TOBLF@DBTF
     #PPL$MVC
    
    CPPL@DMVCT
     αϩήʔτΩʔ ػցతͳओΩʔ ͷར༻
     Կ΋ࢦఆ͠ͳ͚Ε͹
    JE
    ΧϥϜ͕ࣗಈੜ੒͞ΕΔ
     ֎෦Ωʔͷ໋໊͸
    ୯਺ܗͷςʔϒϧ໊@JE
    ύλʔϯ "DUJWF3FDPSEͷڧྗ͞ͷԸܙΛड͚Δʹ͸
    %#ઃܭΛن໿ʹ߹ΘͤΔඞཁ͕͋Δ
15. ઃఆΑΓ΋ن໿
    💪
16. ͔͠͠
17. 3BJMTͰͳ͍αʔϏεͷ%#͸ʁ
18. ຊ೔ͷςʔϚ  ଞͷݴޠ੡ͷ8FCαʔϏεΛ3BJMTʹϦϓϨΠε͢Δͧʂ %#ؔ࿈ͷͭΒ͍ࣄྫͱճආࡦ
19. લఏ৚݅
20. લఏ৚݅  %#ߏ଄Λ࠶ฤ੒͢ΔҠߦํ਑Ͱ͸ͳ͘ʜʜ
21. લఏ৚݅  ӡ༻தͷ%#ʹ઀ଓͯ͠ঃʑʹҠߦ͍ͯ͘͠ํ਑ʂ
22. ຊฤ
23. ໋໊ن໿ҧ൓ͷରࡦ
24. ໋໊ن໿ҧ൓ͷରࡦ  ςʔϒϧ໊ࢦఆ
    UBCMF@OBNF
     ֎෦Ωʔ໊ࢦఆ
    GPSFJHO@LFZ IUUQTSBJMTHVJEFTKQBDUJWF@SFDPSE@CBTJDTIUNM໋໊ن໿Λ্ॻ͖͢Δ
25. 3BJMT͸ن໿Λ্ॻ͖Ͱ͖Δ ͳΜͩࣗ༝౓ߴ͍͡ΌΜ
    😁😁😁
26. ͱࢥ͍͖΍ʜʁ
27. %BOHFSPVT"UUSJCVUF&SSPS  "DUJWF3FDPSE%BOHFSPVT"UUSJCVUF&SSPS
     3BJMTͰ༧໿ࡁͷΧϥϜ໊͸࢖͑ͳ͍
     IBTI
    NPEFM@OBNF
    PCKFDU@JE
    ͳͲͳͲʜʜ
     "DUJWF
    3FDPSEͷΠϯελϯεϝιου໊ͱಉ໊͡લͷΧϥϜ͕
    طଘ%#ͷςʔϒϧʹ࡞ΒΕ͍ͯΔͱ065
28. ରࡦʁ
29. ͦͷ໊લΛ࢖Θͳ͍
30. ӡ༻தͷΧϥϜͷ
    3FOBNF͸Өڹൣғେ Ͱ͖ͨΒ
    ۤ࿑͸͠ͳ͍
31. ۤ೑ͷࡦ ΧϥϜ໊͸ҡ࣋
32. JHOPSFE@DPMVNOT  "DUJWF3FDPSEΦϒδΣΫτ͔Β͸
    ແࢹ͞ΕΔ
     ஋ͷࢀর΋ઃఆ΋Ͱ͖ͳ͍
     औΓٸ͗ΤϥʔΛফ͍ͨ͠৔߹͸͜Ε
33. σʔλಡΈऔΓ
34. (FOFSBUFE
    $PMVNO  3%#.4ͷʮ(FOFSBUFE
    $PMVNOʯ ੜ੒ྻ ػೳ͕࢖͑Δ৔߹͋Γ
     .Z42-
    1PTUHSF42-
    42-JUF
    ͋ͨΓͰ͸࢖͑ͦ͏
     ΧϥϜͷ஋͕ɺΧϥϜఆٛͷʮࣜʯʹΑͬͯܭࢉ͞ΕΔ
35. (FOFSBUFE
    $PMVNO  ༧໿ࡁͰͳ໊͍લͷੜ੒ྻΛ௥Ճ͢Δ͜ͱͰ
    3BJMT͔Β஋ΛࢀরͰ͖ΔΑ͏ʹͳΔ
36. σʔλॻ͖ࠐΈ
37. جຊ͸%#ϨΠϠʔͰ΍Δ
38. σϑΥϧτ஋  σϑΥϧτ஋ఆٛʹܭࢉࣜΛઃఆ͓ͯ͘͠ */4&35࣌ʹ%#͕஋ΛೖΕͯ͘ΕΔʂ
39. 53*((&3  ςʔϒϧʹରͯ͠ಛఆͷΠϕϯτ͕ൃੜ͢Δͱ࣮ߦ͞ΕΔ 61%"5&࣌ʹ%#͕஋ΛೖΕͯ͘ΕΔʂ
40. ؅ཧ͕ͱͯ΋ͭΒ͍
41. ۤ೉͸ଓ͘
42. ෼ׂ%#ରࡦ
43. ςʔϒϧ͝ͱʹॴଐ%#͕ҟͳΔ  %#͕ෳ਺ଘࡏ͢Δ৔߹͕͋Δ
44. ෳ਺%#ରԠ  DPO fi HEBUBCBTFZNM
    Ͱ%#઀ଓΛෳ਺ఆٛ͢Δ͜ͱ͕Մೳ
45. DPOOFDUT@UP  Ͳͷ%#ʹ઀ଓ͢Δ͔ΛϞσϧʹఆٛͰ͖Δ
46. DPOOFDUT@UP  جఈΫϥεΛෳ਺࡞੒ͯ͠Ϟσϧ ςʔϒϧ ʹΑͬͯ࢖͍෼͚
47. ΊͰͨ͠
48. ͑ʂʁ
    %#Λ·͍ͨͰ
    5SBOTBDUJPOॲཧ͍ͨ͠ʁ
49. ͳͥ%#෼ׂ͞ΕͯΔʜʁ
50. ଟॏUSBOTBDUJPO  USBOTBDUJPOϒϩοΫΛଟॏʹ͢Δ͜ͱͰ࣮ݱՄೳ
     ʮσʔλϕʔείωΫγϣϯ୯ҐʯͰτϥϯβΫγϣϯॲཧ͞ΕΔ
51. ଟॏUSBOTBDUJPO  ϩʔϧόοΫ͍ͤͨ͞৔߹ʹཁ஫ҙ
     "DUJWF3FDPSE3PMMCBDLɹ͸USBOTBDUJPOΛஈ͔͠୤ग़Ͱ͖ͳ͍
52. ଟॏUSBOTBDUJPO  ϩʔϧόοΫ͍ͤͨ͞৔߹ʹཁ஫ҙ
     "DUJWF3FDPSE3PMMCBDLɹ͸USBOTBDUJPOΛஈ͔͠୤ग़Ͱ͖ͳ͍ ר͖໭Δ
53. ଟॏUSBOTBDUJPO  ϩʔϧόοΫ͍ͤͨ͞৔߹ʹཁ஫ҙ
     "DUJWF3FDPSE3PMMCBDLɹ͸USBOTBDUJPOΛஈ͔͠୤ग़Ͱ͖ͳ͍ ר͖໭Βͳ͍
54. ଟॏUSBOTBDUJPO  શͯͷUSBOTBDUJPOϒϩοΫΛඈͼग़͍ͯ͜͠͏
     3PMMCBDL
    Ҏ֎ͷྫ֎Ͱ͋Ε͹୤ग़Մೳ
55. ऻ͍དྷΔ-FHBDZͨͪ
56. .Z42-
    ;FSP
    %BUF  
    ɹͷଘࡏ
     .Z42-Ͱ͸
    ೥݄೔Λڐ༰͢Δ
     /05
    /6--੍໿ͷΧϥϜͰ͸ɺ/6--ͱ౳ՁͰ͋Γɺ/6--Ͱ͸ͳ͍
     *4
    /6--
    ͰϚον͢Δ
     *4
    /05
    /6--
    Ͱ΋Ϛον͢Δ
57. ରࡦʁ
58. ࢖Θͳ͍
59. 42-Ϟʔυ  42-Ϟʔυ
     42-ߏจͷڍಈΛ੾Γସ͑ΒΕΔΦϓγϣϯͷΑ͏ͳ΋ͷ
     ʮ42-ϞʔυʯʹΑΓ;FSP
    %BUF͸ېࢭͰ͖Δ جຊతʹ͸
     ҆͝৺͍ͩ͘͞
     .Z42-
    Ҏ߱Ͱ͸;FSP
    %BUFېࢭ͕σϑΥϧτ
60. 
    Λ
    طʹ࢖͍ͬͯΔ ݸͷςʔϒϧͰ
    EFGBVMU஋ʹར༻ ͔͠͠
61. ۤ೑ͷࡦ
62. 3BJMTʹೝࣝ͞Εͳ͍໰୊  3BJMT͸
    [FSP
    EBUF
    Λ
    OJM
    ͱͯ͠ѻ͏
     ECTDIFNBEVNQ
    ͯ͠΋ग़ྗ͞Εͳ͍ʂ
     EFWFMPQ
    UFTU؀ڥͰ%#ߏ੒͕࠶ݱͰ͖ͳ͍ʜʜ
63. ؾ߹ϞϯΩʔύον  "DUJWF3FDPSEͷ4DIFNB%VNQFSʹؾ߹ͷύονΛ౰ͯΔ
64. *OWBMJE
    EFGBVMU
    WBMVF  σϑΥϧτ஋͕;FSP
    EBUFͷΧϥϜΛؚΉςʔϒϧʹରͯ͠
    "-5&3
    5"#-&Λൃߦ͢Δͱ
    *OWBMJE
    EFGBVMU
    WBMVF
    ΤϥʔͱͳΔ
65. 42-Ϟʔυมߋ  EBUBCBTFZNM
    Ͱʮݫີͳ42-ϞʔυʯΛGBMTFʹͯ͠ճආ
     ฐ֐͕େ͖͗͢ΔͷͰਅࣅ͠ͳ͍Α͏ʹʂ
66. ͜ͷষ͸ਅࣅ͠ͳ͍Α͏ʹ
    ຊ౰ʹ
67. ·ͱΊ
68. ՔಇதͷαʔϏεɾσʔλΛकΔ
    ϦϓϨΠε΋΍Δ
69. େม
70. γεςϜҠߦ͸େม  ࠓՔಇ͍ͯ͠ΔϏδωεɾϢʔβʔɾσʔλΛकΔͷ͕େલఏ
     ϨΨγʔίʔυͳΒ͵ɺϨΨγʔσʔλߏ଄վળ΋ฒߦ͢Δඞཁ͋Γ
     ͦͷଞͷͭΒ͍ࣄྫɺΑ͖ղܾํ๏Λ͝ଘ஌ͷํ
     ͓࿩͠·͠ΐ͏ʂ