最速のクエリビルダを妄想してみた

Transcript

1. ࠷଎ͷΫΤϦϏϧμΛ ໝ૝ͯ͠Έͨ @mackee_w a.k.a Ϛίϐʔ ΠΧID: mackee_w
2. YAPCԠื͍ͯ͠·͢ • http://yapcasia.org/2015/talk/show/ a668ef3e-080b-11e5-b2b4-79c97d574c3a • Ͳ͏ͯ͠΋PerlͰυϩʔϯΛඈ͹͍ͨ͠ਓͷͨ Ίͷϋʔυ΢ΣΞϋοΫ֓࿦ • ·ͨͷ໊Λୁั͞Εͳ͍ͨΊʹυϩʔϯΛඈ ͹ͨ͢Ίͷ97ͷ͜ͱ
3. GoͷΫΤϦϏϧμ • lann/squirrel import sq “github.com/lann/squirrel” query, args, err := sq.Select(“id”, “name”).From(“user”).Where(sq.Eq{“id”: id}).ToSql() row := db.QueryRow(query, args…)
4. sq.Where(sq.Eq{“id”: id}) ↑͍ͭ͜͸ϦϑϨΫγϣϯ
5. ͦsquirrel͸ΫΤϦϏϧμ • ΫΤϦϏϧμͳͷͰεΩʔϚΛ஌Βͳ͍ • εΩʔϚΛ஌Βͳ͍ͷͰΧϥϜͷܕΛ஌Βͳ ͍ • ͱ͍͏͔interface{}ͳͷͰͳΜͰ΋ಥͬࠐΊΔ • errorͱ͔ಥͬࠐΊΔɺͦͯ͠panicΔ
6. ϦϑϨΫγϣϯͷޭࡑ • ϦϑϨΫγϣϯʹΑΓͱΓ͋͑ͣinterface{}Ͱ ड͚ͯͦͷޙͷ͜ͱ͸ޙͰߟ͑ΔΈ͍ͨͳ͜ ͱ͕ग़དྷΔ • ͦͷ୅ΘΓʹಈ͍͍ͯΔͱ͖ʹpanicΔͷͰਓ ͕͕ؒΜ͹ͬͯpanicΒͳ͍Α͏ʹಥͬࠐΉ΋ ͷΛ؂ࢹ͠ͳ͚Ε͹ͳΒͳ͍
7. ܕͱ͸Կͩͬͨͷ͔ (Go͸ܕϏονݴޠͱ͍͏੠ ͸͜͜Ͱແࢹ͓ͯ͘͠)
8. sqlla - a pre- generated structure query buillder - ͔࣍Β͸ໝ૝Ͱ͢
9. go generate • Go͸1.4͔Βgo generateͱ͍͏࢓૊Έ͕௥Ճ ͞Εͨ • //go:generate hogehoge • ͜ΕΛهड़ͨ͠ιʔε͕ଘࡏ͢Δͱ͜ΖͰgo generateͬͯίϚϯυΛଧͭͱhogehogeͬͯ ͍͏ͷ͕γΣϧͰ࣮ߦ͞ΕΔ
10. ࢖༻ྫ • https://godoc.org/golang.org/x/tools/cmd/ stringer จࣈྻԽग़དྷΔఆ਺Λ࡞ΔͨΊͷ generater • ఆ਺ͷ্ʹίϝϯτͰΞϊςʔγϣϯΛ࡞Δ ͱ fmt.Stringerͱ͍͏interfaceΛ࣮૷ͨ͠type Λఆٛͯ͠จࣈྻԽग़དྷͯศར
11. argen • ੩తղੳϕʔεͷORM • //+ARͬͯstructʹॻ͘ͱ͍Ζ͍Ζ࣮૷ͯ͘͠ ΕΔ(?)
12. genddl • ੿࡞ͷDDLੜ੒ث • //+table: <ςʔϒϧ໊>ͬͯstructʹॻ͍ͯΧ ϥϜ໊ͱ͔ΛλάͰॻ͘ͱDDLΛੜ੒ͯ͘͠ ΕΔ
13. ಓ۩ • go/parser + go/ast • text/template
14. ࠓճໝ૝ͨ͠ͷ͸ • ੩తղੳϕʔεͷΫΤϦϏϧμ import ( “github.com/mackee/sugoiapp/schema/user” ) user.UserId{1}.Name{“name”}.ToSql()
15. த਎ //+table: user type User struct { Id uint64 `db:”id”` Name string `db:”name”` }
16. ͔͜͜Βauto generated type Name struct { Name string Expr sqlla.Expr } func (c Name) ToSql() { return “name “ + c.Expr.ToSql() + “?” }
17. ͋ͱϝιουνΣΠϯͱ͔ ͸͕Μ͹ͬͯࣗಈੜ੒ϫΠϫ Π ྗٕ͡Ό
18. ͱ͍͏ͷΛ1࣌ؒલʹࢥ͍ͭ ͍ͨͷͰɺͦͷ͏࣮ͪ૷͠ͱ ͜(͜Ε͕Φν)