[Nhibernate-commit] nhibernate/src/NHibernate.Test/ExpressionTest SQLExpressionFixture.cs,NONE,1.1

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

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

Added Files:
	SQLExpressionFixture.cs 
Log Message:
Added test for SQLExpression and new method in SqlString

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

using NHibernate.SqlCommand;
using NExpression = NHibernate.Expression;

using NHibernate.DomainModel;

using NUnit.Framework;

namespace NHibernate.Test.ExpressionTest 
{
	/// <summary>
	/// Summary description for SQLExpressionFixture.
	/// </summary>
	[TestFixture]
	public class SQLExpressionFixture : BaseExpressionFixture
	{
		[Test]
		public void StraightSqlTest() 
		{
			ISession session = factory.OpenSession();
			
			NExpression.Expression sqlExpression = NExpression.Expression.Sql("$alias.address is not null");

			SqlString sqlString = sqlExpression.ToSqlString(factoryImpl, typeof(Simple), "simple_alias");

			string expectedSql = "simple_alias.address is not null";
			
			CompareSqlStrings(sqlString, expectedSql);

			session.Close();
		}

		[Test]
		public void NoParamsSqlStringTest() 
		{
			ISession session = factory.OpenSession();
			
			NExpression.Expression sqlExpression = NExpression.Expression.Sql( new SqlString( "$alias.address is not null") );

			SqlString sqlString = sqlExpression.ToSqlString(factoryImpl, typeof(Simple), "simple_alias");

			string expectedSql = "simple_alias.address is not null";
			
			CompareSqlStrings(sqlString, expectedSql);

			session.Close();
		}

		[Test]
		public void WithParameterTest() 
		{
			ISession session = factory.OpenSession();
			SqlStringBuilder builder = new SqlStringBuilder();
			
			string expectedSql = "simple_alias.address = :address";
			Parameter[] expectedParams = new Parameter[1];
			
			Parameter firstAndParam = new Parameter();
			firstAndParam.SqlType = new SqlTypes.StringSqlType();
			firstAndParam.Name = "address";
			expectedParams[0] = firstAndParam;

			builder.Add( "$alias.address = " );
			builder.Add( firstAndParam );

			NExpression.Expression sqlExpression = NExpression.Expression.Sql(builder.ToSqlString(), "some address", NHibernate.String );

			SqlString sqlString = sqlExpression.ToSqlString(factoryImpl, typeof(Simple), "simple_alias");

			CompareSqlStrings(sqlString, expectedSql, expectedParams);

			session.Close();
		}
	}
}