NHibernateDaoTest.cs :  » Persistence-Frameworks » iBATIS.NET » IBatisNet » DataAccess » Test » NUnit » DaoTests » C# / CSharp Open Source

// DataSource definition
  // ScriptRunner definition
using System;
using System.Configuration;
using System.IO;
using IBatisNet.Common;
using IBatisNet.Common.Utilities;
using IBatisNet.DataAccess.Configuration;
using IBatisNet.DataAccess.Test.Dao.Interfaces;
using IBatisNet.DataAccess.Test.Domain;
using NUnit.Framework;

namespace IBatisNet.DataAccess.Test.NUnit.DaoTests{
  /// <summary>
  /// Summary description for NHibernateDaoTest.
  /// </summary>
  [TestFixture]
  public class NHibernateDaoTest
  {
    /// <summary>
    /// A daoManager
    /// </summary>
    private static DaoManager _daoManager = null;

    /// <summary>
    /// Initialisation
    /// </summary>
    [SetUp]
    public void SetUp()
    {
      string scriptDirectory = Path.Combine(Path.Combine(Path.Combine(Path.Combine(Resources.ApplicationBase, ".."), ".."), "Scripts"), ConfigurationSettings.AppSettings["database"]) + Path.DirectorySeparatorChar;
//        Resources.RootDirectory + Path.DirectorySeparatorChar +
//        "Scripts" + Path.DirectorySeparatorChar +
//        ConfigurationSettings.AppSettings["database"]+ Path.DirectorySeparatorChar;

      DomDaoManagerBuilder builder = new DomDaoManagerBuilder();
      builder.Configure("dao" + "_" + ConfigurationSettings.AppSettings["database"] + "_" + ConfigurationSettings.AppSettings["providerType"] + ".config");

      _daoManager = DaoManager.GetInstance("NHibernateDao");

      InitScript(_daoManager.LocalDataSource, scriptDirectory + "user-init.sql");
    }

    /// <summary>
    /// Run a sql batch for the datasource.
    /// </summary>
    /// <param name="datasource">The datasource.</param>
    /// <param name="script">The sql batch</param>
    protected static void InitScript(DataSource datasource, string script)
    {
      ScriptRunner runner = new ScriptRunner();

      runner.RunScript(datasource, script);
    }

    /// <summary>
    /// Test Create user
    /// </summary>
    [Test]
    [Category("NHibernate")]
    public void TestCreateUser()
    {
      IUserDao userDao = (IUserDao) _daoManager[typeof (IUserDao)];

      User newUser = new User();
      newUser.Id = "joe_cool";
      newUser.UserName = "Joseph Cool";
      newUser.Password = "abc123";
      newUser.EmailAddress = "joe@cool.com";
      newUser.LastLogon = DateTime.Now;

      try
      {
        _daoManager.OpenConnection();
        userDao.Create(newUser);
      }
      catch (Exception e)
      {
        // Ignore
        Console.WriteLine("TestCreateUser, error cause : " + e.Message);
      }
      finally
      {
        _daoManager.CloseConnection();
      }

      DateTime stamp = DateTime.Now;
      User joeCool = null;
      try
      {
        // open another session to retrieve the just inserted user
        _daoManager.OpenConnection();

        //The User object you get back is live! 
        joeCool = userDao.Load("joe_cool");

        Assert.IsNotNull(joeCool);
        Assert.AreEqual("Joseph Cool", joeCool.UserName);

        //Change its properties and it will get persisted to the database on Close. 
        // set Joe Cool's Last Login property
        joeCool.LastLogon = stamp;
      }
      catch (Exception e)
      {
        // Ignore
        Console.WriteLine("TestCreateUser, error cause : " + e.Message);
      }
      finally
      {
        // flush the changes from the Session to the Database
        _daoManager.CloseConnection();
      }

      _daoManager.OpenConnection();
      //The User object you get back is live! 
      joeCool = userDao.Load("joe_cool");
      _daoManager.CloseConnection();

      Assert.IsNotNull(joeCool);
      Assert.AreEqual("Joseph Cool", joeCool.UserName);
      Assert.AreEqual(stamp.ToString(), joeCool.LastLogon.ToString());
    }

  }
}