1 # Pleroma: A lightweight social networking server
2 # Copyright © 2017-2018 Pleroma Authors <https://pleroma.social/>
3 # SPDX-License-Identifier: AGPL-3.0-only
5 defmodule Mix.Tasks.Pleroma.Activity do
7 alias Pleroma.Activity.Search
9 alias Pleroma.Web.CommonAPI
10 alias Pleroma.Pagination
15 def run(["get", id | _rest]) do
19 |> Activity.get_by_id()
23 def run(["delete_by_keyword", user, keyword | _rest]) do
25 u = User.get_by_nickname(user)
28 |> Activity.with_preloaded_object()
29 |> Activity.restrict_deactivated_users()
30 |> Activity.Queries.by_author(u)
31 |> query_with(keyword)
32 |> Pagination.fetch_paginated(
33 %{"offset" => 0, "limit" => 20, "skip_order" => false},
36 |> Enum.map(fn x -> CommonAPI.delete(x.id, u) end)
41 defp query_with(q, search_query) do
43 Ecto.Adapters.SQL.query!(
45 "select current_setting('default_text_search_config')::regconfig::oid;"
51 "to_tsvector(?::oid::regconfig, ?->>'content') @@ websearch_to_tsquery(?)",