From edf2251aca60a970e822079d23933e5b70b26571 Mon Sep 17 00:00:00 2001 From: ctrlaltca <> Date: Wed, 2 Jan 2013 14:42:24 +0000 Subject: backported all related changes up to 3229 to branch/3.2 --- tests/unit/SQLMap/scripts/mssql/DBCreation.sql | 89 ---------- tests/unit/SQLMap/scripts/mssql/DataBase.sql | 179 --------------------- .../SQLMap/scripts/mssql/README-embed-param.txt | 8 - tests/unit/SQLMap/scripts/mssql/account-init.sql | 47 ------ .../SQLMap/scripts/mssql/account-procedure.sql | 12 -- tests/unit/SQLMap/scripts/mssql/category-init.sql | 17 -- .../SQLMap/scripts/mssql/category-procedure.sql | 10 -- tests/unit/SQLMap/scripts/mssql/documents-init.sql | 34 ---- .../scripts/mssql/embed-param-setup-init.sql | 94 ----------- .../SQLMap/scripts/mssql/embed-param-test-init.sql | 32 ---- .../unit/SQLMap/scripts/mssql/enumeration-init.sql | 30 ---- tests/unit/SQLMap/scripts/mssql/line-item-init.sql | 53 ------ .../SQLMap/scripts/mssql/more-account-records.sql | 11 -- tests/unit/SQLMap/scripts/mssql/order-init.sql | 54 ------- tests/unit/SQLMap/scripts/mssql/other-init.sql | 145 ----------------- .../unit/SQLMap/scripts/mssql/ps_SelectAccount.sql | 10 -- tests/unit/SQLMap/scripts/mssql/swap-procedure.sql | 34 ---- tests/unit/SQLMap/scripts/mssql/user-init.sql | 17 -- 18 files changed, 876 deletions(-) delete mode 100644 tests/unit/SQLMap/scripts/mssql/DBCreation.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/DataBase.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/README-embed-param.txt delete mode 100644 tests/unit/SQLMap/scripts/mssql/account-init.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/account-procedure.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/category-init.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/category-procedure.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/documents-init.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/embed-param-setup-init.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/embed-param-test-init.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/enumeration-init.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/line-item-init.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/more-account-records.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/order-init.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/other-init.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/ps_SelectAccount.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/swap-procedure.sql delete mode 100644 tests/unit/SQLMap/scripts/mssql/user-init.sql (limited to 'tests/unit/SQLMap/scripts/mssql') diff --git a/tests/unit/SQLMap/scripts/mssql/DBCreation.sql b/tests/unit/SQLMap/scripts/mssql/DBCreation.sql deleted file mode 100644 index c5ed9517..00000000 --- a/tests/unit/SQLMap/scripts/mssql/DBCreation.sql +++ /dev/null @@ -1,89 +0,0 @@ --- MSQL DATABASE - -IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'IBatisNet') - DROP DATABASE [IBatisNet] -GO - -CREATE DATABASE [IBatisNet] - COLLATE Latin1_General_CI_AS -GO - -exec sp_dboption N'IBatisNet', N'autoclose', N'true' -GO - -exec sp_dboption N'IBatisNet', N'bulkcopy', N'false' -GO - -exec sp_dboption N'IBatisNet', N'trunc. log', N'true' -GO - -exec sp_dboption N'IBatisNet', N'torn page detection', N'true' -GO - -exec sp_dboption N'IBatisNet', N'read only', N'false' -GO - -exec sp_dboption N'IBatisNet', N'dbo use', N'false' -GO - -exec sp_dboption N'IBatisNet', N'single', N'false' -GO - -exec sp_dboption N'IBatisNet', N'autoshrink', N'true' -GO - -exec sp_dboption N'IBatisNet', N'ANSI null default', N'false' -GO - -exec sp_dboption N'IBatisNet', N'recursive triggers', N'false' -GO - -exec sp_dboption N'IBatisNet', N'ANSI nulls', N'false' -GO - -exec sp_dboption N'IBatisNet', N'concat null yields null', N'false' -GO - -exec sp_dboption N'IBatisNet', N'cursor close on commit', N'false' -GO - -exec sp_dboption N'IBatisNet', N'default to local cursor', N'false' -GO - -exec sp_dboption N'IBatisNet', N'quoted identifier', N'false' -GO - -exec sp_dboption N'IBatisNet', N'ANSI warnings', N'false' -GO - -exec sp_dboption N'IBatisNet', N'auto create statistics', N'true' -GO - -exec sp_dboption N'IBatisNet', N'auto update statistics', N'true' -GO - -if( ( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) ) or ( (@@microsoftversion / power(2, 24) = 7) and (@@microsoftversion & 0xffff >= 1082) ) ) - exec sp_dboption N'IBatisNet', N'db chaining', N'false' -GO - -if exists (select * from master.dbo.syslogins where loginname = N'IBatisNet') - exec sp_droplogin N'IBatisNet' -GO - -use [IBatisNet] -GO - -if not exists (select * from master.dbo.syslogins where loginname = N'IBatisNet') -BEGIN - declare @logindb nvarchar(132), @loginpass nvarchar(132), @loginlang nvarchar(132) - select @logindb = N'IBatisNet', @loginpass=N'test', @loginlang = N'us_english' - exec sp_addlogin N'IBatisNet', @loginpass, @logindb, @loginlang -END -GO - -if not exists (select * from dbo.sysusers where name = N'IBatisNet' and uid < 16382) - EXEC sp_grantdbaccess N'IBatisNet', N'IBatisNet' -GO - -exec sp_addrolemember N'db_owner', N'IBatisNet' -GO \ No newline at end of file diff --git a/tests/unit/SQLMap/scripts/mssql/DataBase.sql b/tests/unit/SQLMap/scripts/mssql/DataBase.sql deleted file mode 100644 index 733e2f99..00000000 --- a/tests/unit/SQLMap/scripts/mssql/DataBase.sql +++ /dev/null @@ -1,179 +0,0 @@ --- MSQL DATABASE 'IBatisNet' - -IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'IBatisNet') - DROP DATABASE [IBatisNet] -GO - -CREATE DATABASE [IBatisNet] - COLLATE Latin1_General_CI_AS -GO - -exec sp_dboption N'IBatisNet', N'autoclose', N'true' -GO - -exec sp_dboption N'IBatisNet', N'bulkcopy', N'false' -GO - -exec sp_dboption N'IBatisNet', N'trunc. log', N'true' -GO - -exec sp_dboption N'IBatisNet', N'torn page detection', N'true' -GO - -exec sp_dboption N'IBatisNet', N'read only', N'false' -GO - -exec sp_dboption N'IBatisNet', N'dbo use', N'false' -GO - -exec sp_dboption N'IBatisNet', N'single', N'false' -GO - -exec sp_dboption N'IBatisNet', N'autoshrink', N'true' -GO - -exec sp_dboption N'IBatisNet', N'ANSI null default', N'false' -GO - -exec sp_dboption N'IBatisNet', N'recursive triggers', N'false' -GO - -exec sp_dboption N'IBatisNet', N'ANSI nulls', N'false' -GO - -exec sp_dboption N'IBatisNet', N'concat null yields null', N'false' -GO - -exec sp_dboption N'IBatisNet', N'cursor close on commit', N'false' -GO - -exec sp_dboption N'IBatisNet', N'default to local cursor', N'false' -GO - -exec sp_dboption N'IBatisNet', N'quoted identifier', N'false' -GO - -exec sp_dboption N'IBatisNet', N'ANSI warnings', N'false' -GO - -exec sp_dboption N'IBatisNet', N'auto create statistics', N'true' -GO - -exec sp_dboption N'IBatisNet', N'auto update statistics', N'true' -GO - -if( ( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) ) or ( (@@microsoftversion / power(2, 24) = 7) and (@@microsoftversion & 0xffff >= 1082) ) ) - exec sp_dboption N'IBatisNet', N'db chaining', N'false' -GO - -if exists (select * from master.dbo.syslogins where loginname = N'IBatisNet') - exec sp_droplogin N'IBatisNet' -GO - -use [IBatisNet] -GO - -if not exists (select * from master.dbo.syslogins where loginname = N'IBatisNet') -BEGIN - declare @logindb nvarchar(132), @loginpass nvarchar(132), @loginlang nvarchar(132) - select @logindb = N'IBatisNet', @loginpass=N'test', @loginlang = N'us_english' - exec sp_addlogin N'IBatisNet', @loginpass, @logindb, @loginlang -END -GO - -if not exists (select * from dbo.sysusers where name = N'IBatisNet' and uid < 16382) - EXEC sp_grantdbaccess N'IBatisNet', N'IBatisNet' -GO - -exec sp_addrolemember N'db_owner', N'IBatisNet' -GO - --- MSQL DATABASE 'NHibernate' - -IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'NHibernate') - DROP DATABASE [NHibernate] -GO - -CREATE DATABASE [NHibernate] - COLLATE Latin1_General_CI_AS -GO - -exec sp_dboption N'NHibernate', N'autoclose', N'true' -GO - -exec sp_dboption N'NHibernate', N'bulkcopy', N'false' -GO - -exec sp_dboption N'NHibernate', N'trunc. log', N'true' -GO - -exec sp_dboption N'NHibernate', N'torn page detection', N'true' -GO - -exec sp_dboption N'NHibernate', N'read only', N'false' -GO - -exec sp_dboption N'NHibernate', N'dbo use', N'false' -GO - -exec sp_dboption N'NHibernate', N'single', N'false' -GO - -exec sp_dboption N'NHibernate', N'autoshrink', N'true' -GO - -exec sp_dboption N'NHibernate', N'ANSI null default', N'false' -GO - -exec sp_dboption N'NHibernate', N'recursive triggers', N'false' -GO - -exec sp_dboption N'NHibernate', N'ANSI nulls', N'false' -GO - -exec sp_dboption N'NHibernate', N'concat null yields null', N'false' -GO - -exec sp_dboption N'NHibernate', N'cursor close on commit', N'false' -GO - -exec sp_dboption N'NHibernate', N'default to local cursor', N'false' -GO - -exec sp_dboption N'NHibernate', N'quoted identifier', N'false' -GO - -exec sp_dboption N'NHibernate', N'ANSI warnings', N'false' -GO - -exec sp_dboption N'NHibernate', N'auto create statistics', N'true' -GO - -exec sp_dboption N'NHibernate', N'auto update statistics', N'true' -GO - -if( ( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) ) or ( (@@microsoftversion / power(2, 24) = 7) and (@@microsoftversion & 0xffff >= 1082) ) ) - exec sp_dboption N'NHibernate', N'db chaining', N'false' -GO - -if exists (select * from master.dbo.syslogins where loginname = N'NHibernate') - exec sp_droplogin N'NHibernate' -GO - -use [NHibernate] -GO - -if not exists (select * from master.dbo.syslogins where loginname = N'NHibernate') -BEGIN - declare @logindb nvarchar(132), @loginpass nvarchar(132), @loginlang nvarchar(132) - select @logindb = N'NHibernate', @loginpass=N'test', @loginlang = N'us_english' - exec sp_addlogin N'NHibernate', @loginpass, @logindb, @loginlang -END -GO - -if not exists (select * from dbo.sysusers where name = N'NHibernate' and uid < 16382) - EXEC sp_grantdbaccess N'NHibernate', N'NHibernate' -GO - -exec sp_addrolemember N'db_owner', N'NHibernate' -GO \ No newline at end of file diff --git a/tests/unit/SQLMap/scripts/mssql/README-embed-param.txt b/tests/unit/SQLMap/scripts/mssql/README-embed-param.txt deleted file mode 100644 index 355ebf42..00000000 --- a/tests/unit/SQLMap/scripts/mssql/README-embed-param.txt +++ /dev/null @@ -1,8 +0,0 @@ -Technique for creating large sample test data from: - -http://www.sql-server-performance.com/jc_large_data_operations.asp - -Make sure you have enough space and have either enough processing power or -enough patience to run the Embed Parameters in Statement tests. - -Run embed-parameters-setup-init.sql prior to running tests. diff --git a/tests/unit/SQLMap/scripts/mssql/account-init.sql b/tests/unit/SQLMap/scripts/mssql/account-init.sql deleted file mode 100644 index 8334798b..00000000 --- a/tests/unit/SQLMap/scripts/mssql/account-init.sql +++ /dev/null @@ -1,47 +0,0 @@ --- Creating Table - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Accounts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Orders_Accounts]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) - ALTER TABLE [dbo].[Orders] DROP CONSTRAINT FK_Orders_Accounts - - drop table [dbo].[Accounts] -END - -CREATE TABLE [dbo].[Accounts] ( - [Account_ID] [int] NOT NULL , - [Account_FirstName] [varchar] (32) NOT NULL , - [Account_LastName] [varchar] (32) NOT NULL , - [Account_Email] [varchar] (128) NULL, - [Account_Banner_Option] [varchar] (255), - [Account_Cart_Option] [int] -) ON [PRIMARY] - -ALTER TABLE [dbo].[Accounts] WITH NOCHECK ADD - CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED - ( - [Account_ID] - ) ON [PRIMARY] - --- Creating Test Data - -INSERT INTO [dbo].[Accounts] VALUES(1,'Joe', 'Dalton', 'Joe.Dalton@somewhere.com', 'Oui', 200); -INSERT INTO [dbo].[Accounts] VALUES(2,'Averel', 'Dalton', 'Averel.Dalton@somewhere.com', 'Oui', 200); -INSERT INTO [dbo].[Accounts] VALUES(3,'William', 'Dalton', null, 'Non', 100); -INSERT INTO [dbo].[Accounts] VALUES(4,'Jack', 'Dalton', 'Jack.Dalton@somewhere.com', 'Non', 100); -INSERT INTO [dbo].[Accounts] VALUES(5,'Gilles', 'Bayon', null, 'Oui', 100); - --- Store procedure - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ps_InsertAccount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) -drop procedure [dbo].[ps_InsertAccount] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ps_SelectAccount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) -drop procedure [dbo].[ps_SelectAccount] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ps_swap_email_address]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) -drop procedure [dbo].[ps_swap_email_address] - - diff --git a/tests/unit/SQLMap/scripts/mssql/account-procedure.sql b/tests/unit/SQLMap/scripts/mssql/account-procedure.sql deleted file mode 100644 index a18e1522..00000000 --- a/tests/unit/SQLMap/scripts/mssql/account-procedure.sql +++ /dev/null @@ -1,12 +0,0 @@ -CREATE PROCEDURE dbo.[ps_InsertAccount] -@Account_ID [int], -@Account_FirstName [nvarchar] (40), -@Account_LastName [varchar] (32), -@Account_Email [varchar] (128), -@Account_Banner_Option [varchar] (255), -@Account_Cart_Option [int] -AS -insert into Accounts - (Account_ID, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option) -values - (@Account_ID, @Account_FirstName, @Account_LastName, @Account_Email, @Account_Banner_Option, @Account_Cart_Option) diff --git a/tests/unit/SQLMap/scripts/mssql/category-init.sql b/tests/unit/SQLMap/scripts/mssql/category-init.sql deleted file mode 100644 index c0d20603..00000000 --- a/tests/unit/SQLMap/scripts/mssql/category-init.sql +++ /dev/null @@ -1,17 +0,0 @@ --- Creating Table - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Categories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [dbo].[Categories] - -CREATE TABLE [dbo].[Categories] ( - [Category_Id] [int] IDENTITY (1, 1) NOT NULL , - [Category_Name] [varchar] (32) NULL, - [Category_Guid] [uniqueidentifier] NULL -) ON [PRIMARY] - --- Store procedure - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ps_InsertCategorie]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) -drop procedure [dbo].[ps_InsertCategorie] diff --git a/tests/unit/SQLMap/scripts/mssql/category-procedure.sql b/tests/unit/SQLMap/scripts/mssql/category-procedure.sql deleted file mode 100644 index 45fcda2c..00000000 --- a/tests/unit/SQLMap/scripts/mssql/category-procedure.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE PROCEDURE dbo.[ps_InsertCategorie] -@Category_Id [int] output, -@Category_Name [varchar] (32), -@Category_Guid [uniqueidentifier] -AS -insert into Categories - (Category_Name, Category_Guid ) -values - (@Category_Name, @Category_Guid) -SELECT @Category_Id = SCOPE_IDENTITY() \ No newline at end of file diff --git a/tests/unit/SQLMap/scripts/mssql/documents-init.sql b/tests/unit/SQLMap/scripts/mssql/documents-init.sql deleted file mode 100644 index 686a80ad..00000000 --- a/tests/unit/SQLMap/scripts/mssql/documents-init.sql +++ /dev/null @@ -1,34 +0,0 @@ --- Creating Table - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Documents]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_LineItems_Orders]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) - ALTER TABLE [dbo].[LineItems] DROP CONSTRAINT FK_LineItems_Orders - - drop table [dbo].[Documents] -END - -CREATE TABLE [dbo].[Documents] ( - [Document_ID] [int] NOT NULL , - [Document_Title] [varchar] (32) NULL , - [Document_Type] [varchar] (32) NULL , - [Document_PageNumber] [int] NULL , - [Document_City] [varchar] (32) NULL -) ON [PRIMARY] - -ALTER TABLE [dbo].[Documents] WITH NOCHECK ADD - CONSTRAINT [PK_Documents] PRIMARY KEY CLUSTERED - ( - [Document_ID] - ) ON [PRIMARY] - --- Creating Test Data - -INSERT INTO [dbo].[Documents] VALUES (1, 'The World of Null-A', 'Book', 55, null); -INSERT INTO [dbo].[Documents] VALUES (2, 'Le Progres de Lyon', 'Newspaper', null , 'Lyon'); -INSERT INTO [dbo].[Documents] VALUES (3, 'Lord of the Rings', 'Book', 3587, null); -INSERT INTO [dbo].[Documents] VALUES (4, 'Le Canard enchaine', 'Tabloid', null , 'Paris'); -INSERT INTO [dbo].[Documents] VALUES (5, 'Le Monde', 'Broadsheet', null , 'Paris'); -INSERT INTO [dbo].[Documents] VALUES (6, 'Foundation', 'Monograph', 557, null); diff --git a/tests/unit/SQLMap/scripts/mssql/embed-param-setup-init.sql b/tests/unit/SQLMap/scripts/mssql/embed-param-setup-init.sql deleted file mode 100644 index de2c3f7b..00000000 --- a/tests/unit/SQLMap/scripts/mssql/embed-param-setup-init.sql +++ /dev/null @@ -1,94 +0,0 @@ --- Technique for creating large sample test data from --- http://www.sql-server-performance.com/jc_large_data_operations.asp - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ManyRecords]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [dbo].[ManyRecords] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ManyRecordsTest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [dbo].[ManyRecordsTest] - - - --- Create Data Storage Table -CREATE TABLE [dbo].[ManyRecords] ( - [Many_FirstID] [int] NOT NULL, - [Many_SecondID] [int] NOT NULL, - [Many_ThirdID] [int] NOT NULL, - [Many_FourthID] [int] NOT NULL, - [Many_FifthID] [int] NOT NULL, - [Many_SequenceID] [int] NOT NULL, - [Many_DistributedID] [int] NOT NULL, - [Many_SampleCharValue] [char] (10) NOT NULL, - [Many_SampleDecimal] [decimal] (9,4) NOT NULL, - [Many_SampleMoney] [money] NOT NULL, - [Many_SampleDate] [datetime] NOT NULL, - [Many_SequenceDate] [datetime] NOT NULL ) -ON [PRIMARY] - - - --- Create Sample Data of 1 million records (increase if needed) -BEGIN TRANSACTION - DECLARE @intIndex int, @rowCount int, @seqCount int, @distValue int - SELECT @intIndex = 1, @rowCount = 1000000, @seqCount = 10000 - SELECT @distValue = @rowCount/10000 - - WHILE @intIndex <= @rowCount - BEGIN - INSERT INTO [dbo].[ManyRecords] ( - [Many_FirstID], - [Many_SecondID], - [Many_ThirdID], - [Many_FourthID], - [Many_FifthID], - [Many_SequenceID], - [Many_DistributedID], - [Many_SampleCharValue], - [Many_SampleDecimal], - [Many_SampleMoney], - [Many_SampleDate], - [Many_SequenceDate] ) - VALUES ( - @intIndex, -- First - @intIndex/2, -- Second - @intIndex/4, -- Third - @intIndex/10, -- Fourth - @intIndex/20, -- Fifth - (@intIndex-1)/@seqCount + 1, -- Sequential value - (@intIndex-1)%(@distValue) + 1, -- Distributed value - CHAR(65 + 26*rand())+CHAR(65 + 26*rand())+CHAR(65 + 26*rand())+CONVERT(char(6),CONVERT(int,100000*(9.0*rand()+1.0)))+CHAR(65 + 26*rand()), -- Char Value - 10000*rand(), -- Decimal value - 10000*rand(), -- Money value - DATEADD(hour,100000*rand(),'1990-01-01'), -- Date value - DATEADD(hour,@intIndex/5,'1990-01-01') ) -- Sequential date value - - SET @intIndex = @intIndex + 1 - END -COMMIT TRANSACTION - - - --- Create Test table using storage table sample data -SELECT - [Many_FirstID], - [Many_SecondID], - [Many_ThirdID], - [Many_FourthID], - [Many_FifthID], - [Many_SequenceID], - [Many_DistributedID], - [Many_SampleCharValue], - [Many_SampleDecimal], - [Many_SampleMoney], - [Many_SampleDate], - [Many_SequenceDate] -INTO [dbo].[ManyRecordsTest] -FROM [dbo].[ManyRecords] - - - --- Create Test table indexes -CREATE INDEX [IDX_ManyRecordsTest_Seq] ON [dbo].[ManyRecordsTest] ([Many_SequenceID]) WITH SORT_IN_TEMPDB -CREATE INDEX [IDX_ManyRecordsTest_Dist] ON [dbo].[ManyRecordsTest] ([Many_DistributedID]) WITH SORT_IN_TEMPDB \ No newline at end of file diff --git a/tests/unit/SQLMap/scripts/mssql/embed-param-test-init.sql b/tests/unit/SQLMap/scripts/mssql/embed-param-test-init.sql deleted file mode 100644 index 17affd8e..00000000 --- a/tests/unit/SQLMap/scripts/mssql/embed-param-test-init.sql +++ /dev/null @@ -1,32 +0,0 @@ --- Technique for creating large sample test data from --- http://www.sql-server-performance.com/jc_large_data_operations.asp - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ManyRecordsTest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [dbo].[ManyRecordsTest] - - - --- Create Test table using storage table sample data -SELECT - [Many_FirstID], - [Many_SecondID], - [Many_ThirdID], - [Many_FourthID], - [Many_FifthID], - [Many_SequenceID], - [Many_DistributedID], - [Many_SampleCharValue], - [Many_SampleDecimal], - [Many_SampleMoney], - [Many_SampleDate], - [Many_SequenceDate] -INTO [dbo].[ManyRecordsTest] -FROM [dbo].[ManyRecords] - - - --- Create Test table indexes -CREATE INDEX [IDX_ManyRecordsTest_Seq] ON [dbo].[ManyRecordsTest] ([Many_SequenceID]) WITH SORT_IN_TEMPDB -CREATE INDEX [IDX_ManyRecordsTest_Dist] ON [dbo].[ManyRecordsTest] ([Many_DistributedID]) WITH SORT_IN_TEMPDB \ No newline at end of file diff --git a/tests/unit/SQLMap/scripts/mssql/enumeration-init.sql b/tests/unit/SQLMap/scripts/mssql/enumeration-init.sql deleted file mode 100644 index f5ed9af1..00000000 --- a/tests/unit/SQLMap/scripts/mssql/enumeration-init.sql +++ /dev/null @@ -1,30 +0,0 @@ --- Creating Table - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Enumerations]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - drop table [dbo].[Enumerations] -END - -CREATE TABLE [dbo].[Enumerations] ( - [Enum_ID] [int] NOT NULL , - [Enum_Day] [int] NOT NULL , - [Enum_Color] [int] NOT NULL, - [Enum_Month] [int] NULL -) ON [PRIMARY] - -ALTER TABLE [dbo].[Enumerations] WITH NOCHECK ADD - CONSTRAINT [PK_Enum] PRIMARY KEY CLUSTERED - ( - [Enum_ID] - ) ON [PRIMARY] - --- Creating Test Data - -INSERT INTO [dbo].[Enumerations] VALUES(1, 1, 1, 128); -INSERT INTO [dbo].[Enumerations] VALUES(2, 2, 2, 2048); -INSERT INTO [dbo].[Enumerations] VALUES(3, 3, 4, 256); -INSERT INTO [dbo].[Enumerations] VALUES(4, 4, 8, null); - - diff --git a/tests/unit/SQLMap/scripts/mssql/line-item-init.sql b/tests/unit/SQLMap/scripts/mssql/line-item-init.sql deleted file mode 100644 index c823667b..00000000 --- a/tests/unit/SQLMap/scripts/mssql/line-item-init.sql +++ /dev/null @@ -1,53 +0,0 @@ --- Creating Table - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LineItems]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [dbo].[LineItems] - -CREATE TABLE [dbo].[LineItems] ( - [LineItem_ID] [int] NOT NULL , - [Order_ID] [int] NOT NULL , - [LineItem_Code] [varchar] (32) NOT NULL , - [LineItem_Quantity] [int] NOT NULL , - [LineItem_Price] [decimal](18, 2) NULL, - [LineItem_Picture] [image] null -) ON [PRIMARY] - -ALTER TABLE [dbo].[LineItems] WITH NOCHECK ADD - CONSTRAINT [PK_LinesItem] PRIMARY KEY CLUSTERED - ( - [LineItem_ID], - [Order_ID] - ) ON [PRIMARY] - -ALTER TABLE [dbo].[LineItems] ADD - CONSTRAINT [FK_LineItems_Orders] FOREIGN KEY - ( - [Order_ID] - ) REFERENCES [dbo].[Orders] ( - [Order_ID] - ) --- Creating Test Data - -INSERT INTO [dbo].[LineItems] VALUES (1, 10, 'ESM-34', 1, 45.43, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 10, 'QSM-98', 8, 8.40, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 9, 'DSM-78', 2, 45.40, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 9, 'TSM-12', 2, 32.12, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 8, 'DSM-16', 4, 41.30, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 8, 'GSM-65', 1, 2.20, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 7, 'WSM-27', 7, 52.10, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 7, 'ESM-23', 2, 123.34, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 6, 'QSM-39', 9, 12.12, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 6, 'ASM-45', 6, 78.77, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 5, 'ESM-48', 3, 43.87, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 5, 'WSM-98', 7, 5.40, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 4, 'RSM-57', 2, 78.90, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 4, 'XSM-78', 9, 2.34, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 3, 'DSM-59', 3, 5.70, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 3, 'DSM-53', 3, 98.78, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 2, 'DSM-37', 4, 7.80, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 2, 'FSM-12', 2, 55.78, null); -INSERT INTO [dbo].[LineItems] VALUES (1, 1, 'ESM-48', 8, 87.60, null); -INSERT INTO [dbo].[LineItems] VALUES (2, 1, 'ESM-23', 1, 55.40, null); - diff --git a/tests/unit/SQLMap/scripts/mssql/more-account-records.sql b/tests/unit/SQLMap/scripts/mssql/more-account-records.sql deleted file mode 100644 index d4b2199f..00000000 --- a/tests/unit/SQLMap/scripts/mssql/more-account-records.sql +++ /dev/null @@ -1,11 +0,0 @@ - - - --- Creating Test Data - -INSERT INTO [dbo].[Accounts] VALUES(6,'Jane', 'Calamity', 'Jane.Calamity@somewhere.com', 'Oui', 200); -INSERT INTO [dbo].[Accounts] VALUES(7,'Lucky', 'Luke', 'Lucky.Luke@somewhere.com', 'Oui', 200); -INSERT INTO [dbo].[Accounts] VALUES(8,'Ming', 'Li Foo', null, 'Non', 100); -INSERT INTO [dbo].[Accounts] VALUES(9,'O''Hara', 'Steve', 'Jack.OHara@somewhere.com', 'Oui', 200); -INSERT INTO [dbo].[Accounts] VALUES(10,'Robert', 'O''Timmins', null, 'Non', 100); - diff --git a/tests/unit/SQLMap/scripts/mssql/order-init.sql b/tests/unit/SQLMap/scripts/mssql/order-init.sql deleted file mode 100644 index b81b16ad..00000000 --- a/tests/unit/SQLMap/scripts/mssql/order-init.sql +++ /dev/null @@ -1,54 +0,0 @@ --- Creating Table - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Orders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_LineItems_Orders]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) - ALTER TABLE [dbo].[LineItems] DROP CONSTRAINT FK_LineItems_Orders - - drop table [dbo].[Orders] -END - -CREATE TABLE [dbo].[Orders] ( - [Order_ID] [int] NOT NULL , - [Account_ID] [int] NULL , - [Order_Date] [datetime] NULL , - [Order_CardType] [varchar] (32) NULL , - [Order_CardNumber] [varchar] (32) NULL , - [Order_CardExpiry] [varchar] (32) NULL , - [Order_Street] [varchar] (32) NULL , - [Order_City] [varchar] (32) NULL , - [Order_Province] [varchar] (32) NULL , - [Order_PostalCode] [varchar] (32) NULL , - [Order_FavouriteLineItem] [int] NULL -) ON [PRIMARY] - -ALTER TABLE [dbo].[Orders] WITH NOCHECK ADD - CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED - ( - [Order_ID] - ) ON [PRIMARY] - - -ALTER TABLE [dbo].[Orders] ADD - CONSTRAINT [FK_Orders_Accounts] FOREIGN KEY - ( - [Account_ID] - ) REFERENCES [dbo].[Accounts] ( - [Account_ID] - ) --- Creating Test Data -- 2003-02-15 8:15:00/ 2003-02-15 8:15:00 - -INSERT INTO [dbo].[Orders] VALUES (1, 1, '2003-02-15 8:15:00', 'VISA', '999999999999', '05/03', '11 This Street', 'Victoria', 'BC', 'C4B 4F4',2); -INSERT INTO [dbo].[Orders] VALUES (2, 4, '2003-02-15 8:15:00', 'MC', '888888888888', '06/03', '222 That Street', 'Edmonton', 'AB', 'X4K 5Y4',1); -INSERT INTO [dbo].[Orders] VALUES (3, 3, '2003-02-15 8:15:00', 'AMEX', '777777777777', '07/03', '333 Other Street', 'Regina', 'SK', 'Z4U 6Y4',2); -INSERT INTO [dbo].[Orders] VALUES (4, 2, '2003-02-15 8:15:00', 'MC', '666666666666', '08/03', '444 His Street', 'Toronto', 'ON', 'K4U 3S4',1); -INSERT INTO [dbo].[Orders] VALUES (5, 5, '2003-02-15 8:15:00', 'VISA', '555555555555', '09/03', '555 Her Street', 'Calgary', 'AB', 'J4J 7S4',2); -INSERT INTO [dbo].[Orders] VALUES (6, 5, '2003-02-15 8:15:00', 'VISA', '999999999999', '10/03', '6 Their Street', 'Victoria', 'BC', 'T4H 9G4',1); -INSERT INTO [dbo].[Orders] VALUES (7, 4, '2003-02-15 8:15:00', 'MC', '888888888888', '11/03', '77 Lucky Street', 'Edmonton', 'AB', 'R4A 0Z4',2); -INSERT INTO [dbo].[Orders] VALUES (8, 3, '2003-02-15 8:15:00', 'AMEX', '777777777777', '12/03', '888 Our Street', 'Regina', 'SK', 'S4S 7G4',1); -INSERT INTO [dbo].[Orders] VALUES (9, 2, '2003-02-15 8:15:00', 'MC', '666666666666', '01/04', '999 Your Street', 'Toronto', 'ON', 'G4D 9F4',2); -INSERT INTO [dbo].[Orders] VALUES (10, 1, '2003-02-15 8:15:00', 'VISA', '555555555555', '02/04', '99 Some Street', 'Calgary', 'AB', 'W4G 7A4',1); -INSERT INTO [dbo].[Orders] VALUES (11, null, '2003-02-15 8:15:00', 'VISA', '555555555555', '02/04', 'Null order', 'Calgary', 'ZZ', 'XXX YYY',1); - diff --git a/tests/unit/SQLMap/scripts/mssql/other-init.sql b/tests/unit/SQLMap/scripts/mssql/other-init.sql deleted file mode 100644 index 93ad5201..00000000 --- a/tests/unit/SQLMap/scripts/mssql/other-init.sql +++ /dev/null @@ -1,145 +0,0 @@ --- Creating Table - -use [IBatisNet] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Others]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - drop table [dbo].[Others] -END - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - drop table [dbo].[A] -END -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[B]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - drop table [dbo].[B] -END -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[C]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - drop table [dbo].[C] -END -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[D]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - drop table [dbo].[D] -END -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[E]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - drop table [dbo].[E] -END -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - drop table [dbo].[F] -END - - -CREATE TABLE [dbo].[Others] ( - [Other_Int] [int] NULL , - [Other_Long] [BigInt] NULL, - [Other_Bit] [Bit] NOT NULL DEFAULT (0), - [Other_String] [varchar] (32) NOT NULL -) ON [PRIMARY] - -CREATE TABLE [dbo].[F] ( - [ID] [varchar] (50) NOT NULL , - [F_Libelle] [varchar] (50) NULL , - CONSTRAINT [PK_F] PRIMARY KEY CLUSTERED - ( - [ID] - ) ON [PRIMARY] -) ON [PRIMARY] - -CREATE TABLE [dbo].[E] ( - [ID] [varchar] (50) NOT NULL , - [E_Libelle] [varchar] (50) NULL , - CONSTRAINT [PK_E] PRIMARY KEY CLUSTERED - ( - [ID] - ) ON [PRIMARY] -) ON [PRIMARY] - -CREATE TABLE [dbo].[D] ( - [ID] [varchar] (50) NOT NULL , - [D_Libelle] [varchar] (50) NULL , - CONSTRAINT [PK_D] PRIMARY KEY CLUSTERED - ( - [ID] - ) ON [PRIMARY] -) ON [PRIMARY] - -CREATE TABLE [dbo].[C] ( - [ID] [varchar] (50) NOT NULL , - [C_Libelle] [varchar] (50) NULL , - CONSTRAINT [PK_C] PRIMARY KEY CLUSTERED - ( - [ID] - ) ON [PRIMARY] -) ON [PRIMARY] - - -CREATE TABLE [dbo].[B] ( - [ID] [varchar] (50) NOT NULL , - [C_ID] [varchar] (50) NULL , - [D_ID] [varchar] (50) NULL , - [B_Libelle] [varchar] (50) NULL , - CONSTRAINT [PK_B] PRIMARY KEY CLUSTERED - ( - [ID] - ) ON [PRIMARY] , - CONSTRAINT [FK_B_C] FOREIGN KEY - ( - [C_ID] - ) REFERENCES [C] ( - [ID] - ), - CONSTRAINT [FK_B_D] FOREIGN KEY - ( - [D_ID] - ) REFERENCES [D] ( - [ID] - ) -) ON [PRIMARY] - - -CREATE TABLE [dbo].[A] ( - [Id] [varchar] (50) NOT NULL , - [B_ID] [varchar] (50) NULL , - [E_ID] [varchar] (50) NULL , - [F_ID] [varchar] (50) NULL , - [A_Libelle] [varchar] (50) NULL - CONSTRAINT [PK_A] PRIMARY KEY CLUSTERED - ( - [Id] - ) ON [PRIMARY] , - CONSTRAINT [FK_A_B] FOREIGN KEY - ( - [B_ID] - ) REFERENCES [B] ( - [ID] - ), - CONSTRAINT [FK_A_E] FOREIGN KEY - ( - [E_ID] - ) REFERENCES [E] ( - [ID] - ), - CONSTRAINT [FK_A_F] FOREIGN KEY - ( - [F_ID] - ) REFERENCES [F] ( - [ID] - ) -) ON [PRIMARY] - - --- Creating Test Data - -INSERT INTO [dbo].[Others] VALUES(1, 8888888, 0, 'Oui'); -INSERT INTO [dbo].[Others] VALUES(2, 9999999999, 1, 'Non'); - -INSERT INTO [dbo].[F] VALUES('f', 'fff'); -INSERT INTO [dbo].[E] VALUES('e', 'eee'); -INSERT INTO [dbo].[D] VALUES('d', 'ddd'); -INSERT INTO [dbo].[C] VALUES('c', 'ccc'); -INSERT INTO [dbo].[B] VALUES('b', 'c', null, 'bbb'); -INSERT INTO [dbo].[A] VALUES('a', 'b', 'e', null, 'aaa'); \ No newline at end of file diff --git a/tests/unit/SQLMap/scripts/mssql/ps_SelectAccount.sql b/tests/unit/SQLMap/scripts/mssql/ps_SelectAccount.sql deleted file mode 100644 index 668913ce..00000000 --- a/tests/unit/SQLMap/scripts/mssql/ps_SelectAccount.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE PROCEDURE dbo.[ps_SelectAccount] -@Account_ID [int] -AS -select - Account_ID as Id, - Account_FirstName as FirstName, - Account_LastName as LastName, - Account_Email as EmailAddress -from Accounts -where Account_ID = @Account_ID \ No newline at end of file diff --git a/tests/unit/SQLMap/scripts/mssql/swap-procedure.sql b/tests/unit/SQLMap/scripts/mssql/swap-procedure.sql deleted file mode 100644 index 203ab60d..00000000 --- a/tests/unit/SQLMap/scripts/mssql/swap-procedure.sql +++ /dev/null @@ -1,34 +0,0 @@ -CREATE PROCEDURE dbo.[ps_swap_email_address] -@First_Email [nvarchar] (64) output, -@Second_Email [nvarchar] (64) output -AS - -Declare @ID1 int -Declare @ID2 int - -Declare @Email1 [nvarchar] (64) -Declare @Email2 [nvarchar] (64) - - SELECT @ID1 = Account_ID, @Email1 = Account_Email - from Accounts - where Account_Email = @First_Email - - SELECT @ID2 = Account_ID, @Email2 = Account_Email - from Accounts - where Account_Email = @Second_Email - - UPDATE Accounts - set Account_Email = @Email2 - where Account_ID = @ID1 - - UPDATE Accounts - set Account_Email = @Email1 - where Account_ID = @ID2 - - SELECT @First_Email = Account_Email - from Accounts - where Account_ID = @ID1 - - SELECT @Second_Email = Account_Email - from Accounts - where Account_ID = @ID2 diff --git a/tests/unit/SQLMap/scripts/mssql/user-init.sql b/tests/unit/SQLMap/scripts/mssql/user-init.sql deleted file mode 100644 index 02268f3c..00000000 --- a/tests/unit/SQLMap/scripts/mssql/user-init.sql +++ /dev/null @@ -1,17 +0,0 @@ --- Creating Table - -use [NHibernate] - -if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -BEGIN - drop table [dbo].[Users] -END - -CREATE TABLE [dbo].[Users] ( - LogonID nvarchar(20) NOT NULL default '0', - Name nvarchar(40) default NULL, - Password nvarchar(20) default NULL, - EmailAddress nvarchar(40) default NULL, - LastLogon datetime default NULL, - PRIMARY KEY (LogonID) -) -- cgit v1.2.3