CSV.Test 8.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339
  1. # Testing the functionality of the module HRVAnalysis
  2. #
  3. # The following denotes to the parser which regression test file to use.
  4. # $Regression: CSV.Test.tmp$
  5. # WMUtilities.Call PCTest.Execute CSV.Test ~ Verbose testing mode
  6. # WMUtilities.Call PCTest.Execute CSV.Test CSV.Test.tmp ~ Regression testing mode
  7. # Use halt or asserts to check for the output you expect
  8. # There are two directives for the test cases:
  9. # - positive
  10. # expects that no ASSERT fails and no HALT is executed
  11. # - negative
  12. # expects that a HALT is executed or an ASSERT fails
  13. #
  14. # It is better to specify all running test cases as positive so the trap window only opens
  15. # really if a test case failed.
  16. positive: UNLOAD the CSV module before the tests
  17. MODULE Test;
  18. IMPORT Modules;
  19. VAR res: WORD; msg: ARRAY 64 OF CHAR;
  20. BEGIN
  21. Modules.FreeModule("TestShared", res, msg);
  22. Modules.FreeModule("CSV", res, msg);
  23. END Test.
  24. positive: setup test base module with shared functions
  25. MODULE TestShared;
  26. IMPORT Files, CSV, Modules, Strings;
  27. CONST fn = "CSV.Test.input.tmp.csv";
  28. VAR f: Files.File; w: Files.Writer; canTest: BOOLEAN;
  29. PROCEDURE GetWriter*(): Files.Writer;
  30. BEGIN
  31. ASSERT(canTest);
  32. IF w = NIL THEN
  33. f := Files.New(fn);
  34. Files.OpenWriter(w, f, 0);
  35. END;
  36. RETURN w;
  37. END GetWriter;
  38. PROCEDURE CloseWriter*;
  39. BEGIN
  40. ASSERT(canTest);
  41. w.Update(); Files.Register(f); f := NIL; w := NIL;
  42. END CloseWriter;
  43. PROCEDURE GetScanner*(csv: CSV.CSV): CSV.Scanner;
  44. VAR r: Files.Reader; fl: Files.File; scan: CSV.Scanner;
  45. BEGIN
  46. ASSERT(canTest);
  47. fl := Files.Old(fn);
  48. Files.OpenReader(r, fl, 0);
  49. NEW(scan, csv, r);
  50. RETURN scan;
  51. END GetScanner;
  52. PROCEDURE Cleanup;
  53. VAR fnstr: Strings.String; res: WORD;
  54. BEGIN
  55. IF canTest THEN
  56. fnstr := Strings.NewString(fn);
  57. Files.Delete(fnstr^, res);
  58. END;
  59. END Cleanup;
  60. BEGIN
  61. canTest := Files.Old(fn) = NIL;
  62. Modules.InstallTermHandler(Cleanup);
  63. END TestShared.
  64. positive: parse empty file gives empty CSV
  65. MODULE Test;
  66. IMPORT CSV, Streams, Strings, TestShared;
  67. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  68. BEGIN
  69. w := TestShared.GetWriter();
  70. csvref := CSV.GetDefaultCSV();
  71. csvref.NewLine();
  72. TestShared.CloseWriter();
  73. csv := CSV.GetDefaultCSV();
  74. s := TestShared.GetScanner(csv);
  75. s.Scan();
  76. ASSERT(CSV.CompareCSVs(csv, csvref));
  77. END Test.
  78. positive: completely empty line doesn't produce a field
  79. MODULE Test;
  80. IMPORT CSV, Streams, Strings, TestShared;
  81. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  82. BEGIN
  83. w := TestShared.GetWriter();
  84. csvref := CSV.GetDefaultCSV();
  85. csvref.NewLine();
  86. csvref.AddField("Test line"); csvref.AddField("32");
  87. w.String('"Test line",32');
  88. csvref.NewLine();
  89. w.Ln();
  90. TestShared.CloseWriter();
  91. csv := CSV.GetDefaultCSV();
  92. s := TestShared.GetScanner(csv);
  93. s.Scan();
  94. ASSERT(CSV.CompareCSVs(csv, csvref));
  95. END Test.
  96. positive: empty field at the beginning of a line is recognised
  97. MODULE Test;
  98. IMPORT CSV, Streams, Strings, TestShared;
  99. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  100. BEGIN
  101. w := TestShared.GetWriter();
  102. csvref := CSV.GetDefaultCSV();
  103. csvref.NewLine();
  104. csvref.AddField(""); csvref.AddField("First field empty"); csvref.AddField("134");
  105. w.String('"","First field empty",134');
  106. csvref.NewLine();
  107. w.Ln();
  108. TestShared.CloseWriter();
  109. csv := CSV.GetDefaultCSV();
  110. s := TestShared.GetScanner(csv);
  111. s.Scan();
  112. ASSERT(CSV.CompareCSVs(csv, csvref));
  113. END Test.
  114. positive: empty field at end of line is recognised as such
  115. MODULE Test;
  116. IMPORT CSV, Streams, Strings, TestShared;
  117. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  118. BEGIN
  119. w := TestShared.GetWriter();
  120. csvref := CSV.GetDefaultCSV();
  121. csvref.NewLine();
  122. csvref.AddField("Test empty EOL field"); csvref.AddField("31"); csvref.AddField("");
  123. w.String('"Test empty EOL field",31,""');
  124. TestShared.CloseWriter();
  125. csv := CSV.GetDefaultCSV();
  126. s := TestShared.GetScanner(csv);
  127. s.Scan();
  128. ASSERT(CSV.CompareCSVs(csv, csvref));
  129. END Test.
  130. positive: parse simple line 1
  131. MODULE Test;
  132. IMPORT CSV, Streams, Strings, TestShared;
  133. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  134. BEGIN
  135. w := TestShared.GetWriter();
  136. csvref := CSV.GetDefaultCSV();
  137. csvref.NewLine();
  138. csvref.AddField("Parker"); csvref.AddField("Howard"); csvref.AddField("32"); csvref.AddField("River Avenue 12");
  139. w.String('Parker, Howard, 32, "River Avenue 12"');
  140. TestShared.CloseWriter();
  141. csv := CSV.GetDefaultCSV();
  142. s := TestShared.GetScanner(csv);
  143. s.Scan();
  144. ASSERT(CSV.CompareCSVs(csv, csvref));
  145. END Test.
  146. positive: parse field
  147. MODULE Test;
  148. IMPORT CSV, Streams, Strings, TestShared;
  149. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  150. BEGIN
  151. w := TestShared.GetWriter();
  152. csvref := CSV.GetDefaultCSV();
  153. csvref.NewLine();
  154. csvref.AddField("Parker");
  155. w.String('Parker');
  156. TestShared.CloseWriter();
  157. csv := CSV.GetDefaultCSV();
  158. s := TestShared.GetScanner(csv);
  159. s.Scan();
  160. ASSERT(CSV.CompareCSVs(csv, csvref));
  161. END Test.
  162. positive: parse field and ignore leading whitespace not in quotes
  163. MODULE Test;
  164. IMPORT CSV, Streams, Strings, TestShared;
  165. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  166. BEGIN
  167. w := TestShared.GetWriter();
  168. csvref := CSV.GetDefaultCSV();
  169. csvref.NewLine();
  170. csvref.AddField("Parker");
  171. w.String(' Parker');
  172. TestShared.CloseWriter();
  173. csv := CSV.GetDefaultCSV();
  174. s := TestShared.GetScanner(csv);
  175. s.Scan();
  176. ASSERT(CSV.CompareCSVs(csv, csvref));
  177. END Test.
  178. positive: parse field and keep leading whitespace in quotes
  179. MODULE Test;
  180. IMPORT CSV, Streams, Strings, TestShared;
  181. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  182. BEGIN
  183. w := TestShared.GetWriter();
  184. csvref := CSV.GetDefaultCSV();
  185. csvref.NewLine();
  186. csvref.AddField(" Parker");
  187. w.String('" Parker"');
  188. TestShared.CloseWriter();
  189. csv := CSV.GetDefaultCSV();
  190. s := TestShared.GetScanner(csv);
  191. s.Scan();
  192. ASSERT(CSV.CompareCSVs(csv, csvref));
  193. END Test.
  194. positive: parse field and ignore trailing whitespace not in quotes
  195. MODULE Test;
  196. IMPORT CSV, Streams, Strings, TestShared;
  197. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  198. BEGIN
  199. w := TestShared.GetWriter();
  200. csvref := CSV.GetDefaultCSV();
  201. csvref.NewLine();
  202. csvref.AddField("Parker");
  203. w.String('Parker ');
  204. TestShared.CloseWriter();
  205. csv := CSV.GetDefaultCSV();
  206. s := TestShared.GetScanner(csv);
  207. s.Scan();
  208. ASSERT(CSV.CompareCSVs(csv, csvref));
  209. END Test.
  210. positive: parse field and keep trailing whitespace in quotes
  211. MODULE Test;
  212. IMPORT CSV, Streams, Strings, TestShared;
  213. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  214. BEGIN
  215. w := TestShared.GetWriter();
  216. csvref := CSV.GetDefaultCSV();
  217. csvref.NewLine();
  218. csvref.AddField("Parker ");
  219. w.String('"Parker "');
  220. TestShared.CloseWriter();
  221. csv := CSV.GetDefaultCSV();
  222. s := TestShared.GetScanner(csv);
  223. s.Scan();
  224. ASSERT(CSV.CompareCSVs(csv, csvref));
  225. END Test.
  226. positive: parse simple file
  227. MODULE Test;
  228. IMPORT CSV, Streams, Strings, TestShared;
  229. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  230. BEGIN
  231. w := TestShared.GetWriter();
  232. csvref := CSV.GetDefaultCSV();
  233. csvref.NewLine();
  234. csvref.AddField("Parker"); csvref.AddField("Howard"); csvref.AddField("32"); csvref.AddField("River Avenue 12");
  235. w.String('Parker,Howard,32,"River Avenue 12"');
  236. csvref.NewLine();
  237. w.Ln();
  238. csvref.AddField(" Hello Peter "); csvref.AddField("Off, everything cool!");
  239. w.String('" Hello Peter ","Off, everything cool!"');
  240. TestShared.CloseWriter();
  241. csv := CSV.GetDefaultCSV();
  242. s := TestShared.GetScanner(csv);
  243. s.Scan();
  244. ASSERT(CSV.CompareCSVs(csv, csvref));
  245. END Test.
  246. positive: parse field not quoted and containing still whitespace skip after whitespace
  247. (* Text in a field after whitespace should be skipped until a separator appears *)
  248. MODULE Test;
  249. IMPORT CSV, Streams, Strings, TestShared;
  250. VAR w: Streams.Writer; csv, csvref: CSV.CSV; s: CSV.Scanner;
  251. BEGIN
  252. w := TestShared.GetWriter();
  253. csvref := CSV.GetDefaultCSV();
  254. csvref.NewLine();
  255. csvref.AddField("Parker"); csvref.AddField("Howard"); csvref.AddField("32"); csvref.AddField("River Avenue 12");
  256. w.String('Parker,Howard Martin,32,"River Avenue 12"');
  257. csvref.NewLine();
  258. w.Ln();
  259. csvref.AddField(" Hello Peter "); csvref.AddField("Off, everything cool!");
  260. w.String('" Hello Peter ","Off, everything cool!"');
  261. TestShared.CloseWriter();
  262. csv := CSV.GetDefaultCSV();
  263. s := TestShared.GetScanner(csv);
  264. s.Scan();
  265. ASSERT(CSV.CompareCSVs(csv, csvref));
  266. END Test.
  267. positive: UNLOAD the CSV module after the tests
  268. MODULE Test;
  269. IMPORT Modules;
  270. VAR res: WORD; msg: ARRAY 64 OF CHAR;
  271. BEGIN
  272. Modules.FreeModule("TestShared", res, msg);
  273. Modules.FreeModule("CSV", res, msg);
  274. END Test.