DBFlute Introで 気軽にDBコメント変更

DBFlute IntroでDatabaseのスキーマをコメントをつけて管理しようという話

Transcript

1. DBFlute IntroͰ

   ؾܰʹDBίϝϯτมߋ
   2017/11/26 #DBFluteFes @deco
   

   View Slide

2. Agenda
   • ࣗݾ঺հ
   • DBFlute-introͱ͸
   • DBίϝϯτʹ͓͚Δ՝୊
   • DBFlute-introͰͲ͏ղܾ͢Δ͔
   • σϞ
   • ػೳ௥Ճ༧ఆ
   • Q&A
   

   View Slide

3. ࣗݾ঺հ
   

   View Slide

4. ࣗݾ঺հ
   • ໊લ : ෌Ӭߊ࢙ @deco
   • ৬छ : AndroidɺiPhoneΤϯδχΞ

   DBFlute-introίϛολʔ
   

   View Slide

5. DBFlute-introͱ͸
   

   View Slide

6. DBFlute-introͱ͸
   • Javaͷ࣮ߦ؀ڥ͑͋͞Ε͹ར༻Ͱ͖Δπʔϧ
   • ΞϓϦͷ֎ଆͰ׆༂͢ΔDBFluteͷػೳΛɺ
   GUI͚ͩͰ࣮ߦͰ͖Δπʔϧ
   • ຊ೔όʔδϣϯ0.1.3ΛϦϦʔε͠·ͨ͠ɻ
   https://github.com/dbflute/dbflute-intro/
   releases
   

   View Slide

7. DBFlute-introͱ͸
   

   View Slide

8. DBFlute-introͱ͸
   • Github

   https://github.com/dbflute/dbflute-intro
   • ֓ཁ

   http://dbflute.seasar.org/ja/manual/function/helper/intro/
   index.html

   

   https://www.slideshare.net/nakamu0718/dbflute-
   intro-69599954?ref=https://connpass.com/event/43457/
   presentation/

   

   View Slide

9. DBίϝϯτʹ͓͚Δ՝୊
   

   View Slide

10. ࣭໰
    • DBมߋΛߦ͏ػೳ௥ՃΛߦͬͨ͜ͱ͸͋Γ·
    ͔͢ʁ
    • DBมߋ࣌ʹίϝϯτ͕ͳͯ͘ࠔͬͨ͜ͱ͸͋
    Γ·ͤΜ͔ʁ
    

    View Slide

11. എܠ
    • ͳΜͰ͜Μͳ͜ͱ͕ى͖Δͷ͔ʁ
    • ߟ͑ͯΈ·ͨ͠ɻ(ओ؍)
    

    View Slide

12. αʔϏεϦϦʔε௚ޙ
    

    View Slide

13. αʔϏεϦϦʔε௚ޙ
    • ςʔϒϧ਺20ະຬ
    • ։ൃऀ1~2໊
    • ͦΕͧΕςʔϒϧͷҙຯΛ೺Ѳ͍ͯ͠Δ
    

    View Slide

14. ϦϦʔεޙ1೥
    ඇެ։
    

    View Slide

15. αʔϏεޙ1೥
    • ςʔϒϧ਺50ະຬ
    • ։ൃऀ1~10໊
    • ଞͷ։ൃऀ͕࡞ͬͨςʔϒϧ͕೺ѲͰ͖ͳ͘ͳͬ
    ͯ͘Δ
    • ։ൃऀ͕ଟ͘ͳ͍ͷͰɺฉ͚͹୭͔͕஌͍ͬͯ
    Δ
    

    View Slide

16. ϦϦʔεޙ10೥ޙ
    ඇެ։
    

    View Slide

17. αʔϏεޙ10೥
    • ςʔϒϧ਺300Ҏ্
    • ։ൃऀ30໊~
    • Α͘Θ͔Βͳ͍ɺࣅͨΑ͏ͳςʔϒϧଟ਺
    • ࡞ͬͨਓ΋ࣾ಺ʹ͍ͳ͍͜ͱ͕ଟ͍
    • ༗ࣝऀ΋෼ࢄ͍ͯͯ͠୭ʹฉ͚͹͍͍͔Θ͔Βͳ͍
    

    View Slide

18. ՝୊
    • ίϝϯτ͕ͳ͍͔ΒɺαʔϏεಛ༗ͷ஍ཕΛ
    ౿Ήएख͕ଓग़ɻ
    • ίϝϯτΛॻ͜͏ͱͯ͠΋ɺERMϑΝΠϧΛ
    มߋ͢ΔͨΊ͕͔͔࣌ؒΓ΍Γ͕ͨΒͳ͍ਓ
    ͕ଟ͍ɻʢDBFluteͷ৔߹ʣ
    

    View Slide

19. DBFlute-introͰͲ͏ղܾ͢Δ͔
    

    View Slide

20. DBFlute-introͰͲ͏ղܾ͢Δ͔
    • DBͷ৘ใΛݟΔͷ͸ERਤ͔schema.html͕΄
    ͱΜͲɻ

    -> schema.html্ͷDBίϝϯτΛ௚઀มߋͰ
    ͖ΔΑ͏ʹ͠Α͏ʂʂ
    

    View Slide

21. DBFlute-introͰͲ͏ղܾ͢Δ͔
    

    View Slide

22. Ͳ͏΍࣮ͬͯݱ͢Δͷ͔
    

    View Slide

23. DBίϝϯτͷอଘॲཧͷྲྀΕ
    scheme.html DBFlute-intro dfmap
    

    View Slide

24. DBίϝϯτͷอଘॲཧͷྲྀΕ
    scheme.html DBFlute-intro dfmap
    

    View Slide

25. DBίϝϯτͷอଘॲཧͷྲྀΕ
    scheme.html DBFlute-intro dfmap
    

    View Slide

26. DBίϝϯτͷอଘॲཧͷྲྀΕ
    scheme.html DBFlute-intro dfmap
    

    View Slide

27. DBίϝϯτͷอଘॲཧͷྲྀΕ
    scheme.html DBFlute-intro dfmap
    

    View Slide

28. DBίϝϯτͷ൓өॲཧͷྲྀΕ
    scheme.html DBFlute-intro dfmap
    ϑΝΠϧΛ։͍ͨλΠϛϯάͰintroʹϦΫΤετ
    

    View Slide

29. DBίϝϯτͷ൓өॲཧͷྲྀΕ
    scheme.html DBFlute-intro dfmap
    dfmapϑΝΠϧΛಡΈࠐΉ
    

    View Slide

30. DBίϝϯτͷ൓өॲཧͷྲྀΕ
    schema.html DBFlute-intro dfmap
    Ϛʔδ݁ՌΛJSONʹม׵
    JSON݁Ռ͔Βschema.htmlΛDOMૢ࡞
    

    View Slide

31. ࢖͍ํ
    • DBFlute-introΛμ΢ϯϩʔυ
    • ىಈ
    • schema.html͔ΒίϝϯτΛฤू
    

    View Slide

32. ࢖͍ํ
    • ֤։ൃऀ͕ࣗ෼ͷ࡞ۀϒϥϯνͰίϝϯτฤ
    ू
    • developϒϥϯνʹϚʔδ͞ΕΔɻ
    • ࠶౓࡞ۀϒϥϯνΛ੾Δͱଞͷ։ൃऀͷίϝ
    ϯτΛ֬ೝ͢Δ͜ͱ͕Ͱ͖Δɻ
    

    View Slide

33. σϞ
    

    View Slide

34. ػೳͷઆ໌
    • ࠷৽ͷίϝϯτΛͲͷΑ͏ʹ൑ఆ͍ͯ͠Δͷ͔
    • ίϯϑϦΫτͷ൑ఆ͸ͲͷΑ͏ʹ͍ͯ͠Δͷ͔
    

    View Slide

35. ػೳͷઆ໌
    • ίϝϯτ͝ͱʹϋογϡ஋ɺҰͭલͷϋογϡ
    ஋Λ࣋ͨͤΔ
    

    View Slide

36. ࠷৽ͷίϝϯτͷ൑ఆํ๏
    code: hoge
    previous: null
    code: fuga
    previous: hoge
    code: foo
    previous: fuga
    code: bar
    previous: fuga
    

    View Slide

37. ࠷৽ͷίϝϯτͷ൑ఆํ๏
    code: hoge
    previous: null
    code: fuga
    previous: hoge
    code: foo
    previous: fuga
    code: bar
    previous: fuga
    

    View Slide

38. ίϯϑϦΫτΛHTML্ʹ൓ө
    

    View Slide

39. ίϯϑϦΫτͷղফ
    code: hoge
    previous: null
    code: fuga
    previous: hoge
    code: foo
    previous: fuga
    code: bar
    previous: fuga
    code: end
    previous: foo, bar
    

    View Slide

40. ػೳ௥Ճ༧ఆ
    

    View Slide

41. ػೳ௥Ճ༧ఆ
    • ݱঢ়ColumnίϝϯτͷΈରԠ͍ͯ͠ΔͷͰ
    Tableίϝϯτ΋ରԠͰ͖ΔΑ͏ʹ͢Δ
    • IntroΛ࢖͍ͬͯͳ͍ਓͰ΋ίϝϯτΛදࣔͰ
    ͖ΔΑ͏ʹ͢Δ
    • ERFluteͱͷ࿈ܞͯ͠ERMϑΝΠϧʹࣗಈ൓ө
    Ͱ͖ΔΑ͏ʹ͢Δ
    

    View Slide

42. Q&A
    

    View Slide

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

    View Slide