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

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

Transcript

1. DBFlute IntroͰ
 ؾܰʹDBίϝϯτมߋ 2017/11/26 #DBFluteFes @deco
2. Agenda • ࣗݾ঺հ • DBFlute-introͱ͸ • DBίϝϯτʹ͓͚Δ՝୊ • DBFlute-introͰͲ͏ղܾ͢Δ͔ • σϞ • ػೳ௥Ճ༧ఆ • Q&A
3. ࣗݾ঺հ
4. ࣗݾ঺հ • ໊લ : ෌Ӭߊ࢙ @deco • ৬छ : AndroidɺiPhoneΤϯδχΞ
 DBFlute-introίϛολʔ
5. DBFlute-introͱ͸
6. DBFlute-introͱ͸ • Javaͷ࣮ߦ؀ڥ͑͋͞Ε͹ར༻Ͱ͖Δπʔϧ • ΞϓϦͷ֎ଆͰ׆༂͢ΔDBFluteͷػೳΛɺ GUI͚ͩͰ࣮ߦͰ͖Δπʔϧ • ຊ೔όʔδϣϯ0.1.3ΛϦϦʔε͠·ͨ͠ɻ https://github.com/dbflute/dbflute-intro/ releases
7. DBFlute-introͱ͸
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/

9. DBίϝϯτʹ͓͚Δ՝୊
10. ࣭໰ • DBมߋΛߦ͏ػೳ௥ՃΛߦͬͨ͜ͱ͸͋Γ· ͔͢ʁ • DBมߋ࣌ʹίϝϯτ͕ͳͯ͘ࠔͬͨ͜ͱ͸͋ Γ·ͤΜ͔ʁ
11. എܠ • ͳΜͰ͜Μͳ͜ͱ͕ى͖Δͷ͔ʁ • ߟ͑ͯΈ·ͨ͠ɻ(ओ؍)
12. αʔϏεϦϦʔε௚ޙ
13. αʔϏεϦϦʔε௚ޙ • ςʔϒϧ਺20ະຬ • ։ൃऀ1~2໊ • ͦΕͧΕςʔϒϧͷҙຯΛ೺Ѳ͍ͯ͠Δ
14. ϦϦʔεޙ1೥ ඇެ։
15. αʔϏεޙ1೥ • ςʔϒϧ਺50ະຬ • ։ൃऀ1~10໊ • ଞͷ։ൃऀ͕࡞ͬͨςʔϒϧ͕೺ѲͰ͖ͳ͘ͳͬ ͯ͘Δ • ։ൃऀ͕ଟ͘ͳ͍ͷͰɺฉ͚͹୭͔͕஌͍ͬͯ Δ
16. ϦϦʔεޙ10೥ޙ ඇެ։
17. αʔϏεޙ10೥ • ςʔϒϧ਺300Ҏ্ • ։ൃऀ30໊~ • Α͘Θ͔Βͳ͍ɺࣅͨΑ͏ͳςʔϒϧଟ਺ • ࡞ͬͨਓ΋ࣾ಺ʹ͍ͳ͍͜ͱ͕ଟ͍ • ༗ࣝऀ΋෼ࢄ͍ͯͯ͠୭ʹฉ͚͹͍͍͔Θ͔Βͳ͍
18. ՝୊ • ίϝϯτ͕ͳ͍͔ΒɺαʔϏεಛ༗ͷ஍ཕΛ ౿Ήएख͕ଓग़ɻ • ίϝϯτΛॻ͜͏ͱͯ͠΋ɺERMϑΝΠϧΛ มߋ͢ΔͨΊ͕͔͔࣌ؒΓ΍Γ͕ͨΒͳ͍ਓ ͕ଟ͍ɻʢDBFluteͷ৔߹ʣ
19. DBFlute-introͰͲ͏ղܾ͢Δ͔
20. DBFlute-introͰͲ͏ղܾ͢Δ͔ • DBͷ৘ใΛݟΔͷ͸ERਤ͔schema.html͕΄ ͱΜͲɻ
 -> schema.html্ͷDBίϝϯτΛ௚઀มߋͰ ͖ΔΑ͏ʹ͠Α͏ʂʂ
21. DBFlute-introͰͲ͏ղܾ͢Δ͔
22. Ͳ͏΍࣮ͬͯݱ͢Δͷ͔
23. DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
24. DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
25. DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
26. DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
27. DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
28. DBίϝϯτͷ൓өॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap ϑΝΠϧΛ։͍ͨλΠϛϯάͰintroʹϦΫΤετ
29. DBίϝϯτͷ൓өॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap dfmapϑΝΠϧΛಡΈࠐΉ
30. DBίϝϯτͷ൓өॲཧͷྲྀΕ schema.html DBFlute-intro dfmap Ϛʔδ݁ՌΛJSONʹม׵ JSON݁Ռ͔Βschema.htmlΛDOMૢ࡞
31. ࢖͍ํ • DBFlute-introΛμ΢ϯϩʔυ • ىಈ • schema.html͔ΒίϝϯτΛฤू
32. ࢖͍ํ • ֤։ൃऀ͕ࣗ෼ͷ࡞ۀϒϥϯνͰίϝϯτฤ ू • developϒϥϯνʹϚʔδ͞ΕΔɻ • ࠶౓࡞ۀϒϥϯνΛ੾Δͱଞͷ։ൃऀͷίϝ ϯτΛ֬ೝ͢Δ͜ͱ͕Ͱ͖Δɻ
33. σϞ
34. ػೳͷઆ໌ • ࠷৽ͷίϝϯτΛͲͷΑ͏ʹ൑ఆ͍ͯ͠Δͷ͔ • ίϯϑϦΫτͷ൑ఆ͸ͲͷΑ͏ʹ͍ͯ͠Δͷ͔
35. ػೳͷઆ໌ • ίϝϯτ͝ͱʹϋογϡ஋ɺҰͭલͷϋογϡ ஋Λ࣋ͨͤΔ
36. ࠷৽ͷίϝϯτͷ൑ఆํ๏ code: hoge previous: null code: fuga previous: hoge code: foo previous: fuga code: bar previous: fuga
37. ࠷৽ͷίϝϯτͷ൑ఆํ๏ code: hoge previous: null code: fuga previous: hoge code: foo previous: fuga code: bar previous: fuga
38. ίϯϑϦΫτΛHTML্ʹ൓ө
39. ίϯϑϦΫτͷղফ code: hoge previous: null code: fuga previous: hoge code: foo previous: fuga code: bar previous: fuga code: end previous: foo, bar
40. ػೳ௥Ճ༧ఆ
41. ػೳ௥Ճ༧ఆ • ݱঢ়ColumnίϝϯτͷΈରԠ͍ͯ͠ΔͷͰ Tableίϝϯτ΋ରԠͰ͖ΔΑ͏ʹ͢Δ • IntroΛ࢖͍ͬͯͳ͍ਓͰ΋ίϝϯτΛදࣔͰ ͖ΔΑ͏ʹ͢Δ • ERFluteͱͷ࿈ܞͯ͠ERMϑΝΠϧʹࣗಈ൓ө Ͱ͖ΔΑ͏ʹ͢Δ
42. Q&A
43. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠