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 ---------------------------------- > |