Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

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

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

Akifumi Tominaga

November 26, 2017
Tweet

More Decks by Akifumi Tominaga

Other Decks in Programming

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