<commit_before>/******************************
** File:    01_Install_Assembly
** Name:	Install Assembly
** Desc:	Install the prefSQL assembly and its functions
**			Change the path of the assembly (Variable ASSEMBLY_PATH) before running
** Auth:	Michael
** Date:	12/06/2016
**************************
** Change History
**************************
** PR   Date			Author		Description	
** --   --------		-------		------------------------------------
** 1    05/01/2015      Michael		First version
** 2    16/10/2015      Michael		Remove the 4000 character limit for queries
** 3    20/10/2015      Stefan      Add Skyline Sampling procedure
** 4    12/06/2016		Michael		Add Procedure for Ranking
*******************************/


------------------------------------------------------------------
------------ VARIABLES (CHANGE TO YOUR ENVIRONMENt) --------------
------------------------------------------------------------------

--DECLARE @ASSEMBLY_PATH varchar(400);
--SET @ASSEMBLY_PATH = 'E:\Projekte\prefSQL\SQLSkyline\bin\Release\SQLSkyline.dll';


DECLARE @ASSEMBLY_PATH varchar(400);
SET @ASSEMBLY_PATH = '$(assemblyPath)'


------------------------------------------------------------------
----------- REMOVE ASSEMBLY  -------------------------------------
------------------------------------------------------------------

--Drop Procedures if exists (this are old procedure names, before 21/06/2016)
IF EXISTS (SELECT * FROM sys.objects WHERE type = 'PC' AND name = 'SP_SkylineBNL')
	DROP PROCEDURE SP_SkylineBNL

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'PC' AND name = 'SP_SkylineBNLLevel')
	DROP PROCEDURE SP_SkylineBNLLevel
<commit_msg>Install assembly on test database after build<commit_after>/******************************
** File:    01_Install_Assembly
** Name:	Install Assembly
** Desc:	Install the prefSQL assembly and its functions
**			Change the path of the assembly (Variable ASSEMBLY_PATH) before running
** Auth:	Michael
** Date:	12/06/2016
**************************
** Change History
**************************
** PR   Date			Author		Description	
** --   --------		-------		------------------------------------
** 1    05/01/2015      Michael		First version
** 2    16/10/2015      Michael		Remove the 4000 character limit for queries
** 3    20/10/2015      Stefan      Add Skyline Sampling procedure
** 4    12/06/2016		Michael		Add Procedure for Ranking
*******************************/


------------------------------------------------------------------
------------ VARIABLES (CHANGE TO YOUR ENVIRONMENt) --------------
------------------------------------------------------------------

--DECLARE @ASSEMBLY_PATH varchar(400);
--SET @ASSEMBLY_PATH = 'E:\Projekte\prefSQL\SQLSkyline\bin\Release\SQLSkyline.dll';


DECLARE @ASSEMBLY_PATH varchar(400);
SET @ASSEMBLY_PATH = 'C:\projects\prefsql\SQLSkyline\bin\Release\SQLSkyline.dll'


------------------------------------------------------------------
----------- REMOVE ASSEMBLY  -------------------------------------
------------------------------------------------------------------

--Drop Procedures if exists (this are old procedure names, before 21/06/2016)
IF EXISTS (SELECT * FROM sys.objects WHERE type = 'PC' AND name = 'SP_SkylineBNL')
	DROP PROCEDURE SP_SkylineBNL

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'PC' AND name = 'SP_SkylineBNLLevel')
	DROP PROCEDURE SP_SkylineBNLLevel

{'fraction_non_alphanumeric': 0.3622719246615656, 'fraction_numerical': 0.03766921718658034, 'mean_word_length': 1.6267387944358578, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5428589', 'n_tokens_mistral': 991, 'n_tokens_neox': 855, 'n_words': 248}