summaryrefslogtreecommitdiff
path: root/doc/20260626025705_add_search_vector_to_page_translations.rb.pending
diff options
context:
space:
mode:
authorerdgeist <erdgeist@erdgeist.org>2026-06-27 02:39:55 +0200
committererdgeist <erdgeist@erdgeist.org>2026-06-27 02:39:55 +0200
commitb4f850e97aeb12369399d8e1ab354f66d3b88e40 (patch)
treea4936218a3e8df5525150d12ed4b94c077befd6f /doc/20260626025705_add_search_vector_to_page_translations.rb.pending
parente7d5d0b2c32b172ecdaa80555bf5804043fd87a0 (diff)
Stage 6 click-testing fixes and production setup
- file_attachment.rb: delete old upload directory before writing replacement files; fixes orphaned variants when filename or mime type changes - assets/edit.html.erb: add file upload field and current file display; the form was previously empty and non-functional - admin.css: fix button_to hover styling; buttons now show orange hover to signal interactivity - test/controllers/users_controller_test.rb: assert input[type=submit] not anchor tag for destroy action (button_to change) - test/test_helper.rb: add I18n.locale reset in setup block - doc/rc.d_cccms: fix cccms_chdir, add start_precmd for log/pid dirs, PATH export for bash wrapper, user/pid/tcp_nopush unicorn fixes - doc/INSTALL.md: new installation guide covering all non-obvious steps - Remove parked search migration from doc/ (now in db/migrate/)
Diffstat (limited to 'doc/20260626025705_add_search_vector_to_page_translations.rb.pending')
-rw-r--r--doc/20260626025705_add_search_vector_to_page_translations.rb.pending47
1 files changed, 0 insertions, 47 deletions
diff --git a/doc/20260626025705_add_search_vector_to_page_translations.rb.pending b/doc/20260626025705_add_search_vector_to_page_translations.rb.pending
deleted file mode 100644
index 0747637f..00000000
--- a/doc/20260626025705_add_search_vector_to_page_translations.rb.pending
+++ /dev/null
@@ -1,47 +0,0 @@
1class AddSearchVectorToPageTranslations < ActiveRecord::Migration[7.2]
2 def up
3 add_column :page_translations, :search_vector, :tsvector
4
5 execute <<~SQL
6 UPDATE page_translations
7 SET search_vector = to_tsvector(
8 'simple',
9 coalesce(title, '') || ' ' ||
10 coalesce(abstract, '') || ' ' ||
11 coalesce(body, '')
12 )
13 SQL
14
15 add_index :page_translations, :search_vector,
16 using: :gin,
17 name: 'index_page_translations_on_search_vector'
18
19 execute <<~SQL
20 CREATE OR REPLACE FUNCTION page_translations_search_vector_update()
21 RETURNS trigger AS $$
22 BEGIN
23 NEW.search_vector := to_tsvector(
24 'simple',
25 coalesce(NEW.title, '') || ' ' ||
26 coalesce(NEW.abstract, '') || ' ' ||
27 coalesce(NEW.body, '')
28 );
29 RETURN NEW;
30 END;
31 $$ LANGUAGE plpgsql;
32
33 CREATE TRIGGER page_translations_search_vector_trigger
34 BEFORE INSERT OR UPDATE ON page_translations
35 FOR EACH ROW EXECUTE PROCEDURE page_translations_search_vector_update();
36 SQL
37 end
38
39 def down
40 execute <<~SQL
41 DROP TRIGGER IF EXISTS page_translations_search_vector_trigger ON page_translations;
42 DROP FUNCTION IF EXISTS page_translations_search_vector_update();
43 SQL
44 remove_index :page_translations, name: 'index_page_translations_on_search_vector'
45 remove_column :page_translations, :search_vector
46 end
47end