Aakash BakhleandGitHub
102f19fe41
Resolved conversations need a separate suggestion layer so repeated FAQ signals can be grouped without creating untrusted knowledge entries. This PR adds the persistence foundation only; it introduces no user-facing behavior by itself. ## Closes - [CW-7495](https://linear.app/chatwoot/issue/CW-7495/backend-llm-changes-to-make-conversation-faqs-as-signalssuggestions) (stacked PR 1/3; the issue is complete after the full stack lands) ## What changed - Added `captain_faq_suggestions` with question, answer, embedding, source count, and review status. - Added `captain_faq_observations` to retain conversation-level signals. - Added Captain assistant, account, and conversation associations. - Added vector and lookup indexes for semantic grouping. ## How to test This layer has no standalone UI behavior. Apply the migration and confirm Captain assistants can persist open FAQ suggestions with attached conversation observations.
52 lines
1.6 KiB
Ruby
52 lines
1.6 KiB
Ruby
# == Schema Information
|
|
#
|
|
# Table name: captain_faq_suggestions
|
|
#
|
|
# id :bigint not null, primary key
|
|
# answer :text not null
|
|
# embedding :vector(1536)
|
|
# language :string default("en"), not null
|
|
# question :string not null
|
|
# source_count :integer default(0), not null
|
|
# status :integer default("open"), not null
|
|
# created_at :datetime not null
|
|
# updated_at :datetime not null
|
|
# account_id :bigint not null
|
|
# assistant_id :bigint not null
|
|
#
|
|
class Captain::FaqSuggestion < ApplicationRecord
|
|
self.table_name = 'captain_faq_suggestions'
|
|
|
|
belongs_to :assistant, class_name: 'Captain::Assistant'
|
|
belongs_to :account
|
|
has_many :observations,
|
|
class_name: 'Captain::FaqObservation',
|
|
dependent: :delete_all,
|
|
inverse_of: :faq_suggestion
|
|
has_neighbors :embedding, normalize: true
|
|
|
|
enum status: { open: 0, approved: 1, dismissed: 2 }
|
|
|
|
validates :question, :answer, :language, presence: true
|
|
|
|
before_validation :ensure_account
|
|
after_commit :update_embedding, on: [:create, :update]
|
|
|
|
scope :ordered, -> { order(source_count: :desc, updated_at: :desc) }
|
|
scope :by_language, ->(language) { where(language: language) }
|
|
|
|
private
|
|
|
|
def ensure_account
|
|
self.account = assistant&.account
|
|
end
|
|
|
|
def update_embedding
|
|
return unless open?
|
|
return unless saved_change_to_question? || saved_change_to_answer? || embedding.nil?
|
|
return if previously_new_record? && embedding.present?
|
|
|
|
Captain::Llm::UpdateEmbeddingJob.perform_later(self, "#{question}: #{answer}")
|
|
end
|
|
end
|