Hasuraを活用するためのTips集

Transcript

1. HasuraΛ׆༻͢ΔͨΊͷTipsू 2022/08/30 ։ൃ2෦ ૣ੉࿨ً
2. ࣗݾ঺հ • ૣ੉࿨ً • ग़඼؅ཧSaa S ◦ ϓϩδΣΫτϦʔμʔ ◦ ϑϧελοΫΤϯδχΞ • ࠷ۙͷϚΠϒʔϜ ◦ ݸਓ։ൃ࠶։͠·ͨ͠ ▪ Cloud Run(gqlgen) + Firestore(Datastore mode ) ▪ Next.js + Rela y ◦ Ҿͬӽ͠४උத
3. ΞδΣϯμ • Hasuraͱ͸ • HasuraΛ׆༻͢ΔͨΊͷTipsू ◦ Upsertͷ׆༻ ◦ τϥϯβΫγϣϯ ◦ ϦϨʔγϣϯΛؚΜͩMutatio n ◦ σΟϨΫςΟϒʹΑΔ੍ޚ • ͓ΘΓʹ
4. ΞδΣϯμ • Hasuraͱ͸ • HasuraΛ׆༻͢ΔͨΊͷTipsू ◦ Upsertͷ׆༻ ◦ τϥϯβΫγϣϯ ◦ ϦϨʔγϣϯΛؚΜͩMutatio n ◦ σΟϨΫςΟϒʹΑΔ੍ޚ • ͓ΘΓʹ
5. Hasuraͱ͸ • DBͷεΩʔϚ͔ΒGraphQLαʔόʔΛੜ੒Ͱ͖ΔΦʔϓϯιʔε • DB͑͋͞Ε͹αʔόʔཱ͕ͯΒΕΔͷͰ࣮૷ίετ͕֨ஈʹݮΔ
6. ΧελϜϩδοΫʹ͍ͭͯ • ΧελϜϩδοΫΛ௥Ճ͢Δํ๏ΛHasura͸ఏڙ͍ͯ͠Δ ◦ Actio n ◦ Remote Schem a • ҙ֎ͱΧελϜϩδοΫΛ࣮૷͍ͨ͠৔໘͸ଟ͍ • ࣮ͨͩ͠૷ίετɺϝϯςφϯείετ͕૿Ճ͢Δ
7. HasuraͷػೳΛ׆༻͢Δ͜ͱͰ
 ΧελϜϩδοΫͷ࣮૷ΛݮΒ͢͜ͱ͕Ͱ͖Δ
8. ΞδΣϯμ • Hasuraͱ͸ • HasuraΛ׆༻͢ΔͨΊͷTipsू ◦ Upsertͷ׆༻ ◦ τϥϯβΫγϣϯ ◦ ϦϨʔγϣϯΛؚΜͩMutatio n ◦ σΟϨΫςΟϒʹΑΔ੍ޚ • ͓ΘΓʹ
9. Upsertͷ׆༻ on_conflictΛࢦఆ͢Δ͜ͱͰUpsertͰ࣮ߦ
10. Upsert࢖༻࣌ͷ஫ҙ఺ • σʔλ͕ଘࡏ͢Δ͔Θ͔Βͳ͍৔߹ͷΈ࢖༻͢Δ ◦ ϕʔεͷMutation͸InsertͳͷͰશͯͷඞਢύϥϝʔλΛ౉͢ඞཁ͕͋Δ ◦ Updateͷ୅༻ͱͯ͠͸࢖͑ͳ͍ • σʔλ͕ଘࡏ͢Δ͜ͱ͕Θ͔͍ͬͯΔ৔߹͸UpdateΛ࢖༻͢Δ
11. ΞδΣϯμ • Hasuraͱ͸ • HasuraΛ׆༻͢ΔͨΊͷTipsू ◦ Upsertͷ׆༻ ◦ τϥϯβΫγϣϯ ◦ ϦϨʔγϣϯΛؚΜͩMutatio n ◦ σΟϨΫςΟϒʹΑΔ੍ޚ • ͓ΘΓʹ
12. τϥϯβΫγϣϯ Hasura͸1ͭͷϦΫΤετʹෳ਺ͷMutationؚ͕·Ε͍ͯΔ৔߹ɺ
 ֤Mutation͸1ͭτϥϯβΫγϣϯͰॱ൪ʹ࣮ߦ͞ΕΔ ͲΕ͔ҰͭͰ΋ࣦഊͨ͠৔߹શͯͷMutation͕ϩʔϧόοΫ͞ΕΔ
13. τϥϯβΫγϣϯͷྫ deletePost͕ࣦഊͯ͠SampleMutationશମ͕ϩʔϧόοΫ͞ΕΔ ϩʔϧόοΫ͞ΕΔͷͰtaggings͸࡟আ͞Ε͍ͯͳ͍
14. ΞδΣϯμ • Hasuraͱ͸ • HasuraΛ׆༻͢ΔͨΊͷTipsू ◦ Upsertͷ׆༻ ◦ τϥϯβΫγϣϯ ◦ ϦϨʔγϣϯΛؚΜͩMutatio n ◦ σΟϨΫςΟϒʹΑΔ੍ޚ • ͓ΘΓʹ
15. ϦϨʔγϣϯΛؚΜͩMutation Mutationͷ૊Έཱͯ࣍ୈͰ༷ʑͳϦϨʔγϣϯΛؚΜͩσʔλͷ࡞੒͕Մೳ • 1: 1 • 1: N • N:N
16. 1:1ͷϦϨʔγϣϯ profileͱͦΕʹඥͮ͘userΛ࡞੒ userͱͦΕʹඥͮ͘profileΛ࡞੒͠Α͏ͱ͢ΔͱΤϥʔ
17. ΦϒδΣΫτͷ࡞੒ॱং σϑΥϧτͰ͸1:1ͷϦϨʔγϣϯ͸Լهͷॱ൪ͰΦϒδΣΫτ͕࡞੒͞ΕΔ 1. ࢠΦϒδΣΫτΛ࡞੒ͯ͠idΛऔಘ 2. FKΧϥϜʹ 1 Ͱऔಘͨ͠idΛઃఆͯ͠਌ΦϒδΣΫτΛ࡞੒ ※ ϦϨʔγϣϯ࡞੒࣌ͷinsertion_orderͷઃఆͰॱ൪͸มߋՄೳ
18. 1:NͷϦϨʔγϣϯ ౤ߘͱͦΕʹඥ͍͍ͮ͘ͶΛ࡞੒
19. ΦϒδΣΫτͷ࡞੒ॱং 1:NͷϦϨʔγϣϯ͸Լهͷॱ൪ͰΦϒδΣΫτ͕࡞੒͞ΕΔ 1. ਌ΦϒδΣΫτΛ࡞੒ͯ͠idΛऔಘ 2. FKΧϥϜʹ 1 Ͱऔಘͨ͠idΛઃఆͯ͠ࢠΦϒδΣΫτΛ࡞੒
20. N:NͷϦϨʔγϣϯ ౤ߘͱͦΕʹඥͮ͘λάΛ࡞੒
21. ߴ౓ͳN:NͷϦϨʔγϣϯ ౤ߘͱͦΕʹඥͮ͘λάΛ࡞੒ɺλάͷ࡞੒͸Upsert λά͕͢Ͱʹଘࡏ͢Δ৔߹͸ͦͷλά ͱඥ෇͚ɺλά͕ଘࡏ͠ͳ͍৔߹͸λ άΛ࡞੒ͯ͠ඥ෇͚ͱ͍ͬͨෳࡶͳ Mutation΋࣮૷Մೳ
22. ΞδΣϯμ • Hasuraͱ͸ • HasuraΛ׆༻͢ΔͨΊͷTipsू ◦ Upsertͷ׆༻ ◦ τϥϯβΫγϣϯ ◦ ϦϨʔγϣϯΛؚΜͩMutatio n ◦ σΟϨΫςΟϒʹΑΔ੍ޚ • ͓ΘΓʹ
23. σΟϨΫςΟϒʹΑΔ੍ޚ Hasura͸ඪ४σΟϨΫςΟϒ͕ར༻Մೳ σΟϨΫςΟϒΛ׆༻͢Δ͜ͱͰQuery, Mutationͷදݱͷ෯͕޿͕Δ
24. σΟϨΫςΟϒʹΑΔ੍ޚ @includeͰऔಘ͢ΔϑΟʔϧυΛ੍ޚ @skipͰ࣮ߦ͢ΔMutationΛ੍ޚ
25. σΟϨΫςΟϒʹΑΔ੍ޚ ؔ࿈ͷͳ͍MutationͰ͋Ε͹ϦΫΤετͷ෼ׂͰରԠՄೳ ಉ͡τϥϯβΫγϣϯ಺ͰMutationͷ࣮ߦΛ੍ޚ͍ͨ͠৔߹͸
 σΟϨΫςΟϒͰͷ੍ޚ͕༗ޮ
26. ͓ΘΓʹ • HasuraΛ׆༻͢Δ͜ͱͰόοΫΤϯυͷ࣮૷޻਺ΛݮΒ͢͜ͱ͕Ͱ͖Δ • ଞʹ΋Hasuraͷػೳ͚ͩͰ࣮ݱͰ͖Δ͜ͱ͸ੵۃతʹ׆༻͢Δͷ͕
 ྑ͍ͱࢥ͍·͢ʂ