pgsqlclient-checkins

[Carlos G. Á. <car...@us...>]

Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient.UnitTests/source
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12010

Modified Files:
	PgBaseTest.cs 
Log Message:
Updated base unit test

Index: PgBaseTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient.UnitTests/source/PgBaseTest.cs,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** PgBaseTest.cs	29 Sep 2004 12:14:52 -0000	1.12
--- PgBaseTest.cs	31 Jan 2005 14:08:48 -0000	1.13
***************
*** 221,228 ****
  			commandText = new StringBuilder();
  
! 			commandText.Append("CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler;");
! 			
! 			command = new PgCommand(commandText.ToString(), connection);
! 			command.ExecuteNonQuery();
  
  			// Create test function public.TestCount()
--- 221,234 ----
  			commandText = new StringBuilder();
  
! 			try
! 			{
! 				commandText.Append("CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler;");
! 
! 				command = new PgCommand(commandText.ToString(), connection);
! 				command.ExecuteNonQuery();
! 			}
! 			catch
! 			{
! 			}
  
  			// Create test function public.TestCount()
***************
*** 279,283 ****
  		private void insertTestData()
  		{
! 			string commandText = "insert into public.test_table values(@int4_field, @char_field, @varchar_field, @single_field, @double_field, @date_Field, @time_field, @timestamp_field, @blob_field)";
  
  			PgTransaction transaction = connection.BeginTransaction();
--- 285,289 ----
  		private void insertTestData()
  		{
! 			string commandText = "insert into public.test_table values(@int4_field, @char_field, @varchar_field, @single_field, @double_field, @date_Field, @time_field, @timestamp_field, @blob_field, @bool_field)";
  
  			PgTransaction transaction = connection.BeginTransaction();
***************
*** 296,299 ****
--- 302,306 ----
  				command.Parameters.Add("@timestamp_field", PgDbType.Timestamp);
  				command.Parameters.Add("@blob_field", PgDbType.Binary);
+ 				command.Parameters.Add("@bool_field", PgDbType.Boolean);
  
  				for (int i = 0; i < 100; i++)
***************
*** 308,311 ****
--- 315,319 ----
  					command.Parameters["@timestamp_field"].Value = DateTime.Now;
  					command.Parameters["@blob_field"].Value		= Encoding.Default.GetBytes("IRow " + i.ToString());
+ 					command.Parameters["@bool_field"].Value		= true;
  
  					command.ExecuteNonQuery();