// Umadevi S (sumadevi@novell.com)
// Kornél Pál <http://www.kornelpal.hu/>
// Sureshkumar T (tsureshkumar@novell.com)
-// Senganal T (tsenganal@novell.com)
//
// Copyright (c) 2004 Novell Inc., and the individuals listed
// on the ChangeLog entries.
using System;
using System.Data;
-using System.Text;
-using System.Data.SqlTypes;
using System.Data.Common;
using System.Data.SqlClient;
[Category ("sqlserver")]
public class SqlDataReaderTest
{
- SqlConnection conn = null;
- SqlCommand cmd = null;
- SqlDataReader reader = null;
- String query = "Select type_{0},type_{1},convert({0},null) from numeric_family where id=1";
- DataSet sqlDataset = null;
-
- DataTable numericDataTable =null;
- DataTable stringDataTable =null;
- DataTable binaryDataTable =null;
- DataTable datetimeDataTable =null;
-
- DataRow numericRow = null;
- DataRow stringRow = null;
- DataRow binaryRow = null;
- DataRow datetimeRow = null;
+ SqlConnection conn;
[Test]
public void ReadEmptyNTextFieldTest () {
ConnectionManager.Singleton.CloseConnection ();
}
}
-
- [TestFixtureSetUp]
- public void init ()
- {
- conn = new SqlConnection (ConnectionManager.Singleton.ConnectionString);
- cmd = conn.CreateCommand ();
-
- sqlDataset = (new DataProvider()).GetDataSet ();
-
- numericDataTable = sqlDataset.Tables["numeric_family"];
- stringDataTable = sqlDataset.Tables["string_family"];
- binaryDataTable = sqlDataset.Tables["binary_family"];
- datetimeDataTable = sqlDataset.Tables["datetime_family"];
-
- numericRow = numericDataTable.Select ("id=1")[0];
- stringRow = stringDataTable.Select ("id=1")[0];
- binaryRow = binaryDataTable.Select ("id=1")[0];
- datetimeRow = datetimeDataTable.Select ("id=1")[0];
- }
-
- [SetUp]
- public void Setup ()
- {
- conn.Open ();
- }
- [TearDown]
- public void TearDown ()
- {
- if (reader != null)
- reader.Close ();
-
- conn.Close ();
- }
-
- // This method just helps in Calling common tests among all the Get* Methods
- // without replicating code
-
- void CallGetMethod (string s, int i)
- {
- switch (s) {
- case "Boolean" : reader.GetBoolean (i) ; break;
- case "SqlBoolean": reader.GetSqlBoolean (i); break;
- case "Int16" : reader.GetInt16 (i); break;
- case "SqlInt16" : reader.GetSqlInt16 (i); break;
- case "Int32" : reader.GetInt32 (i);break;
- case "SqlInt32" : reader.GetSqlInt32(i);break;
- case "Int64" : reader.GetInt64 (i);break;
- case "SqlInt64" : reader.GetSqlInt64(i); break;
- case "Decimal" : reader.GetDecimal(i);break;
- case "SqlDecimal" : reader.GetSqlDecimal (i);break;
- case "SqlMoney" : reader.GetSqlMoney (i);break;
- case "Float" : reader.GetFloat (i);break;
- case "SqlSingle" : reader.GetSqlSingle(i);break;
- case "Double" : reader.GetDouble (i);break;
- case "SqlDouble" : reader.GetSqlDouble(i);break;
- case "Guid" : reader.GetGuid(i);break;
- case "SqlGuid" : reader.GetSqlGuid(i);break;
- case "String" : reader.GetString(i);break;
- case "SqlString" : reader.GetSqlString(i);break;
- case "Char" : reader.GetChar(i);break;
- case "Byte" : reader.GetByte (i);break;
- case "SqlByte" : reader.GetSqlByte(i); break;
- case "DateTime" : reader.GetDateTime(i); break;
- case "SqlDateTime" : reader.GetSqlDateTime(i); break;
- case "SqlBinary" : reader.GetSqlBinary(i); break;
- default : Console.WriteLine ("OOOOPSSSSSS {0}",s);break;
- }
- }
-
- // This method just helps in Calling common tests among all the Get* Methods
- // without replicating code
- void GetMethodTests (string s)
- {
-
- try {
- CallGetMethod (s, 1);
- Assert.Fail ("#1[Get"+s+"] InvalidCastException must be thrown");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof(InvalidCastException), e.GetType(),
- "#2[Get"+s+"] Incorrect Exception : " + e);
- }
-
- // GetSql* Methods do not throw SqlNullValueException
- // So, Testimg only for Get* Methods
- if (!s.StartsWith("Sql")) {
- try {
- CallGetMethod (s, 2);
- Assert.Fail ("#3[Get"+s+"] Exception must be thrown");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e){
- Assert.AreEqual (typeof(SqlNullValueException),e.GetType(),
- "#4[Get"+s+"] Incorrect Exception : " + e);
- }
- }
-
- try {
- CallGetMethod (s, 3);
- Assert.Fail ("#5[Get"+s+"] IndexOutOfRangeException must be thrown");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e){
- Assert.AreEqual (typeof(IndexOutOfRangeException), e.GetType(),
- "#6[Get"+s+"] Incorrect Exception : " + e);
- }
- }
-
- [Test]
- public void GetBooleanTest ()
- {
- cmd.CommandText = string.Format (query, "bit", "int");
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests("Boolean");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_bit"], reader.GetBoolean(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlBoolean");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_bit"], reader.GetSqlBoolean(0).Value,
- "#4 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetByteTest ()
- {
- cmd.CommandText = string.Format (query, "tinyint", "int");
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests("Byte");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_tinyint"], reader.GetByte(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlByte");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_tinyint"], reader.GetSqlByte(0).Value,
- "#4 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetInt16Test ()
- {
- cmd.CommandText = string.Format (query, "smallint", "int");
- reader = cmd.ExecuteReader();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests("Int16");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_smallint"], reader.GetInt16(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlInt16");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_smallint"], reader.GetSqlInt16(0).Value,
- "#4 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetInt32Test ()
- {
- cmd.CommandText = string.Format (query, "int", "bigint");
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests("Int32");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_int"], reader.GetInt32(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlInt32");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_int"], reader.GetSqlInt32(0).Value,
- "#4 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetInt64Test ()
- {
- cmd.CommandText = string.Format (query, "bigint", "int");
- reader = cmd.ExecuteReader ();
- reader.Read ();
-
- // Test for standard exceptions
- GetMethodTests("Int64");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_bigint"], reader.GetInt64(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlInt64");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_bigint"], reader.GetSqlInt64(0).Value,
- "#4 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetDecimalTest ()
- {
- cmd.CommandText = string.Format (query, "decimal", "int");
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests("Decimal");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_decimal"], reader.GetDecimal(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlDecimal");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_decimal"], reader.GetSqlDecimal(0).Value,
- "#4 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetSqlMoneyTest ()
- {
- cmd.CommandText = string.Format (query, "money", "int");
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests("SqlMoney");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_money"], reader.GetSqlMoney(0).Value,
- "#2 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetFloatTest ()
- {
- cmd.CommandText = "select type_float,type_double,convert(real,null)";
- cmd.CommandText += "from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests("Float");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_float"], reader.GetFloat(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlSingle");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_float"], reader.GetSqlSingle(0).Value,
- "#2 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetDoubleTest ()
- {
- cmd.CommandText = "select type_double,type_float,convert(float,null)";
- cmd.CommandText += " from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests("Double");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_double"], reader.GetDouble(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlDouble");
-
- // Test if data is returned correctly
- Assert.AreEqual (numericRow["type_double"], reader.GetSqlDouble(0).Value,
- "#4 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetBytesTest ()
- {
- cmd.CommandText = "Select type_text,type_ntext,convert(text,null) ";
- cmd.CommandText += "from string_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
- try {
- reader.GetBytes (0,0,null,0,0);
- Assert.Fail ("#1 GetBytes shud be used only wth Sequential Access");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof(InvalidCastException), e.GetType (),
- "#2 Incorrect Exception : " + e);
- }
- reader.Close ();
-
- byte[] asciiArray = (new ASCIIEncoding ()).GetBytes ("text");
- byte[] unicodeArray = (new UnicodeEncoding ()).GetBytes ("ntext");
- byte[] buffer = null ;
- long size = 0;
-
- reader = cmd.ExecuteReader (CommandBehavior.SequentialAccess);
- reader.Read ();
- size = reader.GetBytes (0,0,null,0,0);
- Assert.AreEqual (asciiArray.Length, size, "#3 Data Incorrect");
-
- buffer = new byte[size];
- size = reader.GetBytes (0,0,buffer,0,(int)size);
- for (int i=0;i<size; i++)
- Assert.AreEqual (asciiArray[i], buffer[i], "#4 Data Incorrect");
-
- size = reader.GetBytes (1,0,null,0,0);
- Assert.AreEqual (unicodeArray.Length, size, "#5 Data Incorrect");
- buffer = new byte[size];
- size = reader.GetBytes (1,0,buffer,0,(int)size);
- for (int i=0;i<size; i++)
- Assert.AreEqual (unicodeArray[i], buffer[i], "#6 Data Incorrect");
-
- // Test if msdotnet behavior s followed when null value
- // is read using GetBytes
- Assert.AreEqual (0, reader.GetBytes (2,0,null,0,0), "#7");
- reader.GetBytes (2,0,buffer,0,10);
-
- reader.Close ();
- // do i need to test for image/binary values also ???
- }
-
- [Test]
- public void GetStringTest ()
- {
- cmd.CommandText = "Select type_varchar,10,convert(varchar,null)";
- cmd.CommandText += "from string_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests("String");
-
- // Test if data is returned correctly
- Assert.AreEqual (stringRow["type_varchar"], reader.GetString(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlString");
-
- // Test if data is returned correctly
- Assert.AreEqual (stringRow["type_varchar"], reader.GetSqlString(0).Value,
- "#4 DataValidation Failed");
- reader.Close();
- }
-
- [Test]
- public void GetSqlBinaryTest ()
- {
- cmd.CommandText = "Select type_binary ,10 ,convert(binary,null)";
- cmd.CommandText += "from binary_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests ("SqlBinary");
-
- // Test if data is returned correctly
- Assert.AreEqual (binaryRow["type_binary"], reader.GetSqlBinary(0).Value,
- "#2 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetGuidTest ()
- {
- cmd.CommandText = "Select type_guid,id,convert(uniqueidentifier,null)";
- cmd.CommandText += "from string_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
-
- // Test for standard exceptions
- GetMethodTests("Guid");
-
- // Test if data is returned correctly
- Assert.AreEqual (stringRow["type_guid"], reader.GetGuid(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlGuid");
-
- // Test if data is returned correctly
- Assert.AreEqual (stringRow["type_guid"], reader.GetSqlGuid(0).Value,
- "#4 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- public void GetDateTimeTest ()
- {
- cmd.CommandText = "Select type_datetime,10,convert(datetime,null)";
- cmd.CommandText += "from datetime_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
-
- // Test for standard exceptions
- GetMethodTests("DateTime");
-
- // Test if data is returned correctly
- Assert.AreEqual (datetimeRow["type_datetime"], reader.GetDateTime(0),
- "#2 DataValidation Failed");
-
- // Test for standard exceptions
- GetMethodTests("SqlDateTime");
-
- // Test if data is returned correctly
- Assert.AreEqual (datetimeRow["type_datetime"], reader.GetSqlDateTime(0).Value,
- "#2 DataValidation Failed");
- reader.Close ();
- }
-
- [Test]
- [Ignore ("Not Supported by msdotnet")]
- public void GetCharTest ()
- {
- cmd.CommandText = "Select type_char,type_guid,convert(char,null)";
- cmd.CommandText += "from string_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
- // Test for standard exceptions
- GetMethodTests ("Char");
- reader.Close ();
- }
-
- [Test]
- public void GetValueTest ()
- {
- cmd.CommandText = "Select id, null from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
-
- object obj = null;
- obj = reader.GetValue (0);
- Assert.AreEqual ((byte)1, obj, "#1 Shud return the value of id");
- obj = reader.GetValue (1);
- Assert.AreEqual (DBNull.Value, obj, "#2 shud return DBNull");
- reader.Close ();
- }
-
- [Test]
- public void GetSqlValueTest ()
- {
- cmd.CommandText = "Select id,null from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
-
- Assert.AreEqual ((byte)1, ((SqlByte)reader.GetSqlValue(0)).Value, "#1");
- //Assert.AreEqual (DBNull.Value, reader.GetSqlValue(1), "#2");
-
- reader.Close ();
- }
-
- [Test]
- public void GetValuesTest ()
- {
- cmd.CommandText = "Select 10,20,30 from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
- object[] arr = null;
- int count = 0;
-
- arr = new object[1];
- count = reader.GetValues (arr);
- Assert.AreEqual (10, (int)arr[0], "#1 Only first object shud be copied");
- Assert.AreEqual (1, count, "#1 return value shud equal objects copied");
-
- arr = new object[3];
- count = reader.GetValues (arr);
- Assert.AreEqual (3, count, "#2 return value shud equal objects copied");
-
- arr = new object[5];
- count = reader.GetValues (arr);
- Assert.AreEqual (3, count, "#3 return value shud equal objects copied");
- Assert.IsNull (arr[3], "#4 Only 3 objects shud be copied");
-
- reader.Close ();
- }
-
- [Test]
- public void GetSqlValuesTest ()
- {
- cmd.CommandText = "Select 10,20,30 from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
- object[] arr = null;
- int count = 0;
-
- arr = new object[1];
- count = reader.GetSqlValues (arr);
- // Something is wrong with types ... gotta figure it out
- //Assert.AreEqual (10, arr[0], "#1 Only first object shud be copied");
- Assert.AreEqual (1, count, "#1 return value shud equal objects copied");
-
- arr = new object[3];
- count = reader.GetSqlValues (arr);
- Assert.AreEqual (3, count, "#2 return value shud equal objects copied");
-
- arr = new object[5];
- count = reader.GetSqlValues (arr);
- Assert.AreEqual (3, count, "#3 return value shud equal objects copied");
- Assert.IsNull (arr[3], "#4 Only 3 objects shud be copied");
-
- reader.Close ();
- }
-
- [Test]
- public void isDBNullTest ()
- {
- cmd.CommandText = "select id , null from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
- reader.Read ();
-
- Assert.IsFalse (reader.IsDBNull (0), "#1");
- Assert.IsTrue (reader.IsDBNull (1) , "#2");
-
- try {
- reader.IsDBNull (10);
- Assert.Fail ("#1 Invalid Argument");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof(IndexOutOfRangeException), e.GetType(),
- "#1 Incorrect Exception : " + e);
- }
- }
-
- [Test]
- public void ReadTest ()
- {
- cmd.CommandText = "select id, type_bit from numeric_family where id=1" ;
- reader = cmd.ExecuteReader ();
- Assert.IsTrue (reader.Read () , "#1");
- Assert.IsFalse (reader.Read (), "#2");
- reader.Close ();
-
- try {
- reader.Read ();
- Assert.Fail ("#3 Exception shud be thrown : Reader is closed");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof(InvalidOperationException), e.GetType (),
- "#4 Incorrect Exception : " + e);
- }
- }
-
- [Test]
- public void NextResultTest ()
- {
- cmd.CommandText = "Select id from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
- Assert.IsFalse (reader.NextResult (), "#1");
- reader.Close ();
-
- cmd.CommandText = "select id from numeric_family where id=1;";
- cmd.CommandText += "select type_bit from numeric_family where id=2;";
- reader = cmd.ExecuteReader ();
- Assert.IsTrue (reader.NextResult (), "#2");
- Assert.IsFalse (reader.NextResult (), "#3");
- reader.Close ();
-
- try {
- reader.NextResult ();
- Assert.Fail ("#4 Exception shud be thrown : Reader is closed");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof(InvalidOperationException), e.GetType (),
- "#5 Incorrect Exception : " + e);
- }
- }
-
- [Test]
- public void GetNameTest ()
- {
- cmd.CommandText = "Select id,10 as gen,20 from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
-
- Assert.AreEqual ("id" , reader.GetName(0) , "#1");
- Assert.AreEqual ("gen" , reader.GetName(1) , "#2");
-
- try {
- reader.GetName (3);
- Assert.Fail ("#4 Exception shud be thrown");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof(IndexOutOfRangeException), e.GetType(),
- "#5 Incorrect Exception : " + e);
- }
- }
-
- [Test]
- public void GetOrdinalTest ()
- {
- //what is kana-width insensitive ?????
- cmd.CommandText = "Select id,10 as gen,20 from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
-
- Assert.AreEqual (0, reader.GetOrdinal ("id"), "#1");
- Assert.AreEqual (0, reader.GetOrdinal ("ID"), "#2");
- Assert.AreEqual (1, reader.GetOrdinal ("gen"), "#3");
- // Would expect column1,columnn2 etc for unnamed columns,
- // but msdotnet return empty string for unnamed columns
- Assert.AreEqual (2, reader.GetOrdinal (""), "#4");
-
- try {
- reader.GetOrdinal ("invalidname");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof (IndexOutOfRangeException),
- e.GetType(), "#4 Incorrect Exception : " + e);
- }
- }
-
- [Test]
- public void GetSchemaTableTest ()
- {
- cmd.CommandText = "Select type_decimal as decimal,id,10 ";
- cmd.CommandText += "from numeric_family where id=1";
- reader = cmd.ExecuteReader (CommandBehavior.KeyInfo);
- DataTable schemaTable = reader.GetSchemaTable ();
- DataRow row0 = schemaTable.Rows[0];
- DataRow row1 = schemaTable.Rows[1];
-
- Assert.AreEqual ("decimal", row0["ColumnName"], "#1");
- Assert.AreEqual ("", schemaTable.Rows[2]["ColumnName"], "#2");
-
- Assert.AreEqual (0, row0["ColumnOrdinal"], "#2");
- Assert.AreEqual (17, row0["ColumnSize"], "#3");
- Assert.AreEqual (38, row0["NumericPrecision"], "#4");
- Assert.AreEqual (0, row0["NumericScale"], "#5");
-
- Assert.AreEqual (false, row0["IsUnique"], "#6");
- // msdotnet returns IsUnique as false for Primary key
- // even though table consists of a single Primary Key
- //Assert.AreEqual (true, row1["IsUnique"], "#7");
- Assert.AreEqual (false, row0["IsKey"], "#8");
- Assert.AreEqual (true, row1["IsKey"], "#9");
-
- //Assert.AreEqual ("servername", row0["BaseServerName"], "#10");
- //Assert.AreEqual ("monotest", row0["BaseCatalogName"], "#11");
- Assert.AreEqual ("type_decimal", row0["BaseColumnName"], "#12");
- //Assert.IsNull(row0["BaseSchemaName"], "#13");
- Assert.AreEqual ("numeric_family", row0["BaseTableName"], "#14");
- Assert.AreEqual (typeof (Decimal), row0["DataType"], "#15");
- Assert.AreEqual (true, row0["AllowDBNull"], "#16");
- Assert.AreEqual (false, row1["AllowDBNull"], "#17");
- //Assert.IsNull(row0["ProviderType"], "#18");
- Assert.AreEqual (true, row0["IsAliased"], "#19");
- Assert.AreEqual (false, row1["IsAliased"], "#20");
-
- Assert.AreEqual (false, row0["IsExpression"], "#21");
- Assert.AreEqual (false, row0["IsIdentity"], "#22");
- Assert.AreEqual (false, row0["IsAutoIncrement"], "#23");
- Assert.AreEqual (false, row0["IsRowVersion"], "#24");
- Assert.AreEqual (false, row0["IsHidden"], "#25");
- Assert.AreEqual (false, row0["IsLong"], "#26");
- Assert.AreEqual (false, row0["IsReadOnly"], "#27");
- Assert.AreEqual (true, schemaTable.Rows[2]["IsReadOnly"], "#27");
-
- // Test Exception is thrown when reader is closed
- reader.Close ();
- try {
- reader.GetSchemaTable ();
- Assert.Fail ("#28 Exception shud be thrown" );
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof(InvalidOperationException), e.GetType(),
- "#29 Incorrect Exception");
- }
- }
-
- [Test]
- public void GetDataTypeNameTest ()
- {
- cmd.CommandText = "Select id,10,null from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
-
- Assert.AreEqual ("tinyint", reader.GetDataTypeName(0), "#1");
- Assert.AreEqual ("int", reader.GetDataTypeName(1), "#2");
- //need check on windows
- Assert.AreEqual ("int", reader.GetDataTypeName(2), "#3");
- try {
- reader.GetDataTypeName (10);
- Assert.Fail ("#4 Exception shud be thrown");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof(IndexOutOfRangeException), e.GetType(),
- "#5 Incorrect Exception : " + e);
- }
- }
-
- [Test]
- public void GetFieldType ()
- {
- cmd.CommandText = "Select id ,10 , null from numeric_family where id=1";
- reader = cmd.ExecuteReader ();
-
- Assert.AreEqual ("tinyint", reader.GetDataTypeName(0), "#1");
- Assert.AreEqual ("int", reader.GetDataTypeName(1) , "#2");
- Assert.AreEqual ("int", reader.GetDataTypeName(2), "#3");
- try {
- reader.GetDataTypeName (10);
- Assert.Fail ("#4 Exception shud be thrown");
- }catch (AssertionException e) {
- throw e;
- }catch (Exception e) {
- Assert.AreEqual (typeof(IndexOutOfRangeException), e.GetType(),
- "#5 Incorrect Exception : " + e);
- }
- }
-
- // Need to populate the data from a config file
- // Will be replaced later
- void validateData(string sqlQuery, DataTable table)
- {
- string fmt = "#TAB[{0}] ROW[{1}] COL[{2}] Data Mismatch";
-
- int noOfColumns = table.Columns.Count ;
- int i=0;
-
- cmd.CommandText = sqlQuery ;
- reader = cmd.ExecuteReader ();
-
- while (reader.Read ()){
- for (int j=1; j< noOfColumns ; ++j)
- Assert.AreEqual (table.Rows[i][j], reader[j],
- String.Format (fmt, table.TableName, i+1, j));
-
- i++;
- }
- reader.Close ();
- }
-
- [Test]
- public void NumericDataValidation ()
- {
- validateData ("select * from numeric_family order by id ASC",
- numericDataTable);
- }
-
- [Test]
- public void StringDataValidation ()
- {
- validateData ("select * from string_family order by id ASC",
- stringDataTable);
- }
-
- [Test]
- public void BinaryDataValidation ()
- {
- validateData ("select * from binary_family order by id ASC",
- binaryDataTable);
- }
-
- [Test]
- public void DatetimeDataValidation ()
- {
- validateData ("select * from datetime_family order by id ASC",
- datetimeDataTable);
- }
-
}
}