17 Commits
Author SHA1 Message Date
Egor Bogatov 2115cd7394 [System.Data] Integration tests (#4538) 2017-03-22 13:51:57 +01:00
Alexander Köplinger b03e606287 Remove ChangeLog files from the repo
They weren't updated in the last 6 years and aren't helpful anymore (e.g. by causing unrelated matches during git grep searches).
2016-01-29 19:17:06 +01:00
Gert Driesen 812bfb22f4 * sqlserver7.sql: Added script for SQL Server 7.0, with unicode
encoding (as isql7 does not deal well with utf-8).

svn path=/trunk/mcs/; revision=139701
2009-08-11 11:47:32 +00:00
Gert Driesen a8a338ba57 Added input param to sp_326182b.
svn path=/trunk/mcs/; revision=123717
2009-01-17 22:40:06 +00:00
Gert Driesen 416d711c89 Added sp with mix of input and output parameters.
svn path=/trunk/mcs/; revision=123675
2009-01-17 00:46:00 +00:00
Gert Driesen 8a6bd370d1 Save as UTF-8.
svn path=/trunk/mcs/; revision=122383
2009-01-03 23:27:27 +00:00
Gert Driesen 25c01a2252 * app-default.config: Renamed to app-net_1_1.config, and added
providerTests section.
* app-net_2.0.config: Added providerTests section and removed
mono.data section.
* Makefile: Added support for CONNECTION variable and corresponding
PROVIDER_TESTS_CONNECTION environment variable. Always rebuild test
assembly since we have no dependency check for sources in place.
Only add reference to Mono.Data on 1.1 profile. Added reference to
System.Configuration on 2.0 profile.
* sqlserver.config: Merged into app-*.config.
* odbc.config: Merged into app-*.config.
* System.Data.Connected.Tests.dll.sources: Added ConnectionConfig.cs,
EngineConfig.cs, EngineType.cs, ProviderTestsConfigurationHandler.cs
and DbDataReaderTest.cs. Removed OdbcConnectionStringBuilderTest.cs.
* ConnectionConfig.cs:  Holds information on a specific connection and
corresponding engine to test.
* EngineConfig.cs: Holds information on the capabilities and behavior
of an RDBMS engine.
* EngineType.cs: Defines different database engines supported by the
provider tests.
* ConnectionManager.cs: Use DbProviderFactory and DbConnection
on 2.0 profile. Added support for new Connection/Engine configuration.
* ProviderTestsConfigurationHandler.cs: IConfigurationSectionHandler
for the ProviderTests section.
* DataReaderTest.cs: Added tests that were previously part of
SqlClient tests but apply to all families. Improved existing
tests.
* DbDataReaderTest.cs: Added GetProviderSpecificValues error check
 tests.
* IDbCommandTest.cs: Added ExecuteNonQuery tests for empty CommandText.
Added test for bug #462947.
* OdbcCommandBuilderTest.cs: Improved GetDeleteCommand,
GetInsertCommand and GetUpdateCommand tests. Added QuotePrefix,
QuoteSuffix and QuoteIdentifier tests.
* OdbcCommandTest.cs: Improved existing tests. Added
ExecuteNonQuery and Dispose tests.
* OdbcConnectionStringBuilderTest.cs: Moved to System.Data
test suite.
* OdbcDataAdapterTest.cs: Removed extra whitespace.
* OdbcDataReaderTest.cs: Added GetBytes and GetSchemaTable
tests.
* OdbcParameterCollectionTest.cs: Improve existing tests.
* OdbcParameterTest.cs: Added tests for several data types.
* SqlCommandBuilderTest.cs: Improve Get*Command tests.
* SqlCommandTest.cs: Added test for bug #341743. Added test
for connection state after executing invalid SQL. Improved
stored procedure test to check behavior with and without
leading '@' for parameter names. Minor formatting changes.
* SqlConnectionTest.cs: Split up connection string errors
test.
* SqlDataReaderTest.cs: Improved GetInt64Test. Improved and
added GetBytes tests. Added GetSqlValues and HasRows tests.
Added GetSchemaTable test. Improved GetProviderSpecificFieldType
tests.
* SqlParameterTest.cs: Improved ParameterType test. Added
type inferrence tests.
* SqlTransactionTest.cs: Allow not working tests to run on MS.
* MySQL_5.sql: Added numeric and decimal colums with different
precision and scale. Added more rows to binary_family. Added
nchar and nvarchar columns to string_family, and added extra
data. Added time and date columns to datetime_family.
* sqlserver.sql: Added numeric and decimal colums with different
precision and scale. Added timestamp column and more rows to
binary_family. Added nchar and nvarchar columns to string_family,
and added extra data. Added sp_326182 stored procedure.
* sybase.sql: Added more rows to binary_family.

svn path=/trunk/mcs/; revision=122297
2008-12-31 15:35:07 +00:00
Nagappan Alagappan db8ea6e71f 2007-06-06 Nagappan A <[email protected]>
* MySQL_5.sql: Fixed EOL and extra spaces.


svn path=/trunk/mcs/; revision=78729
2007-06-06 12:18:56 +00:00
Nagappan Alagappan 01ca77c113 2007-06-06 Nagappan A <[email protected]>
* MySQL_5.sql: Added more sql statements.


svn path=/trunk/mcs/; revision=78725
2007-06-06 11:50:35 +00:00
Nagappan Alagappan 754339e7c3 2007-05-30 Nagappan A <[email protected]>
* sqlserver.sql: Fixed sqlserver sql statements and its respective
	values.


svn path=/trunk/mcs/; revision=78188
2007-05-30 10:59:08 +00:00
Nagappan Alagappan d25983f7c9 2007-02-02 Amit Biswas <[email protected]>
* MySQL_5.sql: Added this new sql script. This sql script performs
	the same operations as the existing "mysql.sql" but some sql
	commands have been changed either to fix bugs or to comply with
	MySQL Server 5.0.


svn path=/trunk/mcs/; revision=73234
2007-02-21 07:46:38 +00:00
Senganal T 79f9f4547f 2005-10-14 Senganal T <[email protected]>
* Test/ProviderTests/sql/mysql.sql: Added data for testing bug #75032
	* Test/ProviderTests/System.Data.Odbc/OdbcDataReaderTest.cs: Added test for bug #75032
	* System.Data.Odbc/OdbcDataReader.cs: Added Text and NText datatypes to the list
	of datatypes checked by GetValue () method. Fixes bug #75032


svn path=/trunk/mcs/; revision=51706
2005-10-14 08:56:22 +00:00
Sureshkumar T 88683eb2b2 In System.Data.Odbc:
2005-10-08  Sureshkumar T  <[email protected]>

	* OdbcParameterTest.cs (OdbcTypeTest): Disconnected Tests for
	OdbcParameter class.

In ProviderTests/sql:
2005-10-08  Sureshkumar T  <[email protected]>

	* mysql.sql: impact from sqlserver.sql.

In ProviderTests/System.Data.Odbc:
2005-10-08  Sureshkumar T  <[email protected]>

	* OdbcParameterTest.cs: Corrections.


svn path=/trunk/mcs/; revision=51461
2005-10-08 09:57:37 +00:00
Sureshkumar T 3f1e1a17dd 2005-09-24 Sureshkumar T <[email protected]>
In sql:

	* sybase.sql: grant permissions on objects

	* sqlserver.sql: change id as int. tiny int won't allow 6000 (the
	tempory updatable limit).

In System.Data.SqlClient:

	* SqlDataAdapterTest.cs (Fill_Test_Exceptions): passing null
	dataset name throws ArgumentNullException in ms.net

	* SqlConnectionTest.cs: HostName compare: convert to uppercase.

	* SqlDataReaderTest.cs: remove Opening connection in few test
	cases as it was done in SetUp.
	- id type change changes


svn path=/trunk/mcs/; revision=50673
2005-09-24 13:53:03 +00:00
Senganal T e520ee3e0a 2005-09-16 Senganal T <[email protected]>
* System.Data.Connected.Tests.dll.sources: added more source files 
	* sql/sqlserver.sql: modified. added string_family, datetime_family,
	  modified numeric_family values.
	  created new database mono-test for checking -.
	* Common/DataProvider.cs : Provides data for validation
	  DataProvider provides the data that is used for
	  validating Sq[DataReader. Currently it uses a dataset
	  to fill data from the database. Will be modified later to
	  get the values from a config file.
	* System.Data.SqlClient/SqlCommandTest.cs: added more testcases 
	  for connected mode
	* System.Data.SqlClient/SqlConnectionTest.cs: added more testcases
	  for connected mode
	* System.Data.SqlClient/SqlDataAdapterTest.cs: added more testcases 
	  for connected mode
	* System.Data.SqlClient/SqlDataReaderTest.cs: added more testcases 
	  for connected mode


svn path=/trunk/mcs/; revision=50153
2005-09-16 15:51:44 +00:00
Sureshkumar T 3435f767fe 2005-09-13 Sureshkumar T <[email protected]>
* sql/sybase.sql: added. script file to create test database on
	sybase.
	* Makefile: Added reference to Sybase db.


svn path=/trunk/mcs/; revision=49966
2005-09-13 13:50:22 +00:00
Sureshkumar T cce8383f1e added a new framework for testing data providers using nunit and mono.data's provider
factory. Moved few stand-alone tests from Test/ to this framework.

In Test:
2005-09-01  Sureshkumar T  <[email protected]>

	* ProviderTests: Added a new framework for testing Data
	Providers. This framework is based on nunit category tests and
	also the provider factory provided by Mono.Data.

In Test/System.Data.SqlClient:
2005-09-01  Sureshkumar T  <[email protected]>

	* SqlDataReaderTest.cs: moved to ProviderTests and integrated with
	connected mode tests
	* SqlCommandTest.cs: -- do --
	* SqlConnectionTest.cs: -- do --
	* SqlTransactionTest.cs: -- do --
	* SqlDataAdapterTest.cs: -- do --

In Test/System.Data.Odbc:
2005-09-01  Sureshkumar T  <[email protected]>

	* OdbcDataAdapterTest.cs: moved to ProviderTests and integrated
	with connected more framework.
	* OdbcCommandTest.cs: -- do --.

	* OdbcParameterCollectionTest.cs: Removed ParameterLengthTrimTest
	to ProviderTests.

In Test/ProviderTests/sql:
2005-09-01  Sureshkumar T  <[email protected]>

	* SCHEMA: schema specification.

	* sqlserver.sql: sql script file to create test schema for mssql
	database. added.

	* mysql.sql: sql script file to create test schema for mysql
	database. added.

In Test/ProviderTests/System.Data.Odbc:
2005-09-01  Sureshkumar T  <[email protected]>

	* OdbcCommandBuilderTest.cs: Added tests for OdbcCommandBuilder.cs
	* OdbcCommandTest.cs: pulled from Test/System.Data.Odbc
	* OdbcDataAdapterTest.cs: pulled from Test/System.Data.Odbc
	* OdbcDataReaderTest.cs: pulled from Test/System.Data.Odbc
	* OdbcParameterCollectionTest.cs: pulled from Test/System.Data.Odbc

In Test/ProviderTests/ProviderIndependant:
2005-09-01  Sureshkumar T  <[email protected]>

	* IDbCommandTest.cs: Added. Provider independent Command tests.

	* DataReaderTest.cs: Added. Provider independent DataReader tests.

In Test/ProviderTests:
2005-09-01  Sureshkumar T  <[email protected]>

	* System.Data.Connected.Tests.dll.sources: source files.

	* app-default.config:
	* app-net_2_0.config:
	configuration files for profiles and lists the assembly
	informations for the Provider factory.

	* odbc.config:
	* sqlserver.config:
	connection string info for respective databases.

	* README: initial.

	pulled connected mode test-cases around Test/* directory into this
	new framework. This framework is based on nunit category based
	test-cases and uses Provider Factories provided in Mono.Data.dll
	to write provider independent code.

In Test/ProviderTests/Common:
2005-09-01  Sureshkumar T  <[email protected]>

	* DBHelper.cs: Added. Class to provide helper methods for other tests.

	* ConnectionManager.cs: Added. Class to manage connections

In Test/ProviderTests/System.Data.SqlClient:
2005-09-01  Sureshkumar T  <[email protected]>

	* SqlCommandBuilderTest.cs: added tests for SqlCommandBuilder
	* SqlCommandTest.cs: pulled from Test/System.Data.SqlClient
	* SqlConnectionStringBuilderTest.cs: pulled from Test/System.Data.SqlClient
	* SqlConnectionTest.cs: pulled from Test/System.Data.SqlClient
	* SqlDataAdapterTest.cs: pulled from Test/System.Data.SqlClient
	* SqlDataReaderTest.cs: pulled from Test/System.Data.SqlClient
	* SqlTransactionTest.cs: pulled from Test/System.Data.SqlClient

	Added attribute Category ("sqlserver") to all these test fixtures.



svn path=/trunk/mcs/; revision=49260
2005-09-01 11:50:04 +00:00