robottokauf3 / meilisearch-elixir Goto Github PK

config :meilisearch,
  api_key: System.get_env("MEILI_MASTER_KEY")

      # chan_uuid: c.id,
      # chan_readable_id: c.readable_id,
      # chan_name: c.name,
      # chan_description: c.description,

CREATE VIEW media_items_joined AS
SELECT items.id,
	items.title,
	items.artist,
	items.presenter_name,
	items.presented_at,
	items.published_at,
	items.updated_at,
	items.localizedname,
	items.language_id,
	items.source_material,
	items.description,
	items.media_category,
	items.media_format,
	items.tags,
	items.filepath,
	items.cdn_path,
	items.readable_id,
	items.duration,
	items.size_bytes,
	items.width,
	items.height,
	items.view_count,
	items.like_count,
	items.dislike_count,
	plist.id AS playlist_uuid,
	plist.readable_id AS playlist_readable_id,
	plist.name AS playlist_basename,
	chan.id AS channel_uuid,
	chan.readable_id AS channel_readable_id,
	chan.name AS channel_basename,
	org.id AS org_uuid,
	org.readable_id AS org_readable_id,
	org.basename AS org_basename,
	org.shortname AS org_shortname
FROM mediaitems AS items
LEFT JOIN playlists AS plist ON items.playlist_id = plist.id
LEFT JOIN channels AS chan ON plist.channel_id = chan.id
LEFT JOIN orgs AS org ON chan.org_id = org.id;

alias FaithfulWord.Repo
alias FaithfulWord.Schema.{MediaItem, Playlist, Org}
alias FaithfulWord.Channels.Channel

import Ecto.Query
import Meilisearch.Indexes
import Meilisearch.Documents

Meilisearch.Indexes.delete("mediaitems")
Meilisearch.Indexes.create("mediaitems")

# returns 12296 list items

mediaitems =
  from(mediaitem in MediaItem,
  left_join: p in Playlist,
  on: mediaitem.playlist_id == p.id,
  left_join: c in Channel,
  on: p.channel_id == c.id,
  left_join: o in Org,
  on: mediaitem.org_id == o.id,
    select: %{
      id: mediaitem.id,
      readable_id: mediaitem.readable_id,
      title: mediaitem.title,
      description: mediaitem.description,
      comment: mediaitem.comment,
      tags: mediaitem.tags,
      artist: mediaitem.artist,
      media_format: mediaitem.media_format,
      media_category: mediaitem.media_category,
      source_material: mediaitem.source_material,
      presented_at: mediaitem.presented_at,
      presenter_name: mediaitem.presenter_name,
      duration: mediaitem.duration,
      size_bytes: mediaitem.size_bytes,
      cdn_path: mediaitem.cdn_path,
      view_count: mediaitem.view_count,
      like_count: mediaitem.like_count,
      dislike_count: mediaitem.dislike_count,
      playlist_uuid: p.id,
      playlist_readable_id: p.readable_id,
      playlist_name: p.name,
      playlist_description: p.description,
      # chan_uuid: c.id,
      # chan_readable_id: c.readable_id,
      # chan_name: c.name,
      # chan_description: c.description,
      org_uuid: o.id,
      org_readable_id: o.readable_id,
      org_shortname: o.shortname,
      org_basename: o.basename
    })
  |> Repo.all()

  Meilisearch.Documents.add_or_replace("mediaitems", mediaitems)