1 | using System;
|
---|
2 | using System.Collections.Generic;
|
---|
3 | using System.Text;
|
---|
4 | using NUnit.Framework;
|
---|
5 | using System.Data;
|
---|
6 | using IndianHealthService.BMXNet.Model;
|
---|
7 |
|
---|
8 |
|
---|
9 | namespace IndianHealthService.BMXNet.Tests
|
---|
10 | {
|
---|
11 |
|
---|
12 | /// <summary>
|
---|
13 | /// BMX ADO SS^BMX TEST FILE^^~~~~~
|
---|
14 | ///
|
---|
15 | /// </summary>
|
---|
16 | ///
|
---|
17 | public class FieldTypesAndFieldConstraints : BmxValidUserTestSuite
|
---|
18 | {
|
---|
19 |
|
---|
20 |
|
---|
21 | private DataRow _testRow;
|
---|
22 |
|
---|
23 | public DataRow TestRow
|
---|
24 | {
|
---|
25 | get { return _testRow; }
|
---|
26 | set { _testRow = value; }
|
---|
27 | }
|
---|
28 | private DataTable _testTable;
|
---|
29 |
|
---|
30 | public DataTable TestTable
|
---|
31 | {
|
---|
32 | get { return _testTable; }
|
---|
33 | set { _testTable = value; }
|
---|
34 | }
|
---|
35 |
|
---|
36 | public bool GenerateValidTestRow()
|
---|
37 | {
|
---|
38 | // BMXNetScriptedBroker broker = new BMXNetScriptedBroker();
|
---|
39 | // broker.AddCall(
|
---|
40 | // @"{BMX}0007700062007BMX;;;;000470BMX ADO SS^000300140BMX TEST FILE00100060~~~~~",
|
---|
41 | // @"@@@meta@@@BMXIEN|90093.97|^90093.97|.001|N|15|BMXIEN|TRUE|TRUE|FALSE^90093.97|.01|T|30|NAME|FALSE|FALSE|FALSE^90093.97|.02|N|4|NUMBER|FALSE|FALSE|TRUE^90093.97|.03|D|21|DATE|FALSE|FALSE|TRUE^90093.97|.04|D|21|DATE TIME|FALSE|FALSE|TRUE^90093.97|.05|T|3|SET|FALSE|FALSE|TRUE^90093.97|.06|T|30|NAME R/O|TRUE|FALSE|TRUE^90093.97|.07|N|4|NUMBER R/O|TRUE|FALSE|TRUE^90093.97|.08|D|21|DATE R/O|TRUE|FALSE|TRUE^90093.97|.09|D|21|DATE TIME R/O|TRUE|FALSE|TRUE^90093.97|.1|T|3|SET R/O|TRUE|FALSE|TRUE^90093.97|.11|I|2|INTEGER|FALSE|FALSE|TRUE^90093.97|.12|I|2|INTEGER R/O|TRUE|FALSE|TRUE |
---|
42 | 1^John^8^OCT 10, 1970^^^^^^^^^ |
---|
43 | ");
|
---|
44 |
|
---|
45 | //SMH: Table needs to be cleared at this point since it expects to have a clean slate
|
---|
46 | //SMH: And here it is!
|
---|
47 | DataTable table = this.RemoteSession.TableFromCommand(this.FetchTableString);
|
---|
48 |
|
---|
49 | foreach (DataRow each in table.Rows)
|
---|
50 | {
|
---|
51 | each.Delete();
|
---|
52 | }
|
---|
53 | this.RemoteSession.SaveChanges(table);
|
---|
54 | //end my changes
|
---|
55 |
|
---|
56 | table = this.RemoteSession.TableFromCommand(this.FetchTableString);
|
---|
57 | DataRow row = table.NewRow();
|
---|
58 | row["NAME"] = "John";
|
---|
59 | row["DATE"] = new DateTime(1970, 10, 10);
|
---|
60 | row["NUMBER"] = 8;
|
---|
61 | row["NUMBER R/O"] = 9;
|
---|
62 | table.Rows.Add(row);
|
---|
63 | Assert.AreEqual(1, table.Rows.Count);
|
---|
64 |
|
---|
65 | Assert.IsTrue(this.RemoteSession.SaveChanges(table));
|
---|
66 |
|
---|
67 | this.TestTable = RemoteSession.TableFromCommand(this.FetchTableString);
|
---|
68 | Assert.AreEqual(1, this.TestTable.Rows.Count);
|
---|
69 | this.TestRow = this.TestTable.Rows[0];
|
---|
70 | Assert.AreEqual(row["NAME"], "John");
|
---|
71 | Assert.AreEqual(row["DATE"], new DateTime(1970, 10, 10));
|
---|
72 |
|
---|
73 | return true;
|
---|
74 |
|
---|
75 | }
|
---|
76 |
|
---|
77 | public bool RefetchTestRow()
|
---|
78 | {
|
---|
79 | try
|
---|
80 | {
|
---|
81 | this.TestTable = this.RemoteSession.TableFromCommand(this.FetchTableString);
|
---|
82 | Assert.AreEqual(1, this.TestTable.Rows.Count);
|
---|
83 | this.TestRow = this.TestTable.Rows[0];
|
---|
84 | return true;
|
---|
85 | }
|
---|
86 | catch
|
---|
87 | {
|
---|
88 | return false;
|
---|
89 | }
|
---|
90 | }
|
---|
91 |
|
---|
92 | /*
|
---|
93 | 90093.97,.01 NAME 0;1 FREE TEXT (Required)
|
---|
94 | INPUT TRANSFORM: K:$L(X)>30!($L(X)<3)!'(X'?1P.E) X
|
---|
95 | LAST EDITED: JAN 16, 2008
|
---|
96 | HELP-PROMPT: Answer must be 3-30 characters in length.
|
---|
97 | CROSS-REFERENCE: 90093.97^B
|
---|
98 | 1)= S ^BMXTEST("B",$E(X,1,30),DA)=""
|
---|
99 | 2)= K ^BMXTEST("B",$E(X,1,30),DA)
|
---|
100 | */
|
---|
101 |
|
---|
102 |
|
---|
103 | /*
|
---|
104 | 90093.97,.06 NUMBER 0;6 NUMBER
|
---|
105 | INPUT TRANSFORM: K:+X'=X!(X>99)!(X<5)!(X?.E1"."2N.N) X
|
---|
106 | LAST EDITED: JAN 16, 2008
|
---|
107 | HELP-PROMPT: Type a Number between 5 and 99, 1 Decimal Digit*/
|
---|
108 | [Test]
|
---|
109 | [ExpectedException(typeof(BMXNetException))]
|
---|
110 | public void NumberMin()
|
---|
111 | {
|
---|
112 | this.GenerateValidTestRow();
|
---|
113 | this.TestRow["Number"] = 0;
|
---|
114 | this.RemoteSession.SaveChanges(this.TestTable);
|
---|
115 | }
|
---|
116 |
|
---|
117 | [Test]
|
---|
118 | [ExpectedException(typeof(BMXNetException))]
|
---|
119 | public void NumberMax()
|
---|
120 | {
|
---|
121 | this.GenerateValidTestRow();
|
---|
122 | this.TestRow["Number"] = 120;
|
---|
123 | this.RemoteSession.SaveChanges(this.TestTable);
|
---|
124 | }
|
---|
125 |
|
---|
126 | [Test]
|
---|
127 | [ExpectedException(typeof(BMXNetException))]
|
---|
128 | public void NumberTooManyDecimals()
|
---|
129 | {
|
---|
130 | this.GenerateValidTestRow();
|
---|
131 | this.TestRow["Number"] = 120.1234;
|
---|
132 | this.RemoteSession.SaveChanges(this.TestTable);
|
---|
133 | }
|
---|
134 |
|
---|
135 | [Test]
|
---|
136 | public void NumberDecimals()
|
---|
137 | {
|
---|
138 | this.GenerateValidTestRow();
|
---|
139 | this.TestRow["NUMBER"] = 5.6;
|
---|
140 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
141 |
|
---|
142 | this.RefetchTestRow();
|
---|
143 | Assert.AreEqual(this.TestRow["NUMBER"], 5.6);
|
---|
144 | }
|
---|
145 |
|
---|
146 | /*90093.97,.07 NUMBER R/O 0;7 NUMBER
|
---|
147 |
|
---|
148 | INPUT TRANSFORM: K:+X'=X!(X>99)!(X<5)!(X?.E1"."1N.N) X
|
---|
149 | LAST EDITED: JAN 16, 2008
|
---|
150 | HELP-PROMPT: Type a Number between 5 and 99, 0 Decimal
|
---|
151 | Digits*/
|
---|
152 |
|
---|
153 | /// <summary>
|
---|
154 | /// THIS WILL FAIL!!!! NOTHING IN THE BMX LIBRARY THROWS THIS EXCEPTION//SMH
|
---|
155 | /// </summary>
|
---|
156 | [Test]
|
---|
157 | [ExpectedException(typeof(System.Data.ReadOnlyException))]
|
---|
158 | public void UpdateReadOnlyNumber()
|
---|
159 | {
|
---|
160 | this.GenerateValidTestRow();
|
---|
161 | this.TestRow["NUMBER R/O"] = 100;
|
---|
162 | }
|
---|
163 |
|
---|
164 |
|
---|
165 | [Test]
|
---|
166 | [ExpectedException(typeof(BMXNetException))]
|
---|
167 | public void StringMinLength()
|
---|
168 | {
|
---|
169 | this.GenerateValidTestRow();
|
---|
170 | this.TestRow["NAME"] = "John";
|
---|
171 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
172 |
|
---|
173 | this.RefetchTestRow();
|
---|
174 | Assert.AreEqual(this.TestRow["NAME"], "John");
|
---|
175 | this.TestRow["NAME"] = "T";
|
---|
176 | Assert.IsFalse(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
177 | }
|
---|
178 |
|
---|
179 | [Test]
|
---|
180 | public void StringMinLengthNoSideEffect()
|
---|
181 | {
|
---|
182 | this.GenerateValidTestRow();
|
---|
183 | this.TestRow["NAME"] = "John";
|
---|
184 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
185 |
|
---|
186 | this.RefetchTestRow();
|
---|
187 | try
|
---|
188 | {
|
---|
189 | this.TestRow["NAME"] = "T";
|
---|
190 | Assert.IsFalse(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
191 | Assert.IsTrue(false);
|
---|
192 | }
|
---|
193 | catch
|
---|
194 | {
|
---|
195 | }
|
---|
196 |
|
---|
197 | this.RefetchTestRow();
|
---|
198 | Assert.AreEqual(this.TestRow["NAME"], "John");
|
---|
199 | }
|
---|
200 |
|
---|
201 | [Test]
|
---|
202 | [ExpectedException(typeof(BMXNetException))]
|
---|
203 | public void StringMaxLength()
|
---|
204 | {
|
---|
205 | this.GenerateValidTestRow();
|
---|
206 | this.TestRow["NAME"] = "John";
|
---|
207 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
208 |
|
---|
209 | this.RefetchTestRow();
|
---|
210 | Assert.AreEqual(this.TestRow["NAME"], "John");
|
---|
211 | this.TestRow["NAME"] = "T1234567890123456789012345678901234567890";
|
---|
212 | Assert.IsFalse(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
213 | }
|
---|
214 |
|
---|
215 | [Test]
|
---|
216 | public void StringMaxLengthNoSideEffect()
|
---|
217 | {
|
---|
218 | this.GenerateValidTestRow();
|
---|
219 | this.TestRow["NAME"] = "John";
|
---|
220 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
221 |
|
---|
222 | this.RefetchTestRow();
|
---|
223 | try
|
---|
224 | {
|
---|
225 | this.TestRow["NAME"] = "T1234567890123456789012345678901234567890";
|
---|
226 | Assert.IsFalse(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
227 | Assert.IsTrue(false);
|
---|
228 | }
|
---|
229 | catch
|
---|
230 | {
|
---|
231 | }
|
---|
232 |
|
---|
233 | this.RefetchTestRow();
|
---|
234 | Assert.AreEqual(this.TestRow["NAME"], "John");
|
---|
235 | }
|
---|
236 |
|
---|
237 | /*90093.97,.03 DATE 0;3 DATE
|
---|
238 |
|
---|
239 | INPUT TRANSFORM: S %DT="EX" D ^%DT S X=Y K:Y<1 X
|
---|
240 | LAST EDITED: JAN 16, 2008*/
|
---|
241 | [Test]
|
---|
242 | public void SetDateAt0Second()
|
---|
243 | {
|
---|
244 | this.GenerateValidTestRow();
|
---|
245 | this.TestRow["DATE"] = new DateTime(1950,1,1);
|
---|
246 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
247 |
|
---|
248 | this.RefetchTestRow();
|
---|
249 | Assert.AreEqual(new DateTime(1950,1,1),(DateTime)this.TestRow["DATE"]);
|
---|
250 | }
|
---|
251 |
|
---|
252 |
|
---|
253 | [Test]
|
---|
254 | [ExpectedException(typeof(BMXNetException))]
|
---|
255 | public void SetDateAtWithTime()
|
---|
256 | {
|
---|
257 | this.GenerateValidTestRow();
|
---|
258 | this.TestRow["DATE"] = new DateTime(1950, 1, 1,10,30,30);
|
---|
259 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
260 |
|
---|
261 | this.RefetchTestRow();
|
---|
262 | Assert.AreEqual(new DateTime(1950, 1, 1, 10, 30, 30), (DateTime)this.TestRow["DATE"]);
|
---|
263 | }
|
---|
264 |
|
---|
265 |
|
---|
266 | /*
|
---|
267 | 90093.97,.04 DATE TIME 0;4 DATE
|
---|
268 | INPUT TRANSFORM: S %DT="ETX" D ^%DT S X=Y K:Y<1 X
|
---|
269 | LAST EDITED: JAN 16, 2008*/
|
---|
270 | [Test]
|
---|
271 | [ExpectedException(typeof(BMXNetException))]
|
---|
272 | public void SetDateTimeAtWithTimeHavingSeconds()
|
---|
273 | {
|
---|
274 | this.GenerateValidTestRow();
|
---|
275 | this.TestRow["DATE TIME"] = new DateTime(1950, 1, 1, 20, 30,1);
|
---|
276 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
277 | }
|
---|
278 |
|
---|
279 | /*90093.97,.05 DATE R/O 0;5 DATE
|
---|
280 |
|
---|
281 | INPUT TRANSFORM: S %DT="EX" D ^%DT S X=Y K:Y<1 X*/
|
---|
282 |
|
---|
283 | [Test]
|
---|
284 | public void SetDateTimeAtWithTime()
|
---|
285 | {
|
---|
286 | this.GenerateValidTestRow();
|
---|
287 | this.TestRow["DATE TIME"] = new DateTime(1950, 1, 1, 20, 30, 0);
|
---|
288 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
289 |
|
---|
290 | this.RefetchTestRow();
|
---|
291 | Assert.AreEqual(new DateTime(1950, 1, 1, 20, 30, 0), (DateTime)this.TestRow["DATE TIME"]);
|
---|
292 | }
|
---|
293 |
|
---|
294 |
|
---|
295 | /// <summary>
|
---|
296 | /// THIS WILL FAIL!!!! NOTHING IN THE BMX LIBRARY THROWS THIS EXCEPTION//SMH
|
---|
297 | /// </summary>
|
---|
298 | [Test]
|
---|
299 | [ExpectedException(typeof(System.Data.ReadOnlyException))]
|
---|
300 | public void UpdateReadOnlyDate()
|
---|
301 | {
|
---|
302 |
|
---|
303 |
|
---|
304 | this.GenerateValidTestRow();
|
---|
305 | this.TestRow["DATE R/O"] = new DateTime(1950, 1, 1);
|
---|
306 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
307 |
|
---|
308 | this.RefetchTestRow();
|
---|
309 | String peek = this.TestRow["DATE R/O"].ToString();
|
---|
310 | Assert.AreEqual(new DateTime(1950, 1, 1), (DateTime)this.TestRow["DATE R/O"]);
|
---|
311 | }
|
---|
312 |
|
---|
313 | /* * 93.97,.08 SET 0;8 SET
|
---|
314 |
|
---|
315 | '1' FOR YES;
|
---|
316 | '0' FOR NO;
|
---|
317 | LAST EDITED: JAN 16, 2008*/
|
---|
318 |
|
---|
319 | [Test]
|
---|
320 | public void SetSetToCode()
|
---|
321 | {
|
---|
322 | this.GenerateValidTestRow();
|
---|
323 | this.TestRow["SET"] = "YES";
|
---|
324 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
325 |
|
---|
326 | this.RefetchTestRow();
|
---|
327 |
|
---|
328 | Assert.AreEqual("YES", this.TestRow["SET"]);
|
---|
329 | }
|
---|
330 | [Test]
|
---|
331 | public void SetSetToNull()
|
---|
332 | {
|
---|
333 | this.GenerateValidTestRow();
|
---|
334 | this.TestRow["SET"] = "";
|
---|
335 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
336 |
|
---|
337 | this.RefetchTestRow();
|
---|
338 |
|
---|
339 | Assert.AreEqual("", this.TestRow["SET"]);
|
---|
340 | }
|
---|
341 |
|
---|
342 | [Test]
|
---|
343 | [ExpectedException(typeof(BMXNetException))]
|
---|
344 | public void SetSetToInvalid()
|
---|
345 | {
|
---|
346 | this.GenerateValidTestRow();
|
---|
347 | this.TestRow["SET"] = "MAYBE";
|
---|
348 | Assert.IsTrue(this.RemoteSession.SaveChanges(this.TestTable));
|
---|
349 |
|
---|
350 | this.RefetchTestRow();
|
---|
351 |
|
---|
352 | Assert.AreEqual("MAYBE", this.TestRow["SET"]);
|
---|
353 | }
|
---|
354 |
|
---|
355 |
|
---|
356 | /*
|
---|
357 |
|
---|
358 |
|
---|
359 |
|
---|
360 |
|
---|
361 | /*
|
---|
362 |
|
---|
363 |
|
---|
364 | 90093.97,.09 SET R/O 0;9 SET
|
---|
365 |
|
---|
366 | '1' FOR YES;
|
---|
367 | '0' FOR NO;
|
---|
368 | LAST EDITED: JAN 16, 2008
|
---|
369 |
|
---|
370 | 90093.97,.1 LOCATION 0;10 POINTER TO LOCATION FILE (#9999999.06
|
---|
371 | )
|
---|
372 | */
|
---|
373 |
|
---|
374 |
|
---|
375 |
|
---|
376 | }
|
---|
377 | }
|
---|