pgsqlclient-checkins Mailing List for PostgreSqlClient (Page 5)
Status: Inactive
Brought to you by:
carlosga_fb
Menu
▾
▴
pgsqlclient-checkins — Mailing list for CVS commit messages.
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(120) |
Aug
(95) |
Sep
(95) |
Oct
(213) |
Nov
(114) |
Dec
(64) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(6) |
Feb
(134) |
Mar
(88) |
Apr
(28) |
May
(22) |
Jun
(15) |
Jul
(23) |
Aug
(2) |
Sep
(15) |
Oct
(2) |
Nov
(6) |
Dec
|
| 2005 |
Jan
(8) |
Feb
(6) |
Mar
|
Apr
(42) |
May
(3) |
Jun
|
Jul
|
Aug
|
Sep
(84) |
Oct
|
Nov
|
Dec
|
| 2006 |
Jan
|
Feb
|
Mar
(84) |
Apr
(46) |
May
(40) |
Jun
(8) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: <car...@us...> - 2006-03-29 13:16:48
|
Revision: 77 Author: carlosga_fb Date: 2006-03-29 05:16:39 -0800 (Wed, 29 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=77&view=rev Log Message: ----------- Created folder remotely Added Paths: ----------- tags/ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-29 13:16:14
|
Revision: 76 Author: carlosga_fb Date: 2006-03-29 05:16:00 -0800 (Wed, 29 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=76&view=rev Log Message: ----------- Created folder remotely Added Paths: ----------- branches/ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-29 11:11:12
|
Revision: 75 Author: carlosga_fb Date: 2006-03-29 03:10:57 -0800 (Wed, 29 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=75&view=rev Log Message: ----------- ?\194?\183 Removed obsolote calls Modified Paths: -------------- trunk/pgsqlclient/source/UnitTests/PgArrayTest.cs trunk/pgsqlclient/source/UnitTests/PgCommandTest.cs trunk/pgsqlclient/source/UnitTests/PgDataAdapterTest.cs trunk/pgsqlclient/source/UnitTests/PgGeometicTypesTest.cs Modified: trunk/pgsqlclient/source/UnitTests/PgArrayTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgArrayTest.cs 2006-03-29 11:02:41 UTC (rev 74) +++ trunk/pgsqlclient/source/UnitTests/PgArrayTest.cs 2006-03-29 11:10:57 UTC (rev 75) @@ -59,7 +59,7 @@ int updated = command.ExecuteNonQuery(); - Assertion.AssertEquals("Invalid number of inserted rows", updated, 1); + Assert.AreEqual(1, updated, "Invalid number of inserted rows"); Console.WriteLine("Checking inserted values"); Modified: trunk/pgsqlclient/source/UnitTests/PgCommandTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgCommandTest.cs 2006-03-29 11:02:41 UTC (rev 74) +++ trunk/pgsqlclient/source/UnitTests/PgCommandTest.cs 2006-03-29 11:10:57 UTC (rev 75) @@ -177,15 +177,15 @@ Console.WriteLine("\r\nRecords Affected by SELECT command: {0}", recordsAffected); selectCommand.Dispose(); - Assertion.Assert(recordsAffected == -1); + Assert.IsTrue(recordsAffected == -1); // Execute a DELETE command PgCommand deleteCommand = new PgCommand("DELETE FROM public.test_table WHERE int4_field = 45", Connection); recordsAffected = deleteCommand.ExecuteNonQuery(); Console.WriteLine("\r\nRecords Affected by DELETE command: {0}", recordsAffected); deleteCommand.Dispose(); - - Assertion.Assert(recordsAffected == 1); + + Assert.IsTrue(recordsAffected == 1); } [Test] Modified: trunk/pgsqlclient/source/UnitTests/PgDataAdapterTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgDataAdapterTest.cs 2006-03-29 11:02:41 UTC (rev 74) +++ trunk/pgsqlclient/source/UnitTests/PgDataAdapterTest.cs 2006-03-29 11:10:57 UTC (rev 75) @@ -200,7 +200,7 @@ short val = (short)command.ExecuteScalar(); - Assertion.AssertEquals("int2_field has not correct value", System.Int16.MaxValue, val); + Assert.AreEqual(System.Int16.MaxValue, val, "int2_field has not correct value"); } [Test] @@ -231,7 +231,7 @@ long val = (long)command.ExecuteScalar(); - Assertion.AssertEquals("int8_field has not correct value", System.Int32.MaxValue, val); + Assert.AreEqual(System.Int32.MaxValue, val, "int8_field has not correct value"); } [Test] @@ -262,7 +262,7 @@ double val = (double)command.ExecuteScalar(); - Assertion.AssertEquals("double_field has not correct value", System.Int32.MaxValue, val); + Assert.AreEqual(System.Int32.MaxValue, val, "double_field has not correct value"); } [Test] @@ -293,7 +293,7 @@ float val = (float)command.ExecuteScalar(); - Assertion.AssertEquals("money_field has not correct value", 200.20, val); + Assert.AreEqual(200.20, val, "money_field has not correct value"); } [Test] @@ -326,7 +326,7 @@ if (val != (decimal)System.Int16.MaxValue) { - Assertion.Fail("numeric_field has not correct value"); + Assert.Fail("numeric_field has not correct value"); } } @@ -360,9 +360,9 @@ DateTime val = (DateTime)command.ExecuteScalar(); - Assertion.AssertEquals("date_field has not correct day", dt.Day, val.Day); - Assertion.AssertEquals("date_field has not correct month", dt.Month, val.Month); - Assertion.AssertEquals("date_field has not correct year", dt.Year, val.Year); + Assert.AreEqual(dt.Day, val.Day, "date_field has not correct day"); + Assert.AreEqual(dt.Month, val.Month, "date_field has not correct month"); + Assert.AreEqual(dt.Year, val.Year, "date_field has not correct year"); } [Test] @@ -395,9 +395,9 @@ DateTime val = (DateTime)command.ExecuteScalar(); - Assertion.AssertEquals("time_field has not correct hour", dt.Hour, val.Hour); - Assertion.AssertEquals("time_field has not correct minute", dt.Minute, val.Minute); - Assertion.AssertEquals("time_field has not correct second", dt.Second, val.Second); + Assert.AreEqual(dt.Hour, val.Hour, "time_field has not correct hour"); + Assert.AreEqual(dt.Minute, val.Minute, "time_field has not correct minute"); + Assert.AreEqual(dt.Second, val.Second, "time_field has not correct second"); } [Test] @@ -430,12 +430,12 @@ DateTime val = (DateTime)command.ExecuteScalar(); - Assertion.AssertEquals("timestamp_field has not correct day", dt.Day, val.Day); - Assertion.AssertEquals("timestamp_field has not correct month", dt.Month, val.Month); - Assertion.AssertEquals("timestamp_field has not correct year", dt.Year, val.Year); - Assertion.AssertEquals("timestamp_field has not correct hour", dt.Hour, val.Hour); - Assertion.AssertEquals("timestamp_field has not correct minute", dt.Minute, val.Minute); - Assertion.AssertEquals("timestamp_field has not correct second", dt.Second, val.Second); + Assert.AreEqual(dt.Day, val.Day, "timestamp_field has not correct day"); + Assert.AreEqual(dt.Month, val.Month, "timestamp_field has not correct month"); + Assert.AreEqual(dt.Year, val.Year, "timestamp_field has not correct year"); + Assert.AreEqual(dt.Hour, val.Hour, "timestamp_field has not correct hour"); + Assert.AreEqual(dt.Minute, val.Minute, "timestamp_field has not correct minute"); + Assert.AreEqual(dt.Second, val.Second, "timestamp_field has not correct second"); } [Test] Modified: trunk/pgsqlclient/source/UnitTests/PgGeometicTypesTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgGeometicTypesTest.cs 2006-03-29 11:02:41 UTC (rev 74) +++ trunk/pgsqlclient/source/UnitTests/PgGeometicTypesTest.cs 2006-03-29 11:10:57 UTC (rev 75) @@ -42,8 +42,8 @@ Console.WriteLine("Point value: {0}", point.ToString()); - Assertion.AssertEquals("Invalid X coord in point", 50, point.X); - Assertion.AssertEquals("Invalid Y coord in point", 60, point.Y); + Assert.AreEqual(50, point.X, "Invalid X coord in point"); + Assert.AreEqual(60, point.Y, "Invalid Y coord in point"); } catch (Exception) { @@ -67,11 +67,11 @@ Console.WriteLine("Box value: {0}", box.ToString()); - Assertion.AssertEquals("Invalid X coord in Lower Left corner", 0, box.LowerLeft.X); - Assertion.AssertEquals("Invalid Y coord in Lower Left corner", 70, box.LowerLeft.Y); + Assert.AreEqual(0, box.LowerLeft.X, "Invalid X coord in Lower Left corner"); + Assert.AreEqual(70, box.LowerLeft.Y, "Invalid Y coord in Lower Left corner"); - Assertion.AssertEquals("Invalid X coord in Upper Right corner", 70, box.UpperRight.X); - Assertion.AssertEquals("Invalid Y coord in Upper Right corner", 70, box.UpperRight.Y); + Assert.AreEqual(70, box.UpperRight.X, "Invalid X coord in Upper Right corner"); + Assert.AreEqual(70, box.UpperRight.Y, "Invalid Y coord in Upper Right corner"); } catch (Exception) { @@ -95,9 +95,9 @@ Console.WriteLine("Circle value: {0}", circle.ToString()); - Assertion.AssertEquals("Invalid X coord in circle", 30, circle.Center.X); - Assertion.AssertEquals("Invalid Y coord in circle", 0, circle.Center.Y); - Assertion.AssertEquals("Invalid RADIUS coord in circle", 30, circle.Radius); + Assert.AreEqual(30, circle.Center.X, "Invalid X coord in circle"); + Assert.AreEqual(0, circle.Center.Y, "Invalid Y coord in circle"); + Assert.AreEqual(30, circle.Radius, "Invalid RADIUS coord in circle"); } catch (Exception) { @@ -121,11 +121,11 @@ Console.WriteLine("LSeg value: {0}", lseg.ToString()); - Assertion.AssertEquals("Invalid X coord in start point", -1, lseg.StartPoint.X); - Assertion.AssertEquals("Invalid Y coord in start point", 0, lseg.StartPoint.Y); + Assert.AreEqual(-1, lseg.StartPoint.X, "Invalid X coord in start point"); + Assert.AreEqual(0, lseg.StartPoint.Y, "Invalid Y coord in start point"); - Assertion.AssertEquals("Invalid X coord in end point", 1, lseg.EndPoint.X); - Assertion.AssertEquals("Invalid Y coord in end point", 0, lseg.EndPoint.Y); + Assert.AreEqual(1, lseg.EndPoint.X, "Invalid X coord in end point"); + Assert.AreEqual(0, lseg.EndPoint.Y, "Invalid Y coord in end point"); } catch (Exception) { @@ -149,11 +149,11 @@ Console.WriteLine("Path value: {0}", path.ToString()); - Assertion.AssertEquals("Invalid X coord in path point 0", 0, path.Points[0].X); - Assertion.AssertEquals("Invalid Y coord in path point 0", 0, path.Points[0].Y); + Assert.AreEqual(0, path.Points[0].X, "Invalid X coord in path point 0"); + Assert.AreEqual(0, path.Points[0].Y, "Invalid Y coord in path point 0"); - Assertion.AssertEquals("Invalid X coord in path point 1", 1, path.Points[1].X); - Assertion.AssertEquals("Invalid Y coord in path point 1", 0, path.Points[1].Y); + Assert.AreEqual(1, path.Points[1].X, "Invalid X coord in path point 1"); + Assert.AreEqual(0, path.Points[1].Y, "Invalid Y coord in path point 1"); } catch (Exception) { @@ -177,11 +177,11 @@ Console.WriteLine("Polygon value: {0}", polygon.ToString()); - Assertion.AssertEquals("Invalid X coord in polygon point 0", 1, polygon.Points[0].X); - Assertion.AssertEquals("Invalid Y coord in polygon point 0", 1, polygon.Points[0].Y); + Assert.AreEqual(1, polygon.Points[0].X, "Invalid X coord in polygon point 0"); + Assert.AreEqual(1, polygon.Points[0].Y, "Invalid Y coord in polygon point 0"); - Assertion.AssertEquals("Invalid X coord in polygon point 1", 0, polygon.Points[1].X); - Assertion.AssertEquals("Invalid Y coord in polygon point 1", 0, polygon.Points[1].Y); + Assert.AreEqual(0, polygon.Points[1].X, "Invalid X coord in polygon point 1"); + Assert.AreEqual(0, polygon.Points[1].Y, "Invalid Y coord in polygon point 1"); } catch (Exception) { This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-29 11:02:54
|
Revision: 74 Author: carlosga_fb Date: 2006-03-29 03:02:41 -0800 (Wed, 29 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=74&view=rev Log Message: ----------- * Removed obsolete calls Modified Paths: -------------- trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs trunk/pgsqlclient/source/UnitTests/PostgreSql.Data.PostgreSqlClient.UnitTests.csproj Modified: trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs 2006-03-29 10:58:37 UTC (rev 73) +++ trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs 2006-03-29 11:02:41 UTC (rev 74) @@ -62,12 +62,12 @@ // Build the connection string PgConnectionStringBuilder csb = new PgConnectionStringBuilder(); - csb.DataSource = ConfigurationSettings.AppSettings["DataSource"]; - csb.Database = ConfigurationSettings.AppSettings["Database"]; - csb.UserID = ConfigurationSettings.AppSettings["User"]; - csb.Password = ConfigurationSettings.AppSettings["Password"]; - csb.Port = Convert.ToInt32(ConfigurationSettings.AppSettings["Port"]); - csb.Ssl = Convert.ToBoolean(ConfigurationSettings.AppSettings["SSL"]); + csb.DataSource = ConfigurationManager.AppSettings["DataSource"]; + csb.Database = ConfigurationManager.AppSettings["Database"]; + csb.UserID = ConfigurationManager.AppSettings["User"]; + csb.Password = ConfigurationManager.AppSettings["Password"]; + csb.Port = Convert.ToInt32(ConfigurationManager.AppSettings["Port"]); + csb.Ssl = Convert.ToBoolean(ConfigurationManager.AppSettings["SSL"]); csb.Pooling = false; connection = new PgConnection(csb.ToString()); @@ -93,12 +93,12 @@ { PgConnectionStringBuilder csb = new PgConnectionStringBuilder(); - csb.DataSource = ConfigurationSettings.AppSettings["DataSource"]; + csb.DataSource = ConfigurationManager.AppSettings["DataSource"]; csb.Database = ""; - csb.UserID = ConfigurationSettings.AppSettings["User"]; - csb.Password = ConfigurationSettings.AppSettings["Password"]; - csb.Port = Convert.ToInt32(ConfigurationSettings.AppSettings["Port"]); - csb.Ssl = Convert.ToBoolean(ConfigurationSettings.AppSettings["SSL"]); + csb.UserID = ConfigurationManager.AppSettings["User"]; + csb.Password = ConfigurationManager.AppSettings["Password"]; + csb.Port = Convert.ToInt32(ConfigurationManager.AppSettings["Port"]); + csb.Ssl = Convert.ToBoolean(ConfigurationManager.AppSettings["SSL"]); csb.Pooling = false; PgConnection connection = new PgConnection(csb.ToString()); @@ -106,7 +106,7 @@ connection.UserCertificateValidation += new System.Net.Security.RemoteCertificateValidationCallback(connection_UserCertificateValidation); connection.Open(); - PgCommand createDatabase = new PgCommand(String.Format("CREATE DATABASE {0} WITH ENCODING='UTF8'", ConfigurationSettings.AppSettings["Database"]), connection); + PgCommand createDatabase = new PgCommand(String.Format("CREATE DATABASE {0} WITH ENCODING='UTF8'", ConfigurationManager.AppSettings["Database"]), connection); createDatabase.ExecuteNonQuery(); createDatabase.Dispose(); @@ -117,12 +117,12 @@ { PgConnectionStringBuilder csb = new PgConnectionStringBuilder(); - csb.DataSource = ConfigurationSettings.AppSettings["DataSource"]; + csb.DataSource = ConfigurationManager.AppSettings["DataSource"]; csb.Database = ""; - csb.UserID = ConfigurationSettings.AppSettings["User"]; - csb.Password = ConfigurationSettings.AppSettings["Password"]; - csb.Port = Convert.ToInt32(ConfigurationSettings.AppSettings["Port"]); - csb.Ssl = Convert.ToBoolean(ConfigurationSettings.AppSettings["SSL"]); + csb.UserID = ConfigurationManager.AppSettings["User"]; + csb.Password = ConfigurationManager.AppSettings["Password"]; + csb.Port = Convert.ToInt32(ConfigurationManager.AppSettings["Port"]); + csb.Ssl = Convert.ToBoolean(ConfigurationManager.AppSettings["SSL"]); csb.Pooling = false; PgConnection connection = new PgConnection(csb.ToString()); @@ -130,7 +130,7 @@ connection.UserCertificateValidation += new System.Net.Security.RemoteCertificateValidationCallback(connection_UserCertificateValidation); connection.Open(); - PgCommand dropDatabase = new PgCommand(String.Format("drop database {0}", ConfigurationSettings.AppSettings["Database"]), connection); + PgCommand dropDatabase = new PgCommand(String.Format("drop database {0}", ConfigurationManager.AppSettings["Database"]), connection); try { dropDatabase.ExecuteNonQuery(); Modified: trunk/pgsqlclient/source/UnitTests/PostgreSql.Data.PostgreSqlClient.UnitTests.csproj =================================================================== --- trunk/pgsqlclient/source/UnitTests/PostgreSql.Data.PostgreSqlClient.UnitTests.csproj 2006-03-29 10:58:37 UTC (rev 73) +++ trunk/pgsqlclient/source/UnitTests/PostgreSql.Data.PostgreSqlClient.UnitTests.csproj 2006-03-29 11:02:41 UTC (rev 74) @@ -30,6 +30,7 @@ <ItemGroup> <Reference Include="nunit.framework, Version=2.2.7.0, Culture=neutral, PublicKeyToken=96d09a1eb7f44a77, processorArchitecture=MSIL" /> <Reference Include="System" /> + <Reference Include="System.configuration" /> <Reference Include="System.Data" /> <Reference Include="System.Xml" /> </ItemGroup> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-29 10:58:43
|
Revision: 73 Author: carlosga_fb Date: 2006-03-29 02:58:37 -0800 (Wed, 29 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=73&view=rev Log Message: ----------- ?\194?\183 Removed obsolete attribute Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnection.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnection.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnection.cs 2006-03-29 10:56:50 UTC (rev 72) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnection.cs 2006-03-29 10:58:37 UTC (rev 73) @@ -65,7 +65,7 @@ #region \xB7 Properties \xB7 [Category("Data")] - [RecommendedAsConfigurableAttribute(true)] + [SettingsBindable(true)] [RefreshProperties(RefreshProperties.All)] [DefaultValue("")] public override string ConnectionString This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-29 10:56:56
|
Revision: 72 Author: carlosga_fb Date: 2006-03-29 02:56:50 -0800 (Wed, 29 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=72&view=rev Log Message: ----------- Cleanup Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataAdapter.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataAdapter.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataAdapter.cs 2006-03-29 10:54:17 UTC (rev 71) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataAdapter.cs 2006-03-29 10:56:50 UTC (rev 72) @@ -49,12 +49,6 @@ #endregion - #region \xB7 Fields \xB7 - - private bool disposed; - - #endregion - #region \xB7 Properties \xB7 [Category("DataCategory_Update")] This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-29 10:54:26
|
Revision: 71 Author: carlosga_fb Date: 2006-03-29 02:54:17 -0800 (Wed, 29 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=71&view=rev Log Message: ----------- Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs 2006-03-29 10:53:34 UTC (rev 70) +++ trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs 2006-03-29 10:54:17 UTC (rev 71) @@ -135,7 +135,6 @@ this.minPoolSize = 0; this.maxPoolSize = 100; this.ssl = false; - this.useCustomSsl = false; } private void ParseConnectionString(string connectionString) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-29 10:53:44
|
Revision: 70 Author: carlosga_fb Date: 2006-03-29 02:53:34 -0800 (Wed, 29 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=70&view=rev Log Message: ----------- Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs 2006-03-28 13:13:45 UTC (rev 69) +++ trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs 2006-03-29 10:53:34 UTC (rev 70) @@ -37,7 +37,6 @@ private int maxPoolSize; private bool pooling; private bool ssl; - private bool useCustomSsl; #endregion This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 13:13:52
|
Revision: 69 Author: carlosga_fb Date: 2006-03-28 05:13:45 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=69&view=rev Log Message: ----------- changes to get SSL support on the nunit test suite Modified Paths: -------------- trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs Modified: trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs 2006-03-28 13:04:34 UTC (rev 68) +++ trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs 2006-03-28 13:13:45 UTC (rev 69) @@ -102,6 +102,8 @@ csb.Pooling = false; PgConnection connection = new PgConnection(csb.ToString()); + connection.StateChange += new StateChangeEventHandler(StateChange); + connection.UserCertificateValidation += new System.Net.Security.RemoteCertificateValidationCallback(connection_UserCertificateValidation); connection.Open(); PgCommand createDatabase = new PgCommand(String.Format("CREATE DATABASE {0} WITH ENCODING='UTF8'", ConfigurationSettings.AppSettings["Database"]), connection); @@ -124,7 +126,9 @@ csb.Pooling = false; PgConnection connection = new PgConnection(csb.ToString()); - connection.Open(); + connection.StateChange += new StateChangeEventHandler(StateChange); + connection.UserCertificateValidation += new System.Net.Security.RemoteCertificateValidationCallback(connection_UserCertificateValidation); + connection.Open(); PgCommand dropDatabase = new PgCommand(String.Format("drop database {0}", ConfigurationSettings.AppSettings["Database"]), connection); try This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 13:04:49
|
Revision: 68 Author: carlosga_fb Date: 2006-03-28 05:04:34 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=68&view=rev Log Message: ----------- Modified Paths: -------------- trunk/pgsqlclient/changelog.txt trunk/pgsqlclient/changes.txt Modified: trunk/pgsqlclient/changelog.txt =================================================================== --- trunk/pgsqlclient/changelog.txt 2006-03-28 13:03:51 UTC (rev 67) +++ trunk/pgsqlclient/changelog.txt 2006-03-28 13:04:34 UTC (rev 68) @@ -1,1467 +1,2 @@ -PgSqlClient - ADO.NET Data Provider for PostgreSQL 7.4+ -------------------------------------------------------- - - - -2005-05-25 Carlos Guzman Alvarez <car...@te...> - - * PostgreSQl.Data.PgSqlClient/NPgClient/PgDbClient.cs: - - - Correctly disable nagle algorithm (Patch #1207038) - -2005-04-14 Carlos Guzman Alvarez <car...@te...> - - * Fixed Tables, Views anbd Functions Privileges Schemas. - -2005-04-10 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PgSqlClient/PgConnectionPool.cs: - - - Fixed problem getting a connection form the pool. (#1146422) - -2005-04-03 Carlos Guzman Alvarez <car...@te...> - - * Changes to improve exception handling. - -2005-01-31 Carlos Guzman Alvarez <car...@te...> - - * PostgreSQl.Data.PgSqlClient/NPgSqlClient/PgOutPutPacket.cs: - - - Fixed boolean parameters support. - - * PostgreSQl.Data.PgSqlClient/PgConnection.cs: - - - Fixed bug on Close MEthod while clearing - SSL handlers. - -2004-09-29 Carlos Guzman Alvarez <car...@te...> - - - Mayour update of the sources - - -2004-07-22 Carlos Guzman Alvarez <car...@te...> - - * USe PascalCase naming for private methods in all classes. - - -2004-06-12 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PgSqlClient/PgCommand.cs: - - - Fix regex usage (it waqs working in .NET but not in mono - i have sent an email to the mono list and i'm wainting for response - for now if it's a mono problem) - - -2004-06-09 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PgSqlClient/PgCommand.cs: - - - Fix for PgCommand.NextResult (Thanks to Sion for his feedback) - -2004-06-03 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PgSqlClient/PgLayouts.cs: - - - Removed file. - - * PostgreSql.Data.PgSqlClient/PgResponsePacket.cs: - * PostgreSql.Data.PgSqlClient/PgOutputPacket.cs: - - - Improved Doubvle and Float read/write - -2004-05-31 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PgSqlClient/FbConnection.cs: - * PostgreSql.Data.PgSqlClient/NPgClient/PgDbClient.cs: - - - Reworked information and notification message handling - using callbacks (delegates) - - -2004-05-09 Carlos Guzman Alvarez <car...@te...> - - * Sync Mono.Security stuff with mono beta 1 sources. - -2004-05-06 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql/Data/PgSqlClient/NPgClient/PgDbClient.cs: - - - Changes for patch (#948340) - ( Disable the nagle algorithm on socket setup ) - -2004-05-03 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PGSqlClient/PgCommand.cs: - - - Clenaup. - - - * PostgreSql.Data.PGSqlClient/NPgClient/PgOutputPacket.cs: - - - Fix bytea field handling. - -2004-05-02 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PGSqlClient/PgCommand.cs: - - - Changes on named parameters support. - -2004-04-26 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls/Alert.cs: - * Mono.Security.Protocol.Tls/CipherSuite.cs: - * Mono.Security.Protocol.Tls/CipherSuiteCollection.cs: - * Mono.Security.Protocol.Tls/ClientRecordProtocol.cs: - * Mono.Security.Protocol.Tls/Context.cs: - * Mono.Security.Protocol.Tls/RecordProtocol.cs: - * Mono.Security.Protocol.Tls/SecurityCompressionType.cs: - * Mono.Security.Protocol.Tls/ServerRecordProtocol.cs: - * Mono.Security.Protocol.Tls/SslServerStream.cs: - * Mono.Security.Protocol.Tls/TlsClientSettings.cs: - - - Changes for fix FxCop Rules. - - * Mono.Security.Protocol.Tls.Handshake/HandshakeMessage.cs: - - - Changes for fix FxCop Rules. - - -2004-04-10 Carlos Guzman Alvarez <car...@te...> - - * Started cleanup and unification of this keyword usage tasks. - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - * Mono.Security.Protocol.Tls/SslServerStream.cs: - * Mono.Security.Protocol.Tls/Alert.cs: - * Mono.Security.Protocol.Tls/RecordProtocol.cs: - * Mono.Security.Protocol.Tls/ClientRecordProtocol.cs: - * Mono.Security.Protocol.Tls/ServerRecordProtocol.cs: - * Mono.Security.Protocol.Tls/Context.cs: - * Mono.Security.Protocol.Tls/TlsException.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/TlsClientCertificate.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/TlsClientCertificateVerify.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/TlsServerCertificate.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/TlsServerHello.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/TlsServerKeyExchange.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/TlsClientCertificateVerify.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/TlsClientFinished.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/TlsClientHello.cs: - - - Reworked Alert and Exception (TlsException) handling. - - -2004-04-09 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls/TlsClientSettings.cs: - - - Added new CertificateRSA property. - - * Mono.Security.Protocol.Tls/SslHandshakeHash.cs: - - - Added two new methods: CreateSignature and VerifySignature. - - * Mono.Security.Protocol.Tls.Handshake.Client/TlsClientCertificateVerify.cs: - - - Added Ssl3 implementation. - - * Mono.Security.Protocol.Tls.Handshake.Server/TlsClientCertificateVerify.cs: - - - Added initial implementation. - - -2004-04-1 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PgSqlClient/PgCommandBuilder.cs: - * PostgreSql.Data.PgSqlClient/PgDataReader.cs: - * PostgreSql.Data.PgSqlClient/PgCommand.cs: - - - Improved implementations of Command, - Command builder and Data reader classes. - -2004-03-23 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PgSqlClient/PgCommandBuilder.cs: - - - Improved command builder implementation. - - -2004-03-17 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls.Handshake.Server/TlsClientCertificate.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/TlsServerKeyExchange.cs: - - - Initial implementation. - -2004-03-16 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls/SslCipherSuite.cs: - - - Added changes for allow it to work as server or client. - - -2004-03-15 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls/TlsStream.cs: - * Mono.Security.Protocol.Tls/CipherSuite.cs: - * Mono.Security.Protocol.Tls/TlsCipherSuite.cs: - * Mono.Security.Protocol.Tls/SslHandshakeHash.cs: - * Mono.Security.Protocol.Tls/RecordProtocol.cs: - * Mono.Security.Cryptography/MD5SHA1.cs: - - - Use Buffer.BlockCopy instead of System.Array.Copy - - -2004-03-10 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls.Handshake.Server/TlsClientHello.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/TlsClientFinished.cs: - * Mono.Security.Protocol.Tls/RecordProtocol.cs: - - - Implemented some server alerts. - - * Mono.Security.Protocol.Tls/Context.cs: - - - Added new RecordProtocol property. - - -2004-03-09 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls.Handshake.Client/TlsClientCertificateVerify.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/TlsServerCertificateRequest.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/TlsServerFinished.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/TlsClientCertificateVerify.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/TlsServerCertificateRequest.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/TlsServerFinished.cs: - - - Fixed meesage type definition. - - * Mono.Security.Protocol.Tls/Ciphersuite.cs: - - - Added generation of the Server encryption algorithms. - - - Modified encryption/decription methods for work - as client or server as needed. - - * Mono.Security.Protocol.Tls/Ciphersuite.cs: - - - Added generation of the Server encryption algorithms. - - - * Mono.Security.Protocol.Tls.Handshake.Server/TlsClientKeyExchange.cs: - - - Finished processing of the message contents. - - * Mono.Security.Protocol.Tls/RecordProtocol.cs: - * Mono.Security.Protocol.Tls/ClientRecordProtocol.cs: - * Mono.Security.Protocol.Tls/ServerRecordProtocol.cs: - - - Added new ProcessChangeCipherSpec method. - - * Mono.Security.Protocol.Tls/Context.cs: - - - Added new PrintBuffer method ( for debug ). - - * PostgreSql.Data.PgSqlClient/PgDataReader.cs: - - - Improved data reader implementation. - - -< --------------------------- Beta 7 ------------------------------ > - -2004-03-08 Carlos Guzman Alvarez <car...@te...> - - * PostgreSql.Data.PgSqlClient/PgCommandBuilder.cs: - - - Cleanup. - - * PostgreSql.Data.PgSqlClient/PgCommand.cs: - - - Fixed bug. - - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - * Mono.Security.Protocol.Tls/SslServerStream.cs: - - - Callback cleanup. - - * PostgreSql.Data.PgSqlClient/PgCommandBuilder.cs: - - - Cleanup - - * PostgreSql.Data.PgSqlClient/PgConnectionPool.cs: - - - New connection pool implementation. - - * PostgreSql.Data.PgSqlClient/PgConnection.cs: - * PostgreSql.Data.PgSqlClient/PgDbConnection.cs: - * PostgreSql.Data.PgSqlClient/NPgClient/PgDbClient.cs: - - - Reworked SSL events hacks. - - -2004-03-06 Carlos Guzman Alvarez <car...@te...> - - * source/PgCommand.cs: - * source/PgDataReader.cs: - - - Improved Records Affected handling. - - * source/PgConnection.cs: - - - Added event for allow client certificate private key selection. - - * Mono.Security.Protocol.Tls/SslServerStream.cs: - - - Added PrivateKeySelection event and callback. - - - Added methods for event raising. - - -2004-03-06 Carlos Guzman Alvarez <car...@te...> - - * source/PgCommand.cs: - - - Improved named parameters support. - - -2004-03-03 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls/SslServerStream.cs: - - - Implemented flow for the server handshake. - - * Mono.Security.Protocol.Tls/Ciphersuite.cs: - * Mono.Security.Protocol.Tls/TlsCiphersuite.cs: - * Mono.Security.Protocol.Tls/ClientRecordProtocol.cs: - * Mono.Security.Protocol.Tls/ServerRecordProtocol.cs: - * Mono.Security.Protocol.Tls/SslClientStream.cs: - * Mono.Security.Protocol.Tls/TlsServerSettings.cs: - * Mono.Security.Protocol.Tls/TlsClientSettings.cs: - * Mono.Security.Protocol.Tls/ClientContext.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/*.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/*.cs: - - - Changes for make use of the renamed classes and enums. - - * Mono.Security.Protocol.Tls.Handshake/TlsHandshakeType.cs: - - - Renamed to HandshakeType.cs (Enum and file) - - * Mono.Security.Protocol.Tls.Handshake/TlsHandshakeMessage.cs: - - - Renamed to HandshakeMessage.cs (Class and file) - - * Mono.Security.Protocol.Tls.Handshake/TlsClientCertificateType.cs: - - - Renamed to ClientCertificateType.cs (Enum and file) - - * Mono.Security.Protocol.Tls.Alerts/TlsAlert.cs: - - - Renamed to Alert (Class, enums and file) - - * Mono.Security.Protocol.Tls/TlsContentType.cs: - - - Renamed to ContentType.cs ( Enum and file ) - - * Mono.Security.Protocol.Tls/TlsCiphersuiteCollection.cs: - - - Renamed to CiphersuiteCollection.cs ( Class and file ) - - * Mono.Security.Protocol.Tls/TlsCiphersuiteFactory.cs: - - - Renamed to CiphersuiteCollection.cs ( Class and file ) - - * Mono.Security.Protocol.Tls/TlsSslHandshakeHash.cs: - - - Renamed to SslHandshakeHash.cs ( Class and file ) - - * Mono.Security.Protocol.Tls/TlsSslCipherSuite.cs: - - - Renamed to SslCipherSuite.cs ( Class and file ) - -2004-02-25 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls/HandshakeState.cs: - - - New file. - - * Mono.Security.Protocol.Tls.Alerts/TlsAlert.cs: - - - Modified the level of some alerts according to the RFC. - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - * Mono.Security.Protocol.Tls/SslServerStream.cs: - * Mono.Security.Protocol.Tls/Context.cs: - * Mono.Security.Protocol.Tls/ClientContext.cs: - * Mono.Security.Protocol.Tls/ClientRecordProtocol.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/TlsServerFinished.cs: - - - Added changes for better handling of ClientHelloRequest messages. - -2004-02-24 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls.Alerts/TlsClosNotifyAlert.cs: - - - Removed File. - - * Mono.Security.Protocol.Tls.Alerts/TlsAlerts.cs: - * Mono.Security.Protocol.Tls/RecordProtocol.cs: - * Mono.Security.Protocol.Tls/SslClientStream.cs: - * Mono.Security.Protocol.Tls/SslServerStream.cs: - - - Reimplementation of TLS/SSL Alert Protocol. - -2004-02-23 Carlos Guzman Alvarez <car...@te...> - - * Mono.Security.Protocol.Tls/TlsContext.cs: - - - Removed file, implementation is now present in: - - Context.cs - ClientContext.cs - ServerContext.cs - - * Mono.Security.Protocol.Tls/Context.cs: - * Mono.Security.Protocol.Tls/ClientContext.cs: - * Mono.Security.Protocol.Tls/ServerContext.cs: - * Mono.Security.Protocol.Tls/ServerRecordProtocol.cs: - - - New classes. - - * Mono.Security.Protocol.Tls/SslServerStream.cs: - - - Added implementation for properties, and read/write methods - as in SslClientStream. - - - doHandshake method is not implemented yet. - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - * Mono.Security.Protocol.Tls/RecordProtocol.cs: - * Mono.Security.Protocol.Tls/Ciphersuite.cs: - * Mono.Security.Protocol.Tls.Alerts/TlsAlert.cs: - * Mono.Security.Protocol.Tls.Alerts/TlsCloseNotifyAlert.cs: - * Mono.Security.Protocol.Tls.Handshake/TlsHandshakeMessage.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/*.cs: - * Mono.Security.Protocol.Tls.Handshake.Server/*.cs: - - - Added changes for make use of the new Context implementation. - -2004-02-20 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - * Mono.Security.Protocol.Tls/RecordProtocol.cs: - * Mono.Security.Protocol.Tls/TlsContext.cs: - - - Added changes for handle te SecurityProtocolType enum - as a Flags enum. - - * Mono.Security.Protocol.Tls.Handshake.Client/TlsClientHello.cs: - - - Let the Ssl3 message to be process in the same way as the Tls1. - - * Mono.Security.Protocol.Tls.Handshake.Client/TlsClientHello.cs: - - - Added changes for use the Protocol version send by the server - - * Mono.Security.Protocol.Tls/CipherSuite.cs: - - - Compute the premaster secret using the protocol version sent in - the ClientHello message instead of the actual protocol version. - - * Mono.Security.Protocol.Tls.Alerts/TlsWarningEventAgrs.cs: - - - Removed no more needed file. - - * Mono.Security.Protocol.Tls.Alerts/TlsAlert.cs: - - - Added 4 new properties: - - * Message - - * IsWarning - - * IsFatal - - * IsCloseNotify - - - Return always the same message when working in release mode - (The authentication or decryption has failed.) - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - - - Added control over the CloseNotify Alert - to BeginRead method. - - - Return true in the server certificate validation method - if there are no errors. - -2004-02-19 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Mono.Security.Protocol.Tls/RecordProtocol.cs: - * Mono.Security.Protocol.Tls/ClientRecordProtocol.cs: - - - New classes for handle the SSL/TLS record protocol. - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - - - Record protocol stuff moved to the new classes. - - - Removed Warning event. - -2004-02-18 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Mono.Security.Protocol.Tls/CipherAlgorithmType.cs: - * Mono.Security.Protocol.Tls/HashAlgorithmType.cs: - * Mono.Security.Protocol.Tls/ExchangeAlgorithmType.cs: - - - Added Serializable attribute. - - * Mono.Security.Protocol.Tls/CipherSuite.cs: - * Mono.Security.Protocol.Tls/TlsCipherSuite.cs: - * Mono.Security.Protocol.Tls/TlsSslCipherSuite.cs: - * Mono.Security.Protocol.Tls/TlsContext.cs: - - - Added some optimizations proposed by Sebastien Pouliot. - - * Mono.Security.Protocol.Tls.Handshake.Client/TlsServerCertificate.cs: - - - Changes on Common Name detection and certificate error handling ( Thanks to Sebastien Pouliot for his feedback ). - - * Mono.Security.Protocol.Tls/SecurityProtocolType.cs: - - - Added Serializable attribute ( Thanks to Sebastien Pouliot for his feedback ). - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - - - Fix for ServerCertificate property - -2004-02-17 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - - - Added changes for check that the handshake is finished - to the security properties. - - * Mono.Security.Protocol.Tls.Handshake.Client/TlsClientCertificate.cs: - - - Raise the Client Certificate event. - - * Mono.Security.Protocol.Tls/CipherSuite.cs: - * Mono.Security.Protocol.Tls/SslClientStream.cs: - * Mono.Security.Protocol.Tls/SecurityProtocolType.cs: - * Mono.Security.Protocol.Tls/TlsCipherSuite.cs: - * Mono.Security.Protocol.Tls/TlsCipherSuiteCollection.cs: - * Mono.Security.Protocol.Tls/TlsCipherSuiteFactory.cs: - * Mono.Security.Protocol.Tls/TlsContext.cs: - * Mono.Security.Protocol.Tls.Handshake/TlsHandshakeMessage.cs: - * Mono.Security.Protocol.Tls.Handshake.Client/TlsClientHello.cs: - - - Change the SecurityProtocolType enum to mtch .NET 1.2 documentation definition. - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - - - Impement SelectedClientCertificate and ServerCertificate properties. - -2004-02-16 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Mono.Security.Protocol.Tls/TlsCipherSuiteFactory.cs: - - - Changed the cipher suites preference order ( Thanks to Sebastien Pouliot for his feedback ) - -2004-02-15 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Mono.Security.Protocol.Tls/SslClientStream.cs: - - - Added specific control od available data for Network Streams - on Read ( Thanks to Francisco Figueiredo Jr. for his feedback ). - - - Removed test code. - -2004-02-15 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgDbClient.cs: - * source/NPgClient/PgStatement.cs: - - - Simplify packet write. - -2004-01-03 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgCommand.cs: - * source/NPgClient/PgStatement.cs: - * source/NPgClient/PgResponsePacket.cs: - - - Added an initial implementation of the simple query protocol - that will be available using an SIMPLE_PROTOCOL define at build time. - - -< --------------------------- Beta 6 ------------------------------ > - -2003-12-02 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgCommand.cs: - * source/NPgClient/PgStatement.cs: - - - Minor uimprovement to prepare process. - - -2003-11-26 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgCommand.cs: - * source/NPgClient/PgStatement.cs: - - - Added minor improvement for call Describe only when it's needed. - - -2003-11-24 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgConnection.cs: - * source/PgCommand.cs: - * source/PgTransaction.cs: - - - Added better handling of connection active transaction, - (some checks done using the ODBC data provider). - - -2003-11-23 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgDbClient.cs: - - - Minor changes to exception handling. - - * source/NPgClient/PgStatement.cs: - - - Removed invalid case in switch, in method processDataRow ( Thanks to Ishpal Singh for his feedback ). - - -2003-11-22 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgDbClient.cs: - - - Added correct processing of SSLRequest message. - -2003-11-21 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgConnection.cs: - - - Added event handlers for SSL certificates validation and selection. - - * source/NPgClient/PgDbClient.cs: - - - Make SslClientStream to be public. - - * source/NPgClient/PgDbClient.cs: - * source/NPgClient/PgStatement.cs: - - - Added correct processing of Sync and error messages. - - * source/NPgClient/PgOutputPacket.cs: - - - Make conversion of datatime parameters using Convert.ToDateTime() ( Thanks to Ishpal Singh for his feedback ) - - - Make conversion of timespan parameters using TimeSpan.Parse() - - * source/PgCommand.cs: - - - Added change for try to make a correct replace of named parameters ( Thanks to Ishpal Singh for his feedback ). - - -2003-11-20 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Updated build file for use NUnit 2.1. - - -2003-11-19 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgCommand.cs: - * source/PgConnection.cs: - * source/PgDataAdapter.cs: - * source/PgCommandBuilder.cs: - - - Added better implementation of constructors and dispose methods. - - -< --------------------------- Beta 5 ------------------------------ > - - -2003-11-17 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgCommand.cs: - - - Restricted batch command execution to ExecuteReader calls. - Prepare, ExecuteNonquery and ExecuteScalar calls will handle - the command text as a single SQL command. - - * source/NPgClient/PgOutputPacket.cs: - * source/NPgClient/PgResponsePacket.cs: - * source/NPgClient/PgDbClient.cs: - - - Added correct encoding/decoding of string values with the client_encoding character set. - - -2003-11-14 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgDbClient.cs: - - * Added changes for make use of the new scema of the SSL/TLS library. - - -2003-11-12 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgDbClient.cs: - * source/NPgClient/PgOutputPacket.cs: - - - Fixed bug #841051. - - * source/PgTypes/PgBox.cs: - * source/PgTypes/PgCircle.cs: - * source/PgTypes/PgLine.cs: - * source/PgTypes/PgLSeg.cs: - * source/PgTypes/PgPath.cs: - * source/PgTypes/PgPoint.cs: - * source/PgTypes/PgPolygon.cs: - - - Added new constructors ( not to all ). - - - Added Serializable attribute. - - * source/PgTypes/PgBox.cs: - - - Added Serializable attribute. - - * source/PgTransaction.cs: - - - Removed set accessors from Connection and IsolationLEvel properties. - -2003-11-10 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgCommand.cs: - - - Fixed connection checking in dispose method. - -2003-11-08 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/FbConnection.cs: - * source/FbCommand.cs: - * source/FbdataAdapter.cs: - - - Added ToolboxItem attribute for allow components to be used from #Develop. - - * source/FbDataAdapter.cs: - - - Improved handling of behavior and Close method. - - -2003-11-06 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgResponsePacket.cs: - - - Added more precise handling of float values that sometimes have a offset of - 0.5 ( Thanks to Jesus for his feedback ) - - -2003-11-01 Alban Colley <albancolley at users.sourceforge.net> - - * source/NPgClient/PgStatement.cs: - * source/NPgClient/PgDbClient.cs: - - - Ref Cursor + Fetch Patch ( Patch #832503 ) - - -2003-10-28 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgOutputPacket.cs: - * source/NPgClient/PgResponsePacket.cs: - - - Added fix for correct handling of timetz type. - - -2003-10-27 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgOutputPacket.cs: - * source/NPgClient/PgResponsePacket.cs: - - - Added fix for correct handling of box type. - - - Added some changes to interval datatype handling. - - * source/PgTypes/PgBox.cs: - - - Added fix for correct handling of box type. - - -2003-10-26 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgDbClient.cs: - * source/NPgClient/PgOutputPacket.cs: - * source/NPgClient/PgResponsePacket.cs: - * source/NPgClient/PgDataType.cs: - * source/PgDbType.cs: - * source/PgParameter.cs: - * source/PgType.cs: - - - Started to work on support for timetz, timestamptz and interval types [not finished yet]. - - * source/PgDataReader.cs: - - - Added changes for handle new supported types and in SqlClient and OracleClient - - - New types are PgBox, PgCircle, PgPath, PgPoint, PgLSeg, PgPolygon and PgTimeSpan. - - * source/PgTypes/PgBox.cs: - * source/PgTypes/PgCircle.cs: - * source/PgTypes/PgLSeg.cs: - * source/PgTypes/PgPath.cs: - * source/PgTypes/PgPoint.cs: - * source/PgTypes/PgPolygon.cs: - - - Changed to be structs instead of classes. - - * source/PgTypes/PgTimeSpan.cs: - - - New struct type for handle PostgreSQL interval types. - - -2003-10-25 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added changes for allow future testing of geometic types. - - * Added empty nunit test fixture for geometric types testing. - - * source/NPgClient/PgDataType.cs: - - - Changed visibility level to internal - - * source/DbSchema/PgAbstractDbSchema.cs: - - - Added fix for transaction handling. - - - Added better exception handling. - - -2003-10-24 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added specific changelog file for the TLS/SSL implementation. - - -2003-10-21 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * TLS implementation: - - * Added partial implementation of SSL3 protocol. - - * TlsCipherSuiteFactory.cs: - - - Changed names of private methods. - - * TlsSslCipherSuite.cs: - - - Replaced implementations of key generation methods with - a throw new NotSupportedException() - - * TlsSocket.cs: - * TlsAbstractCipherSuite.cs: - * TlsCipherSuite.cs: - * TlsSslCipherSuite.cs: - - - Moved MAC generation methods to specific CipherSuite classes. - - -2003-10-20 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgType.cs: - - - Fixed little problem returning system type for PostgreSQL Float data type. - - * TLS implementation: - - * TlsSessionContext.cs: - - - Added new MAX_FRAGMENT_SIZE constant. - - * TlsSession.cs: - - - Removed MaxFragmentSize property. - - * TlsSocket.cs: - - - Replaced use of TlsSesison.MaxFragmentSize by TlsSessionContext.MAX_FAGMENT_SIZE - - - - Fixed padding length calculation on record encryption. - - - Abstracted CipherSuite classes for allow work with other protocol versions. - - - Added new files : - - TlsAbstractCipherSuite.cs - - TlsSslCipherSuite.cs - - TlsCipherSuiteFactory.cs - - TlsCompressionMethod.cs - - - Added new cipher suites definitions based on RFC3268 - (http://www.ietf.org/rfc/rfc3268.txt) - - - Added two new supported ciphersuites for TLS protocol: - - TLS_RSA_WITH_AES_256_CBC_SHA - - TLS_RSA_WITH_AES_128_CBC_SHA - - - Moved key generation stuff to specific cipher suite classes. - - -2003-10-19 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Protocol implementation: - - - Added support for unidimensional arrays of Geometric Types. - - - Addes upport for boolean arrays. - - -2003-10-18 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - - * Protocol implementation: - - - Improved types handling - - - Added definitions of geometric array types - - - Added specific classes for handle PostgreSQL Geometric types - - - Added handling of line, lseg, box, polygon, path geometric PostgreSQL types - - -2003-10-17 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - - * Protocol implementation: - - - Added changes for better handling of postgres datatypes - at protocol implementation layer - - - Added support for read/write point values ( as double[2] ) - - - Added support for read/write circle values ( as double[3] ) - - -2003-10-16 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * TLS Library: - - - Added changes for allow, in the future, the handshake layer - to work with SSL3 protocol. - - -< --------------------------- Beta 4 ------------------------------ > - - -2003-10-14 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - - * TLS library: - - - Added new TlsStream class. - TlsStreamReader and TlsStreamWriter will be replaced by this class soon. - TlsHandhskaeMessage inherits from this class. - - - TlsSessionContext.cs: - - - Added methods GetUnixTime and GetSecureRandomBytes. - -2003-10-10 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * TLS library: - - - Handshake reorganization. - - -2003-10-09 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * TLS library: - - - Added better control of session state and socket/session/networkstream closing - ( needs testing but seems to be the way to go ). - - * source/PgCommand.cs: - * source/PgCommandbuilder.cs: - * source/PgDatareader.cs: - - - Fixed some bugs introduced with latest commits - -2003-10-08 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * TLS library: - - - Added some code reorganization. - - - Started the work to implement Client Certificate and Client certificate verify handshake messages. - - - Fixed server certificate chain read - -2003-10-07 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgCommand.cs: - - - Simplify InternalSetOutputParameters implementation. - - * source/PgCommand.cs: - * source/PgDataReader.cs: - - - Implemented NextResult stuff and added nunit test case for it. - - -2003-10-01 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NpgClient/PgOutputPacket.cs: - - - Added better handling of array parameters. - - -2003-09-29 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added some changes to array datatype handling. - - * Added some improvements to PgCommandBuilder implementation. - - * source/PgParameter.cs: - - - created a new design time converter. - - - Added attributes. - - * source/PgCommand.cs: - - - Added better checking of command transaction ( matching SqlClient way ) - - -2003-09-28 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgCommandBuilder.cs: - - - Added changes for use the same format in the CommandText - of the generated insert, delete, update commands that is used - by the SqlClient data provider. - - -2003-09-27 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgParameter.cs: - - - Override ToString method and return the parameter name. - - * source/PgCommand.cs: - - - Added ReadOnly attribute to ConnectionTimeout property. - - -2003-09-22 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgStatement.cs: - - - Added row fetching in groups of 200 rows. - - - Cleanup. - - -2003-09-19 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgOutputPacket.cs: - - - Added support for array parameters ( not finished needs testing ). - -< ----------------------------------- Beta 3 ---------------------------------- > - -2003-09-18 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * NUnit test suite can now be executed using TLS connections. - - - Removed TlsReader and TlsWriter. Removed methods GetReader and GetWriter - from the TlsSession class. - - - Renamed class TlsSessionState to TlsSessionContext. - - - Added new TlsSocket and TlsNetworkStream classes and added a new NetworkStream - property to TlsSession class. - - - Rework TLS library usage in the provider to match to the new way of work. - -2003-09-14 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added some improvements to TLS connections. - - * Fixed some problems in Database Schema support. - -2003-09-14 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * The TLS can now finish the Handshake protocol against the PostgreSQL server, - and the provider can connect to the server using TLS connections. - - * source/NPgClient/PgDbClient.cs: - - - Added changes for better processing of messages received in secure connections ( TLS ) - -< ----------------------------------- Beta 2 ---------------------------------- > - -2003-09-02 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/NPgClient/PgDbClient.cs: - - - Added changes for better generation of the character set collection. - -2003-08-22 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added changes for allow cultureAwareCompare method of some classes to work with mono. - - * Added new test case for PgCommandBuilder class. - - * source/PgConnection.cs: - * source/PgCommandBuilder.cs: - - - Added changes for better fit to ADO.NET. - - -2003-08-20 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added initial release of a simple TLS protocol implementation, - it uses tree files from the Mono project that are under the MIT X11 - license. - - -2003-08-15 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added changes for better handling of net writes. - - - * source/PgCommand.cs: - * source/PgCommandBuilder.cs: - - - Added stored procedure execution using only the sp name. - - -2003-08-12 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgParameterCollection.cs: - - - Fixed error on RemoveAt method (#788826). - - - * source/PgDbConnection.cs: - - - Added processing of new connection string element for ssl connections. - - - * source/PgParameter.cs: - - - Fixed error on null value handling and rearrange FbDbType infering from Value property - to match SqlParameter behavior (#88827). - - -2003-07-07 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgDataReader.cs: - - - Improved GetSchemaTable method using prepared statements for retrieve column - and primary key information.. - - - -< ----------------------------------- Beta 1 ---------------------------------- > - -2003-07-05 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgParameter.cs: - - - Fixed casing of pgDbType field. - - - * source/PgCommandbuilder.cs: - - - Improved DeriveParameters method. - - -2003-07-03 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added test case for error 782096. - - * Added serial field for NUnit test suite. - - * source/PgDataReader.cs: - - - Finished initial implementation for autoincrement fields ( serial ) at - PgDataReader.GetSchemaTable method (#81647). - - - Improved primary key handling. - - * source/DbSchema/PgColumnsSchema.cs: - - - Finished implementation for autoincrement fields ( serial ) support (#81647). - - -2003-07-02 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Changed casing of all clasess from PgXXX to PgXXX to - follow MS' guidelines. - - * New directory structure in the CVS for match class names and file names. - - * source/PgDataReader.cs: - - - Fixed error closing the DataReader when the subyacent command is disposed (#782096) - - - Added code for check autoincrement fields at GetSchemaTable method. - - * source/DbSchema/P^gDbSchemaColumns.cs: - - - Added new column for know if a field is autoincrement. - - -2003-07-01 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Improved PostgreSQL 3.0 protocol handling. - - * Added some new files: - - - PgInfoMessageEventArgs.cs - - - PgNotificationEventArgs.cs - - - PgClientMessageEventArgs.cs - - - PgClientNotificationEventArgs.cs - - * Added initial revision of asynchronous notification support ( task #82889 ). - - * Added implementation of PgConnection.InfoMessage event ( task #82902 ). - - -2003-07-31 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added Linux makefile for mono:: ( Task #82784 ) - - * Fixed Toolbox bitmaps resources ( error #780770 ) - - - -< ----------------------------------- Alpha 3 ---------------------------------- > - -2003-07-30 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added NUnit test suite for PgCommandBuilder class. - - * source/PgCommandBuilder.cs: - - - Fixed handling of expression columns at checkSchemaTable method ( error #780423 ). - - * source/FbConnection.cs: - - - Fixed some problems with named parameters that mades the CommandBuilder to non work ( error #780409 ). - - * source/FbConnection.cs: - - - Added implementation for ChangeDatabase. - - * source/FbCommandBuilder.cs: - - - Added implementation for DereiveParameters method ( non tested yet ) - - -2003-07-29 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added C Sharp Naming guidelines PDF. - - * Changed cultureAwareCompare method in PgDataReader and all Collection classes for use it in a better way, - and allow it to run on Mono:: - - * source/FbDataReader.cs: - - - Changed the way for update RecordsAffected property value, making it - at Close and NextResult methods. - - -2003-07-28 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added new NUnit test for function calls (Stored procedure calls). - - * source/FbCommand.cs: - * source/FbDataReader.cs: - - - Added support for Function calls using CommandType.StoredProcedure. - - - -2003-07-27 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * surce/PgParameter.cs: - * surce/PgParameterCollection.cs: - - - Removed non standard constructor from PgParameter and added a new one, - made needed changes in the Nunit test suite from bring it to work. - - -< ----------------------------------- Alpha 2 ---------------------------------- > - - -2003-07-24 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added Windows installation project file. - - * Added CHANGES.TXT file.a - - -2003-07-22 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Changed build file for use new NUnit v2.1. - - * Improved database schema handling. - - -2003-07-21 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Minor changes to db schema support - - -2003-07-20 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added new test case for money fields. - - * Fixed money datatype handling. - - -2003-07-19 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Prepare for Alpha 1 release. - - * Improved NUnit test Suite. - - * source/NPgClient/PgOutputPacket.cs: - - - Fixed decimal datatype write. - - -2003-07-17 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added decimal datatype support at this moment using text format ( Task 81641 ) - - * Added two new files for encode/decode datatype values. - - * source/NPgClient/PgResponsePacket.cs: - - - Removed test code. - - - Added call to PgEncodeType.EncodeNumeric. - - * source/NPgClient/PgEncodeType.cs: - * source/NPgClient/PgDecodeType.cs: - * source/NPgClient/PgResponsePacket.cs: - - - CleanUp. - - -2003-07-16 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * source/PgParameter.cs: - - - Added better use of design time attributes. - - - Added new constructor. - - * source/PgCommand.cs: - - - Added better use of design time attributes. - - * source/PgConnection.cs: - * source/PgDataReader.cs: - * source/PgDataAdapter.cs: - * source/PgCommandBuilder.cs: - * source/PgErrorCollection.cs: - * source/PgParameterAdapter.cs: - * source/PgException.cs: - - - Added better use of design time attributes. - - * source/PgParameterAdapter.cs: - - - Added default constructor as internal. - - -2003-07-15 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Updated NAnt build file for MS.NET. - - * Moved the tests to NUnit. - - -2003-07-14 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added new Unit Test case for PgDataAdapter class. - - * source/PgCommand.cs: - - - Fixed exception throw. - - * source/PgCommandBuilder.cs: - - - Fixed casing in private methods and visibility level. - - - Added better handling of table names. - - * source/PgDataReader.cs: - - - Improved GetSchemaTable. - - - Fixed Primary Key info retrieval. - - * source/NPgClient/PgType.cs: - * source/NPgClient/PgTypeCollection.cs: - * source/NPgClient/PgDbClient.cs: - - - Added changes for know if a datatype is serial. - - * source/PgDataReader.cs: - * source/PgDbType.cs: - * source/PgParameter.cs: - * source/NPgClient/PgType.cs: - - - Added better handling of datatypes. - - -2003-07-13 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Added Test cases for PgDataReader and PgTransaction classes. - - * source/PgDataReader.cs: - - - Fixed implementation of GetSchemaTable method. - - * source/PgCommand.cs: - - - Added better handling of exceptions and command parameters. - - * source/PgException.cs: - * source/PgDataAdapter.cs: - - - Fixed constructors. - - -2003-07-12 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - - * Added changelog.txt file. - - * source/PgConnection.cs: - - - Do not allow to execute CreateDatabase and GetDbSchemaTable if there are a DataReader open. - - * source/PgDbConnection.cs: - - - Changed Regular expression used for parsing connection string. - - -2003-07-12 Carlos Guzm\xE1n \xC1lvarez <car...@te...> - - * Initial import. \ No newline at end of file +PostgreSqlClient - ADO.NET Data Provider for PostgreSQL 7.4+ +---------------- - ----------------------------------------- Modified: trunk/pgsqlclient/changes.txt =================================================================== --- trunk/pgsqlclient/changes.txt 2006-03-28 13:03:51 UTC (rev 67) +++ trunk/pgsqlclient/changes.txt 2006-03-28 13:04:34 UTC (rev 68) @@ -1,155 +1,4 @@ -PgSqlClient - ADO.NET Data Provider for PostgreSQL 7.4+ -------------------------------------------------------- +PostgreSqlClient - ADO.NET Data Provider for PostgreSQL 7.4+ +---------------- - ----------------------------------------- -Beta 7 ( 21-07-2004 ) ----- - - -- -- ---- - - -* Bug fixes (please review the changelog for details) - -* Better fit to ADO.NET - -* Improved SSL/TLS support. - -* Time and timestamp data types are now handled as strings. - -* Improved named parameters support. - -* Improved Command Builder and Data Reader classes. - - -Beta 6 ( 08-03-2004 ) ----- - - -- -- ---- - - -- Buf fixes. - -- Improved named parameters support. - -- Improved TLS/SSL support. - - -Beta 5 ( 18-12-2003 ) ----- - - -- -- ---- - - -- Buf fixes. - -- Minor improvements in PostgreSQL 3.0 implementation. - - -Beta 4 ( 20-11-2003 ) ----- - - -- -- ---- - - -- Bug fixes. - -- Better fit to ADO.NET. - -- Improved handling of command parameters. - -- Restricted batch command execution to PgCommand.ExecuteReader calls. - -- Added correct handling of character sets. - -- Added support for Geometric types. - -- Added some improvements to the SSL/TLS library. - - -Beta 3 ( 16-10-2003 ) ----- - - -- -- ---- - - -- Bug fixes. - -- Better fit to ADO.NET. - -- Improved Command Builder implementation. - -- Improved design time support for PgParameterCollection class. - -- Implemented PgDataReader.NextResult method. - -- Added implementation for array data type parameters. - -- Added some improvements to the TLS library. - - -Beta 2 ( 18-09-2003 ) ----- - - -- -- ---- - - -* Improvements to TLS (Transport Layer Security support). - -NUnit test suite can now be executed using TLS connections -( tested on Windows + CygWin + PostgreSQL 7.4 Beta 1 ) - -See the Task Lisk at project page on sourceforge to know what -is pending of implement in the TLS library. - -(https://sourceforge.net/pm/task.php?group_project_id=30343&group_id=85397&func=browse) - - - -Beta 1 ( 12-09-2003 ) ----- - - -- -- ---- - - -* Better fit to ADO.NET. - -* Simple Transport Layer security ( TLS 1.0 ) implementation -It's usined yet for both TLS and non-TLS connetions but it's not finished yet. - -* Improved Command Builder implementation. - -* Improved PgDataReader.GetSchemaTable method using prepared statemets for retrieve -column and primary key information. - -* Added SQL Server like Stored Procedure calls. - -* Improved compatibility with mono:: (http://www.go-mono.com) - - - -Alpha 3 ( 05-08-2003 ) ------ - - -- -- ---- - - -* Bug fixes. - -* Improved NUnit test suite. - -* Improved PostgreSQL 3.0 protocol handling. - -* Improved PgCommandBuilder.DeriveParameters method. - -* Added initial implementation of PgConnection.Notification for asynchronous notification support ( task #82889 ). - -* Added initial implementation of PgConnection.InfoMessage event ( task #82902 ). - -* Added initial implementation of serial fields support ( task #81647 ). - -* Changed casing of all clasess from PGXXX to PgXXX to follow MS' guidelines. - -* New directory structure in the CVS for match class, file and directory names -( pgsqlclient_10 is the actual cvs developement module ) - - - -Alpha 2 ( 31-07-2003 ) ------ - - -- -- ---- - - -* Better fit to ADO .NET - -* Improved NUnit test suite. - -* Added support for Function calls using CommandType.StoredProcedure. - -* Added some changes for better work with mono:: platform. - -* Added implementation for PgConnection.ChangeDatabase method. - -* Added implementation for PgCommandBuilder.DeriveParameters method. - -* PgCommandBuilder is now working better. - - - -Alpha 2 ( 27-07-2003 ) ------ - - -- -- ---- - - -Initial release. \ No newline at end of file This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 13:04:02
|
Revision: 67 Author: carlosga_fb Date: 2006-03-28 05:03:51 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=67&view=rev Log Message: ----------- Modified Paths: -------------- trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs Modified: trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs 2006-03-28 13:02:19 UTC (rev 66) +++ trunk/pgsqlclient/source/UnitTests/PgBaseTest.cs 2006-03-28 13:03:51 UTC (rev 67) @@ -72,6 +72,7 @@ connection = new PgConnection(csb.ToString()); connection.StateChange += new StateChangeEventHandler(StateChange); + connection.UserCertificateValidation += new System.Net.Security.RemoteCertificateValidationCallback(connection_UserCertificateValidation); connection.Open(); CreateTables(); @@ -383,10 +384,14 @@ private void StateChange(object sender, StateChangeEventArgs e) { - Console.WriteLine("Connection state changed from {0} to {1}", - e.OriginalState, e.CurrentState); + Console.WriteLine("Connection state changed from {0} to {1}", e.OriginalState, e.CurrentState); } + private bool connection_UserCertificateValidation(object sender, System.Security.Cryptography.X509Certificates.X509Certificate certificate, System.Security.Cryptography.X509Certificates.X509Chain chain, System.Net.Security.SslPolicyErrors sslPolicyErrors) + { + return true; + } + #endregion } } \ No newline at end of file This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 13:02:32
|
Revision: 66 Author: carlosga_fb Date: 2006-03-28 05:02:19 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=66&view=rev Log Message: ----------- Modified Paths: -------------- trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs Modified: trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs 2006-03-28 12:59:34 UTC (rev 65) +++ trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs 2006-03-28 13:02:19 UTC (rev 66) @@ -154,12 +154,6 @@ } [Test] - public void TableConstraint() - { - DataTable tableConstraint = Connection.GetSchema("TableConstraint", null); - } - - [Test] public void Triggers() { DataTable triggers = Connection.GetSchema("Triggers", null); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 12:59:41
|
Revision: 65 Author: carlosga_fb Date: 2006-03-28 04:59:34 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=65&view=rev Log Message: ----------- Modified Paths: -------------- trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs Modified: trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs 2006-03-28 12:50:37 UTC (rev 64) +++ trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs 2006-03-28 12:59:34 UTC (rev 65) @@ -165,17 +165,10 @@ DataTable triggers = Connection.GetSchema("Triggers", null); } - [Test] - [Ignore("Not implemented.")] - public void TriggerParameters() - { - DataTable triggerParameters = Connection.GetSchema("TriggerParameters", null); - } - [Test] public void ViewColumns() { - DataTable viewColumns = Connection.GetSchema("viewColumns", null); + DataTable viewColumns = Connection.GetSchema("ViewColumns", null); } [Test] This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 12:50:47
|
Revision: 64 Author: carlosga_fb Date: 2006-03-28 04:50:37 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=64&view=rev Log Message: ----------- Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgDatabase.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs 2006-03-28 12:34:28 UTC (rev 63) +++ trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgConnectionOptions.cs 2006-03-28 12:50:37 UTC (rev 64) @@ -15,7 +15,6 @@ * All Rights Reserved. */ - using System; using System.Text; using System.Text.RegularExpressions; @@ -38,6 +37,7 @@ private int maxPoolSize; private bool pooling; private bool ssl; + private bool useCustomSsl; #endregion @@ -99,12 +99,12 @@ get { return this.pooling; } } - public bool SSL + public bool Ssl { get { return this.ssl; } } - #endregion + #endregion #region \xB7 Constructors \xB7 @@ -135,6 +135,8 @@ this.connectionLifetime = 0; this.minPoolSize = 0; this.maxPoolSize = 100; + this.ssl = false; + this.useCustomSsl = false; } private void ParseConnectionString(string connectionString) Modified: trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgDatabase.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgDatabase.cs 2006-03-28 12:34:28 UTC (rev 63) +++ trunk/pgsqlclient/source/PostgreSql/Data/Protocol/PgDatabase.cs 2006-03-28 12:50:37 UTC (rev 64) @@ -271,7 +271,7 @@ lock (this) { - if (this.options.SSL) + if (this.options.Ssl) { // Send SSL request message if (this.SslRequest()) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 12:34:40
|
Revision: 63 Author: carlosga_fb Date: 2006-03-28 04:34:28 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=63&view=rev Log Message: ----------- ?\194?\183 Changes for correct handling of SSL callbacks Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnection.cs trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionInternal.cs trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionPool.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnection.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnection.cs 2006-03-28 12:14:23 UTC (rev 62) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnection.cs 2006-03-28 12:34:28 UTC (rev 63) @@ -326,6 +326,8 @@ else { this.connectionInternal = new PgConnectionInternal(this); + + this.SslSetup(); this.connectionInternal.OwningConnection = this; this.connectionInternal.Pooled = false; @@ -344,10 +346,6 @@ // Add notification event handler this.connectionInternal.Database.Notification = new NotificationCallback(this.OnNotification); - - // Add SSL callback handlers - this.connectionInternal.Database.UserCertificateValidationCallback = new RemoteCertificateValidationCallback(OnUserCertificateValidation); - this.connectionInternal.Database.UserCertificateSelectionCallback = new LocalCertificateSelectionCallback(OnUserCertificateSelection); } catch (PgClientException ex) { @@ -445,9 +443,20 @@ #endregion - #region \xB7 Event Handlers Methods \xB7 + #region \xB7 SSL Setup \xB7 - private void OnInfoMessage(PgClientException ex) + internal void SslSetup() + { + // Add SSL callback handlers + this.connectionInternal.Database.UserCertificateValidationCallback = new RemoteCertificateValidationCallback(OnUserCertificateValidation); + this.connectionInternal.Database.UserCertificateSelectionCallback = new LocalCertificateSelectionCallback(OnUserCertificateSelection); + } + + #endregion + + #region \xB7 Event Handlers Methods \xB7 + + private void OnInfoMessage(PgClientException ex) { if (this.InfoMessage != null) { Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionInternal.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionInternal.cs 2006-03-28 12:14:23 UTC (rev 62) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionInternal.cs 2006-03-28 12:34:28 UTC (rev 63) @@ -101,6 +101,7 @@ { this.owningConnection = owningConnection; this.options = new PgConnectionOptions(owningConnection.ConnectionString); + this.database = new PgDatabase(this.options); this.created = 0; this.pooled = true; } @@ -113,7 +114,6 @@ { try { - this.database = new PgDatabase(this.options); this.database.Connect(); } catch (PgClientException ex) Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionPool.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionPool.cs 2006-03-28 12:14:23 UTC (rev 62) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionPool.cs 2006-03-28 12:34:28 UTC (rev 63) @@ -137,10 +137,12 @@ newConnection = this.Create(owningConnection); - newConnection.OwningConnection = owningConnection; - newConnection.Pooled = true; - newConnection.Created = System.DateTime.Now.Ticks; + newConnection.OwningConnection = owningConnection; + newConnection.Pooled = true; + newConnection.Created = System.DateTime.Now.Ticks; + owningConnection.SslSetup(); + newConnection.Connect(); this.locked.Add(newConnection); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 12:14:30
|
Revision: 62 Author: carlosga_fb Date: 2006-03-28 04:14:23 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=62&view=rev Log Message: ----------- ?\194?\183 Removed non valid test case Modified Paths: -------------- trunk/pgsqlclient/source/UnitTests/PgDataReaderTest.cs Modified: trunk/pgsqlclient/source/UnitTests/PgDataReaderTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgDataReaderTest.cs 2006-03-28 12:13:51 UTC (rev 61) +++ trunk/pgsqlclient/source/UnitTests/PgDataReaderTest.cs 2006-03-28 12:14:23 UTC (rev 62) @@ -201,50 +201,6 @@ command.Dispose(); } - [Test] - [Ignore] - public void NextResultTest() - { - string querys = - "select * from public.test_table order by int4_field asc;" + - "select * from public.test_table order by int4_field desc;"; - - PgCommand command = new PgCommand(querys, Connection); - - PgDataReader reader = command.ExecuteReader(); - - Console.WriteLine(); - Console.WriteLine("DataReader - NextResult Method - Test ( First Result )"); - - while (reader.Read()) - { - for(int i = 0; i < reader.FieldCount; i++) - { - Console.Write(reader.GetValue(i) + "\t"); - } - - Console.WriteLine(); - } - - if (reader.NextResult()) - { - Console.WriteLine("DataReader - NextResult Method - Test ( Second Result )"); - - while (reader.Read()) - { - for(int i = 0; i < reader.FieldCount; i++) - { - Console.Write(reader.GetValue(i) + "\t"); - } - - Console.WriteLine(); - } - } - - reader.Close(); - command.Dispose(); - } - #endregion } } \ No newline at end of file This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 12:14:01
|
Revision: 61 Author: carlosga_fb Date: 2006-03-28 04:13:51 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=61&view=rev Log Message: ----------- ?\194?\183 More bug fixes Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgCommand.cs trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataReader.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgCommand.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgCommand.cs 2006-03-28 11:24:30 UTC (rev 60) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgCommand.cs 2006-03-28 12:13:51 UTC (rev 61) @@ -45,8 +45,6 @@ private int commandTimeout; private bool designTimeVisible; private StringCollection namedParameters; - private int matchIndex; - private Hashtable matchReplaces; private PgStatement statement; private PgDataReader activeDataReader; @@ -219,9 +217,26 @@ #endregion - #region \xB7 Constructors \xB7 + #region \xB7 Private Properties \xB7 - public PgCommand() + public StringCollection NamedParameters + { + get + { + if (this.namedParameters == null) + { + this.namedParameters = new StringCollection(); + } + + return this.namedParameters; + } + } + + #endregion + + #region \xB7 Constructors \xB7 + + public PgCommand() : base() { this.commandText = String.Empty; @@ -230,8 +245,6 @@ this.updatedRowSource = UpdateRowSource.Both; this.commandBehavior = CommandBehavior.Default; this.designTimeVisible = true; - this.namedParameters = new StringCollection(); - this.matchReplaces = new Hashtable(); } public PgCommand(string cmdText) @@ -276,11 +289,11 @@ this.commandText = null; - this.matchReplaces.Clear(); - this.matchReplaces = null; - - this.namedParameters.Clear(); - this.namedParameters = null; + if (this.namedParameters != null) + { + this.namedParameters.Clear(); + this.namedParameters = null; + } } // release any unmanaged resources @@ -432,7 +445,7 @@ string prepareName = "PS" + this.GetStmtName(); string portalName = "PR" + this.GetStmtName(); - this.statement = conn.Database.CreateStatement(prepareName, portalName, this.ParseParameterNames(sql)); + this.statement = conn.Database.CreateStatement(prepareName, portalName, this.ParseNamedParameters(sql)); // Parse statement this.statement.Parse(); @@ -598,61 +611,66 @@ return GetHashCode().ToString() + this.connection.GetHashCode().ToString() + DateTime.Now.Ticks; } - private string ParseParameterNames(string commandText) - { - string sql = commandText; + private string ParseNamedParameters(string sql) + { + StringBuilder builder = new StringBuilder(); + StringBuilder paramBuilder = new StringBuilder(); + bool inCommas = false; + bool inParam = false; + int paramIndex = 0; - this.namedParameters.Clear(); + this.NamedParameters.Clear(); - if (commandText.IndexOf("@") != -1) - { - this.matchReplaces.Clear(); - this.matchIndex = 0; + if (sql.IndexOf('@') == -1) + { + return sql; + } - string pattern = @"(('[^']*?\@[^']*')*[^'@]*?)*(?<param>@\w+)*([^'@]*?('[^']*?\@*[^']*'))*"; + for (int i = 0; i < sql.Length; i++) + { + char sym = sql[i]; - Regex r = new Regex(pattern, RegexOptions.ExplicitCapture); + if (inParam) + { + if (Char.IsLetterOrDigit(sym) || sym == '_' || sym == '$') + { + paramBuilder.Append(sym); + } + else + { + this.NamedParameters.Add(paramBuilder.ToString()); + paramBuilder.Length = 0; + builder.AppendFormat("${0}", ++paramIndex); + builder.Append(sym); + inParam = false; + } + } + else + { + if (sym == '\'') + { + inCommas = !inCommas; + } + else if (!inCommas && sym == '@') + { + inParam = true; + paramBuilder.Append(sym); + continue; + } - MatchEvaluator me = new MatchEvaluator(NamedParamsMatchEvaluator); + builder.Append(sym); + } + } - sql = r.Replace(sql, me); + if (inParam) + { + this.NamedParameters.Add(paramBuilder.ToString()); + builder.AppendFormat("${0}", ++paramIndex); + } - this.matchReplaces.Clear(); - } + return builder.ToString(); + } - return sql; - } - - private string NamedParamsMatchEvaluator(Match match) - { - string input = match.Value; - string replace = String.Empty; - - if (match.Groups["param"].Success) - { - Group g = match.Groups["param"]; - - if (!this.matchReplaces.ContainsKey(g.Value)) - { - this.namedParameters.Add(g.Value); - - replace = "$$" + ((this.matchIndex++) + 1).ToString(); - - this.matchReplaces.Add(g.Value, replace); - } - else - { - replace = this.matchReplaces[g.Value].ToString(); - } - - return Regex.Replace(input, g.Value, replace); - } - else - { - return match.Value; - } - } - private void SetParameterValues() { if (this.Parameters.Count != 0) @@ -661,9 +679,9 @@ { int index = i; - if (this.namedParameters.Count > 0) + if (this.NamedParameters.Count > 0) { - index = this.Parameters.IndexOf(this.namedParameters[i]); + index = this.Parameters.IndexOf(this.NamedParameters[i]); } if (this.Parameters[index].Direction == ParameterDirection.Input || Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataReader.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataReader.cs 2006-03-28 11:24:30 UTC (rev 60) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataReader.cs 2006-03-28 12:13:51 UTC (rev 61) @@ -258,8 +258,8 @@ // Add row information DataRow schemaRow = schemaTable.NewRow(); - schemaRow["ColumnName"] = Convert.ToString(columnInfo[2]); - schemaRow["ColumnOrdinal"] = Convert.ToInt32(columnInfo[5]); + schemaRow["ColumnName"] = this.GetName(i); + schemaRow["ColumnOrdinal"] = (i + 1); schemaRow["ColumnSize"] = this.GetSize(i); if (this.IsNumeric(i)) { @@ -287,7 +287,7 @@ schemaRow["BaseColumnName"] = columnInfo[2].ToString(); schemaRow["IsReadOnly"] = (bool)columnInfo[7]; schemaRow["IsAutoIncrement"] = (bool)columnInfo[7]; - schemaRow["IsKey"] = this.IsPrimaryKey(pKeyInfo, (int)schemaRow["ColumnOrdinal"]); + schemaRow["IsKey"] = this.IsPrimaryKey(pKeyInfo, Convert.ToInt32(columnInfo[5])); schemaRow["AllowDBNull"] = ((bool)columnInfo[6]) ? false : true; } else This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 11:24:39
|
Revision: 60 Author: carlosga_fb Date: 2006-03-28 03:24:30 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=60&view=rev Log Message: ----------- ?\194?\183 Fixed Key Column info retrieval in GetSchema Methods ?\194?\183 Changed SQL statements used to retrieve column info to get only the nedded information. Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataReader.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataReader.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataReader.cs 2006-03-28 11:23:24 UTC (rev 59) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgDataReader.cs 2006-03-28 11:24:30 UTC (rev 60) @@ -252,15 +252,15 @@ if (primaryKeyCmd.Statement.Rows != null && primaryKeyCmd.Statement.Rows.Length > 0) { object[] temp = (object[])primaryKeyCmd.Statement.Rows[0]; - pKeyInfo = (Array)temp[4]; + pKeyInfo = (Array)temp[0]; } // Add row information - DataRow schemaRow = schemaTable.NewRow(); + DataRow schemaRow = schemaTable.NewRow(); - schemaRow["ColumnName"] = this.GetName(i); - schemaRow["ColumnOrdinal"] = i; - schemaRow["ColumnSize"] = this.GetSize(i); + schemaRow["ColumnName"] = Convert.ToString(columnInfo[2]); + schemaRow["ColumnOrdinal"] = Convert.ToInt32(columnInfo[5]); + schemaRow["ColumnSize"] = this.GetSize(i); if (this.IsNumeric(i)) { schemaRow["NumericPrecision"] = this.GetNumericPrecision(i); @@ -279,15 +279,16 @@ schemaRow["IsAliased"] = this.IsAliased(i); schemaRow["IsExpression"] = this.IsExpression(i); schemaRow["BaseCatalogName"] = System.DBNull.Value; + if (columnInfo != null) { - schemaRow["BaseSchemaName"] = columnInfo[1].ToString(); - schemaRow["BaseTableName"] = columnInfo[2].ToString(); - schemaRow["BaseColumnName"] = columnInfo[3].ToString(); - schemaRow["IsReadOnly"] = (bool)columnInfo[10]; - schemaRow["IsAutoIncrement"] = (bool)columnInfo[10]; - schemaRow["IsKey"] = this.IsPrimaryKey(pKeyInfo, (int)columnInfo[6]); - schemaRow["AllowDBNull"] = ((bool)columnInfo[9]) ? false : true; + schemaRow["BaseSchemaName"] = columnInfo[0].ToString(); + schemaRow["BaseTableName"] = columnInfo[1].ToString(); + schemaRow["BaseColumnName"] = columnInfo[2].ToString(); + schemaRow["IsReadOnly"] = (bool)columnInfo[7]; + schemaRow["IsAutoIncrement"] = (bool)columnInfo[7]; + schemaRow["IsKey"] = this.IsPrimaryKey(pKeyInfo, (int)schemaRow["ColumnOrdinal"]); + schemaRow["AllowDBNull"] = ((bool)columnInfo[6]) ? false : true; } else { @@ -314,45 +315,32 @@ private string GetColumnsSql() { - return "SELECT " + - "null AS TABLE_CATALOG, " + + return + "SELECT " + "pg_namespace.nspname AS TABLE_SCHEMA, " + "pg_class.relname AS TABLE_NAME, " + "pg_attribute.attname AS COLUMN_NAME, " + "pg_attribute.atttypid AS DATA_TYPE, " + "pg_attribute.attlen AS COLUMN_SIZE, " + - "pg_attribute.attndims AS COLUMN_DIMENSIONS, " + "pg_attribute.attnum AS ORDINAL_POSITION, " + - "pg_attrdef.adsrc AS COLUMN_DEFAULT, " + "pg_attribute.attnotnull AS IS_NOT_NULL, " + - "(pg_depend.objid is not null) AS IS_AUTOINCREMENT, " + - "case pg_attribute.attstorage " + - "when 'p' THEN 'PLAIN' " + - "when 'e' THEN 'EXTERNAL' "+ - "when 'm' THEN 'MAIN' " + - "when 'x' THEN 'EXTENDED' " + - "END AS STORAGE, " + - "pg_description.description AS DESCRIPTION " + + "(pg_depend.objid is not null) AS IS_AUTOINCREMENT " + "FROM pg_attribute " + "left join pg_class ON pg_attribute.attrelid = pg_class.oid " + "left join pg_namespace ON pg_class.relnamespace = pg_namespace.oid " + - "left join pg_attrdef ON (pg_class.oid = pg_attrdef.adrelid AND pg_attribute.attnum = pg_attrdef.adnum) " + - "left join pg_description ON (pg_attribute.attrelid = pg_description.objoid AND pg_attribute.attnum = pg_description.objsubid) " + - "left join pg_depend ON (pg_attribute.attrelid = pg_depend.refobjid AND pg_attribute.attnum = pg_depend.refobjsubid AND pg_depend.deptype = 'i') " + - "WHERE pg_attribute.attisdropped = false AND pg_attribute.attnum > 0 AND " + - "pg_attribute.attnum = @OidNumber AND " + - "pg_attribute.attrelid = @OidTable"; + "left join pg_attrdef ON (pg_class.oid = pg_attrdef.adrelid AND pg_attribute.attnum = pg_attrdef.adnum) " + + "left join pg_depend ON (pg_attribute.attrelid = pg_depend.refobjid AND pg_attribute.attnum = pg_depend.refobjsubid AND pg_depend.deptype = 'i') " + + "WHERE " + + "pg_attribute.attisdropped = false AND " + + "pg_attribute.attnum > 0 AND " + + "pg_attribute.attnum = @OidNumber AND " + + "pg_attribute.attrelid = @OidTable"; } private string GetPrimaryKeysSql() { return "SELECT " + - "null AS TABLE_CATALOG, " + - "pg_namespace.nspname AS TABLE_SCHEMA, " + - "pg_class.relname AS TABLE_NAME, " + - "pg_constraint.conname AS PK_NAME, " + - "pg_constraint.conkey AS PK_COLUMNS, " + - "pg_description.description AS DESCRIPTION " + + "pg_constraint.conkey AS PK_COLUMNS " + "FROM pg_constraint " + "left join pg_class ON pg_constraint.conrelid = pg_class.oid " + "left join pg_namespace ON pg_constraint.connamespace = pg_namespace.oid " + This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-28 11:23:33
|
Revision: 59 Author: carlosga_fb Date: 2006-03-28 03:23:24 -0800 (Tue, 28 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=59&view=rev Log Message: ----------- ?\194?\183 minor change on Validate method to do not throw an exception when the connection is not valid Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionPool.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionPool.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionPool.cs 2006-03-27 13:04:55 UTC (rev 58) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgConnectionPool.cs 2006-03-28 11:23:24 UTC (rev 59) @@ -197,7 +197,7 @@ } catch { - throw; + return false; } } This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-27 13:05:15
|
Revision: 58 Author: carlosga_fb Date: 2006-03-27 05:04:55 -0800 (Mon, 27 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=58&view=rev Log Message: ----------- ?\194?\183 Added new NUnit Tests for Database Schemas Modified Paths: -------------- trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs Modified: trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs =================================================================== --- trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs 2006-03-27 13:04:09 UTC (rev 57) +++ trunk/pgsqlclient/source/UnitTests/PgDatabaseSchemaTest.cs 2006-03-27 13:04:55 UTC (rev 58) @@ -58,7 +58,19 @@ DataTable databases = Connection.GetSchema("Databases", null); } - [Test] + [Test] + public void DataSourceInformation() + { + DataTable dataSourceInformation = Connection.GetSchema("DataSourceInformation", null); + } + + [Test] + public void DataTypes() + { + DataTable providerTypes = Connection.GetSchema("DataTypes", null); + } + + [Test] public void ForeignKeys() { DataTable foreignKeys = Connection.GetSchema("ForeignKeys", null); @@ -110,24 +122,31 @@ DataTable primaryKeys = Connection.GetSchema("PrimaryKeys", null); } - [Test] - public void DataTypes() - { - DataTable providerTypes = Connection.GetSchema("DataTypes", null); - } - [Test] - public void Schemata() - { - DataTable schemata = Connection.GetSchema("Schemata", null); - } + [Test] + public void ReservedWords() + { + DataTable reservedWords = Connection.GetSchema("ReservedWords", null); + } - [Test] - public void SqlLanguages() - { - DataTable sqlLanguages = Connection.GetSchema("SqlLanguages", null); - } + [Test] + public void Restrictions() + { + DataTable restrictions = Connection.GetSchema("Restrictions", null); + } + [Test] + public void Schemas() + { + DataTable schemas = Connection.GetSchema("Schemas"); + } + + [Test] + public void SqlLanguages() + { + DataTable sqlLanguages = Connection.GetSchema("SqlLanguages"); + } + [Test] public void Tables() { @@ -154,7 +173,6 @@ } [Test] - [Ignore("Not Implemented")] public void ViewColumns() { DataTable viewColumns = Connection.GetSchema("viewColumns", null); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-27 13:04:17
|
Revision: 57 Author: carlosga_fb Date: 2006-03-27 05:04:09 -0800 (Mon, 27 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=57&view=rev Log Message: ----------- ?\194?\183 Added implementation of ViewColumns schema Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/Schema/MetaData.xml trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgViewColumns.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/Schema/MetaData.xml =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/Schema/MetaData.xml 2006-03-27 12:45:14 UTC (rev 56) +++ trunk/pgsqlclient/source/PostgreSql/Data/Schema/MetaData.xml 2006-03-27 13:04:09 UTC (rev 57) @@ -516,6 +516,30 @@ <RestrictionDefault>view_name</RestrictionDefault> <RestrictionNumber>3</RestrictionNumber> </Restrictions> + <Restrictions> + <CollectionName>ViewColumns</CollectionName> + <RestrictionName>ViewCatalog</RestrictionName> + <RestrictionDefault>view_catalog</RestrictionDefault> + <RestrictionNumber>1</RestrictionNumber> + </Restrictions> + <Restrictions> + <CollectionName>ViewColumns</CollectionName> + <RestrictionName>ViewSchema</RestrictionName> + <RestrictionDefault>view_schema</RestrictionDefault> + <RestrictionNumber>2</RestrictionNumber> + </Restrictions> + <Restrictions> + <CollectionName>ViewColumns</CollectionName> + <RestrictionName>ViewName</RestrictionName> + <RestrictionDefault>view_name</RestrictionDefault> + <RestrictionNumber>3</RestrictionNumber> + </Restrictions> + <Restrictions> + <CollectionName>ViewColumns</CollectionName> + <RestrictionName>ColumnName</RestrictionName> + <RestrictionDefault>column_name</RestrictionDefault> + <RestrictionNumber>4</RestrictionNumber> + </Restrictions> <DataSourceInformation> <CompositeIdentifierSeparatorPattern>.</CompositeIdentifierSeparatorPattern> <DataSourceProductName>PostgreSQL</DataSourceProductName> Modified: trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgViewColumns.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgViewColumns.cs 2006-03-27 12:45:14 UTC (rev 56) +++ trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgViewColumns.cs 2006-03-27 13:04:09 UTC (rev 57) @@ -25,7 +25,48 @@ protected override string BuildSql(string[] restrictions) { - throw new NotImplementedException(); + string sql = + "SELECT " + + "current_database() AS VIEW_CATALOG, " + + "pg_namespace.nspname AS VIEW_SCHEMA, " + + "pg_class.relname AS VIEW_NAME, " + + "pg_attribute.attname AS COLUMN_NAME " + + "FROM " + + "pg_class " + + "left join pg_namespace ON pg_class.relnamespace = pg_namespace.oid " + + "left join pg_attribute ON pg_attribute.attrelid = pg_class.oid " + + "WHERE " + + "pg_class.relkind = 'v' "; + + if (restrictions != null && restrictions.Length > 0) + { + // VIEW_CATALOG + if (restrictions.Length > 0 && restrictions[0] != null) + { + } + + // VIEW_SCHEMA + if (restrictions.Length > 1 && restrictions[1] != null) + { + sql += String.Format(" and pg_namespace.nspname = '{0}'", restrictions[1]); + } + + // VIEW_NAME + if (restrictions.Length > 2 && restrictions[2] != null) + { + sql += String.Format(" and pg_class.relname = '{0}'", restrictions[2]); + } + + // COLUMN_NAME + if (restrictions.Length > 3 && restrictions[3] != null) + { + sql += String.Format(" and pg_attribute.attname = '{0}'", restrictions[3]); + } + } + + sql += " ORDER BY pg_namespace.nspname, pg_class.relname"; + + return sql; } #endregion This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-27 12:45:28
|
Revision: 56 Author: carlosga_fb Date: 2006-03-27 04:45:14 -0800 (Mon, 27 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=56&view=rev Log Message: ----------- ?\194?\183 Implemented Index Columns database schema Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/Schema/MetaData.xml trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgIndexColumns.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/Schema/MetaData.xml =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/Schema/MetaData.xml 2006-03-27 12:13:59 UTC (rev 55) +++ trunk/pgsqlclient/source/PostgreSql/Data/Schema/MetaData.xml 2006-03-27 12:45:14 UTC (rev 56) @@ -176,7 +176,7 @@ </MetaDataCollections> <MetaDataCollections> <CollectionName>IndexColumns</CollectionName> - <NumberOfRestrictions>4</NumberOfRestrictions> + <NumberOfRestrictions>5</NumberOfRestrictions> <NumberOfIdentifierParts>0</NumberOfIdentifierParts> <PopulationMechanism>PrepareCollection</PopulationMechanism> </MetaDataCollections> Modified: trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgIndexColumns.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgIndexColumns.cs 2006-03-27 12:13:59 UTC (rev 55) +++ trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgIndexColumns.cs 2006-03-27 12:45:14 UTC (rev 56) @@ -25,9 +25,60 @@ protected override string BuildSql(string[] restrictions) { - throw new Exception("The method or operation is not implemented."); - } + string sql = + "SELECT " + + "current_database() AS TABLE_CATALOG, " + + "pg_namespace.nspname AS TABLE_SCHEMA, " + + "pg_class.relname AS TABLE_NAME, " + + "current_database() AS INDEX_CATALOG, " + + "pg_namespidx.nspname AS INDEX_SCHEMA, " + + "pg_classidx.relname AS INDEX_NAME, " + + "pg_attribute.attname AS COLUMN_NAME, " + + "pg_attribute.attnum AS ORDINAL_POSITION " + + "FROM pg_index " + + "left join pg_class ON pg_index.indrelid = pg_class.oid " + + "left join pg_class as pg_classidx ON pg_index.indexrelid = pg_classidx.oid " + + "left join pg_namespace ON pg_classidx.relnamespace = pg_namespace.oid " + + "left join pg_namespace as pg_namespidx ON pg_classidx.relnamespace = pg_namespidx.oid " + + "left join pg_attribute ON pg_index.indexrelid = pg_attribute.attrelid "; + + if (restrictions != null && restrictions.Length > 0) + { + // TABLE_CATALOG + if (restrictions.Length > 0 && restrictions[0] != null) + { + } + // TABLE_SCHEMA + if (restrictions.Length > 1 && restrictions[1] != null) + { + sql += String.Format(" and pg_namespace.nspname = '{0}'", restrictions[1]); + } + + // TABLE_NAME + if (restrictions.Length > 2 && restrictions[2] != null) + { + sql += String.Format(" and pg_class.relname = '{0}'", restrictions[2]); + } + + // INDEX_NAME + if (restrictions.Length > 3 && restrictions[3] != null) + { + sql += String.Format(" and pg_classidx.relname = '{0}'", restrictions[3]); + } + + // COLUMN_NAME + if (restrictions.Length > 4 && restrictions[4] != null) + { + sql += String.Format(" and pg_attribute.attname = '{0}'", restrictions[4]); + } + } + + sql += "ORDER BY pg_namespace.nspname, pg_class.relname, pg_classidx.relname, pg_attribute.attnum"; + + return sql; + } + #endregion } } This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-27 12:14:14
|
Revision: 55 Author: carlosga_fb Date: 2006-03-27 04:13:59 -0800 (Mon, 27 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=55&view=rev Log Message: ----------- ?\194?\183 Finished initial implementation of the Foreign Key Columns schema Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgForeignKeyColumns.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgForeignKeyColumns.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgForeignKeyColumns.cs 2006-03-27 12:13:20 UTC (rev 54) +++ trunk/pgsqlclient/source/PostgreSql/Data/Schema/PgForeignKeyColumns.cs 2006-03-27 12:13:59 UTC (rev 55) @@ -88,7 +88,23 @@ protected override DataTable ProcessResult(PgConnection connection, DataTable schema) { DataTable foreignKeyColumns = schema.Clone(); + string sql = + "SELECT " + + "column_name " + + "FROM information_schema.columns " + + "WHERE "+ + "table_catalog=current_database() AND " + + "table_schema=@tableSchema AND " + + "table_name=@tableName AND " + + "ordinal_position=@ordinalPosition"; + PgCommand selectColumn = new PgCommand(sql, connection); + selectColumn.Parameters.Add("@tableSchema", PgDbType.Text); + selectColumn.Parameters.Add("@tableName", PgDbType.Text); + selectColumn.Parameters.Add("@ordinalPosition", PgDbType.Text); + + selectColumn.Prepare(); + foreach (DataRow row in schema.Rows) { Array tableColumns = (Array)row["CONSTRAINT_TABLE_COLUMNS"]; @@ -98,22 +114,40 @@ { DataRow foreignKeyColumn = foreignKeyColumns.NewRow(); + // Grab the table column name + selectColumn.Parameters["@tableSchema"].Value = row["TABLE_SCHEMA"]; + selectColumn.Parameters["@tableName"].Value = row["TABLE_NAME"]; + selectColumn.Parameters["@ordinalPosition"].Value = Convert.ToInt16(tableColumns.GetValue(i + 1)); + + string tableColumn = (string)selectColumn.ExecuteScalar(); + + // Grab the referenced table column name + selectColumn.Parameters["@tableSchema"].Value = row["REFERENCED_TABLE_SCHEMA"]; + selectColumn.Parameters["@tableName"].Value = row["REFERENCED_TABLE_NAME"]; + selectColumn.Parameters["@ordinalPosition"].Value = Convert.ToInt16(referencedTableColumns.GetValue(i + 1)); + + string referencedTableColumn = (string)selectColumn.ExecuteScalar(); + + // Create the new foreign key column info foreignKeyColumn["CONSTRAINT_CATALOG"] = row["CONSTRAINT_CATALOG"]; foreignKeyColumn["CONSTRAINT_SCHEMA"] = row["CONSTRAINT_SCHEMA"]; foreignKeyColumn["CONSTRAINT_NAME"] = row["CONSTRAINT_NAME"]; foreignKeyColumn["TABLE_CATALOG"] = row["TABLE_CATALOG"]; foreignKeyColumn["TABLE_SCHEMA"] = row["TABLE_SCHEMA"]; foreignKeyColumn["TABLE_NAME"] = row["TABLE_NAME"]; - foreignKeyColumn["COLUMN_NAME"] = ""; + foreignKeyColumn["COLUMN_NAME"] = tableColumn; foreignKeyColumn["REFERENCED_TABLE_CATALOG"] = row["REFERENCED_TABLE_CATALOG"]; foreignKeyColumn["REFERENCED_TABLE_SCHEMA"] = row["REFERENCED_TABLE_SCHEMA"]; foreignKeyColumn["REFERENCED_TABLE_NAME"] = row["REFERENCED_TABLE_NAME"]; - foreignKeyColumn["REFERENCED_COLUMN_NAME"] = ""; + foreignKeyColumn["REFERENCED_COLUMN_NAME"] = referencedTableColumn; foreignKeyColumns.Rows.Add(foreignKeyColumn); } } + // CleanUp + selectColumn.Dispose(); + return foreignKeyColumns; } This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-27 12:13:29
|
Revision: 54 Author: carlosga_fb Date: 2006-03-27 04:13:20 -0800 (Mon, 27 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=54&view=rev Log Message: ----------- ?\194?\183 Changed the loop used in the IndexOf(string) method Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgParameterCollection.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgParameterCollection.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgParameterCollection.cs 2006-03-27 12:12:35 UTC (rev 53) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgParameterCollection.cs 2006-03-27 12:13:20 UTC (rev 54) @@ -221,18 +221,15 @@ public override int IndexOf(string parameterName) { - int index = 0; + for (int i = 0; i < this.Count; i++) + { + if (((PgParameter)this[i]).ParameterName == parameterName) + { + return i; + } + } - foreach (PgParameter item in this.parameters) - { - if (item.ParameterName == parameterName) - { - return index; - } - index++; - } - - return -1; + return -1; } public override void Insert(int index, object value) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <car...@us...> - 2006-03-27 12:12:45
|
Revision: 53 Author: carlosga_fb Date: 2006-03-27 04:12:35 -0800 (Mon, 27 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=53&view=rev Log Message: ----------- ?\194?\183 Removed commented code Modified Paths: -------------- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgCommand.cs Modified: trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgCommand.cs =================================================================== --- trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgCommand.cs 2006-03-23 13:57:40 UTC (rev 52) +++ trunk/pgsqlclient/source/PostgreSql/Data/PostgreSqlClient/PgCommand.cs 2006-03-27 12:12:35 UTC (rev 53) @@ -406,33 +406,6 @@ this.InternalPrepare(); } - //public string GetCommandPlan(bool verbose) - //{ - // string plan; - - // this.CheckCommand(); - - // try - // { - // if (this.statement == null) - // { - // this.statement = this.connection.InternalConnection.Database.CreateStatement(commandText); - // plan = this.statement.GetPlan(verbose); - // this.statement = null; - // } - // else - // { - // plan = this.statement.GetPlan(verbose); - // } - // } - // catch (PgClientException ex) - // { - // throw new PgException(ex.Message, ex); - // } - - // return plan; - //} - #endregion #region \xB7 Internal Methods \xB7 This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
