Home Explore Help
Sign In
mementomori
/
Kotlin-Backend
Watch 1
Star 0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Kotlin-Backend
/
tests
/
rest.CourseRepoTest.html

rest.CourseRepoTest.html 26 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259 
  1. <!DOCTYPE html>
    2. 

  2. <html>
    3. 

  3. <head>
    4. 

  4. <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    5. 

  5. <meta http-equiv="x-ua-compatible" content="IE=edge"/>
    6. 

  6. <title>Test results - Class rest.CourseRepoTest</title>
    7. 

  7. <link href="../css/base-style.css" rel="stylesheet" type="text/css"/>
    8. 

  8. <link href="../css/style.css" rel="stylesheet" type="text/css"/>
    9. 

  9. <script src="../js/report.js" type="text/javascript"></script>
    10. 

  10. </head>
    11. 

  11. <body>
    12. 

  12. <div id="content">
    13. 

  13. <h1>Class rest.CourseRepoTest</h1>
    14. 

  14. <div class="breadcrumbs">
    15. 

  15. <a href="../index.html">all</a> &gt; 
    16. 

  16. <a href="../packages/rest.html">rest</a> &gt; CourseRepoTest</div>
    17. 

  17. <div id="summary">
    18. 

  18. <table>
    19. 

  19. <tr>
    20. 

  20. <td>
    21. 

  21. <div class="summaryGroup">
    22. 

  22. <table>
    23. 

  23. <tr>
    24. 

  24. <td>
    25. 

  25. <div class="infoBox" id="tests">
    26. 

  26. <div class="counter">1</div>
    27. 

  27. <p>tests</p>
    28. 

  28. </div>
    29. 

  29. </td>
    30. 

  30. <td>
    31. 

  31. <div class="infoBox" id="failures">
    32. 

  32. <div class="counter">0</div>
    33. 

  33. <p>failures</p>
    34. 

  34. </div>
    35. 

  35. </td>
    36. 

  36. <td>
    37. 

  37. <div class="infoBox" id="ignored">
    38. 

  38. <div class="counter">0</div>
    39. 

  39. <p>ignored</p>
    40. 

  40. </div>
    41. 

  41. </td>
    42. 

  42. <td>
    43. 

  43. <div class="infoBox" id="duration">
    44. 

  44. <div class="counter">1.305s</div>
    45. 

  45. <p>duration</p>
    46. 

  46. </div>
    47. 

  47. </td>
    48. 

  48. </tr>
    49. 

  49. </table>
    50. 

  50. </div>
    51. 

  51. </td>
    52. 

  52. <td>
    53. 

  53. <div class="infoBox success" id="successRate">
    54. 

  54. <div class="percent">100%</div>
    55. 

  55. <p>successful</p>
    56. 

  56. </div>
    57. 

  57. </td>
    58. 

  58. </tr>
    59. 

  59. </table>
    60. 

  60. </div>
    61. 

  61. <div id="tabs">
    62. 

  62. <ul class="tabLinks">
    63. 

  63. <li>
    64. 

  64. <a href="#tab0">Tests</a>
    65. 

  65. </li>
    66. 

  66. <li>
    67. 

  67. <a href="#tab1">Standard output</a>
    68. 

  68. </li>
    69. 

  69. </ul>
    70. 

  70. <div id="tab0" class="tab">
    71. 

  71. <h2>Tests</h2>
    72. 

  72. <table>
    73. 

  73. <thead>
    74. 

  74. <tr>
    75. 

  75. <th>Test</th>
    76. 

  76. <th>Duration</th>
    77. 

  77. <th>Result</th>
    78. 

  78. </tr>
    79. 

  79. </thead>
    80. 

  80. <tr>
    81. 

  81. <td class="success">courseRepoMapTest</td>
    82. 

  82. <td class="success">1.305s</td>
    83. 

  83. <td class="success">passed</td>
    84. 

  84. </tr>
    85. 

  85. </table>
    86. 

  86. </div>
    87. 

  87. <div id="tab1" class="tab">
    88. 

  88. <h2>Standard output</h2>
    89. 

  89. <span class="code">
    90. 

  90. <pre>17:58:49.493 [Test worker] DEBUG Exposed - SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'MODE'
    91. 

  91. 17:58:49.513 [Test worker] DEBUG Exposed - CREATE TABLE IF NOT EXISTS TUTOR (ID INT AUTO_INCREMENT PRIMARY KEY, &quot;NAME&quot; VARCHAR(255) NOT NULL, POST VARCHAR(50) NOT NULL)
    92. 

  92. 17:58:49.513 [Test worker] DEBUG Exposed - CREATE TABLE IF NOT EXISTS STUDENT (ID INT AUTO_INCREMENT PRIMARY KEY, &quot;NAME&quot; VARCHAR(255) NOT NULL, GOROUP VARCHAR(70) NOT NULL)
    93. 

  93. 17:58:49.513 [Test worker] DEBUG Exposed - CREATE TABLE IF NOT EXISTS COURSE (ID INT AUTO_INCREMENT PRIMARY KEY, &quot;NAME&quot; VARCHAR(50) NOT NULL)
    94. 

  94. 17:58:49.522 [Test worker] DEBUG Exposed - CREATE TABLE IF NOT EXISTS COURSESTUDENT (ID INT AUTO_INCREMENT PRIMARY KEY, COURSE_ID INT NOT NULL, STUDENT_ID INT NOT NULL, CONSTRAINT FK_COURSESTUDENT_COURSE_ID_ID FOREIGN KEY (COURSE_ID) REFERENCES COURSE(ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_COURSESTUDENT_STUDENT_ID_ID FOREIGN KEY (STUDENT_ID) REFERENCES STUDENT(ID) ON DELETE RESTRICT ON UPDATE RESTRICT)
    95. 

  95. 17:58:49.532 [Test worker] DEBUG Exposed - CREATE TABLE IF NOT EXISTS COURSETUTOR (ID INT AUTO_INCREMENT PRIMARY KEY, COURSE_ID INT NOT NULL, TUTOR_ID INT NOT NULL, CONSTRAINT FK_COURSETUTOR_COURSE_ID_ID FOREIGN KEY (COURSE_ID) REFERENCES COURSE(ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_COURSETUTOR_TUTOR_ID_ID FOREIGN KEY (TUTOR_ID) REFERENCES TUTOR(ID) ON DELETE RESTRICT ON UPDATE RESTRICT)
    96. 

  96. 17:58:49.533 [Test worker] DEBUG Exposed - CREATE TABLE IF NOT EXISTS &quot;TYPE&quot; (ID INT AUTO_INCREMENT PRIMARY KEY, &quot;NAME&quot; VARCHAR(50) NOT NULL, &quot;shortName&quot; VARCHAR(20) NOT NULL)
    97. 

  97. 17:58:49.533 [Test worker] DEBUG Exposed - CREATE TABLE IF NOT EXISTS TASK (ID INT AUTO_INCREMENT PRIMARY KEY, &quot;NAME&quot; VARCHAR(255) NOT NULL, &quot;type_ID&quot; INT NOT NULL, COURSE_ID INT NOT NULL, DESCRIPTION VARCHAR(255) NOT NULL, &quot;maxValue&quot; INT NOT NULL, DEADLINE DATE NOT NULL, CONSTRAINT FK_TASK_TYPE_ID_ID FOREIGN KEY (&quot;type_ID&quot;) REFERENCES &quot;TYPE&quot;(ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_TASK_COURSE_ID_ID FOREIGN KEY (COURSE_ID) REFERENCES COURSE(ID) ON DELETE RESTRICT ON UPDATE RESTRICT)
    98. 

  98. 17:58:49.533 [Test worker] DEBUG Exposed - CREATE TABLE IF NOT EXISTS GRADES (ID INT AUTO_INCREMENT PRIMARY KEY, &quot;VALUE&quot; INT NOT NULL, &quot;DATE&quot; DATE NOT NULL, &quot;student_ID&quot; INT NOT NULL, &quot;task_ID&quot; INT NOT NULL, CONSTRAINT FK_GRADES_STUDENT_ID_ID FOREIGN KEY (&quot;student_ID&quot;) REFERENCES STUDENT(ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_GRADES_TASK_ID_ID FOREIGN KEY (&quot;task_ID&quot;) REFERENCES TASK(ID) ON DELETE RESTRICT ON UPDATE RESTRICT)
    99. 

  99. 17:58:49.543 [Test worker] DEBUG Exposed - CREATE TABLE IF NOT EXISTS TOPLIST (ID INT AUTO_INCREMENT PRIMARY KEY, STUDENT_ID INT NOT NULL, COURSE_ID INT NOT NULL, &quot;RANK&quot; DOUBLE PRECISION NOT NULL, CONSTRAINT FK_TOPLIST_STUDENT_ID_ID FOREIGN KEY (STUDENT_ID) REFERENCES STUDENT(ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_TOPLIST_COURSE_ID_ID FOREIGN KEY (COURSE_ID) REFERENCES COURSE(ID) ON DELETE RESTRICT ON UPDATE RESTRICT)
    100. 

  100. 17:58:49.556 [Test worker] DEBUG Exposed - INSERT INTO TUTOR (&quot;NAME&quot;, POST) VALUES ('Sheldon', 'Professor')
    101. 

  101. 17:58:49.556 [Test worker] DEBUG Exposed - INSERT INTO TUTOR (&quot;NAME&quot;, POST) VALUES ('Leonard', 'Professor')
    102. 

  102. 17:58:49.562 [Test worker] DEBUG Exposed - INSERT INTO TUTOR (&quot;NAME&quot;, POST) VALUES ('Ada', 'Invited lecturer')
    103. 

  103. 17:58:49.566 [Test worker] DEBUG Exposed - INSERT INTO STUDENT (GOROUP, &quot;NAME&quot;) VALUES ('Footprint on the Moon', 'Howard')
    104. 

  104. 17:58:49.567 [Test worker] DEBUG Exposed - INSERT INTO STUDENT (GOROUP, &quot;NAME&quot;) VALUES ('Footprint on the Moon', 'Raj')
    105. 

  105. 17:58:49.567 [Test worker] DEBUG Exposed - INSERT INTO STUDENT (GOROUP, &quot;NAME&quot;) VALUES ('Waitress', 'Penny')
    106. 

  106. 17:58:49.572 [Test worker] DEBUG Exposed - INSERT INTO &quot;TYPE&quot; (&quot;NAME&quot;, &quot;shortName&quot;) VALUES ('Lecture', 'Lec')
    107. 

  107. 17:58:49.573 [Test worker] DEBUG Exposed - INSERT INTO &quot;TYPE&quot; (&quot;NAME&quot;, &quot;shortName&quot;) VALUES ('Practice', 'Pract')
    108. 

  108. 17:58:49.573 [Test worker] DEBUG Exposed - INSERT INTO &quot;TYPE&quot; (&quot;NAME&quot;, &quot;shortName&quot;) VALUES ('Test', 'Test')
    109. 

  109. 17:58:49.623 [Test worker] INFO ktor.test - No ktor.deployment.watch patterns specified, automatic reload is not active
    110. 

  110. 17:58:49.757 [DefaultDispatcher-worker-1 @request#1] DEBUG Exposed - INSERT INTO COURSE (&quot;NAME&quot;) VALUES ('Math')
    111. 

  111. 17:58:49.773 [DefaultDispatcher-worker-1 @request#3] DEBUG Exposed - INSERT INTO COURSE (&quot;NAME&quot;) VALUES ('Phys')
    112. 

  112. 17:58:49.782 [DefaultDispatcher-worker-1 @request#5] DEBUG Exposed - INSERT INTO COURSE (&quot;NAME&quot;) VALUES ('Hist')
    113. 

  113. 17:58:49.782 [Test worker] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR
    114. 

  114. 17:58:49.802 [DefaultDispatcher-worker-1 @request#9] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    115. 

  115. 17:58:49.803 [DefaultDispatcher-worker-1 @request#9] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 1
    116. 

  116. 17:58:49.803 [DefaultDispatcher-worker-1 @request#9] DEBUG Exposed - INSERT INTO COURSETUTOR (COURSE_ID, TUTOR_ID) VALUES (1, 1)
    117. 

  117. 17:58:49.812 [DefaultDispatcher-worker-1 @request#11] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    118. 

  118. 17:58:49.814 [DefaultDispatcher-worker-1 @request#11] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 2
    119. 

  119. 17:58:49.815 [DefaultDispatcher-worker-1 @request#11] DEBUG Exposed - INSERT INTO COURSETUTOR (COURSE_ID, TUTOR_ID) VALUES (1, 2)
    120. 

  120. 17:58:49.818 [DefaultDispatcher-worker-1 @request#13] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    121. 

  121. 17:58:49.818 [DefaultDispatcher-worker-1 @request#13] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 3
    122. 

  122. 17:58:49.822 [DefaultDispatcher-worker-1 @request#13] DEBUG Exposed - INSERT INTO COURSETUTOR (COURSE_ID, TUTOR_ID) VALUES (1, 3)
    123. 

  123. 17:58:49.824 [DefaultDispatcher-worker-1 @request#15] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    124. 

  124. 17:58:49.824 [DefaultDispatcher-worker-1 @request#15] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 9
    125. 

  125. 17:58:49.824 [Test worker] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT
    126. 

  126. 17:58:49.833 [DefaultDispatcher-worker-1 @request#17] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    127. 

  127. 17:58:49.833 [DefaultDispatcher-worker-1 @request#17] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 1
    128. 

  128. 17:58:49.833 [DefaultDispatcher-worker-1 @request#17] DEBUG Exposed - INSERT INTO COURSESTUDENT (COURSE_ID, STUDENT_ID) VALUES (1, 1)
    129. 

  129. 17:58:49.843 [DefaultDispatcher-worker-1 @request#19] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    130. 

  130. 17:58:49.843 [DefaultDispatcher-worker-1 @request#19] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 2
    131. 

  131. 17:58:49.843 [DefaultDispatcher-worker-1 @request#19] DEBUG Exposed - INSERT INTO COURSESTUDENT (COURSE_ID, STUDENT_ID) VALUES (1, 2)
    132. 

  132. 17:58:49.843 [DefaultDispatcher-worker-1 @request#21] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    133. 

  133. 17:58:49.843 [DefaultDispatcher-worker-1 @request#21] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 3
    134. 

  134. 17:58:49.843 [DefaultDispatcher-worker-1 @request#21] DEBUG Exposed - INSERT INTO COURSESTUDENT (COURSE_ID, STUDENT_ID) VALUES (1, 3)
    135. 

  135. 17:58:49.853 [DefaultDispatcher-worker-1 @request#23] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    136. 

  136. 17:58:49.856 [DefaultDispatcher-worker-1 @request#23] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 9
    137. 

  137. 17:58:49.863 [DefaultDispatcher-worker-1 @request#25] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    138. 

  138. 17:58:49.877 [DefaultDispatcher-worker-1 @request#25] DEBUG Exposed - INSERT INTO TASK (COURSE_ID, DEADLINE, DESCRIPTION, &quot;maxValue&quot;, &quot;NAME&quot;, &quot;type_ID&quot;) VALUES (1, '2020-12-06', '', 5, 'first task', 1)
    139. 

  139. 17:58:49.877 [DefaultDispatcher-worker-1 @request#27] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    140. 

  140. 17:58:49.882 [DefaultDispatcher-worker-1 @request#27] DEBUG Exposed - INSERT INTO TASK (COURSE_ID, DEADLINE, DESCRIPTION, &quot;maxValue&quot;, &quot;NAME&quot;, &quot;type_ID&quot;) VALUES (1, '2020-12-06', '', 5, 'second task', 1)
    141. 

  141. 17:58:49.884 [DefaultDispatcher-worker-1 @request#29] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    142. 

  142. 17:58:49.884 [DefaultDispatcher-worker-1 @request#31] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    143. 

  143. 17:58:49.884 [DefaultDispatcher-worker-1 @request#31] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    144. 

  144. 17:58:49.893 [DefaultDispatcher-worker-1 @request#31] DEBUG Exposed - INSERT INTO GRADES (&quot;DATE&quot;, &quot;student_ID&quot;, &quot;task_ID&quot;, &quot;VALUE&quot;) VALUES ('2020-12-06', 1, 1, 5)
    145. 

  145. 17:58:49.893 [DefaultDispatcher-worker-1 @request#33] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    146. 

  146. 17:58:49.893 [DefaultDispatcher-worker-1 @request#33] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    147. 

  147. 17:58:49.901 [DefaultDispatcher-worker-1 @request#33] DEBUG Exposed - INSERT INTO GRADES (&quot;DATE&quot;, &quot;student_ID&quot;, &quot;task_ID&quot;, &quot;VALUE&quot;) VALUES ('2020-12-06', 2, 1, 3)
    148. 

  148. 17:58:49.902 [DefaultDispatcher-worker-1 @request#35] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    149. 

  149. 17:58:49.906 [DefaultDispatcher-worker-1 @request#37] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE
    150. 

  150. 17:58:49.931 [DefaultDispatcher-worker-3 @request#41] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    151. 

  151. 17:58:49.934 [DefaultDispatcher-worker-4 @request#45] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    152. 

  152. 17:58:49.936 [DefaultDispatcher-worker-4 @request#45] DEBUG Exposed - SELECT COURSETUTOR.ID, COURSETUTOR.COURSE_ID, COURSETUTOR.TUTOR_ID FROM COURSETUTOR
    153. 

  153. 17:58:49.938 [DefaultDispatcher-worker-4 @request#45] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 1
    154. 

  154. 17:58:49.939 [DefaultDispatcher-worker-4 @request#45] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 2
    155. 

  155. 17:58:49.941 [DefaultDispatcher-worker-4 @request#45] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 3
    156. 

  156. 17:58:49.946 [DefaultDispatcher-worker-1 @request#49] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    157. 

  157. 17:58:49.949 [DefaultDispatcher-worker-1 @request#49] DEBUG Exposed - SELECT COURSESTUDENT.ID, COURSESTUDENT.COURSE_ID, COURSESTUDENT.STUDENT_ID FROM COURSESTUDENT
    158. 

  158. 17:58:49.951 [DefaultDispatcher-worker-1 @request#49] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 1
    159. 

  159. 17:58:49.952 [DefaultDispatcher-worker-1 @request#49] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 2
    160. 

  160. 17:58:49.954 [DefaultDispatcher-worker-1 @request#49] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 3
    161. 

  161. 17:58:49.962 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    162. 

  162. 17:58:49.963 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT TOPLIST.ID, TOPLIST.STUDENT_ID, TOPLIST.COURSE_ID, TOPLIST.&quot;RANK&quot; FROM TOPLIST
    163. 

  163. 17:58:49.963 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSESTUDENT.ID, COURSESTUDENT.COURSE_ID, COURSESTUDENT.STUDENT_ID FROM COURSESTUDENT
    164. 

  164. 17:58:49.963 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 1
    165. 

  165. 17:58:49.963 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 2
    166. 

  166. 17:58:49.972 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 3
    167. 

  167. 17:58:49.977 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    168. 

  168. 17:58:49.977 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 1
    169. 

  169. 17:58:49.982 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT TOPLIST.ID, TOPLIST.STUDENT_ID, TOPLIST.COURSE_ID, TOPLIST.&quot;RANK&quot; FROM TOPLIST
    170. 

  170. 17:58:49.984 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    171. 

  171. 17:58:49.984 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT GRADES.ID, GRADES.&quot;VALUE&quot;, GRADES.&quot;DATE&quot;, GRADES.&quot;student_ID&quot;, GRADES.&quot;task_ID&quot; FROM GRADES WHERE GRADES.&quot;student_ID&quot; = 1
    172. 

  172. 17:58:49.984 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT &quot;TYPE&quot;.ID, &quot;TYPE&quot;.&quot;NAME&quot;, &quot;TYPE&quot;.&quot;shortName&quot; FROM &quot;TYPE&quot; WHERE &quot;TYPE&quot;.ID = 1
    173. 

  173. 17:58:49.984 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - INSERT INTO TOPLIST (COURSE_ID, &quot;RANK&quot;, STUDENT_ID) VALUES (1, 0.1, 1)
    174. 

  174. 17:58:49.993 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    175. 

  175. 17:58:49.993 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 2
    176. 

  176. 17:58:49.993 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT TOPLIST.ID, TOPLIST.STUDENT_ID, TOPLIST.COURSE_ID, TOPLIST.&quot;RANK&quot; FROM TOPLIST
    177. 

  177. 17:58:49.993 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    178. 

  178. 17:58:49.993 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 1
    179. 

  179. 17:58:49.993 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    180. 

  180. 17:58:50.001 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT GRADES.ID, GRADES.&quot;VALUE&quot;, GRADES.&quot;DATE&quot;, GRADES.&quot;student_ID&quot;, GRADES.&quot;task_ID&quot; FROM GRADES WHERE GRADES.&quot;student_ID&quot; = 2
    181. 

  181. 17:58:50.002 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT &quot;TYPE&quot;.ID, &quot;TYPE&quot;.&quot;NAME&quot;, &quot;TYPE&quot;.&quot;shortName&quot; FROM &quot;TYPE&quot; WHERE &quot;TYPE&quot;.ID = 1
    182. 

  182. 17:58:50.002 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - INSERT INTO TOPLIST (COURSE_ID, &quot;RANK&quot;, STUDENT_ID) VALUES (1, 0.0, 2)
    183. 

  183. 17:58:50.002 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    184. 

  184. 17:58:50.002 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 3
    185. 

  185. 17:58:50.006 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT TOPLIST.ID, TOPLIST.STUDENT_ID, TOPLIST.COURSE_ID, TOPLIST.&quot;RANK&quot; FROM TOPLIST
    186. 

  186. 17:58:50.006 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    187. 

  187. 17:58:50.006 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 1
    188. 

  188. 17:58:50.013 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    189. 

  189. 17:58:50.013 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 2
    190. 

  190. 17:58:50.016 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    191. 

  191. 17:58:50.018 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT GRADES.ID, GRADES.&quot;VALUE&quot;, GRADES.&quot;DATE&quot;, GRADES.&quot;student_ID&quot;, GRADES.&quot;task_ID&quot; FROM GRADES WHERE GRADES.&quot;student_ID&quot; = 3
    192. 

  192. 17:58:50.019 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - INSERT INTO TOPLIST (COURSE_ID, &quot;RANK&quot;, STUDENT_ID) VALUES (1, 0.0, 3)
    193. 

  193. 17:58:50.021 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT TOPLIST.ID, TOPLIST.STUDENT_ID, TOPLIST.COURSE_ID, TOPLIST.&quot;RANK&quot; FROM TOPLIST
    194. 

  194. 17:58:50.022 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    195. 

  195. 17:58:50.023 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 1
    196. 

  196. 17:58:50.023 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    197. 

  197. 17:58:50.024 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 2
    198. 

  198. 17:58:50.024 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    199. 

  199. 17:58:50.025 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 3
    200. 

  200. 17:58:50.029 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    201. 

  201. 17:58:50.031 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 1
    202. 

  202. 17:58:50.032 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    203. 

  203. 17:58:50.033 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 2
    204. 

  204. 17:58:50.034 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    205. 

  205. 17:58:50.035 [DefaultDispatcher-worker-2 @request#53] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 3
    206. 

  206. 17:58:50.040 [DefaultDispatcher-worker-2 @request#57] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    207. 

  207. 17:58:50.042 [DefaultDispatcher-worker-2 @request#57] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    208. 

  208. 17:58:50.054 [DefaultDispatcher-worker-2 @request#61] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    209. 

  209. 17:58:50.056 [DefaultDispatcher-worker-2 @request#61] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    210. 

  210. 17:58:50.062 [DefaultDispatcher-worker-2 @request#65] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    211. 

  211. 17:58:50.062 [DefaultDispatcher-worker-2 @request#65] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    212. 

  212. 17:58:50.062 [DefaultDispatcher-worker-2 @request#65] DEBUG Exposed - SELECT GRADES.ID, GRADES.&quot;VALUE&quot;, GRADES.&quot;DATE&quot;, GRADES.&quot;student_ID&quot;, GRADES.&quot;task_ID&quot; FROM GRADES
    213. 

  213. 17:58:50.073 [DefaultDispatcher-worker-2 @request#69] DEBUG Exposed - UPDATE COURSE SET &quot;NAME&quot;='MathNew' WHERE COURSE.ID = 1
    214. 

  214. 17:58:50.083 [DefaultDispatcher-worker-2 @request#71] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    215. 

  215. 17:58:50.092 [DefaultDispatcher-worker-2 @request#75] DEBUG Exposed - DELETE FROM COURSE WHERE COURSE.ID = 3
    216. 

  216. 17:58:50.093 [DefaultDispatcher-worker-2 @request#77] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    217. 

  217. 17:58:50.093 [DefaultDispatcher-worker-2 @request#77] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 1
    218. 

  218. 17:58:50.102 [DefaultDispatcher-worker-2 @request#77] DEBUG Exposed - DELETE FROM COURSETUTOR WHERE (COURSETUTOR.COURSE_ID = 1) AND (COURSETUTOR.TUTOR_ID = 1)
    219. 

  219. 17:58:50.102 [DefaultDispatcher-worker-2 @request#79] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    220. 

  220. 17:58:50.102 [DefaultDispatcher-worker-2 @request#79] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 3
    221. 

  221. 17:58:50.107 [DefaultDispatcher-worker-2 @request#79] DEBUG Exposed - DELETE FROM COURSESTUDENT WHERE (COURSESTUDENT.COURSE_ID = 1) AND (COURSESTUDENT.STUDENT_ID = 3)
    222. 

  222. 17:58:50.107 [DefaultDispatcher-worker-2 @request#81] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE WHERE COURSE.ID = 1
    223. 

  223. 17:58:50.115 [DefaultDispatcher-worker-2 @request#81] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    224. 

  224. 17:58:50.121 [DefaultDispatcher-worker-2 @request#81] DEBUG Exposed - DELETE FROM GRADES WHERE GRADES.&quot;task_ID&quot; = 1
    225. 

  225. 17:58:50.123 [DefaultDispatcher-worker-2 @request#81] DEBUG Exposed - DELETE FROM TASK WHERE (TASK.COURSE_ID = 1) AND (TASK.ID = 1)
    226. 

  226. 17:58:50.123 [DefaultDispatcher-worker-2 @request#83] DEBUG Exposed - SELECT COURSE.ID, COURSE.&quot;NAME&quot; FROM COURSE
    227. 

  227. 17:58:50.132 [Test worker] DEBUG Exposed - SELECT COURSETUTOR.ID, COURSETUTOR.COURSE_ID, COURSETUTOR.TUTOR_ID FROM COURSETUTOR
    228. 

  228. 17:58:50.132 [Test worker] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 2
    229. 

  229. 17:58:50.132 [Test worker] DEBUG Exposed - SELECT TUTOR.ID, TUTOR.&quot;NAME&quot;, TUTOR.POST FROM TUTOR WHERE TUTOR.ID = 3
    230. 

  230. 17:58:50.132 [Test worker] DEBUG Exposed - SELECT COURSESTUDENT.ID, COURSESTUDENT.COURSE_ID, COURSESTUDENT.STUDENT_ID FROM COURSESTUDENT
    231. 

  231. 17:58:50.132 [Test worker] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 1
    232. 

  232. 17:58:50.132 [Test worker] DEBUG Exposed - SELECT STUDENT.ID, STUDENT.&quot;NAME&quot;, STUDENT.GOROUP FROM STUDENT WHERE STUDENT.ID = 2
    233. 

  233. 17:58:50.132 [Test worker] DEBUG Exposed - SELECT TASK.ID, TASK.&quot;NAME&quot;, TASK.&quot;type_ID&quot;, TASK.COURSE_ID, TASK.DESCRIPTION, TASK.&quot;maxValue&quot;, TASK.DEADLINE FROM TASK
    234. 

  234. 17:58:50.143 [Test worker] DEBUG Exposed - DROP TABLE IF EXISTS TOPLIST
    235. 

  235. 17:58:50.143 [Test worker] DEBUG Exposed - DROP TABLE IF EXISTS GRADES
    236. 

  236. 17:58:50.143 [Test worker] DEBUG Exposed - DROP TABLE IF EXISTS TASK
    237. 

  237. 17:58:50.143 [Test worker] DEBUG Exposed - DROP TABLE IF EXISTS &quot;TYPE&quot;
    238. 

  238. 17:58:50.143 [Test worker] DEBUG Exposed - DROP TABLE IF EXISTS COURSETUTOR
    239. 

  239. 17:58:50.143 [Test worker] DEBUG Exposed - DROP TABLE IF EXISTS TUTOR
    240. 

  240. 17:58:50.143 [Test worker] DEBUG Exposed - DROP TABLE IF EXISTS COURSESTUDENT
    241. 

  241. 17:58:50.143 [Test worker] DEBUG Exposed - DROP TABLE IF EXISTS STUDENT
    242. 

  242. 17:58:50.143 [Test worker] DEBUG Exposed - DROP TABLE IF EXISTS COURSE
    243. 

  243. </pre>
    244. 

  244. </span>
    245. 

  245. </div>
    246. 

  246. </div>
    247. 

  247. <div id="footer">
    248. 

  248. <p>
    249. 

  249. <div>
    250. 

  250. <label class="hidden" id="label-for-line-wrapping-toggle" for="line-wrapping-toggle">Wrap lines
    251. 

  251. <input id="line-wrapping-toggle" type="checkbox" autocomplete="off"/>
    252. 

  252. </label>
    253. 

  253. </div>Generated by 
    254. 

  254. <a href="http://www.gradle.org">Gradle 6.5</a> at Dec 6, 2020, 5:58:50 PM</p>
    255. 

  255. </div>
    256. 

  256. </div>
    257. 

  257. </body>
    258. 

  258. </html>
    259. 

  259.