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.Data.OracleClient ; 32 using System.IO; 33 using System.Collections; 34 using Sys = System; 35 using MonoTests.System.Data.Utils.Data; 36 37 // Provide All Data required by the diffderent tests e.g.DataTable, DataRow ... 38 namespace MonoTests.System.Data.Utils { 39 /// <summary> 40 /// Types of Database Servers that tests can be run on. 41 /// </summary> 42 public enum DataBaseServer { 43 SQLServer, 44 Oracle, 45 DB2, 46 Sybase, 47 PostgreSQL, 48 Unknown 49 } 50 51 public class ConnectedDataProvider { 52 53 #region Private 54 //A string containing all printable charachters. 55 private const string SAMPLE_STRING = "abcdefghijklmnopqrstuvwxyz1234567890~!@#$%^&*()_+-=[]\\|;:,./<>? "; 56 #endregion 57 58 #region Public 59 /// <summary> 60 /// Name of the table in the database, that contain columns of simple types. 61 /// </summary> 62 public const string SIMPLE_TYPES_TABLE_NAME = "TYPES_SIMPLE"; 63 /// <summary> 64 /// Name of the table in the database, that contain columns of extended types. 65 /// </summary> 66 public const string EXTENDED_TYPES_TABLE_NAME = "TYPES_EXTENDED"; 67 /// <summary> 68 /// Name of the table in the database, that contain columns of DB specific types. 69 /// </summary> 70 public const string SPECIFIC_TYPES_TABLE_NAME = "TYPES_SPECIFIC"; 71 #endregion 72 73 public static string ConnectionString { 74 get { 75 string connection_string = Environment.GetEnvironmentVariable ("MONO_TESTS_ORACLE_CONNECTION_STRING"); 76 if(connection_string == null) 77 NUnit.Framework.Assert.Ignore ("Please consult README.tests."); 78 return connection_string; 79 } 80 } 81 82 // SQLClient does not allow to use the Provider token 83 // since Provider is always the first parameter(in GHT framework), 84 // we trim it. 85 public static string ConnectionStringSQLClient { 86 get { 87 return ConnectionString.Substring(ConnectionString.IndexOf(";")); 88 } 89 } 90 91 92 /// <summary> 93 /// Resolves the type of DB server specified by the "ADOConString.txt" file. 94 /// </summary> 95 /// <returns>The type of DB server specified by the "ADOConString.txt" file.</returns> GetDbType()96 public static DataBaseServer GetDbType() { 97 return ConnectedDataProvider.GetDbType(ConnectedDataProvider.ConnectionString); 98 } 99 100 /// <summary> 101 /// Resolves the type of DB server that the specified connection refers. 102 /// </summary> 103 /// <param name="OleCon">A valid connection object to a DataBase.</param> 104 /// <returns>The type of DB server that the specified connection refers to.</returns> GetDbType(Sys.Data.OracleClient.OracleConnection OleCon)105 public static DataBaseServer GetDbType(Sys.Data.OracleClient.OracleConnection OleCon) { 106 return ConnectedDataProvider.GetDbType(OleCon.ConnectionString); 107 } 108 109 /// <summary> 110 /// Resolves the type of DB server that the specified connection string refers. 111 /// </summary> 112 /// <param name="ConnectionString">A valid connection string to a DataBase server.</param> 113 /// <returns>The type of DB server that the specified connection string refers to.</returns> GetDbType(string ConnectionString)114 public static DataBaseServer GetDbType(string ConnectionString) { 115 return DataBaseServer.Oracle; 116 } 117 118 /// <summary> 119 /// Creates a DbTypeParametersCollection with default types and data for the TYPES_SIMPLE table. 120 /// </summary> 121 /// <returns>The initialized DbTypeParametersCollection</returns> GetSimpleDbTypesParameters()122 public static DbTypeParametersCollection GetSimpleDbTypesParameters() { 123 DbTypeParametersCollection row = new DbTypeParametersCollection(SIMPLE_TYPES_TABLE_NAME); 124 switch (ConnectedDataProvider.GetDbType(ConnectedDataProvider.ConnectionString)) { 125 #region SQLServer 126 case MonoTests.System.Data.Utils.DataBaseServer.SQLServer: 127 row.Add("bit", true, 1); 128 row.Add("tinyint", (byte)25, 1); 129 row.Add("smallint", (Int16)77, 2); 130 row.Add("int", (Int32)2525, 4); 131 row.Add("bigint", (Int64)25251414, 8); 132 row.Add("decimal", 10M, 9); //(Decimal)10 133 row.Add("numeric", 123123M, 9); //(Decimal)123123 134 row.Add("float", 17.1414257, 8); 135 row.Add("real", (float)0.71425, 4); 136 row.Add("char", "abcdefghij", 10); 137 row.Add("nchar", "klmnopqrst", 10); 138 row.Add("varchar", "qwertasdfg", 50); 139 row.Add("nvarchar", "qwertasdfg", 50); 140 break; 141 #endregion 142 143 #region Sybase 144 case MonoTests.System.Data.Utils.DataBaseServer.Sybase: 145 //row.Add("BIT", true, 1); 146 row.Add("TINYINT", (byte)25, 1); 147 row.Add("SMALLINT", (Int16)77, 2); 148 row.Add("INT", (Int32)2525, 4); 149 //row.Add("BIGINT", (Int64)25251414, 8); 150 row.Add("DECIMAL", 10M, 9); //(Decimal)10 151 row.Add("NUMERIC", 123123M, 9); //(Decimal)123123 152 row.Add("FLOAT", 17.1414257, 8); 153 row.Add("REAL", (float)0.71425, 4); 154 row.Add("CHAR", "abcdefghij", 10); 155 row.Add("NCHAR", "klmnopqrst", 10); 156 row.Add("VARCHAR", "qwertasdfg", 50); 157 row.Add("NVARCHAR", "qwertasdfg", 50); 158 break; 159 #endregion 160 161 #region ORACLE 162 case MonoTests.System.Data.Utils.DataBaseServer.Oracle: 163 row.Add("NUMBER", 21M, 22); //(Decimal)21 164 row.Add("LONG", SAMPLE_STRING, 2147483647); //Default data type in .NET is system.String. 165 row.Add("FLOAT", 1.234, 22); 166 row.Add("VARCHAR", "qwertasdfg", 10); 167 row.Add("NVARCHAR", "qwertasdfg", 20); 168 row.Add("CHAR", "abcdefghij", 10); 169 row.Add("NCHAR", "abcdefghij", 10); 170 break; 171 #endregion 172 173 #region DB2 174 case MonoTests.System.Data.Utils.DataBaseServer.DB2: 175 row.Add("SMALLINT", (Int16)2, 2); 176 row.Add("INTEGER", 7777, 4); 177 row.Add("BIGINT", (Int64)21767267, 8); 178 row.Add("DECIMAL", 123M, 9); //(decimal)123 179 row.Add("REAL", (float)0.7, 4); 180 row.Add("DOUBLE", 1.7, 8); 181 row.Add("CHARACTER", "abcdefghij", 10); 182 row.Add("VARCHAR", "qwertasdfg", 10); 183 row.Add("LONGVARCHAR", SAMPLE_STRING, 32000); 184 break; 185 #endregion 186 187 #region PostgreSQL 188 case MonoTests.System.Data.Utils.DataBaseServer.PostgreSQL: 189 190 // PostgreSQL ODBC Type BOOL returns String with value "1" 191 // so we don't run it on .NET 192 // if (!GHTEnvironment.IsJavaRunTime()) 193 // { 194 // row.Add("BOOL", "1", 1); 195 // } 196 // else 197 // { 198 row.Add("BOOL", (bool)true, 1); 199 // } 200 201 row.Add("INT2", (Int16)21, 2); 202 row.Add("INT4", (Int32)30000, 4); 203 row.Add("INT8", (Int64)30001, 8); 204 row.Add("NUMERIC", (decimal)100000M, 10); //(decimal)100000 205 row.Add("FLOAT4", (Single)7.23157, 4); 206 row.Add("FLOAT8", (Double)7.123456, 8); 207 row.Add("VARCHAR", "qwertasdfg", 10); 208 row.Add("CHAR", "abcdefghij", 10); 209 row.Add("NCHAR", "klmnopqrst", 10); 210 break; 211 #endregion 212 } 213 return row; 214 } 215 /// <summary> 216 /// Creates a DbTypeParametersCollection with default types and data for the TYPES_EXTENDED table. 217 /// </summary> 218 /// <returns>The initialized DbTypeParametersCollection</returns> GetExtendedDbTypesParameters()219 public static DbTypeParametersCollection GetExtendedDbTypesParameters() { 220 DbTypeParametersCollection row = new DbTypeParametersCollection(EXTENDED_TYPES_TABLE_NAME); 221 switch (ConnectedDataProvider.GetDbType(ConnectedDataProvider.ConnectionString)) { 222 #region SQLServer 223 case MonoTests.System.Data.Utils.DataBaseServer.SQLServer: 224 row.Add("text", SAMPLE_STRING, 16); 225 row.Add("ntext", SAMPLE_STRING, 16); 226 row.Add("binary", new byte[] {0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 227 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 228 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 229 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 230 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0}, 50); 231 row.Add("varbinary", new byte[] {0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 232 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 233 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 234 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 235 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0}, 50); 236 row.Add("datetime", new DateTime(2004, 8, 9, 20, 30, 15, 500), 8); 237 row.Add("smalldatetime", new DateTime(2004, 8, 9, 20, 30, 00), 4); 238 break; 239 #endregion 240 241 #region Sybase 242 case MonoTests.System.Data.Utils.DataBaseServer.Sybase: 243 row.Add("TEXT", SAMPLE_STRING, 16); 244 //There is probably a bug in the jdbc driver , we've tried to insert this string using 245 //sybase command tool and it gave the same result (3850) 246 row.Add("NTEXT", SAMPLE_STRING.Trim() , 16); 247 row.Add("BINARY", new byte[] {0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 248 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 249 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 250 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 251 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0}, 50); 252 row.Add("VARBINARY", new byte[] {0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 253 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 254 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 255 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 256 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0}, 50); 257 row.Add("DATETIME", new DateTime(2004, 8, 9, 20, 30, 15, 500), 8); 258 row.Add("SMALLDATETIME", new DateTime(2004, 8, 9, 20, 30, 00), 4); 259 break; 260 #endregion 261 262 #region ORACLE 263 case MonoTests.System.Data.Utils.DataBaseServer.Oracle: 264 row.Add("RAW", new byte[] {0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0}, 10); 265 row.Add("LONGRAW", new byte[] {0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 266 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 267 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 268 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 269 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 270 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 271 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 272 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 273 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 274 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 275 }, 100); 276 row.Add("DATE", new DateTime(2004, 8, 9, 20, 30, 15), 7); 277 278 // The .NET Framework provides support for Oracle LOBs in the OracleClient namespace, but not in the Oracle namespace. 279 // Since Visual MainWin does not support the OracleClient namespace, a partial support for this important feature is provided in the Oracle namespace. 280 // See ms-help://MS.VSCC.2003/VMW.GH.1033/ghdoc/vmwdoc_ADONET_data_access_limitations_51.htm 281 break; 282 #endregion 283 284 #region DB2 285 case MonoTests.System.Data.Utils.DataBaseServer.DB2: 286 row.Add("DATE", new DateTime(2004, 8, 9, 20, 30, 15, 500).Date); 287 row.Add("TIME", new TimeSpan(20, 30, 15)); 288 row.Add("TIMESTAMP", new DateTime(2004, 8, 9, 20, 30, 15, 500)); 289 row.Add("BLOB", new byte[] {0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 290 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 291 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 292 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 293 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 294 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 295 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 296 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 297 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 298 ,0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0 299 }); 300 row.Add("CLOB", SAMPLE_STRING 301 + SAMPLE_STRING 302 + SAMPLE_STRING 303 + SAMPLE_STRING 304 + SAMPLE_STRING 305 + SAMPLE_STRING 306 ); 307 row.Add("DBCLOB", SAMPLE_STRING 308 + SAMPLE_STRING 309 + SAMPLE_STRING 310 + SAMPLE_STRING 311 + SAMPLE_STRING 312 + SAMPLE_STRING 313 ); 314 break; 315 #endregion 316 317 #region PostgreSQL 318 case MonoTests.System.Data.Utils.DataBaseServer.PostgreSQL: 319 row.Add("BYTEA", new byte[] {0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 320 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 321 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 322 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0, 323 0x00, 0x12, 0x34, 0x56, 0x78, 0x9A, 0xBC, 0xDE, 0xFF, 0xF0}, 50); 324 row.Add("DATE", new DateTime(2004, 8, 9)); 325 row.Add("TEXT", "abcdefg", 16); 326 row.Add("TIME", new Sys.TimeSpan(02,02,02)); 327 row.Add("TIMESTAMP", new DateTime(2004, 8, 9, 20, 30, 15, 500), 8); 328 break; 329 #endregion 330 331 } 332 return row; 333 } 334 } 335 }