2 // DBDataPermissionTest.cs - NUnit Test Cases for DBDataPermission
5 // Sebastien Pouliot <sebastien@ximian.com>
7 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
9 // Permission is hereby granted, free of charge, to any person obtaining
10 // a copy of this software and associated documentation files (the
11 // "Software"), to deal in the Software without restriction, including
12 // without limitation the rights to use, copy, modify, merge, publish,
13 // distribute, sublicense, and/or sell copies of the Software, and to
14 // permit persons to whom the Software is furnished to do so, subject to
15 // the following conditions:
17 // The above copyright notice and this permission notice shall be
18 // included in all copies or substantial portions of the Software.
20 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
21 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
22 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
23 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
24 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
25 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
26 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
29 using NUnit.Framework;
32 using System.Data.Common;
33 using System.Security;
34 using System.Security.Permissions;
36 namespace MonoTests.System.Data.Common {
38 public class NonAbstractDBDataPermission : DBDataPermission {
41 public NonAbstractDBDataPermission ()
46 public NonAbstractDBDataPermission (DBDataPermission permission, bool allowBlankPassword)
49 AllowBlankPassword = allowBlankPassword;
52 // make Copy and CreateInstance work :)
53 public NonAbstractDBDataPermission ()
54 : base (PermissionState.None)
58 public NonAbstractDBDataPermission (PermissionState state)
63 public NonAbstractDBDataPermission (DBDataPermission permission)
68 public NonAbstractDBDataPermission (DBDataPermissionAttribute permissionAttribute)
69 : base (permissionAttribute)
73 public NonAbstractDBDataPermission (DbConnectionOptions connectionOptions)
74 : base (connectionOptions)
79 public new void Clear ()
84 public new DBDataPermission CreateInstance ()
86 return base.CreateInstance ();
91 public class DBDataPermissionTest {
93 private const string defaultConnectString = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;";
94 private const string defaultConnectString2 = "Data Source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=Northwind;";
96 private void Check (string msg, NonAbstractDBDataPermission dbdp, bool blank, bool unrestricted, int count)
98 Assert.AreEqual (blank, dbdp.AllowBlankPassword, msg + ".AllowBlankPassword");
99 Assert.AreEqual (unrestricted, dbdp.IsUnrestricted (), msg + ".IsUnrestricted");
101 Assert.IsNull (dbdp.ToXml ().Children, msg + ".Count != 0");
103 Assert.AreEqual (count, dbdp.ToXml ().Children.Count, msg + ".Count");
108 public void Constructor_Empty ()
110 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission ();
111 Check ("Empty", dbdp, false, false, 0);
115 [ExpectedException (typeof (ArgumentOutOfRangeException))]
116 public void Constructor_PermissionStateBoolean_Invalid ()
118 PermissionState ps = (PermissionState) Int32.MinValue;
119 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (ps, false);
123 public void Constructor_PermissionStateBoolean_None ()
125 PermissionState ps = PermissionState.None;
126 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (ps, false);
127 Check ("None,False", dbdp, false, false, 0);
129 dbdp = new NonAbstractDBDataPermission (ps, true);
130 Check ("None,True", dbdp, true, false, 0);
134 public void Constructor_PermissionStateBoolean_Unrestricted ()
136 PermissionState ps = PermissionState.Unrestricted;
137 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (ps, false);
138 Check ("Unrestricted,False", dbdp, false, true, 0);
140 dbdp = new NonAbstractDBDataPermission (ps, true);
141 Check ("Unrestricted,True", dbdp, true, true, 0);
145 [ExpectedException (typeof (ArgumentNullException))]
146 public void Constructor_DBDataPermission_Null ()
148 DBDataPermission p = null;
149 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (p);
153 public void Constructor_DBDataPermission ()
155 DBDataPermission p = new NonAbstractDBDataPermission (PermissionState.None);
156 p.AllowBlankPassword = true;
157 p.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
159 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (p);
160 Check ("DBDataPermission", dbdp, true, false, 1);
164 [ExpectedException (typeof (ArgumentNullException))]
165 public void Constructor_DBDataPermissionAttribute_Null ()
167 DBDataPermissionAttribute a = null;
168 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (a);
172 public void Constructor_DBDataPermissionAttribute ()
174 DBDataPermissionAttribute a = new NonAbstractDBDataPermissionAttribute (SecurityAction.Assert);
175 a.AllowBlankPassword = true;
177 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (a);
178 Check ("DBDataPermissionAttribute-0", dbdp, true, false, 0);
180 a.Unrestricted = true;
181 dbdp = new NonAbstractDBDataPermission (a);
182 Check ("DBDataPermissionAttribute-1", dbdp, false, true, 0);
183 // Unrestricted "bypass" the AllowBlankPassword (so it report false)
185 a.ConnectionString = defaultConnectString;
186 dbdp = new NonAbstractDBDataPermission (a);
187 Check ("DBDataPermissionAttribute-2", dbdp, false, true, 0);
188 // Unrestricted "bypass" the ConnectionString (so it report 0 childs)
190 a.Unrestricted = false;
191 dbdp = new NonAbstractDBDataPermission (a);
192 Check ("DBDataPermissionAttribute-3", dbdp, true, false, 1);
196 // [ExpectedException (typeof (ArgumentNullException))]
197 public void Constructor_DbConnectionOptions_Null ()
199 DbConnectionOptions o = null;
200 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (o);
201 Check ("DbConnectionOptions_Null", dbdp, false, false, 0);
205 public void Constructor_DbConnectionOptions ()
207 DbConnectionOptions o = new DbConnectionOptions (defaultConnectString);
208 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (o);
209 Check ("DbConnectionOptions", dbdp, false, false, 1);
214 [ExpectedException (typeof (ArgumentOutOfRangeException))]
216 [ExpectedException (typeof (ArgumentException))]
218 public void Constructor_PermissionState_Invalid ()
220 PermissionState ps = (PermissionState) Int32.MinValue;
221 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (ps);
225 public void Constructor_PermissionState_None ()
227 PermissionState ps = PermissionState.None;
228 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (ps);
229 Check ("PermissionState_None-1", dbdp, false, false, 0);
230 dbdp.AllowBlankPassword = true;
231 Check ("PermissionState_None-1", dbdp, true, false, 0);
235 public void Constructor_PermissionState_Unrestricted ()
237 PermissionState ps = PermissionState.Unrestricted;
238 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (ps);
239 Check ("PermissionState_Unrestricted-1", dbdp, false, true, 0);
240 dbdp.AllowBlankPassword = true;
241 Check ("PermissionState_Unrestricted-2", dbdp, true, true, 0);
245 public void AllowBlankPassword ()
247 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.None);
248 Assert.IsFalse (dbdp.AllowBlankPassword, "Default");
249 dbdp.AllowBlankPassword = true;
250 Assert.IsTrue (dbdp.AllowBlankPassword, "True");
252 // clear the connection list - not the permission itself
253 Assert.IsTrue (dbdp.AllowBlankPassword, "Clear");
254 dbdp.AllowBlankPassword = false;
255 Assert.IsFalse (dbdp.AllowBlankPassword, "False");
261 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.None);
262 dbdp.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
263 Assert.AreEqual (1, dbdp.ToXml ().Children.Count, "Count");
265 NonAbstractDBDataPermission copy = (NonAbstractDBDataPermission)dbdp.Copy ();
266 Assert.AreEqual (1, copy.ToXml ().Children.Count, "Copy.Count");
269 Assert.IsNull (dbdp.ToXml ().Children, "Clear");
270 Assert.AreEqual (1, copy.ToXml ().Children.Count, "Copy.Count-2");
274 public void Add_Duplicates ()
276 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.None);
277 dbdp.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
278 dbdp.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
279 // no exception but a single element is kept
280 Assert.AreEqual (1, dbdp.ToXml ().Children.Count, "Count");
281 dbdp.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.PreventUsage);
284 Assert.IsNull (dbdp.ToXml ().Children, "Clear");
288 public void Add_Differents ()
290 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.None);
291 dbdp.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
292 string connectString = "Data Source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=Northwind;";
293 dbdp.Add (connectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
294 Assert.AreEqual (2, dbdp.ToXml ().Children.Count, "Count");
297 Assert.IsNull (dbdp.ToXml ().Children, "Clear");
301 public void Add_Unrestricted ()
303 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
304 Assert.IsTrue (dbdp.IsUnrestricted (), "IsUnrestricted-1");
305 // we lose unrestricted by adding an element
306 dbdp.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
307 Assert.IsFalse (dbdp.IsUnrestricted (), "IsUnrestricted-2");
308 // removing the element doesn't regain unrestricted status
310 Assert.IsFalse (dbdp.IsUnrestricted (), "IsUnrestricted-3");
314 public void CreateInstance ()
316 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
317 Assert.AreEqual (typeof (NonAbstractDBDataPermission), dbdp.CreateInstance ().GetType (), "Same type");
322 public void Intersect_Null ()
324 NonAbstractDBDataPermission elp = new NonAbstractDBDataPermission (PermissionState.None);
325 // No intersection with null
326 Assert.IsNull (elp.Intersect (null), "None N null");
330 public void Intersect ()
332 NonAbstractDBDataPermission dbdp1 = new NonAbstractDBDataPermission (PermissionState.None);
333 NonAbstractDBDataPermission dbdp2 = new NonAbstractDBDataPermission (PermissionState.None);
336 NonAbstractDBDataPermission result = (NonAbstractDBDataPermission) dbdp1.Intersect (dbdp2);
337 Assert.IsNull (result, "Empty N Empty");
340 dbdp2.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
341 result = (NonAbstractDBDataPermission)dbdp1.Intersect (dbdp2);
342 Assert.IsNull (result, "Empty N Entry");
345 result = (NonAbstractDBDataPermission)dbdp2.Intersect (dbdp1);
346 Assert.IsNull (result, "Entry N Empty");
348 // 4. Unrestricted N None
349 NonAbstractDBDataPermission unr = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
350 result = (NonAbstractDBDataPermission)unr.Intersect (dbdp1);
351 Check ("(Unrestricted N None)", result, false, false, 0);
353 // 5. None N Unrestricted
354 result = (NonAbstractDBDataPermission)dbdp1.Intersect (unr);
355 Check ("(None N Unrestricted)", result, false, false, 0);
357 // 6. Unrestricted N Unrestricted
358 result = (NonAbstractDBDataPermission)unr.Intersect (unr);
359 Check ("(Unrestricted N Unrestricted)", result, false, true, 0);
361 // 7. Unrestricted N Entry
362 result = (NonAbstractDBDataPermission)unr.Intersect (dbdp2);
363 Check ("(Unrestricted N Entry)", result, false, false, 1);
365 // 8. Entry N Unrestricted
366 result = (NonAbstractDBDataPermission)dbdp2.Intersect (unr);
367 Check ("(Entry N Unrestricted)", result, false, false, 1);
369 // 9. Entry2 N Entry2
370 result = (NonAbstractDBDataPermission)dbdp2.Intersect (dbdp2);
371 Check ("(Entry2 N Entry2)", result, false, false, 1);
373 // 10. Entry1 N Entry 2
374 dbdp1.Add (defaultConnectString2, String.Empty, KeyRestrictionBehavior.PreventUsage);
375 result = (NonAbstractDBDataPermission)dbdp1.Intersect (dbdp2);
376 Assert.IsNull (result, "(Entry1 N Entry2)");
378 // 11. Entry2 N Entry 1
379 result = (NonAbstractDBDataPermission)dbdp2.Intersect (dbdp1);
380 Assert.IsNull (result, "(Entry2 N Entry1)");
384 public void Intersect_AllowBlankPassword ()
386 NonAbstractDBDataPermission ptrue = new NonAbstractDBDataPermission (PermissionState.None);
387 ptrue.AllowBlankPassword = true;
388 ptrue.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
389 NonAbstractDBDataPermission pfalse = new NonAbstractDBDataPermission (PermissionState.None);
390 pfalse.AllowBlankPassword = false;
391 pfalse.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
393 NonAbstractDBDataPermission intersect = (NonAbstractDBDataPermission)ptrue.Intersect (ptrue);
394 Check ("true N true", intersect, true, false, 1);
395 intersect = (NonAbstractDBDataPermission)ptrue.Intersect (pfalse);
396 Check ("true N false", intersect, false, false, 1);
397 intersect = (NonAbstractDBDataPermission)pfalse.Intersect (ptrue);
398 Check ("false N true", intersect, false, false, 1);
399 intersect = (NonAbstractDBDataPermission)pfalse.Intersect (pfalse);
400 Check ("false N false", intersect, false, false, 1);
404 [ExpectedException (typeof (ArgumentException))]
405 public void Intersect_BadPermission ()
407 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
408 dbdp.Intersect (new SecurityPermission (SecurityPermissionFlag.Assertion));
412 public void IsSubset_Null ()
414 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.None);
415 Assert.IsTrue (dbdp.IsSubsetOf (null), "Empty-null");
417 dbdp.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
418 Assert.IsFalse (dbdp.IsSubsetOf (null), "Element-null");
420 dbdp = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
421 Assert.IsFalse (dbdp.IsSubsetOf (null), "Unrestricted-null");
425 public void IsSubset ()
427 NonAbstractDBDataPermission empty = new NonAbstractDBDataPermission (PermissionState.None);
428 Assert.IsTrue (empty.IsSubsetOf (empty), "Empty-Empty");
430 NonAbstractDBDataPermission dbdp1 = new NonAbstractDBDataPermission (PermissionState.None);
431 dbdp1.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
432 Assert.IsTrue (empty.IsSubsetOf (dbdp1), "Empty-1");
433 Assert.IsFalse (dbdp1.IsSubsetOf (empty), "1-Empty");
434 Assert.IsTrue (dbdp1.IsSubsetOf (dbdp1), "1-1");
436 NonAbstractDBDataPermission dbdp2 = (NonAbstractDBDataPermission)dbdp1.Copy ();
437 dbdp2.Add (defaultConnectString2, String.Empty, KeyRestrictionBehavior.AllowOnly);
438 Assert.IsTrue (dbdp1.IsSubsetOf (dbdp2), "1-2");
439 Assert.IsFalse (dbdp2.IsSubsetOf (dbdp1), "2-1");
440 Assert.IsTrue (dbdp2.IsSubsetOf (dbdp2), "2-2");
442 NonAbstractDBDataPermission dbdp3 = new NonAbstractDBDataPermission (PermissionState.None);
443 dbdp3.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.PreventUsage);
444 Assert.IsTrue (dbdp3.IsSubsetOf (dbdp1), "3-1");
445 Assert.IsTrue (dbdp1.IsSubsetOf (dbdp3), "1-3");
446 Assert.IsTrue (dbdp3.IsSubsetOf (dbdp3), "3-3");
448 NonAbstractDBDataPermission unr = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
449 Assert.IsTrue (dbdp1.IsSubsetOf (unr), "1-unrestricted");
450 Assert.IsFalse (unr.IsSubsetOf (dbdp1), "unrestricted-1");
451 Assert.IsTrue (dbdp2.IsSubsetOf (unr), "2-unrestricted");
452 Assert.IsFalse (unr.IsSubsetOf (dbdp2), "unrestricted-2");
453 Assert.IsTrue (dbdp3.IsSubsetOf (unr), "3-unrestricted");
454 Assert.IsFalse (unr.IsSubsetOf (dbdp3), "unrestricted-3");
455 Assert.IsTrue (unr.IsSubsetOf (unr), "unrestricted-unrestricted");
459 public void IsSubsetOf_AllowBlankPassword ()
461 NonAbstractDBDataPermission ptrue = new NonAbstractDBDataPermission (PermissionState.None);
462 ptrue.AllowBlankPassword = true;
463 ptrue.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
464 NonAbstractDBDataPermission pfalse = new NonAbstractDBDataPermission (PermissionState.None);
465 pfalse.AllowBlankPassword = false;
466 pfalse.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
468 Assert.IsTrue (ptrue.IsSubsetOf (ptrue), "true subsetof true");
469 Assert.IsFalse (ptrue.IsSubsetOf (pfalse), "true subsetof false");
470 Assert.IsTrue (pfalse.IsSubsetOf (ptrue), "false subsetof true");
471 Assert.IsTrue (pfalse.IsSubsetOf (pfalse), "false subsetof false");
475 public void IsSubsetOf_BothEmpty_KeyRestrictionBehavior ()
477 NonAbstractDBDataPermission pAllow = new NonAbstractDBDataPermission (PermissionState.None);
478 pAllow.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
479 NonAbstractDBDataPermission pPrevent = new NonAbstractDBDataPermission (PermissionState.None);
480 pPrevent.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.PreventUsage);
482 Assert.IsTrue (pAllow.IsSubsetOf (pAllow), "BothEmpty - pAllow subsetof pAllow");
483 Assert.IsTrue (pAllow.IsSubsetOf (pPrevent), "BothEmpty - pAllow subsetof pPrevent");
484 Assert.IsTrue (pPrevent.IsSubsetOf (pAllow), "BothEmpty - pPrevent subsetof pAllow");
485 Assert.IsTrue (pPrevent.IsSubsetOf (pPrevent), "BothEmpty - pPrevent subsetof pPrevent");
489 public void IsSubsetOf_EmptyAllow_Prevent_KeyRestrictionBehavior ()
491 NonAbstractDBDataPermission pAllow = new NonAbstractDBDataPermission (PermissionState.None);
492 pAllow.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
493 NonAbstractDBDataPermission pPrevent = new NonAbstractDBDataPermission (PermissionState.None);
494 pPrevent.Add (defaultConnectString, "password=;", KeyRestrictionBehavior.PreventUsage);
496 Assert.IsTrue (pAllow.IsSubsetOf (pAllow), "EmptyAllow_Prevent - pAllow subsetof pAllow");
497 Assert.IsTrue (pAllow.IsSubsetOf (pPrevent), "EmptyAllow_Prevent - pAllow subsetof pPrevent");
498 Assert.IsTrue (pPrevent.IsSubsetOf (pAllow), "EmptyAllow_Prevent - pPrevent subsetof pAllow");
499 Assert.IsTrue (pPrevent.IsSubsetOf (pPrevent), "EmptyAllow_Prevent - pPrevent subsetof pPrevent");
503 public void IsSubsetOf_Allow_EmptyPrevent_KeyRestrictionBehavior ()
505 NonAbstractDBDataPermission pAllow = new NonAbstractDBDataPermission (PermissionState.None);
506 pAllow.Add (defaultConnectString, "data source=;", KeyRestrictionBehavior.AllowOnly);
507 NonAbstractDBDataPermission pPrevent = new NonAbstractDBDataPermission (PermissionState.None);
508 pPrevent.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.PreventUsage);
510 Assert.IsTrue (pAllow.IsSubsetOf (pAllow), "Allow_EmptyPrevent - pAllow subsetof pAllow");
511 Assert.IsTrue (pAllow.IsSubsetOf (pPrevent), "Allow_EmptyPrevent - pAllow subsetof pPrevent");
512 Assert.IsTrue (pPrevent.IsSubsetOf (pAllow), "Allow_EmptyPrevent - pPrevent subsetof pAllow");
513 Assert.IsTrue (pPrevent.IsSubsetOf (pPrevent), "Allow_EmptyPrevent - pPrevent subsetof pPrevent");
517 public void IsSubsetOf_AllowPreventSame_KeyRestrictionBehavior ()
519 NonAbstractDBDataPermission pAllow = new NonAbstractDBDataPermission (PermissionState.None);
520 pAllow.Add (defaultConnectString, "password=;", KeyRestrictionBehavior.AllowOnly);
521 NonAbstractDBDataPermission pPrevent = new NonAbstractDBDataPermission (PermissionState.None);
522 pPrevent.Add (defaultConnectString, "password=;", KeyRestrictionBehavior.PreventUsage);
524 Assert.IsTrue (pAllow.IsSubsetOf (pAllow), "AllowPreventSame - pAllow subsetof pAllow");
525 Assert.IsTrue (pAllow.IsSubsetOf (pPrevent), "AllowPreventSame - pAllow subsetof pPrevent");
526 Assert.IsTrue (pPrevent.IsSubsetOf (pAllow), "AllowPreventSame - pPrevent subsetof pAllow");
527 Assert.IsTrue (pPrevent.IsSubsetOf (pPrevent), "AllowPreventSame - pPrevent subsetof pPrevent");
531 public void IsSubsetOf_AllowPreventDifferent_KeyRestrictionBehavior ()
533 NonAbstractDBDataPermission pAllow1 = new NonAbstractDBDataPermission (PermissionState.None);
534 pAllow1.Add (defaultConnectString, "security=;", KeyRestrictionBehavior.AllowOnly);
535 NonAbstractDBDataPermission pAllow2 = new NonAbstractDBDataPermission (PermissionState.None);
536 pAllow2.Add (defaultConnectString, "password=;", KeyRestrictionBehavior.AllowOnly);
537 NonAbstractDBDataPermission pPrevent1 = new NonAbstractDBDataPermission (PermissionState.None);
538 pPrevent1.Add (defaultConnectString, "security=;", KeyRestrictionBehavior.PreventUsage);
539 NonAbstractDBDataPermission pPrevent2 = new NonAbstractDBDataPermission (PermissionState.None);
540 pPrevent2.Add (defaultConnectString, "password=;", KeyRestrictionBehavior.PreventUsage);
542 Assert.IsTrue (pAllow1.IsSubsetOf (pAllow1), "AllowPreventDifferent - pAllow subsetof pAllow");
543 Assert.IsTrue (pAllow1.IsSubsetOf (pPrevent2), "AllowPreventDifferent - pAllow subsetof pPrevent");
544 Assert.IsTrue (pPrevent1.IsSubsetOf (pAllow2), "AllowPreventDifferent - pPrevent subsetof pAllow");
545 Assert.IsTrue (pPrevent1.IsSubsetOf (pPrevent2), "AllowPreventDifferent - pPrevent subsetof pPrevent");
549 [ExpectedException (typeof (ArgumentException))]
550 public void IsSubsetOf_BadPermission ()
552 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
553 dbdp.IsSubsetOf (new SecurityPermission (SecurityPermissionFlag.Assertion));
557 public void Union_Null ()
559 NonAbstractDBDataPermission dbdp = new NonAbstractDBDataPermission (PermissionState.None);
560 NonAbstractDBDataPermission union = (NonAbstractDBDataPermission) dbdp.Union (null);
561 Check ("Empty U null", dbdp, false, false, 0);
563 dbdp.AllowBlankPassword = true;
564 dbdp.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
565 union = (NonAbstractDBDataPermission) dbdp.Union (null);
566 Check ("Element U null", dbdp, true, false, 1);
568 dbdp = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
569 union = (NonAbstractDBDataPermission) dbdp.Union (null);
570 Check ("Unrestricted U null", dbdp, false, true, 0);
576 NonAbstractDBDataPermission empty = new NonAbstractDBDataPermission (PermissionState.None);
577 NonAbstractDBDataPermission union = (NonAbstractDBDataPermission) empty.Union (empty);
578 Assert.IsNotNull (union, "Empty U Empty");
580 NonAbstractDBDataPermission dbdp1 = new NonAbstractDBDataPermission (PermissionState.None);
581 dbdp1.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
582 union = (NonAbstractDBDataPermission) empty.Union (dbdp1);
583 Check ("Empty U 1", union, false, false, 1);
585 NonAbstractDBDataPermission dbdp2 = (NonAbstractDBDataPermission)dbdp1.Copy ();
586 dbdp2.Add (defaultConnectString2, String.Empty, KeyRestrictionBehavior.AllowOnly);
587 union = (NonAbstractDBDataPermission) dbdp1.Union (dbdp2);
588 Check ("1 U 2", union, false, false, 2);
590 NonAbstractDBDataPermission dbdp3 = new NonAbstractDBDataPermission (PermissionState.None);
591 dbdp3.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.PreventUsage);
592 union = (NonAbstractDBDataPermission) dbdp2.Union (dbdp3);
593 Check ("2 U 3", union, false, false, 2);
595 NonAbstractDBDataPermission dbdp4 = new NonAbstractDBDataPermission (PermissionState.None);
596 dbdp4.Add (defaultConnectString, "Data Source=;", KeyRestrictionBehavior.PreventUsage);
597 union = (NonAbstractDBDataPermission) dbdp3.Union (dbdp4);
598 Check ("3 U 4", union, false, false, 1);
600 NonAbstractDBDataPermission unr = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
601 union = (NonAbstractDBDataPermission) unr.Union (empty);
602 Check ("unrestricted U empty", union, false, true, 0);
604 union = (NonAbstractDBDataPermission)unr.Union (dbdp4);
605 Check ("unrestricted U 4", union, false, true, 0);
609 public void Union_AllowBlankPassword ()
611 NonAbstractDBDataPermission ptrue = new NonAbstractDBDataPermission (PermissionState.None);
612 ptrue.AllowBlankPassword = true;
613 ptrue.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
614 NonAbstractDBDataPermission pfalse = new NonAbstractDBDataPermission (PermissionState.None);
615 pfalse.AllowBlankPassword = false;
616 pfalse.Add (defaultConnectString, String.Empty, KeyRestrictionBehavior.AllowOnly);
618 NonAbstractDBDataPermission union = (NonAbstractDBDataPermission) ptrue.Union (ptrue);
619 Check ("true U true", union, true, false, 1);
620 union = (NonAbstractDBDataPermission)ptrue.Union (pfalse);
621 Check ("true U false", union, true, false, 1);
622 union = (NonAbstractDBDataPermission)pfalse.Union (ptrue);
623 Check ("false U true", union, true, false, 1);
624 union = (NonAbstractDBDataPermission)pfalse.Union (pfalse);
625 Check ("false U false", union, false, false, 1);
629 [ExpectedException (typeof (ArgumentException))]
630 public void Union_BadPermission ()
632 NonAbstractDBDataPermission dbdp1 = new NonAbstractDBDataPermission (PermissionState.Unrestricted);
633 dbdp1.Union (new SecurityPermission (SecurityPermissionFlag.Assertion));
637 [ExpectedException (typeof (ArgumentNullException))]
638 public void FromXml_Null ()
640 NonAbstractDBDataPermission elp = new NonAbstractDBDataPermission (PermissionState.None);
645 [ExpectedException (typeof (ArgumentException))]
646 public void FromXml_WrongTag ()
648 NonAbstractDBDataPermission elp = new NonAbstractDBDataPermission (PermissionState.None);
649 SecurityElement se = elp.ToXml ();
655 [ExpectedException (typeof (ArgumentException))]
656 public void FromXml_WrongTagCase ()
658 NonAbstractDBDataPermission elp = new NonAbstractDBDataPermission (PermissionState.None);
659 SecurityElement se = elp.ToXml ();
660 se.Tag = "IPERMISSION"; // instead of IPermission
665 public void FromXml_WrongClass ()
667 NonAbstractDBDataPermission elp = new NonAbstractDBDataPermission (PermissionState.None);
668 SecurityElement se = elp.ToXml ();
670 SecurityElement w = new SecurityElement (se.Tag);
671 w.AddAttribute ("class", "Wrong" + se.Attribute ("class"));
672 w.AddAttribute ("version", se.Attribute ("version"));
674 // doesn't care of the class name at that stage
675 // anyway the class has already be created so...
679 public void FromXml_NoClass ()
681 NonAbstractDBDataPermission elp = new NonAbstractDBDataPermission (PermissionState.None);
682 SecurityElement se = elp.ToXml ();
684 SecurityElement w = new SecurityElement (se.Tag);
685 w.AddAttribute ("version", se.Attribute ("version"));
687 // doesn't even care of the class attribute presence
691 [ExpectedException (typeof (ArgumentException))]
692 public void FromXml_WrongVersion ()
694 NonAbstractDBDataPermission elp = new NonAbstractDBDataPermission (PermissionState.None);
695 SecurityElement se = elp.ToXml ();
696 se.Attributes.Remove ("version");
697 se.Attributes.Add ("version", "2");
702 public void FromXml_NoVersion ()
704 NonAbstractDBDataPermission elp = new NonAbstractDBDataPermission (PermissionState.None);
705 SecurityElement se = elp.ToXml ();
707 SecurityElement w = new SecurityElement (se.Tag);
708 w.AddAttribute ("class", se.Attribute ("class"));