NieR Re[in]carnationにおけるマスターデータ運用とその裏側

by CyberAgent

Slide 1

Slide 1 text

ҏ౻ ྇໵ 2021೥౓ ৽ଔೖࣾ גࣜձࣾOEN @ry_itto @ry-itto

Slide 2

Slide 2 text

Ṥޱ ༤໵ 2020೥౓ ৽ଔೖࣾ גࣜձࣾΞϓϦϘοτ NieR Re[in]carnationνʔϜ ΤϯδχΞ @y_uucu @yuucu

Slide 3

Slide 3 text

Slide 4

Slide 4 text

Slide 5

Slide 5 text

1.ήʔϜʹ͓͚ΔϚελʔσʔλ 2.Ϛελʔσʔλ഑৴ͷཪଆ 3.Ϛελʔσʔλӡ༻ 4.·ͱΊ

Slide 6

Slide 6 text

1.ήʔϜʹ͓͚ΔϚελʔσʔλ 2.Ϛελʔσʔλ഑৴ͷཪଆ 3.Ϛελʔσʔλӡ༻ 4.·ͱΊ

Slide 7

Slide 7 text

Ϛελʔσʔλͱ͸ ●ήʔϜ಺Ͱར༻͞ΕΔઃఆ஋ ex. ΫΤετɼΠϕϯτɼΨνϟͳͲશͯͷઃఆ஋ ●σʔλͱϩδοΫͷ෼཭ ΤϯδχΞ͕࣮૷͠ɼϓϥϯφʔ͕ઃఆ ●ΞϓϦߋ৽ແ͠ͰήʔϜ಺σʔλΛߋ৽

Slide 8

Slide 8 text

Ϛελʔσʔλͱ͸ ●Ϛελʔσʔλͷςʔϒϧ ڞ௨Ϛελɼαʔόʔઐ༻ɼΫϥΠΞϯτઐ༻ͷ3छྨ ຊλΠτϧͰ͸ɼ2022೥5݄ݱࡏͰ600ऑͷςʔϒϧ਺ 

Slide 9

Slide 9 text

1.ήʔϜʹ͓͚ΔϚελʔσʔλ 2.Ϛελʔσʔλ഑৴ͷཪଆ 3.Ϛελʔσʔλӡ༻ 4.·ͱΊ

Slide 10

Slide 10 text

Ϛελʔσʔλ഑৴·Ͱ ●ςʔϒϧఆٛߋ৽  ςʔϒϧఆٛ  ࣗಈੜ੒ʢERਤ, ddl, dto, dao…ʣ  ؀ڥσϓϩΠ ●Ϛελʔσʔλߋ৽  Ϛελʔσʔλ౤ೖ  ϚελʔσʔλϦϦʔε

Slide 11

Slide 11 text

ςʔϒϧఆٛ ●Plant UMLʹΑΔςΩετϑΝΠϧهड़

Slide 12

Slide 12 text

ࣗಈੜ੒ ●Plant UMLͷಠࣗparserʹΑΔࣗಈੜ੒ ●αʔόʔؔ࿈  DDL  DTO  DAO  ෆ੔߹ݕ஌ΫΤϦ ●ΫϥΠΞϯτؔ࿈  DBςʔϒϧఆٛ  (MasterMemory) ※Ұ෦লུ

Slide 13

Slide 13 text

ࣗಈੜ੒ ●Plant UMLͷಠࣗparserʹΑΔࣗಈੜ੒ʢαʔόʔʣ DAO - ඞཁ࠷খݶͷΫΤϦʹରԠͨ͠Ϋϥε͕ࣗಈੜ੒͞ΕΔ - ඞཁʹԠͯ͡ΧελϜΫΤϦΛࠩ͠ࠐΉ͜ͱ΋ DDL DTO - MyBatisʹΑΔࣗಈੜ੒ ෆ੔߹ݕ஌ΫΤϦ - ϦϨʔγϣϯ͔ΒϚελʔσʔλݕূͷͨΊͷΫΤϦ͕ੜ੒

Slide 14

Slide 14 text

ࣗಈੜ੒ ●Plant UMLͷಠࣗparserʹΑΔࣗಈੜ੒ʢΫϥΠΞϯτʣ ࢀߟจݙɿhttps://github.com/Cysharp/MasterMemory ςʔϒϧఆٛʢMasterMemoryʣ - ิ଍ɿMasterMemory - Unityͱ.Net CoreͷͨΊͷಡΈऔΓઐ༻ΠϯϝϞϦDB - MasterMemoryʹඞཁͳςʔϒϧఆٛΫϥεΛࣗಈੜ੒

Slide 15

Slide 15 text

σϓϩΠ/Ϛελʔσʔλ౤ೖ ●σϓϩΠ ఆٛͨ͠ϑΝΠϧ͔Βࣗಈੜ੒͞ΕͨddlΛྲྀͨ͠Γɼ ΞϓϦέʔγϣϯΛߋ৽͠·͢   ●Ϛελʔσʔλ౤ೖ ޙड़ͷεϥΠυͰৄ͘͠ड़΂·͢

Slide 16

Slide 16 text

ϚελʔσʔλϦϦʔε ●αʔόʔ  DBʹೖ͍ͬͯΔϚελʔσʔλΛϏϧυ͠ɼS3΁  ഑৴͞Εͨ΋ͷΛΞϓϦέʔγϣϯ͕ಡΈऔΓɼ  ΠϯϝϞϦ΁Ωϟογϡ͠·͢ ●ΫϥΠΞϯτ MasterMemory͕ಡΈऔΕΔܗͰϏϧυͯ͠഑৴

Slide 17

Slide 17 text

1.ήʔϜʹ͓͚ΔϚελʔσʔλ 2.Ϛελʔσʔλ഑৴ͷཪଆ 3.Ϛελʔσʔλӡ༻ 4.·ͱΊ

Slide 18

Slide 18 text

Ϛελʔσʔλӡ༻ ●GitʹΑΔཤྺ؅ཧ  ●ϚελʔσʔλϦϙδτϦ ςʔϒϧ͝ͱͷcsvϑΝΠϧ  ●։ൃ؀ڥ1ͭʹରͯ͠ɼ1branch dev01, dev02, dev03…ϒϥϯν ●CSV / Gitӡ༻

Slide 19

Slide 19 text

●CSV + Git؅ཧ ϩʔΧϧͰͷCSVฤू ϓϥϯφʔʹΑΔcommit & push ●՝୊఺ Gitͷֶशίετ CSVखಈฤूͷͭΒ͞ աڈͷӡ༻ (ϦϦʔεલ)

Slide 20

Slide 20 text

● εϓϨουγʔτ + Gitӡ༻ Gitӡ༻෦෼ΛࣗಈԽ͠ɼ୭Ͱ΋ѻ͑ΔγεςϜ΁ ● εϓϨουγʔτपΓͷΤίγεςϜ ؔ਺ͳͲͰϓϥϯφʔࣗ਎ͰϚΫϩΛ૊ΜͩΓग़དྷΔ ը૾ ݱࡏͷӡ༻

Slide 21

Slide 21 text

ఆٛΤΫεϙʔτ

Slide 22

Slide 22 text

ఆٛΤΫεϙʔτ ●Ϛελʔσʔλͷςʔϒϧબ୒ʢෳ਺ʣ ●৽ن࡞੒orಛఆͷγʔτʹఆٛు͖ग़͠

Slide 23

Slide 23 text

εϓϨουγʔτ ●1ߦ໨ɿςʔϒϧ໊ ●2ߦ໨ɿܕఆٛ ●3ߦ໨ɿΧϥϜ໊ ●4ߦ໨ʙɿ౤ೖ͍ͨ͠σʔλ

Slide 24

Slide 24 text

σʔλΠϯϙʔτ

Slide 25

Slide 25 text

σʔλΠϯϙʔτ ●εϓϨουγʔτબ୒ ●ςʔϒϧબ୒ ●֘౰ςʔϒϧͷσʔλ౤ೖ

Slide 26

Slide 26 text

σʔλΠϯϙʔτ ●εϓϨουγʔτબ୒ ●ςʔϒϧબ୒ ●֘౰ςʔϒϧͷσʔλ౤ೖ

Slide 27

Slide 27 text

σʔλΠϯϙʔτ ●DBʹσʔλ͕ཷ·͍ͬͯ͘ ●Ωϟογϡ͸ߋ৽͞Εͳ͍ͷͰήʔϜ͸ߋ৽͞Εͳ͍ ●Πϯϙʔτػೳ

Slide 28

Slide 28 text

λά࡞੒

Slide 29

Slide 29 text

λά࡞੒ ●DB -> CSV export -> git commit & tag -> git push ●gitʹpush͞ΕͨcsvͰαʔόʔ/ΫϥΠΞϯτͦΕͧΕͷ ܗࣜʹϏϧυ͠ɼS3্ʹ഑ஔ ●ݱঢ়ͷDBͷத਎ʹλάΛ෇͚Δ

Slide 30

Slide 30 text

Ϛελʔσʔλߋ৽ ●ಛఆͷλάબ୒ͯ͠Πϯϙʔτ ςʔϒϧ͝ͱͷhashΛܭࢉ͠ɼࠩ෼͕͋Ε͹ߋ৽ ●λάબ୒

Slide 31

Slide 31 text

1.ήʔϜʹ͓͚ΔϚελʔσʔλ 2.Ϛελʔσʔλ഑৴ͷཪଆ 3.Ϛελʔσʔλӡ༻ 4.·ͱΊ

Slide 32

Slide 32 text

·ͱΊ ●Ϛελʔσʔλ഑৴·Ͱͷཪଆ  ࣗಈੜ੒Λ࢖ͬͯޮ཰Խͨ͠։ൃ؀ڥ  ●Ϛελʔσʔλӡ༻  GitΛ࢖ͬͨϚελʔσʔλ؅ཧ  GitΛҙࣝ͠ͳ͍Ϛελʔσʔλӡ༻γεςϜΛ঺հ