use Ecto.Schema
import Ecto.Changeset
- import Ecto.Query
- alias Pleroma.Object
alias Pleroma.Repo
alias Pleroma.User
It is a helper only, to make it easy to display a list of chats with other people, ordered by last bump. The actual messages are retrieved by querying the recipients of the ChatMessages.
"""
+ @primary_key {:id, FlakeId.Ecto.CompatType, autogenerate: true}
+
schema "chats" do
belongs_to(:user, User, type: FlakeId.Ecto.CompatType)
field(:recipient, :string)
- field(:unread, :integer, default: 0, read_after_writes: true)
timestamps()
end
- def last_message_for_chat(chat) do
- messages_for_chat_query(chat)
- |> order_by(desc: :id)
- |> Repo.one()
- end
-
- def messages_for_chat_query(chat) do
- chat =
- chat
- |> Repo.preload(:user)
-
- from(o in Object,
- where: fragment("?->>'type' = ?", o.data, "ChatMessage"),
- where:
- fragment(
- """
- (?->>'actor' = ? and ?->'to' = ?)
- OR (?->>'actor' = ? and ?->'to' = ?)
- """,
- o.data,
- ^chat.user.ap_id,
- o.data,
- ^[chat.recipient],
- o.data,
- ^chat.recipient,
- o.data,
- ^[chat.user.ap_id]
- )
- )
- end
-
- def creation_cng(struct, params) do
+ def changeset(struct, params) do
struct
- |> cast(params, [:user_id, :recipient, :unread])
+ |> cast(params, [:user_id, :recipient])
|> validate_change(:recipient, fn
:recipient, recipient ->
case User.get_cached_by_ap_id(recipient) do
|> unique_constraint(:user_id, name: :chats_user_id_recipient_index)
end
+ def get_by_id(id) do
+ __MODULE__
+ |> Repo.get(id)
+ end
+
def get(user_id, recipient) do
__MODULE__
|> Repo.get_by(user_id: user_id, recipient: recipient)
def get_or_create(user_id, recipient) do
%__MODULE__{}
- |> creation_cng(%{user_id: user_id, recipient: recipient})
+ |> changeset(%{user_id: user_id, recipient: recipient})
|> Repo.insert(
# Need to set something, otherwise we get nothing back at all
on_conflict: [set: [recipient: recipient]],
def bump_or_create(user_id, recipient) do
%__MODULE__{}
- |> creation_cng(%{user_id: user_id, recipient: recipient, unread: 1})
+ |> changeset(%{user_id: user_id, recipient: recipient})
|> Repo.insert(
- on_conflict: [set: [updated_at: NaiveDateTime.utc_now()], inc: [unread: 1]],
+ on_conflict: [set: [updated_at: NaiveDateTime.utc_now()]],
+ returning: true,
conflict_target: [:user_id, :recipient]
)
end
-
- def mark_as_read(chat) do
- chat
- |> change(%{unread: 0})
- |> Repo.update()
- end
end