添加当前用户id以触发sql查询hair_trigger gem rails

gem 'hair_trigger'

class AddPostUpdateTrigger < ActiveRecord::Migration[6.1]
  def up
    HairTrigger.create(
      name: 'update_post_user_id',
      table: 'posts',
      trigger: <<-SQL
        CREATE OR REPLACE FUNCTION update_post_user_id()
        RETURNS TRIGGER AS $$
        BEGIN
          -- 在这里执行你的 SQL 查询，使用 NEW.current_user_id
          UPDATE posts SET updated_by = NEW.current_user_id WHERE id = NEW.id;
          RETURN NEW;
        END;
        $$ LANGUAGE plpgsql;
      SQL
    )
  end

  def down
    HairTrigger.find_by(name: 'update_post_user_id').destroy
  end
end

class Post < ApplicationRecord
  before_save :set_current_user_id

  private

  def set_current_user_id
    ActiveRecord::Base.connection.execute <<-SQL
      UPDATE posts SET current_user_id = #{current_user.id} WHERE id = #{id};
    SQL
  end
end