-- this test must be run on a database named 'contrib_regression'
CREATE EXTENSION IF NOT EXISTS anon CASCADE;
-- INIT
SELECT anon.load();
 load 
------
 t
(1 row)

CREATE TABLE cards (
  id integer NOT NULL,
  board_id integer NOT NULL,
  data TEXT
);
INSERT INTO cards VALUES (1, 1, 'Paint house');
INSERT INTO cards VALUES (2, 1, 'Clean');
INSERT INTO cards VALUES (3, 1, 'Cook');
INSERT INTO cards VALUES (4, 1, 'Vacuum');
INSERT INTO cards VALUES (999999,0, E'(,Very"Weird\'\'value\t trying\n to\,break '' CSV\)export)');
CREATE TABLE customer (
  id SERIAL,
  name TEXT,
  "CreditCard" TEXT
);
INSERT INTO customer
VALUES (1,'Schwarzenegger','1234567812345678');
COMMENT ON COLUMN customer.name
IS E'MASKED WITH FUNCTION md5(''0'') ';
COMMENT ON COLUMN customer."CreditCard"
IS E'MASKED WITH FUNCTION md5(''0'') ';
CREATE TABLE "COMPANY" (
  rn SERIAL,
  "IBAN" TEXT,
  BRAND TEXT
);
INSERT INTO "COMPANY"
VALUES (1991,'12345677890','Cyberdyne Systems');
COMMENT ON COLUMN "COMPANY"."IBAN"
IS E'MASKED WITH FUNCTION md5(''0'') ';
COMMENT ON COLUMN "COMPANY".brand
IS E'MASKED WITH FUNCTION md5(''0'')';
-- 0. basic test : call the dump function
SELECT count(d) FROM anon.dump() AS d;
NOTICE:  This function is deprecated !
HINT:  Use the pg_dump_anon command line instead.
 count 
-------
     8
(1 row)

-- 1. Dump into a file
\! psql -q -t -A -c 'SELECT anon.dump()' contrib_regression > tests/tmp/_dump1.sql
NOTICE:  This function is deprecated !
HINT:  Use the pg_dump_anon command line instead.
-- 2. Clean the database and Restore with the dump file
DROP TABLE cards CASCADE;
DROP TABLE customer CASCADE;
DROP TABLE "COMPANY" CASCADE;
-- output will vary a lot between PG versions
-- So have to disable it to pass this test
\! psql -f tests/tmp/_dump1.sql contrib_regression >/dev/null
-- 3. Dump again into a second file
\! psql -t -A -c 'SELECT anon.dump()' contrib_regression > tests/tmp/_dump2.sql
NOTICE:  This function is deprecated !
HINT:  Use the pg_dump_anon command line instead.
-- 4. Check that both dump files are identical
\! diff tests/tmp/_dump1.sql tests/tmp/_dump2.sql
--  CLEAN
DROP TABLE "COMPANY" CASCADE;
DROP TABLE customer CASCADE;
DROP TABLE cards CASCADE;
DROP EXTENSION anon CASCADE;