業務効率を改善するためのTrello自動化物語

Transcript

1. ۀ຿ޮ཰Λվળ͢ΔͨΊͷ TrelloࣗಈԽ෺ޠ ୈճ
   5PLZP
   "UMBTTJBO
   Ϣʔβʔάϧʔϓ

2. What is it? ಥવͰ͕͢ɾɾɾ

3. What is it? ΤϯδχΞͷਓ

4. What is it? Ӧۀͷਓ

5. What is it? όοΫΦϑΟεͷਓ

6. What is it? ୭Ͱ΋࢖͑Δͷ͕Trelloͷྑ͞

7. What is it? ͦΜͳTrelloΛ࢖ͬͨ࿩Λ͠·͢

8. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹTrelloͰ΍Γ͍ͨ͜ͱ ̏ɹAPIʹ͍ͭͯ ̐ɹ׆༻ࣄྫ ̑ɹ·ͱΊ

9. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹTrelloͰ΍Γ͍ͨ͜ͱ ̏ɹAPIʹ͍ͭͯ ̐ɹ׆༻ࣄྫ ̑ɹ·ͱΊ

10. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ33ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿCustomer Reliability Engineering ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹɹ

    ษڧձ୲౰ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

11. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ33ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿCustomer Reliability Engineering ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹɹ

    ษڧձ୲౰ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

12. Mackerel

13. ͸ͯͳ͸஥ؒΛ୳ͯ͠·͢ curl -sIL mackerel.io | grep engineer

14. ͸ͯͳ͸஥ؒΛ୳ͯ͠·͢ curl -sIL mackerel.io | grep engineer ͜Εͩͱ$3&ग़ͯ͜ͳ͍ͷͰ
    HSFQ
    DSF
    ͍ͯͩ͘͠͞ʂʂ

15. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹTrelloͰ΍Γ͍ͨ͜ͱ ̏ɹAPIʹ͍ͭͯ ̐ɹ׆༻ࣄྫ ̑ɹ·ͱΊ

16. TrelloͰ΍Γ͍ͨ͜ͱ λεΫͷՄࢹԽ

17. TrelloͰ΍Γ͍ͨ͜ͱ λεΫͷՄࢹԽ
    ˣ
    ಛʹঢ়ଶͷ؅ཧ

18. λεΫͷՄࢹԽ

19. TrelloͰ΍Γ͍ͨ͜ͱ ΧϯόϯΛ΍Γ͍ͨ
    

20. TrelloͰ΍Γ͍ͨ͜ͱ ΧϯόϯΛ΍Γ͍ͨ
    ˣ
    Ͱ΋ΧϯόϯͷϝϯςφΛ
    ΍Γ͍ͨΘ͚Ͱ͸ͳ͍

21. 5SFMMP͓͡͞Μۀ
    w ఆྫλεΫͷνέοτԽ
    w Ԙ௮͚͞ΕͨλεΫͷ࠵ଅ
    w աෛՙͳਓͷλεΫ֬ೝ TrelloͰ΍Γ͍ͨ͜ͱ

22. TrelloͰ΍Γ͍ͨ͜ͱ ඞཁͳ͜ͱ͕ͩࣗ෼ͨͪͷ
    ຊདྷ΍Δ΂͖͜ͱͰ͸ͳ͍

23. TrelloͰ΍Γ͍ͨ͜ͱ ࣗ෼ͨͪͷλεΫʹूத͍ͨ͠
    

24. TrelloͰ΍Γ͍ͨ͜ͱ ࣗ෼ͨͪͷλεΫʹूத͍ͨ͠
    ˣ
    5SFMMP͓͡͞ΜۀΛࣗಈԽ͢Δ

25. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹTrelloͰ΍Γ͍ͨ͜ͱ ̏ɹAPIʹ͍ͭͯ ̐ɹ׆༻ࣄྫ ̑ɹ·ͱΊ

26. APIʹ͍ͭͯ ࣗಈԽ͢ΔͨΊʹ͸"1*Λ׆༻͢Δ

27. ެࣜυΩϡϝϯτ
    IUUQTEFWFMPQFSTUSFMMPDPNWSFGFSFODF APIʹ͍ͭͯ

28. ެࣜυΩϡϝϯτ
    IUUQTEFWFMPQFSTUSFMMPDPNWSFGFSFODF ӳޠͳΜͰ͢ΑͶ APIʹ͍ͭͯ

29. 5SFMMP
    "1*ϦϑΝϨϯε೔ຊޠ൛
    উखʹ࡞੒
    IUUQTPHBUJTNKQUFDITUSFMMPBQJSFGFSFODF APIʹ͍ͭͯ

30. "1*ΛԿॲ͔Βୟ͔͘ APIʹ͍ͭͯ

31. ͙͢࢖͑Δαʔό͕ແ͍ʜ APIʹ͍ͭͯ

32. (PPHMF
    "QQT
    4DSJQU
    ͕ΦεεϝʢҎԼ("4ʣ APIʹ͍ͭͯ

33. ("4ͷϝϦοτ
    w ແྉ
    w ఆظ࣮ߦग़དྷΔʢ༵೔ࢦఆ΋
    w (PPHMFυΩϡϝϯτͱ૬ੑ͕͍͍ APIʹ͍ͭͯ

34. 5SFMMPͱ("4ͰࣗಈԽʂ APIʹ͍ͭͯ

35. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹTrelloͰ΍Γ͍ͨ͜ͱ ̏ɹAPIʹ͍ͭͯ ̐ɹ׆༻ࣄྫ ̑ɹ·ͱΊ

36. ׆༻ࣄྫ (PPHMF
    4QSFBETIFFU͔Β
    5SFMMPʹࣗಈొ࿥͢Δ
    IUUQTPVEBJIBUFOBCMPHDPNFOUSZ

37. ׆༻ࣄྫ ษڧձΛ΍ΔͨΊʹඞཁͳλεΫΛ
    εϓϨουγʔτʹ·ͱΊͨ
    IUUQTPVEBJIBUFOBCMPHDPNFOUSZ

38. ׆༻ࣄྫ .BDLFSFMΛ࢖ͬͯ
    λεΫͷݟ͑ΔԽΛͨ͠࿩
    IUUQTPVEBJIBUFOBCMPHDPNFOUSZ

39. 5SFMMP͓͡͞Μۀ
    w ఆྫλεΫͷνέοτԽ
    w Ԙ௮͚͞ΕͨλεΫͷ࠵ଅ
    w աෛՙͳਓͷλεΫ֬ೝ TrelloͰ΍Γ͍ͨ͜ͱ

40. ׆༻ࣄྫ ࣗಈԽग़དྷΔʂ

41. ׆༻ࣄྫ ࣗ෼ѼͷϝʔϧΛ
    5SFMMPʹొ࿥ͯ͠Χϯόϯӡ༻
    IUUQTPVEBJIBUFOBCMPHDPNFOUSZ

42. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹTrelloͰ΍Γ͍ͨ͜ͱ ̏ɹAPIʹ͍ͭͯ ̐ɹ׆༻ࣄྫ ̑ɹ·ͱΊ

43. ·ͱΊ վળͷίπ

44. ·ͱΊ 1$Ͱ΍Δ࡞ۀ͸֓ͶࣗಈԽग़དྷΔ

45. ·ͱΊ Ұਓͷ࡞ۀΛຖ೔ඵվળ
    

46. ·ͱΊ Ұਓͷ࡞ۀΛຖ೔ඵվળ
    ˣ
    ਓͷνʔϜͳΒຖ೔̍࣌ؒվળʂ

47. ·ͱΊ 5SFMMPͷྑ͞͸
    ΤϯδχΞҎ֎΋Θ͔Γ΍͍͢ॴ

48. ·ͱΊ ࣗಈԽͷίπ
    

49. ·ͱΊ ࣗಈԽͷίπ
    ˣ
    ϝϯςφϯε͸ΈΜͳͰग़དྷΔࣄ

50. ·ͱΊ ໰୊Λద੾ͳαΠζʹ੾Γ෼͚Δ
    

51. ·ͱΊ ໰୊Λద੾ͳαΠζʹ੾Γ෼͚Δ
    ˣ
    ͦ͜ͰπʔϧΛ׆༻͢Δ

52. ·ͱΊ πʔϧ͕໰୊Λ
    ௚઀ղܾ͢ΔΘ͚Ͱ͸ͳ͍

53. ·ͱΊ ຊ࣭ΛݟۃΊΔࣄ͕େࣄ

54. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ