USE [CarParts]
GO
/****** Object:  StoredProcedure [dbo].[TestRun1]    Script Date: 12/5/2016 4:34:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Name
-- Create date:
-- Description:
-- =============================================
ALTER PROCEDURE [dbo].[TestRun1]
	-- Add the parameters for the stored procedure here

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	declare @startRun datetime, @endRun datetime, @startRunTable datetime, @endRunTable datetime, @startRunView datetime, @endRunView datetime, @counter integer;
	declare @testNumber integer;
	set @testNumber = 1;
    -- Insert statements for procedure here
	EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all';
	insert into Tests
	values ('First test on colors');
	insert into Tables
	values ('Color');
	insert into TestTables
	values (@testNumber, 1, 100, 0);
	insert into Views
	values ('Color View');
	insert into TestViews
	values (@testNumber, 1);
	set @startRun = CURRENT_TIMESTAMP;
	set @startRunTable = CURRENT_TIMESTAMP;



	set @startRunTable = CURRENT_TIMESTAMP;
	delete from color;
	set @counter = 0;
	while (@counter < 1000) begin
		insert into color
		values (@counter, concat('Color ', cast(@counter as char(5))));
		set @counter = @counter + 1;
	end;
	set @endRunTable = CURRENT_TIMESTAMP;

	set @startRunView = CURRENT_TIMESTAMP;
	select * from color;
	set @endRunView = CURRENT_TIMESTAMP;

	set @endRun = CURRENT_TIMESTAMP;

	--return table to original state
	delete from color;
	insert into Color
	values (1,'red');
	insert into Color
	values (2,'green');
	insert into Color
	values (3,'blue');
	insert into Color
	values (4,'yellow');
	insert into Color
	values (5,'gray');
	insert into Color
	values (6,'burgundy');

	EXEC sp_msforeachtable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all';

	insert into TestRuns
	values ('Test on colors', @startRun, @endRun);
	insert into TestRunTables
	values (1, 1, @startRunTable, @endRunTable);
	insert into TestRunViews
	values (1, 1, @startRunView, @endRunView);

END