# file: install-pgvector.sh

#!/bin/bash

echo "🔧 Paigaldame pgvector'i PostgreSQL konteineri sees..."

docker exec postgres_postgis bash -c '
apt-get update
apt-get install -y build-essential postgresql-server-dev-16 git

echo "pgvector paigaldus lõpetatud!"
'

docker exec postgres_postgis bash -c '
apt-get install postgresql-16-pgvector
echo "✓ Pgvector paigaldatud konteineri sees"
'

# Admin kasutaja lisamine
docker exec -it postgres_postgis bash -c "
  export PGPASSWORD='ai_secure_pass_2026' &&
  psql -U ai_user -h localhost -d research_db -c \"
  CREATE ROLE osm WITH LOGIN SUPERUSER CREATEDB CREATEROLE PASSWORD 'osm'\"
"
# PDF-de andmevbaasi loomine
docker exec -it postgres_postgis bash -c "
  export PGPASSWORD='ai_secure_pass_2026' &&
  psql -U ai_user -h localhost -d research_db -c '
  CREATE DATABASE pdf_research WITH OWNER = osm;'
"
# Laienduste lisamine
docker exec -it postgres_postgis bash -c "
  export PGPASSWORD='osm' &&
  psql -U osm -h localhost -d pdf_research -c \"
  CREATE EXTENSION IF NOT EXISTS postgis CASCADE;
  CREATE EXTENSION IF NOT EXISTS pointcloud CASCADE;
  CREATE EXTENSION IF NOT EXISTS pointcloud_postgis CASCADE;
  CREATE EXTENSION IF NOT EXISTS fuzzystrmatch CASCADE;
  CREATE EXTENSION IF NOT EXISTS postgis_tiger_geocoder CASCADE;
  CREATE EXTENSION IF NOT EXISTS postgis_topology CASCADE;
  CREATE EXTENSION IF NOT EXISTS postgis_raster CASCADE;
  CREATE EXTENSION IF NOT EXISTS pgrouting CASCADE;
  CREATE EXTENSION IF NOT EXISTS postgis_sfcgal CASCADE;
  CREATE EXTENSION IF NOT EXISTS hstore CASCADE;
  CREATE EXTENSION IF NOT EXISTS plpgsql CASCADE;
  CREATE EXTENSION IF NOT EXISTS vector CASCADE;
  SELECT * FROM pg_extension WHERE extname = 'vector';
  \"
"
docker exec -it postgres_postgis bash -c "
  export PGPASSWORD='osm' &&
  psql -U osm -h localhost -d pdf_research -c '\dx'
"

echo "✓ Pgvector aktiveerimisel!"