daemonslayer/tests-airflow

DROP DATABASE IF EXISTS orders;
DROP DATABASE IF EXISTS dwh;
DROP USER IF EXISTS dwh_svc_account;
DROP USER IF EXISTS db_owner;
DROP USER IF EXISTS oltp_read;
CREATE USER db_owner PASSWORD 'db_owner';
CREATE USER oltp_read PASSWORD 'oltp_read';
CREATE USER dwh_svc_account PASSWORD 'dwh_svc_account';

-- Create orders database
CREATE DATABASE orders;
\c orders;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO db_owner;

-- Create data warehouse db
CREATE DATABASE dwh;
\c dwh;

CREATE SCHEMA dwh AUTHORIZATION db_owner;
CREATE SCHEMA staging AUTHORIZATION db_owner;
--CREATE SCHEMA partman AUTHORIZATION db_owner;
--CREATE EXTENSION pg_partman SCHEMA partman;

GRANT ALL PRIVILEGES ON SCHEMA dwh TO db_owner;
GRANT ALL PRIVILEGES ON SCHEMA staging TO db_owner;
--GRANT ALL PRIVILEGES ON SCHEMA partman TO db_owner;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA dwh TO db_owner;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA staging TO db_owner;
--GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA partman TO db_owner;