+ with %User{} = user <- get_by_nickname(nickname) do
+ user
+ else
+ _e ->
+ with [_nick, _domain] <- String.split(nickname, "@"),
+ {:ok, user} <- fetch_by_nickname(nickname) do
+ user
+ else
+ _e -> nil
+ end
+ end
+ end
+
+ def get_followers_query(%User{id: id, follower_address: follower_address}) do
+ from(
+ u in User,
+ where: fragment("? <@ ?", ^[follower_address], u.following),
+ where: u.id != ^id
+ )
+ end
+
+ def get_followers(user) do
+ q = get_followers_query(user)
+
+ {:ok, Repo.all(q)}
+ end
+
+ def get_friends_query(%User{id: id, following: following}) do
+ from(
+ u in User,
+ where: u.follower_address in ^following,
+ where: u.id != ^id
+ )
+ end
+
+ def get_friends(user) do
+ q = get_friends_query(user)
+
+ {:ok, Repo.all(q)}
+ end
+
+ def increase_note_count(%User{} = user) do
+ note_count = (user.info["note_count"] || 0) + 1
+ new_info = Map.put(user.info, "note_count", note_count)
+
+ cs = info_changeset(user, %{info: new_info})
+
+ update_and_set_cache(cs)
+ end
+
+ def decrease_note_count(%User{} = user) do
+ note_count = user.info["note_count"] || 0
+ note_count = if note_count <= 0, do: 0, else: note_count - 1
+ new_info = Map.put(user.info, "note_count", note_count)
+
+ cs = info_changeset(user, %{info: new_info})
+
+ update_and_set_cache(cs)
+ end
+
+ def update_note_count(%User{} = user) do
+ note_count_query =
+ from(
+ a in Object,
+ where: fragment("?->>'actor' = ? and ?->>'type' = 'Note'", a.data, ^user.ap_id, a.data),
+ select: count(a.id)
+ )
+
+ note_count = Repo.one(note_count_query)
+
+ new_info = Map.put(user.info, "note_count", note_count)
+
+ cs = info_changeset(user, %{info: new_info})
+
+ update_and_set_cache(cs)
+ end
+
+ def update_follower_count(%User{} = user) do
+ follower_count_query =
+ from(
+ u in User,
+ where: ^user.follower_address in u.following,
+ where: u.id != ^user.id,
+ select: count(u.id)
+ )
+
+ follower_count = Repo.one(follower_count_query)
+
+ new_info = Map.put(user.info, "follower_count", follower_count)
+
+ cs = info_changeset(user, %{info: new_info})
+
+ update_and_set_cache(cs)
+ end
+
+ def get_notified_from_activity(%Activity{recipients: to}) do
+ query =
+ from(
+ u in User,
+ where: u.ap_id in ^to,
+ where: u.local == true
+ )
+
+ Repo.all(query)
+ end
+
+ def get_recipients_from_activity(%Activity{recipients: to}) do
+ query =
+ from(
+ u in User,
+ where: u.ap_id in ^to,
+ or_where: fragment("? && ?", u.following, ^to)
+ )
+
+ query = from(u in query, where: u.local == true)
+
+ Repo.all(query)
+ end
+
+ def search(query, resolve) do
+ # strip the beginning @ off if there is a query
+ query = String.trim_leading(query, "@")
+
+ if resolve do
+ User.get_or_fetch_by_nickname(query)
+ end
+
+ q =
+ from(
+ u in User,
+ where:
+ fragment(
+ "(to_tsvector('english', ?) || to_tsvector('english', ?)) @@ plainto_tsquery('english', ?)",
+ u.nickname,
+ u.name,
+ ^query
+ ),
+ limit: 20
+ )
+
+ Repo.all(q)
+ end
+
+ def block(user, %{ap_id: ap_id}) do
+ blocks = user.info["blocks"] || []
+ new_blocks = Enum.uniq([ap_id | blocks])
+ new_info = Map.put(user.info, "blocks", new_blocks)
+
+ cs = User.info_changeset(user, %{info: new_info})
+ update_and_set_cache(cs)
+ end
+
+ def unblock(user, %{ap_id: ap_id}) do
+ blocks = user.info["blocks"] || []
+ new_blocks = List.delete(blocks, ap_id)
+ new_info = Map.put(user.info, "blocks", new_blocks)
+
+ cs = User.info_changeset(user, %{info: new_info})
+ update_and_set_cache(cs)
+ end
+
+ def blocks?(user, %{ap_id: ap_id}) do
+ blocks = user.info["blocks"] || []
+ Enum.member?(blocks, ap_id)
+ end
+
+ def local_user_query() do
+ from(u in User, where: u.local == true)
+ end
+
+ def deactivate(%User{} = user) do
+ new_info = Map.put(user.info, "deactivated", true)
+ cs = User.info_changeset(user, %{info: new_info})
+ update_and_set_cache(cs)
+ end
+
+ def delete(%User{} = user) do
+ {:ok, user} = User.deactivate(user)
+
+ # Remove all relationships
+ {:ok, followers} = User.get_followers(user)
+
+ followers
+ |> Enum.each(fn follower -> User.unfollow(follower, user) end)
+
+ {:ok, friends} = User.get_friends(user)
+
+ friends
+ |> Enum.each(fn followed -> User.unfollow(user, followed) end)
+
+ query = from(a in Activity, where: a.actor == ^user.ap_id)
+
+ Repo.all(query)
+ |> Enum.each(fn activity ->
+ case activity.data["type"] do
+ "Create" ->
+ ActivityPub.delete(Object.get_by_ap_id(activity.data["object"]["id"]))
+
+ # TODO: Do something with likes, follows, repeats.
+ _ ->
+ "Doing nothing"
+ end
+ end)
+
+ :ok
+ end
+
+ def get_or_fetch_by_ap_id(ap_id) do
+ if user = get_by_ap_id(ap_id) do