mcs/class/System.Data/Test/System.Data/ForeignKeyConstraintTest.cs

   1 // ForeignKeyConstraintTest.cs - NUnit Test Cases for [explain here]
   2 //
   3 // Authors:
   4 //   Franklin Wise (gracenote@earthlink.net)
   5 //   Martin Willemoes Hansen (mwh@sysrq.dk)
   6 //
   7 // (C) Franklin Wise
   8 // (C) 2003 Martin Willemoes Hansen
   9 //
  10
  11 //
  12 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
  13 //
  14 // Permission is hereby granted, free of charge, to any person obtaining
  15 // a copy of this software and associated documentation files (the
  16 // "Software"), to deal in the Software without restriction, including
  17 // without limitation the rights to use, copy, modify, merge, publish,
  18 // distribute, sublicense, and/or sell copies of the Software, and to
  19 // permit persons to whom the Software is furnished to do so, subject to
  20 // the following conditions:
  21 //
  22 // The above copyright notice and this permission notice shall be
  23 // included in all copies or substantial portions of the Software.
  24 //
  25 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  26 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  27 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  28 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  29 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  30 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  31 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  32 //
  33
  34 using NUnit.Framework;
  35 using System;
  36 using System.Data;
  37
  38 namespace MonoTests.System.Data
  39 {
  40         [TestFixture]
  41         public class ForeignKeyConstraintTest : Assertion
  42         {
  43                 private DataSet _ds;
  44
  45                 //NOTE: fk constraints only work when the table is part of a DataSet
  46
  47                 [SetUp]
  48                 public void GetReady()
  49                 {
  50                         _ds = new DataSet();
  51
  52                         //Setup DataTable
  53                         DataTable table;
  54                         table = new DataTable("TestTable");
  55                         table.Columns.Add("Col1",typeof(int));
  56                         table.Columns.Add("Col2",typeof(int));
  57                         table.Columns.Add("Col3",typeof(int));
  58
  59                         _ds.Tables.Add(table);
  60
  61                         table = new DataTable("TestTable2");
  62                         table.Columns.Add("Col1",typeof(int));
  63                         table.Columns.Add("Col2",typeof(int));
  64                         table.Columns.Add("Col3",typeof(int));
  65
  66                         _ds.Tables.Add(table);
  67
  68                 }
  69
  70                 // Tests ctor (string, DataColumn, DataColumn)
  71                 [Test]
  72                 public void Ctor1 ()
  73                 {
  74                         DataTable Table =  _ds.Tables [0];
  75
  76                         AssertEquals ("test#01", 0, Table.Constraints.Count);
  77                         Table =  _ds.Tables [1];
  78                         AssertEquals ("test#02", 0, Table.Constraints.Count);
  79
  80                         // ctor (string, DataColumn, DataColumn
  81                         ForeignKeyConstraint Constraint = new ForeignKeyConstraint ("test", _ds.Tables [0].Columns [2], _ds.Tables [1].Columns [0]);
  82                         Table = _ds.Tables [1];
  83                         Table.Constraints.Add (Constraint);
  84
  85                         AssertEquals ("test#03", 1, Table.Constraints.Count);
  86                         AssertEquals ("test#04", "test", Table.Constraints [0].ConstraintName);
  87                         AssertEquals ("test#05", typeof (ForeignKeyConstraint), Table.Constraints [0].GetType ());
  88
  89                         Table = _ds.Tables [0];
  90                         AssertEquals ("test#06", 1, Table.Constraints.Count);
  91                         AssertEquals ("test#07", "Constraint1", Table.Constraints [0].ConstraintName);
  92                         AssertEquals ("test#08", typeof (UniqueConstraint), Table.Constraints [0].GetType ());
  93                 }
  94
  95                 // Tests ctor (DataColumn, DataColumn)
  96                 [Test]
  97                 public void Ctor2 ()
  98                 {
  99                         DataTable Table =  _ds.Tables [0];
 100
 101                         AssertEquals ("test#01", 0, Table.Constraints.Count);
 102                         Table =  _ds.Tables [1];
 103                         AssertEquals ("test#02", 0, Table.Constraints.Count);
 104
 105                         // ctor (string, DataColumn, DataColumn
 106                         ForeignKeyConstraint Constraint = new ForeignKeyConstraint (_ds.Tables [0].Columns [2], _ds.Tables [1].Columns [0]);
 107                         Table = _ds.Tables [1];
 108                         Table.Constraints.Add (Constraint);
 109
 110                         AssertEquals ("test#03", 1, Table.Constraints.Count);
 111                         AssertEquals ("test#04", "Constraint1", Table.Constraints [0].ConstraintName);
 112                         AssertEquals ("test#05", typeof (ForeignKeyConstraint), Table.Constraints [0].GetType ());
 113
 114                         Table = _ds.Tables [0];
 115                         AssertEquals ("test#06", 1, Table.Constraints.Count);
 116                         AssertEquals ("test#07", "Constraint1", Table.Constraints [0].ConstraintName);
 117                         AssertEquals ("test#08", typeof (UniqueConstraint), Table.Constraints [0].GetType ());
 118                 }
 119
 120                 // Test ctor (DataColumn [], DataColumn [])
 121                 [Test]
 122                 public void Ctor3 ()
 123                 {
 124                         DataTable Table =  _ds.Tables [0];
 125
 126                         AssertEquals ("test#01", 0, Table.Constraints.Count);
 127                         Table =  _ds.Tables [1];
 128                         AssertEquals ("test#02", 0, Table.Constraints.Count);
 129
 130                         DataColumn [] Cols1 = new DataColumn [2];
 131                         Cols1 [0] = _ds.Tables [0].Columns [1];
 132                         Cols1 [1] = _ds.Tables [0].Columns [2];
 133
 134                         DataColumn [] Cols2 = new DataColumn [2];
 135                         Cols2 [0] = _ds.Tables [1].Columns [0];
 136                         Cols2 [1] = _ds.Tables [1].Columns [1];
 137
 138                         ForeignKeyConstraint Constraint = new ForeignKeyConstraint (Cols1, Cols2);
 139                         Table = _ds.Tables [1];
 140                         Table.Constraints.Add (Constraint);
 141
 142                         AssertEquals ("test#03", 1, Table.Constraints.Count);
 143                         AssertEquals ("test#04", "Constraint1", Table.Constraints [0].ConstraintName);
 144                         AssertEquals ("test#05", typeof (ForeignKeyConstraint), Table.Constraints [0].GetType ());
 145
 146                         Table = _ds.Tables [0];
 147                         AssertEquals ("test#06", 1, Table.Constraints.Count);
 148                         AssertEquals ("test#07", "Constraint1", Table.Constraints [0].ConstraintName);
 149                         AssertEquals ("test#08", typeof (UniqueConstraint), Table.Constraints [0].GetType ());
 150
 151                 }
 152
 153                 // Tests ctor (string, DataColumn [], DataColumn [])
 154                 [Test]
 155                 public void Ctor4 ()
 156                 {
 157                         DataTable Table =  _ds.Tables [0];
 158
 159                         AssertEquals ("test#01", 0, Table.Constraints.Count);
 160                         Table =  _ds.Tables [1];
 161                         AssertEquals ("test#02", 0, Table.Constraints.Count);
 162
 163                         DataColumn [] Cols1 = new DataColumn [2];
 164                         Cols1 [0] = _ds.Tables [0].Columns [1];
 165                         Cols1 [1] = _ds.Tables [0].Columns [2];
 166
 167                         DataColumn [] Cols2 = new DataColumn [2];
 168                         Cols2 [0] = _ds.Tables [1].Columns [0];
 169                         Cols2 [1] = _ds.Tables [1].Columns [1];
 170
 171                         ForeignKeyConstraint Constraint = new ForeignKeyConstraint ("Test", Cols1, Cols2);
 172                         Table = _ds.Tables [1];
 173                         Table.Constraints.Add (Constraint);
 174
 175                         AssertEquals ("test#03", 1, Table.Constraints.Count);
 176                         AssertEquals ("test#04", "Test", Table.Constraints [0].ConstraintName);
 177                         AssertEquals ("test#05", typeof (ForeignKeyConstraint), Table.Constraints [0].GetType ());
 178
 179                         Table = _ds.Tables [0];
 180                         AssertEquals ("test#06", 1, Table.Constraints.Count);
 181                         AssertEquals ("test#07", "Constraint1", Table.Constraints [0].ConstraintName);
 182                         AssertEquals ("test#08", typeof (UniqueConstraint), Table.Constraints [0].GetType ());
 183                 }
 184
 185                 [Test]
 186                 public void TestCtor5()
 187                 {
 188                         DataTable table1 = new DataTable ("Table1");
 189                         DataTable table2 = new DataTable ("Table2");
 190                         DataSet dataSet = new DataSet();
 191                         dataSet.Tables.Add (table1);
 192                         dataSet.Tables.Add (table2);
 193                         DataColumn column1 = new DataColumn ("col1");
 194                         DataColumn column2 = new DataColumn ("col2");
 195                         DataColumn column3 = new DataColumn ("col3");
 196                         table1.Columns.Add (column1);
 197                         table1.Columns.Add (column2);
 198                         table1.Columns.Add (column3);
 199                         DataColumn column4 = new DataColumn ("col4");
 200                         DataColumn column5 = new DataColumn ("col5");
 201                         DataColumn column6 = new DataColumn ("col6");
 202                         table2.Columns.Add (column4);
 203                         table2.Columns.Add (column5);
 204                         table2.Columns.Add (column6);
 205                         string []parentColumnNames = {"col1", "col2", "col3"};
 206                         string []childColumnNames = {"col4", "col5", "col6"};
 207                         string parentTableName = "table1";
 208
 209                         // Create a ForeingKeyConstraint Object using the constructor
 210                         // ForeignKeyConstraint (string, string, string[], string[], AcceptRejectRule, Rule, Rule);
 211                          ForeignKeyConstraint fkc = new ForeignKeyConstraint ("hello world", parentTableName, parentColumnNames, childColumnNames, AcceptRejectRule.Cascade, Rule.Cascade, Rule.Cascade);                                                                                                                            // Assert that the Constraint object does not belong to any table yet
 212 #if NET_1_1
 213                         try {
 214                                 DataTable tmp = fkc.Table;
 215                                 Fail ("When table is null, get_Table causes an InvalidOperationException.");
 216                         } catch (InvalidOperationException) {
 217                         }
 218 #else
 219                         Assertion.AssertEquals ("#A01 Table should not be set", fkc.Table, null);
 220 #endif
 221
 222                         Constraint []constraints = new Constraint[3];
 223                         constraints [0] = new UniqueConstraint (column1);
 224                         constraints [1] = new UniqueConstraint (column2);
 225                         constraints [2] = fkc;
 226
 227                         // Try to add the constraint to ConstraintCollection of the DataTable through Add()
 228                         try{
 229                                 table2.Constraints.Add (fkc);
 230                                 throw new ApplicationException ("An Exception was expected");
 231                         }
 232                         // LAMESPEC : spec says InvalidConstraintException but throws this
 233                         catch (ArgumentException) {
 234                         }
 235
 236 #if false // FIXME: Here this test crashes under MS.NET.
 237                         // OK - So AddRange() is the only way!
 238                         table2.Constraints.AddRange (constraints);
 239                            // After AddRange(), Check the properties of ForeignKeyConstraint object
 240                         Assertion.Assert("#A04", fkc.RelatedColumns [0].ColumnName.Equals ("col1"));                        Assertion.Assert("#A05", fkc.RelatedColumns [1].ColumnName.Equals ("col2"));                        Assertion.Assert("#A06", fkc.RelatedColumns [2].ColumnName.Equals ("col3"));                        Assertion.Assert("#A07", fkc.Columns [0].ColumnName.Equals ("col4"));
 241                         Assertion.Assert("#A08", fkc.Columns [1].ColumnName.Equals ("col5"));
 242                         Assertion.Assert("#A09", fkc.Columns [2].ColumnName.Equals ("col6"));
 243 #endif
 244                         // Try to add columns with names which do not exist in the table
 245                         parentColumnNames [2] = "noColumn";
 246                         ForeignKeyConstraint foreignKeyConstraint = new ForeignKeyConstraint ("hello world", parentTableName, parentColumnNames, childColumnNames, AcceptRejectRule.Cascade, Rule.Cascade, Rule.Cascade);
 247                         constraints [0] = new UniqueConstraint (column1);
 248                         constraints [1] = new UniqueConstraint (column2);
 249                         constraints [2] = foreignKeyConstraint;
 250                         try{
 251                                 table2.Constraints.AddRange (constraints);
 252                                 throw new ApplicationException ("An Exception was expected");
 253                         }
 254                         catch (ArgumentException e) {
 255                         }
 256                         catch (InvalidConstraintException e){ // Could not test on ms.net, as ms.net does not reach here so far.
 257                         }
 258
 259 #if false // FIXME: Here this test crashes under MS.NET.
 260                         // Check whether the child table really contains the foreign key constraint named "hello world"
 261                         Assertion.Assert("#A11 ", table2.Constraints.Contains ("hello world"));
 262 #endif
 263                 }
 264
 265
 266
 267                 //  If Childs and parents are in same table
 268                 [Test]
 269                 public void KeyBetweenColumns ()
 270                 {
 271                         DataTable Table =  _ds.Tables [0];
 272
 273                         AssertEquals ("test#01", 0, Table.Constraints.Count);
 274                         Table =  _ds.Tables [1];
 275                         AssertEquals ("test#02", 0, Table.Constraints.Count);
 276
 277
 278                         ForeignKeyConstraint Constraint = new ForeignKeyConstraint ("Test", _ds.Tables [0].Columns [0], _ds.Tables [0].Columns [2]);
 279                         Table = _ds.Tables [0];
 280                         Table.Constraints.Add (Constraint);
 281
 282                         AssertEquals ("test#03", 2, Table.Constraints.Count);
 283                         AssertEquals ("test#04", "Constraint1", Table.Constraints [0].ConstraintName);
 284                         AssertEquals ("test#05", typeof (UniqueConstraint), Table.Constraints [0].GetType ());
 285                         AssertEquals ("test#04", "Test", Table.Constraints [1].ConstraintName);
 286                         AssertEquals ("test#05", typeof (ForeignKeyConstraint), Table.Constraints [1].GetType ());
 287
 288                 }
 289
 290                 [Test]
 291                 public void CtorExceptions ()
 292                 {
 293                         ForeignKeyConstraint fkc;
 294
 295                         DataTable localTable = new DataTable();
 296                         localTable.Columns.Add("Col1",typeof(int));
 297                         localTable.Columns.Add("Col2",typeof(bool));
 298
 299                         //Null
 300                         try
 301                         {
 302                                 fkc = new ForeignKeyConstraint((DataColumn)null,(DataColumn)null);
 303                                 Fail("Failed to throw ArgumentNullException.");
 304                         }
 305 #if NET_1_1
 306                         catch (NullReferenceException) {}
 307 #else
 308                         catch (ArgumentNullException) {}
 309 #endif
 310                         catch (AssertionException exc) {throw exc;}
 311                         catch (Exception exc)
 312                         {
 313                                 Fail("A1: Wrong Exception type. " + exc.ToString());
 314                         }
 315
 316                         //zero length collection
 317                         try
 318                         {
 319                                 fkc = new ForeignKeyConstraint(new DataColumn[]{},new DataColumn[]{});
 320                                 Fail("B1: Failed to throw ArgumentException.");
 321                         }
 322                         catch (ArgumentException) {}
 323                         catch (AssertionException exc) {throw exc;}
 324                         catch (Exception exc)
 325                         {
 326                                 Fail("A2: Wrong Exception type. " + exc.ToString());
 327                         }
 328
 329                         //different datasets
 330                         try
 331                         {
 332                                 fkc = new ForeignKeyConstraint(_ds.Tables[0].Columns[0], localTable.Columns[0]);
 333                                 Fail("Failed to throw InvalidOperationException.");
 334                         }
 335                         catch (InvalidOperationException) {}
 336                         catch (AssertionException exc) {throw exc;}
 337                         catch (Exception exc)
 338                         {
 339                                 Fail("A3: Wrong Exception type. " + exc.ToString());
 340                         }
 341
 342                         try
 343                         {
 344                                 fkc = new ForeignKeyConstraint(_ds.Tables[0].Columns[0], localTable.Columns[1]);
 345                                 Fail("Failed to throw InvalidConstraintException.");
 346                         }
 347 #if NET_1_1
 348                         // tables in different datasets
 349                         catch (InvalidOperationException) {}
 350 #else
 351                         //different dataTypes
 352                         catch (InvalidConstraintException) {}
 353 #endif
 354
 355                         // Cannot create a Key from Columns that belong to
 356                         // different tables.
 357                         try
 358                         {
 359                                 fkc = new ForeignKeyConstraint(new DataColumn [] {_ds.Tables[0].Columns[0], _ds.Tables[0].Columns[1]}, new DataColumn [] {localTable.Columns[1], _ds.Tables[1].Columns [0]});
 360                                 Fail("Failed to throw InvalidOperationException.");
 361                         }
 362                         catch (InvalidConstraintException) {}
 363                         catch (AssertionException exc) {throw exc;}
 364                 }
 365
 366                 [Test]
 367                 public void CtorExceptions2 ()
 368                 {
 369                         DataColumn col = new DataColumn("MyCol1",typeof(int));
 370
 371                         ForeignKeyConstraint fkc;
 372
 373                         //Columns must belong to a Table
 374                         try
 375                         {
 376                                 fkc = new ForeignKeyConstraint(col, _ds.Tables[0].Columns[0]);
 377                                 Fail("FTT1: Failed to throw ArgumentException.");
 378                         }
 379                         catch (ArgumentException) {}
 380                         catch (AssertionException exc) {throw exc;}
 381 //                      catch (Exception exc)
 382 //                      {
 383 //                              Fail("WET1: Wrong Exception type. " + exc.ToString());
 384 //                      }
 385
 386                         //Columns must belong to the same table
 387                         //InvalidConstraintException
 388
 389                         DataColumn [] difTable = new DataColumn [] {_ds.Tables[0].Columns[2],
 390                                                                            _ds.Tables[1].Columns[0]};
 391                         try
 392                         {
 393                                 fkc = new ForeignKeyConstraint(difTable,new DataColumn[] {
 394                                                                  _ds.Tables[0].Columns[1],
 395                                                                 _ds.Tables[0].Columns[0]});
 396
 397                                 Fail("FTT2: Failed to throw InvalidConstraintException.");
 398                         }
 399                         catch (InvalidConstraintException) {}
 400                         catch (AssertionException exc) {throw exc;}
 401                         catch (Exception exc)
 402                         {
 403                                 Fail("WET2: Wrong Exception type. " + exc.ToString());
 404                         }
 405
 406
 407                         //parent columns and child columns should be the same length
 408                         //ArgumentException
 409                         DataColumn [] twoCol =
 410                                 new DataColumn [] {_ds.Tables[0].Columns[0],_ds.Tables[0].Columns[1]};
 411
 412
 413                         try
 414                         {
 415                                 fkc = new ForeignKeyConstraint(twoCol,
 416                                         new DataColumn[] { _ds.Tables[0].Columns[0]});
 417
 418                                 Fail("FTT3: Failed to throw ArgumentException.");
 419                         }
 420                         catch (ArgumentException) {}
 421                         catch (AssertionException exc) {throw exc;}
 422                         catch (Exception exc)
 423                         {
 424                                 Fail("WET3: Wrong Exception type. " + exc.ToString());
 425                         }
 426
 427                         //InvalidOperation: Parent and child are the same column.
 428                         try
 429                         {
 430                                 fkc = new ForeignKeyConstraint( _ds.Tables[0].Columns[0],
 431                                         _ds.Tables[0].Columns[0] );
 432
 433                                 Fail("FTT4: Failed to throw InvalidOperationException.");
 434                         }
 435                         catch (InvalidOperationException) {}
 436                         catch (AssertionException exc) {throw exc;}
 437                         catch (Exception exc)
 438                         {
 439                                 Fail("WET4: Wrong Exception type. " + exc.ToString());
 440                         }
 441
 442                 }
 443
 444                 [Test]
 445                 public void EqualsAndHashCode()
 446                 {
 447                         DataTable tbl = _ds.Tables[0];
 448                         DataTable tbl2 = _ds.Tables[1];
 449
 450                         ForeignKeyConstraint fkc = new ForeignKeyConstraint(
 451                                 new DataColumn[] {tbl.Columns[0], tbl.Columns[1]} ,
 452                                 new DataColumn[] {tbl2.Columns[0], tbl2.Columns[1]} );
 453
 454                         ForeignKeyConstraint fkc2 = new ForeignKeyConstraint(
 455                                 new DataColumn[] {tbl.Columns[0], tbl.Columns[1]} ,
 456                                 new DataColumn[] {tbl2.Columns[0], tbl2.Columns[1]} );
 457
 458                         ForeignKeyConstraint fkcDiff =
 459                                 new ForeignKeyConstraint( tbl.Columns[1], tbl.Columns[2]);
 460
 461                         Assert( "Equals failed. 1" , fkc.Equals(fkc2));
 462                         Assert( "Equals failed. 2" , fkc2.Equals(fkc));
 463                         Assert( "Equals failed. 3" , fkc.Equals(fkc));
 464
 465                         Assert( "Equals failed diff. 1" , fkc.Equals(fkcDiff) == false);
 466
 467                         Assert( "Hash Code Failed. 1", fkc.GetHashCode() == fkc2.GetHashCode() );
 468                         Assert( "Hash Code Failed. 2", fkc.GetHashCode() != fkcDiff.GetHashCode() );
 469
 470                 }
 471
 472                 [Test]
 473                 [ExpectedException (typeof (ArgumentException))]
 474                 public void ViolationTest ()
 475                 {
 476                         DataTable parent = _ds.Tables [0];
 477                         DataTable child  = _ds.Tables [1];
 478
 479                         parent.Rows.Add (new object [] {1, 1, 1});
 480                         child.Rows.Add (new object [] {2, 2, 2});
 481
 482                         try {
 483                                 child.Constraints.Add (new ForeignKeyConstraint ( parent.Columns [0],
 484                                                                                   child.Columns [0])
 485                                                        );
 486                         } finally {
 487                                 // clear the rows for further testing
 488                                 _ds.Clear ();
 489                         }
 490                 }
 491
 492                 [Test]
 493                 public void NoViolationTest ()
 494                 {
 495                         DataTable parent = _ds.Tables [0];
 496                         DataTable child  = _ds.Tables [1];
 497
 498                         parent.Rows.Add (new object [] {1, 1, 1});
 499                         child.Rows.Add (new object [] {2, 2, 2});
 500
 501                         try {
 502                                 _ds.EnforceConstraints = false;
 503                                 child.Constraints.Add (new ForeignKeyConstraint ( parent.Columns [0],
 504                                                                                   child.Columns [0])
 505                                                        );
 506                         } finally {
 507                                 // clear the rows for further testing
 508                                 _ds.Clear ();
 509                                 _ds.EnforceConstraints = true;
 510                         }
 511                 }
 512
 513                 [Test]
 514                 public void ModifyParentKeyBeforeAcceptChanges ()
 515                 {
 516                         DataSet ds1 = new DataSet();
 517                         DataTable t1= ds1.Tables.Add ("t1");
 518                         DataTable t2= ds1.Tables.Add ("t2");
 519                         t1.Columns.Add ("col1", typeof (int));
 520                         t2.Columns.Add ("col2", typeof (int));
 521                         ds1.Relations.Add ("fk", t1.Columns [0], t2.Columns [0]);
 522
 523                         t1.Rows.Add (new object[] {10});
 524                         t2.Rows.Add (new object [] {10});
 525
 526                         t1.Rows [0][0]=20;
 527                         Assert("#1", (int)t2.Rows [0][0] == 20);
 528                 }
 529         }
 530 }