[Nhibernate-commit] nhibernate/src/NHibernate.Test/DialectTest DialectFixture.cs,NONE,1.1 MsSqlDialectFixture.cs,NONE,1.1

[Michael D. <mik...@us...>]

Update of /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/DialectTest
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8053/DialectTest

Added Files:
	DialectFixture.cs MsSqlDialectFixture.cs 
Log Message:
Added TestFixture's for Dialect and MsSqlDialect to test for Quoting.  I need 
to get in the habit of writing these things first ;)

--- NEW FILE: DialectFixture.cs ---
using System;

using NHibernate.Dialect;
using NUnit.Framework;

namespace NHibernate.Test.DialectTest
{

	/// <summary>
	/// Summary description for DialectFixture.
	/// </summary>
	[TestFixture]
	public class DialectFixture 
	{
		protected Dialect.Dialect d = null;

		const int BeforeQuoteIndex = 0;
		const int AfterQuoteIndex = 1;
		const int AfterUnquoteIndex = 2;
		
		protected string[] tableWithNothingToBeQuoted;
		
		// simulating a string already enclosed in the Dialects quotes of Quote"d[Na$` 
		// being passed in that should be returned as Quote""d[Na$` - notice the "" before d
		protected string[] tableAlreadyQuoted;
		
		// simulating a string that has NOT been enclosed in the Dialects quotes and needs to 
		// be.
		protected string[] tableThatNeedsToBeQuoted;
		
		

		[SetUp]
		public virtual void SetUp() 
		{
			// Generic Dialect inherits all of the Quoting functions from
			// Dialect (which is abstract)
			d = new Dialect.GenericDialect();
			tableWithNothingToBeQuoted = new string[] {"plainname", "\"plainname\""};
			tableAlreadyQuoted = new string[] {"\"Quote\"\"d[Na$`\"", "\"Quote\"\"d[Na$`\"","Quote\"d[Na$`" };
			tableThatNeedsToBeQuoted = new string[] {"Quote\"d[Na$`", "\"Quote\"\"d[Na$`\"", "Quote\"d[Na$`"};
		}

		[Test]
		public void IsQuotedTrue() 
		{
			Assert.IsTrue( d.IsQuoted(tableAlreadyQuoted[BeforeQuoteIndex]) );
		}

		/// <summary>
		/// Test that only the first char identifies that the Identifier
		/// is Quoted - regardless of what chars are contained in it.
		/// </summary>
		[Test]
		public void IsQuotedFalse() 
		{
			Assert.IsFalse( d.IsQuoted(tableThatNeedsToBeQuoted[BeforeQuoteIndex]) );
		}

		[Test]
		public void QuoteTableNameNeeded() 
		{
			Assert.AreEqual( 
				tableThatNeedsToBeQuoted[AfterQuoteIndex], 
				d.QuoteForTableName(tableThatNeedsToBeQuoted[BeforeQuoteIndex]) );
		}

		[Test]
		public void QuoteTableNameNotNeeded() 
		{
			Assert.AreEqual( 
				tableWithNothingToBeQuoted[AfterQuoteIndex], 
				d.QuoteForTableName( tableWithNothingToBeQuoted[BeforeQuoteIndex] ) );
		}

		[Test]
		public void QuoteTableNameAlreadyQuoted() 
		{
			Assert.AreEqual( 
				tableAlreadyQuoted[BeforeQuoteIndex] ,
				d.QuoteForTableName( tableAlreadyQuoted[BeforeQuoteIndex] ) );
		}


		/// <summary>
		/// Test that it does not matter if the name passed in has been quoted or not
		/// already.  The UnQuote should take care of it and return the same result.
		/// </summary>
		[Test]
		public void UnQuoteAlreadyQuoted() 
		{
			Assert.AreEqual( 
				tableAlreadyQuoted[AfterUnquoteIndex] ,
				d.UnQuote( tableAlreadyQuoted[BeforeQuoteIndex] ) );
				
			Assert.AreEqual(
				tableAlreadyQuoted[AfterUnquoteIndex] ,
				d.UnQuote( tableAlreadyQuoted[AfterQuoteIndex] ) );
		}

		[Test]
		public void UnQuoteNeedingQuote() 
		{
			Assert.AreEqual( 
				tableThatNeedsToBeQuoted[AfterUnquoteIndex] ,
				d.UnQuote( tableThatNeedsToBeQuoted[BeforeQuoteIndex] ) );
				
			Assert.AreEqual(
				tableThatNeedsToBeQuoted[AfterUnquoteIndex] ,
				d.UnQuote( tableThatNeedsToBeQuoted[AfterQuoteIndex] ) );
		}

		[Test]
		public void UnQuoteArray()
		{
			string[] actualUnquoted = new string[2];
			string[] expectedUnquoted = new string[] {tableThatNeedsToBeQuoted[AfterUnquoteIndex], tableAlreadyQuoted[AfterUnquoteIndex] };

			actualUnquoted = d.UnQuote(new string[] {tableThatNeedsToBeQuoted[BeforeQuoteIndex], tableAlreadyQuoted[BeforeQuoteIndex] } );

			ObjectAssertion.AssertEquals(expectedUnquoted, actualUnquoted, true);

		}

	}
}

--- NEW FILE: MsSqlDialectFixture.cs ---
using System;

using NUnit.Framework;

namespace NHibernate.Test.DialectTest 
{

	/// <summary>
	/// Summary description for MsSqlDialectFixture.
	/// </summary>
	[TestFixture]
	public class MsSqlDialectFixture : DialectFixture
	{

		[SetUp]
		public override void SetUp() 
		{
			// Generic Dialect inherits all of the Quoting functions from
			// Dialect (which is abstract)
			d = new Dialect.MsSql2000Dialect();
			tableWithNothingToBeQuoted = new string[] {"plainname", "[plainname]"};
			tableAlreadyQuoted = new string[] {"[Quote[d[Na]]$`]", "[Quote[d[Na]]$`]","Quote[d[Na]$`" };
			tableThatNeedsToBeQuoted = new string[] {"Quote[d[Na]$`", "[Quote[d[Na]]$`]", "Quote[d[Na]$`"};

		}
	}
}