2002-05-08 Rodrigo Moya <rodrigo@ximian.com>
[mono.git] / mcs / class / System.Data / ChangeLog
index 70ee2d70f28fcc8e2c3e16b3fd59c2bbdf96fae7..705199a09edb6b60ddf8e9e7e65e9c5eef808b50 100644 (file)
@@ -1,3 +1,325 @@
+2002-05-08  Rodrigo Moya <rodrigo@ximian.com>
+
+       * Test/System.Data_test.build: excluded TestDataColumn, which
+       should be replaced with a nunit test.
+
+       * Test/TestDataColumn.cs: added basic test for DataColumn.cs.
+
+2002-05-07  Tim Coleman <tim@timcoleman.com>
+       * SqlBinary.cs:
+       * SqlBoolean.cs:
+       * SqlByte.cs:
+       * SqlDateTime.cs:
+       * SqlDecimal.cs:
+       * SqlDouble.cs:
+       * SqlGuid.cs:
+       * SqlInt16.cs:
+       * SqlInt32.cs:
+       * SqlInt64.cs:
+       * SqlMoney.cs:
+       * SqlSingle.cs:
+       * SqlString.cs:
+               Fix the broken build I made before.  Bad
+               me.
+
+2002-05-07  Tim Coleman <tim@timcoleman.com>
+       * SqlString.cs:
+               Fix a symantic error I made in SqlString
+               Equals where I copied and pasted wrongly
+
+2002-05-07  Tim Coleman <tim@timcoleman.com>
+       * INullable.cs:
+       * SqlBinary.cs:
+       * SqlBoolean.cs:
+       * SqlByte.cs:
+       * SqlCompareOptions.cs:
+       * SqlDateTime.cs:
+       * SqlDecimal.cs:
+       * SqlDouble.cs:
+       * SqlGuid.cs:
+       * SqlInt16.cs:
+       * SqlInt32.cs:
+       * SqlInt64.cs:
+       * SqlMoney.cs:
+       * SqlSingle.cs:
+       * SqlString.cs:
+               Implement CompareTo, Equals, and String conversions 
+               for many types
+
+2002-05-05  Daniel Morgan <danmorg@sc.rr.com>
+
+       * Test/PostgresTest.cs: modified to run completely.  There
+       are many TODOs in System.Data, so not all data types are
+       included in the SELECT SQL query.  Also, I made it to where
+       it would connect 
+       using "host=localhost;dbname=test;user=postgres"
+       instead of my userid and password.  When more types are included,
+       update this test.
+
+2002-05-05  Daniel Morgan <danmorg@sc.rr.com>
+
+       * Test/PostgresTest.cs: added - ported
+       libgda postgres-test.c originally by 
+       Gonzalo Paniagua Javier <gonzalo@gnome-db.org>
+       to C#.
+
+2002-05-05  Tim Coleman <tim@timcoleman.com>
+       * System.Data.SqlTypes/SqlBinary.cs:
+       * System.Data.SqlTypes/SqlBoolean.cs:
+       * System.Data.SqlTypes/SqlByte.cs:
+       * System.Data.SqlTypes/SqlDateTime.cs:
+       * System.Data.SqlTypes/SqlDecimal.cs:
+       * System.Data.SqlTypes/SqlDouble.cs:
+       * System.Data.SqlTypes/SqlGuid.cs:
+       * System.Data.SqlTypes/SqlInt16.cs:
+       * System.Data.SqlTypes/SqlInt32.cs:
+       * System.Data.SqlTypes/SqlInt64.cs:
+       * System.Data.SqlTypes/SqlMoney.cs:
+       * System.Data.SqlTypes/SqlSingle.cs:
+       * System.Data.SqlTypes/SqlString.cs:
+               More implementation, and code clean-up for consistency.
+               Also, I had implemented many conversions as explicit
+               that should have been implicit.  This should remove
+               many of the red X's and green pluses from the 
+               System.Data.SqlTypes namespace.
+
+2002-05-05  Miguel de Icaza  <miguel@ximian.com>
+
+       * System.Data/DataSet.cs: Remove [Serializable] attributes from
+       methods, those only apply to structs or classes.
+
+       Stub out ISerializable, ISupportInitialize, and IListSource methods 
+       
+       * System.Data/DataRowView.cs: Stub out interface methods for
+       IEditableObject, ICustomTypeDescriptor and IDataErrorInfo
+
+       * System.Data/DataView.cs: Comment out non-implemented
+       interfaces. 
+
+       * System.Data/DataViewSettingsCollection.cs: Type cast variables
+       to the correct type to make it compile.
+
+       * System.Data/DataViewSettings.cs: remove reference to
+       non-existance type ApplyDefaultSort, it is a boolean.
+       
+
+2002-05-05  Tim Coleman <tim@timcoleman.com>
+        * System.Data.SqlTypes/SqlBinary.cs:
+        * System.Data.SqlTypes/SqlBoolean.cs:
+        * System.Data.SqlTypes/SqlByte.cs:
+        * System.Data.SqlTypes/SqlDecimal.cs:
+        * System.Data.SqlTypes/SqlDouble.cs:
+        * System.Data.SqlTypes/SqlGuid.cs:
+        * System.Data.SqlTypes/SqlInt16.cs:
+        * System.Data.SqlTypes/SqlInt32.cs:
+        * System.Data.SqlTypes/SqlInt64.cs:
+        * System.Data.SqlTypes/SqlMoney.cs:
+        * System.Data.SqlTypes/SqlSingle.cs:
+        * System.Data.SqlTypes/SqlString.cs:
+                Various fixes, including adding the SqlNullValueException
+                when trying to retrieve the value of a null SqlType,
+                and when casting values, a Null of type A converts to a
+                Null of type B.
+
+2002-05-04  Daniel Morgan <danmorg@sc.rr.com>
+       
+       * System.Data.SqlClient/PostgresLibrary.cs
+       * System.Data.SqlClient/SqlCommand.cs
+       * System.Data.SqlClient/SqlConnection.cs
+       * System.Data.SqlClient/SqlDataReader.cs
+       oid should not be hard coded because they
+       can change from one version of PostgreSQL
+       to the next.  Use the typname's instead.
+       The PostgreSQL type data retrieves
+       at database connection time.  Any unimplemented
+       types just default to string.  These were things
+       suggested by Gonzalo.
+       
+       * Test/ReadPostgresData.cs - stuff
+       * Test/TestSqlDataReader.cs - stuff
+       
+       * System.Data.SqlTypes/SqlInt32.cs - added a using
+
+2002-05-03  Tim Coleman <tim@timcoleman.com>
+       * System.Data.build: Fix the build so that test depends on build
+
+2002-05-03  Tim Coleman <tim@timcoleman.com>
+       * System.Data.SqlTypes/SqlByte.cs:
+       * System.Data.SqlTypes/SqlDateTime.cs:
+       * System.Data.SqlTypes/SqlDecimal.cs:
+       * System.Data.SqlTypes/SqlDouble.cs:
+       * System.Data.SqlTypes/SqlGuid.cs:
+       * System.Data.SqlTypes/SqlInt16.cs:
+       * System.Data.SqlTypes/SqlInt64.cs:
+       * System.Data.SqlTypes/SqlMoney.cs:
+       * System.Data.SqlTypes/SqlSingle.cs:
+               These files were mysteriously excluded from the last
+               patch I made and sent to Rodrigo
+       * System.Data.build: include the System.Data.SqlTypes in the build
+
+2002-05-03  Daniel Morgan <danmorg@sc.rr.com>
+
+       * System.Data.build: removed comments
+
+       * System.Data.SqlClient/PostgresLibrary.cs: changed
+       the hard-coded PostgreSQL oid type int's to using an
+       enum.  Also, added PostgreSQL bpchar (character) type.
+       
+       * Test/TestSqlDataReader.cs: updated test
+       to include new bpchar PostgreSQL type
+
+2002-05-03  Rodrigo Moya <rodrigo@ximian.com>
+
+       * System.Data.SqlTypes/SqlBinary.cs:
+       * System.Data.SqlTypes/SqlBoolean.cs:
+       * System.Data.SqlTypes/SqlInt32.cs:
+       * System.Data.SqlTypes/SqlString.cs: more implementation, by
+       Tim Coleman <tcoleman@opentext.com>.
+
+2002-05-03  Daniel Morgan <danmorg@sc.rr.com>
+
+       * Test/TestExecuteScalar.cs: added test for 
+       method ExecuteScalar in class SqlCommand.
+       
+       * System.Data/DataColumnCollection.cs - it should
+       inherit properties from base InternalDataCollectionBase
+       and use them instead of overriding them, such as, List.
+       
+       * System.Data/DataColumn.cs
+       * System.Data/DataTable.cs: tweaks to retrieve
+       meta data from the database
+       
+       * System.Data.SqlClient/PostgresLibrary.cs -
+       added method OidToType to convert PostgreSQL oid type 
+       to System.Type.  Renamed method OidTypeToSystem
+       to ConvertPgTypeToSystem for converting the data value
+       from a PostgreSQL type to a .NET System type.
+       
+       * System.Data.SqlClient/SqlCommand.cs: implemented
+       method ExecuteReader which returns a SqlDataReader
+       for a light forward only read only result set. 
+       It works on types int4 ==> Int32 and 
+       varchar ==> String.  Other types
+       will come later.
+       
+       * System.Data.SqlClient/SqlConnection.cs: added comment
+       
+       * System.Data.SqlClient/SqlDataReader.cs: implemented
+       class.  It works, but still lots to do.
+       
+       * Test/ReadPostgresData.cs: stuff
+       
+       * Test/TestSqlDataReader.cs: updated test for SqlDataReader
+       to display meta data and the data
+       
+2002-05-03  Duncan Mak  <duncan@ximian.com>
+
+       * TODO: Took out all the Exceptions. They should be all done now.
+
+       * System.Data/ConstraintException.cs: 
+       * System.Data/DBConcurrencyException.cs:
+       * System.Data/DataException.cs: 
+       * System.Data/DeletedRowInaccessibleException.cs: 
+       * System.Data/DuplicateNameException.cs:
+       * System.Data/EvaluateException.cs: 
+       * System.Data/InRowChangingEventException.cs: 
+       * System.Data/InvalidConstraintException.cs: 
+       * System.Data/InvalidExpressionException.cs: 
+       * System.Data/MissingPrimaryKeyException.cs:
+       * System.Data/NoNullAllowedException.cs: 
+       * System.Data/ReadOnlyException.cs: 
+       * System.Data/RowNotInTableException.cs: 
+       * System.Data/StrongTypingException.cs:
+       * System.Data/SyntaxErrorException.cs: 
+       * System.Data/TypeDataSetGeneratorException.cs: 
+       * System.Data/VersionNotFoundException.cs: Added to CVS.
+
+       * System.Data.SqlTypes/SqlNullValueException.cs: 
+       * System.Data.SqlTypes/SqlTruncateException.cs: 
+       * System.Data.SqlTypes/SqlTypeException.cs: Added to CVS.
+
+2002-05-02  Rodrigo Moya <rodrigo@ximian.com>
+
+       * System.Data/DataViewSettingCollection.cs: implemented.
+
+       * System.Data/DataRowView.cs: new stubs.
+
+       * System.Data.SqlTypes/SqlByte.cs:
+       * System.Data.SqlTypes/SqlDateTime.cs:
+       * System.Data.SqlTypes/SqlDecimal.cs:
+       * System.Data.SqlTypes/SqlDouble.cs:
+       * System.Data.SqlTypes/SqlGuid.cs:
+       * System.Data.SqlTypes/SqlInt16.cs:
+       * System.Data.SqlTypes/SqlInt64.cs:
+       * System.Data.SqlTypes/SqlMoney.cs:
+       * System.Data.SqlTypes/SqlSingle.cs: new stubs, contributed
+       by Tim Coleman <tcoleman@opentext.com>
+
+       * System.Data.build: excluded newly-added files.
+
+2002-05-02  Daniel Morgan <danmorg@sc.rr.com>
+
+       * System.Data.SqlClient/PostgresLibrary.cs: included new 
+       internal class that will be a helper class in using
+       PostgreSQL.  PostgresLibrary is used for the 
+       pinvoke methods to the PostgreSQL Client
+       native C library libpq while the class PostgresHelper 
+       is used for     wrapper or helper methods.  It currently only
+       has one static method OidTypeToSystem in converting
+       PostgreSQL types to .NET System.<type>s, such as,
+       a PostgreSQL int8 becomes a .NET System.Int64.
+       Only a few types have been added, such as, int2,
+       int4, int8, varchar, text, bool, and char.  Other types
+       will come later.
+       
+       * System.Data.SqlClient/SqlCommand.cs: implemented
+       method ExecuteScalar which allows us to do aggregate
+       functions, such as, count, avg, min, max, and sum.  We
+       also are able to retrieve the result, convert it to the .NET type
+       as an object.  The user of the returned object must explicitly cast.
+       
+       * Test/ReadPostgresData.cs: updated sample
+       to help us learn to retrieve data in System.Data.SqlClient
+       classes
+
+2002-05-01  Daniel Morgan <danmorg@sc.rr.com>
+
+       * System.Data.build: added /nowarn: nnnn arguments 
+       so you will not get a ton of warnings.  The warnings
+       being excluded are: 1595, 0067, 0109, 0169, and 0649
+
+2002-05-01  Daniel Morgan <danmorg@sc.rr.com>
+
+       * System.Data.build: modified to exclude more 
+       files from the build
+
+2002-05-01  Rodrigo Moya <rodrigo@ximian.com>
+
+       * System.Data.SqlClient/SqlClientPermission.cs: added missing
+       'using's.
+
+       * System.Data/MergeFailedEventArgs.cs: new class, contributed
+       by John Dugaw <jdugaw@unizenconsulting.com>.
+
+       * System.Data.build: excluded new files from build.
+
+2002-04-29  Daniel Morgan <danmorg@sc.rr.com>
+
+       * Test/ReadPostgresData.cs: added - Uses the 
+       PostgresLibrary to retrieve a recordset.
+       This is not meant to be used in Production, but as a
+       learning aid in coding 
+       class System.Data.SqlClient.SqlDataReader.
+       This sample does work.
+       
+       * Test/TestSqlDataReader.cs: added - used
+       to test SqlDataReader (does not work yet)
+       Forgot to add to ChangeLog on last commit.
+
+2002-04-28  Rodrigo Moya <rodrigo@ximian.com>
+
+       * System.Data/DataViewSetting.cs: new class.
+       
 2002-04-28  Rodrigo Moya <rodrigo@ximian.com>
 
        * System.Data/DataViewManager.cs: new class.