Fukuoka.go #21 Tomohisa Oda / Mar 11, 2025 ίʔυδΣωϨʔλʔͰ ޮ཰తͳ։ൃΛ͢Δ

Fukuoka.go #21 @linyows Blog: tomohisaoda.com Affiliation: Sakura internet, Inc. ɹɹɹɹɹɹCognano, Inc.

Fukuoka.go #21 ࠓճ͸ϙΤϜ

Fukuoka.go #21 ๏ PHFO͸0QFO"1*WΛδΣωϨʔτ͢Δπʔϧ ๏ +40/ͷΤϯίʔυʗσίʔυʹϦϑϨΫγϣϯͰͳ͘௚઀όοϑΝ͔ ΒܕղੳΛ͢ΔͨΊϝϞϦΞϩέʔγϣϯ͕গͳ͍͠଎͍ ๏ 0QFO"1*4DIFNB͔Βͷ7BMJEBUJPO͕Ͱ͖Δ ๏ ॊೈͳܕͷαϙʔτ͕͋Δ ๏ 0QFO5FMFNFUSZͷαϙʔτ͕͋Δ 0QFO"1*ϓϩδΣΫτͰPHFOΛ࢖ͬͨ

Fukuoka.go #21 0QFO"1*WΛδΣωϨʔτ͢Δπʔϧ

Fukuoka.go #21 ๏ PQFOBQJHFOFSBUPSIUUQTHJUIVCDPN0QFO"1*5PPMTPQFOBQJHFOFSBUPS ๏ PBQJDPEFHFOIUUQTHJUIVCDPNPBQJDPEFHFOPBQJDPEFHFO ๏ PHFOIUUQTHJUIVCDPNPHFOHPPHFO ๏ HPTXBHHFSIUUQTHJUIVCDPNHPTXBHHFSHPTXBHHFS (PͰ0QFO"1*δΣωϨʔλʔͱ͍͑͹

Fukuoka.go #21 ๏ (JOIUUQTHJUIVCDPNHJOHPOJDHJO ๏ &DIPIUUQTHJUIVCDPNMBCTUBDLFDIP ๏ $IJIUUQTHJUIVCDPNHPDIJDIJ ๏ (PBIUUQTHJUIVCDPNHPBEFTJHOHPB (PͰ"QQMJDBUJPO'SBNFXPSLͱ͍͑͹

Fukuoka.go #21 ๏ (P͸ݴޠͱͯ͠ޙํޓ׵ੑΛ໿ଋ͞Ε͍ͯΔʢࠓ͸ʣ ๏ ίϛϡχςΟύοέʔδΛݮΒͯ͠ͳΔ΂͘ඪ४ϥΠϒϥϦʹد͓͖͍ͤͯͨ ๏ όʔδϣϯ௥ैָ͕͸ਆ ๏ ͳͷͰ'SBNFXPSL͸ബ͍ํ͕޷Έɺ͋Δ͍͸ෆཁ ๏ ඞཁʹͳ͔ͬͯΒػೳΛ௥ՃͰ͖Δ΄͏͕ΞλοΫαʔϑΣε΋খ͘͞Ͱ͖Δ ͱ৴͍ͯ͡Δ ਖ਼௚ͲΕͰ΋͍͍ʜ͕

Fukuoka.go #21 ๏ HPSNͳͲ"DUJWF3FDPSEʹӨڹΛड͚͍ͯΔ03.͸ۤख ๏ ศརͳ൓໘ɺ৭ʑӅṭ͞Ε͍ͯͯೝ஌ෛՙ͕ߴ͍ͱײ͡Δ ๏ όʔδϣϯΞοϓ࣌΍ύϑΥʔϚϯενϡʔχϯάͳͲ ๏ ௚ʹ2VFSZΛఆٛ͠δΣωϨʔτͯ͠࢖͏TRMD͕࠷ߴ Ͳ͔ͬͪͱ͍͏ͱ3%#ͷ.BQQJOH͕໰୊

Fukuoka.go #21 ๏ 4DIFNB͔Β4FSWFS)BOEMFSͷ*OUFSGBDFΛ(FOFSBUF ๏ *OUFSGBDFΛຬ࣮ͨ͢૷Λॻ͘ ๏ 2VFSZ͔Β4USVDU΍.FUIPEΛ(FOFSBUF ๏ ࣮૷͔Βݺͼग़͚ͩ͢ ๏ جຊతʹ͸BQJύοέʔδʹ࣮૷Λ૿΍͍ͯ͘͠ʢ΋ͪΖΜґଘ͠ͳ͍ ΋ͷ͸ผͷύοέʔδʹ੾Γग़͢ʣ PHFOͱTRMDΛϓϩδΣΫτͰ࢖༻͢Δ

Fukuoka.go #21 ͱ͍͏͜ͱͰɺPHFOͱTRMDΛ࢖༻

Fukuoka.go #21 ߏ੒ྫ

Fukuoka.go #21 HFOHP package example //go:generate go run github.com/ogen-go/ogen/cmd/ogen --target oas/ oasgen --package oasgen --clean oas/petstore.yml //go:generate go run github.com/sqlc-dev/sqlc/cmd/sqlc generate -f db/sqlc.yml HFOFSBUFDPNNBOEΛॻ͍ͯHPHFOFSBUFΛ࣮ߦ

Fukuoka.go #21 7BMJEBUJPOͷྫ

Fukuoka.go #21 ॊೈͳܕαϙʔτ 0QUJPOBM5ZQFT

Fukuoka.go #21 4DIFNB͔Β࡞ΒΕ ΔΠϯλʔϑΣʔε Λຬͨ͢Α͏ʹ࣮૷

Fukuoka.go #21 TRMDͷRVFSZ΍ 0QFO5FMFNFUSZͷ USBDFS1SPWJEFSΛ IBOEMFSʹηοτ

Fukuoka.go #21 0QFO5FMFNFUSZͱͷ౷߹

Fukuoka.go #21 ๏ ࢀߟ࣮૷ΛHJUIVCʹஔ͍ͨIUUQTHJUIVCDPNMJOZPXT PHFOFYBNQMF ๏ ੹຿෼ׂ͕໌֬ʹͳΓ࣮૷͕গͳ͘ͳͬͨؾ͕͢Δ ๏ 03.ʹৄ͘͠ͳͯ͘΋%#ʹରͯ͠ԿΛ΍͍ͬͯΔ͔໌֬ʹͳͬ ͨ ๏ ͕࣌ؒ͋Ε͹%FNPIUUQTHJUIVCDPNPHFOHPFYBNQMF δΣωϨʔλʔଟ༻ͷޮՌ

Fukuoka.go #21 ๏ EPDLFSDPNQPTFVQͰ0QFO"1*αʔόͱΫϥΠΞϯτͱ 0CTFSWBCJMJUZ؀ڥ͕ىಈ͢Δ ๏ 0CTFSWBCJMJUZ؀ڥ͸$MJDLIPVTFͱ0UFMECͱ(SBGBOB ๏ τϨʔεɺϝτϦΫεɺϩάͷೖग़ྗ͕Ͱ͖Δ0UFMEC͕ศར ๏ 0UFMEC͸$MJDLIPVTFͷϥούʔ%# ๏ ࢒೦ͳ͜ͱʹຊ൪Ͱ͸·ͩ࢖͑ͳ͍΍ͭ PHFOHPFYBNQMF

Fukuoka.go #21 ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ ͘͞ΒΠϯλʔωοτͰ͸ 𝝣 (0Λ࢖ͬͯΫϥ΢υͷίϯϙʔωϯ τΛ։ൃͯ͘͠ΕΔ஥ؒΛ୳͍ͯ͠·͢ʂ ؾܰʹ͓੠͔͚͍ͩ͘͞㷉⊙౪⚆㷊