mcs/class/System.Data/Test/System.Data.Test.Utils/DataProvider.cs

   1 // Authors:
   2 //   Rafael Mizrahi   <rafim@mainsoft.com>
   3 //   Erez Lotan       <erezl@mainsoft.com>
   4 //   Oren Gurfinkel   <oreng@mainsoft.com>
   5 //   Ofer Borstein
   6 //
   7 // Copyright (c) 2004 Mainsoft Co.
   8 //
   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:
  16 //
  17 // The above copyright notice and this permission notice shall be
  18 // included in all copies or substantial portions of the Software.
  19 //
  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.
  27 //
  28
  29 using System;
  30 using System.Data;
  31 using System.IO;
  32 using System.Collections;
  33
  34 // Provide All Data required by the diffderent tests e.g.DataTable, DataRow ...
  35 namespace MonoTests.System.Data.Utils
  36 {
  37         public class DataProvider
  38         {
  39                 #region Constatntas
  40
  41                 #region Private
  42                 //A string containing all printable charachters.
  43                 private const string SAMPLE_STRING = "abcdefghijklmnopqrstuvwxyz1234567890~!@#$%^&*()_+-=[]\\|;:,./<>? ";
  44                 #endregion
  45
  46                 #endregion
  47
  48                 public static DataTable CreateChildDataTable()
  49                 {
  50                         DataTable dtChild = new DataTable("Child");
  51                         dtChild.Columns.Add("ParentId",typeof(int));
  52                         dtChild.Columns.Add("ChildId",typeof(int));
  53                         dtChild.Columns.Add("String1",typeof(string));
  54                         dtChild.Columns.Add("String2",typeof(string));
  55                         dtChild.Columns.Add("ChildDateTime",typeof(DateTime));
  56                         dtChild.Columns.Add("ChildDouble",typeof(double));
  57
  58                         dtChild.Rows.Add(new object[] {1,1,"1-String1","1-String2",new DateTime(2000,1,1,0,0,0,0),1.534});
  59                         dtChild.Rows.Add(new object[] {1,2,"2-String1","2-String2",DateTime.MaxValue ,-1.534});
  60                         dtChild.Rows.Add(new object[] {1,3,"3-String1","3-String2",DateTime.MinValue,double.MaxValue/10000});
  61                         dtChild.Rows.Add(new object[] {2,1,"1-String1","1-String2",new DateTime(1973,6,20,0,0,0,0),double.MinValue*10000});
  62                         dtChild.Rows.Add(new object[] {2,2,"2-String1","2-String2",new DateTime(2008,12,1,13,59,59,59),0.45});
  63                         dtChild.Rows.Add(new object[] {2,3,"3-String1","3-String2",new DateTime(2003,1,1,1,1,1,1),0.55});
  64                         dtChild.Rows.Add(new object[] {5,1,"1-String1","1-String2",new DateTime(2002,1,1,1,1,1,1),0});
  65                         dtChild.Rows.Add(new object[] {5,2,"2-String1","2-String2",new DateTime(2001,1,1,1,1,1,1),10});
  66                         dtChild.Rows.Add(new object[] {5,3,"3-String1","3-String2",new DateTime(2000,1,1,1,1,1,1),20});
  67                         dtChild.Rows.Add(new object[] {6,1,"1-String1","1-String2",new DateTime(2000,1,1,1,1,1,0),25});
  68                         dtChild.Rows.Add(new object[] {6,2,"2-String1","2-String2",new DateTime(2000,1,1,1,1,0,0),30});
  69                         dtChild.Rows.Add(new object[] {6,3,"3-String1","3-String2",new DateTime(2000,1,1,0,0,0,0),35});
  70                         dtChild.AcceptChanges();
  71                         return dtChild;
  72                 }
  73
  74                 public static DataTable CreateParentDataTable()
  75                 {
  76                         DataTable dtParent = new DataTable("Parent");
  77
  78                         dtParent.Columns.Add("ParentId",typeof(int));
  79                         dtParent.Columns.Add("String1",typeof(string));
  80                         dtParent.Columns.Add("String2",typeof(string));
  81
  82                         dtParent.Columns.Add("ParentDateTime",typeof(DateTime));
  83                         dtParent.Columns.Add("ParentDouble",typeof(double));
  84                         dtParent.Columns.Add("ParentBool",typeof(bool));
  85
  86                         dtParent.Rows.Add(new object[] {1,"1-String1","1-String2",new DateTime(2005,1,1,0,0,0,0),1.534,true});
  87                         dtParent.Rows.Add(new object[] {2,"2-String1","2-String2",new DateTime(2004,1,1,0,0,0,1),-1.534,true});
  88                         dtParent.Rows.Add(new object[] {3,"3-String1","3-String2",new DateTime(2003,1,1,0,0,1,0),double.MinValue*10000,false});
  89                         dtParent.Rows.Add(new object[] {4,"4-String1","4-String2",new DateTime(2002,1,1,0,1,0,0),double.MaxValue/10000,true});
  90                         dtParent.Rows.Add(new object[] {5,"5-String1","5-String2",new DateTime(2001,1,1,1,0,0,0),0.755,true});
  91                         dtParent.Rows.Add(new object[] {6,"6-String1","6-String2",new DateTime(2000,1,1,0,0,0,0),0.001,false});
  92                         dtParent.AcceptChanges();
  93                         return dtParent;
  94                 }
  95
  96                 //This method replace the DataSet GetXmlSchema method
  97                 //used to compare DataSets
  98                 //Created by Ofer (13-Nov-03) becuase DataSet GetXmlSchema method is not yet implemented in java
  99                 public static string GetDSSchema(DataSet ds)
 100                 {
 101                         string strSchema = "DataSet Name=" + ds.DataSetName + "\n";
 102                         //Get relations
 103                         foreach (DataRelation dl in ds.Relations)
 104                         {
 105                                 strSchema += "\t" + "DataRelation Name=" + dl.RelationName ;
 106                                 foreach (DataColumn dc in dl.ParentColumns)
 107                                         strSchema += "\t" + "ParentColummn=" +  dc.ColumnName ;
 108                                 foreach (DataColumn dc in dl.ChildColumns )
 109                                         strSchema += "\t" + "ChildColumn=" +  dc.ColumnName ;
 110                                 strSchema += "\n";
 111                         }
 112                         //Get teables
 113                         foreach (DataTable dt in ds.Tables)
 114                         {
 115                                 strSchema += "Table=" + dt.TableName + "\t";
 116                                 //Get Constraints
 117                                 strSchema += "Constraints =";
 118                                 foreach (Constraint cs in dt.Constraints )
 119                                         strSchema += cs.GetType().Name + ", ";
 120                                 strSchema += "\n";
 121                                 //Get PrimaryKey Columns
 122                                 strSchema += "PrimaryKey Columns index:=";
 123                                 foreach (DataColumn dc in dt.PrimaryKey)
 124                                         strSchema += dc.Ordinal + ", ";
 125                                 strSchema += "\n";
 126                                 //Get Columns
 127                                 foreach (DataColumn dc in dt.Columns)
 128                                 {
 129                                         strSchema += "ColumnName=" + dc.ColumnName + "\t" +
 130                                                 "ColumnType=" + dc.DataType.Name + "\t" +
 131                                                 "AllowDBNull=" + dc.AllowDBNull.ToString() + "\t" +
 132                                                 "DefaultValue=" + dc.DefaultValue.ToString() + "\t" +
 133                                                 "Unique=" + dc.Unique.ToString() + "\t" +
 134                                                 "ReadOnly=" + dc.ReadOnly.ToString() + "\n" ;
 135                                 }
 136                                 strSchema += "\n";
 137                         }
 138                         return strSchema;
 139                 }
 140
 141                 public static DataTable CreateUniqueConstraint()
 142                 {
 143                         DataTable dt = DataProvider.CreateParentDataTable();
 144                         return CreateUniqueConstraint(dt);
 145                 }
 146
 147                 public static DataTable CreateUniqueConstraint(DataTable dt)
 148                 {
 149                         Constraint con = new UniqueConstraint(dt.Columns["ParentId"]);
 150                         dt.Constraints.Add(con);
 151                         return dt;
 152                 }
 153
 154                 public static void TryToBreakUniqueConstraint()
 155                 {
 156                         //Create the constraint
 157                         DataTable dt =  CreateUniqueConstraint();
 158                         //Try to violate the constraint
 159
 160                         DataRow dr1 = dt.NewRow();
 161                         dr1[0] = 1;
 162                         dt.Rows.Add(dr1);
 163                 }
 164
 165                 public static DataSet CreateForigenConstraint()
 166                 {
 167                         DataTable parent = DataProvider.CreateParentDataTable();
 168                         DataTable child = DataProvider.CreateChildDataTable();
 169                         DataSet ds = new DataSet();
 170                         ds.Tables.Add(parent);
 171                         ds.Tables.Add(child);
 172
 173                         Constraint con1 = new ForeignKeyConstraint(parent.Columns[0],child.Columns[0]);
 174                         child.Constraints.Add(con1);
 175
 176                         return ds;
 177                 }
 178
 179                 public static void TryToBreakForigenConstraint()
 180                 {
 181                         DataSet ds = CreateForigenConstraint();
 182                         //Code to break:
 183
 184                         DataRow dr =  ds.Tables[1].NewRow();
 185                         dr[0]=7;
 186                         ds.Tables[1].Rows.Add(dr);
 187
 188                         ds.AcceptChanges();
 189                         ds.EnforceConstraints=true;
 190                 }
 191         }
 192 }