1 // ForeignKeyConstraintTest.cs - NUnit Test Cases for [explain here]
4 // Franklin Wise (gracenote@earthlink.net)
5 // Martin Willemoes Hansen (mwh@sysrq.dk)
8 // (C) 2003 Martin Willemoes Hansen
12 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
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:
22 // The above copyright notice and this permission notice shall be
23 // included in all copies or substantial portions of the Software.
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.
34 using NUnit.Framework;
38 namespace MonoTests.System.Data
41 public class ForeignKeyConstraintTest : Assertion
45 //NOTE: fk constraints only work when the table is part of a DataSet
48 public void GetReady()
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));
59 _ds.Tables.Add(table);
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));
66 _ds.Tables.Add(table);
70 // Tests ctor (string, DataColumn, DataColumn)
74 DataTable Table = _ds.Tables [0];
76 AssertEquals ("test#01", 0, Table.Constraints.Count);
77 Table = _ds.Tables [1];
78 AssertEquals ("test#02", 0, Table.Constraints.Count);
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);
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 ());
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 ());
95 // Tests ctor (DataColumn, DataColumn)
99 DataTable Table = _ds.Tables [0];
101 AssertEquals ("test#01", 0, Table.Constraints.Count);
102 Table = _ds.Tables [1];
103 AssertEquals ("test#02", 0, Table.Constraints.Count);
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);
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 ());
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 ());
120 // Test ctor (DataColumn [], DataColumn [])
124 DataTable Table = _ds.Tables [0];
126 AssertEquals ("test#01", 0, Table.Constraints.Count);
127 Table = _ds.Tables [1];
128 AssertEquals ("test#02", 0, Table.Constraints.Count);
130 DataColumn [] Cols1 = new DataColumn [2];
131 Cols1 [0] = _ds.Tables [0].Columns [1];
132 Cols1 [1] = _ds.Tables [0].Columns [2];
134 DataColumn [] Cols2 = new DataColumn [2];
135 Cols2 [0] = _ds.Tables [1].Columns [0];
136 Cols2 [1] = _ds.Tables [1].Columns [1];
138 ForeignKeyConstraint Constraint = new ForeignKeyConstraint (Cols1, Cols2);
139 Table = _ds.Tables [1];
140 Table.Constraints.Add (Constraint);
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 ());
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 ());
153 // Tests ctor (string, DataColumn [], DataColumn [])
157 DataTable Table = _ds.Tables [0];
159 AssertEquals ("test#01", 0, Table.Constraints.Count);
160 Table = _ds.Tables [1];
161 AssertEquals ("test#02", 0, Table.Constraints.Count);
163 DataColumn [] Cols1 = new DataColumn [2];
164 Cols1 [0] = _ds.Tables [0].Columns [1];
165 Cols1 [1] = _ds.Tables [0].Columns [2];
167 DataColumn [] Cols2 = new DataColumn [2];
168 Cols2 [0] = _ds.Tables [1].Columns [0];
169 Cols2 [1] = _ds.Tables [1].Columns [1];
171 ForeignKeyConstraint Constraint = new ForeignKeyConstraint ("Test", Cols1, Cols2);
172 Table = _ds.Tables [1];
173 Table.Constraints.Add (Constraint);
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 ());
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 ());
186 public void TestCtor5()
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";
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
213 DataTable tmp = fkc.Table;
214 Fail ("When table is null, get_Table causes an InvalidOperationException.");
215 } catch (InvalidOperationException) {
218 Constraint []constraints = new Constraint[3];
219 constraints [0] = new UniqueConstraint (column1);
220 constraints [1] = new UniqueConstraint (column2);
221 constraints [2] = fkc;
223 // Try to add the constraint to ConstraintCollection of the DataTable through Add()
225 table2.Constraints.Add (fkc);
226 throw new ApplicationException ("An Exception was expected");
228 // LAMESPEC : spec says InvalidConstraintException but throws this
229 catch (ArgumentException) {
232 #if false // FIXME: Here this test crashes under MS.NET.
233 // OK - So AddRange() is the only way!
234 table2.Constraints.AddRange (constraints);
235 // After AddRange(), Check the properties of ForeignKeyConstraint object
236 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"));
237 Assertion.Assert("#A08", fkc.Columns [1].ColumnName.Equals ("col5"));
238 Assertion.Assert("#A09", fkc.Columns [2].ColumnName.Equals ("col6"));
240 // Try to add columns with names which do not exist in the table
241 parentColumnNames [2] = "noColumn";
242 ForeignKeyConstraint foreignKeyConstraint = new ForeignKeyConstraint ("hello world", parentTableName, parentColumnNames, childColumnNames, AcceptRejectRule.Cascade, Rule.Cascade, Rule.Cascade);
243 constraints [0] = new UniqueConstraint (column1);
244 constraints [1] = new UniqueConstraint (column2);
245 constraints [2] = foreignKeyConstraint;
247 table2.Constraints.AddRange (constraints);
248 throw new ApplicationException ("An Exception was expected");
250 catch (ArgumentException e) {
252 catch (InvalidConstraintException e){ // Could not test on ms.net, as ms.net does not reach here so far.
255 #if false // FIXME: Here this test crashes under MS.NET.
256 // Check whether the child table really contains the foreign key constraint named "hello world"
257 Assertion.Assert("#A11 ", table2.Constraints.Contains ("hello world"));
263 // If Childs and parents are in same table
265 public void KeyBetweenColumns ()
267 DataTable Table = _ds.Tables [0];
269 AssertEquals ("test#01", 0, Table.Constraints.Count);
270 Table = _ds.Tables [1];
271 AssertEquals ("test#02", 0, Table.Constraints.Count);
274 ForeignKeyConstraint Constraint = new ForeignKeyConstraint ("Test", _ds.Tables [0].Columns [0], _ds.Tables [0].Columns [2]);
275 Table = _ds.Tables [0];
276 Table.Constraints.Add (Constraint);
278 AssertEquals ("test#03", 2, Table.Constraints.Count);
279 AssertEquals ("test#04", "Constraint1", Table.Constraints [0].ConstraintName);
280 AssertEquals ("test#05", typeof (UniqueConstraint), Table.Constraints [0].GetType ());
281 AssertEquals ("test#04", "Test", Table.Constraints [1].ConstraintName);
282 AssertEquals ("test#05", typeof (ForeignKeyConstraint), Table.Constraints [1].GetType ());
287 public void CtorExceptions ()
289 ForeignKeyConstraint fkc;
291 DataTable localTable = new DataTable();
292 localTable.Columns.Add("Col1",typeof(int));
293 localTable.Columns.Add("Col2",typeof(bool));
298 fkc = new ForeignKeyConstraint((DataColumn)null,(DataColumn)null);
299 Fail("Failed to throw ArgumentNullException.");
301 catch (NullReferenceException) {}
302 catch (AssertionException exc) {throw exc;}
303 catch (Exception exc)
305 Fail("A1: Wrong Exception type. " + exc.ToString());
308 //zero length collection
311 fkc = new ForeignKeyConstraint(new DataColumn[]{},new DataColumn[]{});
312 Fail("B1: Failed to throw ArgumentException.");
314 catch (ArgumentException) {}
315 catch (AssertionException exc) {throw exc;}
316 catch (Exception exc)
318 Fail("A2: Wrong Exception type. " + exc.ToString());
324 fkc = new ForeignKeyConstraint(_ds.Tables[0].Columns[0], localTable.Columns[0]);
325 Fail("Failed to throw InvalidOperationException.");
327 catch (InvalidOperationException) {}
328 catch (AssertionException exc) {throw exc;}
329 catch (Exception exc)
331 Fail("A3: Wrong Exception type. " + exc.ToString());
336 fkc = new ForeignKeyConstraint(_ds.Tables[0].Columns[0], localTable.Columns[1]);
337 Fail("Failed to throw InvalidConstraintException.");
339 // tables in different datasets
340 catch (InvalidOperationException) {}
342 // Cannot create a Key from Columns that belong to
346 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]});
347 Fail("Failed to throw InvalidOperationException.");
349 catch (InvalidConstraintException) {}
350 catch (AssertionException exc) {throw exc;}
354 public void CtorExceptions2 ()
356 DataColumn col = new DataColumn("MyCol1",typeof(int));
358 ForeignKeyConstraint fkc;
360 //Columns must belong to a Table
363 fkc = new ForeignKeyConstraint(col, _ds.Tables[0].Columns[0]);
364 Fail("FTT1: Failed to throw ArgumentException.");
366 catch (ArgumentException) {}
367 catch (AssertionException exc) {throw exc;}
368 // catch (Exception exc)
370 // Fail("WET1: Wrong Exception type. " + exc.ToString());
373 //Columns must belong to the same table
374 //InvalidConstraintException
376 DataColumn [] difTable = new DataColumn [] {_ds.Tables[0].Columns[2],
377 _ds.Tables[1].Columns[0]};
380 fkc = new ForeignKeyConstraint(difTable,new DataColumn[] {
381 _ds.Tables[0].Columns[1],
382 _ds.Tables[0].Columns[0]});
384 Fail("FTT2: Failed to throw InvalidConstraintException.");
386 catch (InvalidConstraintException) {}
387 catch (AssertionException exc) {throw exc;}
388 catch (Exception exc)
390 Fail("WET2: Wrong Exception type. " + exc.ToString());
394 //parent columns and child columns should be the same length
396 DataColumn [] twoCol =
397 new DataColumn [] {_ds.Tables[0].Columns[0],_ds.Tables[0].Columns[1]};
402 fkc = new ForeignKeyConstraint(twoCol,
403 new DataColumn[] { _ds.Tables[0].Columns[0]});
405 Fail("FTT3: Failed to throw ArgumentException.");
407 catch (ArgumentException) {}
408 catch (AssertionException exc) {throw exc;}
409 catch (Exception exc)
411 Fail("WET3: Wrong Exception type. " + exc.ToString());
414 //InvalidOperation: Parent and child are the same column.
417 fkc = new ForeignKeyConstraint( _ds.Tables[0].Columns[0],
418 _ds.Tables[0].Columns[0] );
420 Fail("FTT4: Failed to throw InvalidOperationException.");
422 catch (InvalidOperationException) {}
423 catch (AssertionException exc) {throw exc;}
424 catch (Exception exc)
426 Fail("WET4: Wrong Exception type. " + exc.ToString());
432 public void EqualsAndHashCode()
434 DataTable tbl = _ds.Tables[0];
435 DataTable tbl2 = _ds.Tables[1];
437 ForeignKeyConstraint fkc = new ForeignKeyConstraint(
438 new DataColumn[] {tbl.Columns[0], tbl.Columns[1]} ,
439 new DataColumn[] {tbl2.Columns[0], tbl2.Columns[1]} );
441 ForeignKeyConstraint fkc2 = new ForeignKeyConstraint(
442 new DataColumn[] {tbl.Columns[0], tbl.Columns[1]} ,
443 new DataColumn[] {tbl2.Columns[0], tbl2.Columns[1]} );
445 ForeignKeyConstraint fkcDiff =
446 new ForeignKeyConstraint( tbl.Columns[1], tbl.Columns[2]);
448 Assert( "Equals failed. 1" , fkc.Equals(fkc2));
449 Assert( "Equals failed. 2" , fkc2.Equals(fkc));
450 Assert( "Equals failed. 3" , fkc.Equals(fkc));
452 Assert( "Equals failed diff. 1" , fkc.Equals(fkcDiff) == false);
454 Assert( "Hash Code Failed. 1", fkc.GetHashCode() == fkc2.GetHashCode() );
455 Assert( "Hash Code Failed. 2", fkc.GetHashCode() != fkcDiff.GetHashCode() );
460 [ExpectedException (typeof (ArgumentException))]
461 public void ViolationTest ()
463 DataTable parent = _ds.Tables [0];
464 DataTable child = _ds.Tables [1];
466 parent.Rows.Add (new object [] {1, 1, 1});
467 child.Rows.Add (new object [] {2, 2, 2});
470 child.Constraints.Add (new ForeignKeyConstraint ( parent.Columns [0],
474 // clear the rows for further testing
480 public void NoViolationTest ()
482 DataTable parent = _ds.Tables [0];
483 DataTable child = _ds.Tables [1];
485 parent.Rows.Add (new object [] {1, 1, 1});
486 child.Rows.Add (new object [] {2, 2, 2});
489 _ds.EnforceConstraints = false;
490 child.Constraints.Add (new ForeignKeyConstraint ( parent.Columns [0],
494 // clear the rows for further testing
496 _ds.EnforceConstraints = true;
501 public void ModifyParentKeyBeforeAcceptChanges ()
503 DataSet ds1 = new DataSet();
504 DataTable t1= ds1.Tables.Add ("t1");
505 DataTable t2= ds1.Tables.Add ("t2");
506 t1.Columns.Add ("col1", typeof (int));
507 t2.Columns.Add ("col2", typeof (int));
508 ds1.Relations.Add ("fk", t1.Columns [0], t2.Columns [0]);
510 t1.Rows.Add (new object[] {10});
511 t2.Rows.Add (new object [] {10});
514 Assert("#1", (int)t2.Rows [0][0] == 20);
518 // https://bugzilla.novell.com/show_bug.cgi?id=650402
519 public void ForeignKey_650402 ()
521 DataSet data = new DataSet ();
522 DataTable parent = new DataTable ("parent");
523 DataColumn pk = parent.Columns.Add ("PK");
524 DataTable child = new DataTable ("child");
525 DataColumn fk = child.Columns.Add ("FK");
527 data.Tables.Add (parent);
528 data.Tables.Add (child);
529 data.Relations.Add (pk, fk);
531 parent.Rows.Add ("value");
532 child.Rows.Add ("value");
533 data.AcceptChanges ();
534 child.Rows[0].Delete ();
535 parent.Rows[0][0] = "value2";
537 data.EnforceConstraints = false;
538 data.EnforceConstraints = true;