user.ex 29.5 KB
Newer Older
1
# Pleroma: A lightweight social networking server
kaniini's avatar
kaniini committed
2
# Copyright © 2017-2019 Pleroma Authors <https://pleroma.social/>
3
4
# SPDX-License-Identifier: AGPL-3.0-only

lain's avatar
lain committed
5
6
defmodule Pleroma.User do
  use Ecto.Schema
7

8
  import Ecto.{Changeset, Query}
9
  alias Pleroma.{Repo, User, Object, Web, Activity, Notification}
10
  alias Comeonin.Pbkdf2
Maxim Filippov's avatar
Maxim Filippov committed
11
12
  alias Pleroma.Formatter
  alias Pleroma.Web.CommonAPI.Utils, as: CommonUtils
13
  alias Pleroma.Web.{OStatus, Websub, OAuth}
lain's avatar
lain committed
14
  alias Pleroma.Web.ActivityPub.{Utils, ActivityPub}
lain's avatar
lain committed
15

16
17
  require Logger

Maksim's avatar
Maksim committed
18
19
  @type t :: %__MODULE__{}

href's avatar
href committed
20
21
22
  @email_regex ~r/^[a-zA-Z0-9.!#$%&'*+\/=?^_`{|}~-]+@[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?(?:\.[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?)*$/

  @strict_local_nickname_regex ~r/^[a-zA-Z\d]+$/
href's avatar
href committed
23
  @extended_local_nickname_regex ~r/^[a-zA-Z\d_-]+$/
href's avatar
href committed
24

lain's avatar
lain committed
25
  schema "users" do
lain's avatar
lain committed
26
27
28
29
30
31
32
33
34
35
36
37
    field(:bio, :string)
    field(:email, :string)
    field(:name, :string)
    field(:nickname, :string)
    field(:password_hash, :string)
    field(:password, :string, virtual: true)
    field(:password_confirmation, :string, virtual: true)
    field(:following, {:array, :string}, default: [])
    field(:ap_id, :string)
    field(:avatar, :map)
    field(:local, :boolean, default: true)
    field(:follower_address, :string)
38
    field(:search_rank, :float, virtual: true)
39
    field(:tags, {:array, :string}, default: [])
40
    field(:last_refreshed_at, :naive_datetime)
lain's avatar
lain committed
41
    has_many(:notifications, Notification)
lain's avatar
lain committed
42
    embeds_one(:info, Pleroma.User.Info)
lain's avatar
lain committed
43
44
45

    timestamps()
  end
lain's avatar
lain committed
46

47
  def auth_active?(%User{local: false}), do: true
48

49
50
51
52
  def auth_active?(%User{info: %User.Info{confirmation_pending: false}}), do: true

  def auth_active?(%User{info: %User.Info{confirmation_pending: true}}),
    do: !Pleroma.Config.get([:instance, :account_activation_required])
53

54
  def auth_active?(_), do: false
55

56
57
58
59
60
  def visible_for?(user, for_user \\ nil)

  def visible_for?(%User{id: user_id}, %User{id: for_id}) when user_id == for_id, do: true

  def visible_for?(%User{} = user, for_user) do
61
    auth_active?(user) || superuser?(for_user)
62
63
  end

64
65
  def visible_for?(_, _), do: false

66
67
  def superuser?(%User{local: true, info: %User.Info{is_admin: true}}), do: true
  def superuser?(%User{local: true, info: %User.Info{is_moderator: true}}), do: true
68
  def superuser?(_), do: false
69

lain's avatar
lain committed
70
71
72
  def avatar_url(user) do
    case user.avatar do
      %{"url" => [%{"href" => href} | _]} -> href
73
      _ -> "#{Web.base_url()}/images/avi.png"
lain's avatar
lain committed
74
75
76
    end
  end

lain's avatar
lain committed
77
  def banner_url(user) do
lain's avatar
lain committed
78
    case user.info.banner do
lain's avatar
lain committed
79
      %{"url" => [%{"href" => href} | _]} -> href
80
      _ -> "#{Web.base_url()}/images/banner.png"
lain's avatar
lain committed
81
82
83
    end
  end

lain's avatar
lain committed
84
  def profile_url(%User{info: %{source_data: %{"url" => url}}}), do: url
85
86
87
  def profile_url(%User{ap_id: ap_id}), do: ap_id
  def profile_url(_), do: nil

lain's avatar
lain committed
88
  def ap_id(%User{nickname: nickname}) do
lain's avatar
lain committed
89
    "#{Web.base_url()}/users/#{nickname}"
lain's avatar
lain committed
90
91
92
93
94
  end

  def ap_followers(%User{} = user) do
    "#{ap_id(user)}/followers"
  end
lain's avatar
lain committed
95
96
97
98
99
100
101

  def follow_changeset(struct, params \\ %{}) do
    struct
    |> cast(params, [:following])
    |> validate_required([:following])
  end

lain's avatar
lain committed
102
  def user_info(%User{} = user) do
103
    oneself = if user.local, do: 1, else: 0
lain's avatar
lain committed
104

lain's avatar
lain committed
105
    %{
106
      following_count: length(user.following) - oneself,
Ivan Tashkinov's avatar
Ivan Tashkinov committed
107
108
109
110
111
      note_count: user.info.note_count,
      follower_count: user.info.follower_count,
      locked: user.info.locked,
      confirmation_pending: user.info.confirmation_pending,
      default_scope: user.info.default_scope
lain's avatar
lain committed
112
113
114
    }
  end

lain's avatar
lain committed
115
  def remote_user_creation(params) do
lain's avatar
lain committed
116
117
118
    params =
      params
      |> Map.put(:info, params[:info] || %{})
lain's avatar
lain committed
119
120
121

    info_cng = User.Info.remote_user_creation(%User.Info{}, params[:info])

lain's avatar
lain committed
122
    changes =
lain's avatar
lain committed
123
      %User{}
lain's avatar
lain committed
124
      |> cast(params, [:bio, :name, :ap_id, :nickname, :avatar])
125
      |> validate_required([:name, :ap_id])
lain's avatar
lain committed
126
127
128
129
130
      |> unique_constraint(:nickname)
      |> validate_format(:nickname, @email_regex)
      |> validate_length(:bio, max: 5000)
      |> validate_length(:name, max: 100)
      |> put_change(:local, false)
lain's avatar
lain committed
131
      |> put_embed(:info, info_cng)
lain's avatar
lain committed
132

133
    if changes.valid? do
lain's avatar
lain committed
134
      case info_cng.changes[:source_data] do
lain's avatar
lain committed
135
136
137
        %{"followers" => followers} ->
          changes
          |> put_change(:follower_address, followers)
lain's avatar
lain committed
138

lain's avatar
lain committed
139
140
        _ ->
          followers = User.ap_followers(%User{nickname: changes.changes[:nickname]})
lain's avatar
lain committed
141

lain's avatar
lain committed
142
143
144
          changes
          |> put_change(:follower_address, followers)
      end
145
146
147
    else
      changes
    end
lain's avatar
lain committed
148
149
  end

lain's avatar
lain committed
150
  def update_changeset(struct, params \\ %{}) do
Thog's avatar
Thog committed
151
    struct
lain's avatar
lain committed
152
    |> cast(params, [:bio, :name, :avatar])
lain's avatar
lain committed
153
    |> unique_constraint(:nickname)
href's avatar
href committed
154
    |> validate_format(:nickname, local_nickname_regex())
lain's avatar
lain committed
155
    |> validate_length(:bio, max: 5000)
lain's avatar
lain committed
156
157
158
    |> validate_length(:name, min: 1, max: 100)
  end

lain's avatar
lain committed
159
  def upgrade_changeset(struct, params \\ %{}) do
160
161
162
163
    params =
      params
      |> Map.put(:last_refreshed_at, NaiveDateTime.utc_now())

lain's avatar
lain committed
164
165
166
167
    info_cng =
      struct.info
      |> User.Info.user_upgrade(params[:info])

lain's avatar
lain committed
168
    struct
lain's avatar
lain committed
169
    |> cast(params, [:bio, :name, :follower_address, :avatar, :last_refreshed_at])
lain's avatar
lain committed
170
    |> unique_constraint(:nickname)
href's avatar
href committed
171
    |> validate_format(:nickname, local_nickname_regex())
lain's avatar
lain committed
172
173
    |> validate_length(:bio, max: 5000)
    |> validate_length(:name, max: 100)
lain's avatar
lain committed
174
    |> put_embed(:info, info_cng)
lain's avatar
lain committed
175
176
  end

Roger Braun's avatar
Roger Braun committed
177
  def password_update_changeset(struct, params) do
lain's avatar
lain committed
178
179
180
181
182
    changeset =
      struct
      |> cast(params, [:password, :password_confirmation])
      |> validate_required([:password, :password_confirmation])
      |> validate_confirmation(:password)
Roger Braun's avatar
Roger Braun committed
183

184
185
186
    OAuth.Token.delete_user_tokens(struct)
    OAuth.Authorization.delete_user_authorizations(struct)

Roger Braun's avatar
Roger Braun committed
187
188
    if changeset.valid? do
      hashed = Pbkdf2.hashpwsalt(changeset.changes[:password])
lain's avatar
lain committed
189

Roger Braun's avatar
Roger Braun committed
190
191
192
193
194
195
196
197
      changeset
      |> put_change(:password_hash, hashed)
    else
      changeset
    end
  end

  def reset_password(user, data) do
lain's avatar
lain committed
198
    update_and_set_cache(password_update_changeset(user, data))
Roger Braun's avatar
Roger Braun committed
199
200
  end

201
202
203
204
205
206
207
208
  def register_changeset(struct, params \\ %{}, opts \\ []) do
    confirmation_status =
      if opts[:confirmed] || !Pleroma.Config.get([:instance, :account_activation_required]) do
        :confirmed
      else
        :unconfirmed
      end

Ivan Tashkinov's avatar
Ivan Tashkinov committed
209
210
    info_change = User.Info.confirmation_changeset(%User.Info{}, confirmation_status)

lain's avatar
lain committed
211
212
213
214
215
216
217
    changeset =
      struct
      |> cast(params, [:bio, :email, :name, :nickname, :password, :password_confirmation])
      |> validate_required([:email, :name, :nickname, :password, :password_confirmation])
      |> validate_confirmation(:password)
      |> unique_constraint(:email)
      |> unique_constraint(:nickname)
lain's avatar
lain committed
218
      |> validate_exclusion(:nickname, Pleroma.Config.get([Pleroma.User, :restricted_nicknames]))
href's avatar
href committed
219
      |> validate_format(:nickname, local_nickname_regex())
lain's avatar
lain committed
220
221
222
      |> validate_format(:email, @email_regex)
      |> validate_length(:bio, max: 1000)
      |> validate_length(:name, min: 1, max: 100)
Ivan Tashkinov's avatar
Ivan Tashkinov committed
223
      |> put_change(:info, info_change)
lain's avatar
lain committed
224
225

    if changeset.valid? do
226
      hashed = Pbkdf2.hashpwsalt(changeset.changes[:password])
lain's avatar
lain committed
227
228
      ap_id = User.ap_id(%User{nickname: changeset.changes[:nickname]})
      followers = User.ap_followers(%User{nickname: changeset.changes[:nickname]})
lain's avatar
lain committed
229

lain's avatar
lain committed
230
231
232
233
      changeset
      |> put_change(:password_hash, hashed)
      |> put_change(:ap_id, ap_id)
      |> put_change(:following, [followers])
234
      |> put_change(:follower_address, followers)
lain's avatar
lain committed
235
236
237
238
239
    else
      changeset
    end
  end

240
241
242
243
244
245
246
247
248
249
  defp autofollow_users(user) do
    candidates = Pleroma.Config.get([:instance, :autofollowed_nicknames])

    autofollowed_users =
      from(u in User,
        where: u.local == true,
        where: u.nickname in ^candidates
      )
      |> Repo.all()

lain's avatar
lain committed
250
    follow_all(user, autofollowed_users)
251
252
  end

253
254
  @doc "Inserts provided changeset, performs post-registration actions (confirmation email sending etc.)"
  def register(%Ecto.Changeset{} = changeset) do
Ivan Tashkinov's avatar
Ivan Tashkinov committed
255
    with {:ok, user} <- Repo.insert(changeset),
256
257
         {:ok, _} <- try_send_confirmation_email(user),
         {:ok, user} <- autofollow_users(user) do
258
259
260
261
      {:ok, user}
    end
  end

262
  def try_send_confirmation_email(%User{} = user) do
263
264
    if user.info.confirmation_pending &&
         Pleroma.Config.get([:instance, :account_activation_required]) do
265
266
267
268
269
270
271
272
      user
      |> Pleroma.UserEmail.account_confirmation_email()
      |> Pleroma.Mailer.deliver()
    else
      {:ok, :noop}
    end
  end

273
274
275
276
277
278
279
280
281
282
  def needs_update?(%User{local: true}), do: false

  def needs_update?(%User{local: false, last_refreshed_at: nil}), do: true

  def needs_update?(%User{local: false} = user) do
    NaiveDateTime.diff(NaiveDateTime.utc_now(), user.last_refreshed_at) >= 86400
  end

  def needs_update?(_), do: true

lain's avatar
lain committed
283
  def maybe_direct_follow(%User{} = follower, %User{local: true, info: %{locked: true}}) do
284
285
286
287
288
289
290
291
    {:ok, follower}
  end

  def maybe_direct_follow(%User{} = follower, %User{local: true} = followed) do
    follow(follower, followed)
  end

  def maybe_direct_follow(%User{} = follower, %User{} = followed) do
Maksim's avatar
Maksim committed
292
    if not User.ap_enabled?(followed) do
293
      follow(follower, followed)
294
295
296
297
298
    else
      {:ok, follower}
    end
  end

Maksim's avatar
Maksim committed
299
  def maybe_follow(%User{} = follower, %User{info: _info} = followed) do
300
301
    if not following?(follower, followed) do
      follow(follower, followed)
302
    else
303
      {:ok, follower}
304
305
306
    end
  end

lain's avatar
lain committed
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
  @doc "A mass follow for local users. Ignores blocks and has no side effects"
  @spec follow_all(User.t(), list(User.t())) :: {atom(), User.t()}
  def follow_all(follower, followeds) do
    following =
      (follower.following ++ Enum.map(followeds, fn %{follower_address: fa} -> fa end))
      |> Enum.uniq()

    {:ok, follower} =
      follower
      |> follow_changeset(%{following: following})
      |> update_and_set_cache

    Enum.each(followeds, fn followed ->
      update_follower_count(followed)
    end)

    {:ok, follower}
  end

lain's avatar
lain committed
326
  def follow(%User{} = follower, %User{info: info} = followed) do
327
328
    user_config = Application.get_env(:pleroma, :user)
    deny_follow_blocked = Keyword.get(user_config, :deny_follow_blocked)
329

330
    ap_followers = followed.follower_address
331

332
    cond do
lain's avatar
lain committed
333
      following?(follower, followed) or info.deactivated ->
334
        {:error, "Could not follow user: #{followed.nickname} is already on your list."}
lain's avatar
lain committed
335

336
      deny_follow_blocked and blocks?(followed, follower) ->
337
        {:error, "Could not follow user: #{followed.nickname} blocked you."}
lain's avatar
lain committed
338

339
340
341
342
343
344
345
346
      true ->
        if !followed.local && follower.local && !ap_enabled?(followed) do
          Websub.subscribe(follower, followed)
        end

        following =
          [ap_followers | follower.following]
          |> Enum.uniq()
347

348
349
350
351
        follower =
          follower
          |> follow_changeset(%{following: following})
          |> update_and_set_cache
352

353
354
355
        {:ok, _} = update_follower_count(followed)

        follower
356
    end
lain's avatar
lain committed
357
  end
lain's avatar
lain committed
358
359

  def unfollow(%User{} = follower, %User{} = followed) do
360
    ap_followers = followed.follower_address
lain's avatar
lain committed
361

362
    if following?(follower, followed) and follower.ap_id != followed.ap_id do
lain's avatar
lain committed
363
364
365
      following =
        follower.following
        |> List.delete(ap_followers)
lain's avatar
lain committed
366

lain's avatar
lain committed
367
368
369
370
      {:ok, follower} =
        follower
        |> follow_changeset(%{following: following})
        |> update_and_set_cache
371
372
373
374

      {:ok, followed} = update_follower_count(followed)

      {:ok, follower, Utils.fetch_latest_follow(follower, followed)}
375
    else
376
      {:error, "Not subscribed!"}
377
    end
lain's avatar
lain committed
378
  end
379

Maksim's avatar
Maksim committed
380
  @spec following?(User.t(), User.t()) :: boolean
381
  def following?(%User{} = follower, %User{} = followed) do
382
    Enum.member?(follower.following, followed.follower_address)
383
  end
lain's avatar
lain committed
384

385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
  def follow_import(%User{} = follower, followed_identifiers)
      when is_list(followed_identifiers) do
    Enum.map(
      followed_identifiers,
      fn followed_identifier ->
        with %User{} = followed <- get_or_fetch(followed_identifier),
             {:ok, follower} <- maybe_direct_follow(follower, followed),
             {:ok, _} <- ActivityPub.follow(follower, followed) do
          followed
        else
          err ->
            Logger.debug("follow_import failed for #{followed_identifier} with: #{inspect(err)}")
            err
        end
      end
    )
  end

403
  def locked?(%User{} = user) do
404
    user.info.locked || false
405
406
  end

lain's avatar
lain committed
407
408
409
410
  def get_by_ap_id(ap_id) do
    Repo.get_by(User, ap_id: ap_id)
  end

411
412
413
414
415
416
417
418
419
  # This is mostly an SPC migration fix. This guesses the user nickname (by taking the last part of the ap_id and the domain) and tries to get that user
  def get_by_guessed_nickname(ap_id) do
    domain = URI.parse(ap_id).host
    name = List.last(String.split(ap_id, "/"))
    nickname = "#{name}@#{domain}"

    get_by_nickname(nickname)
  end

lain's avatar
lain committed
420
421
  def update_and_set_cache(changeset) do
    with {:ok, user} <- Repo.update(changeset) do
Thog's avatar
Thog committed
422
423
424
      Cachex.put(:user_cache, "ap_id:#{user.ap_id}", user)
      Cachex.put(:user_cache, "nickname:#{user.nickname}", user)
      Cachex.put(:user_cache, "user_info:#{user.id}", user_info(user))
lain's avatar
lain committed
425
426
427
428
429
430
      {:ok, user}
    else
      e -> e
    end
  end

lain's avatar
lain committed
431
432
433
  def invalidate_cache(user) do
    Cachex.del(:user_cache, "ap_id:#{user.ap_id}")
    Cachex.del(:user_cache, "nickname:#{user.nickname}")
434
    Cachex.del(:user_cache, "user_info:#{user.id}")
lain's avatar
lain committed
435
436
  end

lain's avatar
lain committed
437
  def get_cached_by_ap_id(ap_id) do
438
    key = "ap_id:#{ap_id}"
Thog's avatar
Thog committed
439
    Cachex.fetch!(:user_cache, key, fn _ -> get_by_ap_id(ap_id) end)
lain's avatar
lain committed
440
441
442
  end

  def get_cached_by_nickname(nickname) do
443
    key = "nickname:#{nickname}"
Thog's avatar
Thog committed
444
    Cachex.fetch!(:user_cache, key, fn _ -> get_or_fetch_by_nickname(nickname) end)
lain's avatar
lain committed
445
  end
lain's avatar
lain committed
446

lain's avatar
lain committed
447
  def get_by_nickname(nickname) do
448
    Repo.get_by(User, nickname: nickname) ||
449
      if Regex.match?(~r(@#{Pleroma.Web.Endpoint.host()})i, nickname) do
450
451
452
        [local_nickname, _] = String.split(nickname, "@")
        Repo.get_by(User, nickname: local_nickname)
      end
453
454
  end

455
456
457
458
459
460
461
  def get_by_nickname_or_email(nickname_or_email) do
    case user = Repo.get_by(User, nickname: nickname_or_email) do
      %User{} -> user
      nil -> Repo.get_by(User, email: nickname_or_email)
    end
  end

lain's avatar
lain committed
462
463
  def get_cached_user_info(user) do
    key = "user_info:#{user.id}"
Thog's avatar
Thog committed
464
    Cachex.fetch!(:user_cache, key, fn _ -> user_info(user) end)
lain's avatar
lain committed
465
  end
lain's avatar
lain committed
466

lain's avatar
lain committed
467
468
469
470
471
472
473
474
475
  def fetch_by_nickname(nickname) do
    ap_try = ActivityPub.make_user_from_nickname(nickname)

    case ap_try do
      {:ok, user} -> {:ok, user}
      _ -> OStatus.make_user(nickname)
    end
  end

lain's avatar
lain committed
476
  def get_or_fetch_by_nickname(nickname) do
lain's avatar
lain committed
477
    with %User{} = user <- get_by_nickname(nickname) do
lain's avatar
lain committed
478
      user
lain's avatar
lain committed
479
480
481
482
483
484
485
486
    else
      _e ->
        with [_nick, _domain] <- String.split(nickname, "@"),
             {:ok, user} <- fetch_by_nickname(nickname) do
          user
        else
          _e -> nil
        end
lain's avatar
lain committed
487
    end
lain's avatar
lain committed
488
  end
lain's avatar
lain committed
489

490
  def get_followers_query(%User{id: id, follower_address: follower_address}, nil) do
491
492
493
494
495
496
497
    from(
      u in User,
      where: fragment("? <@ ?", ^[follower_address], u.following),
      where: u.id != ^id
    )
  end

498
499
500
501
502
503
504
505
506
507
508
509
  def get_followers_query(user, page) do
    from(
      u in get_followers_query(user, nil),
      limit: 20,
      offset: ^((page - 1) * 20)
    )
  end

  def get_followers_query(user), do: get_followers_query(user, nil)

  def get_followers(user, page \\ nil) do
    q = get_followers_query(user, page)
lain's avatar
lain committed
510
511
512
513

    {:ok, Repo.all(q)}
  end

514
515
516
517
518
519
  def get_followers_ids(user, page \\ nil) do
    q = get_followers_query(user, page)

    Repo.all(from(u in q, select: u.id))
  end

520
  def get_friends_query(%User{id: id, following: following}, nil) do
521
522
523
524
525
526
527
    from(
      u in User,
      where: u.follower_address in ^following,
      where: u.id != ^id
    )
  end

528
529
530
531
532
533
534
535
536
537
538
539
  def get_friends_query(user, page) do
    from(
      u in get_friends_query(user, nil),
      limit: 20,
      offset: ^((page - 1) * 20)
    )
  end

  def get_friends_query(user), do: get_friends_query(user, nil)

  def get_friends(user, page \\ nil) do
    q = get_friends_query(user, page)
lain's avatar
lain committed
540
541
542

    {:ok, Repo.all(q)}
  end
543

544
545
546
547
548
549
  def get_friends_ids(user, page \\ nil) do
    q = get_friends_query(user, page)

    Repo.all(from(u in q, select: u.id))
  end

550
551
552
  def get_follow_requests_query(%User{} = user) do
    from(
      a in Activity,
kaniini's avatar
kaniini committed
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
      where:
        fragment(
          "? ->> 'type' = 'Follow'",
          a.data
        ),
      where:
        fragment(
          "? ->> 'state' = 'pending'",
          a.data
        ),
      where:
        fragment(
          "? @> ?",
          a.data,
          ^%{"object" => user.ap_id}
        )
569
570
571
572
573
574
575
576
    )
  end

  def get_follow_requests(%User{} = user) do
    q = get_follow_requests_query(user)
    reqs = Repo.all(q)

    users =
kaniini's avatar
kaniini committed
577
578
579
      Enum.map(reqs, fn req -> req.actor end)
      |> Enum.uniq()
      |> Enum.map(fn ap_id -> get_by_ap_id(ap_id) end)
580
      |> Enum.filter(fn u -> !is_nil(u) end)
581
      |> Enum.filter(fn u -> !following?(u, user) end)
582
583
584
585

    {:ok, users}
  end

586
  def increase_note_count(%User{} = user) do
lain's avatar
lain committed
587
    info_cng = User.Info.add_to_note_count(user.info, 1)
lain's avatar
lain committed
588
589
590
591

    cng =
      change(user)
      |> put_embed(:info, info_cng)
592

lain's avatar
lain committed
593
    update_and_set_cache(cng)
594
595
  end

596
  def decrease_note_count(%User{} = user) do
lain's avatar
lain committed
597
    info_cng = User.Info.add_to_note_count(user.info, -1)
lain's avatar
lain committed
598
599
600
601

    cng =
      change(user)
      |> put_embed(:info, info_cng)
602

lain's avatar
lain committed
603
    update_and_set_cache(cng)
604
605
  end

606
  def update_note_count(%User{} = user) do
lain's avatar
lain committed
607
608
609
610
611
612
    note_count_query =
      from(
        a in Object,
        where: fragment("?->>'actor' = ? and ?->>'type' = 'Note'", a.data, ^user.ap_id, a.data),
        select: count(a.id)
      )
613
614
615

    note_count = Repo.one(note_count_query)

lain's avatar
lain committed
616
    info_cng = User.Info.set_note_count(user.info, note_count)
617

lain's avatar
lain committed
618
619
620
    cng =
      change(user)
      |> put_embed(:info, info_cng)
621

lain's avatar
lain committed
622
    update_and_set_cache(cng)
623
624
625
  end

  def update_follower_count(%User{} = user) do
lain's avatar
lain committed
626
627
628
629
630
631
632
    follower_count_query =
      from(
        u in User,
        where: ^user.follower_address in u.following,
        where: u.id != ^user.id,
        select: count(u.id)
      )
633
634
635

    follower_count = Repo.one(follower_count_query)

lain's avatar
lain committed
636
637
638
    info_cng =
      user.info
      |> User.Info.set_follower_count(follower_count)
639

lain's avatar
lain committed
640
641
642
    cng =
      change(user)
      |> put_embed(:info, info_cng)
643

lain's avatar
lain committed
644
    update_and_set_cache(cng)
645
  end
646

647
  def get_users_from_set_query(ap_ids, false) do
648
649
    from(
      u in User,
650
      where: u.ap_id in ^ap_ids
651
652
653
    )
  end

654
655
  def get_users_from_set_query(ap_ids, true) do
    query = get_users_from_set_query(ap_ids, false)
656
657
658

    from(
      u in query,
659
660
661
662
      where: u.local == true
    )
  end

663
664
665
666
667
  def get_users_from_set(ap_ids, local_only \\ true) do
    get_users_from_set_query(ap_ids, local_only)
    |> Repo.all()
  end

668
  def get_recipients_from_activity(%Activity{recipients: to}) do
lain's avatar
lain committed
669
670
671
672
673
674
    query =
      from(
        u in User,
        where: u.ap_id in ^to,
        or_where: fragment("? && ?", u.following, ^to)
      )
675

lain's avatar
lain committed
676
    query = from(u in query, where: u.local == true)
677

678
679
680
    Repo.all(query)
  end

681
  def search(query, resolve \\ false, for_user \\ nil) do
682
    # Strip the beginning @ off if there is a query
683
684
    query = String.trim_leading(query, "@")

685
    if resolve, do: User.get_or_fetch_by_nickname(query)
lain's avatar
lain committed
686

687
    fts_results = do_search(fts_search_subquery(query), for_user)
688

689
    trigram_results = do_search(trigram_search_subquery(query), for_user)
lain's avatar
lain committed
690

691
692
693
694
    Enum.uniq_by(fts_results ++ trigram_results, & &1.id)
  end

  defp do_search(subquery, for_user, options \\ []) do
kaniini's avatar
kaniini committed
695
696
    q =
      from(
697
        s in subquery(subquery),
698
        order_by: [desc: s.search_rank],
699
        limit: ^(options[:limit] || 20)
kaniini's avatar
kaniini committed
700
      )
lain's avatar
lain committed
701

702
703
704
705
706
    results =
      q
      |> Repo.all()
      |> Enum.filter(&(&1.search_rank > 0))

707
708
    boost_search_results(results, for_user)
  end
709

710
711
712
713
714
715
716
717
  defp fts_search_subquery(query) do
    processed_query =
      query
      |> String.replace(~r/\W+/, " ")
      |> String.trim()
      |> String.split()
      |> Enum.map(&(&1 <> ":*"))
      |> Enum.join(" | ")
718

719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
    from(
      u in User,
      select_merge: %{
        search_rank:
          fragment(
            """
            ts_rank_cd(
              setweight(to_tsvector('simple', regexp_replace(?, '\\W', ' ', 'g')), 'A') ||
              setweight(to_tsvector('simple', regexp_replace(coalesce(?, ''), '\\W', ' ', 'g')), 'B'),
              to_tsquery('simple', ?),
              32
            )
            """,
            u.nickname,
            u.name,
            ^processed_query
          )
      },
lain's avatar
lain committed
737
738
739
740
741
742
743
744
745
746
      where:
        fragment(
          """
            (setweight(to_tsvector('simple', regexp_replace(?, '\\W', ' ', 'g')), 'A') ||
            setweight(to_tsvector('simple', regexp_replace(coalesce(?, ''), '\\W', ' ', 'g')), 'B')) @@ to_tsquery('simple', ?)
          """,
          u.nickname,
          u.name,
          ^processed_query
        )
747
748
    )
  end
749

750
751
752
753
754
755
  defp trigram_search_subquery(query) do
    from(
      u in User,
      select_merge: %{
        search_rank:
          fragment(
756
            "similarity(?, trim(? || ' ' || coalesce(?, '')))",
757
758
759
760
761
            ^query,
            u.nickname,
            u.name
          )
      },
lain's avatar
lain committed
762
      where: fragment("trim(? || ' ' || coalesce(?, '')) % ?", u.nickname, u.name, ^query)
763
764
765
766
767
768
769
770
    )
  end

  defp boost_search_results(results, nil), do: results

  defp boost_search_results(results, for_user) do
    friends_ids = get_friends_ids(for_user)
    followers_ids = get_followers_ids(for_user)
771

772
773
774
775
776
777
778
779
780
781
782
783
784
    Enum.map(
      results,
      fn u ->
        search_rank_coef =
          cond do
            u.id in friends_ids ->
              1.2

            u.id in followers_ids ->
              1.1

            true ->
              1
785
786
          end

787
788
789
790
        Map.put(u, :search_rank, u.search_rank * search_rank_coef)
      end
    )
    |> Enum.sort_by(&(-&1.search_rank))
lain's avatar
lain committed
791
  end
lain's avatar
lain committed
792

793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
  def blocks_import(%User{} = blocker, blocked_identifiers) when is_list(blocked_identifiers) do
    Enum.map(
      blocked_identifiers,
      fn blocked_identifier ->
        with %User{} = blocked <- get_or_fetch(blocked_identifier),
             {:ok, blocker} <- block(blocker, blocked),
             {:ok, _} <- ActivityPub.block(blocker, blocked) do
          blocked
        else
          err ->
            Logger.debug("blocks_import failed for #{blocked_identifier} with: #{inspect(err)}")
            err
        end
      end
    )
  end

810
811
812
813
814
815
816
817
818
819
820
821
822
823
  def block(blocker, %User{ap_id: ap_id} = blocked) do
    # sever any follow relationships to prevent leaks per activitypub (Pleroma issue #213)
    blocker =
      if following?(blocker, blocked) do
        {:ok, blocker, _} = unfollow(blocker, blocked)
        blocker
      else
        blocker
      end

    if following?(blocked, blocker) do
      unfollow(blocked, blocker)
    end

lain's avatar
lain committed
824
825
826
    info_cng =
      blocker.info
      |> User.Info.add_to_block(ap_id)
lain's avatar
lain committed
827

lain's avatar
lain committed
828
829
830
831
832
    cng =
      change(blocker)
      |> put_embed(:info, info_cng)

    update_and_set_cache(cng)
lain's avatar
lain committed
833
834
  end

835
836
837
838
839
  # helper to handle the block given only an actor's AP id
  def block(blocker, %{ap_id: ap_id}) do
    block(blocker, User.get_by_ap_id(ap_id))
  end

lain's avatar
lain committed
840
841
842
843
  def unblock(blocker, %{ap_id: ap_id}) do
    info_cng =
      blocker.info
      |> User.Info.remove_from_block(ap_id)
lain's avatar
lain committed
844

lain's avatar
lain committed
845
846
847
848
849
    cng =
      change(blocker)
      |> put_embed(:info, info_cng)

    update_and_set_cache(cng)
lain's avatar
lain committed
850
851
852
  end

  def blocks?(user, %{ap_id: ap_id}) do
lain's avatar
lain committed
853
854
    blocks = user.info.blocks
    domain_blocks = user.info.domain_blocks
eal's avatar
eal committed
855
    %{host: host} = URI.parse(ap_id)
eal's avatar
eal committed
856
857
858
859
860

    Enum.member?(blocks, ap_id) ||
      Enum.any?(domain_blocks, fn domain ->
        host == domain
      end)
eal's avatar
eal committed
861
862
  end

863
864
865
  def blocked_users(user),
    do: Repo.all(from(u in User, where: u.ap_id in ^user.info.blocks))

eal's avatar
eal committed
866
  def block_domain(user, domain) do
lain's avatar
lain committed
867
868
869
    info_cng =
      user.info
      |> User.Info.add_to_domain_block(domain)
eal's avatar
eal committed
870

lain's avatar
lain committed
871
872
873
    cng =
      change(user)
      |> put_embed(:info, info_cng)
lain's avatar
lain committed
874
875

    update_and_set_cache(cng)
eal's avatar
eal committed
876
877
878
  end

  def unblock_domain(user, domain) do
lain's avatar
lain committed
879
880
881
    info_cng =
      user.info
      |> User.Info.remove_from_domain_block(domain)
eal's avatar
eal committed
882

lain's avatar
lain committed
883
884
885
    cng =
      change(user)
      |> put_embed(:info, info_cng)
lain's avatar
lain committed
886
887

    update_and_set_cache(cng)
lain's avatar
lain committed
888
889
  end

lain's avatar
lain committed
890
  def local_user_query() do
891
892
893
894
895
    from(
      u in User,
      where: u.local == true,
      where: not is_nil(u.nickname)
    )
lain's avatar
lain committed
896
897
  end

kaniini's avatar
kaniini committed
898
899
900
901
902
903
904
905
  def moderator_user_query() do
    from(
      u in User,
      where: u.local == true,
      where: fragment("?->'is_moderator' @> 'true'", u.info)
    )
  end

scarlett's avatar
scarlett committed
906
  def deactivate(%User{} = user, status \\ true) do
lain's avatar
lain committed
907
    info_cng = User.Info.set_activation_status(user.info, status)
lain's avatar
lain committed
908
909
910
911

    cng =
      change(user)
      |> put_embed(:info, info_cng)
lain's avatar
lain committed
912
913

    update_and_set_cache(cng)
lain's avatar
lain committed
914
  end
lain's avatar
lain committed
915

lain's avatar
lain committed
916
  def delete(%User{} = user) do
lain's avatar
lain committed
917
918
919
    {:ok, user} = User.deactivate(user)

    # Remove all relationships
lain's avatar
lain committed
920
921
    {:ok, followers} = User.get_followers(user)

lain's avatar
lain committed
922
    followers
lain's avatar
lain committed
923
    |> Enum.each(fn follower -> User.unfollow(follower, user) end)
lain's avatar
lain committed
924
925

    {:ok, friends} = User.get_friends(user)
lain's avatar
lain committed
926

lain's avatar
lain committed
927
    friends
lain's avatar
lain committed
928
    |> Enum.each(fn followed -> User.unfollow(user, followed) end)
lain's avatar
lain committed
929

lain's avatar
lain committed
930
    query = from(a in Activity, where: a.actor == ^user.ap_id)
lain's avatar
lain committed
931
932

    Repo.all(query)
lain's avatar
lain committed
933
    |> Enum.each(fn activity ->
lain's avatar
lain committed
934
      case activity.data["type"] do
lain's avatar
lain committed
935
        "Create" ->
936
          ActivityPub.delete(Object.normalize(activity.data["object"]))
lain's avatar
lain committed
937
938
939
940

        # TODO: Do something with likes, follows, repeats.
        _ ->
          "Doing nothing"
lain's avatar
lain committed
941
942
943
      end
    end)

944
    {:ok, user}
lain's avatar
lain committed
945
  end
946

lain's avatar
lain committed
947
  def html_filter_policy(%User{info: %{no_rich_text: true}}) do
kaniini's avatar
kaniini committed
948
949
950
    Pleroma.HTML.Scrubber.TwitterText
  end

951
952
953
  @default_scrubbers Pleroma.Config.get([:markup, :scrub_policy])

  def html_filter_policy(_), do: @default_scrubbers
kaniini's avatar
kaniini committed
954

955
  def get_or_fetch_by_ap_id(ap_id) do
956
957
958
    user = get_by_ap_id(ap_id)

    if !is_nil(user) and !User.needs_update?(user) do
959
960
      user
    else
lain's avatar
lain committed
961
962
963
      ap_try = ActivityPub.make_user_from_ap_id(ap_id)

      case ap_try do
lain's avatar
lain committed
964
965
966
        {:ok, user} ->
          user

lain's avatar
lain committed
967
968
969
        _ ->
          case OStatus.make_user(ap_id) do
            {:ok, user} -> user
feld's avatar
feld committed
970
            _ -> {:error, "Could not fetch by AP id"}
lain's avatar
lain committed
971
          end
972
973
974
975
      end
    end
  end

976
  def get_or_create_instance_user do
977
978
979
    relay_uri = "#{Pleroma.Web.Endpoint.url()}/relay"

    if user = get_by_ap_id(relay_uri) do
980
981
982
      user
    else
      changes =
lain's avatar
lain committed
983
        %User{info: %User.Info{}}
984
        |> cast(%{}, [:ap_id, :nickname, :local])
985
        |> put_change(:ap_id, relay_uri)
986
987
        |> put_change(:nickname, nil)
        |> put_change(:local, true)
988
        |> put_change(:follower_address, relay_uri <> "/followers")
989
990
991
992
993
994

      {:ok, user} = Repo.insert(changes)
      user
    end
  end

995
  # AP style
lain's avatar
lain committed
996
  def public_key_from_info(%{
lain's avatar
lain committed
997
        source_data: %{"publicKey" => %{"publicKeyPem" => public_key_pem}}
lain's avatar
lain committed
998
999
      }) do
    key =
Maksim's avatar
Maksim committed
1000
      public_key_pem
For faster browsing, not all history is shown. View entire blame