From a1ddc25da0d2aa79a4d9216ef7792f26233bd38e Mon Sep 17 00:00:00 2001
From: erdgeist <erdgeist@erdgeist.org>
Date: Fri, 26 Jun 2026 05:19:28 +0200
Subject: Stage 5 fixes: RouteWithParams removal, Globalize fallbacks, search
 stub, to_s(:db) → to_fs(:db), LockedByAnotherUser autoload, test environment
 config
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

- Remove safe_path helper and content_path shim from link_helper.rb
- Update all safe_path call sites in views to use named route helpers directly
- Fix Globalize fallbacks via config.i18n.fallbacks in application.rb, remove i18n initializer
- Stub Node.search returning none (search disabled pending PostgreSQL upgrade)
- Replace to_s(:db) with to_fs(:db) in node.rb, nodes_helper.rb, link_helper.rb, admin view
- Move LockedByAnotherUser to app/models/locked_by_another_user.rb for Zeitwerk autoloading
- Fix config/environments/test.rb: config.assets removed, cache_classes → enable_reloading,
  test_order removed, minitest pinned to ~> 5.25
- Fix config/environments/development.rb: cache_classes → enable_reloading
- Park search vector migration in doc/ pending PostgreSQL and plpgsql availability
---
 ...d_search_vector_to_page_translations.rb.pending | 47 ++++++++++++++++++++++
 1 file changed, 47 insertions(+)
 create mode 100644 doc/20260626025705_add_search_vector_to_page_translations.rb.pending

(limited to 'doc')

diff --git a/doc/20260626025705_add_search_vector_to_page_translations.rb.pending b/doc/20260626025705_add_search_vector_to_page_translations.rb.pending
new file mode 100644
index 0000000..0747637
--- /dev/null
+++ b/doc/20260626025705_add_search_vector_to_page_translations.rb.pending
@@ -0,0 +1,47 @@
+class AddSearchVectorToPageTranslations < ActiveRecord::Migration[7.2]
+  def up
+    add_column :page_translations, :search_vector, :tsvector
+
+    execute <<~SQL
+      UPDATE page_translations
+      SET search_vector = to_tsvector(
+        'simple',
+        coalesce(title, '') || ' ' ||
+        coalesce(abstract, '') || ' ' ||
+        coalesce(body, '')
+      )
+    SQL
+
+    add_index :page_translations, :search_vector,
+              using: :gin,
+              name: 'index_page_translations_on_search_vector'
+
+    execute <<~SQL
+      CREATE OR REPLACE FUNCTION page_translations_search_vector_update()
+      RETURNS trigger AS $$
+      BEGIN
+        NEW.search_vector := to_tsvector(
+          'simple',
+          coalesce(NEW.title, '') || ' ' ||
+          coalesce(NEW.abstract, '') || ' ' ||
+          coalesce(NEW.body, '')
+        );
+        RETURN NEW;
+      END;
+      $$ LANGUAGE plpgsql;
+
+      CREATE TRIGGER page_translations_search_vector_trigger
+      BEFORE INSERT OR UPDATE ON page_translations
+      FOR EACH ROW EXECUTE PROCEDURE page_translations_search_vector_update();
+    SQL
+  end
+
+  def down
+    execute <<~SQL
+      DROP TRIGGER IF EXISTS page_translations_search_vector_trigger ON page_translations;
+      DROP FUNCTION IF EXISTS page_translations_search_vector_update();
+    SQL
+    remove_index :page_translations, name: 'index_page_translations_on_search_vector'
+    remove_column :page_translations, :search_vector
+  end
+end
-- 
cgit v1.3