-- DataOps local test bootstrap. Executed only for a fresh Docker volume.
SELECT 'CREATE DATABASE n8n'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'n8n')\gexec

SELECT 'CREATE DATABASE kestra'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'kestra')\gexec

\connect dataops
CREATE EXTENSION IF NOT EXISTS vector;
\ir /dataops-schema/create_data_orders_table.sql
\ir /dataops-schema/add_data_source_to_data_orders.sql
\ir /dataops-schema/create_data_products_table.sql
\ir /dataops-schema/create_metadata_review_records_table.sql
\ir /dataops-schema/create_metadata_version_history_table.sql
\ir /dataops-schema/create_task_list_table.sql