pdf-pipeline/scripts/db_vector_välja_muutmine.sh

# Veeru laiuse muudatus
docker exec -it postgres_postgis bash -c "
  export PGPASSWORD='osm' &&
  psql -U osm -h localhost -d pdf_research -c \"
  ALTER TABLE chunks
      ALTER COLUMN embedding TYPE vector(384);
  \"
"

docker exec -it postgres_postgis bash -c "
  export PGPASSWORD='osm' &&
  psql -U osm -h localhost -d pdf_research -c \"
  DROP INDEX IF EXISTS idx_chunks_embedding;
  CREATE INDEX idx_chunks_embedding ON chunks
  USING ivfflat (embedding vector_cosine_ops) WITH (lists = 100);
  \"
"

# Lisa raw_documents tabelisse weaviate_article_id veerg
docker exec -it postgres_postgis bash -c "
  export PGPASSWORD='osm' &&
  psql -U osm -h localhost -d pdf_research -c \"
ALTER TABLE raw_documents ADD COLUMN weaviate_article_id UUID;
CREATE INDEX idx_raw_weaviate_id ON raw_documents(weaviate_article_id);
  \"
"
# Kontrollli veeru olemasolu
docker exec -it postgres_postgis bash -c "
  export PGPASSWORD='osm' &&
  psql -U osm -h localhost -d pdf_research -c \"
  SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'raw_documents' ORDER BY ordinal_position;
  \"
"