1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
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
108
109
110
111
112
113
114
115
116
117
|
# frozen_string_literal: true
# == Schema Information
#
# Table name: tags
#
# id :bigint(8) not null, primary key
# name :string default(""), not null
# created_at :datetime not null
# updated_at :datetime not null
# local :boolean default(FALSE), not null
# private :boolean default(FALSE), not null
# unlisted :boolean default(FALSE), not null
# chat :boolean default(FALSE), not null
#
class Tag < ApplicationRecord
has_and_belongs_to_many :statuses
has_and_belongs_to_many :accounts
has_and_belongs_to_many :sample_accounts, -> { searchable.discoverable.popular.limit(3) }, class_name: 'Account'
has_many :featured_tags, dependent: :destroy, inverse_of: :tag
has_many :chat_accounts, dependent: :destroy, inverse_of: :tag
has_many :chatters, through: :chat_accounts, source: :account
has_one :account_tag_stat, dependent: :destroy
HASHTAG_NAME_RE = '[[:word:]:._\-]*[[:alpha:]:._·\-][[:word:]:._\-]*'
HASHTAG_RE = /(?:^|[^\/\)\w])#(#{HASHTAG_NAME_RE})/i
validates :name, presence: true, uniqueness: true, format: { with: /\A#{HASHTAG_NAME_RE}\z/i }
scope :discoverable, -> { joins(:account_tag_stat).where(AccountTagStat.arel_table[:accounts_count].gt(0)).where(account_tag_stats: { hidden: false }).order(Arel.sql('account_tag_stats.accounts_count desc')) }
scope :hidden, -> { where(account_tag_stats: { hidden: true }) }
scope :most_used, ->(account) { joins(:statuses).where(statuses: { account: account }).group(:id).order(Arel.sql('count(*) desc')) }
scope :only_local, -> { where(local: true, unlisted: false) }
scope :only_global, -> { where(local: false, unlisted: false) }
scope :only_private, -> { where(private: true) }
scope :only_unlisted, -> { where(unlisted: true) }
scope :only_chat, -> { where(chat: true) }
scope :only_public, -> { where(unlisted: false) }
delegate :accounts_count,
:accounts_count=,
:increment_count!,
:decrement_count!,
:hidden?,
to: :account_tag_stat
before_create :set_scope
after_save :save_account_tag_stat
def account_tag_stat
super || build_account_tag_stat
end
def cached_sample_accounts
Rails.cache.fetch("#{cache_key}/sample_accounts", expires_in: 12.hours) { sample_accounts }
end
def to_param
name
end
def history
days = []
7.times do |i|
day = i.days.ago.beginning_of_day.to_i
days << {
day: day.to_s,
uses: Redis.current.get("activity:tags:#{id}:#{day}") || '0',
accounts: Redis.current.pfcount("activity:tags:#{id}:#{day}:accounts").to_s,
}
end
days
end
class << self
def search_for(term, limit = 5, offset = 0)
term = term.strip.gsub(':', '.')
pattern = sanitize_sql_like(term) + '%'
Tag.only_public.where('lower(name) like lower(?)', pattern)
.or(Tag.only_unlisted.where(name: term))
.order(:name)
.limit(limit)
.offset(offset)
end
def find_normalized(name)
find_by(name: name.gsub(':', '.').mb_chars.downcase.to_s)
end
def find_normalized!(name)
find_normalized(name) || raise(ActiveRecord::RecordNotFound)
end
end
private
def save_account_tag_stat
return unless account_tag_stat&.changed?
account_tag_stat.save
end
def set_scope
self.private = true if name.in?(%w(self .self)) || name.starts_with?('self.', '.self.')
self.unlisted = true if self.private || name.starts_with?('.')
self.chat = true if name.starts_with?('chat.', '.chat')
self.local = true if self.private ||
name.in?(%w(local .local chat.local .chat.local)) ||
name.starts_with?('local.', '.local', 'chat.local.' '.chat.local')
end
end
|
