Class: SiteMapLink

Inherits:
ApplicationRecord show all
Defined in:
app/models/site_map_link.rb

Overview

Represents a directed hyperlink from one SiteMap page to another.

link_type values:
editorial — link placed inside main page content (passes topical signal)
navigation — link found in or .navbar / menu (sitewide template)
footer — link found in (sitewide template)
sidebar — link in an aside / sidebar widget

Template links (navigation, footer) are stored but excluded from gap analysis
and SEO recommendations since they don't carry contextual authority.
== Schema Information

Table name: site_map_links
Database name: primary

id :bigint not null, primary key
anchor_text :string
context_snippet :string
first_seen_at :datetime not null
last_seen_at :datetime not null
link_type :string default("editorial"), not null
to_path :string not null
created_at :datetime not null
updated_at :datetime not null
from_site_map_id :integer not null
to_site_map_id :integer

Indexes

index_site_map_links_on_from_to_path_type (from_site_map_id,to_path,link_type) UNIQUE
index_site_map_links_on_to_path_and_type (to_path,link_type)
index_site_map_links_on_to_site_map_id (to_site_map_id)

Foreign Keys

fk_rails_... (from_site_map_id => site_maps.id) ON DELETE => cascade
fk_rails_... (to_site_map_id => site_maps.id) ON DELETE => cascade

Constant Summary collapse 

%w[editorial navigation footer sidebar].freeze

Constants included from Models::Schedulable

Models::Schedulable::SIMPLE_FORM_OPTIONS

Instance Attribute Summary collapse

Belongs to collapse

Class Method Summary collapse

Instance Method Summary collapse

Methods inherited from ApplicationRecord

ransackable_associations, ransackable_attributes, ransackable_scopes, ransortable_attributes, #to_relation

Methods included from Models::Schedulable

config

Methods included from Models::AfterCommittable

#after_commit

Methods included from Models::EventPublishable

#publish_event

Instance Attribute Details

#from_site_map_id ⇒ Integer

Returns:

  • (Integer) 


56
 
# File 'app/models/site_map_link.rb', line 56

validates :from_site_map_id, uniqueness: { scope: %i[to_path link_type] }

#link_type ⇒ String

Returns:

  • (String) 


53
 
# File 'app/models/site_map_link.rb', line 53

validates :link_type, inclusion: { in: LINK_TYPES }

#to_path ⇒ String

Returns:

  • (String) 


50
 
# File 'app/models/site_map_link.rb', line 50

validates :to_path,   presence: true

Class Method Details

.editorial ⇒ ActiveRecord::Relation<SiteMapLink>

A relation of SiteMapLinks that are editorial. Active Record Scope

Returns:

See Also:



60
 
# File 'app/models/site_map_link.rb', line 60

scope :editorial,   -> { where(link_type: 'editorial') }

.editorial_to_path ⇒ ActiveRecord::Relation<SiteMapLink>

A relation of SiteMapLinks that are editorial to path. Active Record Scope

Returns:

See Also:



66
 
# File 'app/models/site_map_link.rb', line 66

scope :editorial_to_path, ->(path) { editorial.where(to_path: path) }

.inbound_to ⇒ ActiveRecord::Relation<SiteMapLink>

A relation of SiteMapLinks that are inbound to. Active Record Scope

Returns:

See Also:



62
 
# File 'app/models/site_map_link.rb', line 62

scope :inbound_to,  ->(site_map) { where(to_site_map_id: site_map.id) }

.outbound_from ⇒ ActiveRecord::Relation<SiteMapLink>

A relation of SiteMapLinks that are outbound from. Active Record Scope

Returns:

See Also:



63
 
# File 'app/models/site_map_link.rb', line 63

scope :outbound_from, ->(site_map) { where(from_site_map_id: site_map.id) }

.template ⇒ ActiveRecord::Relation<SiteMapLink>

A relation of SiteMapLinks that are template. Active Record Scope

Returns:

See Also:



61
 
# File 'app/models/site_map_link.rb', line 61

scope :template,    -> { where(link_type: %w[navigation footer]) }

.upsert_for_page!(from_site_map, links) ⇒ Object

Bulk upsert links for a page. Existing rows are updated (anchor, last_seen_at);
new rows are inserted. Rows no longer present in the crawl are not deleted —
they get stale naturally and can be pruned separately if needed.

Parameters:

  • from_site_map (SiteMap)
  • links (Array<Hash>) —

    Each hash: { to_path:, anchor_text:, link_type:, context_snippet: }



76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
 
# File 'app/models/site_map_link.rb', line 76

def self.upsert_for_page!(from_site_map, links)
  return if links.blank?

  now = Time.current

  # Resolve to_site_map_id for each target path (batch lookup)
  paths = links.pluck(:to_path).uniq.compact
  path_to_id = SiteMap.where(path: paths, locale: from_site_map.locale)
                      .pluck(:path, :id)
                      .to_h

  rows = links.map do |link|
    {
      from_site_map_id: from_site_map.id,
      to_path:          link[:to_path],
      to_site_map_id:   path_to_id[link[:to_path]],
      anchor_text:      link[:anchor_text].to_s.truncate(255),
      link_type:        link[:link_type] || 'editorial',
      context_snippet:  link[:context_snippet].to_s.truncate(200),
      first_seen_at:    now,
      last_seen_at:     now,
      created_at:       now,
      updated_at:       now
    }
  end

  upsert_all(
    rows,
    unique_by:    %i[from_site_map_id to_path link_type],
    update_only:  %i[to_site_map_id anchor_text context_snippet last_seen_at]
  )
end

Instance Method Details

#editorial? ⇒ Boolean

─── Helpers ───────────────────────────────────────────────────────────────

Returns:

  • (Boolean) 


110
111
 
# File 'app/models/site_map_link.rb', line 110

def editorial?   = link_type == 'editorial'
# @return [Boolean] true when the link is a navigation or footer template link.

#from_site_map ⇒ SiteMap

Returns:



44
 
# File 'app/models/site_map_link.rb', line 44

belongs_to :from_site_map, class_name: 'SiteMap'

#template? ⇒ Boolean

Returns true when the link is a navigation or footer template link.

Returns:

  • (Boolean) —

    true when the link is a navigation or footer template link.



112
 
# File 'app/models/site_map_link.rb', line 112

def template?    = %w[navigation footer].include?(link_type)

#to_site_map ⇒ SiteMap?

Returns:



46
 
# File 'app/models/site_map_link.rb', line 46

belongs_to :to_site_map,   class_name: 'SiteMap', optional: true