From 43233000543984eda49768edde65076fb9c2468c Mon Sep 17 00:00:00 2001
From: ctrlaltca <>
Date: Sun, 18 Nov 2012 20:26:25 +0000
Subject: dropped old tests referring to unexisting components (NOTE: this
 includes what seems a test suite for an older version of SQLMap)

---
 .../scripts/mssql/embed-param-setup-init.sql       | 94 ----------------------
 1 file changed, 94 deletions(-)
 delete mode 100644 tests/unit/SQLMap/scripts/mssql/embed-param-setup-init.sql

(limited to 'tests/unit/SQLMap/scripts/mssql/embed-param-setup-init.sql')

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
-- 
cgit v1.2.3