mexiliang
/
PivotalLabsAndSamples
feito fork de kristofer/PivotalLabsAndSamples
Observar 1
Favorito 0
Fork 0
Código Issues 0 Pull Requests 0 Versões 0 Wiki Atividade
3 Commits
1 Branch
Branch: master
Branches Tags
${ item.name }
Criar branch ${ searchTerm }
de master
${ noResults }
PivotalLabsAndSamples/student-lab-instructions/06-spring-boot-data.html

06-spring-boot-data.html 120KB
Link permanente Histórico Original

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987 
  1. <!DOCTYPE html>

  2. <html lang="en">

  3. <head>

  4. <meta charset="UTF-8">

  5. <!--[if IE]><meta http-equiv="X-UA-Compatible" content="IE=edge"><![endif]-->

  6. <meta name="viewport" content="width=device-width, initial-scale=1.0">

  7. <meta name="generator" content="Asciidoctor 1.5.5">

  8. <title>Spring Boot Data</title>

  9. <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Open+Sans:300,300italic,400,400italic,600,600italic%7CNoto+Serif:400,400italic,700,700italic%7CDroid+Sans+Mono:400,700">

  10. <style>

  11. /* Asciidoctor default stylesheet | MIT License | http://asciidoctor.org */

  12. /* Remove comment around @import statement below when using as a custom stylesheet */

  13. /*@import "https://fonts.googleapis.com/css?family=Open+Sans:300,300italic,400,400italic,600,600italic%7CNoto+Serif:400,400italic,700,700italic%7CDroid+Sans+Mono:400,700";*/

  14. article,aside,details,figcaption,figure,footer,header,hgroup,main,nav,section,summary{display:block}

  15. audio,canvas,video{display:inline-block}

  16. audio:not([controls]){display:none;height:0}

  17. [hidden],template{display:none}

  18. script{display:none!important}

  19. html{font-family:sans-serif;-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%}

  20. a{background:transparent}

  21. a:focus{outline:thin dotted}

  22. a:active,a:hover{outline:0}

  23. h1{font-size:2em;margin:.67em 0}

  24. abbr[title]{border-bottom:1px dotted}

  25. b,strong{font-weight:bold}

  26. dfn{font-style:italic}

  27. hr{-moz-box-sizing:content-box;box-sizing:content-box;height:0}

  28. mark{background:#ff0;color:#000}

  29. code,kbd,pre,samp{font-family:monospace;font-size:1em}

  30. pre{white-space:pre-wrap}

  31. q{quotes:"\201C" "\201D" "\2018" "\2019"}

  32. small{font-size:80%}

  33. sub,sup{font-size:75%;line-height:0;position:relative;vertical-align:baseline}

  34. sup{top:-.5em}

  35. sub{bottom:-.25em}

  36. img{border:0}

  37. svg:not(:root){overflow:hidden}

  38. figure{margin:0}

  39. fieldset{border:1px solid silver;margin:0 2px;padding:.35em .625em .75em}

  40. legend{border:0;padding:0}

  41. button,input,select,textarea{font-family:inherit;font-size:100%;margin:0}

  42. button,input{line-height:normal}

  43. button,select{text-transform:none}

  44. button,html input[type="button"],input[type="reset"],input[type="submit"]{-webkit-appearance:button;cursor:pointer}

  45. button[disabled],html input[disabled]{cursor:default}

  46. input[type="checkbox"],input[type="radio"]{box-sizing:border-box;padding:0}

  47. input[type="search"]{-webkit-appearance:textfield;-moz-box-sizing:content-box;-webkit-box-sizing:content-box;box-sizing:content-box}

  48. input[type="search"]::-webkit-search-cancel-button,input[type="search"]::-webkit-search-decoration{-webkit-appearance:none}

  49. button::-moz-focus-inner,input::-moz-focus-inner{border:0;padding:0}

  50. textarea{overflow:auto;vertical-align:top}

  51. table{border-collapse:collapse;border-spacing:0}

  52. *,*:before,*:after{-moz-box-sizing:border-box;-webkit-box-sizing:border-box;box-sizing:border-box}

  53. html,body{font-size:100%}

  54. body{background:#fff;color:rgba(0,0,0,.8);padding:0;margin:0;font-family:"Noto Serif","DejaVu Serif",serif;font-weight:400;font-style:normal;line-height:1;position:relative;cursor:auto;tab-size:4;-moz-osx-font-smoothing:grayscale;-webkit-font-smoothing:antialiased}

  55. a:hover{cursor:pointer}

  56. img,object,embed{max-width:100%;height:auto}

  57. object,embed{height:100%}

  58. img{-ms-interpolation-mode:bicubic}

  59. .left{float:left!important}

  60. .right{float:right!important}

  61. .text-left{text-align:left!important}

  62. .text-right{text-align:right!important}

  63. .text-center{text-align:center!important}

  64. .text-justify{text-align:justify!important}

  65. .hide{display:none}

  66. img,object,svg{display:inline-block;vertical-align:middle}

  67. textarea{height:auto;min-height:50px}

  68. select{width:100%}

  69. .center{margin-left:auto;margin-right:auto}

  70. .spread{width:100%}

  71. p.lead,.paragraph.lead>p,#preamble>.sectionbody>.paragraph:first-of-type p{font-size:1.21875em;line-height:1.6}

  72. .subheader,.admonitionblock td.content>.title,.audioblock>.title,.exampleblock>.title,.imageblock>.title,.listingblock>.title,.literalblock>.title,.stemblock>.title,.openblock>.title,.paragraph>.title,.quoteblock>.title,table.tableblock>.title,.verseblock>.title,.videoblock>.title,.dlist>.title,.olist>.title,.ulist>.title,.qlist>.title,.hdlist>.title{line-height:1.45;color:#7a2518;font-weight:400;margin-top:0;margin-bottom:.25em}

  73. div,dl,dt,dd,ul,ol,li,h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6,pre,form,p,blockquote,th,td{margin:0;padding:0;direction:ltr}

  74. a{color:#2156a5;text-decoration:underline;line-height:inherit}

  75. a:hover,a:focus{color:#1d4b8f}

  76. a img{border:none}

  77. p{font-family:inherit;font-weight:400;font-size:1em;line-height:1.6;margin-bottom:1.25em;text-rendering:optimizeLegibility}

  78. p aside{font-size:.875em;line-height:1.35;font-style:italic}

  79. h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6{font-family:"Open Sans","DejaVu Sans",sans-serif;font-weight:300;font-style:normal;color:#ba3925;text-rendering:optimizeLegibility;margin-top:1em;margin-bottom:.5em;line-height:1.0125em}

  80. h1 small,h2 small,h3 small,#toctitle small,.sidebarblock>.content>.title small,h4 small,h5 small,h6 small{font-size:60%;color:#e99b8f;line-height:0}

  81. h1{font-size:2.125em}

  82. h2{font-size:1.6875em}

  83. h3,#toctitle,.sidebarblock>.content>.title{font-size:1.375em}

  84. h4,h5{font-size:1.125em}

  85. h6{font-size:1em}

  86. hr{border:solid #ddddd8;border-width:1px 0 0;clear:both;margin:1.25em 0 1.1875em;height:0}

  87. em,i{font-style:italic;line-height:inherit}

  88. strong,b{font-weight:bold;line-height:inherit}

  89. small{font-size:60%;line-height:inherit}

  90. code{font-family:"Droid Sans Mono","DejaVu Sans Mono",monospace;font-weight:400;color:rgba(0,0,0,.9)}

  91. ul,ol,dl{font-size:1em;line-height:1.6;margin-bottom:1.25em;list-style-position:outside;font-family:inherit}

  92. ul,ol,ul.no-bullet,ol.no-bullet{margin-left:1.5em}

  93. ul li ul,ul li ol{margin-left:1.25em;margin-bottom:0;font-size:1em}

  94. ul.square li ul,ul.circle li ul,ul.disc li ul{list-style:inherit}

  95. ul.square{list-style-type:square}

  96. ul.circle{list-style-type:circle}

  97. ul.disc{list-style-type:disc}

  98. ul.no-bullet{list-style:none}

  99. ol li ul,ol li ol{margin-left:1.25em;margin-bottom:0}

  100. dl dt{margin-bottom:.3125em;font-weight:bold}

  101. dl dd{margin-bottom:1.25em}

  102. abbr,acronym{text-transform:uppercase;font-size:90%;color:rgba(0,0,0,.8);border-bottom:1px dotted #ddd;cursor:help}

  103. abbr{text-transform:none}

  104. blockquote{margin:0 0 1.25em;padding:.5625em 1.25em 0 1.1875em;border-left:1px solid #ddd}

  105. blockquote cite{display:block;font-size:.9375em;color:rgba(0,0,0,.6)}

  106. blockquote cite:before{content:"\2014 \0020"}

  107. blockquote cite a,blockquote cite a:visited{color:rgba(0,0,0,.6)}

  108. blockquote,blockquote p{line-height:1.6;color:rgba(0,0,0,.85)}

  109. @media only screen and (min-width:768px){h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6{line-height:1.2}

  110. h1{font-size:2.75em}

  111. h2{font-size:2.3125em}

  112. h3,#toctitle,.sidebarblock>.content>.title{font-size:1.6875em}

  113. h4{font-size:1.4375em}}

  114. table{background:#fff;margin-bottom:1.25em;border:solid 1px #dedede}

  115. table thead,table tfoot{background:#f7f8f7;font-weight:bold}

  116. table thead tr th,table thead tr td,table tfoot tr th,table tfoot tr td{padding:.5em .625em .625em;font-size:inherit;color:rgba(0,0,0,.8);text-align:left}

  117. table tr th,table tr td{padding:.5625em .625em;font-size:inherit;color:rgba(0,0,0,.8)}

  118. table tr.even,table tr.alt,table tr:nth-of-type(even){background:#f8f8f7}

  119. table thead tr th,table tfoot tr th,table tbody tr td,table tr td,table tfoot tr td{display:table-cell;line-height:1.6}

  120. h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6{line-height:1.2;word-spacing:-.05em}

  121. h1 strong,h2 strong,h3 strong,#toctitle strong,.sidebarblock>.content>.title strong,h4 strong,h5 strong,h6 strong{font-weight:400}

  122. .clearfix:before,.clearfix:after,.float-group:before,.float-group:after{content:" ";display:table}

  123. .clearfix:after,.float-group:after{clear:both}

  124. *:not(pre)>code{font-size:.9375em;font-style:normal!important;letter-spacing:0;padding:.1em .5ex;word-spacing:-.15em;background-color:#f7f7f8;-webkit-border-radius:4px;border-radius:4px;line-height:1.45;text-rendering:optimizeSpeed;word-wrap:break-word}

  125. *:not(pre)>code.nobreak{word-wrap:normal}

  126. *:not(pre)>code.nowrap{white-space:nowrap}

  127. pre,pre>code{line-height:1.45;color:rgba(0,0,0,.9);font-family:"Droid Sans Mono","DejaVu Sans Mono",monospace;font-weight:400;text-rendering:optimizeSpeed}

  128. em em{font-style:normal}

  129. strong strong{font-weight:400}

  130. .keyseq{color:rgba(51,51,51,.8)}

  131. kbd{font-family:"Droid Sans Mono","DejaVu Sans Mono",monospace;display:inline-block;color:rgba(0,0,0,.8);font-size:.65em;line-height:1.45;background-color:#f7f7f7;border:1px solid #ccc;-webkit-border-radius:3px;border-radius:3px;-webkit-box-shadow:0 1px 0 rgba(0,0,0,.2),0 0 0 .1em white inset;box-shadow:0 1px 0 rgba(0,0,0,.2),0 0 0 .1em #fff inset;margin:0 .15em;padding:.2em .5em;vertical-align:middle;position:relative;top:-.1em;white-space:nowrap}

  132. .keyseq kbd:first-child{margin-left:0}

  133. .keyseq kbd:last-child{margin-right:0}

  134. .menuseq,.menu{color:rgba(0,0,0,.8)}

  135. b.button:before,b.button:after{position:relative;top:-1px;font-weight:400}

  136. b.button:before{content:"[";padding:0 3px 0 2px}

  137. b.button:after{content:"]";padding:0 2px 0 3px}

  138. p a>code:hover{color:rgba(0,0,0,.9)}

  139. #header,#content,#footnotes,#footer{width:100%;margin-left:auto;margin-right:auto;margin-top:0;margin-bottom:0;max-width:62.5em;*zoom:1;position:relative;padding-left:.9375em;padding-right:.9375em}

  140. #header:before,#header:after,#content:before,#content:after,#footnotes:before,#footnotes:after,#footer:before,#footer:after{content:" ";display:table}

  141. #header:after,#content:after,#footnotes:after,#footer:after{clear:both}

  142. #content{margin-top:1.25em}

  143. #content:before{content:none}

  144. #header>h1:first-child{color:rgba(0,0,0,.85);margin-top:2.25rem;margin-bottom:0}

  145. #header>h1:first-child+#toc{margin-top:8px;border-top:1px solid #ddddd8}

  146. #header>h1:only-child,body.toc2 #header>h1:nth-last-child(2){border-bottom:1px solid #ddddd8;padding-bottom:8px}

  147. #header .details{border-bottom:1px solid #ddddd8;line-height:1.45;padding-top:.25em;padding-bottom:.25em;padding-left:.25em;color:rgba(0,0,0,.6);display:-ms-flexbox;display:-webkit-flex;display:flex;-ms-flex-flow:row wrap;-webkit-flex-flow:row wrap;flex-flow:row wrap}

  148. #header .details span:first-child{margin-left:-.125em}

  149. #header .details span.email a{color:rgba(0,0,0,.85)}

  150. #header .details br{display:none}

  151. #header .details br+span:before{content:"\00a0\2013\00a0"}

  152. #header .details br+span.author:before{content:"\00a0\22c5\00a0";color:rgba(0,0,0,.85)}

  153. #header .details br+span#revremark:before{content:"\00a0|\00a0"}

  154. #header #revnumber{text-transform:capitalize}

  155. #header #revnumber:after{content:"\00a0"}

  156. #content>h1:first-child:not([class]){color:rgba(0,0,0,.85);border-bottom:1px solid #ddddd8;padding-bottom:8px;margin-top:0;padding-top:1rem;margin-bottom:1.25rem}

  157. #toc{border-bottom:1px solid #efefed;padding-bottom:.5em}

  158. #toc>ul{margin-left:.125em}

  159. #toc ul.sectlevel0>li>a{font-style:italic}

  160. #toc ul.sectlevel0 ul.sectlevel1{margin:.5em 0}

  161. #toc ul{font-family:"Open Sans","DejaVu Sans",sans-serif;list-style-type:none}

  162. #toc li{line-height:1.3334;margin-top:.3334em}

  163. #toc a{text-decoration:none}

  164. #toc a:active{text-decoration:underline}

  165. #toctitle{color:#7a2518;font-size:1.2em}

  166. @media only screen and (min-width:768px){#toctitle{font-size:1.375em}

  167. body.toc2{padding-left:15em;padding-right:0}

  168. #toc.toc2{margin-top:0!important;background-color:#f8f8f7;position:fixed;width:15em;left:0;top:0;border-right:1px solid #efefed;border-top-width:0!important;border-bottom-width:0!important;z-index:1000;padding:1.25em 1em;height:100%;overflow:auto}

  169. #toc.toc2 #toctitle{margin-top:0;margin-bottom:.8rem;font-size:1.2em}

  170. #toc.toc2>ul{font-size:.9em;margin-bottom:0}

  171. #toc.toc2 ul ul{margin-left:0;padding-left:1em}

  172. #toc.toc2 ul.sectlevel0 ul.sectlevel1{padding-left:0;margin-top:.5em;margin-bottom:.5em}

  173. body.toc2.toc-right{padding-left:0;padding-right:15em}

  174. body.toc2.toc-right #toc.toc2{border-right-width:0;border-left:1px solid #efefed;left:auto;right:0}}

  175. @media only screen and (min-width:1280px){body.toc2{padding-left:20em;padding-right:0}

  176. #toc.toc2{width:20em}

  177. #toc.toc2 #toctitle{font-size:1.375em}

  178. #toc.toc2>ul{font-size:.95em}

  179. #toc.toc2 ul ul{padding-left:1.25em}

  180. body.toc2.toc-right{padding-left:0;padding-right:20em}}

  181. #content #toc{border-style:solid;border-width:1px;border-color:#e0e0dc;margin-bottom:1.25em;padding:1.25em;background:#f8f8f7;-webkit-border-radius:4px;border-radius:4px}

  182. #content #toc>:first-child{margin-top:0}

  183. #content #toc>:last-child{margin-bottom:0}

  184. #footer{max-width:100%;background-color:rgba(0,0,0,.8);padding:1.25em}

  185. #footer-text{color:rgba(255,255,255,.8);line-height:1.44}

  186. .sect1{padding-bottom:.625em}

  187. @media only screen and (min-width:768px){.sect1{padding-bottom:1.25em}}

  188. .sect1+.sect1{border-top:1px solid #efefed}

  189. #content h1>a.anchor,h2>a.anchor,h3>a.anchor,#toctitle>a.anchor,.sidebarblock>.content>.title>a.anchor,h4>a.anchor,h5>a.anchor,h6>a.anchor{position:absolute;z-index:1001;width:1.5ex;margin-left:-1.5ex;display:block;text-decoration:none!important;visibility:hidden;text-align:center;font-weight:400}

  190. #content h1>a.anchor:before,h2>a.anchor:before,h3>a.anchor:before,#toctitle>a.anchor:before,.sidebarblock>.content>.title>a.anchor:before,h4>a.anchor:before,h5>a.anchor:before,h6>a.anchor:before{content:"\00A7";font-size:.85em;display:block;padding-top:.1em}

  191. #content h1:hover>a.anchor,#content h1>a.anchor:hover,h2:hover>a.anchor,h2>a.anchor:hover,h3:hover>a.anchor,#toctitle:hover>a.anchor,.sidebarblock>.content>.title:hover>a.anchor,h3>a.anchor:hover,#toctitle>a.anchor:hover,.sidebarblock>.content>.title>a.anchor:hover,h4:hover>a.anchor,h4>a.anchor:hover,h5:hover>a.anchor,h5>a.anchor:hover,h6:hover>a.anchor,h6>a.anchor:hover{visibility:visible}

  192. #content h1>a.link,h2>a.link,h3>a.link,#toctitle>a.link,.sidebarblock>.content>.title>a.link,h4>a.link,h5>a.link,h6>a.link{color:#ba3925;text-decoration:none}

  193. #content h1>a.link:hover,h2>a.link:hover,h3>a.link:hover,#toctitle>a.link:hover,.sidebarblock>.content>.title>a.link:hover,h4>a.link:hover,h5>a.link:hover,h6>a.link:hover{color:#a53221}

  194. .audioblock,.imageblock,.literalblock,.listingblock,.stemblock,.videoblock{margin-bottom:1.25em}

  195. .admonitionblock td.content>.title,.audioblock>.title,.exampleblock>.title,.imageblock>.title,.listingblock>.title,.literalblock>.title,.stemblock>.title,.openblock>.title,.paragraph>.title,.quoteblock>.title,table.tableblock>.title,.verseblock>.title,.videoblock>.title,.dlist>.title,.olist>.title,.ulist>.title,.qlist>.title,.hdlist>.title{text-rendering:optimizeLegibility;text-align:left;font-family:"Noto Serif","DejaVu Serif",serif;font-size:1rem;font-style:italic}

  196. table.tableblock>caption.title{white-space:nowrap;overflow:visible;max-width:0}

  197. .paragraph.lead>p,#preamble>.sectionbody>.paragraph:first-of-type p{color:rgba(0,0,0,.85)}

  198. table.tableblock #preamble>.sectionbody>.paragraph:first-of-type p{font-size:inherit}

  199. .admonitionblock>table{border-collapse:separate;border:0;background:none;width:100%}

  200. .admonitionblock>table td.icon{text-align:center;width:80px}

  201. .admonitionblock>table td.icon img{max-width:none}

  202. .admonitionblock>table td.icon .title{font-weight:bold;font-family:"Open Sans","DejaVu Sans",sans-serif;text-transform:uppercase}

  203. .admonitionblock>table td.content{padding-left:1.125em;padding-right:1.25em;border-left:1px solid #ddddd8;color:rgba(0,0,0,.6)}

  204. .admonitionblock>table td.content>:last-child>:last-child{margin-bottom:0}

  205. .exampleblock>.content{border-style:solid;border-width:1px;border-color:#e6e6e6;margin-bottom:1.25em;padding:1.25em;background:#fff;-webkit-border-radius:4px;border-radius:4px}

  206. .exampleblock>.content>:first-child{margin-top:0}

  207. .exampleblock>.content>:last-child{margin-bottom:0}

  208. .sidebarblock{border-style:solid;border-width:1px;border-color:#e0e0dc;margin-bottom:1.25em;padding:1.25em;background:#f8f8f7;-webkit-border-radius:4px;border-radius:4px}

  209. .sidebarblock>:first-child{margin-top:0}

  210. .sidebarblock>:last-child{margin-bottom:0}

  211. .sidebarblock>.content>.title{color:#7a2518;margin-top:0;text-align:center}

  212. .exampleblock>.content>:last-child>:last-child,.exampleblock>.content .olist>ol>li:last-child>:last-child,.exampleblock>.content .ulist>ul>li:last-child>:last-child,.exampleblock>.content .qlist>ol>li:last-child>:last-child,.sidebarblock>.content>:last-child>:last-child,.sidebarblock>.content .olist>ol>li:last-child>:last-child,.sidebarblock>.content .ulist>ul>li:last-child>:last-child,.sidebarblock>.content .qlist>ol>li:last-child>:last-child{margin-bottom:0}

  213. .literalblock pre,.listingblock pre:not(.highlight),.listingblock pre[class="highlight"],.listingblock pre[class^="highlight "],.listingblock pre.CodeRay,.listingblock pre.prettyprint{background:#f7f7f8}

  214. .sidebarblock .literalblock pre,.sidebarblock .listingblock pre:not(.highlight),.sidebarblock .listingblock pre[class="highlight"],.sidebarblock .listingblock pre[class^="highlight "],.sidebarblock .listingblock pre.CodeRay,.sidebarblock .listingblock pre.prettyprint{background:#f2f1f1}

  215. .literalblock pre,.literalblock pre[class],.listingblock pre,.listingblock pre[class]{-webkit-border-radius:4px;border-radius:4px;word-wrap:break-word;padding:1em;font-size:.8125em}

  216. .literalblock pre.nowrap,.literalblock pre[class].nowrap,.listingblock pre.nowrap,.listingblock pre[class].nowrap{overflow-x:auto;white-space:pre;word-wrap:normal}

  217. @media only screen and (min-width:768px){.literalblock pre,.literalblock pre[class],.listingblock pre,.listingblock pre[class]{font-size:.90625em}}

  218. @media only screen and (min-width:1280px){.literalblock pre,.literalblock pre[class],.listingblock pre,.listingblock pre[class]{font-size:1em}}

  219. .literalblock.output pre{color:#f7f7f8;background-color:rgba(0,0,0,.9)}

  220. .listingblock pre.highlightjs{padding:0}

  221. .listingblock pre.highlightjs>code{padding:1em;-webkit-border-radius:4px;border-radius:4px}

  222. .listingblock pre.prettyprint{border-width:0}

  223. .listingblock>.content{position:relative}

  224. .listingblock code[data-lang]:before{display:none;content:attr(data-lang);position:absolute;font-size:.75em;top:.425rem;right:.5rem;line-height:1;text-transform:uppercase;color:#999}

  225. .listingblock:hover code[data-lang]:before{display:block}

  226. .listingblock.terminal pre .command:before{content:attr(data-prompt);padding-right:.5em;color:#999}

  227. .listingblock.terminal pre .command:not([data-prompt]):before{content:"$"}

  228. table.pyhltable{border-collapse:separate;border:0;margin-bottom:0;background:none}

  229. table.pyhltable td{vertical-align:top;padding-top:0;padding-bottom:0;line-height:1.45}

  230. table.pyhltable td.code{padding-left:.75em;padding-right:0}

  231. pre.pygments .lineno,table.pyhltable td:not(.code){color:#999;padding-left:0;padding-right:.5em;border-right:1px solid #ddddd8}

  232. pre.pygments .lineno{display:inline-block;margin-right:.25em}

  233. table.pyhltable .linenodiv{background:none!important;padding-right:0!important}

  234. .quoteblock{margin:0 1em 1.25em 1.5em;display:table}

  235. .quoteblock>.title{margin-left:-1.5em;margin-bottom:.75em}

  236. .quoteblock blockquote,.quoteblock blockquote p{color:rgba(0,0,0,.85);font-size:1.15rem;line-height:1.75;word-spacing:.1em;letter-spacing:0;font-style:italic;text-align:justify}

  237. .quoteblock blockquote{margin:0;padding:0;border:0}

  238. .quoteblock blockquote:before{content:"\201c";float:left;font-size:2.75em;font-weight:bold;line-height:.6em;margin-left:-.6em;color:#7a2518;text-shadow:0 1px 2px rgba(0,0,0,.1)}

  239. .quoteblock blockquote>.paragraph:last-child p{margin-bottom:0}

  240. .quoteblock .attribution{margin-top:.5em;margin-right:.5ex;text-align:right}

  241. .quoteblock .quoteblock{margin-left:0;margin-right:0;padding:.5em 0;border-left:3px solid rgba(0,0,0,.6)}

  242. .quoteblock .quoteblock blockquote{padding:0 0 0 .75em}

  243. .quoteblock .quoteblock blockquote:before{display:none}

  244. .verseblock{margin:0 1em 1.25em 1em}

  245. .verseblock pre{font-family:"Open Sans","DejaVu Sans",sans;font-size:1.15rem;color:rgba(0,0,0,.85);font-weight:300;text-rendering:optimizeLegibility}

  246. .verseblock pre strong{font-weight:400}

  247. .verseblock .attribution{margin-top:1.25rem;margin-left:.5ex}

  248. .quoteblock .attribution,.verseblock .attribution{font-size:.9375em;line-height:1.45;font-style:italic}

  249. .quoteblock .attribution br,.verseblock .attribution br{display:none}

  250. .quoteblock .attribution cite,.verseblock .attribution cite{display:block;letter-spacing:-.025em;color:rgba(0,0,0,.6)}

  251. .quoteblock.abstract{margin:0 0 1.25em 0;display:block}

  252. .quoteblock.abstract blockquote,.quoteblock.abstract blockquote p{text-align:left;word-spacing:0}

  253. .quoteblock.abstract blockquote:before,.quoteblock.abstract blockquote p:first-of-type:before{display:none}

  254. table.tableblock{max-width:100%;border-collapse:separate}

  255. table.tableblock td>.paragraph:last-child p>p:last-child,table.tableblock th>p:last-child,table.tableblock td>p:last-child{margin-bottom:0}

  256. table.tableblock,th.tableblock,td.tableblock{border:0 solid #dedede}

  257. table.grid-all th.tableblock,table.grid-all td.tableblock{border-width:0 1px 1px 0}

  258. table.grid-all tfoot>tr>th.tableblock,table.grid-all tfoot>tr>td.tableblock{border-width:1px 1px 0 0}

  259. table.grid-cols th.tableblock,table.grid-cols td.tableblock{border-width:0 1px 0 0}

  260. table.grid-all *>tr>.tableblock:last-child,table.grid-cols *>tr>.tableblock:last-child{border-right-width:0}

  261. table.grid-rows th.tableblock,table.grid-rows td.tableblock{border-width:0 0 1px 0}

  262. table.grid-all tbody>tr:last-child>th.tableblock,table.grid-all tbody>tr:last-child>td.tableblock,table.grid-all thead:last-child>tr>th.tableblock,table.grid-rows tbody>tr:last-child>th.tableblock,table.grid-rows tbody>tr:last-child>td.tableblock,table.grid-rows thead:last-child>tr>th.tableblock{border-bottom-width:0}

  263. table.grid-rows tfoot>tr>th.tableblock,table.grid-rows tfoot>tr>td.tableblock{border-width:1px 0 0 0}

  264. table.frame-all{border-width:1px}

  265. table.frame-sides{border-width:0 1px}

  266. table.frame-topbot{border-width:1px 0}

  267. th.halign-left,td.halign-left{text-align:left}

  268. th.halign-right,td.halign-right{text-align:right}

  269. th.halign-center,td.halign-center{text-align:center}

  270. th.valign-top,td.valign-top{vertical-align:top}

  271. th.valign-bottom,td.valign-bottom{vertical-align:bottom}

  272. th.valign-middle,td.valign-middle{vertical-align:middle}

  273. table thead th,table tfoot th{font-weight:bold}

  274. tbody tr th{display:table-cell;line-height:1.6;background:#f7f8f7}

  275. tbody tr th,tbody tr th p,tfoot tr th,tfoot tr th p{color:rgba(0,0,0,.8);font-weight:bold}

  276. p.tableblock>code:only-child{background:none;padding:0}

  277. p.tableblock{font-size:1em}

  278. td>div.verse{white-space:pre}

  279. ol{margin-left:1.75em}

  280. ul li ol{margin-left:1.5em}

  281. dl dd{margin-left:1.125em}

  282. dl dd:last-child,dl dd:last-child>:last-child{margin-bottom:0}

  283. ol>li p,ul>li p,ul dd,ol dd,.olist .olist,.ulist .ulist,.ulist .olist,.olist .ulist{margin-bottom:.625em}

  284. ul.unstyled,ol.unnumbered,ul.checklist,ul.none{list-style-type:none}

  285. ul.unstyled,ol.unnumbered,ul.checklist{margin-left:.625em}

  286. ul.checklist li>p:first-child>.fa-square-o:first-child,ul.checklist li>p:first-child>.fa-check-square-o:first-child{width:1em;font-size:.85em}

  287. ul.checklist li>p:first-child>input[type="checkbox"]:first-child{width:1em;position:relative;top:1px}

  288. ul.inline{margin:0 auto .625em auto;margin-left:-1.375em;margin-right:0;padding:0;list-style:none;overflow:hidden}

  289. ul.inline>li{list-style:none;float:left;margin-left:1.375em;display:block}

  290. ul.inline>li>*{display:block}

  291. .unstyled dl dt{font-weight:400;font-style:normal}

  292. ol.arabic{list-style-type:decimal}

  293. ol.decimal{list-style-type:decimal-leading-zero}

  294. ol.loweralpha{list-style-type:lower-alpha}

  295. ol.upperalpha{list-style-type:upper-alpha}

  296. ol.lowerroman{list-style-type:lower-roman}

  297. ol.upperroman{list-style-type:upper-roman}

  298. ol.lowergreek{list-style-type:lower-greek}

  299. .hdlist>table,.colist>table{border:0;background:none}

  300. .hdlist>table>tbody>tr,.colist>table>tbody>tr{background:none}

  301. td.hdlist1,td.hdlist2{vertical-align:top;padding:0 .625em}

  302. td.hdlist1{font-weight:bold;padding-bottom:1.25em}

  303. .literalblock+.colist,.listingblock+.colist{margin-top:-.5em}

  304. .colist>table tr>td:first-of-type{padding:0 .75em;line-height:1}

  305. .colist>table tr>td:last-of-type{padding:.25em 0}

  306. .thumb,.th{line-height:0;display:inline-block;border:solid 4px #fff;-webkit-box-shadow:0 0 0 1px #ddd;box-shadow:0 0 0 1px #ddd}

  307. .imageblock.left,.imageblock[style*="float: left"]{margin:.25em .625em 1.25em 0}

  308. .imageblock.right,.imageblock[style*="float: right"]{margin:.25em 0 1.25em .625em}

  309. .imageblock>.title{margin-bottom:0}

  310. .imageblock.thumb,.imageblock.th{border-width:6px}

  311. .imageblock.thumb>.title,.imageblock.th>.title{padding:0 .125em}

  312. .image.left,.image.right{margin-top:.25em;margin-bottom:.25em;display:inline-block;line-height:0}

  313. .image.left{margin-right:.625em}

  314. .image.right{margin-left:.625em}

  315. a.image{text-decoration:none;display:inline-block}

  316. a.image object{pointer-events:none}

  317. sup.footnote,sup.footnoteref{font-size:.875em;position:static;vertical-align:super}

  318. sup.footnote a,sup.footnoteref a{text-decoration:none}

  319. sup.footnote a:active,sup.footnoteref a:active{text-decoration:underline}

  320. #footnotes{padding-top:.75em;padding-bottom:.75em;margin-bottom:.625em}

  321. #footnotes hr{width:20%;min-width:6.25em;margin:-.25em 0 .75em 0;border-width:1px 0 0 0}

  322. #footnotes .footnote{padding:0 .375em 0 .225em;line-height:1.3334;font-size:.875em;margin-left:1.2em;text-indent:-1.05em;margin-bottom:.2em}

  323. #footnotes .footnote a:first-of-type{font-weight:bold;text-decoration:none}

  324. #footnotes .footnote:last-of-type{margin-bottom:0}

  325. #content #footnotes{margin-top:-.625em;margin-bottom:0;padding:.75em 0}

  326. .gist .file-data>table{border:0;background:#fff;width:100%;margin-bottom:0}

  327. .gist .file-data>table td.line-data{width:99%}

  328. div.unbreakable{page-break-inside:avoid}

  329. .big{font-size:larger}

  330. .small{font-size:smaller}

  331. .underline{text-decoration:underline}

  332. .overline{text-decoration:overline}

  333. .line-through{text-decoration:line-through}

  334. .aqua{color:#00bfbf}

  335. .aqua-background{background-color:#00fafa}

  336. .black{color:#000}

  337. .black-background{background-color:#000}

  338. .blue{color:#0000bf}

  339. .blue-background{background-color:#0000fa}

  340. .fuchsia{color:#bf00bf}

  341. .fuchsia-background{background-color:#fa00fa}

  342. .gray{color:#606060}

  343. .gray-background{background-color:#7d7d7d}

  344. .green{color:#006000}

  345. .green-background{background-color:#007d00}

  346. .lime{color:#00bf00}

  347. .lime-background{background-color:#00fa00}

  348. .maroon{color:#600000}

  349. .maroon-background{background-color:#7d0000}

  350. .navy{color:#000060}

  351. .navy-background{background-color:#00007d}

  352. .olive{color:#606000}

  353. .olive-background{background-color:#7d7d00}

  354. .purple{color:#600060}

  355. .purple-background{background-color:#7d007d}

  356. .red{color:#bf0000}

  357. .red-background{background-color:#fa0000}

  358. .silver{color:#909090}

  359. .silver-background{background-color:#bcbcbc}

  360. .teal{color:#006060}

  361. .teal-background{background-color:#007d7d}

  362. .white{color:#bfbfbf}

  363. .white-background{background-color:#fafafa}

  364. .yellow{color:#bfbf00}

  365. .yellow-background{background-color:#fafa00}

  366. span.icon>.fa{cursor:default}

  367. .admonitionblock td.icon [class^="fa icon-"]{font-size:2.5em;text-shadow:1px 1px 2px rgba(0,0,0,.5);cursor:default}

  368. .admonitionblock td.icon .icon-note:before{content:"\f05a";color:#19407c}

  369. .admonitionblock td.icon .icon-tip:before{content:"\f0eb";text-shadow:1px 1px 2px rgba(155,155,0,.8);color:#111}

  370. .admonitionblock td.icon .icon-warning:before{content:"\f071";color:#bf6900}

  371. .admonitionblock td.icon .icon-caution:before{content:"\f06d";color:#bf3400}

  372. .admonitionblock td.icon .icon-important:before{content:"\f06a";color:#bf0000}

  373. .conum[data-value]{display:inline-block;color:#fff!important;background-color:rgba(0,0,0,.8);-webkit-border-radius:100px;border-radius:100px;text-align:center;font-size:.75em;width:1.67em;height:1.67em;line-height:1.67em;font-family:"Open Sans","DejaVu Sans",sans-serif;font-style:normal;font-weight:bold}

  374. .conum[data-value] *{color:#fff!important}

  375. .conum[data-value]+b{display:none}

  376. .conum[data-value]:after{content:attr(data-value)}

  377. pre .conum[data-value]{position:relative;top:-.125em}

  378. b.conum *{color:inherit!important}

  379. .conum:not([data-value]):empty{display:none}

  380. dt,th.tableblock,td.content,div.footnote{text-rendering:optimizeLegibility}

  381. h1,h2,p,td.content,span.alt{letter-spacing:-.01em}

  382. p strong,td.content strong,div.footnote strong{letter-spacing:-.005em}

  383. p,blockquote,dt,td.content,span.alt{font-size:1.0625rem}

  384. p{margin-bottom:1.25rem}

  385. .sidebarblock p,.sidebarblock dt,.sidebarblock td.content,p.tableblock{font-size:1em}

  386. .exampleblock>.content{background-color:#fffef7;border-color:#e0e0dc;-webkit-box-shadow:0 1px 4px #e0e0dc;box-shadow:0 1px 4px #e0e0dc}

  387. .print-only{display:none!important}

  388. @media print{@page{margin:1.25cm .75cm}

  389. *{-webkit-box-shadow:none!important;box-shadow:none!important;text-shadow:none!important}

  390. a{color:inherit!important;text-decoration:underline!important}

  391. a.bare,a[href^="#"],a[href^="mailto:"]{text-decoration:none!important}

  392. a[href^="http:"]:not(.bare):after,a[href^="https:"]:not(.bare):after{content:"(" attr(href) ")";display:inline-block;font-size:.875em;padding-left:.25em}

  393. abbr[title]:after{content:" (" attr(title) ")"}

  394. pre,blockquote,tr,img,object,svg{page-break-inside:avoid}

  395. thead{display:table-header-group}

  396. svg{max-width:100%}

  397. p,blockquote,dt,td.content{font-size:1em;orphans:3;widows:3}

  398. h2,h3,#toctitle,.sidebarblock>.content>.title{page-break-after:avoid}

  399. #toc,.sidebarblock,.exampleblock>.content{background:none!important}

  400. #toc{border-bottom:1px solid #ddddd8!important;padding-bottom:0!important}

  401. .sect1{padding-bottom:0!important}

  402. .sect1+.sect1{border:0!important}

  403. #header>h1:first-child{margin-top:1.25rem}

  404. body.book #header{text-align:center}

  405. body.book #header>h1:first-child{border:0!important;margin:2.5em 0 1em 0}

  406. body.book #header .details{border:0!important;display:block;padding:0!important}

  407. body.book #header .details span:first-child{margin-left:0!important}

  408. body.book #header .details br{display:block}

  409. body.book #header .details br+span:before{content:none!important}

  410. body.book #toc{border:0!important;text-align:left!important;padding:0!important;margin:0!important}

  411. body.book #toc,body.book #preamble,body.book h1.sect0,body.book .sect1>h2{page-break-before:always}

  412. .listingblock code[data-lang]:before{display:block}

  413. #footer{background:none!important;padding:0 .9375em}

  414. #footer-text{color:rgba(0,0,0,.6)!important;font-size:.9em}

  415. .hide-on-print{display:none!important}

  416. .print-only{display:block!important}

  417. .hide-for-print{display:none!important}

  418. .show-for-print{display:inherit!important}}

  419. </style>

  420. <style>

  421. /* Stylesheet for CodeRay to match GitHub theme | MIT License | http://foundation.zurb.com */

  422. /*pre.CodeRay {background-color:#f7f7f8;}*/

  423. .CodeRay .line-numbers{border-right:1px solid #d8d8d8;padding:0 0.5em 0 .25em}

  424. .CodeRay span.line-numbers{display:inline-block;margin-right:.5em;color:rgba(0,0,0,.3)}

  425. .CodeRay .line-numbers strong{color:rgba(0,0,0,.4)}

  426. table.CodeRay{border-collapse:separate;border-spacing:0;margin-bottom:0;border:0;background:none}

  427. table.CodeRay td{vertical-align: top;line-height:1.45}

  428. table.CodeRay td.line-numbers{text-align:right}

  429. table.CodeRay td.line-numbers>pre{padding:0;color:rgba(0,0,0,.3)}

  430. table.CodeRay td.code{padding:0 0 0 .5em}

  431. table.CodeRay td.code>pre{padding:0}

  432. .CodeRay .debug{color:#fff !important;background:#000080 !important}

  433. .CodeRay .annotation{color:#007}

  434. .CodeRay .attribute-name{color:#000080}

  435. .CodeRay .attribute-value{color:#700}

  436. .CodeRay .binary{color:#509}

  437. .CodeRay .comment{color:#998;font-style:italic}

  438. .CodeRay .char{color:#04d}

  439. .CodeRay .char .content{color:#04d}

  440. .CodeRay .char .delimiter{color:#039}

  441. .CodeRay .class{color:#458;font-weight:bold}

  442. .CodeRay .complex{color:#a08}

  443. .CodeRay .constant,.CodeRay .predefined-constant{color:#008080}

  444. .CodeRay .color{color:#099}

  445. .CodeRay .class-variable{color:#369}

  446. .CodeRay .decorator{color:#b0b}

  447. .CodeRay .definition{color:#099}

  448. .CodeRay .delimiter{color:#000}

  449. .CodeRay .doc{color:#970}

  450. .CodeRay .doctype{color:#34b}

  451. .CodeRay .doc-string{color:#d42}

  452. .CodeRay .escape{color:#666}

  453. .CodeRay .entity{color:#800}

  454. .CodeRay .error{color:#808}

  455. .CodeRay .exception{color:inherit}

  456. .CodeRay .filename{color:#099}

  457. .CodeRay .function{color:#900;font-weight:bold}

  458. .CodeRay .global-variable{color:#008080}

  459. .CodeRay .hex{color:#058}

  460. .CodeRay .integer,.CodeRay .float{color:#099}

  461. .CodeRay .include{color:#555}

  462. .CodeRay .inline{color:#000}

  463. .CodeRay .inline .inline{background:#ccc}

  464. .CodeRay .inline .inline .inline{background:#bbb}

  465. .CodeRay .inline .inline-delimiter{color:#d14}

  466. .CodeRay .inline-delimiter{color:#d14}

  467. .CodeRay .important{color:#555;font-weight:bold}

  468. .CodeRay .interpreted{color:#b2b}

  469. .CodeRay .instance-variable{color:#008080}

  470. .CodeRay .label{color:#970}

  471. .CodeRay .local-variable{color:#963}

  472. .CodeRay .octal{color:#40e}

  473. .CodeRay .predefined{color:#369}

  474. .CodeRay .preprocessor{color:#579}

  475. .CodeRay .pseudo-class{color:#555}

  476. .CodeRay .directive{font-weight:bold}

  477. .CodeRay .type{font-weight:bold}

  478. .CodeRay .predefined-type{color:inherit}

  479. .CodeRay .reserved,.CodeRay .keyword {color:#000;font-weight:bold}

  480. .CodeRay .key{color:#808}

  481. .CodeRay .key .delimiter{color:#606}

  482. .CodeRay .key .char{color:#80f}

  483. .CodeRay .value{color:#088}

  484. .CodeRay .regexp .delimiter{color:#808}

  485. .CodeRay .regexp .content{color:#808}

  486. .CodeRay .regexp .modifier{color:#808}

  487. .CodeRay .regexp .char{color:#d14}

  488. .CodeRay .regexp .function{color:#404;font-weight:bold}

  489. .CodeRay .string{color:#d20}

  490. .CodeRay .string .string .string{background:#ffd0d0}

  491. .CodeRay .string .content{color:#d14}

  492. .CodeRay .string .char{color:#d14}

  493. .CodeRay .string .delimiter{color:#d14}

  494. .CodeRay .shell{color:#d14}

  495. .CodeRay .shell .delimiter{color:#d14}

  496. .CodeRay .symbol{color:#990073}

  497. .CodeRay .symbol .content{color:#a60}

  498. .CodeRay .symbol .delimiter{color:#630}

  499. .CodeRay .tag{color:#008080}

  500. .CodeRay .tag-special{color:#d70}

  501. .CodeRay .variable{color:#036}

  502. .CodeRay .insert{background:#afa}

  503. .CodeRay .delete{background:#faa}

  504. .CodeRay .change{color:#aaf;background:#007}

  505. .CodeRay .head{color:#f8f;background:#505}

  506. .CodeRay .insert .insert{color:#080}

  507. .CodeRay .delete .delete{color:#800}

  508. .CodeRay .change .change{color:#66f}

  509. .CodeRay .head .head{color:#f4f}

  510. </style>

  511. <link rel="stylesheet"

  512.     href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"

  513.     integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u"

  514.     crossorigin="anonymous">

  515. <link rel="stylesheet"

  516.     href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css"

  517.     integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp"

  518.     crossorigin="anonymous">

  519. 

  520. <style>

  521.     .c2cb{

  522.         position: absolute; left: 0; top: 0;

  523.         cursor: pointer

  524.     }

  525.     .c2cb:focus {

  526.         outline: none;

  527.     }

  528.     body {

  529.         font-size: 18px;

  530.     }

  531. 

  532.     p {

  533.         font-size: 18px;

  534.     }

  535. 

  536.     td.content {

  537.         font-size:2.0625rem;

  538.     }

  539. 

  540.     div.title {

  541.         font-size:2.0625rem;

  542.     }

  543. </style>

  544. 

  545. <script src="js/jquery-3.2.1.min.js"></script>

  546. <script src="https://cdnjs.cloudflare.com/ajax/libs/clipboard.js/1.7.1/clipboard.min.js"></script>

  547. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>

  548. <script>

  549. 

  550.     $(function() {

  551.         var button = $("<div style='padding: 10px;'><button data-toggle='tooltip' placement='right' data-trigger='click' title='Copied!'  class='c2cb glyphicon glyphicon-copy'></button></div>");

  552.         $(".listingblock > .content pre").prepend(button);

  553. 

  554.         $('[data-toggle="tooltip"]').tooltip();

  555. 

  556.         $('[data-toggle="tooltip"]').mouseout(function() {

  557.             $(this).tooltip('hide');

  558.             $(this).trigger('blur');

  559.         });

  560. 

  561.         var clipboard = new Clipboard('.c2cb', {

  562.             target: function(c2cb) {

  563.                         return $(c2cb).parent().siblings("code")[0];

  564.                     }

  565.                 });

  566.             clipboard.on('success', function(e) {

  567.                 e.clearSelection();

  568.             });

  569.     });

  570. 

  571. </script>

  572. </head>

  573. <body class="article toc2 toc-left">

  574. <div id="header">

  575. <h1><a id="spring-boot-data"></a>Spring Boot Data</h1>

  576. <div id="toc" class="toc2">

  577. <div id="toctitle">Labs</div>

  578. <ul class="sectlevel1">

  579. <li><a href="#_code_snippet_manager_jdbc">Code Snippet Manager JDBC</a>

  580. <ul class="sectlevel2">

  581. <li><a href="#_challenges">Challenges</a></li>

  582. </ul>

  583. </li>

  584. <li><a href="#_code_snippet_manager_jpa">Code Snippet Manager JPA</a>

  585. <ul class="sectlevel2">

  586. <li><a href="#_challenges_2">Challenges</a></li>

  587. </ul>

  588. </li>

  589. <li><a href="#_code_snippet_manager_jpa_rest">Code Snippet Manager JPA REST</a>

  590. <ul class="sectlevel2">

  591. <li><a href="#_challenges_3">Challenges</a></li>

  592. </ul>

  593. </li>

  594. <li><a href="#_homework">HOMEWORK</a></li>

  595. </ul>

  596. </div>

  597. </div>

  598. <div id="content">

  599. <div id="preamble">

  600. <div class="sectionbody">

  601. <div class="paragraph">

  602. <p>Get familiar with the <strong>Spring Data</strong> and the <strong>Spring Boot Data</strong> features.</p>

  603. </div>

  604. <div class="paragraph">

  605. <p><strong>Time:</strong> 60 minutes (20 minutes per section).</p>

  606. </div>

  607. <!-- toc disabled -->

  608. </div>

  609. </div>

  610. <div class="sect1">

  611. <h2 id="_code_snippet_manager_jdbc">Code Snippet Manager JDBC</h2>

  612. <div class="sectionbody">

  613. <div class="paragraph">

  614. <p>You will continue with the <strong>Code Snippet Manager</strong> code, but this time using a persistence engine. You will reuse the code from previous labs.</p>

  615. </div>

  616. <div class="olist arabic">

  617. <ol class="arabic">

  618. <li>

  619. <p>Open a browser and hit the url: <a href="http://start.spring.io" class="bare" target="_blank">http://start.spring.io</a></p>

  620. </li>

  621. <li>

  622. <p>Click the <strong><em>Switch to the full version</em></strong> link.</p>

  623. </li>

  624. <li>

  625. <p>Fill out the <strong>Code Snippet Manager JDBC</strong> Project metadata with (See Figure 1.0):</p>

  626. <table class="tableblock frame-all grid-all spread">

  627. <caption class="title">Table 1. Code Snippet Manager JDBC App - metadata</caption>

  628. <colgroup>

  629. <col style="width: 16.6666%;">

  630. <col style="width: 83.3334%;">

  631. </colgroup>

  632. <thead>

  633. <tr>

  634. <th class="tableblock halign-left valign-top">Property</th>

  635. <th class="tableblock halign-left valign-top">Value</th>

  636. </tr>

  637. </thead>

  638. <tbody>

  639. <tr>

  640. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Group</strong>:</p></td>

  641. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>io.pivotal.workshop</em></p></td>

  642. </tr>

  643. <tr>

  644. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Artifact</strong>:</p></td>

  645. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>code-snippet-manager-jdbc</em></p></td>

  646. </tr>

  647. <tr>

  648. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Name</strong>:</p></td>

  649. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>code-snippet-manager-jdbc</em></p></td>

  650. </tr>

  651. <tr>

  652. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Package Name</strong>:</p></td>

  653. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>io.pivotal.workshop.snippet</em></p></td>

  654. </tr>

  655. <tr>

  656. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Dependencies</strong>:</p></td>

  657. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>Web, DevTools, Groovy Templates, JDBC, H2, MySQL</em></p></td>

  658. </tr>

  659. <tr>

  660. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Spring Boot</strong>:</p></td>

  661. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>2.0.0.M7</em></p></td>

  662. </tr>

  663. </tbody>

  664. </table>

  665. <div class="paragraph">

  666. <div class="title">Figure 1.0: Spring Initializr - <a href="http://start.spring.io/" class="bare" target="_blank">http://start.spring.io/</a></div>

  667. <p><span class="image"><img src="images/06-spring-boot-data-01.png" alt="SpringInitializr" title="Spring Initializr"></span></p>

  668. </div>

  669. <div class="admonitionblock tip">

  670. <table>

  671. <tr>

  672. <td class="icon">

  673. <div class="title">Tip</div>

  674. </td>

  675. <td class="content">

  676. You can choose either <strong>Maven</strong> or <strong>Gradle</strong> project types.

  677. </td>

  678. </tr>

  679. </table>

  680. </div>

  681. </li>

  682. <li>

  683. <p>Type <strong>Web</strong>, <strong>DevTools</strong>, <strong>Groovy Templates</strong>, <strong>JDBC</strong>, <strong>H2</strong>, and <strong>MySQL</strong> in the <strong><em>Dependencies</em></strong> field and press Enter.</p>

  684. </li>

  685. <li>

  686. <p>Click the <strong><em>Generate Project</em></strong> button.</p>

  687. </li>

  688. <li>

  689. <p>Unzip the file in any directory you want.</p>

  690. </li>

  691. <li>

  692. <p>Import your project in any IDE you want.</p>

  693. </li>

  694. <li>

  695. <p>Copy all the packages (with code) into the new project.</p>

  696. </li>

  697. <li>

  698. <p>The classes in <strong>io.pivotal.workshop.snippet.domain</strong>: <strong><em>Code</em></strong>, <strong><em>Language</em></strong> and <strong><em>Snippet</em></strong> should be the same.</p>

  699. </li>

  700. <li>

  701. <p>Create a new class <strong>CrossSnippetLanguageCode</strong> in the <strong>domain</strong> package:</p>

  702. <div class="listingblock">

  703. <div class="content">

  704. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.domain</span>;

  705. 

  706. <span class="directive">public</span> <span class="type">class</span> <span class="class">CrossSnippetLanguageCode</span> {

  707. 

  708.         <span class="directive">private</span> <span class="predefined-type">String</span> snippetId;

  709.         <span class="directive">private</span> <span class="predefined-type">String</span> languageId;

  710.         <span class="directive">private</span> <span class="predefined-type">String</span> codeId;

  711. 

  712.         <span class="directive">public</span> CrossSnippetLanguageCode() {

  713.         }

  714. 

  715.         <span class="directive">public</span> CrossSnippetLanguageCode(<span class="predefined-type">String</span> snippetId, <span class="predefined-type">String</span> languageId, <span class="predefined-type">String</span> codeId) {

  716. 

  717.                 <span class="local-variable">this</span>.snippetId = snippetId;

  718.                 <span class="local-variable">this</span>.languageId = languageId;

  719.                 <span class="local-variable">this</span>.codeId = codeId;

  720.         }

  721. 

  722.         <span class="directive">public</span> <span class="predefined-type">String</span> getSnippetId() {

  723.                 <span class="keyword">return</span> snippetId;

  724.         }

  725. 

  726.         <span class="directive">public</span> <span class="type">void</span> setSnippetId(<span class="predefined-type">String</span> snippetId) {

  727.                 <span class="local-variable">this</span>.snippetId = snippetId;

  728.         }

  729. 

  730.         <span class="directive">public</span> <span class="predefined-type">String</span> getLanguageId() {

  731.                 <span class="keyword">return</span> languageId;

  732.         }

  733. 

  734.         <span class="directive">public</span> <span class="type">void</span> setLanguageId(<span class="predefined-type">String</span> languageId) {

  735.                 <span class="local-variable">this</span>.languageId = languageId;

  736.         }

  737. 

  738.         <span class="directive">public</span> <span class="predefined-type">String</span> getCodeId() {

  739.                 <span class="keyword">return</span> codeId;

  740.         }

  741. 

  742.         <span class="directive">public</span> <span class="type">void</span> setCodeId(<span class="predefined-type">String</span> codeId) {

  743.                 <span class="local-variable">this</span>.codeId = codeId;

  744.         }

  745. 

  746. }</code></pre>

  747. </div>

  748. </div>

  749. <div class="paragraph">

  750. <p>this class will hold the relationship between the <strong>Code</strong> and <strong>Language</strong> within the <strong>Snippet</strong> class.</p>

  751. </div>

  752. </li>

  753. <li>

  754. <p>Because you will reuse the <strong>SimpleRepository</strong> interface, is necessary modify all the implementations. Modify the code accordingly:</p>

  755. <div class="listingblock">

  756. <div class="title">io.pivotal.workshop.snippet.repository.LanguageRepository.java</div>

  757. <div class="content">

  758. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository</span>;

  759. 

  760. <span class="keyword">import</span> <span class="include">java.sql.PreparedStatement</span>;

  761. <span class="keyword">import</span> <span class="include">java.util.Collection</span>;

  762. 

  763. <span class="keyword">import</span> <span class="include">org.springframework.beans.factory.annotation.Autowired</span>;

  764. <span class="keyword">import</span> <span class="include">org.springframework.dao.EmptyResultDataAccessException</span>;

  765. <span class="keyword">import</span> <span class="include">org.springframework.jdbc.core.JdbcTemplate</span>;

  766. <span class="keyword">import</span> <span class="include">org.springframework.stereotype.Repository</span>;

  767. 

  768. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Language</span>;

  769. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.repository.mapper.LanguageRowMapper</span>;

  770. 

  771. <span class="annotation">@Repository</span>

  772. <span class="directive">public</span> <span class="type">class</span> <span class="class">LanguageRepository</span> <span class="directive">implements</span> SimpleRepository&lt;Language&gt;{

  773. 

  774.     <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_FIND_ALL = <span class="string"><span class="delimiter">&quot;</span><span class="content">select * from language</span><span class="delimiter">&quot;</span></span>;

  775.     <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_FIND_ONE = <span class="string"><span class="delimiter">&quot;</span><span class="content">select * from language where name = ?</span><span class="delimiter">&quot;</span></span>;

  776.     <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_INSERT = <span class="string"><span class="delimiter">&quot;</span><span class="content">insert into language(id,name,syntax) values(?,?,?)</span><span class="delimiter">&quot;</span></span>;

  777.     <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_UPDATE = <span class="string"><span class="delimiter">&quot;</span><span class="content">update language set name = ?, syntax = ? where id = ?</span><span class="delimiter">&quot;</span></span>;

  778. 

  779.     <span class="directive">private</span> JdbcTemplate jdbcTemplate;

  780. 

  781.     <span class="annotation">@Autowired</span>

  782.     <span class="directive">public</span> LanguageRepository(JdbcTemplate jdbcTemplate){

  783.                     <span class="local-variable">this</span>.jdbcTemplate = jdbcTemplate;

  784.     }

  785. 

  786.     <span class="annotation">@Override</span>

  787.         <span class="directive">public</span> <span class="predefined-type">Iterable</span>&lt;Language&gt; findAll(){

  788.                 <span class="keyword">return</span> <span class="local-variable">this</span>.jdbcTemplate.query(SQL_FIND_ALL, <span class="keyword">new</span> LanguageRowMapper());

  789.         }

  790. 

  791.     <span class="annotation">@Override</span>

  792.         <span class="directive">public</span> <span class="type">void</span> saveAll(<span class="predefined-type">Collection</span>&lt;Language&gt; languages){

  793.                 languages.forEach( lang -&gt; saveAll(lang) );

  794.         }

  795. 

  796.     <span class="annotation">@Override</span>

  797.         <span class="directive">public</span> Language findById(<span class="predefined-type">String</span> name) {

  798.                     <span class="keyword">try</span> {

  799.                             <span class="keyword">return</span> <span class="local-variable">this</span>.jdbcTemplate.queryForObject(SQL_FIND_ONE, <span class="keyword">new</span> <span class="predefined-type">Object</span><span class="type">[]</span>{name}, <span class="keyword">new</span> LanguageRowMapper());

  800.                 } <span class="keyword">catch</span> (EmptyResultDataAccessException ex){

  801.                             <span class="keyword">return</span> <span class="predefined-constant">null</span>;

  802.                     }

  803.         }

  804. 

  805.     <span class="annotation">@Override</span>

  806.         <span class="directive">public</span> Language saveAll(Language item) {

  807.                 <span class="keyword">assert</span> item.getName() != <span class="predefined-constant">null</span>;

  808. 

  809.                 Language language = <span class="local-variable">this</span>.findById(item.getName());

  810. 

  811.                 <span class="keyword">if</span>(language == <span class="predefined-constant">null</span>) {

  812.                         <span class="local-variable">this</span>.jdbcTemplate.update( psc -&gt; {

  813.                                 <span class="predefined-type">PreparedStatement</span> ps = psc.prepareStatement(SQL_INSERT);

  814.                                 ps.setString(<span class="integer">1</span>, item.getId());

  815.                                 ps.setString(<span class="integer">2</span>, item.getName());

  816.                                 ps.setString(<span class="integer">3</span>, item.getSyntax());

  817.                                 <span class="keyword">return</span> ps;

  818.                         });

  819.                         <span class="keyword">return</span> item;

  820.                 }<span class="keyword">else</span> {

  821.                         <span class="local-variable">this</span>.jdbcTemplate.update( psc -&gt; {

  822.                                 <span class="predefined-type">PreparedStatement</span> ps = psc.prepareStatement(SQL_UPDATE);

  823.                                 ps.setString(<span class="integer">1</span>, item.getName());

  824.                                 ps.setString(<span class="integer">2</span>, item.getSyntax());

  825.                                 ps.setString(<span class="integer">3</span>, item.getId());

  826.                                 <span class="keyword">return</span> ps;

  827.                         });

  828.                         <span class="keyword">return</span> language;

  829.                 }

  830.         }

  831. }</code></pre>

  832. </div>

  833. </div>

  834. <div class="listingblock">

  835. <div class="title">io.pivotal.workshop.snippet.repository.CodeRepository.java</div>

  836. <div class="content">

  837. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository</span>;

  838. 

  839. <span class="keyword">import</span> <span class="include">java.sql.PreparedStatement</span>;

  840. <span class="keyword">import</span> <span class="include">java.util.Collection</span>;

  841. <span class="keyword">import</span> <span class="include">java.util.List</span>;

  842. 

  843. <span class="keyword">import</span> <span class="include">org.springframework.beans.factory.annotation.Autowired</span>;

  844. <span class="keyword">import</span> <span class="include">org.springframework.dao.EmptyResultDataAccessException</span>;

  845. <span class="keyword">import</span> <span class="include">org.springframework.jdbc.core.JdbcTemplate</span>;

  846. <span class="keyword">import</span> <span class="include">org.springframework.stereotype.Repository</span>;

  847. 

  848. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Code</span>;

  849. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.repository.mapper.CodeRowMapper</span>;

  850. 

  851. <span class="annotation">@Repository</span>

  852. <span class="directive">public</span> <span class="type">class</span> <span class="class">CodeRepository</span> <span class="directive">implements</span> SimpleRepository&lt;Code&gt; {

  853. 

  854.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_FIND_ALL = <span class="string"><span class="delimiter">&quot;</span><span class="content">select * from code</span><span class="delimiter">&quot;</span></span>;

  855.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_FIND_ONE = <span class="string"><span class="delimiter">&quot;</span><span class="content">select * from code where id = ?</span><span class="delimiter">&quot;</span></span>;

  856.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_INSERT = <span class="string"><span class="delimiter">&quot;</span><span class="content">insert into code(id,source) values(?,?)</span><span class="delimiter">&quot;</span></span>;

  857.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_UPDATE = <span class="string"><span class="delimiter">&quot;</span><span class="content">update code set source = ? where id = ?</span><span class="delimiter">&quot;</span></span>;

  858. 

  859.         <span class="directive">private</span> JdbcTemplate jdbcTemplate;

  860. 

  861.         <span class="annotation">@Autowired</span>

  862.         <span class="directive">public</span> CodeRepository(JdbcTemplate jdbcTemplate) {

  863.                 <span class="local-variable">this</span>.jdbcTemplate = jdbcTemplate;

  864.         }

  865. 

  866.         <span class="annotation">@Override</span>

  867.         <span class="directive">public</span> <span class="predefined-type">List</span>&lt;Code&gt; findAll() {

  868.                 <span class="keyword">return</span> <span class="local-variable">this</span>.jdbcTemplate.query(SQL_FIND_ALL, <span class="keyword">new</span> CodeRowMapper());

  869.         }

  870. 

  871.         <span class="annotation">@Override</span>

  872.         <span class="directive">public</span> <span class="type">void</span> saveAll(<span class="predefined-type">Collection</span>&lt;Code&gt; items) {

  873.                 items.forEach(code -&gt; <span class="local-variable">this</span>.saveAll(code));

  874.         }

  875. 

  876.         <span class="annotation">@Override</span>

  877.         <span class="directive">public</span> Code findById(<span class="predefined-type">String</span> id) {

  878.                 <span class="keyword">try</span> {

  879.                         <span class="keyword">return</span> <span class="local-variable">this</span>.jdbcTemplate.queryForObject(SQL_FIND_ONE, <span class="keyword">new</span> <span class="predefined-type">Object</span><span class="type">[]</span> { id }, <span class="keyword">new</span> CodeRowMapper());

  880.                 } <span class="keyword">catch</span> (EmptyResultDataAccessException ex) {

  881.                         <span class="keyword">return</span> <span class="predefined-constant">null</span>;

  882.                 }

  883.         }

  884. 

  885.         <span class="annotation">@Override</span>

  886.         <span class="directive">public</span> Code saveAll(Code item) {

  887.                 <span class="keyword">assert</span> item.getSource() != <span class="predefined-constant">null</span>;

  888. 

  889.                 Code code = <span class="local-variable">this</span>.findById(item.getId());

  890. 

  891.                 <span class="keyword">if</span> (code == <span class="predefined-constant">null</span>) {

  892.                         <span class="local-variable">this</span>.jdbcTemplate.update(psc -&gt; {

  893.                                 <span class="predefined-type">PreparedStatement</span> ps = psc.prepareStatement(SQL_INSERT);

  894.                                 ps.setString(<span class="integer">1</span>, item.getId());

  895.                                 ps.setString(<span class="integer">2</span>, item.getSource());

  896.                                 <span class="keyword">return</span> ps;

  897.                         });

  898.                         <span class="keyword">return</span> item;

  899.                 } <span class="keyword">else</span> {

  900.                         <span class="local-variable">this</span>.jdbcTemplate.update(psc -&gt; {

  901.                                 <span class="predefined-type">PreparedStatement</span> ps = psc.prepareStatement(SQL_UPDATE);

  902.                                 ps.setString(<span class="integer">1</span>, item.getSource());

  903.                                 ps.setString(<span class="integer">2</span>, item.getId());

  904.                                 <span class="keyword">return</span> ps;

  905.                         });

  906.                         <span class="keyword">return</span> code;

  907.                 }

  908.         }

  909. 

  910. }</code></pre>

  911. </div>

  912. </div>

  913. <div class="listingblock">

  914. <div class="title">io.pivotal.workshop.snippet.repository.SnippetRepository.java</div>

  915. <div class="content">

  916. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository</span>;

  917. 

  918. <span class="keyword">import</span> <span class="include">java.sql.PreparedStatement</span>;

  919. <span class="keyword">import</span> <span class="include">java.text.SimpleDateFormat</span>;

  920. <span class="keyword">import</span> <span class="include">java.util.Collection</span>;

  921. <span class="keyword">import</span> <span class="include">java.util.Date</span>;

  922. <span class="keyword">import</span> <span class="include">java.util.List</span>;

  923. 

  924. <span class="keyword">import</span> <span class="include">org.springframework.beans.factory.annotation.Autowired</span>;

  925. <span class="keyword">import</span> <span class="include">org.springframework.dao.EmptyResultDataAccessException</span>;

  926. <span class="keyword">import</span> <span class="include">org.springframework.jdbc.core.JdbcTemplate</span>;

  927. <span class="keyword">import</span> <span class="include">org.springframework.stereotype.Repository</span>;

  928. 

  929. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.CrossSnippetLanguageCode</span>;

  930. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Snippet</span>;

  931. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.repository.mapper.SnippetRowMapper</span>;

  932. 

  933. <span class="annotation">@Repository</span>

  934. <span class="directive">public</span> <span class="type">class</span> <span class="class">SnippetRepository</span> <span class="directive">implements</span> SimpleRepository&lt;Snippet&gt; {

  935. 

  936.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_FIND_ALL = <span class="string"><span class="delimiter">&quot;</span><span class="content">select s.*,l.id lang_id, l.name lang_name, l.syntax lang_syntax, c.id code_id, c.source code_source from cross_snippet_language_code cx </span><span class="delimiter">&quot;</span></span> +

  937.                         <span class="string"><span class="delimiter">&quot;</span><span class="content">inner join snippet s on cx.snippet_id = s.id </span><span class="delimiter">&quot;</span></span> +

  938.                         <span class="string"><span class="delimiter">&quot;</span><span class="content">inner join language l on cx.language_id = l.id </span><span class="delimiter">&quot;</span></span> +

  939.                         <span class="string"><span class="delimiter">&quot;</span><span class="content">inner join code c on cx.code_id = c.id </span><span class="delimiter">&quot;</span></span>;

  940. 

  941.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_FIND_ONE = SQL_FIND_ALL + <span class="string"><span class="delimiter">&quot;</span><span class="content"> where s.id = ?</span><span class="delimiter">&quot;</span></span>;

  942.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_INSERT = <span class="string"><span class="delimiter">&quot;</span><span class="content">insert into snippet(id,title, keywords, description, created, modified) values(?,?,?,?,?,?)</span><span class="delimiter">&quot;</span></span>;

  943.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_UPDATE = <span class="string"><span class="delimiter">&quot;</span><span class="content">update snippet set title = ?, keywords = ?, description = ?, modified = ? where id = ?</span><span class="delimiter">&quot;</span></span>;

  944. 

  945.         <span class="directive">private</span> JdbcTemplate jdbcTemplate;

  946.         <span class="directive">private</span> LanguageRepository langRepo;

  947.         <span class="directive">private</span> CodeRepository codeRepo;

  948.         <span class="directive">private</span> CrossSnippetLanguageCodeRepository crossRepo;

  949. 

  950.         <span class="annotation">@Autowired</span>

  951.         <span class="directive">public</span> SnippetRepository(JdbcTemplate jdbcTemplate, LanguageRepository langRepo, CodeRepository codeRepo, CrossSnippetLanguageCodeRepository crossRepo) {

  952.                 <span class="local-variable">this</span>.jdbcTemplate = jdbcTemplate;

  953.                 <span class="local-variable">this</span>.langRepo = langRepo;

  954.                 <span class="local-variable">this</span>.codeRepo = codeRepo;

  955.                 <span class="local-variable">this</span>.crossRepo = crossRepo;

  956.         }

  957. 

  958.         <span class="annotation">@Override</span>

  959.         <span class="directive">public</span> <span class="predefined-type">List</span>&lt;Snippet&gt; findAll() {

  960.                 <span class="keyword">return</span> <span class="local-variable">this</span>.jdbcTemplate.query(SQL_FIND_ALL, <span class="keyword">new</span> SnippetRowMapper());

  961.         }

  962. 

  963.         <span class="annotation">@Override</span>

  964.         <span class="directive">public</span> <span class="type">void</span> saveAll(<span class="predefined-type">Collection</span>&lt;Snippet&gt; items) {

  965.                 items.forEach(code -&gt; <span class="local-variable">this</span>.saveAll(code));

  966.         }

  967. 

  968.         <span class="annotation">@Override</span>

  969.         <span class="directive">public</span> Snippet findById(<span class="predefined-type">String</span> id) {

  970.                 <span class="keyword">try</span> {

  971.                         <span class="keyword">return</span> <span class="local-variable">this</span>.jdbcTemplate.queryForObject(SQL_FIND_ONE, <span class="keyword">new</span> <span class="predefined-type">Object</span><span class="type">[]</span> { id }, <span class="keyword">new</span> SnippetRowMapper());

  972.                 } <span class="keyword">catch</span> (EmptyResultDataAccessException ex) {

  973.                         <span class="keyword">return</span> <span class="predefined-constant">null</span>;

  974.                 }

  975.         }

  976. 

  977.         <span class="annotation">@Override</span>

  978.         <span class="directive">public</span> Snippet saveAll(<span class="directive">final</span> Snippet item) {

  979.                 <span class="keyword">assert</span> item.getId() != <span class="predefined-constant">null</span>;

  980.                 <span class="keyword">assert</span> item.getTitle() != <span class="predefined-constant">null</span>;

  981.                 <span class="keyword">assert</span> item.getLang() != <span class="predefined-constant">null</span>;

  982.                 <span class="keyword">assert</span> item.getCode() != <span class="predefined-constant">null</span>;

  983. 

  984.                 Snippet snippet = <span class="local-variable">this</span>.findById(item.getId());

  985. 

  986.                 <span class="predefined-type">Date</span> date = <span class="keyword">new</span> <span class="predefined-type">Date</span>();

  987.                 <span class="predefined-type">SimpleDateFormat</span> dateFormat = <span class="keyword">new</span> <span class="predefined-type">SimpleDateFormat</span>(<span class="string"><span class="delimiter">&quot;</span><span class="content">yyyy-MM-dd</span><span class="delimiter">&quot;</span></span>);

  988. 

  989.                 <span class="keyword">if</span> (snippet == <span class="predefined-constant">null</span>) {

  990. 

  991.                         <span class="local-variable">this</span>.crossRepo.saveAll(<span class="keyword">new</span> CrossSnippetLanguageCode(item.getId(), item.getLang().getId(), item.getCode().getId()));

  992.                         <span class="local-variable">this</span>.langRepo.saveAll(item.getLang());

  993.                         <span class="local-variable">this</span>.codeRepo.saveAll(item.getCode());

  994. 

  995.                         <span class="local-variable">this</span>.jdbcTemplate.update(psc -&gt; {

  996.                                 <span class="predefined-type">PreparedStatement</span> ps = psc.prepareStatement(SQL_INSERT);

  997.                                 ps.setString(<span class="integer">1</span>, item.getId());

  998.                                 ps.setString(<span class="integer">2</span>, item.getTitle());

  999.                                 ps.setString(<span class="integer">3</span>, item.getKeywords());

  1000.                                 ps.setString(<span class="integer">4</span>, item.getDescription());

  1001.                                 ps.setString(<span class="integer">5</span>, dateFormat.format(date));

  1002.                                 ps.setString(<span class="integer">6</span>, dateFormat.format(date));

  1003.                                 <span class="keyword">return</span> ps;

  1004.                         });

  1005. 

  1006.                         <span class="keyword">return</span> item;

  1007. 

  1008.                 } <span class="keyword">else</span> {

  1009.                         <span class="local-variable">this</span>.crossRepo.saveAll(<span class="keyword">new</span> CrossSnippetLanguageCode(snippet.getId(), snippet.getLang().getId(), snippet.getCode().getId()));

  1010.                         <span class="local-variable">this</span>.langRepo.saveAll(item.getLang());

  1011.                         <span class="local-variable">this</span>.codeRepo.saveAll(item.getCode());

  1012. 

  1013.                         <span class="local-variable">this</span>.jdbcTemplate.update(psc -&gt; {

  1014.                                 <span class="predefined-type">PreparedStatement</span> ps = psc.prepareStatement(SQL_UPDATE);

  1015.                                 ps.setString(<span class="integer">1</span>, item.getTitle());

  1016.                                 ps.setString(<span class="integer">2</span>, item.getKeywords());

  1017.                                 ps.setString(<span class="integer">3</span>, item.getDescription());

  1018.                                 ps.setString(<span class="integer">4</span>, dateFormat.format(date));

  1019.                                 ps.setString(<span class="integer">5</span>, item.getId());

  1020.                                 <span class="keyword">return</span> ps;

  1021.                         });

  1022. 

  1023.                         <span class="keyword">return</span> snippet;

  1024.                 }

  1025.         }

  1026. 

  1027. 

  1028. }</code></pre>

  1029. </div>

  1030. </div>

  1031. <div class="paragraph">

  1032. <p>Every single class is using the <strong><em>JdbcTemplate</em></strong> (with some methods like: <strong>queryForObject</strong>, <strong>query</strong> and <strong>update</strong>) and the <strong><em>RowMapper</em></strong>, analyze the code and review the <strong>SQL</strong> statements.</p>

  1033. </div>

  1034. </li>

  1035. <li>

  1036. <p>As you already guess from the code above, the <strong>SnippetRepository</strong> class has on its constructor the <strong>CrossSnippetLanguageCodeRepository</strong> reference. Create this class:</p>

  1037. <div class="listingblock">

  1038. <div class="title">io.pivotal.workshop.snippet.repository.CrossSnippetLanguageCodeRepository.java</div>

  1039. <div class="content">

  1040. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository</span>;

  1041. 

  1042. <span class="keyword">import</span> <span class="include">java.sql.PreparedStatement</span>;

  1043. <span class="keyword">import</span> <span class="include">java.sql.ResultSet</span>;

  1044. <span class="keyword">import</span> <span class="include">java.util.Collection</span>;

  1045. 

  1046. <span class="keyword">import</span> <span class="include">org.springframework.beans.factory.annotation.Autowired</span>;

  1047. <span class="keyword">import</span> <span class="include">org.springframework.dao.EmptyResultDataAccessException</span>;

  1048. <span class="keyword">import</span> <span class="include">org.springframework.jdbc.core.JdbcTemplate</span>;

  1049. <span class="keyword">import</span> <span class="include">org.springframework.jdbc.core.RowMapper</span>;

  1050. <span class="keyword">import</span> <span class="include">org.springframework.stereotype.Repository</span>;

  1051. 

  1052. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.CrossSnippetLanguageCode</span>;

  1053. 

  1054. <span class="annotation">@Repository</span>

  1055. <span class="directive">public</span> <span class="type">class</span> <span class="class">CrossSnippetLanguageCodeRepository</span> <span class="directive">implements</span> SimpleRepository&lt;CrossSnippetLanguageCode&gt; {

  1056. 

  1057.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_FIND_ALL = <span class="string"><span class="delimiter">&quot;</span><span class="content">select * from cross_snippet_language_code</span><span class="delimiter">&quot;</span></span>;

  1058.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_FIND_ONE = <span class="string"><span class="delimiter">&quot;</span><span class="content">select * from cross_snippet_language_code where snippet_id = ?</span><span class="delimiter">&quot;</span></span>;

  1059.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_INSERT = <span class="string"><span class="delimiter">&quot;</span><span class="content">insert into cross_snippet_language_code(snippet_id,language_id,code_id) values(?,?,?)</span><span class="delimiter">&quot;</span></span>;

  1060.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">String</span> SQL_UPDATE = <span class="string"><span class="delimiter">&quot;</span><span class="content">update cross_snippet_language_code set langauge_id = ?, code_id = ? where snippet_id = ?</span><span class="delimiter">&quot;</span></span>;

  1061.         <span class="directive">private</span> JdbcTemplate jdbcTemplate;

  1062. 

  1063.         <span class="directive">private</span> <span class="directive">final</span> <span class="predefined-type">RowMapper</span>&lt;CrossSnippetLanguageCode&gt; rowMapper = (<span class="predefined-type">ResultSet</span> rs, <span class="type">int</span> row) -&gt; {

  1064.                 CrossSnippetLanguageCode cross = <span class="keyword">new</span> CrossSnippetLanguageCode();

  1065.                 cross.setSnippetId(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">snippet_id</span><span class="delimiter">&quot;</span></span>));

  1066.                 cross.setLanguageId(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">language_id</span><span class="delimiter">&quot;</span></span>));

  1067.                 cross.setCodeId(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">code_id</span><span class="delimiter">&quot;</span></span>));

  1068.                 <span class="keyword">return</span> cross;

  1069.         };

  1070. 

  1071.         <span class="annotation">@Autowired</span>

  1072.         <span class="directive">public</span> CrossSnippetLanguageCodeRepository(JdbcTemplate jdbcTemplate) {

  1073.                 <span class="local-variable">this</span>.jdbcTemplate = jdbcTemplate;

  1074.         }

  1075. 

  1076.         <span class="annotation">@Override</span>

  1077.         <span class="directive">public</span> <span class="predefined-type">Iterable</span>&lt;CrossSnippetLanguageCode&gt; findAll() {

  1078.                 <span class="keyword">return</span> <span class="local-variable">this</span>.jdbcTemplate.query(SQL_FIND_ALL, rowMapper);

  1079.         }

  1080. 

  1081.         <span class="annotation">@Override</span>

  1082.         <span class="directive">public</span> <span class="type">void</span> saveAll(<span class="predefined-type">Collection</span>&lt;CrossSnippetLanguageCode&gt; items) {

  1083.                 items.forEach(cross -&gt; {

  1084.                         <span class="local-variable">this</span>.saveAll(cross);

  1085.                 });

  1086.         }

  1087. 

  1088.         <span class="annotation">@Override</span>

  1089.         <span class="directive">public</span> CrossSnippetLanguageCode saveAll(CrossSnippetLanguageCode item) {

  1090.                 <span class="keyword">assert</span> item.getSnippetId() != <span class="predefined-constant">null</span>;

  1091.                 <span class="keyword">assert</span> item.getLanguageId() != <span class="predefined-constant">null</span>;

  1092.                 <span class="keyword">assert</span> item.getCodeId() != <span class="predefined-constant">null</span>;

  1093. 

  1094.                 CrossSnippetLanguageCode cross = <span class="local-variable">this</span>.findById(item.getSnippetId());

  1095. 

  1096.                 <span class="keyword">if</span> (cross == <span class="predefined-constant">null</span>) {

  1097.                         <span class="local-variable">this</span>.jdbcTemplate.update(psc -&gt; {

  1098.                                 <span class="predefined-type">PreparedStatement</span> ps = psc.prepareStatement(SQL_INSERT);

  1099.                                 ps.setString(<span class="integer">1</span>, item.getSnippetId());

  1100.                                 ps.setString(<span class="integer">2</span>, item.getLanguageId());

  1101.                                 ps.setString(<span class="integer">3</span>, item.getCodeId());

  1102.                                 <span class="keyword">return</span> ps;

  1103.                         });

  1104.                         <span class="keyword">return</span> item;

  1105.                 } <span class="keyword">else</span> {

  1106.                         <span class="local-variable">this</span>.jdbcTemplate.update(psc -&gt; {

  1107.                                 <span class="predefined-type">PreparedStatement</span> ps = psc.prepareStatement(SQL_UPDATE);

  1108.                                 ps.setString(<span class="integer">1</span>, item.getLanguageId());

  1109.                                 ps.setString(<span class="integer">2</span>, item.getCodeId());

  1110.                                 ps.setString(<span class="integer">3</span>, item.getSnippetId());

  1111.                                 <span class="keyword">return</span> ps;

  1112.                         });

  1113.                         <span class="keyword">return</span> cross;

  1114.                 }

  1115. 

  1116.         }

  1117. 

  1118.         <span class="annotation">@Override</span>

  1119.         <span class="directive">public</span> CrossSnippetLanguageCode findById(<span class="predefined-type">String</span> id) {

  1120.                 <span class="keyword">try</span> {

  1121.                         <span class="keyword">return</span> <span class="local-variable">this</span>.jdbcTemplate.queryForObject(SQL_FIND_ONE, <span class="keyword">new</span> <span class="predefined-type">Object</span><span class="type">[]</span> { id }, rowMapper);

  1122.                 } <span class="keyword">catch</span> (EmptyResultDataAccessException ex) {

  1123.                         <span class="keyword">return</span> <span class="predefined-constant">null</span>;

  1124.                 }

  1125.         }

  1126. 

  1127. }</code></pre>

  1128. </div>

  1129. </div>

  1130. <div class="paragraph">

  1131. <p>Have you noticed that the <strong>CrossSnippetLanguageCodeRepository</strong> is using a declared <strong>Java 8 lambda</strong> notation for the <strong>RowMapper</strong>?</p>

  1132. </div>

  1133. </li>

  1134. <li>

  1135. <p>Talking about <strong>RowMapper</strong>, all the above code is using it to map the <strong>ResultSet</strong> with the domain class. Create the following mappers in the <strong>io.pivotal.workshop.snippet.repository.mapper</strong> package:</p>

  1136. <div class="listingblock">

  1137. <div class="title">io.pivotal.workshop.snippet.repository.mapper.LanguageRowMapper.java</div>

  1138. <div class="content">

  1139. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository.mapper</span>;

  1140. 

  1141. <span class="keyword">import</span> <span class="include">java.sql.ResultSet</span>;

  1142. <span class="keyword">import</span> <span class="include">java.sql.SQLException</span>;

  1143. 

  1144. <span class="keyword">import</span> <span class="include">org.springframework.jdbc.core.RowMapper</span>;

  1145. 

  1146. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Language</span>;

  1147. 

  1148. <span class="directive">public</span> <span class="type">class</span> <span class="class">LanguageRowMapper</span> <span class="directive">implements</span> <span class="predefined-type">RowMapper</span>&lt;Language&gt; {

  1149. 

  1150.         <span class="annotation">@Override</span>

  1151.         <span class="directive">public</span> Language mapRow(<span class="predefined-type">ResultSet</span> rs, <span class="type">int</span> rowNum) <span class="directive">throws</span> <span class="exception">SQLException</span> {

  1152.                  Language lang = <span class="keyword">new</span> Language();

  1153.                  lang.setId(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">id</span><span class="delimiter">&quot;</span></span>));

  1154.                  lang.setName(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">name</span><span class="delimiter">&quot;</span></span>));

  1155.                  lang.setSyntax(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">syntax</span><span class="delimiter">&quot;</span></span>));

  1156.                 <span class="keyword">return</span> lang;

  1157.         }

  1158. 

  1159. }</code></pre>

  1160. </div>

  1161. </div>

  1162. <div class="listingblock">

  1163. <div class="title">io.pivotal.workshop.snippet.repository.mapper.CodeRowMapper.java</div>

  1164. <div class="content">

  1165. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository.mapper</span>;

  1166. 

  1167. <span class="keyword">import</span> <span class="include">java.sql.ResultSet</span>;

  1168. <span class="keyword">import</span> <span class="include">java.sql.SQLException</span>;

  1169. 

  1170. <span class="keyword">import</span> <span class="include">org.springframework.jdbc.core.RowMapper</span>;

  1171. 

  1172. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Code</span>;

  1173. 

  1174. <span class="directive">public</span> <span class="type">class</span> <span class="class">CodeRowMapper</span> <span class="directive">implements</span> <span class="predefined-type">RowMapper</span>&lt;Code&gt; {

  1175. 

  1176.         <span class="annotation">@Override</span>

  1177.         <span class="directive">public</span> Code mapRow(<span class="predefined-type">ResultSet</span> rs, <span class="type">int</span> rowNum) <span class="directive">throws</span> <span class="exception">SQLException</span> {

  1178.                 Code code = <span class="keyword">new</span> Code();

  1179.                 code.setId(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">id</span><span class="delimiter">&quot;</span></span>));

  1180.                 code.setSource(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">source</span><span class="delimiter">&quot;</span></span>));

  1181.                 <span class="keyword">return</span> code;

  1182.         }

  1183. 

  1184. }</code></pre>

  1185. </div>

  1186. </div>

  1187. <div class="listingblock">

  1188. <div class="title">io.pivotal.workshop.snippet.repository.mapper.SnippetRowMapper.java</div>

  1189. <div class="content">

  1190. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository.mapper</span>;

  1191. 

  1192. <span class="keyword">import</span> <span class="include">java.sql.ResultSet</span>;

  1193. <span class="keyword">import</span> <span class="include">java.sql.SQLException</span>;

  1194. 

  1195. <span class="keyword">import</span> <span class="include">org.springframework.jdbc.core.RowMapper</span>;

  1196. 

  1197. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Code</span>;

  1198. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Language</span>;

  1199. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Snippet</span>;

  1200. 

  1201. <span class="directive">public</span> <span class="type">class</span> <span class="class">SnippetRowMapper</span> <span class="directive">implements</span> <span class="predefined-type">RowMapper</span>&lt;Snippet&gt; {

  1202. 

  1203.         <span class="annotation">@Override</span>

  1204.         <span class="directive">public</span> Snippet mapRow(<span class="predefined-type">ResultSet</span> rs, <span class="type">int</span> rowNum) <span class="directive">throws</span> <span class="exception">SQLException</span> {

  1205.                 Language lang = <span class="keyword">new</span> Language();

  1206.                 lang.setId(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">lang_id</span><span class="delimiter">&quot;</span></span>));

  1207.                 lang.setName(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">lang_name</span><span class="delimiter">&quot;</span></span>));

  1208.                 lang.setSyntax(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">lang_syntax</span><span class="delimiter">&quot;</span></span>));

  1209. 

  1210.                 Code code = <span class="keyword">new</span> Code();

  1211.                 code.setId(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">code_id</span><span class="delimiter">&quot;</span></span>));

  1212.                 code.setSource(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">code_source</span><span class="delimiter">&quot;</span></span>));

  1213. 

  1214.                 Snippet snippet = <span class="keyword">new</span> Snippet();

  1215.                 snippet.setId(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">id</span><span class="delimiter">&quot;</span></span>));

  1216.                 snippet.setTitle(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">title</span><span class="delimiter">&quot;</span></span>));

  1217.                 snippet.setDescription(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">description</span><span class="delimiter">&quot;</span></span>));

  1218.                 snippet.setKeywords(rs.getString(<span class="string"><span class="delimiter">&quot;</span><span class="content">keywords</span><span class="delimiter">&quot;</span></span>));

  1219.                 snippet.setCreated(rs.getDate(<span class="string"><span class="delimiter">&quot;</span><span class="content">created</span><span class="delimiter">&quot;</span></span>));

  1220.                 snippet.setModified(rs.getDate(<span class="string"><span class="delimiter">&quot;</span><span class="content">modified</span><span class="delimiter">&quot;</span></span>));

  1221.                 snippet.setLang(lang);

  1222.                 snippet.setCode(code);

  1223. 

  1224.                 <span class="keyword">return</span> snippet;

  1225.         }

  1226. 

  1227. }</code></pre>

  1228. </div>

  1229. </div>

  1230. </li>

  1231. <li>

  1232. <p>The <strong>SnippetController</strong> and the <strong>SnippetConfiguration</strong> classes must be the same. Practically there is no change on any of them, they should work.</p>

  1233. </li>

  1234. <li>

  1235. <p>Next add the <strong>schema.sql</strong> in the <strong>src/main/resources/</strong> folder.</p>

  1236. <div class="listingblock">

  1237. <div class="content">

  1238. <pre class="CodeRay highlight"><code data-lang="sql"><span class="class">DROP</span> <span class="type">TABLE</span> <span class="keyword">IF</span> <span class="keyword">EXISTS</span> snippet;

  1239. <span class="class">CREATE</span> <span class="type">TABLE</span> snippet

  1240. (

  1241.     id <span class="predefined-type">varchar</span>(<span class="integer">36</span>) <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1242.     title <span class="predefined-type">varchar</span>(<span class="integer">200</span>) <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1243.     keywords <span class="predefined-type">varchar</span>(<span class="integer">250</span>) <span class="directive">DEFAULT</span> <span class="predefined-constant">NULL</span>,

  1244.     description <span class="predefined-type">varchar</span>(<span class="integer">500</span>) <span class="directive">DEFAULT</span> <span class="predefined-constant">NULL</span>,

  1245.     created <span class="predefined-type">date</span> <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1246.     modified <span class="predefined-type">date</span> <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1247.     <span class="directive">PRIMARY</span> <span class="type">KEY</span> (id)

  1248. );

  1249. 

  1250. 

  1251. <span class="class">DROP</span> <span class="type">TABLE</span> <span class="keyword">IF</span> <span class="keyword">EXISTS</span> language;

  1252. <span class="class">CREATE</span> <span class="type">TABLE</span> language

  1253. (

  1254.     id <span class="predefined-type">varchar</span>(<span class="integer">36</span>) <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1255.     name <span class="predefined-type">varchar</span>(<span class="integer">250</span>) <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1256.     syntax <span class="predefined-type">varchar</span>(<span class="integer">250</span>) <span class="directive">DEFAULT</span> <span class="predefined-constant">NULL</span>,

  1257.     <span class="directive">PRIMARY</span> <span class="type">KEY</span> (id)

  1258. );

  1259. 

  1260. <span class="class">DROP</span> <span class="type">TABLE</span> <span class="keyword">IF</span> <span class="keyword">EXISTS</span> code;

  1261. <span class="class">CREATE</span> <span class="type">TABLE</span> code

  1262. (

  1263.     id <span class="predefined-type">varchar</span>(<span class="integer">36</span>) <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1264.     source <span class="predefined-type">varchar</span>(<span class="integer">5000</span>) <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1265.     <span class="directive">PRIMARY</span> <span class="type">KEY</span> (id)

  1266. );

  1267. 

  1268. 

  1269. <span class="class">DROP</span> <span class="type">TABLE</span> <span class="keyword">IF</span> <span class="keyword">EXISTS</span> cross_snippet_language_code;

  1270. <span class="class">CREATE</span> <span class="type">TABLE</span> cross_snippet_language_code

  1271. (

  1272.     snippet_id <span class="predefined-type">varchar</span>(<span class="integer">36</span>) <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1273.     language_id <span class="predefined-type">varchar</span>(<span class="integer">36</span>) <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1274.     code_id <span class="predefined-type">varchar</span>(<span class="integer">36</span>) <span class="keyword">NOT</span> <span class="predefined-constant">NULL</span>,

  1275.     <span class="directive">PRIMARY</span> <span class="type">KEY</span> (snippet_id)

  1276. );</code></pre>

  1277. </div>

  1278. </div>

  1279. </li>

  1280. </ol>

  1281. </div>

  1282. <div class="admonitionblock tip">

  1283. <table>

  1284. <tr>

  1285. <td class="icon">

  1286. <div class="title">Tip</div>

  1287. </td>

  1288. <td class="content">

  1289. Before you run your application make sure to have copied <strong>resources/static</strong> and <strong>resources/templates</strong> files from the previous labs.

  1290. </td>

  1291. </tr>

  1292. </table>

  1293. </div>

  1294. <div class="sect2">

  1295. <h3 id="_challenges">Challenges</h3>

  1296. <div class="ulist">

  1297. <ul>

  1298. <li>

  1299. <p>Run the application and make sure it works.</p>

  1300. </li>

  1301. <li>

  1302. <p>Do any necessary change to have the home page working.</p>

  1303. <div class="paragraph">

  1304. <div class="title">Figure 1.1: Code Snippet Manager JDBC - <a href="http://localhost:8080/" class="bare" target="_blank">http://localhost:8080/</a></div>

  1305. <p><span class="image"><img src="images/06-spring-boot-data-04.png" alt="Code Snippet Manager" title="Spring Initializr"></span></p>

  1306. </div>

  1307. </li>

  1308. </ul>

  1309. </div>

  1310. </div>

  1311. </div>

  1312. </div>

  1313. <div class="sect1">

  1314. <h2 id="_code_snippet_manager_jpa">Code Snippet Manager JPA</h2>

  1315. <div class="sectionbody">

  1316. <div class="paragraph">

  1317. <p>You will continue with the <strong>Code Snippet Manager</strong> code, but this time using <strong>JPA</strong>. You will reuse the code from previous labs.</p>

  1318. </div>

  1319. <div class="olist arabic">

  1320. <ol class="arabic">

  1321. <li>

  1322. <p>Open a browser and hit the url: <a href="http://start.spring.io" class="bare" target="_blank">http://start.spring.io</a></p>

  1323. </li>

  1324. <li>

  1325. <p>Click the <strong><em>Switch to the full version</em></strong> link.</p>

  1326. </li>

  1327. <li>

  1328. <p>Fill out the <strong>Code Snippet Manager JPA</strong> Project metadata with (See Figure 2.0):</p>

  1329. <table class="tableblock frame-all grid-all spread">

  1330. <caption class="title">Table 2. Code Snippet Manager JPA App - metadata</caption>

  1331. <colgroup>

  1332. <col style="width: 16.6666%;">

  1333. <col style="width: 83.3334%;">

  1334. </colgroup>

  1335. <thead>

  1336. <tr>

  1337. <th class="tableblock halign-left valign-top">Property</th>

  1338. <th class="tableblock halign-left valign-top">Value</th>

  1339. </tr>

  1340. </thead>

  1341. <tbody>

  1342. <tr>

  1343. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Group</strong>:</p></td>

  1344. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>io.pivotal.workshop</em></p></td>

  1345. </tr>

  1346. <tr>

  1347. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Artifact</strong>:</p></td>

  1348. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>code-snippet-manager-jpa</em></p></td>

  1349. </tr>

  1350. <tr>

  1351. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Name</strong>:</p></td>

  1352. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>code-snippet-manager-jpa</em></p></td>

  1353. </tr>

  1354. <tr>

  1355. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Package Name</strong>:</p></td>

  1356. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>io.pivotal.workshop.snippet</em></p></td>

  1357. </tr>

  1358. <tr>

  1359. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Dependencies</strong>:</p></td>

  1360. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>Web, DevTools, Groovy Templates, JPA, H2, MySQL</em></p></td>

  1361. </tr>

  1362. <tr>

  1363. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Spring Boot</strong>:</p></td>

  1364. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>2.0.0.M7</em></p></td>

  1365. </tr>

  1366. </tbody>

  1367. </table>

  1368. <div class="paragraph">

  1369. <div class="title">Figure 2.0: Spring Initializr - <a href="http://start.spring.io/" class="bare" target="_blank">http://start.spring.io/</a></div>

  1370. <p><span class="image"><img src="images/06-spring-boot-data-02.png" alt="SpringInitializr" title="Spring Initializr"></span></p>

  1371. </div>

  1372. <div class="admonitionblock tip">

  1373. <table>

  1374. <tr>

  1375. <td class="icon">

  1376. <div class="title">Tip</div>

  1377. </td>

  1378. <td class="content">

  1379. You can choose either <strong>Maven</strong> or <strong>Gradle</strong> project types.

  1380. </td>

  1381. </tr>

  1382. </table>

  1383. </div>

  1384. </li>

  1385. <li>

  1386. <p>type <strong>Web</strong>, <strong>DevTools</strong>, <strong>Groovy Templates</strong>, <strong>JPA</strong>, <strong>H2</strong>, and <strong>MySQL</strong> in the <strong><em>Dependencies</em></strong> field and press Enter.</p>

  1387. </li>

  1388. <li>

  1389. <p>Click the <strong><em>Generate Project</em></strong> button.</p>

  1390. </li>

  1391. <li>

  1392. <p>Unzip the file in any directory you want.</p>

  1393. </li>

  1394. <li>

  1395. <p>Import your project in any IDE you want.</p>

  1396. </li>

  1397. <li>

  1398. <p>Copy all the packages (with code) into the new project.</p>

  1399. </li>

  1400. <li>

  1401. <p>The classes in <strong>io.pivotal.workshop.snippet.domain</strong>: <strong><em>Code</em></strong>, <strong><em>Language</em></strong> and <strong><em>Snippet</em></strong> will change because you will use the <strong>JPA</strong> features. Create/modify the following classes:</p>

  1402. <div class="listingblock">

  1403. <div class="title">io.pivotal.workshop.snippet.domain.Language.java</div>

  1404. <div class="content">

  1405. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.domain</span>;

  1406. 

  1407. <span class="keyword">import</span> <span class="include">javax.persistence.Entity</span>;

  1408. <span class="keyword">import</span> <span class="include">javax.persistence.GeneratedValue</span>;

  1409. <span class="keyword">import</span> <span class="include">javax.persistence.Id</span>;

  1410. 

  1411. <span class="keyword">import</span> <span class="include">org.hibernate.annotations.GenericGenerator</span>;

  1412. 

  1413. <span class="annotation">@Entity</span>

  1414. <span class="directive">public</span> <span class="type">class</span> <span class="class">Language</span> {

  1415. 

  1416.         <span class="annotation">@Id</span>

  1417.         <span class="annotation">@GeneratedValue</span>(generator = <span class="string"><span class="delimiter">&quot;</span><span class="content">system-uuid</span><span class="delimiter">&quot;</span></span>)

  1418.         <span class="annotation">@GenericGenerator</span>(name = <span class="string"><span class="delimiter">&quot;</span><span class="content">system-uuid</span><span class="delimiter">&quot;</span></span>, strategy = <span class="string"><span class="delimiter">&quot;</span><span class="content">uuid</span><span class="delimiter">&quot;</span></span>)

  1419.         <span class="directive">private</span> <span class="predefined-type">String</span> id;

  1420.         <span class="directive">private</span> <span class="predefined-type">String</span> name;

  1421.         <span class="directive">private</span> <span class="predefined-type">String</span> syntax = <span class="string"><span class="delimiter">&quot;</span><span class="content">text</span><span class="delimiter">&quot;</span></span>;

  1422. 

  1423.         <span class="directive">public</span> Language() {

  1424.         }

  1425. 

  1426.         <span class="directive">public</span> Language(<span class="predefined-type">String</span> name) {

  1427.                 <span class="local-variable">this</span>();

  1428.                 <span class="local-variable">this</span>.name = name;

  1429.         }

  1430. 

  1431.         <span class="directive">public</span> Language(<span class="predefined-type">String</span> name, <span class="predefined-type">String</span> syntax) {

  1432.                 <span class="local-variable">this</span>(name);

  1433.                 <span class="local-variable">this</span>.syntax = syntax;

  1434.         }

  1435. 

  1436.         <span class="directive">public</span> <span class="predefined-type">String</span> getId() {

  1437.                 <span class="keyword">return</span> id;

  1438.         }

  1439. 

  1440.         <span class="directive">public</span> <span class="type">void</span> setId(<span class="predefined-type">String</span> id) {

  1441.                 <span class="local-variable">this</span>.id = id;

  1442.         }

  1443. 

  1444.         <span class="directive">public</span> <span class="predefined-type">String</span> getName() {

  1445.                 <span class="keyword">return</span> name;

  1446.         }

  1447. 

  1448.         <span class="directive">public</span> <span class="type">void</span> setName(<span class="predefined-type">String</span> name) {

  1449.                 <span class="local-variable">this</span>.name = name;

  1450.         }

  1451. 

  1452.         <span class="directive">public</span> <span class="predefined-type">String</span> getSyntax() {

  1453.                 <span class="keyword">return</span> syntax;

  1454.         }

  1455. 

  1456.         <span class="directive">public</span> <span class="type">void</span> setSyntax(<span class="predefined-type">String</span> syntax) {

  1457.                 <span class="local-variable">this</span>.syntax = syntax;

  1458.         }

  1459. }</code></pre>

  1460. </div>

  1461. </div>

  1462. <div class="listingblock">

  1463. <div class="title">io.pivotal.workshop.snippet.domain.Code.java</div>

  1464. <div class="content">

  1465. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.domain</span>;

  1466. 

  1467. <span class="keyword">import</span> <span class="include">javax.persistence.Entity</span>;

  1468. <span class="keyword">import</span> <span class="include">javax.persistence.GeneratedValue</span>;

  1469. <span class="keyword">import</span> <span class="include">javax.persistence.Id</span>;

  1470. 

  1471. <span class="keyword">import</span> <span class="include">org.hibernate.annotations.GenericGenerator</span>;

  1472. 

  1473. <span class="annotation">@Entity</span>

  1474. <span class="directive">public</span> <span class="type">class</span> <span class="class">Code</span> {

  1475. 

  1476.         <span class="annotation">@Id</span>

  1477.         <span class="annotation">@GeneratedValue</span>(generator = <span class="string"><span class="delimiter">&quot;</span><span class="content">system-uuid</span><span class="delimiter">&quot;</span></span>)

  1478.         <span class="annotation">@GenericGenerator</span>(name = <span class="string"><span class="delimiter">&quot;</span><span class="content">system-uuid</span><span class="delimiter">&quot;</span></span>, strategy = <span class="string"><span class="delimiter">&quot;</span><span class="content">uuid</span><span class="delimiter">&quot;</span></span>)

  1479.         <span class="directive">private</span> <span class="predefined-type">String</span> id;

  1480.         <span class="directive">private</span> <span class="predefined-type">String</span> source;

  1481. 

  1482.         <span class="directive">public</span> Code() {

  1483.         }

  1484. 

  1485.         <span class="directive">public</span> Code(<span class="predefined-type">String</span> source) {

  1486.                 <span class="local-variable">this</span>();

  1487.                 <span class="local-variable">this</span>.source = source;

  1488.         }

  1489. 

  1490.         <span class="directive">public</span> <span class="predefined-type">String</span> getId() {

  1491.                 <span class="keyword">return</span> id;

  1492.         }

  1493. 

  1494.         <span class="directive">public</span> <span class="type">void</span> setId(<span class="predefined-type">String</span> id) {

  1495.                 <span class="local-variable">this</span>.id = id;

  1496.         }

  1497. 

  1498.         <span class="directive">public</span> <span class="predefined-type">String</span> getSource() {

  1499.                 <span class="keyword">return</span> source;

  1500.         }

  1501. 

  1502.         <span class="directive">public</span> <span class="type">void</span> setSource(<span class="predefined-type">String</span> source) {

  1503.                 <span class="local-variable">this</span>.source = source;

  1504.         }

  1505. 

  1506. }</code></pre>

  1507. </div>

  1508. </div>

  1509. <div class="listingblock">

  1510. <div class="title">io.pivotal.workshop.snippet.domain.Snippet.java</div>

  1511. <div class="content">

  1512. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.domain</span>;

  1513. 

  1514. <span class="keyword">import</span> <span class="include">java.util.Date</span>;

  1515. 

  1516. <span class="keyword">import</span> <span class="include">javax.persistence.CascadeType</span>;

  1517. <span class="keyword">import</span> <span class="include">javax.persistence.Column</span>;

  1518. <span class="keyword">import</span> <span class="include">javax.persistence.Entity</span>;

  1519. <span class="keyword">import</span> <span class="include">javax.persistence.FetchType</span>;

  1520. <span class="keyword">import</span> <span class="include">javax.persistence.GeneratedValue</span>;

  1521. <span class="keyword">import</span> <span class="include">javax.persistence.Id</span>;

  1522. <span class="keyword">import</span> <span class="include">javax.persistence.OneToOne</span>;

  1523. <span class="keyword">import</span> <span class="include">javax.persistence.PrePersist</span>;

  1524. <span class="keyword">import</span> <span class="include">javax.persistence.PreUpdate</span>;

  1525. 

  1526. <span class="keyword">import</span> <span class="include">org.hibernate.annotations.GenericGenerator</span>;

  1527. 

  1528. <span class="annotation">@Entity</span>

  1529. <span class="directive">public</span> <span class="type">class</span> <span class="class">Snippet</span> {

  1530. 

  1531.         <span class="annotation">@Id</span>

  1532.         <span class="annotation">@GeneratedValue</span>(generator = <span class="string"><span class="delimiter">&quot;</span><span class="content">system-uuid</span><span class="delimiter">&quot;</span></span>)

  1533.         <span class="annotation">@GenericGenerator</span>(name = <span class="string"><span class="delimiter">&quot;</span><span class="content">system-uuid</span><span class="delimiter">&quot;</span></span>, strategy = <span class="string"><span class="delimiter">&quot;</span><span class="content">uuid</span><span class="delimiter">&quot;</span></span>)

  1534.         <span class="directive">private</span> <span class="predefined-type">String</span> id;

  1535.         <span class="directive">private</span> <span class="predefined-type">String</span> title;

  1536.         <span class="directive">private</span> <span class="predefined-type">String</span> keywords = <span class="string"><span class="delimiter">&quot;</span><span class="delimiter">&quot;</span></span>;

  1537.         <span class="directive">private</span> <span class="predefined-type">String</span> description = <span class="string"><span class="delimiter">&quot;</span><span class="delimiter">&quot;</span></span>;

  1538. 

  1539.         <span class="annotation">@OneToOne</span>(fetch=FetchType.EAGER, cascade = CascadeType.ALL)

  1540.         <span class="directive">private</span> Language lang;

  1541. 

  1542.         <span class="annotation">@OneToOne</span>(fetch=FetchType.EAGER, cascade = CascadeType.ALL)

  1543.         <span class="directive">private</span> Code code;

  1544. 

  1545.         <span class="annotation">@Column</span>(insertable = <span class="predefined-constant">true</span>, updatable = <span class="predefined-constant">false</span>)

  1546.         <span class="directive">private</span> <span class="predefined-type">Date</span> created;

  1547.         <span class="directive">private</span> <span class="predefined-type">Date</span> modified;

  1548. 

  1549.         <span class="directive">public</span> Snippet() {

  1550.                 <span class="local-variable">this</span>.id = java.util.UUID.randomUUID().toString().replaceAll(<span class="string"><span class="delimiter">&quot;</span><span class="content">-</span><span class="delimiter">&quot;</span></span>, <span class="string"><span class="delimiter">&quot;</span><span class="delimiter">&quot;</span></span>);

  1551.                 <span class="local-variable">this</span>.created = <span class="keyword">new</span> <span class="predefined-type">Date</span>();

  1552.                 <span class="local-variable">this</span>.modified = <span class="keyword">new</span> <span class="predefined-type">Date</span>();

  1553.         }

  1554. 

  1555.         <span class="directive">public</span> Snippet(<span class="predefined-type">String</span> title, <span class="predefined-type">String</span> keywords, <span class="predefined-type">String</span> description, Language lang, Code code) {

  1556.                 <span class="local-variable">this</span>();

  1557.                 <span class="local-variable">this</span>.title = title;

  1558.                 <span class="local-variable">this</span>.keywords = keywords;

  1559.                 <span class="local-variable">this</span>.description = description;

  1560.                 <span class="local-variable">this</span>.lang = lang;

  1561.                 <span class="local-variable">this</span>.code = code;

  1562.         }

  1563. 

  1564.         <span class="directive">public</span> Snippet(<span class="predefined-type">String</span> title, Language lang, Code code) {

  1565.                 <span class="local-variable">this</span>(title, <span class="string"><span class="delimiter">&quot;</span><span class="delimiter">&quot;</span></span>, <span class="string"><span class="delimiter">&quot;</span><span class="delimiter">&quot;</span></span>, lang, code);

  1566.         }

  1567. 

  1568.         <span class="directive">public</span> <span class="predefined-type">String</span> getId() {

  1569.                 <span class="keyword">return</span> id;

  1570.         }

  1571. 

  1572.         <span class="directive">public</span> <span class="type">void</span> setId(<span class="predefined-type">String</span> id) {

  1573.                 <span class="local-variable">this</span>.id = id;

  1574.         }

  1575. 

  1576.         <span class="directive">public</span> <span class="predefined-type">String</span> getTitle() {

  1577.                 <span class="keyword">return</span> title;

  1578.         }

  1579. 

  1580.         <span class="directive">public</span> <span class="type">void</span> setTitle(<span class="predefined-type">String</span> title) {

  1581.                 <span class="local-variable">this</span>.title = title;

  1582.         }

  1583. 

  1584.         <span class="directive">public</span> Language getLang() {

  1585.                 <span class="keyword">return</span> lang;

  1586.         }

  1587. 

  1588.         <span class="directive">public</span> <span class="type">void</span> setLang(Language lang) {

  1589.                 <span class="local-variable">this</span>.lang = lang;

  1590.         }

  1591. 

  1592.         <span class="directive">public</span> <span class="predefined-type">String</span> getDescription() {

  1593.                 <span class="keyword">return</span> description;

  1594.         }

  1595. 

  1596.         <span class="directive">public</span> <span class="type">void</span> setDescription(<span class="predefined-type">String</span> description) {

  1597.                 <span class="local-variable">this</span>.description = description;

  1598.         }

  1599. 

  1600.         <span class="directive">public</span> <span class="predefined-type">String</span> getKeywords() {

  1601.                 <span class="keyword">return</span> keywords;

  1602.         }

  1603. 

  1604.         <span class="directive">public</span> <span class="type">void</span> setKeywords(<span class="predefined-type">String</span> keywords) {

  1605.                 <span class="local-variable">this</span>.keywords = keywords;

  1606.         }

  1607. 

  1608.         <span class="directive">public</span> Code getCode() {

  1609.                 <span class="keyword">return</span> code;

  1610.         }

  1611. 

  1612.         <span class="directive">public</span> <span class="type">void</span> setCode(Code code) {

  1613.                 <span class="local-variable">this</span>.code = code;

  1614.         }

  1615. 

  1616.         <span class="directive">public</span> <span class="predefined-type">Date</span> getCreated() {

  1617.                 <span class="keyword">return</span> created;

  1618.         }

  1619. 

  1620.         <span class="directive">public</span> <span class="type">void</span> setCreated(<span class="predefined-type">Date</span> created) {

  1621.                 <span class="local-variable">this</span>.created = created;

  1622.         }

  1623. 

  1624.         <span class="directive">public</span> <span class="predefined-type">Date</span> getModified() {

  1625.                 <span class="keyword">return</span> modified;

  1626.         }

  1627. 

  1628.         <span class="directive">public</span> <span class="type">void</span> setModified(<span class="predefined-type">Date</span> modified) {

  1629.                 <span class="local-variable">this</span>.modified = modified;

  1630.         }

  1631. 

  1632.         <span class="annotation">@PrePersist</span>

  1633.         <span class="type">void</span> onCreate() {

  1634.                 <span class="local-variable">this</span>.setCreated(<span class="keyword">new</span> <span class="predefined-type">Date</span>());

  1635.             <span class="local-variable">this</span>.setModified(<span class="keyword">new</span> <span class="predefined-type">Date</span>());

  1636.         }

  1637. 

  1638.         <span class="annotation">@PreUpdate</span>

  1639.         <span class="type">void</span> onUpdate() {

  1640.                 <span class="local-variable">this</span>.setModified(<span class="keyword">new</span> <span class="predefined-type">Date</span>());

  1641.         }

  1642. }</code></pre>

  1643. </div>

  1644. </div>

  1645. <div class="paragraph">

  1646. <p>See that you are using now the <strong>JPA</strong> standard annotations: <strong>@Entity</strong>, <strong>@Id</strong>, <strong>@OneToOne</strong>, etc.</p>

  1647. </div>

  1648. </li>

  1649. <li>

  1650. <p>The repositories will change becasue you will use the power of the <strong>spring-data</strong> and <strong>spring-data-jpa</strong> projects. Create/Modify the following classes:</p>

  1651. <div class="listingblock">

  1652. <div class="title">io.pivotal.workshop.snippet.repository.LanguageRepository.java</div>

  1653. <div class="content">

  1654. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository</span>;

  1655. 

  1656. <span class="keyword">import</span> <span class="include">org.springframework.data.repository.CrudRepository</span>;

  1657. 

  1658. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Language</span>;

  1659. 

  1660. <span class="directive">public</span> <span class="type">interface</span> <span class="class">LanguageRepository</span> <span class="directive">extends</span> CrudRepository&lt;Language, <span class="predefined-type">String</span>&gt; {

  1661. 

  1662. }</code></pre>

  1663. </div>

  1664. </div>

  1665. <div class="listingblock">

  1666. <div class="title">io.pivotal.workshop.snippet.repository.CodeRepository.java</div>

  1667. <div class="content">

  1668. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository</span>;

  1669. 

  1670. <span class="keyword">import</span> <span class="include">org.springframework.data.repository.CrudRepository</span>;

  1671. 

  1672. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Code</span>;

  1673. 

  1674. <span class="directive">public</span> <span class="type">interface</span> <span class="class">CodeRepository</span> <span class="directive">extends</span> CrudRepository&lt;Code, <span class="predefined-type">String</span>&gt; {

  1675. 

  1676. }</code></pre>

  1677. </div>

  1678. </div>

  1679. <div class="listingblock">

  1680. <div class="title">io.pivotal.workshop.snippet.repository.SnippetRepository.java</div>

  1681. <div class="content">

  1682. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.repository</span>;

  1683. 

  1684. <span class="keyword">import</span> <span class="include">org.springframework.data.repository.CrudRepository</span>;

  1685. 

  1686. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.domain.Snippet</span>;

  1687. 

  1688. <span class="directive">public</span> <span class="type">interface</span> <span class="class">SnippetRepository</span> <span class="directive">extends</span> CrudRepository&lt;Snippet, <span class="predefined-type">String</span>&gt; {

  1689. 

  1690. }</code></pre>

  1691. </div>

  1692. </div>

  1693. <div class="paragraph">

  1694. <p>As you can see from the code above, you don&#8217;t need to implement anything but just extend from the <strong>CrudRepository&lt;T,ID&gt;</strong> interface, which uses generics, meaning that you need to

  1695. pass the domain class and the unique identifies, in this case what is marked as <strong>@Id</strong>. All the operation from the <strong>CrudRepository&lt;T,ID&gt;</strong> interface will be implemented by the <strong>spring-data</strong> classes.</p>

  1696. </div>

  1697. </li>

  1698. <li>

  1699. <p>The <strong>SnippetController</strong> and the <strong>SnippetConfiguration</strong> classes must be the same. Practically there is no change on any of them, they should work.</p>

  1700. </li>

  1701. <li>

  1702. <p>This time there is no need for any <strong>SQL</strong> schema, this time you will use the <strong><em>DDL auto-creation</em></strong> feature. In the <strong>src/main/resources/application.properties</strong> file add the following content:</p>

  1703. <div class="listingblock">

  1704. <div class="title">src/main/resources/application.properties</div>

  1705. <div class="content">

  1706. <pre class="CodeRay highlight"><code data-lang="properties">## JPA

  1707. spring.jpa.generate-ddl=true

  1708. spring.jpa.hibernate.ddl-auto=create-drop</code></pre>

  1709. </div>

  1710. </div>

  1711. </li>

  1712. </ol>

  1713. </div>

  1714. <div class="admonitionblock tip">

  1715. <table>

  1716. <tr>

  1717. <td class="icon">

  1718. <div class="title">Tip</div>

  1719. </td>

  1720. <td class="content">

  1721. Before you run your application make sure to have copied <strong>resources/static</strong> and <strong>resources/templates</strong> files from the previous labs.

  1722. </td>

  1723. </tr>

  1724. </table>

  1725. </div>

  1726. <div class="sect2">

  1727. <h3 id="_challenges_2">Challenges</h3>

  1728. <div class="ulist">

  1729. <ul>

  1730. <li>

  1731. <p>Run the application and make sure it works.</p>

  1732. </li>

  1733. <li>

  1734. <p>Do any necessary change to have the home page working.</p>

  1735. <div class="paragraph">

  1736. <div class="title">Figure 1.1: Code Snippet Manager JPA - <a href="http://localhost:8080/" class="bare" target="_blank">http://localhost:8080/</a></div>

  1737. <p><span class="image"><img src="images/06-spring-boot-data-04.png" alt="Code Snippet Manager JPA" title="Code Snippet Manager JPA"></span></p>

  1738. </div>

  1739. </li>

  1740. </ul>

  1741. </div>

  1742. </div>

  1743. </div>

  1744. </div>

  1745. <div class="sect1">

  1746. <h2 id="_code_snippet_manager_jpa_rest">Code Snippet Manager JPA REST</h2>

  1747. <div class="sectionbody">

  1748. <div class="paragraph">

  1749. <p>You will continue with the <strong>Code Snippet Manager</strong> code, but this time using <strong>Data Rest</strong> module. You will reuse the code from previous labs.</p>

  1750. </div>

  1751. <div class="olist arabic">

  1752. <ol class="arabic">

  1753. <li>

  1754. <p>Open a browser and hit the url: <a href="http://start.spring.io" class="bare" target="_blank">http://start.spring.io</a></p>

  1755. </li>

  1756. <li>

  1757. <p>Click the <strong><em>Switch to the full version</em></strong> link.</p>

  1758. </li>

  1759. <li>

  1760. <p>Fill out the <strong>Code Snippet Manager JPA REST</strong> Project metadata with (See Figure 3.0):</p>

  1761. <table class="tableblock frame-all grid-all spread">

  1762. <caption class="title">Table 3. Code Snippet Manager JPA REST App - metadata</caption>

  1763. <colgroup>

  1764. <col style="width: 16.6666%;">

  1765. <col style="width: 83.3334%;">

  1766. </colgroup>

  1767. <thead>

  1768. <tr>

  1769. <th class="tableblock halign-left valign-top">Property</th>

  1770. <th class="tableblock halign-left valign-top">Value</th>

  1771. </tr>

  1772. </thead>

  1773. <tbody>

  1774. <tr>

  1775. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Group</strong>:</p></td>

  1776. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>io.pivotal.workshop</em></p></td>

  1777. </tr>

  1778. <tr>

  1779. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Artifact</strong>:</p></td>

  1780. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>code-snippet-manager-jpa-rest</em></p></td>

  1781. </tr>

  1782. <tr>

  1783. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Name</strong>:</p></td>

  1784. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>code-snippet-manager-jpa-rest</em></p></td>

  1785. </tr>

  1786. <tr>

  1787. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Package Name</strong>:</p></td>

  1788. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>io.pivotal.workshop.snippet</em></p></td>

  1789. </tr>

  1790. <tr>

  1791. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Dependencies</strong>:</p></td>

  1792. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>Web, DevTools, Groovy Templates, JPA, Rest Repositories, H2, MySQL</em></p></td>

  1793. </tr>

  1794. <tr>

  1795. <td class="tableblock halign-left valign-top"><p class="tableblock"><strong>Spring Boot</strong>:</p></td>

  1796. <td class="tableblock halign-left valign-top"><p class="tableblock"><em>2.0.0.M7</em></p></td>

  1797. </tr>

  1798. </tbody>

  1799. </table>

  1800. <div class="paragraph">

  1801. <div class="title">Figure 3.0: Spring Initializr - <a href="http://start.spring.io/" class="bare" target="_blank">http://start.spring.io/</a></div>

  1802. <p><span class="image"><img src="images/06-spring-boot-data-03.png" alt="SpringInitializr" title="Spring Initializr"></span></p>

  1803. </div>

  1804. <div class="admonitionblock tip">

  1805. <table>

  1806. <tr>

  1807. <td class="icon">

  1808. <div class="title">Tip</div>

  1809. </td>

  1810. <td class="content">

  1811. You can choose either <strong>Maven</strong> or <strong>Gradle</strong> project types.

  1812. </td>

  1813. </tr>

  1814. </table>

  1815. </div>

  1816. </li>

  1817. <li>

  1818. <p>type <strong>Web</strong>, <strong>DevTools</strong>, <strong>Groovy Templates</strong>, <strong>JPA</strong>, <strong>Rest Repositories</strong>, <strong>H2</strong>, and <strong>MySQL</strong> in the <strong><em>Dependencies</em></strong> field and press Enter.</p>

  1819. </li>

  1820. <li>

  1821. <p>Click the <strong><em>Generate Project</em></strong> button.</p>

  1822. </li>

  1823. <li>

  1824. <p>Unzip the file in any directory you want.</p>

  1825. </li>

  1826. <li>

  1827. <p>Import your project in any IDE you want.</p>

  1828. </li>

  1829. <li>

  1830. <p>Copy all the packages (with code) into the new project.</p>

  1831. </li>

  1832. <li>

  1833. <p>The only class that will change will be the <strong>SnippetController</strong>. Create/modify the folowing class:</p>

  1834. <div class="listingblock">

  1835. <div class="title">io.pivotal.workshop.snippet.controller.SnippetController.java</div>

  1836. <div class="content">

  1837. <pre class="CodeRay highlight"><code data-lang="java"><span class="keyword">package</span> <span class="namespace">io.pivotal.workshop.snippet.controller</span>;

  1838. 

  1839. <span class="keyword">import</span> <span class="include">java.util.HashMap</span>;

  1840. <span class="keyword">import</span> <span class="include">java.util.Map</span>;

  1841. 

  1842. <span class="keyword">import</span> <span class="include">org.springframework.web.bind.annotation.RequestMapping</span>;

  1843. <span class="keyword">import</span> <span class="include">org.springframework.web.bind.annotation.RestController</span>;

  1844. <span class="keyword">import</span> <span class="include">org.springframework.web.servlet.ModelAndView</span>;

  1845. 

  1846. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.repository.LanguageRepository</span>;

  1847. <span class="keyword">import</span> <span class="include">io.pivotal.workshop.snippet.repository.SnippetRepository</span>;

  1848. 

  1849. <span class="annotation">@RestController</span>

  1850. <span class="directive">public</span> <span class="type">class</span> <span class="class">SnippetController</span> {

  1851. 

  1852. 

  1853.         <span class="directive">private</span> SnippetRepository snippetRepository;

  1854.         <span class="directive">private</span> LanguageRepository languageRepository;

  1855. 

  1856.         <span class="directive">public</span> SnippetController(SnippetRepository snippetRepository,LanguageRepository languageRepository){

  1857.                 <span class="local-variable">this</span>.snippetRepository = snippetRepository;

  1858.                 <span class="local-variable">this</span>.languageRepository = languageRepository;

  1859.         }

  1860. 

  1861.         <span class="annotation">@RequestMapping</span>(<span class="string"><span class="delimiter">&quot;</span><span class="content">/</span><span class="delimiter">&quot;</span></span>)

  1862.         <span class="directive">public</span> ModelAndView home(){

  1863.                 <span class="keyword">assert</span> snippetRepository != <span class="predefined-constant">null</span>;

  1864. 

  1865.                 <span class="predefined-type">Map</span>&lt;<span class="predefined-type">String</span>,<span class="predefined-type">Object</span>&gt; model = <span class="keyword">new</span> <span class="predefined-type">HashMap</span>&lt;<span class="predefined-type">String</span>,<span class="predefined-type">Object</span>&gt;();

  1866.                 model.put(<span class="string"><span class="delimiter">&quot;</span><span class="content">langs</span><span class="delimiter">&quot;</span></span>, languageRepository.findAll());

  1867.                 model.put(<span class="string"><span class="delimiter">&quot;</span><span class="content">snippets</span><span class="delimiter">&quot;</span></span>, snippetRepository.findAll());

  1868. 

  1869.                 <span class="keyword">return</span> <span class="keyword">new</span> ModelAndView(<span class="string"><span class="delimiter">&quot;</span><span class="content">views/home</span><span class="delimiter">&quot;</span></span>,model);

  1870.         }

  1871. 

  1872. }</code></pre>

  1873. </div>

  1874. </div>

  1875. <div class="paragraph">

  1876. <p>As you can see, only is necessary the <strong>home</strong> method, and this is because the <strong>spring-data-rest</strong> module will take care of creating all the web controllers for accepting any request regarding to the domain repositories.</p>

  1877. </div>

  1878. </li>

  1879. <li>

  1880. <p>When using the <strong>spring-data-rest</strong> libraries, the default path for the controllers is the root: <strong>/</strong>, but in this case you are using the root as home page, that&#8217;s why is necessary to override the <strong>spring-data-rest</strong> context path defaults,

  1881. in the <strong>src/main/resources/application.properties</strong> file add the following:</p>

  1882. <div class="listingblock">

  1883. <div class="title">src/main/resources/application.properties</div>

  1884. <div class="content">

  1885. <pre class="CodeRay highlight"><code data-lang="properties">## JPA

  1886. spring.jpa.generate-ddl=true

  1887. spring.jpa.hibernate.ddl-auto=create-drop

  1888. 

  1889. ## REST

  1890. spring.data.rest.base-path=api</code></pre>

  1891. </div>

  1892. </div>

  1893. <div class="paragraph">

  1894. <p>Now you should be able to use the <a href="http://localhost:8080/api" class="bare" target="_blank">http://localhost:8080/api</a> to access the REST repositories.</p>

  1895. </div>

  1896. </li>

  1897. </ol>

  1898. </div>

  1899. <div class="admonitionblock tip">

  1900. <table>

  1901. <tr>

  1902. <td class="icon">

  1903. <div class="title">Tip</div>

  1904. </td>

  1905. <td class="content">

  1906. Before you run your application make sure to have copied <strong>resources/static</strong> and <strong>resources/templates</strong> files from the previous labs.

  1907. </td>

  1908. </tr>

  1909. </table>

  1910. </div>

  1911. <div class="sect2">

  1912. <h3 id="_challenges_3">Challenges</h3>

  1913. <div class="ulist">

  1914. <ul>

  1915. <li>

  1916. <p>Run the application and make sure it works.</p>

  1917. <div class="admonitionblock tip">

  1918. <table>

  1919. <tr>

  1920. <td class="icon">

  1921. <div class="title">Tip</div>

  1922. </td>

  1923. <td class="content">

  1924. See the logs and take a look at all the mapping that is being generated.

  1925. </td>

  1926. </tr>

  1927. </table>

  1928. </div>

  1929. </li>

  1930. <li>

  1931. <p>Do any necessary change to have the home page working.</p>

  1932. <div class="paragraph">

  1933. <div class="title">Figure 3.1: Code Snippet Manager JPA REST - <a href="http://localhost:8080/" class="bare" target="_blank">http://localhost:8080/</a></div>

  1934. <p><span class="image"><img src="images/06-spring-boot-data-04.png" alt="Code Snippet Manager" title="Code Snippet Manager"></span></p>

  1935. </div>

  1936. </li>

  1937. <li>

  1938. <p>Go to the <a href="http://localhost:8080/api" class="bare" target="_blank">http://localhost:8080/api</a>, you should see the following image:</p>

  1939. <div class="paragraph">

  1940. <div class="title">Figure 3.2: Code Snippet Manager JPA REST - <a href="http://localhost:8080/api" class="bare" target="_blank">http://localhost:8080/api</a></div>

  1941. <p><span class="image"><img src="images/06-spring-boot-data-05.png" alt="Code Snippet Manager API" title="Code Snippet Manager API"></span></p>

  1942. </div>

  1943. <div class="paragraph">

  1944. <p>and if you click the <a href="http://localhost:8080/api/snippets" class="bare" target="_blank">http://localhost:8080/api/snippets</a> you should see the following image:</p>

  1945. </div>

  1946. <div class="paragraph">

  1947. <div class="title">Figure 3.2: Code Snippet Manager JPA REST - <a href="http://localhost:8080/api/snippets" class="bare" target="_blank">http://localhost:8080/api/snippets</a></div>

  1948. <p><span class="image"><img src="images/06-spring-boot-data-06.png" alt="Code Snippet Manager API" title="Code Snippet Manager API"></span></p>

  1949. </div>

  1950. </li>

  1951. <li>

  1952. <p>Review all the links and see that the all the information is being translated into a <strong>JSON/HAL</strong>.</p>

  1953. </li>

  1954. <li>

  1955. <p>So far we are using the <strong>H2</strong> engine, do the necessary changes to use now <strong>MySQL</strong>, how can you accomplish this?</p>

  1956. </li>

  1957. </ul>

  1958. </div>

  1959. </div>

  1960. </div>

  1961. </div>

  1962. <div class="sect1">

  1963. <h2 id="_homework">HOMEWORK</h2>

  1964. <div class="sectionbody">

  1965. <div class="ulist">

  1966. <ul>

  1967. <li>

  1968. <p>Use multiple databases like MySQL and MongoDB (multiple Datasources).</p>

  1969. </li>

  1970. <li>

  1971. <p>Use <strong>Flyway</strong> or <strong>Liquibase</strong> to do a Database migration. Add an <strong><em>executeCommand</em></strong> field to the <strong>Code</strong> domain class. This field will tell how to execute the source code provided.</p>

  1972. </li>

  1973. <li>

  1974. <p>Use <strong>jOOQ</strong> framework.</p>

  1975. </li>

  1976. </ul>

  1977. </div>

  1978. </div>

  1979. </div>

  1980. </div>

  1981. <div id="footer">

  1982. <div id="footer-text">

  1983. Last updated 2017-11-18 11:05:24 PST

  1984. </div>

  1985. </div>

  1986. </body>

  1987. </html>