[Adapdev-commits] Adapdev/src/Adapdev.Data.Tests Adapdev.Data.Tests.csproj,1.17,1.18 SelectQueryTest.cs,1.1,1.2

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

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

Modified Files:
	Adapdev.Data.Tests.csproj SelectQueryTest.cs 
Log Message:


Index: SelectQueryTest.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data.Tests/SelectQueryTest.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** SelectQueryTest.cs	3 Mar 2006 05:29:55 -0000	1.1
--- SelectQueryTest.cs	15 Mar 2006 04:34:16 -0000	1.2
***************
*** 13,104 ****
  	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());
- 		}
  	}
  }
--- 13,16 ----

Index: Adapdev.Data.Tests.csproj
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data.Tests/Adapdev.Data.Tests.csproj,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** Adapdev.Data.Tests.csproj	3 Mar 2006 05:22:54 -0000	1.17
--- Adapdev.Data.Tests.csproj	15 Mar 2006 04:34:16 -0000	1.18
***************
*** 135,143 ****
                      BuildAction = "Compile"
                  />
-                 <File
-                     RelPath = "SelectQueryTest.cs"
-                     SubType = "Code"
-                     BuildAction = "Compile"
-                 />
                  <Folder RelPath = "bin\Debug\" />
                  <File
--- 135,138 ----
***************
*** 202,209 ****
--- 197,224 ----
                  />
                  <File
+                     RelPath = "Sql\DeleteQueryTest.cs"
+                     SubType = "Code"
+                     BuildAction = "Compile"
+                 />
+                 <File
+                     RelPath = "Sql\InsertQueryTest.cs"
+                     SubType = "Code"
+                     BuildAction = "Compile"
+                 />
+                 <File
                      RelPath = "Sql\SelectQueryTest.cs"
                      SubType = "Code"
                      BuildAction = "Compile"
                  />
+                 <File
+                     RelPath = "Sql\SqlServerCriteriaTest.cs"
+                     SubType = "Code"
+                     BuildAction = "Compile"
+                 />
+                 <File
+                     RelPath = "Sql\UpdateQueryTest.cs"
+                     SubType = "Code"
+                     BuildAction = "Compile"
+                 />
              </Include>
          </Files>