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 746650d1b9 [bcl] Remove more NET_2_0 checks from class libs 2015-01-17 05:45:39 +01:00
vvaradhan b2285ad835 2010-09-29 Veerapuram Varadhan <[email protected]>
** Fixes failed test for smallmoney
	* Tds70.cs (WriteParameterInfo): Round money values to 4
	decimals, for smallmoney too.
2010-10-01 19:17:48 +05:30
vvaradhan 2ff8ca98f1 2010-09-20 Veerapuram Varadhan <[email protected]>
* SqlDataReaderTest.cs: Add test for bug#613087
2010-09-29 14:39:01 +05:30
Gert Driesen 5def661365 * SqlDataReaderTest.cs: Fixes for SQL Server 7.0 / TDS 7. Avoid
catching and rethrowing AssertionException. Minor code formatting
changes.

svn path=/trunk/mcs/; revision=139244
2009-08-01 14:38:27 +00:00
Veerapuram Varadhan fd5ac5b3ed TDS 8 changes
svn path=/trunk/mcs/; revision=125333
2009-02-02 11:05:18 +00:00
Gert Driesen a2589359cd * SqlCommandBuilderTest.cs: Improved tests to also check
behavior of RefreshSchema.
* SqlDataReaderTest.cs: Added tests for GetBytes.

svn path=/trunk/mcs/; revision=122398
2009-01-04 21:45:09 +00:00
Gert Driesen 37d01cae34 * SqlCommandBuilderTest.cs: Improve Get*Command tests.
* SqlCommandTest.cs: Fixed warning.
* SqlConnectionTest.cs: Removed unused property.
* SqlDataReaderTest.cs: Enabled GetChars test on 1.0
profile. Added GetValues test. Added and improved
GetSqlValue tests. Improved HasRows and NextResult
tests. Added GetFieldType tests. Added big batch of
schema-related tests.
* SqlParameterTest.cs: Moved disconnected tests to
System.Data test suite. Improved test for bug
#382635. Added test for failed conversion to SQL type.


svn path=/trunk/mcs/; revision=122382
2009-01-03 23:24:47 +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 7903207616 2007-05-30 Nagappan A <[email protected]>
* SqlCommandTest.cs (StoredProc_NoParameterTest)
	(StoredProc_ParameterTest, rpc_helper_function): Added new methods
	to test the implementation of TDS RPC.


svn path=/trunk/mcs/; revision=78189
2007-05-30 11:02:36 +00:00
Nagappan Alagappan 903da96171 2007-04-03 Amit Biswas <[email protected]>
* SqlDataReaderTest.cs (GetSqlBytesTest): Test case for GetSqlBytes
	(GetProviderSpecificFieldTypeTest): Test case for GetProviderSpecificFieldTypeTest
	(GetProviderSpecificValueTest): Test case for GetProviderSpecificValueTest
	(GetProviderSpecificValueLowerBoundaryTest):
	(GetProviderSpecificValueUpperBoundaryTest):
	(GetProviderSpecificValuesTest): Test case for GetProviderSpecificValuesTest
	(GetProviderSpecificValuesSmallArrayTest): Test case with an array smaller than no. of columns
	(GetProviderSpecificValuesLargeArrayTest): Test case with an array larger than no. of columns
	(GetProviderSpecificValuesNullTest): Test case for null parameters

	* SqlParameterTest.cs (XmlSchemaTest): Test case for properties related to XML schema
	(SourceColumnNullMappingTest): Test case for SourceColumnNullMappingTest
	(ctor7Test): Test case to the constructor new in .net 2.0

	* SqlParameterTest.cs (ParameterType): Corrected a bug in the test case regarding
	default values of SqlDbType and DbType
	(SqlDbTypeTest): Test for SqlDbType and DbType properties
	(ResetSqlDbTypeTest): Test for ResetSqlDbType method
	(ResetDbTypeTest): Test for ResetDbType method

	* SqlParameterCollectionTest.cs (CopyToTest): Test case for CopyTo method


svn path=/trunk/mcs/; revision=76656
2007-05-04 04:08:23 +00:00
Nagappan Alagappan e7d0548097 2007-01-08 Nagappan A <[email protected]>
* SqlCommandBuilderTest.cs (GetInsertCommandTest)
	(GetInsertCommandTestWithExpression, GetUpdateCommandTest): Fixed
	NET 2.0 based test conditions.
	(GetUpdateCommandBoolTest): Added new test case.
	(GetUpdateCommandTest_CheckNonUpdatableColumns): Fixed NET 2.0
	based test conditions.
	(GetUpdateCommandBoolTest_CheckNonUpdatableColumns): Added new test
	case.
	(GetUpdateDeleteCommandBoolTest_CheckParameters): Added new test
	case.
	(GetUpdateCommandDBConcurrencyExceptionTest): Fixed NET 2.0 based
	test conditions.

	* SqlDataAdapterTest.cs: Commented not working test-cases.


svn path=/trunk/mcs/; revision=70623
2007-01-08 05:59:43 +00:00
Kornél Pál 546a1134d2 Converted source files to UTF-8 (without byte order mark). Use UTF-8 as the default encoding for compilers.
svn path=/trunk/mcs/; revision=64941
2006-09-05 13:54:12 +00:00
Senganal T 1ed319dc99 2006-02-10 Senganal T <[email protected]>
* Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds.cs :
		- GetSequentialColumn,BeginLoad, EndLoad,
		LoadData, SkipRow, SkipToColumnIndex
		New Methods to Support sequential loading of row data
	* Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs :
		- Skip : Changed arugment type from int to long.
	* System.Data/Test/ProviderTests/System.Data.SqlClient/SqlDataReaderTest.cs : 
		Added more tests to verify Sequential reading of row data.
	* System.Data/Test/ProviderTests/ProviderIndependant/DataReaderTest : Corrected a failing testcase.
	* System.Data/System.Data.SqlClient/SqlDataReader.cs :
		- GetBytes : Read binary/blob/clob data sequentially when
		CommandBehavior is set to SequentialAcccess
		- GetChars : Read String/clob data sequentially when CommandBehavior
		is set to SequentialAccess
	* System.Data/System.Data.SqlClient/SqlCommand.cs :
		- ExecuteReader : set SequentialAccess property on TDS
		- CloseDataReader : Reset the command behavior


svn path=/trunk/mcs/; revision=56757
2006-02-10 14:50:55 +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 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