pgsqlclient-checkins Mailing List for PostgreSqlClient (Page 51)
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...> - 2003-07-30 19:09:20
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv3191 Modified Files: changes.txt Log Message: Updated changes.txt Index: changes.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changes.txt,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** changes.txt 30 Jul 2003 17:41:25 -0000 1.2 --- changes.txt 30 Jul 2003 18:38:21 -0000 1.3 *************** *** 8,11 **** --- 8,13 ---- * Better fit to ADO .NET + * Improved NUnit test suite. + * Added support for Function calls using CommandType.StoredProcedure. *************** *** 15,18 **** --- 17,23 ---- * Added implementation for PGCommandBuilder.DeriveParameters method. + + * PGCommandBuilder is now working better. + |
|
From: <car...@us...> - 2003-07-30 19:04:05
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source In directory sc8-pr-cvs1:/tmp/cvs-serv3662 Added Files: PGCommandBuilderTest.cs Log Message: Added new NUnit test for PGCommandBuilder class. --- NEW FILE: PGCommandBuilderTest.cs --- (This appears to be a binary file; contents omitted.) |
|
From: <car...@us...> - 2003-07-30 18:58:24
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv7140 Modified Files: changelog.txt Log Message: Updated changelog.txt Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v retrieving revision 1.34 retrieving revision 1.35 diff -C2 -d -r1.34 -r1.35 *** changelog.txt 30 Jul 2003 18:38:48 -0000 1.34 --- changelog.txt 30 Jul 2003 18:58:21 -0000 1.35 *************** *** 7,10 **** --- 7,14 ---- * Added NUnit test suite for PGCommandBuilder class. + * source/PGCommandBuilder.cs: + + - Fixed handling of expression columns at checkSchemaTable method ( error #780423 ). + * source/FbConnection.cs: |
|
From: <car...@us...> - 2003-07-30 18:57:30
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source
In directory sc8-pr-cvs1:/tmp/cvs-serv6501
Modified Files:
PGCommandBuilderTest.cs
Log Message:
Fixed handling of expression columns at checkSchemaTable method
Index: PGCommandBuilderTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGCommandBuilderTest.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** PGCommandBuilderTest.cs 30 Jul 2003 18:40:30 -0000 1.1
--- PGCommandBuilderTest.cs 30 Jul 2003 18:54:36 -0000 1.2
***************
*** 92,96 ****
Console.WriteLine(builder.GetDeleteCommand().CommandText);
! adapter.SelectCommand.CommandText = "select int4_field, date_field from TEST_TABLE_01 where int4_field = @int4_field";
builder.RefreshSchema();
--- 92,96 ----
Console.WriteLine(builder.GetDeleteCommand().CommandText);
! adapter.SelectCommand.CommandText = "select int4_field, date_field from public.test_table where int4_field = @int4_field";
builder.RefreshSchema();
***************
*** 111,115 ****
public void CommandBuilderWithExpressionFieldTest()
{
! PGCommand command = new PGCommand("select *, o AS EXPR_VALUE from public.test_table where int4_field = @int4_field and varchar_field = @varchar_field", Connection);
PGDataAdapter adapter = new PGDataAdapter(command);
PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 111,115 ----
public void CommandBuilderWithExpressionFieldTest()
{
! PGCommand command = new PGCommand("select public.test_table.*, 0 AS EXPR_VALUE from public.test_table where int4_field = @int4_field and varchar_field = @varchar_field", Connection);
PGDataAdapter adapter = new PGDataAdapter(command);
PGCommandBuilder builder = new PGCommandBuilder(adapter);
|
|
From: <car...@us...> - 2003-07-30 18:56:01
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv3279 Modified Files: changelog.txt Log Message: Updated changelog.txt Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v retrieving revision 1.33 retrieving revision 1.34 diff -C2 -d -r1.33 -r1.34 *** changelog.txt 30 Jul 2003 17:36:25 -0000 1.33 --- changelog.txt 30 Jul 2003 18:38:48 -0000 1.34 *************** *** 5,8 **** --- 5,14 ---- 2003-07-30 Carlos Guzmán Álvarez <car...@te...> + * Added NUnit test suite for PGCommandBuilder class. + + * source/FbConnection.cs: + + - Fixed some problems with named parameters that mades the CommandBuilder to non work ( error #780409 ). + * source/FbConnection.cs: |
|
From: <car...@us...> - 2003-07-30 18:39:35
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source
In directory sc8-pr-cvs1:/tmp/cvs-serv3457
Modified Files:
PGBaseTest.cs
Log Message:
Added creation of a new function for use with DeriveParameters test
Index: PGBaseTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGBaseTest.cs,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** PGBaseTest.cs 28 Jul 2003 18:26:41 -0000 1.9
--- PGBaseTest.cs 30 Jul 2003 18:39:32 -0000 1.10
***************
*** 170,173 ****
--- 170,185 ----
PGCommand command = new PGCommand(commandText.ToString(), connection);
command.ExecuteNonQuery();
+
+ commandText = new StringBuilder();
+ commandText.Append("CREATE OR REPLACE FUNCTION public.DeriveCount(int4)");
+ commandText.Append("RETURNS int8 AS");
+ commandText.Append("'");
+ commandText.Append("select count(*) from test_table where int4_field < $1;");
+ commandText.Append("'");
+ commandText.Append("LANGUAGE 'sql' VOLATILE;");
+
+ command.CommandText = commandText.ToString();
+ command.ExecuteNonQuery();
+
command.Dispose();
}
|
|
From: <car...@us...> - 2003-07-30 18:34:48
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv2408
Modified Files:
PGCommand.cs
Log Message:
Fixed some problems with named parameters
that mades the CommandBuilder to non work.
Index: PGCommand.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGCommand.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** PGCommand.cs 28 Jul 2003 12:18:48 -0000 1.5
--- PGCommand.cs 30 Jul 2003 18:34:45 -0000 1.6
***************
*** 467,474 ****
}
! if (parameters.Count != 0)
{
- // Get named parameters in CommandText
- namedParameters = search.Matches(CommandText);
// Subst parameterNames with $position
parseParameterNames();
--- 467,475 ----
}
! // Get named parameters in CommandText
! namedParameters = search.Matches(CommandText);
!
! if (parameters.Count != 0 || namedParameters.Count != 0)
{
// Subst parameterNames with $position
parseParameterNames();
***************
*** 591,595 ****
private void parseParameterNames()
{
! if (parameters.Count != 0 && namedParameters.Count != 0)
{
for (int i = 0; i < namedParameters.Count; i++)
--- 592,596 ----
private void parseParameterNames()
{
! if (namedParameters.Count != 0)
{
for (int i = 0; i < namedParameters.Count; i++)
|
|
From: <car...@us...> - 2003-07-30 17:41:28
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv24203 Modified Files: changes.txt Log Message: Updated changes.txt Index: changes.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changes.txt,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** changes.txt 24 Jul 2003 11:02:22 -0000 1.1 --- changes.txt 30 Jul 2003 17:41:25 -0000 1.2 *************** *** 3,4 **** --- 3,23 ---- + Alpha 2 ( XX-XX-2003 ) + ----- - - -- -- ---- - + + * Better fit to ADO .NET + + * 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. + + + Alpha 2 ( 27-07-2003 ) + ----- - - -- -- ---- - + + + Initial release. \ No newline at end of file |
|
From: <car...@us...> - 2003-07-30 17:36:28
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv23272 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v retrieving revision 1.32 retrieving revision 1.33 diff -C2 -d -r1.32 -r1.33 *** changelog.txt 29 Jul 2003 23:26:41 -0000 1.32 --- changelog.txt 30 Jul 2003 17:36:25 -0000 1.33 *************** *** 9,12 **** --- 9,16 ---- - Added implementation for ChangeDatabase. + * source/FbCommandBuilder.cs: + + - Added implementation for DereiveParameters method ( non tested yet ) + 2003-07-29 Carlos Guzmán Álvarez <car...@te...> |
|
From: <car...@us...> - 2003-07-30 17:36:12
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv23205
Modified Files:
PGCommandBuilder.cs
Log Message:
Added implementation for DereiveParameters method ( non tested yet )
Index: PGCommandBuilder.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGCommandBuilder.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PGCommandBuilder.cs 16 Jul 2003 20:17:49 -0000 1.4
--- PGCommandBuilder.cs 30 Jul 2003 17:36:08 -0000 1.5
***************
*** 186,190 ****
public static void DeriveParameters(PGCommand command)
{
! /* TODO: Add implementation */
}
--- 186,232 ----
public static void DeriveParameters(PGCommand command)
{
! if (command.CommandType != CommandType.StoredProcedure)
! {
! throw new InvalidOperationException("The command text is not a valid stored procedure name.");
! }
!
! command.Parameters.Clear();
! command.Prepare();
!
! int index = 0;
!
! // Derive input parameters
! if (command.Statement.Parameters != null)
! {
! for (int i = 0; i < command.Statement.Parameters.Length; i++)
! {
! PGType type = command.Statement.Parameters[i].DataType;
!
! PGParameter parameter = new PGParameter();
! parameter.ParameterName = "@ip" + i.ToString();
! parameter.DbType = type.DbType;
!
! command.Parameters.Add(parameter);
! }
!
! index = command.Parameters.Count;
! }
!
! if (command.Statement.RowDescriptor != null)
! {
! // Derive output parameters
! for (int i = 0; i < command.Statement.RowDescriptor.Fields.Length; i++)
! {
! PGType type = command.Statement.RowDescriptor.Fields[i].DataType;
!
! PGParameter parameter = new PGParameter();
! parameter.ParameterName = "@ip" + i.ToString();
! parameter.DbType = type.DbType;
!
! command.Parameters.Add(parameter);
!
! index++;
! }
! }
}
|
|
From: <car...@us...> - 2003-07-29 23:26:44
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv4511 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v retrieving revision 1.31 retrieving revision 1.32 diff -C2 -d -r1.31 -r1.32 *** changelog.txt 29 Jul 2003 17:05:23 -0000 1.31 --- changelog.txt 29 Jul 2003 23:26:41 -0000 1.32 *************** *** 2,5 **** --- 2,13 ---- ------------------------------------------------------- + + 2003-07-30 Carlos Guzmán Álvarez <car...@te...> + + * source/FbConnection.cs: + + - Added implementation for ChangeDatabase. + + 2003-07-29 Carlos Guzmán Álvarez <car...@te...> |
|
From: <car...@us...> - 2003-07-29 23:26:15
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv4429
Modified Files:
PGConnection.cs
Log Message:
Added implementation for ChangeDatabase.
Index: PGConnection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGConnection.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGConnection.cs 16 Jul 2003 19:33:21 -0000 1.3
--- PGConnection.cs 29 Jul 2003 23:26:12 -0000 1.4
***************
*** 311,315 ****
public void ChangeDatabase(string db)
{
! /* TODO: Implementation */
}
--- 311,347 ----
public void ChangeDatabase(string db)
{
! if (state == ConnectionState.Closed)
! {
! throw new InvalidOperationException("ChangeDatabase requires an open and available Connection.");
! }
!
! if (db == null || db.Trim().Length == 0)
! {
! throw new InvalidOperationException("Database name is not valid.");
! }
!
! if (this.DataReader != null)
! {
! throw new InvalidOperationException("ChangeDatabase requires an open and available Connection. The connection's current state is Open, Fetching.");
! }
!
! string oldDb = this.dbConnection.Settings.Database;
!
! try
! {
! /* Close current connection */
! this.Close();
!
! /* Set up the new Database */
! this.dbConnection.Settings.Database = db;
!
! /* Open new connection to new database */
! this.Open();
! }
! catch (PGException ex)
! {
! this.dbConnection.Settings.Database = oldDb;
! throw ex;
! }
}
|
|
From: <car...@us...> - 2003-07-29 22:32:47
|
Update of /cvsroot/pgsqlclient/pgsqlclient/WindowsSetup
In directory sc8-pr-cvs1:/tmp/cvs-serv16350
Modified Files:
PGSqlClientSetup.gi2
Log Message:
Minor changes on AppID and AppName variables
Index: PGSqlClientSetup.gi2
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/WindowsSetup/PGSqlClientSetup.gi2,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** PGSqlClientSetup.gi2 24 Jul 2003 11:00:32 -0000 1.1
--- PGSqlClientSetup.gi2 29 Jul 2003 17:06:56 -0000 1.2
***************
*** 100,105 ****
</launchconditions-->
<variables>
! <var name="AppID" value="PGSqlClient .NET Data Provider 1.0 Alpha 1" />
! <var name="AppName" value="PGSqlClient .NET Data Provider 1.0 Alpha 1" />
<var name="OutputPath" value="Output" type="normal"/>
<var name="Password" type="normal"/>
--- 100,105 ----
</launchconditions-->
<variables>
! <var name="AppID" value="PGSqlClient ADO.NET Data Provider 1.0 Alpha 1" />
! <var name="AppName" value="PGSqlClient ADO.NET Data Provider 1.0 Alpha 1" />
<var name="OutputPath" value="Output" type="normal"/>
<var name="Password" type="normal"/>
|
|
From: <car...@us...> - 2003-07-29 17:55:13
|
Update of /cvsroot/pgsqlclient/pgsqlclient/Doc In directory sc8-pr-cvs1:/tmp/cvs-serv15706 Added Files: C_Sharp_Naming_Guidelines.pdf Log Message: Added C Sharp Naming guidelines PDF --- NEW FILE: C_Sharp_Naming_Guidelines.pdf --- (This appears to be a binary file; contents omitted.) |
|
From: <car...@us...> - 2003-07-29 17:18:00
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv15964 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v retrieving revision 1.30 retrieving revision 1.31 diff -C2 -d -r1.30 -r1.31 *** changelog.txt 29 Jul 2003 10:16:26 -0000 1.30 --- changelog.txt 29 Jul 2003 17:05:23 -0000 1.31 *************** *** 2,7 **** ------------------------------------------------------- - 2003-07-29 Carlos Guzmán Álvarez <car...@te...> * Changed cultureAwareCompare method in PGDataReader and all Collection classes for use it in a better way, --- 2,8 ---- ------------------------------------------------------- 2003-07-29 Carlos Guzmán Álvarez <car...@te...> + + * Added C Sharp Naming guidelines PDF. * Changed cultureAwareCompare method in PGDataReader and all Collection classes for use it in a better way, |
|
From: <car...@us...> - 2003-07-29 17:07:55
|
Update of /cvsroot/pgsqlclient/pgsqlclient/Doc In directory sc8-pr-cvs1:/tmp/cvs-serv15481/Doc Log Message: Directory /cvsroot/pgsqlclient/pgsqlclient/Doc added to the repository |
|
From: <car...@us...> - 2003-07-29 10:16:29
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv1657 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v retrieving revision 1.29 retrieving revision 1.30 diff -C2 -d -r1.29 -r1.30 *** changelog.txt 29 Jul 2003 09:26:52 -0000 1.29 --- changelog.txt 29 Jul 2003 10:16:26 -0000 1.30 *************** *** 5,8 **** --- 5,11 ---- 2003-07-29 Carlos Guzmán Álvarez <car...@te...> + * 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: |
|
From: <car...@us...> - 2003-07-29 10:15:43
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient
In directory sc8-pr-cvs1:/tmp/cvs-serv1525
Modified Files:
PGTypeCollection.cs
Log Message:
* Changed cultureAwareCompare method in PGDataReader and all Collection classes for use it in a better way,
and allow it to run on Mono::
Index: PGTypeCollection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGTypeCollection.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGTypeCollection.cs 14 Jul 2003 11:59:44 -0000 1.2
--- PGTypeCollection.cs 29 Jul 2003 10:15:40 -0000 1.3
***************
*** 74,78 ****
foreach(PGType item in this)
{
! if (_cultureAwareCompare(item.Name, name) == 0)
{
return index;
--- 74,78 ----
foreach(PGType item in this)
{
! if (cultureAwareCompare(item.Name, name))
{
return index;
***************
*** 118,124 ****
}
! private int _cultureAwareCompare(string strA, string strB)
{
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase);
}
--- 118,131 ----
}
! private bool cultureAwareCompare(string strA, string strB)
{
! try
! {
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase) == 0 ? true : false;
! }
! catch (NotSupportedException)
! {
! return strA.ToUpper() == strB.ToUpper() ? true : false;
! }
}
|
|
From: <car...@us...> - 2003-07-29 10:15:19
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient
In directory sc8-pr-cvs1:/tmp/cvs-serv1416
Modified Files:
PGCharSetCollection.cs PGClientErrorCollection.cs
Log Message:
* Changed cultureAwareCompare method in PGDataReader and all Collection classes for use it in a better way,
and allow it to run on Mono::
Index: PGCharSetCollection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGCharSetCollection.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGCharSetCollection.cs 12 Jul 2003 08:11:22 -0000 1.1.1.1
--- PGCharSetCollection.cs 29 Jul 2003 10:15:08 -0000 1.2
***************
*** 54,58 ****
foreach(PGCharSet item in this)
{
! if (_cultureAwareCompare(item.CharSet, charset) == 0)
{
return index;
--- 54,58 ----
foreach(PGCharSet item in this)
{
! if (cultureAwareCompare(item.CharSet, charset))
{
return index;
***************
*** 93,99 ****
}
! private int _cultureAwareCompare(string strA, string strB)
{
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase);
}
--- 93,106 ----
}
! private bool cultureAwareCompare(string strA, string strB)
{
! try
! {
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase) == 0 ? true : false;
! }
! catch (NotSupportedException)
! {
! return strA.ToUpper() == strB.ToUpper() ? true : false;
! }
}
Index: PGClientErrorCollection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/NPGClient/PGClientErrorCollection.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** PGClientErrorCollection.cs 12 Jul 2003 08:11:22 -0000 1.1.1.1
--- PGClientErrorCollection.cs 29 Jul 2003 10:15:08 -0000 1.2
***************
*** 53,57 ****
foreach(PGClientError item in this)
{
! if (0 == _cultureAwareCompare(item.Message, errorMessage))
{
return index;
--- 53,57 ----
foreach(PGClientError item in this)
{
! if (cultureAwareCompare(item.Message, errorMessage))
{
return index;
***************
*** 81,87 ****
}
! private int _cultureAwareCompare(string strA, string strB)
{
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase);
}
--- 81,94 ----
}
! private bool cultureAwareCompare(string strA, string strB)
{
! try
! {
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase) == 0 ? true : false;
! }
! catch (NotSupportedException)
! {
! return strA.ToUpper() == strB.ToUpper() ? true : false;
! }
}
|
|
From: <car...@us...> - 2003-07-29 10:14:56
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv1312
Modified Files:
PGDataReader.cs PGErrorCollection.cs PGParameterCollection.cs
Log Message:
* Changed cultureAwareCompare method in PGDataReader and all Collection classes for use it in a better way,
and allow it to run on Mono::
Index: PGDataReader.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGDataReader.cs,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** PGDataReader.cs 29 Jul 2003 09:26:20 -0000 1.9
--- PGDataReader.cs 29 Jul 2003 10:14:53 -0000 1.10
***************
*** 776,780 ****
private bool cultureAwareCompare(string strA, string strB)
{
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase) == 0 ? true : false;
}
--- 776,787 ----
private bool cultureAwareCompare(string strA, string strB)
{
! try
! {
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase) == 0 ? true : false;
! }
! catch (NotSupportedException)
! {
! return strA.ToUpper() == strB.ToUpper() ? true : false;
! }
}
Index: PGErrorCollection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGErrorCollection.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PGErrorCollection.cs 16 Jul 2003 20:17:49 -0000 1.2
--- PGErrorCollection.cs 29 Jul 2003 10:14:53 -0000 1.3
***************
*** 102,106 ****
private bool cultureAwareCompare(string strA, string strB)
{
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase) == 0 ? true : false;
}
--- 102,113 ----
private bool cultureAwareCompare(string strA, string strB)
{
! try
! {
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase) == 0 ? true : false;
! }
! catch (NotSupportedException)
! {
! return strA.ToUpper() == strB.ToUpper() ? true : false;
! }
}
Index: PGParameterCollection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGParameterCollection.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** PGParameterCollection.cs 27 Jul 2003 21:19:17 -0000 1.3
--- PGParameterCollection.cs 29 Jul 2003 10:14:53 -0000 1.4
***************
*** 253,257 ****
private bool cultureAwareCompare(string strA, string strB)
{
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase) == 0 ? true : false;
}
--- 253,264 ----
private bool cultureAwareCompare(string strA, string strB)
{
! try
! {
! return CultureInfo.CurrentCulture.CompareInfo.Compare(strA, strB, CompareOptions.IgnoreKanaType | CompareOptions.IgnoreWidth | CompareOptions.IgnoreCase) == 0 ? true : false;
! }
! catch (NotSupportedException)
! {
! return strA.ToUpper() == strB.ToUpper() ? true : false;
! }
}
|
|
From: <car...@us...> - 2003-07-29 09:26:55
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv26351 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v retrieving revision 1.28 retrieving revision 1.29 diff -C2 -d -r1.28 -r1.29 *** changelog.txt 28 Jul 2003 18:27:13 -0000 1.28 --- changelog.txt 29 Jul 2003 09:26:52 -0000 1.29 *************** *** 3,6 **** --- 3,14 ---- + 2003-07-29 Carlos Guzmán Álvarez <car...@te...> + + * source/FbDataReader.cs: + + - Changed the way for update RecordsAffected property value, making it + at Close and NextResult methods. + + 2003-07-28 Carlos Guzmán Álvarez <car...@te...> |
|
From: <car...@us...> - 2003-07-29 09:26:24
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv26253
Modified Files:
PGDataReader.cs
Log Message:
- Changed the way for update RecordsAffected property value, making it at Close and NextResult methods.
Index: PGDataReader.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient/source/PGDataReader.cs,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** PGDataReader.cs 28 Jul 2003 12:18:48 -0000 1.8
--- PGDataReader.cs 29 Jul 2003 09:26:20 -0000 1.9
***************
*** 60,65 ****
this.command = command;
-
- updateRecordsAffected();
}
--- 60,63 ----
***************
*** 135,138 ****
--- 133,139 ----
}
+ // This will update RecordsAffected property
+ updateRecordsAffected();
+
if (command != null)
{
***************
*** 168,176 ****
}
bool returnValue = command.NextResult();
if (returnValue)
{
- updateRecordsAffected();
position = STARTPOS;
}
--- 169,178 ----
}
+ updateRecordsAffected();
+
bool returnValue = command.NextResult();
if (returnValue)
{
position = STARTPOS;
}
|
|
From: <car...@us...> - 2003-07-28 18:27:16
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv29311 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT file Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v retrieving revision 1.27 retrieving revision 1.28 diff -C2 -d -r1.27 -r1.28 *** changelog.txt 28 Jul 2003 12:19:10 -0000 1.27 --- changelog.txt 28 Jul 2003 18:27:13 -0000 1.28 *************** *** 5,8 **** --- 5,10 ---- 2003-07-28 Carlos Guzmán Álvarez <car...@te...> + * Added new NUnit test for function calls (Stored procedure calls). + * source/FbCommand.cs: * source/FbDataReader.cs: |
|
From: <car...@us...> - 2003-07-28 18:26:44
|
Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source
In directory sc8-pr-cvs1:/tmp/cvs-serv29202
Modified Files:
PGBaseTest.cs PGCommandTest.cs
Log Message:
Added new NUnit test for function calls (Stored procedure calls).
Index: PGBaseTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGBaseTest.cs,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** PGBaseTest.cs 26 Jul 2003 12:48:22 -0000 1.8
--- PGBaseTest.cs 28 Jul 2003 18:26:41 -0000 1.9
***************
*** 58,61 ****
--- 58,62 ----
createTables();
+ createFunctions();
}
***************
*** 154,157 ****
--- 155,174 ----
insertTestData();
+ }
+
+ private void createFunctions()
+ {
+ StringBuilder commandText = new StringBuilder();
+
+ commandText.Append("CREATE OR REPLACE FUNCTION public.TestCount()");
+ commandText.Append("RETURNS int8 AS");
+ commandText.Append("'");
+ commandText.Append("select count(*) from test_table;");
+ commandText.Append("'");
+ commandText.Append("LANGUAGE 'sql' VOLATILE;");
+
+ PGCommand command = new PGCommand(commandText.ToString(), connection);
+ command.ExecuteNonQuery();
+ command.Dispose();
}
Index: PGCommandTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGCommandTest.cs,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** PGCommandTest.cs 26 Jul 2003 12:30:31 -0000 1.7
--- PGCommandTest.cs 28 Jul 2003 18:26:41 -0000 1.8
***************
*** 150,156 ****
[Test]
- [Ignore("Not implemented.")]
public void ExecuteStoredProcTest()
! {
}
--- 150,165 ----
[Test]
public void ExecuteStoredProcTest()
! {
! PGCommand command = new PGCommand("TestCount()", Connection);
! command.CommandType = CommandType.StoredProcedure;
!
! command.Parameters.Add("@CountResult", PGDbType.Int8).Direction = ParameterDirection.Output;
!
! command.ExecuteNonQuery();
!
! Console.WriteLine("ExecuteStoredProcTest - Count result {0}", command.Parameters[0].Value);
!
! command.Dispose();
}
|
|
From: <car...@us...> - 2003-07-28 12:19:13
|
Update of /cvsroot/pgsqlclient/pgsqlclient In directory sc8-pr-cvs1:/tmp/cvs-serv29850 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient/changelog.txt,v retrieving revision 1.26 retrieving revision 1.27 diff -C2 -d -r1.26 -r1.27 *** changelog.txt 27 Jul 2003 21:21:07 -0000 1.26 --- changelog.txt 28 Jul 2003 12:19:10 -0000 1.27 *************** *** 2,5 **** --- 2,15 ---- ------------------------------------------------------- + + 2003-07-28 Carlos Guzmán Álvarez <car...@te...> + + * source/FbCommand.cs: + * source/FbDataReader.cs: + + - Added support for Function calls using CommandType.StoredProcedure. + + + 2003-07-27 Carlos Guzmán Álvarez <car...@te...> |
