server/migrations/20260921120000-tolerate-tsvector-limit-in-document-search-trigger.js

Rama main · réplica de lectura del repositorio original.

"use strict";

/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up(queryInterface) {
    await queryInterface.sequelize.query(`
    CREATE OR REPLACE FUNCTION documents_search_trigger() RETURNS trigger AS $$
    begin
      begin
        new."searchVector" :=
          setweight(to_tsvector('english', coalesce(new.title, '')),'A') ||
          setweight(to_tsvector('english', coalesce(array_to_string(new."previousTitles", ' , '),'')),'C') ||
          setweight(to_tsvector('english', substring(coalesce(new.text, ''), 1, 1000000)), 'D');
      exception when program_limit_exceeded then
        -- The tsvector limit is on the output size, so text made of mostly
        -- unique tokens can overflow it. Index a shorter prefix instead.
        new."searchVector" :=
          setweight(to_tsvector('english', coalesce(new.title, '')),'A') ||
          setweight(to_tsvector('english', coalesce(array_to_string(new."previousTitles", ' , '),'')),'C') ||
          setweight(to_tsvector('english', substring(coalesce(new.text, ''), 1, 500000)), 'D');
      end;
      return new;
    end
    $$ LANGUAGE plpgsql;
    `);
  },

  async down(queryInterface) {
    await queryInterface.sequelize.query(`
    CREATE OR REPLACE FUNCTION documents_search_trigger() RETURNS trigger AS $$
    begin
      new."searchVector" :=
        setweight(to_tsvector('english', coalesce(new.title, '')),'A') ||
        setweight(to_tsvector('english', coalesce(array_to_string(new."previousTitles", ' , '),'')),'C') ||
        setweight(to_tsvector('english', substring(coalesce(new.text, ''), 1, 1000000)), 'D');
      return new;
    end
    $$ LANGUAGE plpgsql;
    `);
  },
};