pgsqlclient-checkins Mailing List for PostgreSqlClient (Page 43)
Status: Inactive
Brought to you by:
carlosga_fb
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-10-01 21:39:37
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/NPgClient
In directory sc8-pr-cvs1:/tmp/cvs-serv8230
Modified Files:
PgOutputPacket.cs
Log Message:
- Added better handling of array parameters.
Index: PgOutputPacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/NPgClient/PgOutputPacket.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** PgOutputPacket.cs 29 Sep 2003 14:33:01 -0000 1.5
--- PgOutputPacket.cs 1 Oct 2003 20:41:47 -0000 1.6
***************
*** 183,190 ****
}
! // Write array values (at this moment only for first dimension)
! for (int i = array.GetLowerBound(0); i < array.GetLength(0); i++)
{
! this.writeParameter(packet, elementType.DbType, size, array.GetValue(i));
}
--- 183,190 ----
}
! // Write array values
! foreach (object element in array)
{
! this.writeParameter(packet, elementType.DbType, size, element);
}
|
|
From: <car...@us...> - 2003-10-01 21:02:51
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv8322 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/changelog.txt,v retrieving revision 1.32 retrieving revision 1.33 diff -C2 -d -r1.32 -r1.33 *** changelog.txt 29 Sep 2003 18:16:40 -0000 1.32 --- changelog.txt 1 Oct 2003 20:42:13 -0000 1.33 *************** *** 2,5 **** --- 2,13 ---- ------------------------------------------------------- + + 2003-10-01 Carlos Guzmán Álvarez <car...@te...> + + * source/NpgClient/PgOutputPacket.cs: + + - Added better handling of array parameters. + + 2003-09-29 Carlos Guzmán Álvarez <car...@te...> |
|
From: <car...@us...> - 2003-10-01 10:32:40
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10
In directory sc8-pr-cvs1:/tmp/cvs-serv6681
Modified Files:
PgSqlClient.build
Log Message:
Continue rework of build system for Windows
Index: PgSqlClient.build
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PgSqlClient.build,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PgSqlClient.build 30 Sep 2003 19:54:35 -0000 1.4
--- PgSqlClient.build 1 Oct 2003 10:32:37 -0000 1.5
***************
*** 115,127 ****
<property name="nant.settings.currentframework" value="mono-1.0" />
<echo message="Building using Mono 1.0." />
! <call target="build-provider" />
! <if propertyexists="nunit.framework.dll">
! <call target="build-nunit-tests" />
! </if>
</if>
- <call target="distribution" />
</target>
! <!-- Taget for build TLS Assembly -->
<target name="build-tls">
<property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" />
--- 115,123 ----
<property name="nant.settings.currentframework" value="mono-1.0" />
<echo message="Building using Mono 1.0." />
! <call target="build-provider-mono" />
</if>
</target>
! <!-- Taget for build TLS Assembly (Microsoft .NET) -->
<target name="build-tls">
<property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" />
***************
*** 144,148 ****
</target>
! <!-- Taget for build PgSqlClient .NET Data Provider Assembly -->
<target name="build-provider" depends="build-tls">
<property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" />
--- 140,144 ----
</target>
! <!-- Taget for build PgSqlClient Data Provider (Microsoft .NET)-->
<target name="build-provider" depends="build-tls">
<property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" />
***************
*** 158,161 ****
--- 154,202 ----
<absolute file="System.Drawing.dll" />
<absolute file="System.XML.dll" />
+ <includes name="${build.dir}/System.Security.Tls.dll" />
+ </references>
+ <arg value="/resource:${resources.dir}\Toolbox\PgConnection.bmp,PostgreSql.Data.PgSqlClient.Resources.ToolBox.PgConnection.bmp" />
+ <arg value="/resource:${resources.dir}\Toolbox\PgCommand.bmp,PostgreSql.Data.PgSqlClient.Resources.ToolBox.PgCommand.bmp" />
+ <arg value="/resource:${resources.dir}\Toolbox\PgDataAdapter.bmp,PostgreSql.Data.PgSqlClient.Resources.ToolBox.PgDataAdapter.bmp" />
+ <arg value="/optimize+" />
+ </csc>
+ </target>
+
+ <!-- Taget for build TLS Assembly (mono::)-->
+ <target name="build-tls-mono">
+ <property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" />
+
+ <mkdir dir="${build.dir}" failonerror="false" />
+
+ <!-- compile System.Security.TLS -->
+ <csc output="${build.dir}\System.Security.Tls.dll" target="library" define="${build.define}">
+ <sources>
+ <includes name="${tls.src.dir}/**/*.cs" />
+ </sources>
+
+ <references>
+ <includes name="${nant.settings.currentframework.frameworkassemblydirectory}/System.dll" />
+ <includes name="${nant.settings.currentframework.frameworkassemblydirectory}/System.Data.dll" />
+ <includes name="${nant.settings.currentframework.frameworkassemblydirectory}/System.Drawing.dll" />
+ <includes name="${nant.settings.currentframework.frameworkassemblydirectory}/System.XML.dll" />
+ </references>
+ <arg value="/optimize+" />
+ </csc>
+ </target>
+
+ <!-- Taget for build PgSqlClient Data Provider Assembly (mono::) -->
+ <target name="build-provider-mono" depends="build-tls-mono">
+ <property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" />
+
+ <!-- compile PostgreSql.Data.PgSqlClient -->
+ <csc output="${build.dir}\${project.FormalName}.dll" target="library" define="${build.define}">
+ <sources>
+ <includes name="${src.dir}/**/*.cs" />
+ </sources>
+ <references>
+ <includes name="${nant.settings.currentframework.frameworkassemblydirectory}/System.dll" />
+ <includes name="${nant.settings.currentframework.frameworkassemblydirectory}/System.Data.dll" />
+ <includes name="${nant.settings.currentframework.frameworkassemblydirectory}/System.Drawing.dll" />
+ <includes name="${nant.settings.currentframework.frameworkassemblydirectory}/System.XML.dll" />
<includes name="${build.dir}/System.Security.Tls.dll" />
</references>
|
|
From: <car...@us...> - 2003-09-30 19:55:36
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv14211 Added Files: System.Security.Tls.snk Log Message: added key pair for the TLS library --- NEW FILE: System.Security.Tls.snk --- (This appears to be a binary file; contents omitted.) |
|
From: <car...@us...> - 2003-09-30 19:54:39
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv14057 Modified Files: PgSqlClient.build Added Files: Build.bat Log Message: Reworked build system for Windows --- NEW FILE: Build.bat --- nant -buildfile:PgSqlClient.build -verbose %1 %2 %3 %4 Index: PgSqlClient.build =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PgSqlClient.build,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** PgSqlClient.build 12 Sep 2003 20:47:43 -0000 1.3 --- PgSqlClient.build 30 Sep 2003 19:54:35 -0000 1.4 *************** *** 1,26 **** ! <?xml version="1.0" ?> ! <project name="PgSqlClient" default="build-all" basedir="." xmlnds="http://tempuri.org/nant-vs.xsd"> <!-- Project properties --> <property name="project.name" value="PgSqlClient" /> <property name="project.FormalName" value="PostgreSql.Data.PgSqlClient" /> <property name="project.version" value="1.0" /> ! <!-- Build properties --> <property name="build.debug" value="true" /> <property name="build.define" value="_DEBUG" /> ! <!-- Paths properties --> <property name="base.dir" value="." /> ! <property name="build.dir" value="build" /> ! <property name="src.dir" value="${project.FormalName}\source" /> <property name="tls.src.dir" value="PgSqlClient.Security.Tls\source" /> ! <property name="nunit.test.dir" value="PostgreSql.Data.PgSqlClient.UnitTests"/> <property name="resources.dir" value="${src.dir}\Resources" /> ! <property name="distribution.dir" value="${build.dir}\distribution" /> <!-- Check for Html Help Compiler --> <target name="check-htmlhelp-compiler"> <ifnot propertyexists="htmlhelp.compiler"> ! <readregistry property="htmlhelp.workshop.installroot" key="SOFTWARE\Microsoft\HTML Help Workshop\InstallDir" hive="CurrentUser" failonerror="false" /> <if propertyexists="htmlhelp.workshop.installroot"> <property name="htmlhelp.compiler" value="${htmlhelp.workshop.installroot}\hhc.exe" readonly="false" /> --- 1,28 ---- ! <?xml version="1.0" encoding="utf-8" ?> ! <project name="PgSqlClient" default="release" basedir="." xmlnds="http://tempuri.org/nant-vs.xsd"> <!-- Project properties --> <property name="project.name" value="PgSqlClient" /> <property name="project.FormalName" value="PostgreSql.Data.PgSqlClient" /> <property name="project.version" value="1.0" /> ! <!-- Build properties --> <property name="build.debug" value="true" /> <property name="build.define" value="_DEBUG" /> ! <!-- Paths properties --> <property name="base.dir" value="." /> ! <property name="base.build.dir" value="build" /> ! <property name="build.dir" value="${base.build.dir}" /> ! <property name="tls.src.dir" value="PgSqlClient.Security.Tls\source" /> ! <property name="src.dir" value="${project.FormalName}\source" /> <property name="resources.dir" value="${src.dir}\Resources" /> ! <property name="nunit.test.dir" value="PostgreSql.Data.PgSqlClient.UnitTests\source"/> <!-- Check for Html Help Compiler --> <target name="check-htmlhelp-compiler"> <ifnot propertyexists="htmlhelp.compiler"> ! <readregistry property="htmlhelp.workshop.installroot" key="SOFTWARE\Microsoft\HTML Help Workshop\InstallDir" ! hive="CurrentUser" failonerror="false" /> <if propertyexists="htmlhelp.workshop.installroot"> <property name="htmlhelp.compiler" value="${htmlhelp.workshop.installroot}\hhc.exe" readonly="false" /> *************** *** 29,33 **** <ifnot propertyexists="htmlhelp.compiler"> <sysinfo /> ! <property name="htmlhelp.compiler" value="${sys.os.folder.programfiles}\HTML Help Workshop\hhc.exe" readonly="false" /> </ifnot> </target> --- 31,36 ---- <ifnot propertyexists="htmlhelp.compiler"> <sysinfo /> ! <property name="htmlhelp.compiler" value="${sys.os.folder.programfiles}\HTML Help Workshop\hhc.exe" ! readonly="false" /> </ifnot> </target> *************** *** 41,47 **** </ifnot> </target> ! <!-- Displays configuration info, usefull for working out why PgSqlClient doesn't build --> ! <target name="display-setup" depends="check-nunit-framework"> <!-- .NET Framework 1.0 --> <available type="Framework" resource="net-1.0" property="temp.framework.available" /> --- 44,74 ---- </ifnot> </target> + + <!-- Target for check build configuration --> + <target name="check-build-config" depends="clean"> + <call target="check-htmlhelp-compiler" /> + <call target="check-nunit-framework" /> + </target> ! <!-- Target for clean destination directory --> ! <target name="clean" description="cleans build directory"> ! <delete dir="${build.dir}" failonerror="false" verbose="true" /> ! </target> ! ! <!-- Target for build in DEBUG mode --> ! <target name="debug" depends="clean"> ! <property name="build.debug" value="true" /> ! <call target="build-all" /> ! </target> ! ! <!-- Target for build in RELEASE mode --> ! <target name="release" depends="clean"> ! <property name="build.debug" value="false" /> ! <property name="build.define" value="_RELEASE" /> ! <call target="build-all" /> ! </target> ! ! <!-- Build target for all existing platforms --> ! <target name="build-all" depends="check-build-config"> <!-- .NET Framework 1.0 --> <available type="Framework" resource="net-1.0" property="temp.framework.available" /> *************** *** 51,56 **** <if propertytrue="temp.framework.available"> <property name="nant.settings.currentframework" value="net-1.0" /> ! <call target="display-current-runtime" force="true" /> </if> <!-- .NET Framework 1.1 --> <available type="Framework" resource="net-1.1" property="temp.framework.available" /> --- 78,92 ---- <if propertytrue="temp.framework.available"> <property name="nant.settings.currentframework" value="net-1.0" /> ! <echo message="Building using .NET Framework 1.0." /> ! <call target="build-provider" /> ! <if propertyexists="htmlhelp.compiler"> ! <!-- call target="build-sdk" / --> ! </if> ! <if propertyexists="nunit.framework.dll"> ! <call target="build-nunit-tests" /> ! </if> ! <call target="distribution" /> </if> + <!-- .NET Framework 1.1 --> <available type="Framework" resource="net-1.1" property="temp.framework.available" /> *************** *** 60,65 **** <if propertytrue="temp.framework.available"> <property name="nant.settings.currentframework" value="net-1.1" /> ! <call target="display-current-runtime" force="true" /> </if> <!-- Mono 1.0 --> <available type="Framework" resource="mono-1.0" property="temp.framework.available" /> --- 96,110 ---- <if propertytrue="temp.framework.available"> <property name="nant.settings.currentframework" value="net-1.1" /> ! <echo message="Building using .NET Framework 1.1." /> ! <call target="build-provider" /> ! <if propertyexists="htmlhelp.compiler"> ! <!-- call target="build-sdk" / --> ! </if> ! <if propertyexists="nunit.framework.dll"> ! <call target="build-nunit-tests" /> ! </if> ! <call target="distribution" /> </if> + <!-- Mono 1.0 --> <available type="Framework" resource="mono-1.0" property="temp.framework.available" /> *************** *** 69,137 **** <if propertytrue="temp.framework.available"> <property name="nant.settings.currentframework" value="mono-1.0" /> ! <call target="display-current-runtime" force="true" /> ! </if> ! <!-- SSCLI 1.0 --> ! <available type="Framework" resource="sscli-1.0" property="temp.framework.available" /> ! <ifnot propertytrue="temp.framework.available"> ! <echo message="SSCLI 1.0 runtime is not available." /> ! </ifnot> ! <if propertytrue="temp.framework.available"> ! <property name="nant.settings.currentframework" value="sscli-1.0" /> ! <call target="display-current-runtime" force="true" /> ! </if> ! <!-- HTML Help Compiler --> ! <echo message="" /> ! <echo message="----------------------------------------------------------" /> ! <echo message="" /> ! <echo message="htmlhelp.compiler: ${htmlhelp.compiler}" /> ! <echo message="" /> ! </target> ! ! <target name="display-current-runtime"> ! <echo message="" /> ! <echo message="----------------------------------------------------------" /> ! <echo message=" ${nant.settings.currentframework.description}" /> ! <echo message="----------------------------------------------------------" /> ! <echo message="" /> ! <echo message="framework : ${nant.settings.currentframework}" /> ! <echo message="description : ${nant.settings.currentframework.description}" /> ! <if propertyexists="nant.settings.currentframework.sdkdirectory"> ! <echo message="sdk directory : ${nant.settings.currentframework.sdkdirectory}" /> ! </if> ! <ifnot propertyexists="nant.settings.currentframework.sdkdirectory"> ! <echo message="sdk directory : <not configured/available>" /> ! </ifnot> ! <echo message="framework directory : ${nant.settings.currentframework.frameworkdirectory}" /> ! <echo message="assembly directory : ${nant.settings.currentframework.frameworkassemblydirectory}" /> ! <if propertyexists="nant.settings.currentframework.runtimeengine"> ! <echo message="runtime engine : ${nant.settings.currentframework.runtimeengine}" /> </if> ! <echo message="" /> ! </target> ! ! <!-- Target for check build configuration --> ! <target name="check-build-config" depends="clean"> ! <call target="display-setup" /> ! <!-- ${nant.settings.currentframework} --> </target> - <!-- Target for clean destination directory --> - <target name="clean" description="cleans build directory"> - <delete dir="${build.dir}" failonerror="false" verbose="true" /> - <delete dir="${distribution.dir}" failonerror="false" verbose="true" /> - </target> - - <!-- Target for check build configuration --> - <target name="build-all" depends="check-build-config"> - <call target="build-tls" /> - <call target="build-pgsqlclient" /> - <if propertyexists="nunit.framework.dll"> - <call target="build-nunit-tests" /> - </if> - <call target="distribution" /> - </target> - <!-- Taget for build TLS Assembly --> <target name="build-tls"> <mkdir dir="${build.dir}" failonerror="false" /> --- 114,130 ---- <if propertytrue="temp.framework.available"> <property name="nant.settings.currentframework" value="mono-1.0" /> ! <echo message="Building using Mono 1.0." /> ! <call target="build-provider" /> ! <if propertyexists="nunit.framework.dll"> ! <call target="build-nunit-tests" /> ! </if> </if> ! <call target="distribution" /> </target> <!-- Taget for build TLS Assembly --> <target name="build-tls"> + <property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" /> + <mkdir dir="${build.dir}" failonerror="false" /> *************** *** 152,158 **** <!-- Taget for build PgSqlClient .NET Data Provider Assembly --> ! <target name="build-pgsqlclient"> ! <mkdir dir="${build.dir}" failonerror="false" /> ! <!-- compile PostgreSql.Data.PgSqlClient --> <csc output="${build.dir}\${project.FormalName}.dll" target="library" define="${build.define}"> --- 145,151 ---- <!-- Taget for build PgSqlClient .NET Data Provider Assembly --> ! <target name="build-provider" depends="build-tls"> ! <property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" /> ! <!-- compile PostgreSql.Data.PgSqlClient --> <csc output="${build.dir}\${project.FormalName}.dll" target="library" define="${build.define}"> *************** *** 173,179 **** </csc> </target> ! <!-- Target for build csUnit Tests --> <target name="build-nunit-tests"> <copy todir="${build.dir}"> <fileset basedir="${nunit.test.dir}"> --- 166,174 ---- </csc> </target> ! <!-- Target for build csUnit Tests --> <target name="build-nunit-tests"> + <property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" /> + <copy todir="${build.dir}"> <fileset basedir="${nunit.test.dir}"> *************** *** 199,202 **** --- 194,200 ---- <!-- Target for distribution --> <target name="distribution"> + <property name="build.dir" value="${base.build.dir}\${nant.settings.currentframework}" /> + <property name="distribution.dir" value="${build.dir}\distribution" /> + <mkdir dir="${distribution.dir}" failonerror="false" /> <!-- Copy needed files to distribution directory --> *************** *** 214,216 **** </copy> </target> ! </project> \ No newline at end of file --- 212,214 ---- </copy> </target> ! </project> |
|
From: <car...@us...> - 2003-09-30 19:54:03
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv13942 Removed Files: DotNETBuild.bat MonoBuild.bat Log Message: Reworked build system for Windows --- DotNETBuild.bat DELETED --- --- MonoBuild.bat DELETED --- |
|
From: <car...@us...> - 2003-09-30 19:53:07
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv13772 Removed Files: PgSqlClient_Mono.build Log Message: Reworked build system for Windows --- PgSqlClient_Mono.build DELETED --- |
|
From: <car...@us...> - 2003-09-30 09:23:48
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PgSqlClient.Security.Tls/source
In directory sc8-pr-cvs1:/tmp/cvs-serv12727
Modified Files:
TlsSession.cs
Log Message:
- Added exception Handling to Open & Close methods.
- Reset isSecure field in closeStreams method.
Index: TlsSession.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PgSqlClient.Security.Tls/source/TlsSession.cs,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
*** TlsSession.cs 16 Sep 2003 12:28:28 -0000 1.18
--- TlsSession.cs 30 Sep 2003 09:23:45 -0000 1.19
***************
*** 153,177 ****
public void Open()
{
! this.socket.DoHandshake();
}
public void Close()
{
! if (isSecure)
{
! TlsCloseNotifyAlert alert = new TlsCloseNotifyAlert(this);
! // Write close notify
! this.socket.SendAlert(alert);
! // Check that the session is finished by the client and by server
! if (!this.context.ConnectionEnd)
! {
! throw new TlsException("Invalid session termination");
}
}
!
! // Close streams
! closeStreams();
}
--- 153,198 ----
public void Open()
{
! try
! {
! this.socket.DoHandshake();
! }
! catch (TlsException ex)
! {
! throw ex;
! }
! catch (Exception ex)
! {
! this.closeStreams();
! throw ex;
! }
}
public void Close()
{
! try
{
! if (isSecure)
! {
! TlsCloseNotifyAlert alert = new TlsCloseNotifyAlert(this);
! // Write close notify
! this.socket.SendAlert(alert);
! // Check that the session is finished by the client and by server
! if (!this.context.ConnectionEnd)
! {
! throw new TlsException("Invalid session termination");
! }
}
}
! catch (Exception ex)
! {
! throw ex;
! }
! finally
! {
! // Close streams
! closeStreams();
! }
}
***************
*** 276,279 ****
--- 297,301 ----
// Reset session information
+ this.isSecure = false;
this.helloDone = false;
this.handshakeFinished = false;
|
|
From: <car...@us...> - 2003-09-29 19:41:43
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv20655
Modified Files:
PgParameter.cs
Log Message:
Updated file
Index: PgParameter.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgParameter.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** PgParameter.cs 29 Sep 2003 15:21:00 -0000 1.6
--- PgParameter.cs 29 Sep 2003 19:41:39 -0000 1.7
***************
*** 24,28 ****
{
[ParenthesizePropertyName(true),
! TypeConverter(typeof(PgParameterConverter))]
public sealed class PgParameter : MarshalByRefObject, IDbDataParameter, IDataParameter, ICloneable
{
--- 24,28 ----
{
[ParenthesizePropertyName(true),
! TypeConverter(typeof(Design.PgParameterConverter))]
public sealed class PgParameter : MarshalByRefObject, IDbDataParameter, IDataParameter, ICloneable
{
***************
*** 129,133 ****
}
! [Category("Data"), DefaultValue(null)]
public object Value
{
--- 129,135 ----
}
! [Category("Data"),
! TypeConverter(typeof(StringConverter)),
! DefaultValue(null)]
public object Value
{
|
|
From: <car...@us...> - 2003-09-29 19:41:28
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/Design In directory sc8-pr-cvs1:/tmp/cvs-serv20626 Added Files: PgParameterConverter.cs Log Message: New file --- NEW FILE: PgParameterConverter.cs --- (This appears to be a binary file; contents omitted.) |
|
From: <car...@us...> - 2003-09-29 19:41:03
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/Design In directory sc8-pr-cvs1:/tmp/cvs-serv20515/Design Log Message: Directory /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/Design added to the repository |
|
From: <car...@us...> - 2003-09-29 18:16:54
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv511 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/changelog.txt,v retrieving revision 1.31 retrieving revision 1.32 diff -C2 -d -r1.31 -r1.32 *** changelog.txt 29 Sep 2003 15:34:52 -0000 1.31 --- changelog.txt 29 Sep 2003 18:16:40 -0000 1.32 *************** *** 8,16 **** * Added some improvements to PgCommandBuilder implementation. ! * source/PgParameter: - created a new design time converter. - Added attributes. 2003-09-28 Carlos Guzmán Álvarez <car...@te...> --- 8,20 ---- * 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án Álvarez <car...@te...> |
|
From: <car...@us...> - 2003-09-29 18:15:50
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv32726
Modified Files:
PgCommand.cs PgConnection.cs
Log Message:
- Added better checking of command transaction ( matching SqlClient way )
Index: PgCommand.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgCommand.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** PgCommand.cs 27 Sep 2003 19:20:39 -0000 1.6
--- PgCommand.cs 29 Sep 2003 18:15:36 -0000 1.7
***************
*** 299,320 ****
public int ExecuteNonQuery()
! {
! if (Connection == null || Connection.State != ConnectionState.Open)
! {
! throw new InvalidOperationException("Connection must valid and open");
! }
!
! if (Connection.DataReader != null)
! {
! throw new InvalidOperationException("There is already an open DataReader associated with this Connection which must be closed first.");
! }
!
! if (Transaction != null)
! {
! if (!Connection.Equals(Transaction.Connection))
! {
! throw new InvalidOperationException("Command Connection is not equal to Transaction Connection");
! }
! }
InternalPrepare();
--- 299,304 ----
public int ExecuteNonQuery()
! {
! checkCommand();
InternalPrepare();
***************
*** 343,363 ****
public PgDataReader ExecuteReader(CommandBehavior behavior)
{
! if (Connection == null || Connection.State != ConnectionState.Open)
! {
! throw new InvalidOperationException("Connection must valid and open");
! }
!
! if (Connection.DataReader != null)
! {
! throw new InvalidOperationException("There is already an open DataReader associated with this Connection which must be closed first.");
! }
!
! if (Transaction != null)
! {
! if (!Connection.Equals(Transaction.Connection))
! {
! throw new InvalidOperationException("Command Connection is not equal to Transaction Connection");
! }
! }
commandBehavior = behavior;
--- 327,331 ----
public PgDataReader ExecuteReader(CommandBehavior behavior)
{
! checkCommand();
commandBehavior = behavior;
***************
*** 379,399 ****
public object ExecuteScalar()
{
! if (Connection == null || Connection.State != ConnectionState.Open)
! {
! throw new InvalidOperationException("Connection must valid and open");
! }
!
! if (Connection.DataReader != null)
! {
! throw new InvalidOperationException("There is already an open DataReader associated with this Connection which must be closed first.");
! }
!
! if (Transaction != null)
! {
! if (!Connection.Equals(Transaction.Connection))
! {
! throw new InvalidOperationException("Command Connection is not equal to Transaction Connection");
! }
! }
object returnValue = null;
--- 347,351 ----
public object ExecuteScalar()
{
! checkCommand();
object returnValue = null;
***************
*** 412,427 ****
public void Prepare()
{
! if (Connection == null || Connection.State != ConnectionState.Open)
! {
! throw new InvalidOperationException("Connection must valid and open.");
! }
!
! if (Transaction != null)
! {
! if (!Connection.Equals(Transaction.Connection))
! {
! throw new InvalidOperationException("Command Connection is not equal to Transaction Connection.");
! }
! }
InternalPrepare();
--- 364,368 ----
public void Prepare()
{
! checkCommand();
InternalPrepare();
***************
*** 433,436 ****
--- 374,379 ----
string plan;
+ checkCommand();
+
try
{
***************
*** 671,674 ****
--- 614,644 ----
}
}
+ }
+ }
+
+ private void checkCommand()
+ {
+ if (connection == null || connection.State != ConnectionState.Open)
+ {
+ throw new InvalidOperationException("Connection must valid and open");
+ }
+ if (connection.DataReader != null)
+ {
+ throw new InvalidOperationException("There is already an open DataReader associated with this Connection which must be closed first.");
+ }
+ if (connection.ActiveTransaction != null &&
+ !connection.ActiveTransaction.IsUpdated &&
+ this.Transaction == null)
+ {
+ throw new InvalidOperationException("Execute requires the Command object to have a Transaction object when the Connection object assigned to the command is in a pending local transaction. The Transaction property of the Command has not been initialized.");
+ }
+ if (transaction != null &&
+ !connection.Equals(Transaction.Connection))
+ {
+ throw new InvalidOperationException("Command Connection is not equal to Transaction Connection");
+ }
+ if (commandText == String.Empty || commandText == null)
+ {
+ throw new InvalidOperationException ("The command text for this Command has not been set.");
}
}
Index: PgConnection.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgConnection.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PgConnection.cs 22 Aug 2003 19:18:12 -0000 1.2
--- PgConnection.cs 29 Sep 2003 18:15:36 -0000 1.3
***************
*** 47,51 ****
private string connectionString;
private PgDataReader dataReader;
! private PgTransaction activeTxn;
private ArrayList activeCommands;
--- 47,51 ----
private string connectionString;
private PgDataReader dataReader;
! private PgTransaction activeTransaction;
private ArrayList activeCommands;
***************
*** 180,183 ****
--- 180,188 ----
}
+ internal PgTransaction ActiveTransaction
+ {
+ get { return activeTransaction; }
+ }
+
#endregion
***************
*** 261,265 ****
}
! if (activeTxn != null && !activeTxn.IsUpdated)
{
throw new InvalidOperationException("A transaction is currently active. Parallel transactions are not supported.");
--- 266,270 ----
}
! if (activeTransaction != null && !activeTransaction.IsUpdated)
{
throw new InvalidOperationException("A transaction is currently active. Parallel transactions are not supported.");
***************
*** 273,278 ****
try
{
! activeTxn = new PgTransaction(this);
! activeTxn.InternalBeginTransaction();
}
catch (PgClientException ex)
--- 278,283 ----
try
{
! activeTransaction = new PgTransaction(this);
! activeTransaction.InternalBeginTransaction();
}
catch (PgClientException ex)
***************
*** 281,285 ****
}
! return this.activeTxn;
}
--- 286,290 ----
}
! return this.activeTransaction;
}
***************
*** 291,295 ****
}
! if (activeTxn != null && !activeTxn.IsUpdated)
{
throw new InvalidOperationException("A transaction is currently active. Parallel transactions are not supported.");
--- 296,300 ----
}
! if (activeTransaction != null && !activeTransaction.IsUpdated)
{
throw new InvalidOperationException("A transaction is currently active. Parallel transactions are not supported.");
***************
*** 303,308 ****
try
{
! activeTxn = new PgTransaction(this, level);
! activeTxn.InternalBeginTransaction();
}
catch (PgClientException ex)
--- 308,313 ----
try
{
! activeTransaction = new PgTransaction(this, level);
! activeTransaction.InternalBeginTransaction();
}
catch (PgClientException ex)
***************
*** 311,315 ****
}
! return this.activeTxn;
}
--- 316,320 ----
}
! return this.activeTransaction;
}
***************
*** 417,424 ****
// Rollback active transation
! if (activeTxn != null)
{
! activeTxn.Dispose();
! activeTxn = null;
}
--- 422,429 ----
// Rollback active transation
! if (activeTransaction != null)
{
! activeTransaction.Dispose();
! activeTransaction = null;
}
|
|
From: <car...@us...> - 2003-09-29 15:35:05
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv32113 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/changelog.txt,v retrieving revision 1.30 retrieving revision 1.31 diff -C2 -d -r1.30 -r1.31 *** changelog.txt 28 Sep 2003 18:57:40 -0000 1.30 --- changelog.txt 29 Sep 2003 15:34:52 -0000 1.31 *************** *** 2,6 **** ------------------------------------------------------- ! 2003-09-27 Carlos Guzmán Álvarez <car...@te...> * source/PgCommandBuilder.cs: --- 2,18 ---- ------------------------------------------------------- ! 2003-09-29 Carlos Guzmán Álvarez <car...@te...> ! ! * Added some changes to array datatype handling. ! ! * Added some improvements to PgCommandBuilder implementation. ! ! * source/PgParameter: ! ! - created a new design time converter. ! ! - Added attributes. ! ! 2003-09-28 Carlos Guzmán Álvarez <car...@te...> * source/PgCommandBuilder.cs: |
|
From: <car...@us...> - 2003-09-29 15:21:13
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv28532
Modified Files:
PgParameter.cs
Log Message:
Added new Attributes
Index: PgParameter.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgParameter.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** PgParameter.cs 27 Sep 2003 13:45:10 -0000 1.5
--- PgParameter.cs 29 Sep 2003 15:21:00 -0000 1.6
***************
*** 23,26 ****
--- 23,28 ----
namespace PostgreSql.Data.PgSqlClient
{
+ [ParenthesizePropertyName(true),
+ TypeConverter(typeof(PgParameterConverter))]
public sealed class PgParameter : MarshalByRefObject, IDbDataParameter, IDataParameter, ICloneable
{
|
|
From: <car...@us...> - 2003-09-29 14:37:31
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv19231
Modified Files:
PgCommandBuilder.cs
Log Message:
Some improvements to command builder
Index: PgCommandBuilder.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgCommandBuilder.cs,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** PgCommandBuilder.cs 28 Sep 2003 18:56:54 -0000 1.7
--- PgCommandBuilder.cs 29 Sep 2003 14:37:14 -0000 1.8
***************
*** 125,129 ****
sqlUpdate = "UPDATE {0} SET {1} WHERE ( {2} )";
sqlDelete = "DELETE FROM {0} WHERE ( {1} )";
! whereClausule1 = "(({0} IS NULL AND ${1} IS NULL) OR ({0} = ${2}))";
whereClausule2 = "({0} = ${1})";
setClausule = "{0} = ${1}";
--- 125,129 ----
sqlUpdate = "UPDATE {0} SET {1} WHERE ( {2} )";
sqlDelete = "DELETE FROM {0} WHERE ( {1} )";
! whereClausule1 = "(({0} IS NULL AND ${1} = NULL) OR ({0} = ${2}))";
whereClausule2 = "({0} = ${1})";
setClausule = "{0} = ${1}";
***************
*** 346,350 ****
insertCommand = new PgCommand(sql.ToString(), selectCommand.Connection, selectCommand.Transaction);
! int i = 0;
foreach (DataRow schemaRow in schemaTable.Rows)
{
--- 346,350 ----
insertCommand = new PgCommand(sql.ToString(), selectCommand.Connection, selectCommand.Transaction);
! int i = 1;
foreach (DataRow schemaRow in schemaTable.Rows)
{
***************
*** 406,410 ****
updateCommand = new PgCommand(sql.ToString(), selectCommand.Connection, selectCommand.Transaction);
! int i = 0;
foreach (DataRow schemaRow in schemaTable.Rows)
{
--- 406,410 ----
updateCommand = new PgCommand(sql.ToString(), selectCommand.Connection, selectCommand.Transaction);
! int i = 1;
foreach (DataRow schemaRow in schemaTable.Rows)
{
***************
*** 513,517 ****
// Build where clausule
! int i = 0;
foreach (DataRow schemaRow in schemaTable.Rows)
{
--- 513,517 ----
// Build where clausule
! int i = 1;
foreach (DataRow schemaRow in schemaTable.Rows)
{
***************
*** 601,605 ****
private PgParameter createParameter(DataRow schemaRow, int index, bool isWhereParameter)
{
! PgParameter parameter = new PgParameter(String.Format("@param_{0}", index), (PgDbType)schemaRow["ProviderType"]);
parameter.Size = Convert.ToInt32(schemaRow["ColumnSize"]);
--- 601,605 ----
private PgParameter createParameter(DataRow schemaRow, int index, bool isWhereParameter)
{
! PgParameter parameter = new PgParameter(String.Format("@p{0}", index), (PgDbType)schemaRow["ProviderType"]);
parameter.Size = Convert.ToInt32(schemaRow["ColumnSize"]);
***************
*** 674,681 ****
if (!(bool)schemaRow["IsKey"])
{
return false;
}
! if ((bool)schemaRow["IsLong"])
{
return false;
--- 674,688 ----
if (!(bool)schemaRow["IsKey"])
{
+ // return false;
+ }
+
+ PgDbType pgDbType= (PgDbType)schemaRow["ProviderType"];
+
+ if (pgDbType == PgDbType.Binary)
+ {
return false;
}
! if (pgDbType == PgDbType.Array)
{
return false;
***************
*** 776,780 ****
if (e.Command == null)
{
! e.Command = buildInsertCommand(e.Row, e.TableMapping);
}
e.Status = UpdateStatus.Continue;
--- 783,788 ----
if (e.Command == null)
{
! insertCommand = buildInsertCommand(e.Row, e.TableMapping);
! e.Command = insertCommand;
}
e.Status = UpdateStatus.Continue;
***************
*** 784,788 ****
if (e.Command == null)
{
! e.Command = buildUpdateCommand(e.Row, e.TableMapping);
}
e.Status = UpdateStatus.Continue;
--- 792,797 ----
if (e.Command == null)
{
! updateCommand = buildUpdateCommand(e.Row, e.TableMapping);
! e.Command = updateCommand;
}
e.Status = UpdateStatus.Continue;
***************
*** 792,796 ****
if (e.Command == null)
{
! e.Command = buildDeleteCommand(e.Row, e.TableMapping);
}
e.Status = UpdateStatus.Continue;
--- 801,806 ----
if (e.Command == null)
{
! deleteCommand = buildDeleteCommand(e.Row, e.TableMapping);
! e.Command = deleteCommand;
}
e.Status = UpdateStatus.Continue;
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/NPgClient
In directory sc8-pr-cvs1:/tmp/cvs-serv18477
Modified Files:
PgDbClient.cs PgOutputPacket.cs PgResponsePacket.cs PgType.cs
Log Message:
Added some changes to Array datatype handling
Index: PgDbClient.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/NPgClient/PgDbClient.cs,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** PgDbClient.cs 21 Sep 2003 22:35:21 -0000 1.17
--- PgDbClient.cs 29 Sep 2003 14:33:01 -0000 1.18
***************
*** 652,678 ****
types.Add(16 , "bool" , DbType.Boolean , Type.GetType("System.Boolean") , 0, 1, 1, false);
types.Add(17 , "bytea" , DbType.Binary , Type.GetType("System.Array") , 0, 1, 0, false);
! types.Add(18 , "char" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
types.Add(19 , "name" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
types.Add(20 , "int8" , DbType.Int64 , Type.GetType("System.Int64") , 0, 1, 8, false);
types.Add(21 , "int2" , DbType.Int16 , Type.GetType("System.Int16") , 0, 1, 2, false);
! types.Add(22 , "int2vector", DbType.Object , Type.GetType("System.Array") , 21, 1, 2, true);
types.Add(23 , "int4" , DbType.Int32 , Type.GetType("System.Int32") , 0, 1, 4, false);
types.Add(24 , "regproc" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
types.Add(25 , "text" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
types.Add(26 , "oid" , DbType.Int32 , Type.GetType("System.Int32") , 0, 1, 4, false);
! types.Add(30 , "oidvector", DbType.Object , Type.GetType("System.Array") , 26, 1, 4, true);
types.Add(700 , "float4" , DbType.Single , Type.GetType("System.Single") , 0, 1, 4, false);
types.Add(701 , "float8" , DbType.Double , Type.GetType("System.Double") , 0, 1, 8, false);
! types.Add(705 , "unknown" , DbType.Object , Type.GetType("System.Object") , 0, 0, 0, false);
types.Add(790 , "money" , DbType.Currency , Type.GetType("System.Decimal") , 0, 1, 4, false);
types.Add(829 , "macaddr" , DbType.String , Type.GetType("System.String") , 0, 0, 6, false);
types.Add(869 , "inet" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
! types.Add(1005 , "_int2" , DbType.Object , Type.GetType("System.Array") , 21, 1, 2, false);
! types.Add(1007 , "_int4" , DbType.Object , Type.GetType("System.Array") , 23, 1, 4, false);
! types.Add(1016 , "_int8" , DbType.Object , Type.GetType("System.Array") , 20, 1, 8, false);
! types.Add(1009 , "_text" , DbType.Object , Type.GetType("System.Array") , 25, 1, 0, false);
! types.Add(1021 , "_float4" , DbType.Object , Type.GetType("System.Array") , 700, 1, 4, false);
types.Add(1033 , "aclitem" , DbType.String , Type.GetType("System.String") , 0, 0, 12, false);
! types.Add(1034 , "_aclitem", DbType.Object , Type.GetType("System.Array") , 1033, 0, 0, false);
types.Add(1042 , "bpchar" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
types.Add(1043 , "varchar" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
--- 652,678 ----
types.Add(16 , "bool" , DbType.Boolean , Type.GetType("System.Boolean") , 0, 1, 1, false);
types.Add(17 , "bytea" , DbType.Binary , Type.GetType("System.Array") , 0, 1, 0, false);
! types.Add(18 , "char" , DbType.StringFixedLength, Type.GetType("System.String"), 0, 0, 0, false);
types.Add(19 , "name" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
types.Add(20 , "int8" , DbType.Int64 , Type.GetType("System.Int64") , 0, 1, 8, false);
types.Add(21 , "int2" , DbType.Int16 , Type.GetType("System.Int16") , 0, 1, 2, false);
! types.Add(22 , "int2vector", DbType.Binary , Type.GetType("System.Array") , 21, 1, 2, true);
types.Add(23 , "int4" , DbType.Int32 , Type.GetType("System.Int32") , 0, 1, 4, false);
types.Add(24 , "regproc" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
types.Add(25 , "text" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
types.Add(26 , "oid" , DbType.Int32 , Type.GetType("System.Int32") , 0, 1, 4, false);
! types.Add(30 , "oidvector", DbType.Binary , Type.GetType("System.Array") , 26, 1, 4, true);
types.Add(700 , "float4" , DbType.Single , Type.GetType("System.Single") , 0, 1, 4, false);
types.Add(701 , "float8" , DbType.Double , Type.GetType("System.Double") , 0, 1, 8, false);
! // types.Add(705 , "unknown" , DbType.Object , Type.GetType("System.Object") , 0, 0, 0, false);
types.Add(790 , "money" , DbType.Currency , Type.GetType("System.Decimal") , 0, 1, 4, false);
types.Add(829 , "macaddr" , DbType.String , Type.GetType("System.String") , 0, 0, 6, false);
types.Add(869 , "inet" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
! types.Add(1005 , "_int2" , DbType.Binary , Type.GetType("System.Array") , 21, 1, 2, false);
! types.Add(1007 , "_int4" , DbType.Binary , Type.GetType("System.Array") , 23, 1, 4, false);
! types.Add(1016 , "_int8" , DbType.Binary , Type.GetType("System.Array") , 20, 1, 8, false);
! types.Add(1009 , "_text" , DbType.Binary , Type.GetType("System.Array") , 25, 1, 0, false);
! types.Add(1021 , "_float4" , DbType.Binary , Type.GetType("System.Array") , 700, 1, 4, false);
types.Add(1033 , "aclitem" , DbType.String , Type.GetType("System.String") , 0, 0, 12, false);
! types.Add(1034 , "_aclitem", DbType.Binary , Type.GetType("System.Array") , 1033, 0, 0, false);
types.Add(1042 , "bpchar" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
types.Add(1043 , "varchar" , DbType.String , Type.GetType("System.String") , 0, 0, 0, false);
***************
*** 683,687 ****
types.Add(1562 , "varbit" , DbType.Byte , Type.GetType("System.Byte") , 0, 1, 0, false);
types.Add(1700 , "numeric" , DbType.Decimal , Type.GetType("System.Decimal") , 0, 0, 8, false);
! types.Add(2277 , "anyarray", DbType.Object , Type.GetType("System.Array") , 0, 1, 8, false);
}
--- 683,687 ----
types.Add(1562 , "varbit" , DbType.Byte , Type.GetType("System.Byte") , 0, 1, 0, false);
types.Add(1700 , "numeric" , DbType.Decimal , Type.GetType("System.Decimal") , 0, 0, 8, false);
! types.Add(2277 , "anyarray", DbType.Binary , Type.GetType("System.Array") , 0, 1, 8, false);
}
Index: PgOutputPacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/NPgClient/PgOutputPacket.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PgOutputPacket.cs 19 Sep 2003 17:04:39 -0000 1.4
--- PgOutputPacket.cs 29 Sep 2003 14:33:01 -0000 1.5
***************
*** 154,158 ****
else
{
! if (parameter.DataType.DbType == DbType.Object)
{
// Handle this type as Array values
--- 154,159 ----
else
{
! if (parameter.DataType.DbType == DbType.Binary &&
! parameter.DataType.ArrayType != 0)
{
// Handle this type as Array values
Index: PgResponsePacket.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/NPgClient/PgResponsePacket.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** PgResponsePacket.cs 19 Sep 2003 17:04:39 -0000 1.5
--- PgResponsePacket.cs 29 Sep 2003 14:33:01 -0000 1.6
***************
*** 296,300 ****
{
case DbType.Binary:
! return ReadBytes(length);
case DbType.String:
--- 296,323 ----
{
case DbType.Binary:
! {
! if (type.ArrayType != 0)
! {
! if (type.FormatCode == 0)
! {
! return ReadStringArray(type, length);
! }
! else
! {
! if (type.IsVector)
! {
! return ReadVector(type, length);
! }
! else
! {
! return ReadPrimitiveArray(type, length);
! }
! }
! }
! else
! {
! return ReadBytes(length);
! }
! }
case DbType.String:
***************
*** 337,366 ****
case DbType.DateTime:
return ReadTimestamp();
-
- case DbType.Object:
- {
- if (type.SystemType == Type.GetType("System.Array"))
- {
- if (type.FormatCode == 0)
- {
- return ReadStringArray(type, length);
- }
- else
- {
- if (type.IsVector)
- {
- return ReadVector(type, length);
- }
- else
- {
- return ReadPrimitiveArray(type, length);
- }
- }
- }
- else
- {
- throw new NotSupportedException("Unknown data type");
- }
- }
default:
--- 360,363 ----
Index: PgType.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/NPgClient/PgType.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** PgType.cs 2 Aug 2003 21:12:16 -0000 1.2
--- PgType.cs 29 Sep 2003 14:33:01 -0000 1.3
***************
*** 120,137 ****
break;
- case DbType.AnsiString:
- case DbType.String:
- providerType = PgDbType.VarChar;
- break;
-
case DbType.AnsiStringFixedLength:
case DbType.StringFixedLength:
providerType = PgDbType.Char;
break;
case DbType.Binary:
! case DbType.Object:
! providerType = PgDbType.Binary;
! break;
case DbType.Date:
--- 120,145 ----
break;
case DbType.AnsiStringFixedLength:
case DbType.StringFixedLength:
providerType = PgDbType.Char;
break;
+
+ case DbType.AnsiString:
+ case DbType.String:
+ providerType = PgDbType.VarChar;
+ break;
case DbType.Binary:
! {
! if (arrayType != 0)
! {
! providerType = PgDbType.Array;
! }
! else
! {
! providerType = PgDbType.Binary;
! }
! }
! break;
case DbType.Date:
|
|
From: <car...@us...> - 2003-09-28 18:57:55
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv5228 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/changelog.txt,v retrieving revision 1.29 retrieving revision 1.30 diff -C2 -d -r1.29 -r1.30 *** changelog.txt 27 Sep 2003 19:23:15 -0000 1.29 --- changelog.txt 28 Sep 2003 18:57:40 -0000 1.30 *************** *** 4,7 **** --- 4,15 ---- 2003-09-27 Carlos Guzmán Álvarez <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án Álvarez <car...@te...> + * source/PgParameter.cs: |
|
From: <car...@us...> - 2003-09-28 18:57:11
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv4988
Modified Files:
PgCommandBuilder.cs
Log Message:
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.
Index: PgCommandBuilder.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgCommandBuilder.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** PgCommandBuilder.cs 31 Aug 2003 12:59:36 -0000 1.6
--- PgCommandBuilder.cs 28 Sep 2003 18:56:54 -0000 1.7
***************
*** 38,42 ****
private PgCommand updateCommand;
private PgCommand deleteCommand;
! private string whereClausule;
private string setClausule;
private DataTable schemaTable;
--- 38,44 ----
private PgCommand updateCommand;
private PgCommand deleteCommand;
! private string separator;
! private string whereClausule1;
! private string whereClausule2;
private string setClausule;
private DataTable schemaTable;
***************
*** 123,128 ****
sqlUpdate = "UPDATE {0} SET {1} WHERE ( {2} )";
sqlDelete = "DELETE FROM {0} WHERE ( {1} )";
! whereClausule = "(({0} IS NULL) OR ({0} = {1}))";
! setClausule = "{0} = {1}";
quotePrefix = String.Empty;
quoteSuffix = String.Empty;
--- 125,132 ----
sqlUpdate = "UPDATE {0} SET {1} WHERE ( {2} )";
sqlDelete = "DELETE FROM {0} WHERE ( {1} )";
! whereClausule1 = "(({0} IS NULL AND ${1} IS NULL) OR ({0} = ${2}))";
! whereClausule2 = "({0} = ${1})";
! setClausule = "{0} = ${1}";
! separator = ", ";
quotePrefix = String.Empty;
quoteSuffix = String.Empty;
***************
*** 349,357 ****
if (fields.Length > 0)
{
! fields.Append(", ");
}
if (values.Length > 0)
{
! values.Append(", ");
}
--- 353,361 ----
if (fields.Length > 0)
{
! fields.Append(separator);
}
if (values.Length > 0)
{
! values.Append(separator);
}
***************
*** 364,385 ****
PgParameter parameter = createParameter(schemaRow, i, false);
- if (tableMapping != null)
- {
- if (tableMapping.ColumnMappings.Count > 0)
- {
- dsColumnName = tableMapping.ColumnMappings[parameter.SourceColumn].DataSetColumn;
- }
- else
- {
- dsColumnName = parameter.SourceColumn;
- }
- }
- else
- {
- dsColumnName = parameter.SourceColumn;
- }
-
if (row != null)
{
parameter.Value = row[dsColumnName];
}
--- 368,374 ----
PgParameter parameter = createParameter(schemaRow, i, false);
if (row != null)
{
+ dsColumnName = getColumnName(tableMapping, schemaRow["BaseColumnName"].ToString());
parameter.Value = row[dsColumnName];
}
***************
*** 424,455 ****
if (sets.Length > 0)
{
! sets.Append(", ");
}
// Build Field name and append it to the string
sets.AppendFormat(setClausule,
! getQuotedIdentifier(schemaRow["BaseColumnName"]),
! "@param_" + i.ToString());
PgParameter parameter = createParameter(schemaRow, i, false);
- if (tableMapping != null)
- {
- if (tableMapping.ColumnMappings.Count > 0)
- {
- dsColumnName = tableMapping.ColumnMappings[parameter.SourceColumn].DataSetColumn;
- }
- else
- {
- dsColumnName = parameter.SourceColumn;
- }
- }
- else
- {
- dsColumnName = parameter.SourceColumn;
- }
-
if (row != null)
{
parameter.Value = row[dsColumnName];
}
--- 413,428 ----
if (sets.Length > 0)
{
! sets.Append(separator);
}
// Build Field name and append it to the string
sets.AppendFormat(setClausule,
! getQuotedIdentifier(schemaRow["BaseColumnName"]), i);
PgParameter parameter = createParameter(schemaRow, i, false);
if (row != null)
{
+ dsColumnName = this.getColumnName(tableMapping, schemaRow["BaseColumnName"].ToString());
parameter.Value = row[dsColumnName];
}
***************
*** 458,462 ****
updateCommand.Parameters.Add(parameter);
! }
}
--- 431,435 ----
updateCommand.Parameters.Add(parameter);
! }
}
***************
*** 471,505 ****
}
! where.AppendFormat(whereClausule,
! getQuotedIdentifier(schemaRow["BaseColumnName"]),
! "@param_" + i.ToString());
!
! PgParameter parameter = createParameter(schemaRow, i, true);
! if (tableMapping != null)
{
! if (tableMapping.ColumnMappings.Count > 0)
! {
! dsColumnName = tableMapping.ColumnMappings[parameter.SourceColumn].DataSetColumn;
! }
! else
{
! dsColumnName = parameter.SourceColumn;
}
}
else
{
! dsColumnName = parameter.SourceColumn;
! }
! if (row != null)
! {
! parameter.Value = row[dsColumnName, DataRowVersion.Original];
! }
! i++;
! updateCommand.Parameters.Add(parameter);
! }
}
--- 444,488 ----
}
! dsColumnName = this.getColumnName(tableMapping, schemaRow["BaseColumnName"].ToString());
! string quotedId = getQuotedIdentifier(schemaRow["BaseColumnName"]);
! if ((bool)schemaRow["IsKey"])
{
! PgParameter parameter = createParameter(schemaRow, i, true);
! where.AppendFormat(whereClausule2, quotedId, i);
!
! if (row != null)
{
! parameter.Value = row[dsColumnName, DataRowVersion.Original];
}
+
+ updateCommand.Parameters.Add(parameter);
}
else
{
! // Create parameters for this field
! int paramIndex1 = i;
! PgParameter parameter1 = createParameter(schemaRow, paramIndex1, true);
! int paramIndex2 = ++i;
! PgParameter parameter2 = createParameter(schemaRow, paramIndex2, true);
! // Add where clausule for this field
! where.AppendFormat(whereClausule1,
! quotedId, paramIndex1, paramIndex2);
! // Set parameter values
! if (row != null)
! {
! parameter1.Value = row[dsColumnName, DataRowVersion.Original];
! parameter2.Value = row[dsColumnName, DataRowVersion.Original];
! }
! // Add parameters to command parameter collectionb
! updateCommand.Parameters.Add(parameter1);
! updateCommand.Parameters.Add(parameter2);
! }
!
! i++;
! }
}
***************
*** 540,573 ****
}
! where.AppendFormat(whereClausule,
! getQuotedIdentifier(schemaRow["BaseColumnName"]),
! "@param_" + i.ToString());
!
! PgParameter parameter = createParameter(schemaRow, i, true);
! if (tableMapping != null)
{
! if (tableMapping.ColumnMappings.Count > 0)
! {
! dsColumnName = tableMapping.ColumnMappings[parameter.SourceColumn].DataSetColumn;
! }
! else
{
! dsColumnName = parameter.SourceColumn;
}
}
else
{
! dsColumnName = parameter.SourceColumn;
! }
!
! if (row != null)
! {
! parameter.Value = row[dsColumnName, DataRowVersion.Original];
}
i++;
-
- deleteCommand.Parameters.Add(parameter);
}
}
--- 523,566 ----
}
! dsColumnName = this.getColumnName(tableMapping, schemaRow["BaseColumnName"].ToString());
! string quotedId = getQuotedIdentifier(schemaRow["BaseColumnName"]);
! if ((bool)schemaRow["IsKey"])
{
! PgParameter parameter = createParameter(schemaRow, i, true);
! where.AppendFormat(whereClausule2, quotedId, i);
!
! if (row != null)
{
! parameter.Value = row[dsColumnName, DataRowVersion.Original];
}
+
+ deleteCommand.Parameters.Add(parameter);
}
else
{
! // Create parameters for this field
! int paramIndex1 = i;
! PgParameter parameter1 = createParameter(schemaRow, paramIndex1, true);
! int paramIndex2 = ++i;
! PgParameter parameter2 = createParameter(schemaRow, paramIndex2, true);
!
! // Add where clausule for this field
! where.AppendFormat(whereClausule1,
! quotedId, paramIndex1, paramIndex2);
!
! // Set parameter values
! if (row != null)
! {
! parameter1.Value = row[dsColumnName, DataRowVersion.Original];
! parameter2.Value = row[dsColumnName, DataRowVersion.Original];
! }
!
! // Add parameters to command parameter collectionb
! deleteCommand.Parameters.Add(parameter1);
! deleteCommand.Parameters.Add(parameter2);
}
i++;
}
}
***************
*** 581,584 ****
--- 574,600 ----
return deleteCommand;
+ }
+
+ private string getColumnName(DataTableMapping tableMapping, string sourceColumn)
+ {
+ string dsColumnName;
+
+ if (tableMapping != null)
+ {
+ if (tableMapping.ColumnMappings.Count > 0)
+ {
+ dsColumnName = tableMapping.ColumnMappings[sourceColumn].DataSetColumn;
+ }
+ else
+ {
+ dsColumnName = sourceColumn;
+ }
+ }
+ else
+ {
+ dsColumnName = sourceColumn;
+ }
+
+ return dsColumnName;
}
|
|
From: <car...@us...> - 2003-09-27 19:23:28
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv3612 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/changelog.txt,v retrieving revision 1.28 retrieving revision 1.29 diff -C2 -d -r1.28 -r1.29 *** changelog.txt 27 Sep 2003 13:46:12 -0000 1.28 --- changelog.txt 27 Sep 2003 19:23:15 -0000 1.29 *************** *** 8,11 **** --- 8,15 ---- - Override ToString method and return the parameter name. + * source/PgCommand.cs: + + - Added ReadOnly attribute to ConnectionTimeout property. + 2003-09-22 Carlos Guzmán Álvarez <car...@te...> |
|
From: <car...@us...> - 2003-09-27 19:20:52
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv2917
Modified Files:
PgCommand.cs
Log Message:
Added ReadOnly attribute to ConnectionTimeout property.
Index: PgCommand.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgCommand.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** PgCommand.cs 22 Aug 2003 19:39:58 -0000 1.5
--- PgCommand.cs 27 Sep 2003 19:20:39 -0000 1.6
***************
*** 80,84 ****
}
! [DefaultValue(30)]
public int CommandTimeout
{
--- 80,85 ----
}
! [ReadOnly(true),
! DefaultValue(30)]
public int CommandTimeout
{
|
|
From: <car...@us...> - 2003-09-27 13:46:26
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv9803 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/changelog.txt,v retrieving revision 1.27 retrieving revision 1.28 diff -C2 -d -r1.27 -r1.28 *** changelog.txt 21 Sep 2003 22:36:03 -0000 1.27 --- changelog.txt 27 Sep 2003 13:46:12 -0000 1.28 *************** *** 2,12 **** ------------------------------------------------------- 2003-09-22 Carlos Guzmán Álvarez <car...@te...> * source/NPgClient/PgStatement.cs: ! * Added row fetching in groups of 200 rows. ! * Cleanup. 2003-09-19 Carlos Guzmán Álvarez <car...@te...> --- 2,19 ---- ------------------------------------------------------- + 2003-09-27 Carlos Guzmán Álvarez <car...@te...> + + * source/PgParameter.cs: + + - Override ToString method and return the parameter name. + + 2003-09-22 Carlos Guzmán Álvarez <car...@te...> * source/NPgClient/PgStatement.cs: ! - Added row fetching in groups of 200 rows. ! - Cleanup. 2003-09-19 Carlos Guzmán Álvarez <car...@te...> *************** *** 14,18 **** * source/NPgClient/PgOutputPacket.cs: ! * Added support for array parameters ( not finished needs testing ). < ----------------------------------- Beta 3 ---------------------------------- > --- 21,25 ---- * source/NPgClient/PgOutputPacket.cs: ! - Added support for array parameters ( not finished needs testing ). < ----------------------------------- Beta 3 ---------------------------------- > |
|
From: <car...@us...> - 2003-09-27 13:45:24
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv9624
Modified Files:
PgParameter.cs
Log Message:
Override ToString method and return the parameter name.
Index: PgParameter.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgParameter.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** PgParameter.cs 12 Aug 2003 19:30:13 -0000 1.4
--- PgParameter.cs 27 Sep 2003 13:45:10 -0000 1.5
***************
*** 416,419 ****
--- 416,424 ----
}
}
+
+ public override string ToString()
+ {
+ return this.parameterName;
+ }
#endregion
|
|
From: <car...@us...> - 2003-09-21 22:37:05
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv32138 Modified Files: DotNETBuild.bat Log Message: Updated Index: DotNETBuild.bat =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/DotNETBuild.bat,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** DotNETBuild.bat 12 Sep 2003 20:47:43 -0000 1.2 --- DotNETBuild.bat 21 Sep 2003 22:37:01 -0000 1.3 *************** *** 1 **** ! nant -buildfile:PgSqlClient.build %1 %2 %3 %4 --- 1 ---- ! nant -buildfile:PgSqlClient.build -verbose %1 %2 %3 %4 |
|
From: <car...@us...> - 2003-09-21 22:36:07
|
Update of /cvsroot/pgsqlclient/pgsqlclient_10 In directory sc8-pr-cvs1:/tmp/cvs-serv32015 Modified Files: changelog.txt Log Message: Updated CHANGELOG.TXT Index: changelog.txt =================================================================== RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/changelog.txt,v retrieving revision 1.26 retrieving revision 1.27 diff -C2 -d -r1.26 -r1.27 *** changelog.txt 18 Sep 2003 14:18:13 -0000 1.26 --- changelog.txt 21 Sep 2003 22:36:03 -0000 1.27 *************** *** 2,5 **** --- 2,19 ---- ------------------------------------------------------- + 2003-09-22 Carlos Guzmán Álvarez <car...@te...> + + * source/NPgClient/PgStatement.cs: + + * Added row fetching in groups of 200 rows. + + * Cleanup. + + 2003-09-19 Carlos Guzmán Álvarez <car...@te...> + + * source/NPgClient/PgOutputPacket.cs: + + * Added support for array parameters ( not finished needs testing ). + < ----------------------------------- Beta 3 ---------------------------------- > |