Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
DBFlute Introで 気軽にDBコメント変更
Search
Akifumi Tominaga
November 26, 2017
Programming
0
88
DBFlute Introで 気軽にDBコメント変更
DBFlute IntroでDatabaseのスキーマをコメントをつけて管理しようという話
Akifumi Tominaga
November 26, 2017
Tweet
Share
More Decks by Akifumi Tominaga
See All by Akifumi Tominaga
依存関係を静的解析しよう
decoch
2
340
CircleCIを使って 「完全サーバーレス運用」を 実現した話
decoch
2
410
GOで作るCLIツール
decoch
0
300
DBFlute-intro
decoch
0
48
Other Decks in Programming
See All in Programming
単体テストを書かない技術 #phpcon_odawara
o0h
PRO
27
8.5k
Behind VS Code Extensions for JavaScript / TypeScript Linnting and Formatting
unvalley
6
1.2k
PHPの次期バージョンはこの時期どうなっているのか - Internalsの開発体制について - PHPカンファレンス小田原
youkidearitai
PRO
1
220
見た目から始める生産性向上
ikumatadokoro
10
1.4k
CREってこういうこと? 体験入社 - 提案資料 - / what-is-cre-trial-employment
shinden
1
520
Java 22 Overview
kishida
1
190
障害対応を起点としたもっといい開発と運用のサイクル作りのためにできること / Hatena Enginner Seminar #29
polamjag
0
380
Next.js App Router
quramy
12
1.8k
"config" ってなんだ? / What is "config"?
okashoi
0
320
CDKコントリビュートの最初の壁を越えよう! -簡単issueの見つけ方-
badmintoncryer
3
210
Git Rebase
bkuhlmann
11
1.6k
CA.swift19 恋するAIアプリ開発の裏側
oskmr
0
380
Featured
See All Featured
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
7
3.4k
Done Done
chrislema
178
15k
Building Better People: How to give real-time feedback that sticks.
wjessup
356
18k
Designing Experiences People Love
moore
136
23k
Building an army of robots
kneath
300
41k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
275
13k
The World Runs on Bad Software
bkeepers
PRO
61
6.7k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
323
20k
Product Roadmaps are Hard
iamctodd
45
9.7k
Optimizing for Happiness
mojombo
370
69k
Code Reviewing Like a Champion
maltzj
515
39k
From Idea to $5000 a Month in 5 Months
shpigford
378
45k
Transcript
DBFlute IntroͰ ؾܰʹDBίϝϯτมߋ 2017/11/26 #DBFluteFes @deco
Agenda • ࣗݾհ • DBFlute-introͱ • DBίϝϯτʹ͓͚Δ՝ • DBFlute-introͰͲ͏ղܾ͢Δ͔ •
σϞ • ػೳՃ༧ఆ • Q&A
ࣗݾհ
ࣗݾհ • ໊લ : Ӭߊ࢙ @deco • ৬छ : AndroidɺiPhoneΤϯδχΞ
DBFlute-introίϛολʔ
DBFlute-introͱ
DBFlute-introͱ • Javaͷ࣮ߦڥ͑͋͞Εར༻Ͱ͖Δπʔϧ • ΞϓϦͷ֎ଆͰ׆༂͢ΔDBFluteͷػೳΛɺ GUI͚ͩͰ࣮ߦͰ͖Δπʔϧ • ຊόʔδϣϯ0.1.3ΛϦϦʔε͠·ͨ͠ɻ https://github.com/dbflute/dbflute-intro/ releases
DBFlute-introͱ
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/
DBίϝϯτʹ͓͚Δ՝
࣭ • DBมߋΛߦ͏ػೳՃΛߦͬͨ͜ͱ͋Γ· ͔͢ʁ • DBมߋ࣌ʹίϝϯτ͕ͳͯ͘ࠔͬͨ͜ͱ͋ Γ·ͤΜ͔ʁ
എܠ • ͳΜͰ͜Μͳ͜ͱ͕ى͖Δͷ͔ʁ • ߟ͑ͯΈ·ͨ͠ɻ(ओ؍)
αʔϏεϦϦʔεޙ
αʔϏεϦϦʔεޙ • ςʔϒϧ20ະຬ • ։ൃऀ1~2໊ • ͦΕͧΕςʔϒϧͷҙຯΛѲ͍ͯ͠Δ
ϦϦʔεޙ1 ඇެ։
αʔϏεޙ1 • ςʔϒϧ50ະຬ • ։ൃऀ1~10໊ • ଞͷ։ൃऀ͕࡞ͬͨςʔϒϧ͕ѲͰ͖ͳ͘ͳͬ ͯ͘Δ • ։ൃऀ͕ଟ͘ͳ͍ͷͰɺฉ͚୭͔͕͍ͬͯ
Δ
ϦϦʔεޙ10ޙ ඇެ։
αʔϏεޙ10 • ςʔϒϧ300Ҏ্ • ։ൃऀ30໊~ • Α͘Θ͔Βͳ͍ɺࣅͨΑ͏ͳςʔϒϧଟ • ࡞ͬͨਓࣾʹ͍ͳ͍͜ͱ͕ଟ͍ •
༗ࣝऀࢄ͍ͯͯ͠୭ʹฉ͚͍͍͔Θ͔Βͳ͍
՝ • ίϝϯτ͕ͳ͍͔ΒɺαʔϏεಛ༗ͷཕΛ ౿Ήएख͕ଓग़ɻ • ίϝϯτΛॻ͜͏ͱͯ͠ɺERMϑΝΠϧΛ มߋ͢ΔͨΊ͕͔͔࣌ؒΓΓ͕ͨΒͳ͍ਓ ͕ଟ͍ɻʢDBFluteͷ߹ʣ
DBFlute-introͰͲ͏ղܾ͢Δ͔
DBFlute-introͰͲ͏ղܾ͢Δ͔ • DBͷใΛݟΔͷERਤ͔schema.html͕΄ ͱΜͲɻ -> schema.html্ͷDBίϝϯτΛมߋͰ ͖ΔΑ͏ʹ͠Α͏ʂʂ
DBFlute-introͰͲ͏ղܾ͢Δ͔
Ͳ͏࣮ͬͯݱ͢Δͷ͔
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷөॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap ϑΝΠϧΛ։͍ͨλΠϛϯάͰintroʹϦΫΤετ
DBίϝϯτͷөॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap dfmapϑΝΠϧΛಡΈࠐΉ
DBίϝϯτͷөॲཧͷྲྀΕ schema.html DBFlute-intro dfmap Ϛʔδ݁ՌΛJSONʹม JSON݁Ռ͔Βschema.htmlΛDOMૢ࡞
͍ํ • DBFlute-introΛμϯϩʔυ • ىಈ • schema.html͔ΒίϝϯτΛฤू
͍ํ • ֤։ൃऀ͕ࣗͷ࡞ۀϒϥϯνͰίϝϯτฤ ू • developϒϥϯνʹϚʔδ͞ΕΔɻ • ࠶࡞ۀϒϥϯνΛΔͱଞͷ։ൃऀͷίϝ ϯτΛ֬ೝ͢Δ͜ͱ͕Ͱ͖Δɻ
σϞ
ػೳͷઆ໌ • ࠷৽ͷίϝϯτΛͲͷΑ͏ʹఆ͍ͯ͠Δͷ͔ • ίϯϑϦΫτͷఆͲͷΑ͏ʹ͍ͯ͠Δͷ͔
ػೳͷઆ໌ • ίϝϯτ͝ͱʹϋογϡɺҰͭલͷϋογϡ Λ࣋ͨͤΔ
࠷৽ͷίϝϯτͷఆํ๏ code: hoge previous: null code: fuga previous: hoge code:
foo previous: fuga code: bar previous: fuga
࠷৽ͷίϝϯτͷఆํ๏ code: hoge previous: null code: fuga previous: hoge code:
foo previous: fuga code: bar previous: fuga
ίϯϑϦΫτΛHTML্ʹө
ίϯϑϦΫτͷղফ code: hoge previous: null code: fuga previous: hoge code:
foo previous: fuga code: bar previous: fuga code: end previous: foo, bar
ػೳՃ༧ఆ
ػೳՃ༧ఆ • ݱঢ়ColumnίϝϯτͷΈରԠ͍ͯ͠ΔͷͰ TableίϝϯτରԠͰ͖ΔΑ͏ʹ͢Δ • IntroΛ͍ͬͯͳ͍ਓͰίϝϯτΛදࣔͰ ͖ΔΑ͏ʹ͢Δ • ERFluteͱͷ࿈ܞͯ͠ERMϑΝΠϧʹࣗಈө Ͱ͖ΔΑ͏ʹ͢Δ
Q&A
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠