2 // Rafael Mizrahi <rafim@mainsoft.com>
3 // Erez Lotan <erezl@mainsoft.com>
4 // Oren Gurfinkel <oreng@mainsoft.com>
7 // Copyright (c) 2004 Mainsoft Co.
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.
31 using System.Data.OleDb ;
34 using System.Collections;
36 // Provide All Data required by the diffderent tests e.g.DataTable, DataRow ...
40 public class DataProvider
45 //A string containing all printable charachters.
46 private const string SAMPLE_STRING = "abcdefghijklmnopqrstuvwxyz1234567890~!@#$%^&*()_+-=[]\\|;:,./<>? ";
52 public static System.Data.DataTable CreateChildDataTable()
54 System.Data.DataTable dtChild = new System.Data.DataTable("Child");
55 dtChild.Columns.Add("ParentId",typeof(int));
56 dtChild.Columns.Add("ChildId",typeof(int));
57 dtChild.Columns.Add("String1",typeof(string));
58 dtChild.Columns.Add("String2",typeof(string));
59 dtChild.Columns.Add("ChildDateTime",typeof(DateTime));
60 dtChild.Columns.Add("ChildDouble",typeof(double));
62 dtChild.Rows.Add(new object[] {1,1,"1-String1","1-String2",new DateTime(2000,1,1,0,0,0,0),1.534});
63 dtChild.Rows.Add(new object[] {1,2,"2-String1","2-String2",DateTime.MaxValue ,-1.534});
64 dtChild.Rows.Add(new object[] {1,3,"3-String1","3-String2",DateTime.MinValue,double.MaxValue/10000});
65 dtChild.Rows.Add(new object[] {2,1,"1-String1","1-String2",new DateTime(1973,6,20,0,0,0,0),double.MinValue*10000});
66 dtChild.Rows.Add(new object[] {2,2,"2-String1","2-String2",new DateTime(2008,12,1,13,59,59,59),0.45});
67 dtChild.Rows.Add(new object[] {2,3,"3-String1","3-String2",new DateTime(2003,1,1,1,1,1,1),0.55});
68 dtChild.Rows.Add(new object[] {5,1,"1-String1","1-String2",new DateTime(2002,1,1,1,1,1,1),0});
69 dtChild.Rows.Add(new object[] {5,2,"2-String1","2-String2",new DateTime(2001,1,1,1,1,1,1),10});
70 dtChild.Rows.Add(new object[] {5,3,"3-String1","3-String2",new DateTime(2000,1,1,1,1,1,1),20});
71 dtChild.Rows.Add(new object[] {6,1,"1-String1","1-String2",new DateTime(2000,1,1,1,1,1,0),25});
72 dtChild.Rows.Add(new object[] {6,2,"2-String1","2-String2",new DateTime(2000,1,1,1,1,0,0),30});
73 dtChild.Rows.Add(new object[] {6,3,"3-String1","3-String2",new DateTime(2000,1,1,0,0,0,0),35});
74 dtChild.AcceptChanges();
79 public static System.Data.DataTable CreateParentDataTable()
82 System.Data.DataTable dtParent = new System.Data.DataTable("Parent");
84 dtParent.Columns.Add("ParentId",typeof(int));
85 dtParent.Columns.Add("String1",typeof(string));
86 dtParent.Columns.Add("String2",typeof(string));
88 dtParent.Columns.Add("ParentDateTime",typeof(DateTime));
89 dtParent.Columns.Add("ParentDouble",typeof(double));
90 dtParent.Columns.Add("ParentBool",typeof(bool));
92 dtParent.Rows.Add(new object[] {1,"1-String1","1-String2",new DateTime(2005,1,1,0,0,0,0),1.534,true});
93 dtParent.Rows.Add(new object[] {2,"2-String1","2-String2",new DateTime(2004,1,1,0,0,0,1),-1.534,true});
94 dtParent.Rows.Add(new object[] {3,"3-String1","3-String2",new DateTime(2003,1,1,0,0,1,0),double.MinValue*10000,false});
95 dtParent.Rows.Add(new object[] {4,"4-String1","4-String2",new DateTime(2002,1,1,0,1,0,0),double.MaxValue/10000,true});
96 dtParent.Rows.Add(new object[] {5,"5-String1","5-String2",new DateTime(2001,1,1,1,0,0,0),0.755,true});
97 dtParent.Rows.Add(new object[] {6,"6-String1","6-String2",new DateTime(2000,1,1,0,0,0,0),0.001,false});
98 dtParent.AcceptChanges();
103 //This method replace the DataSet GetXmlSchema method
104 //used to compare DataSets
105 //Created by Ofer (13-Nov-03) becuase DataSet GetXmlSchema method is not yet implemented in java
106 public static string GetDSSchema(DataSet ds)
109 string strSchema = "DataSet Name=" + ds.DataSetName + "\n";
111 foreach (DataRelation dl in ds.Relations)
113 strSchema += "\t" + "DataRelation Name=" + dl.RelationName ;
114 foreach (DataColumn dc in dl.ParentColumns)
115 strSchema += "\t" + "ParentColummn=" + dc.ColumnName ;
116 foreach (DataColumn dc in dl.ChildColumns )
117 strSchema += "\t" + "ChildColumn=" + dc.ColumnName ;
121 foreach (DataTable dt in ds.Tables)
123 strSchema += "Table=" + dt.TableName + "\t";
125 strSchema += "Constraints =";
126 foreach (Constraint cs in dt.Constraints )
127 strSchema += cs.GetType().Name + ", ";
129 //Get PrimaryKey Columns
130 strSchema += "PrimaryKey Columns index:=";
131 foreach (DataColumn dc in dt.PrimaryKey)
132 strSchema += dc.Ordinal + ", ";
135 foreach (DataColumn dc in dt.Columns)
137 strSchema += "ColumnName=" + dc.ColumnName + "\t" +
138 "ColumnType=" + dc.DataType.Name + "\t" +
139 "AllowDBNull=" + dc.AllowDBNull.ToString() + "\t" +
140 "DefaultValue=" + dc.DefaultValue.ToString() + "\t" +
141 "Unique=" + dc.Unique.ToString() + "\t" +
142 "ReadOnly=" + dc.ReadOnly.ToString() + "\n" ;
150 public static DataTable CreateUniqueConstraint()
152 DataTable dt = GHTUtils.DataProvider.CreateParentDataTable();
153 return CreateUniqueConstraint(dt);
155 public static DataTable CreateUniqueConstraint(DataTable dt)
157 Constraint con = new UniqueConstraint(dt.Columns["ParentId"]);
158 dt.Constraints.Add(con);
162 public static void TryToBreakUniqueConstraint()
164 //Create the constraint
165 DataTable dt = CreateUniqueConstraint();
166 //Try to violate the constraint
168 DataRow dr1 = dt.NewRow();
173 public static DataSet CreateForigenConstraint()
175 DataTable parent = GHTUtils.DataProvider.CreateParentDataTable();
176 DataTable child = GHTUtils.DataProvider.CreateChildDataTable();
177 DataSet ds = new DataSet();
178 ds.Tables.Add(parent);
179 ds.Tables.Add(child);
181 Constraint con1 = new ForeignKeyConstraint(parent.Columns[0],child.Columns[0]);
182 child.Constraints.Add(con1);
186 public static void TryToBreakForigenConstraint()
188 DataSet ds = CreateForigenConstraint();
191 DataRow dr = ds.Tables[1].NewRow();
193 ds.Tables[1].Rows.Add(dr);
196 ds.EnforceConstraints=true;