Files
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

90 lines
3.2 KiB
Plaintext

DATABASE: monotest
========================== TABLE : numeric_family ==================================
TABLE: numeric_family
id int PRIMARY KEY NOT NULL
type_bit bit NULL
type_tinyint tinyint NULL
type_smallint smallint NULL
type_int int NULL
type_bigint bigint NULL
type_decimal decimal (38, 0) NULL
type_numeric numeric (38, 0) NULL
type_money money NULL
type_smallmoney smallmoney NULL
DATA:
insert into numeric_family values (1,1,255,32767,2147483647,9223372036854775807,1000,1000,922337203685477.5807,214748.3647);
insert into numeric_family values (2,0,0,-32768,-2147483648,-9223372036854775808,-1000,-1000,-922337203685477.5808,-214748.3648);
insert into numeric_family values (3,0,0,0,0,0,0,0,0,0);
insert into numeric_family values (4,null,null,null,null,null,null,null,null,null);
go
========================== END TABLE : numeric_family ===============================
========================== TABLE : binary_family ====================================
TABLE: binary_family
id int PRIMARY KEY NOT NULL
type_binary binary NULL
type_varbinary varbinary (255) NULL
type_blob image NULL
type_tinyblob image NULL
type_mediumblob image NULL
type_longblob_image image NULL
insert into binary_family values (1, convert (image, '555555'), convert (image, '0123456789012345678901234567890123456789012345678901234567890123456789'),
convert (image, '66666666'), convert (image, '777777'),
convert (image, '888888'), convert (image, '999999'));
--insert into binary_family values (2,
--insert into binary_family values (3,
insert into binary_family values (4,null,null,null,null,null,null);
========================== END TABLE : binary_family ================================
=================================== TABLE: EMPLOYEE ================================
TABLE : employee
id int PRIMARY KEY NOT NULL
fname varchar (50) NOT NULL
lname varchar (50) NULL
dob datetime NOT NULL
doj datetime NOT NULL
email varchar (50) NULL
insert into employee values (1, 'suresh', 'kumar', '1978-08-22', '2001-03-12', '[email protected]');
insert into employee values (2, 'ramesh', 'rajendran', '1977-02-15', '2005-02-11', '[email protected]');
insert into employee values (3, 'venkat', 'ramakrishnan', '1977-06-12', '2003-12-11', '[email protected]');
insert into employee values (4, 'ramu', 'dhasarath', '1977-02-15', '2005-02-11', '[email protected]');
=============================== END TABLE: EMPLOYEE ================================
=============================== STORED PROCEDURE : sp_clean_employee_table =========
SP : sp_clean_employee_table
NAME: sp_clean_employee_table
PROCESS:
delete from employee where id > 6000;
============================ END STORED PROCEDURE : sp_clean_employee_table =========
============================ STORED PROCEDURE : sp_get_age ==========================
NAME: procedure sp_get_age
PARAMETER :
NAME : fname TYPE: varchar (50) DIRECTION : in
NAME : age TYPE: int DIRECTION : out
PROCESS:
select age = datediff (day, dob, getdate ()) from employee where fname like fname;
return age;
=================================== END PROCEDURE : sp_get_age =====================