SpringBootとMyBatisでデータベースを可視化する

JJUG CCC 2017 Fall で発表した資料です。

Transcript

1. SpringBootͱMyBatisͰ σʔλϕʔεΛՄࢹԽ͢Δ 2017/11/18 JJUG CCC 2017 Fall #ccc_l1 1
2. ࣗݾ঺հ @su_kun_1899 PaDDΤϯδχΞɻϞϒϓϩά ϥϚɻΤϞ࿮ɻ৺͸͍ͭͰ΋ εΫϥϜϚελʔɻ web/java/agile/scrum גࣜձࣾΤεɾΤϜɾΤεͰ հޢࣄۀॴ޲͚ͷWebαʔϏ ε։ൃͯ͠·͢ɻ 2
3. ϑΟʔυόοΫԼ͍͞ #ccc_l1 3
4. Introduction 4
5. ։ൃͯ͠Δ࣌Կݟͯ·͔͢ʁ 5
7. DBఆٛͬͯͲ͏΍ͬͯ֬ೝͯ͠·͔͢ʁ 7
9. shishamoͱ͍͏πʔϧΛ࡞Γ·ͨ͠ https://github.com/su-kun1899/shishamo 9
10. shishamo? • MySQLͷϝλ৘ใΛՄࢹԽ͢ΔWebΞϓϦέ ʔγϣϯ • ΦϯϥΠϯͰInformation SchemaʹΫΤϦΛ ൃߦ͢Δ • ͠͠Ό΋͸ΠϧΧͷ㕒Β͍͠ͷͰɺMySQLͷ Ϛείοτʹ͋΍໋໊͔ͬͯ 10
11. demo 11
12. ഥखͲ͏ͧ 12
13. վΊ·ͯ͠ 13
14. SpringBootͱMyBatisͰ σʔλϕʔεΛՄࢹԽ͢Δ 2017/11/18 JJUG CCC 2017 Fall #ccc_l1 14
15. ࠓ೔࿩͢͜ͱ • લ൒ • ϨΨγʔγεςϜͱσʔλߏ଄ͷՄࢹԽ • shishamoͱ͍͏WebΞϓϦͷ঺հ • ޙ൒ • shishamoΛࢧ͑Δٕज़ • Spring Boot • MyBatis • Spock ※͋·Γٕज़Λਂ۷Γͨ͠࿩͸͠·ͤΜɻԿ͔Λ࢝ΊΔ͖͔͚ͬ΍ώϯτͱ͠ ͯॿ͚ʹͳΕ͹ɻ 15
16. shishamo͸ϨΨγʔγεςϜͱઓ͏ͨΊʹੜ·Ε·ͨ͠ 16
17. ϨΨγʔγεςϜʁ • ෳࡶʹංେԽ • ෆे෼ͳߏ੒؅ཧ • ࠶ݱੑͷͳ͍؀ڥ • ੔උ͞Ε͍ͯͳ͍ςετ • ࣦΘΕͨʢαϙʔτͷ੾Εͨʣٕज़ • etc 17
18. ཁ͸ Α͘෼͔Βͳ͍͠ɺͲ͔ͬΛ͍ͬͨ͡ΒͲ͔͕ͬ յΕͦ͏ͳγεςϜ ʢ΋͔ͨ͠͠Β΋͏յΕͯΔͷ͔΋ɻɻʣ 18
19. Ͳ͏ઓ͏͔ʁ — Α͘෼͔Βͳ͍΋ͷΛ෼͔ΔΑ͏ʹ͢Δ 19
20. σʔλ͔Β੾ΓࠐΉ • γεςϜ͸ଟ͘ͷ৔߹ΠϯϓοτͱΞ΢τϓο τͰ੒Γཱͭ • σʔλ͕γεςϜͷ੒Ռ෺Ͱ͋Δ͜ͱ͕ଟ͍ • ΞϓϦέʔγϣϯʹ͸ઃܭ΍ࢥ૝͕ݱΕΔ • ઃܭ͕࿪ΜͰ͍Δ৔߹ɺ͔͑ͬͯϊΠζʹ ͳΔ͜ͱ͕ଟ͍ 20
21. ʮ࠷ऴతʹ࣮ݱ͍ͨ͜͠ͱʯ͸ σʔλʹදΕ͍ͯΔ͜ͱ͕ଟ͍ 21
22. Ͳ͏ઓ͏͔ʁ — σʔλߏ଄Λ཈͑Δ 22
23. ͦ͏ͩɺERਤͩ 23
24. ΤϯςΟςΟఆٛॻ.xlsm • 1000Ҏ্ͷΦϒδΣΫτ͕ҰͭͷϒοΫ ʹɻɻ • Ұ෦࠷৽Ͱͳ͍΋ͷ͕͋Γ·͢ • Ұ෦ѻ͍ͬͯͳ͍ςʔϒϧ͕͋Γ·͢ • Ұ෦(ry 24
25. υΩϡϝϯτ͸ݹ͘ͳΔ • υΩϡϝϯτ͸ݩʑγεςϜ։ൃͷΠϯϓοτ ʢઃܭॻʣͱͯ͠ͷ໾ׂ͕େ͖͔ͬͨ • γεςϜ͸ΑΓҭͯΔ΋ͷ΁ͱγϑτ͍ͯ͠Δ • ϦϦʔεαΠΫϧ্͕͕ΔҰํͷதɺγεςϜ ʹ௥ै͍ͯ͘͜͠ͱ͸ߴίετ • ͦͯ͠ஔ͍͍͔ͯΕΔɻɻ 25
26. ৴͡ΒΕΔͷ͸ ίʔυ͚ͩ — ࠓͲ͏ͳ͍ͬͯΔ͔ɺ͕།Ұͷਅ࣮ 26
27. Ͱ΋౎౓DBߏ଄Λ֬ೝ͢Δͷ͸πϥΠɻɻ show create table hoge_table; 27
28. Ͳ͏΍Β • γεςϜ։ൃͰ͸σʔλߏ଄Λ཈͑Δͷ͕ॏཁ ʢΆ͍ʣ • υΩϡϝϯτͰදݱ͢Δͷ͸ߴίετʢΆ͍ʣ • Ͳ͏΍ͬͯσʔλߏ଄Λ཈͍͑ͯ͘ͷ͕͍͍ͩ Ζ͏͔ 28
29. σʔλߏ଄Λ Ͳ͏཈͑Δ͔ — ϝλ৘ใ͔Βσʔλߏ଄ΛՄࢹԽ͢Δ 29
30. Information Schema • table, view, column, procedureͷ৘ใΛಡΈऔΓઐ ༻Viewͱͯ͠ఏڙ • ඪ४SQLͰఆٛ͞Ε͍ͯΔ SELECT column_name, data_type, column_default, is_nullable FROM information_schema.columns WHERE table_name='alpha'; column_name | data_type | column_default | is_nullable -------------+-----------+----------------+------------- foo | integer | | YES bar | character | | YES (2 rows) https://en.wikipedia.org/wiki/Information_schema 30
31. SchemaSpy • ϚΠΫϩαʔϏεΞʔΩςΫνϟຊͰ஌ͬͨ • Information SchemaΛݩʹHTMLΛੜ੒ (ࢀߟ) https://qiita.com/su-kun1899/items/b106a1a643bf49df164d 31
32. SchemaSpy ΊͬͪΌΑ͍Ͱ͢ 32
33. SchemaSpyͷ໰୊఺ • HTMLੜ੒ʹΑΔλΠϜϥά • σϓϩΠ৔ॴ • S3ʹϗεςΟϯάͯͨ͠ • ฒྻίετ͕ߴΊ • ฒߦ։ൃͬͯී௨ʹ͋ΔΑͶɻɻ • ࠷৽͚ͩͰͳ͘։ൃதͷ΋ͷ΋ݟ͍ͨ • ଞͷERٯੜ੒πʔϧ΋େ֓ಉ༷ͷ໰୊ • MySQL Workbenchͱ͔ʢ͍͢͝ΜͰ͚͢ͲͶʣ 33
34. shishamo 34
35. shishamoͷڧΈ • ϦΞϧλΠϜʹϝλ৘ใΛՄࢹԽͰ͖Δ -> λΠϜϥά͕ͳ͍ • Java͑͋͞Ε͹Ͳ͜Ͱ΋ಈ͘ʢ΍΍ތு͚ͩͲʣ -> σϓϩΠ৔ॴΛબ͹ͳ͍ • खܰʹ૿΍ͤΔ -> ϩʔΧϧɺDevɺQAɺetc... 35
36. ͙͢࢖͑Δ 1. git clone 2. Ҿ਺ʹ઀ଓઌDBΛࢦఆͯ͠boot:run 3. ϒϥ΢βΞΫηε $ git clone git@github.com:su-kun1899/shishamo.git $ cd shishamo/ $ ./mvnw spring-boot:run \ -Dspring.datasource.url=<Your database url> \ -Dspring.datasource.schema=<Your mysql schema> \ -Dspring.datasource.username=<Your mysql user> \ -Dspring.datasource.password=<Your mysql password> 36
37. Simple • TableҰཡ • Tableఆٛ • Columnఆٛ • Indexఆٛ • Relation • show create table 37
39. shishamoͷऑΈ • ΫΤϦൃߦʹΑΔDB΁ͷෛՙ • ੩తϑΝΠϧΑΓԠ౴ੑೳ͸ྼΔ • MySQLͰ͔͠࢖͑ͳ͍ʢࠓͷͱ͜Ζʣ 39
40. ʮࠓͲ͏ͳͬͯΔ͔ʯΛ ਖ਼֬ʹද͢υΩϡϝϯτ͸ ڧ͍ shishamo࢖ͬͯΈͯԼ͍͞ʂ 40
41. shishamoΛࢧ͑Δٕज़ • Spring Boot • MyBatis • Spock ͔͜͜Βޙ൒ઓɻ࢒Γ࣌ؒ͸େৎ෉͔ʁ 41
42. shishamo ࠷େͷڧΈ — Java͑͋͞Ε͹Ͳ͜Ͱ΋ಈ͘ 42
43. Spring Bootͷ͓͔͛ 43
44. Spring Boot Spring Boot makes it easy to create stand-alone, production-grade Spring based Applications that you can “just run”. 44
45. ؆୯ɾ͓खܰ && ߴػೳɾଟػೳ Springʹ৐͔͍ͬͬͯΔ 45
46. ͪΐͬͱ࡞ͬͯΈΑ͏͕ߴ඼࣭ ࡶʹ࡞ͬͨπʔϧ͕ࢥ͍ͷ֎޿·ͬͯΧΦεԽ͠ ͨ͜ͱͳ͍Ͱ͔͢ʁ 46
47. খ͘͞͸͡Ίͯେ͖͘ҭͯΔ • shishamo͸ݱ࣌఺Ͱ͸େͨ͜͠ͱ͸͍ͯ͠ͳ ͍ • ػೳ௥Ճͨ͘͠ͳͬͨ࣌ʹɺSpringͷੈք͕ॿ ͚ͯ͘ΕΔʢͱࢥ͏ʣ 47
48. Spring BootͰ ࢝ΊΑ͏ 48
49. MyBatis ΧελϜSQLɺετΞυϓϩγʔδϟɺߴ౓ͳϚ οϐϯάॲཧʹରԠͨ͠༏ΕͨӬଓԽϑϨʔϜϫ ʔΫ 49
50. Overview • ͬ͘͟Γ͍͏ͱXMLʹSQLͱϚοϐϯάఆٛΛ ॻ͖·͢ • if΍܁Γฦ͠ͷ੍ޚจ΋ॻ͚·͢ʢࠓ೔͸঺հ ͠·ͤΜʣ • MyBatisͷڧྗ͞͸Ϛοϐϯάʹ͋Δͱࢥ͏ ͷͰ 50
51. model public class User { private int id; private String name; private String sex; // ΞΫηα͸লུ } 51
52. interface @Repository @Mapper public interface UserRepository { User selectById(int id); } 52
53. Result Map <resultMap id="userResultMap" type="User"> <id property="id" column="user_id" /> <result property="name" column="user_name"/> <result property="sex" column="user_sex"/> </resultMap> 53
54. Statement <select id="selectById" resultMap="userResultMap"> select user_id, user_name, user_sex from user_table where id = #{id} </select> 54
55. ΊΜͲͦ͘͞͏ͱײͨ͡ͳΒਖ਼ղͰ͢ 55
56. Auto MappingΛ࢖͏ • MyBatis͕ྻ໊ͱಉ໊͡લΛ࣋ͭϓϩύςΟΛ ୳͢ • ྻ໊͸ΤΠϦΞεͰἧ͑Δ͜ͱ͕Ͱ͖Δ 56
57. Result Map • autoMappingଐੑΛ͚ͭͯ΍Ε͹Α͍ • άϩʔόϧʹઃఆ͢Δ͜ͱ΋Մೳ <resultMap id="userResultMap" type="User" autoMapping="true"> <!-- <id property="id" column="user_id" /> --> <!-- <result property="name" column="user_name"/> --> <!-- <result property="sex" column="user_sex"/> --> </resultMap> 57
58. Statement • ΤΠϦΞεͰɺಉ໊ͰऔΕΔΑ͏ʹͯ͋͛͠Ε ͹Α͍ <select id="selectUsers" resultMap="userResultMap"> select user_id as id, user_name as name, sex as sex from user_table where id = #{id} </select> 58
59. ศརͦ͏ͳงғؾ͕ग़͖ͯ·ͨ͠ʂ 59
60. ωετͨ͠ΦϒδΣΫτ • 1 ର 1 60
61. Address address_id address_city 11 tokyo 12 osaka User user_id user_name user_sex address_id Tokyo Kantō Tokyo 11 Kanagawa Kantō Yokohama 12 61
62. ͜Μͳײ͡ͰऔΔ user id user name user sex address id address city 1 yamada male 11 tokyo 2 sato female 12 osaka 62
63. model public class User { private Address address; private int id; private String name; private String sex; // ΞΫηα͸লུ } public class Address { private int id; private String city; // ΞΫηα͸লུ } 63
64. Result Map • ΦϒδΣΫτΛҰҙʹ͢ΔΧϥϜΛidͰఆٛ • resultMap͸ݸผʹఆٛ͢Δʢ࠶ར༻΋Մೳʣ • associationͰඥ͖ͮΛఆٛ • columnPrefixΛ࢖͏ͱSQLͰ໊લॏෳΛճආͰ ͖Δ 64
65. Result Map <!-- User --> <resultMap id="userResultMap" type="User" autoMapping="true" columnPrefix="user_"> <id column="id"/> <association property="address" resultMap="addressResultMap" columnPrefix="address_"/> </resultMap> <!-- Address --> <resultMap id="addressResultMap" type="Address" autoMapping="true"> <id property="id" column="id"/> </resultMap> 65
66. Statement • ΤΠϦΞεͰɺಉ໊ͰऔΕΔΑ͏ʹͯ͋͛͠Ε ͹Α͍ • columnPrefix͕ର৅ͷΦϒδΣΫτʹඥ෇͚ͯ ͘ΕΔ 66
67. Statement <select id="selectUsers" resultMap="userResultMap"> select some_table.user_id as user_id, some_table.user_name as user_name, some_table.sex as user_sex, address.address_id as address_id, address.address_city as address_city from some_table inner join address on some_table.address_id = address.address_id where some_table.user_id = #{id} </select> 67
68. ωετͨ͠ΦϒδΣΫτ • 1 ର ଟ 68
69. User user_id user_name user_sex address_id 1 yamada male 11 2 sato female 12 Hobby hobby_id hobby_name 21 football 22 running 23 video game 24 programming 69
70. User_Hobby user_id hobby_id 1 21 1 23 1 24 2 22 2 24 70
71. ͜Μͳײ͡ͰऔΔ user_id user_name user_sex hobby_id hobby_nam e 1 yamada male 21 football 1 yamada male 23 video game 1 yamada male 24 programmin g 2 sato female 22 runnning 2 sato female 24 programmin g 71
72. model public class User { private Address address; private int id; private String name; private String sex; private List<Hobby> hobbies; // ΞΫηα͸লུ } public class Hobby { private int id; private String name; // ΞΫηα͸লུ } 72
73. Result Map • collectionλάͰඥ෇͚Δ • idλάͷఆ͕ٛ֊૚Λಛఆ͢Δ 73
74. Result Map <resultMap id="userResultMap" type="User" autoMapping="true" columnPrefix="user_"> <id column="id"/> <collection property="hobbies" ofType="Hobby" resultMap="hobbyResultMap" columnPrefix="hobby_"/> </resultMap> <resultMap id="hobbyResultMap" type="Hobby" autoMapping="true"> <id property="id" column="id"/> </resultMap> 74
75. Statement <select id="selectUsers" resultMap="userResultMap"> select some_table.user_id as user_id, some_table.user_name as user_name, some_table.sex as user_sex, hobby.hobby_id as hobby_id, hobby.hobby_name as hobby_name from some_table inner join user_hobby on some_table.user_id = user_hobby.user_id inner join hobby on user_hobby.hobby_id = hobby.hobby_id where some_table.id = #{id} </select> 75
76. ͲΜͳͱ͖ʹMyBatisʁ • SQLϕʔεͷϚοϐϯά͕ڧྗ • Ϛοϐϯάఆٛͷهड़ίετΛԼ͛Δ޻෉͕͞ Ε͍ͯΔ • ͭ·ΓɺSQLΛॻ͖͍ͨ࣌ʹ޲͍͍ͯΔ 76
77. SQLΛॻ͖͍ͨ࣌ʁ • σʔλϞσϧ͕Ұఆͷن໛Ҏ্ʹͳΓɺυϝΠ ϯϞσϧͱͷࠩ෼͕େ͖͘ͳ͍ͬͯΔ • σʔλϕʔεͷมߋίετ͕ߴ͍ 77
78. shishamoͷ৔߹ • Information Schemaʹର͢ΔΫΤϦ • ΞϓϦέʔγϣϯͷ౎߹ͰσʔλϞσϧΛมߋ Ͱ͖ͳ͍ 78
79. σʔλϞσϧͱυϝΠϯϞσϧ͸ ຊདྷผ෺ • σʔλϞσϧͱυϝΠϯϞσϧͷϛεϚονղ ফʹMyBatisΛબ୒͢ΔՁ஋͸͋Δ • ΞϓϦέʔγϣϯϨΠϠͰѻ͏ΦϒδΣΫτ͕ DBߏ଄ͱҰக͢ΔʢΑ͏ʹ͢ΔʣͷͰ͋Ε͹ ผͷબ୒ࢶͷํ͕͍͍ 79
80. MyBatis͸ͦΕͳΓʹίετ͕͔͔Δ • SQLΛॻ͔ͳͯ͘͸͍͚ͳ͍ • ֶशίετ • Mapper XMLͰͷΧελϜSQL • SQLʹ੍ޚߏ଄ΛຒΊࠐΉ 80
81. ͦΕͰ΋ • σʔλߏ଄ʹҾ͖ͣΒΕͳͯ͘ࡁΉͷ͸େ͖ͳར఺ • DBఆٛมߋͷͨΊʹυϝΠϯϞσϧʹखΛೖΕͨ ΓɺDTO΍EntityͷΑ͏ͳҰ࣌ड͚Ϋϥε͕ෆཁʹ ͳΔ • (༨ஊͰ͕͢)ͦ͏ͳ͖ͬͯͨΒORϚούʔͷࡌ ͤସ͑Λݕ౼ͨ͠ํ͕͍͍ͱࢥ͏ • σʔλϞσϧʹυϝΠϯϞσϧ͕Ҿ͖ͣΒΕΔͷ͸ ຊ຤స౗ͳؾ͕͢Δ 81
82. MyBatisͱ͍͏ બ୒ࢶΛ खʹೖΕΑ͏ 82
83. Spock • Java/GroovyΞϓϦέʔγϣϯͷͨΊͷςες ΟϯάϑϨʔϜϫʔΫ • GroovyͰॻ͖·͢ʢJavaͰ΋ॻ͚Δ͚Ͳʣ 83
84. Spock͸࠷ߴͰ͢ • ࠓ೔Ұ൪ݴ͍͍ͨ͜ͱͱ͍ͬͯ΋աݴͰ͸ͳ͍ • shishamo͸GitHubͰ͸GroovyϓϩδΣΫτ 84
85. Spockͷ͍͍ͱ͜Ζ • given/when/then౳ͷϒϩοΫ • ڧྗͳMockػߏ • Data TablesʹΑΔύϥϝʔλϥΠζυςετ • ௿ֶ͍शίετ • and more 85
86. given/when/then౳ͷϒϩοΫ • setup • given • when • then • expect • cleanup • where 86
87. ςετͷҙਤ͕໌ന def "HashMap accepts null key"() { given: def map = new HashMap() when: map.put(null, "elem") then: notThrown(NullPointerException) } 87
88. ڧྗͳMockػߏ given: def subscriber = Mock(Subscriber) subscriber.receive("message1") >> "ok" and: def publisher = new Publisher(); when: publisher.send("message1") then: 1 * subscriber.receive("message1") 88
89. ͜Μͳ͜ͱ΋ // Ҿ਺͕helloͷͱ͖͚ͩ 1 * subscriber.receive("hello") // Ҿ਺͕helloͰ͸ͳ͍ͱ͖͚ͩ 1 * subscriber.receive(!"hello") // Ҿ਺ͻͱͭͳΒͳΜͰ΋ 1 * subscriber.receive(_) // Ҿ਺͍ͭ͘Ͱ΋ͳΜͰ΋ 1 * subscriber.receive(*_) // StringͷҾ਺ͻͱͭͳΒͳΜͰ΋ 1 * subscriber.receive(_ as String) // predicate΋࢖͑ΔʢҾ਺ͷsize͕ 3 ΑΓେ͖͍ʣ 1 * subscriber.receive({ it.size() > 3 }) 89
90. Data Tables def "maximum of two numbers"() { expect: Math.max(a, b) == c where: a | b || c 1 | 3 || 3 7 | 4 || 7 0 | 0 || 0 } 90
91. Groovyͷॊೈੑ • Javaʹൺ΂ΔͱʮԿͰ΋͋Γʯͳײ֮ʹؕΔ • privateίϯετϥΫλ΋ಛʹMockingͳ͠ʹ ݺͼग़ͤΔఔ • ※ྫͳͷͰɺͦΕΛݺͼग़͢ͷ͕Α͍ͱ͍͏ Θ͚Ͱ͸ͳ͍ 91
92. Πϯελϯεੜ੒ public class Foo { private long id; private String name; // ΞΫηαলུ } 92
93. Πϯελϯεੜ੒ • ಛʹίϯετϥΫλ͕ͳͯ͘΋஋ηοτͰੜ੒ Ͱ͖Δ def foo = new Foo(id: 1, name: "sample") 93
94. JUnitʁ • JUnit͸Ғେ • ςετͰ΍Γ͍ͨ͜ͱ͸ JUnit/Mockito/ PowerMock ͕͋Ε͹΄΅࣮ݱͰ͖Δ 94
95. ͳͥSpockͳͷ͔ʁ 95
96. MockitoͰͷMocking LinkedList mockedList = mock(LinkedList.class); when(mockedList.get(0)).thenReturn("first"); 96
97. SpockͰͷMocking def mockedList = Mock(LinkedList); mockedList.get(0) >> "first"; 97
98. JUnitͰͷύϥϝʔλϥΠζυςετ @ParameterizedTest @ValueSource(strings = { "Hello", "World" }) void testWithStringParameter(String argument) { assertNotNull(argument); } • JUnit5Ͱ͍ͩͿָʹͳͬͨ໛༷ • JUnit4ͩͱTheoriesΛ࢖ͬͯ΋ͬͱେม 98
99. SpockͷData Tables def "with string parameter"() { expect: argument != null where: argument | _ "Hello" | _ "World" | _ } 99
100. JUnit • ΍Γ͍ͨ͜ͱ͸Ͱ͖Δ͚Ͳɺ֮͑Δ͜ͱ͕ଟ͍ • ςετΛॻ͍͍ͯΔͱ͖ʹɺԿ͔Λௐ΂͍ͯΔ͜ͱ ͕ଟ͍ • voidϝιουͷMockͲ͏΍ͬͯॻ͘Μͩͬ ͚ɻɻ • ύϥϝʔλϥΠζυςετͷΞϊςʔγϣϯͳΜ ͚ͩͬɻɻ • etc 100
101. Spock • ه๏͕γϯϓϧ • ຊ࣭తͳʮͲ͏΍ͬͯԿΛςετ͢ΔʯΛߟ͑ Δ͕࣌ؒ૿͑Δ • ͍͍ҙຯͰࡶʹॻ͚Δ • ςετΛॻ͘ͷ͕େมͩͱɺॻ͘ؾ͕ͳ͘ ͳΔ 101
102. Spockʹ৮ͬͯΈΑ͏ 102
103. ςετର৅Ϋϥε @Service public class UserService { private UserRepository userRepository; // ίϯετϥΫλ public UserService(UserRepository userRepository) { this.userRepository = userRepository; } // ςετର৅ϝιου @Transactional(readOnly = true) public List<User> findBy(Sex sex) { return userRepository.selectBySex(sex); } } 103
104. ςετΫϥε class UserServiceSpec extends Specification { UserService userService UserRepository userRepository; def 'Get users by sex'() { given: 'Mocking repository' def userRepository = Mock(UserRepository) userRepository.selectBySex(Sex.MALE) >> {[ new User(name: 'Taro', sex: Sex.MALE), new User(name: 'Jiro', sex: Sex.MALE), ]} and: def userService = new UserRepository(userRepository) when: def actual = userService.get(Sex.MALE) then: actual.size() == 2 actual.collect { it.name } == ['Taro', 'Jiro'] } } 104
105. given given: 'Mocking repository' def userRepository = Mock(UserRepository) userRepository.selectBySex(Sex.MALE) >> {[ new User(name: 'Taro', sex: Sex.MALE), new User(name: 'Jiro', sex: Sex.MALE), ]} and: 'ίϯετϥΫλΠϯδΣΫγϣϯ࠷ߴ' def userService = new UserRepository(userRepository) 105
106. when-then when: def actual = userService.get(Sex.MALE) then: actual.size() == 2 actual.collect { it.name } == ['Taro', 'Jiro'] 106
107. ͍Ζ͍Ζݴ͍·͕ͨ͠ • ৮ͬͯΈͯ͸͡Ίͯྑ͕͞෼͔Δͱࢥ͍·͢ • Ҏલಋೖʹ൓ରͨ͜͠ͱ͕͋Γ·͢ • ผݴޠͰ৽͍͠ϑϨʔϜϫʔΫಋೖා͔ͬ ͨ • ͦͷͱ͖͸JUnitʹ͠·ͨ͠ • ࠓͰ΋৑ஊͰ͍͡ΒΕ·͢ 107
108. Conclusion 108
109. ଟ͘ͷγεςϜʹ͸DB͕͋Δ 109
110. DB͸γεςϜશମΛࢧ͍͑ͯΔ 110
111. DBͷण໋͸ΞϓϦέʔγϣϯΑΓ΋௕͍ 111
112. طଘͷDBΛ׆͔ͨ͠ ΞϓϦέʔγϣϯΛ ࡞Γ͍ͨ 112
113. DBͷ௚઀ૢ࡞Λ ΍Ί͍ͨ ڞ༗σʔλϕʔεΛ ΍Ί͍ͨ 113
114. ࡞Δͷେมͦ͏ͩͳɻɻ ؀ڥͷ४උͰ͖Δ͔ͳɻɻ 114
115. Spring Boot! 115
116. ઃܭ࣮ͯ͠૷͠Α͏ɻɻ ςʔϒϧఆٛͲ͏ͳ͚ͬͯͨͬʁ 116
117. shishamo! 117
118. σʔλߏ଄ͱϞσϧ͕ϛεϚον͔΋ʁ ࠓͷSQLࢿ࢈Λ׆͔ͤͳ͍͔ͳʁ 118
119. MyBatis!! 119
120. SQLΛॻ͜͏ɻɻ ϦϨʔγϣϯͲ͏ͳ͚ͬͯͨͬʁ ΠϯσοΫε͸ʁ 120
121. shishamo! 121
122. ςετ͠ͳͬͪ͘Όɻɻ ָ͘͠ςετΛॻ͘ํ๏͸ͳ͍͔ͳʁ 122
123. Spock!!! 123
124. ςετσʔλ͕ඞཁͩͳɻɻ ͲͷςʔϒϧʹͲΜͳσʔλ͕ඞཁͩΖ͏ʁ 124
125. shishamo! 125
126. ͦΖͦΖϦϦʔεͰ͖ͦ͏͔ɻɻʁ 126
127. “just run” 127
128. ࠓ೔ݴ͍͔ͨͬͨ͜ͱ • SpringBoot + MyBatis + Spock ͱ͍͏։ൃύοΫ • SpringBoot͸؆୯Ͱߴػೳ • MyBatisͷϚοϐϯά͸ڧྗ • Spock࠷ߴͳͷͰࢼͯ͠Լ͍͞ • طଘࢿ࢈Λվળ͢Δʹ͸ՄࢹԽ͕େࣄ • ʮݱঢ়ʯΛਖ਼֬ʹද͢ • υΩϡϝϯτʹ΋ίʔυʹ΋པΓ͗͢ͳ͍ • DBʹݶͬͨ࿩Ͱ͸ͳ͍ 128
129. ༨ஊ ಉ྅ʹshishamoΛ঺հͨ͠Β͢΂ͯKotlinͰॻ͖ ׵͑ΔϓϧϦΫΤετ͕ૹΒΕ͖ͯͨ͜ͱΛ͜͜ ʹ͝ใࠂ͠·͢ɻ 129
130. ͓͠·͍ Spring Boot makes it easy to create stand-alone, production- grade Spring based Applications that you can “just run”. 130