15b1069bcc
This PR moves the entire project to Typescript. Due to the ~1000 ignores this will lead to a messy codebase for a while, but the churn is worth it – all of those ignore comments are places that were never type-safe previously. closes #1282
32 lines
1.0 KiB
JavaScript
32 lines
1.0 KiB
JavaScript
"use strict";
|
|
|
|
module.exports = {
|
|
up: async (queryInterface, Sequelize) => {
|
|
const searchDocument = `
|
|
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', coalesce(new.text, '')), 'B');
|
|
return new;
|
|
end
|
|
$$ LANGUAGE plpgsql;
|
|
`;
|
|
await queryInterface.sequelize.query(searchDocument);
|
|
},
|
|
down: async (queryInterface, Sequelize) => {
|
|
const searchDocument = `
|
|
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(new.text, '')), 'C');
|
|
return new;
|
|
end
|
|
$$ LANGUAGE plpgsql;
|
|
`;
|
|
await queryInterface.sequelize.query(searchDocument);
|
|
},
|
|
};
|