CREATE EXTENSION IF NOT EXISTS anon CASCADE;
NOTICE:  installing required extension "tsm_system_rows"
NOTICE:  installing required extension "ddlx"
-- test data
 
CREATE TABLE test_noise (
	id SERIAL,
	key   TEXT,
	int_value  INT,
	float_value FLOAT,
	date_value DATE
);
INSERT INTO test_noise
VALUES 
	( 1, 'a', 40 , 33.3, '2019-01-01'),
	( 2, 'b', 40 , 33.3, '2019-01-01'),
    ( 3, 'c', 40 , 33.3, '2019-01-01'),
    ( 4, 'd', 40 , 33.3, '2019-01-01'),
    ( 5, 'e', 40 , 33.3, '2019-01-01'),
    ( 6, 'f', 40 , 33.3, '2019-01-01'),
    ( 7, 'g', 40 , 33.3, '2019-01-01'),
    ( 8, 'h', 40 , 33.3, '2019-01-01'),
    ( 9, 'i', 40 , 33.3, '2019-01-01'),
    ( 10, 'j', 40 , 33.3, '2019-01-01')
;
--CREATE TABLE test_noise_backup 
--AS SELECT * FROM test_noise;
SELECT anon.add_noise_on_numeric_column('test_noise','int_value', 0.25);
 add_noise_on_numeric_column 
-----------------------------
 t
(1 row)

SELECT anon.add_noise_on_numeric_column('test_noise','float_value', 3);
 add_noise_on_numeric_column 
-----------------------------
 t
(1 row)

SELECT anon.add_noise_on_datetime_column('test_noise','date_value', '365 days');
 add_noise_on_datetime_column 
------------------------------
 t
(1 row)

-- TEST 1 :  int_value is between 30 and 50
SELECT min(int_value) >= 30  
AND    max(int_value) <= 50
FROM test_noise;
 ?column? 
----------
 t
(1 row)

-- TEST 2 :  float_value is between 
SELECT min(float_value) >=  -66.6  
AND    max(float_value) <= 133.2
FROM test_noise;
 ?column? 
----------
 t
(1 row)

-- TEST 3 :  date_value is between 2018 and 2020
SELECT min(date_value) >= '2018-01-01'
AND    max(date_value) <= '2020-01-01'
FROM test_noise;
 ?column? 
----------
 t
(1 row)

DROP EXTENSION anon CASCADE;
DROP TABLE test_noise;