[Adapdev-commits] Adapdev/src/Adapdev.Data.Tests CommandTextViewerTest.cs,NONE,1.1 ConnectionStringBuilderTest.cs,NONE,1.1 SelectQueryTest.cs,NONE,1.1

[Sean M. <int...@us...>]

Update of /cvsroot/adapdev/Adapdev/src/Adapdev.Data.Tests
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8050/src/Adapdev.Data.Tests

Added Files:
	CommandTextViewerTest.cs ConnectionStringBuilderTest.cs 
	SelectQueryTest.cs 
Log Message:


--- NEW FILE: SelectQueryTest.cs ---
using System;
using System.Collections;
using NUnit.Framework;
using Adapdev.Data.Sql;

namespace Adapdev.Data.Tests
{
	/// <summary>
	/// Summary description for SelectQueryTest.
	/// </summary>
	/// 
	[TestFixture]
	public class SelectQueryTest
	{
		private DbType _dbType = DbType.ACCESS;
		private Hashtable q = new Hashtable();

		public SelectQueryTest()
		{
			q.Add("SQLSERVER_SelectAll", "");
		}

		private string SelectAll()
		{
			ISelectQuery query = QueryFactory.CreateSelectQuery(this._dbType);
			query.SetTable("sometable");
			query.AddAll();
			return query.Statement;
		}

		private string SelectColumns()
		{
			ISelectQuery query = QueryFactory.CreateSelectQuery(this._dbType);
			query.SetTable("sometable");
			query.Add("column1");
			query.Add("column2");
			return query.Statement;
		}

		private string SelectColumnsWithTable()
		{
			ISelectQuery query = QueryFactory.CreateSelectQuery(this._dbType);
			query.SetTable("sometable");
			query.Add("table2", "column2");
			query.Add("column2");
			return query.Statement;
		}

		private string SelectColumnsWithTableAndAlias()
		{
			ISelectQuery query = QueryFactory.CreateSelectQuery(this._dbType);
			query.SetTable("sometable");
			query.Add("column1");
			query.AddColumnAlias("table2", "column2", "alias2");
			query.AddColumnAlias("column3", "alias3");

			return query.Statement;
		}

		private string SelectColumnCount()
		{
			ISelectQuery query = QueryFactory.CreateSelectQuery(this._dbType);
			query.SetTable("sometable");
			query.AddCount("column");

			return query.Statement;
		}

		private string SelectCountAll()
		{
			ISelectQuery query = QueryFactory.CreateSelectQuery(this._dbType);
			query.SetTable("sometable");
			query.AddCountAll();

			return query.Statement;
		}

		private string SelectGroupBy()
		{
			ISelectQuery query = QueryFactory.CreateSelectQuery(this._dbType);
			query.SetTable("sometable");
			query.AddAll();
			query.AddGroupBy("column1");

			return query.Statement;
		}


		[Test]
		public void SqlServer()
		{
			this._dbType = DbType.SQLSERVER;

			Assert.AreEqual("SELECT  *  FROM [sometable]", this.SelectAll(), "SelectAll failed");
			Assert.AreEqual("SELECT  [column1], [column2] FROM [sometable]", this.SelectColumns(), "SelectColumns failed");
			Assert.AreEqual("SELECT  [table2].[column2], [column2] FROM [sometable]", this.SelectColumnsWithTable(), "SelectColumnsWithTable failed");
			Assert.AreEqual("SELECT  [column1], [table2].[column2] AS alias2, [column3] AS alias3 FROM [sometable]", this.SelectColumnsWithTableAndAlias(), "SelectColumnsWithTableAndAlias failed");
			Assert.AreEqual("SELECT  COUNT([column])  FROM [sometable]", this.SelectColumnCount(), "SelectColumnCount failed");
			Assert.AreEqual("SELECT  COUNT(*)  FROM [sometable]", this.SelectCountAll(), "SelectCountAll failed");
			Assert.AreEqual("SELECT  *  FROM [sometable] GROUP BY [column1]", this.SelectGroupBy(), "SelectGroupBy failed");
			Console.WriteLine(this.SelectGroupBy());
		}
	}
}

--- NEW FILE: CommandTextViewerTest.cs ---
using System;
using System.Data;
using System.Data.OleDb;
using System.Data.OracleClient;
using System.Data.SqlClient;
using Adapdev.Data;
using NUnit.Framework;

namespace Adapdev.Data.Tests
{
	/// <summary>
	/// Summary description for CommandTextViewerTest.
	/// </summary>
	/// 
	[TestFixture]
	public class CommandTextViewerTest
	{
		private string oledbCommand = "INSERT INTO Test (cInt, cString, cDate, cBool) VALUES (?, ?, ?, ?);";
		private string sqlCommand = "INSERT INTO Test (cInt, cString, cDate, cBool) VALUES (@cInt, @cString, @cDate, @cBool);";
		private DateTime time = DateTime.Now;

		[Test]
		public void ParseOleDbCommand()
		{
			OleDbCommand command = new OleDbCommand();
			command.CommandText = this.oledbCommand;

			OleDbParameter cInt = command.Parameters.Add("@cInt", OleDbType.Integer, 1);
			cInt.Value = 1;

			OleDbParameter cString = command.Parameters.Add("@cString", OleDbType.VarChar, 20);
			cString.Value = "test";

			OleDbParameter cDate = command.Parameters.Add("@cDate", OleDbType.DBTimeStamp, 20);
			cDate.Value = new DateTime(2006,2,25,6,18,57);

			OleDbParameter cBool = command.Parameters.Add("@cBool", OleDbType.Boolean, 20);
			cBool.Value = false;



			string cmd = CommandTextViewer.ParseOleDbCommand(command);
			ValidateResult(cmd);
		}

		[Test]
		public void ParseSqlCommand()
		{
			SqlCommand command = new SqlCommand();
			command.CommandText = this.sqlCommand;

			SqlParameter cInt = command.Parameters.Add("@cInt", SqlDbType.Int, 1);
			cInt.Value = 1;

			SqlParameter cString = command.Parameters.Add("@cString", SqlDbType.VarChar, 20);
			cString.Value = "test";

			SqlParameter cDate = command.Parameters.Add("@cDate", SqlDbType.DateTime, 20);
			cDate.Value = new DateTime(2006,2,25,6,18,57);

			SqlParameter cBool = command.Parameters.Add("@cBool", SqlDbType.Bit, 20);
			cBool.Value = false;



			string cmd = CommandTextViewer.ParseSqlCommand(command);
			ValidateResult(cmd);
		}

		[Test]
		public void ParseOracleCommand()
		{
			OracleCommand command = new OracleCommand();
			command.CommandText = this.sqlCommand;

			OracleParameter cInt = command.Parameters.Add("@cInt", OracleType.Int32, 1);
			cInt.Value = 1;

			OracleParameter cString = command.Parameters.Add("@cString", OracleType.VarChar, 20);
			cString.Value = "test";

			OracleParameter cDate = command.Parameters.Add("@cDate", OracleType.DateTime, 20);
			cDate.Value = new DateTime(2006,2,25,6,18,57);

			OracleParameter cBool = command.Parameters.Add("@cBool", OracleType.Byte, 20);
			cBool.Value = false;



			string cmd = CommandTextViewer.ParseOracleCommand(command);
			ValidateResult(cmd);
		}

		private void ValidateResult(string text)
		{
			Assert.AreEqual("INSERT INTO Test (cInt, cString, cDate, cBool) VALUES (1, 'test', '2/25/2006 6:18:57 AM', False);", text);
		}
	}
}

--- NEW FILE: ConnectionStringBuilderTest.cs ---
using System;
using NUnit.Framework;
using Adapdev.Data;

namespace Adapdev.Data.Tests
{
	/// <summary>
	/// Summary description for ConnectionStringBuilderTest.
	/// </summary>
	/// 
	[TestFixture]
	public class ConnectionStringBuilderTest
	{
		[Test]
		public void BuildDSN()
		{
			string conn = ConnectionStringBuilder.BuildDSN("db", "sa", "password");
			Console.WriteLine(conn);
		}
	}
}