CREATE EXTENSION IF NOT EXISTS anon CASCADE;
SELECT anon.load();
 load 
------
 t
(1 row)

--
-- Personal Data (First Name, etc.)
--
-- First Name
SELECT pg_typeof(anon.random_first_name()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_first_name()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

-- Last Name
SELECT pg_typeof(anon.random_last_name()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_last_name()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

-- Email
SELECT pg_typeof(anon.random_email()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_email()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

-- Location
SELECT pg_typeof(anon.random_city_in_country('France')) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_city_in_country('France')) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT anon.random_city_in_country('dfndjndjnjdnvjdnjvndjnvjdnvjdnjnvdnvjdnvj') IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT anon.fake_city_in_country('dfndjndjnjdnvjdnjvndjnvjdnvjdnjnvdnvjdnvj') IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT anon.random_city_in_country(NULL) IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT anon.fake_city_in_country(NULL) IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.random_city()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_city()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.random_region_in_country('Italy')) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_region_in_country('Italy')) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT anon.random_region_in_country('c,dksv,kdfsdnfvsjdnfjsdnjfndj') IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT anon.fake_region_in_country('c,dksv,kdfsdnfvsjdnfjsdnjfndj') IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT anon.random_region_in_country(NULL) IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT anon.fake_region_in_country(NULL) IS NULL;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.random_region()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_region()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.random_country()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_country()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

--
-- Company
--
SELECT pg_typeof(anon.random_company()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_company()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

--
-- IBAN
--
SELECT pg_typeof(anon.random_iban()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_iban()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

--
-- SIRET
--
SELECT pg_typeof(anon.fake_siret()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

SELECT pg_typeof(anon.fake_siren()) = 'TEXT'::REGTYPE;
 ?column? 
----------
 t
(1 row)

--
-- Lorem Ipsum
--
SELECT COUNT(*) = 5-1
FROM (
  SELECT regexp_matches(anon.lorem_ipsum(), E'\n', 'g')
) AS l;
 ?column? 
----------
 t
(1 row)

SELECT COUNT(*) = 19-1
FROM (
  SELECT regexp_matches(anon.lorem_ipsum(19), E'\n', 'g')
) AS l;
 ?column? 
----------
 t
(1 row)

SELECT COUNT(*) = 7-1
FROM (
  SELECT regexp_matches(anon.lorem_ipsum( paragraphs := 7 ), E'\n', 'g')
) AS l;
 ?column? 
----------
 t
(1 row)

SELECT COUNT(*) = 20
FROM unnest(string_to_array( anon.lorem_ipsum( words := 20 ), ' ') )
AS l;
 ?column? 
----------
 t
(1 row)

SELECT char_length(anon.lorem_ipsum( characters := 7 )) = 7;
 ?column? 
----------
 t
(1 row)

SELECT char_length(anon.lorem_ipsum( characters := 7 , words := 100)) = 7;
 ?column? 
----------
 t
(1 row)

SELECT char_length(anon.lorem_ipsum( characters := 7 , paragraphs := 100)) = 7;
 ?column? 
----------
 t
(1 row)

DROP EXTENSION anon CASCADE;