--

--

    LANGUAGE sql

    AS $_$

SELECT util.set_search_path(util.mk_search_path(util.schema($1)))

--

--

auto-appends util to the search_path to enable use of util operators

';

DECLARE

	live_datasource text := rm_version_suffix(datasource);

BEGIN

	-- don't datasource_rm() the datasource to publish!

	IF live_datasource = datasource THEN RETURN; END IF;

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	UPDATE source SET shortname = new WHERE shortname = old;

END;

$$;

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	DELETE FROM source WHERE shortname = datasource;

END;

$$;

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	PERFORM datasource_rename(datasource, datasource||'.new');

END;

$$;

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	PERFORM public_schema_publish(util.schema_esc(schema_anchor));

END;

$$;

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	PERFORM util.schema_bundle_rm(util.schema_esc(schema_anchor));

END;

$$;

	source_id_ integer;

	shortname_ text = shortname;

BEGIN

	SELECT source_id INTO source_id_

	FROM source WHERE source.shortname = shortname_ LIMIT 1

	diff_table text = util.qual_name(util.schema(in_view),

		'_diff_'||util.name(in_view));

BEGIN

	PERFORM util.remake_diff_table(diff_table, rematerialize_in_view(in_view),

		rematerialize_out_view(in_view), type_table);

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	PERFORM remake_diff_tables(schema) FROM validatable_datasources() schema;

END;

	errors_ct integer = 0;

	in_view regclass;

BEGIN

	FOR in_view IN SELECT * FROM validation_views(schema)

	LOOP

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	RETURN rematerialize_out_view(datasource_schema := util.schema(in_view),

		out_view := util.qual_name(util.schema(schema_anchor),

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	PERFORM util.rename_relation(view_,

		new_query_view_relation_name(util.name(from_), to_, util.name(view_)))

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	PERFORM util.drop_relation(view_, force := true)

		-- force: needed because some query-view-relations depend on others

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

BEGIN

	RETURN QUERY

		SELECT DISTINCT util.schema(view) FROM validation_views() view;