mcs/class/System.Data/Test/System.Data.Common/DataContainerTest.cs

   1 //
   2 // DataContainerTest.cs - NUnit Test Cases for testing the
   3 //                          DataContainer class
   4 // Author:
   5 //      Umadevi S (sumadevi@novell.com)
   6 //
   7 // Copyright (c) 2004 Novell Inc., and the individuals listed
   8 // on the ChangeLog entries.
   9 //
  10 // Permission is hereby granted, free of charge, to any person obtaining
  11 // a copy of this software and associated documentation files (the
  12 // "Software"), to deal in the Software without restriction, including
  13 // without limitation the rights to use, copy, modify, merge, publish,
  14 // distribute, sublicense, and/or sell copies of the Software, and to
  15 // permit persons to whom the Software is furnished to do so, subject to
  16 // the following conditions:
  17 //
  18 // The above copyright notice and this permission notice shall be
  19 // included in all copies or substantial portions of the Software.
  20 //
  21 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  22 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  23 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  24 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  25 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  26 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  27 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  28 //
  29
  30 using System;
  31 using System.Data;
  32 using System.Data.Common;
  33 using System.Data.SqlClient;
  34
  35 using NUnit.Framework;
  36
  37 namespace MonoTests.System.Data.Common
  38 {
  39         [TestFixture]
  40         public class DataContainerTest : MSSqlTestClient
  41         {
  42                 [SetUp]
  43                 public void GetReady ()
  44                 {
  45                         OpenConnection ();
  46                         CreateTestSetup (); // create test database & tables
  47                 }
  48
  49                 [TearDown]
  50                 public void Clean ()
  51                 {
  52                         CleanTestSetup (); // clean test database
  53                         CloseConnection ();
  54                 }
  55
  56                 [Test]
  57                 public void DateTimeTest ()
  58                 {
  59                         try {
  60                                 SqlDataAdapter myadapter = new SqlDataAdapter ("select * from datetimetest;", conn);
  61
  62                                 DataTable dt = new DataTable ();
  63                                 myadapter.Fill (dt);
  64                                 Assert.AreEqual (3, dt.Rows.Count, "Row count must be three");
  65                         } finally {
  66                                 CleanTestSetup ();
  67                                 CloseConnection ();
  68                         }
  69                 }
  70
  71                 private void CreateTestSetup ()
  72                 {
  73                         if (!isConnAlive)
  74                                 return ;
  75                         // Create test database & tables
  76                         string createQuery = "DROP TABLE datetimetest;" ;
  77                         ExecuteQuery (createQuery);
  78                         createQuery = "CREATE TABLE datetimetest (" +
  79                                         "col_char CHAR(20)," +
  80                                         "col_date DATETIME );";
  81                         ExecuteQuery (createQuery);
  82                         createQuery = "INSERT INTO datetimetest VALUES ('one', '4/12/2004 4:59:00');" ;
  83                         ExecuteQuery (createQuery);
  84                         createQuery = "INSERT INTO datetimetest VALUES ('two',null);" ;
  85                         ExecuteQuery (createQuery);
  86                         createQuery = "INSERT INTO datetimetest (col_char) VALUES ('three');" ;
  87                         ExecuteQuery (createQuery);
  88                 }
  89
  90                 private void CleanTestSetup ()
  91                 {
  92                         if (!isConnAlive)
  93                                 return;
  94                         // delete test database
  95                         string dropQuery = "DROP table datetimetest";
  96                         ExecuteQuery(dropQuery);
  97                 }
  98         }
  99 }