1 # frozen_string_literal: true
3 # == Schema Information
5 # Table name: social_links
7 # id :bigint not null, primary key
8 # user_id :bigint not null
10 # created_at :datetime not null
11 # updated_at :datetime not null
15 # index_social_links_on_user_id (user_id)
19 # fk_rails_... (user_id => users.id)
22 class SocialLink < ApplicationRecord
25 validates :url, :format => { :with => %r{\A(https?://.+|@([a-zA-Z0-9_]+)@([\w\-.]+))\z}, :message => :http_parse_error }
28 :bluesky => %r{\Ahttps?://(?:www\.)?bsky\.app/profile/([a-zA-Z0-9._-]+)},
29 :discord => %r{\Ahttps?://(?:www\.)?discord\.com/users/(\d+)},
30 :facebook => %r{\Ahttps?://(?:www\.)?facebook\.com/([a-zA-Z0-9.]+)},
31 :flickr => %r{\Ahttps?://(?:www\.)?flickr\.com/people/([a-zA-Z0-9@._-]+)},
32 :github => %r{\Ahttps?://(?:www\.)?github\.com/([a-zA-Z0-9_-]+)},
33 :gitlab => %r{\Ahttps?://(?:www\.)?gitlab\.com/([a-zA-Z0-9_-]+)},
34 :hdyc => %r{\Ahttps?://(?:www\.)?hdyc\.neis-one\.org/\?([a-zA-Z0-9_-]+)},
35 :hot => %r{\Ahttps?://tasks\.hotosm\.org/users/([a-zA-Z0-9_-]+)},
36 :instagram => %r{\Ahttps?://(?:www\.)?instagram\.com/([a-zA-Z0-9._]+)},
37 :linkedin => %r{\Ahttps?://(?:www\.)?linkedin\.com/in/([a-zA-Z0-9_-]+)},
38 :line => %r{\Ahttps?://(?:www\.)?line\.me/ti/p/([a-zA-Z0-9_-]+)},
39 :mapillary => %r{\Ahttps?://(?:www\.)?mapillary\.com/(?:app/user|profile)/([a-zA-Z0-9_-]+)},
40 :mastodon => %r{\Ahttps?://(?:(?:www\.)?(mastodon\.social|en\.osm\.town))/(@[a-zA-Z0-9_]+)},
41 :mastodon_general => /\A@([a-zA-Z0-9_]+)@([\w\-.]+)/,
42 :medium => %r{\Ahttps?://(?:www\.)?medium\.com/@([a-zA-Z0-9_]+)},
43 :ogf => %r{\Ahttps?://wiki\.opengeofiction\.net/index\.php/User:([a-zA-Z0-9_-]+)},
44 :ohm => %r{\Ahttps?://(?:www\.)?openhistoricalmap\.org/user/(\S+)},
45 :osm_forum => %r{\Ahttps?://community\.openstreetmap\.org/u/(\S+)},
46 :osm_wiki => %r{\Ahttps?://wiki\.openstreetmap\.org/wiki/User:([a-zA-Z0-9_-]+)},
47 :quora => %r{\Ahttps?://(?:www\.)?quora\.com/profile/([a-zA-Z0-9_-]+)},
48 :reddit => %r{\Ahttps?://(?:www\.)?reddit\.com/user/([a-zA-Z0-9_-]+)},
49 :slack => %r{\Ahttps?://join\.slack\.com/shareDM/([a-zA-Z0-9_~-]+)},
50 :snapchat => %r{\Ahttps?://(?:www\.)?snapchat\.com/add/([a-zA-Z0-9_-]+)},
51 :stackoverflow => %r{\Ahttps?://(?:www\.)?stackoverflow\.com/users/\d+/([a-zA-Z0-9_-]+)},
52 :strava => %r{\Ahttps?://(?:www\.)?strava\.com/athletes/([a-zA-Z0-9_-]+)},
53 :substack => %r{\Ahttps?://(?:www\.)?substack\.com/@([a-zA-Z0-9_-]+)},
54 :telegram => %r{\Ahttps?://(?:www\.)?t\.me/([a-zA-Z0-9_]+)},
55 :threads => %r{\Ahttps?://(?:www\.)?threads\.net/@([a-zA-Z0-9_]+)},
56 :tiktok => %r{\Ahttps?://(?:www\.)?tiktok\.com/@([a-zA-Z0-9_]+)},
57 :twitch => %r{\Ahttps?://(?:www\.)?twitch\.tv/([a-zA-Z0-9_]+)},
58 :twitter_x => %r{\Ahttps?://(?:www\.)?(?:twitter|x)\.com/([a-zA-Z0-9_]+)},
59 :vimeo => %r{\Ahttps?://(?:www\.)?vimeo\.com/([a-zA-Z0-9_]+)},
60 :whatsapp => %r{\Ahttps?://wa\.me/(\d+)},
61 :wikidata => %r{\Ahttps?://(?:www\.)?wikidata\.org/wiki/User:([a-zA-Z0-9_-]+)},
62 :wikimedia => %r{\Ahttps?://commons\.wikimedia\.org/wiki/User:([a-zA-Z0-9_-]+)},
63 :wikipedia => %r{\Ahttps?://(?:[a-zA-Z]+\.)?wikipedia\.org/wiki/User:([a-zA-Z0-9_-]+)},
64 :wikivoyage => %r{\Ahttps?://(?:[a-zA-Z]+\.)?wikivoyage\.org/wiki/User:([a-zA-Z0-9_-]+)},
65 :youtube => %r{\Ahttps?://(?:www\.)?youtube\.com/@([a-zA-Z0-9_-]+)}
68 NO_USERNAME_PLATFORMS = %w[discord line slack].freeze
71 URL_PATTERNS.each do |platform, pattern|
72 names = url.match(pattern)
75 if platform == :mastodon_general
77 :url => "https://#{names[2]}/@#{names[1]}",
78 :platform => "mastodon",
79 :name => "@#{names[1]}@#{names[2]}"
83 name = names[2].nil? ? names[1] : "#{names[2]}@#{names[1]}"
84 name = platform.to_s.capitalize if NO_USERNAME_PLATFORMS.include?(platform.to_s)
88 :platform => platform.to_s,
92 { :url => url, :platform => nil, :name => url.gsub(%r{https?://}, "") }