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

第25回 Tokyo Atlassian ユーザーグループの登壇資料です
https://augj.connpass.com/event/71353/

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. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ