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

Transcript

1. 3BJMT࢈Ͱͳ͍%#Λ 3BJMTʹҾͬӽ͢)"$, 0NPUFTBOEPSC !-OJ@5ϧχ

2. ࣗݾ঺հ w5XJUUFS 9 *%!MOJ@5 ϧχ w.FE1FFS ג ͷ3BJMTΤϯδχΞ w+BWBΛ3BJMTʹϦϓϨΠεͨ͠Γ

   1)1Λ3BJMTʹϦϓϨΠεͨ͠Γɹͯ͠ੜܭΛཱͯΔ ʘΑΖ͘͠Ͷʗ
3. None
4. None

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$MVCCPPL@DMVCT αϩήʔτΩʔ ػցతͳओΩʔ ͷར༻

    Կ΋ࢦఆ͠ͳ͚Ε͹JEΧϥϜ͕ࣗಈੜ੒͞ΕΔ ֎෦Ωʔͷ໋໊͸୯਺ܗͷςʔϒϧ໊@JEύλʔϯ

14. ͍Ζ͍Ζͳن໿ ςʔϒϧ໊͸Ϟσϧ໊ͷෳ਺ܗTOBLF@DBTF #PPL$MVCCPPL@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ͳͲͳͲʜʜ

    "DUJWF3FDPSEͷΠϯελϯεϝιου໊ͱಉ໊͡લͷΧϥϜ͕ طଘ%#ͷςʔϒϧʹ࡞ΒΕ͍ͯΔͱ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͸[FSPEBUFΛOJMͱͯ͠ѻ͏ ECTDIFNBEVNQͯ͠΋ग़ྗ͞Εͳ͍ʂ EFWFMPQ UFTU؀ڥͰ%#ߏ੒͕࠶ݱͰ͖ͳ͍ʜʜ

63. ؾ߹ϞϯΩʔύον "DUJWF3FDPSEͷ4DIFNB%VNQFSʹؾ߹ͷύονΛ౰ͯΔ

64. *OWBMJEEFGBVMUWBMVF σϑΥϧτ஋͕;FSPEBUFͷΧϥϜΛؚΉςʔϒϧʹରͯ͠ "-5&35"#-&Λൃߦ͢Δͱ*OWBMJEEFGBVMUWBMVFΤϥʔͱͳΔ

65. 42-Ϟʔυมߋ EBUBCBTFZNMͰʮݫີͳ42-ϞʔυʯΛGBMTFʹͯ͠ճආ ฐ֐͕େ͖͗͢ΔͷͰਅࣅ͠ͳ͍Α͏ʹʂ

66. ͜ͷষ͸ਅࣅ͠ͳ͍Α͏ʹ ຊ౰ʹ

67. ·ͱΊ

68. ՔಇதͷαʔϏεɾσʔλΛकΔ ϦϓϨΠε΋΍Δ

69. େม

70. γεςϜҠߦ͸େม ࠓՔಇ͍ͯ͠ΔϏδωεɾϢʔβʔɾσʔλΛकΔͷ͕େલఏ ϨΨγʔίʔυͳΒ͵ɺϨΨγʔσʔλߏ଄վળ΋ฒߦ͢Δඞཁ͋Γ ͦͷଞͷͭΒ͍ࣄྫɺΑ͖ղܾํ๏Λ͝ଘ஌ͷํ ͓࿩͠·͠ΐ͏ʂ