Introduce sql command

[github/Chocobozzz/PeerTube.git] / server / tests / api / videos / video-channels.ts

/* eslint-disable @typescript-eslint/no-unused-expressions,@typescript-eslint/require-await */

import 'mocha'
import * as chai from 'chai'
import { basename } from 'path'
import { ACTOR_IMAGES_SIZE } from '@server/initializers/constants'
import {
  cleanupTests,
  createUser,
  doubleFollow,
  flushAndRunMultipleServers,
  getVideo,
  getVideoChannelVideos,
  setDefaultVideoChannel,
  testFileExistsOrNot,
  testImage,
  updateVideo,
  uploadVideo,
  userLogin,
  wait
} from '../../../../shared/extra-utils'
import { getMyUserInformation, ServerInfo, setAccessTokensToServers, viewVideo } from '../../../../shared/extra-utils/index'
import { waitJobs } from '../../../../shared/extra-utils/server/jobs'
import { User, Video, VideoChannel, VideoDetails } from '../../../../shared/index'

const expect = chai.expect

async function findChannel (server: ServerInfo, channelId: number) {
  const body = await server.channelsCommand.list({ sort: '-name' })

  return body.data.find(c => c.id === channelId)
}

describe('Test video channels', function () {
  let servers: ServerInfo[]
  let userInfo: User
  let secondVideoChannelId: number
  let totoChannel: number
  let videoUUID: string
  let accountName: string

  const avatarPaths: { [ port: number ]: string } = {}
  const bannerPaths: { [ port: number ]: string } = {}

  before(async function () {
    this.timeout(60000)

    servers = await flushAndRunMultipleServers(2)

    await setAccessTokensToServers(servers)
    await setDefaultVideoChannel(servers)

    await doubleFollow(servers[0], servers[1])
  })

  it('Should have one video channel (created with root)', async () => {
    const body = await servers[0].channelsCommand.list({ start: 0, count: 2 })

    expect(body.total).to.equal(1)
    expect(body.data).to.be.an('array')
    expect(body.data).to.have.lengthOf(1)
  })

  it('Should create another video channel', async function () {
    this.timeout(10000)

    {
      const videoChannel = {
        name: 'second_video_channel',
        displayName: 'second video channel',
        description: 'super video channel description',
        support: 'super video channel support text'
      }
      const created = await servers[0].channelsCommand.create({ attributes: videoChannel })
      secondVideoChannelId = created.id
    }

    // The channel is 1 is propagated to servers 2
    {
      const videoAttributesArg = { name: 'my video name', channelId: secondVideoChannelId, support: 'video support field' }
      const res = await uploadVideo(servers[0].url, servers[0].accessToken, videoAttributesArg)
      videoUUID = res.body.video.uuid
    }

    await waitJobs(servers)
  })

  it('Should have two video channels when getting my information', async () => {
    const res = await getMyUserInformation(servers[0].url, servers[0].accessToken)
    userInfo = res.body

    expect(userInfo.videoChannels).to.be.an('array')
    expect(userInfo.videoChannels).to.have.lengthOf(2)

    const videoChannels = userInfo.videoChannels
    expect(videoChannels[0].name).to.equal('root_channel')
    expect(videoChannels[0].displayName).to.equal('Main root channel')

    expect(videoChannels[1].name).to.equal('second_video_channel')
    expect(videoChannels[1].displayName).to.equal('second video channel')
    expect(videoChannels[1].description).to.equal('super video channel description')
    expect(videoChannels[1].support).to.equal('super video channel support text')

    accountName = userInfo.account.name + '@' + userInfo.account.host
  })

  it('Should have two video channels when getting account channels on server 1', async function () {
    const body = await servers[0].channelsCommand.listByAccount({ accountName })
    expect(body.total).to.equal(2)

    const videoChannels = body.data

    expect(videoChannels).to.be.an('array')
    expect(videoChannels).to.have.lengthOf(2)

    expect(videoChannels[0].name).to.equal('root_channel')
    expect(videoChannels[0].displayName).to.equal('Main root channel')

    expect(videoChannels[1].name).to.equal('second_video_channel')
    expect(videoChannels[1].displayName).to.equal('second video channel')
    expect(videoChannels[1].description).to.equal('super video channel description')
    expect(videoChannels[1].support).to.equal('super video channel support text')
  })

  it('Should paginate and sort account channels', async function () {
    {
      const body = await servers[0].channelsCommand.listByAccount({
        accountName,
        start: 0,
        count: 1,
        sort: 'createdAt'
      })

      expect(body.total).to.equal(2)
      expect(body.data).to.have.lengthOf(1)

      const videoChannel: VideoChannel = body.data[0]
      expect(videoChannel.name).to.equal('root_channel')
    }

    {
      const body = await servers[0].channelsCommand.listByAccount({
        accountName,
        start: 0,
        count: 1,
        sort: '-createdAt'
      })

      expect(body.total).to.equal(2)
      expect(body.data).to.have.lengthOf(1)
      expect(body.data[0].name).to.equal('second_video_channel')
    }

    {
      const body = await servers[0].channelsCommand.listByAccount({
        accountName,
        start: 1,
        count: 1,
        sort: '-createdAt'
      })

      expect(body.total).to.equal(2)
      expect(body.data).to.have.lengthOf(1)
      expect(body.data[0].name).to.equal('root_channel')
    }
  })

  it('Should have one video channel when getting account channels on server 2', async function () {
    const body = await servers[1].channelsCommand.listByAccount({ accountName })

    expect(body.total).to.equal(1)
    expect(body.data).to.be.an('array')
    expect(body.data).to.have.lengthOf(1)

    const videoChannel = body.data[0]
    expect(videoChannel.name).to.equal('second_video_channel')
    expect(videoChannel.displayName).to.equal('second video channel')
    expect(videoChannel.description).to.equal('super video channel description')
    expect(videoChannel.support).to.equal('super video channel support text')
  })

  it('Should list video channels', async function () {
    const body = await servers[0].channelsCommand.list({ start: 1, count: 1, sort: '-name' })

    expect(body.total).to.equal(2)
    expect(body.data).to.be.an('array')
    expect(body.data).to.have.lengthOf(1)
    expect(body.data[0].name).to.equal('root_channel')
    expect(body.data[0].displayName).to.equal('Main root channel')
  })

  it('Should update video channel', async function () {
    this.timeout(15000)

    const videoChannelAttributes = {
      displayName: 'video channel updated',
      description: 'video channel description updated',
      support: 'support updated'
    }

    await servers[0].channelsCommand.update({ channelName: 'second_video_channel', attributes: videoChannelAttributes })

    await waitJobs(servers)
  })

  it('Should have video channel updated', async function () {
    for (const server of servers) {
      const body = await server.channelsCommand.list({ start: 0, count: 1, sort: '-name' })

      expect(body.total).to.equal(2)
      expect(body.data).to.be.an('array')
      expect(body.data).to.have.lengthOf(1)

      expect(body.data[0].name).to.equal('second_video_channel')
      expect(body.data[0].displayName).to.equal('video channel updated')
      expect(body.data[0].description).to.equal('video channel description updated')
      expect(body.data[0].support).to.equal('support updated')
    }
  })

  it('Should not have updated the video support field', async function () {
    for (const server of servers) {
      const res = await getVideo(server.url, videoUUID)
      const video: VideoDetails = res.body

      expect(video.support).to.equal('video support field')
    }
  })

  it('Should update the channel support field and update videos too', async function () {
    this.timeout(35000)

    const videoChannelAttributes = {
      support: 'video channel support text updated',
      bulkVideosSupportUpdate: true
    }

    await servers[0].channelsCommand.update({ channelName: 'second_video_channel', attributes: videoChannelAttributes })

    await waitJobs(servers)

    for (const server of servers) {
      const res = await getVideo(server.url, videoUUID)
      const video: VideoDetails = res.body

      expect(video.support).to.equal(videoChannelAttributes.support)
    }
  })

  it('Should update video channel avatar', async function () {
    this.timeout(15000)

    const fixture = 'avatar.png'

    await servers[0].channelsCommand.updateImage({
      channelName: 'second_video_channel',
      fixture,
      type: 'avatar'
    })

    await waitJobs(servers)

    for (const server of servers) {
      const videoChannel = await findChannel(server, secondVideoChannelId)

      avatarPaths[server.port] = videoChannel.avatar.path
      await testImage(server.url, 'avatar-resized', avatarPaths[server.port], '.png')
      await testFileExistsOrNot(server, 'avatars', basename(avatarPaths[server.port]), true)

      const row = await server.sqlCommand.getActorImage(basename(avatarPaths[server.port]))
      expect(row.height).to.equal(ACTOR_IMAGES_SIZE.AVATARS.height)
      expect(row.width).to.equal(ACTOR_IMAGES_SIZE.AVATARS.width)
    }
  })

  it('Should update video channel banner', async function () {
    this.timeout(15000)

    const fixture = 'banner.jpg'

    await servers[0].channelsCommand.updateImage({
      channelName: 'second_video_channel',
      fixture,
      type: 'banner'
    })

    await waitJobs(servers)

    for (const server of servers) {
      const videoChannel = await server.channelsCommand.get({ channelName: 'second_video_channel@' + servers[0].host })

      bannerPaths[server.port] = videoChannel.banner.path
      await testImage(server.url, 'banner-resized', bannerPaths[server.port])
      await testFileExistsOrNot(server, 'avatars', basename(bannerPaths[server.port]), true)

      const row = await server.sqlCommand.getActorImage(basename(bannerPaths[server.port]))
      expect(row.height).to.equal(ACTOR_IMAGES_SIZE.BANNERS.height)
      expect(row.width).to.equal(ACTOR_IMAGES_SIZE.BANNERS.width)
    }
  })

  it('Should delete the video channel avatar', async function () {
    this.timeout(15000)

    await servers[0].channelsCommand.deleteImage({ channelName: 'second_video_channel', type: 'avatar' })

    await waitJobs(servers)

    for (const server of servers) {
      const videoChannel = await findChannel(server, secondVideoChannelId)
      await testFileExistsOrNot(server, 'avatars', basename(avatarPaths[server.port]), false)

      expect(videoChannel.avatar).to.be.null
    }
  })

  it('Should delete the video channel banner', async function () {
    this.timeout(15000)

    await servers[0].channelsCommand.deleteImage({ channelName: 'second_video_channel', type: 'banner' })

    await waitJobs(servers)

    for (const server of servers) {
      const videoChannel = await findChannel(server, secondVideoChannelId)
      await testFileExistsOrNot(server, 'avatars', basename(bannerPaths[server.port]), false)

      expect(videoChannel.banner).to.be.null
    }
  })

  it('Should list the second video channel videos', async function () {
    this.timeout(10000)

    for (const server of servers) {
      const channelURI = 'second_video_channel@localhost:' + servers[0].port
      const res1 = await getVideoChannelVideos(server.url, server.accessToken, channelURI, 0, 5)
      expect(res1.body.total).to.equal(1)
      expect(res1.body.data).to.be.an('array')
      expect(res1.body.data).to.have.lengthOf(1)
      expect(res1.body.data[0].name).to.equal('my video name')
    }
  })

  it('Should change the video channel of a video', async function () {
    this.timeout(10000)

    await updateVideo(servers[0].url, servers[0].accessToken, videoUUID, { channelId: servers[0].videoChannel.id })

    await waitJobs(servers)
  })

  it('Should list the first video channel videos', async function () {
    this.timeout(10000)

    for (const server of servers) {
      const secondChannelURI = 'second_video_channel@localhost:' + servers[0].port
      const res1 = await getVideoChannelVideos(server.url, server.accessToken, secondChannelURI, 0, 5)
      expect(res1.body.total).to.equal(0)

      const channelURI = 'root_channel@localhost:' + servers[0].port
      const res2 = await getVideoChannelVideos(server.url, server.accessToken, channelURI, 0, 5)
      expect(res2.body.total).to.equal(1)

      const videos: Video[] = res2.body.data
      expect(videos).to.be.an('array')
      expect(videos).to.have.lengthOf(1)
      expect(videos[0].name).to.equal('my video name')
    }
  })

  it('Should delete video channel', async function () {
    await servers[0].channelsCommand.delete({ channelName: 'second_video_channel' })
  })

  it('Should have video channel deleted', async function () {
    const body = await servers[0].channelsCommand.list({ start: 0, count: 10 })

    expect(body.total).to.equal(1)
    expect(body.data).to.be.an('array')
    expect(body.data).to.have.lengthOf(1)
    expect(body.data[0].displayName).to.equal('Main root channel')
  })

  it('Should create the main channel with an uuid if there is a conflict', async function () {
    {
      const videoChannel = { name: 'toto_channel', displayName: 'My toto channel' }
      const created = await servers[0].channelsCommand.create({ attributes: videoChannel })
      totoChannel = created.id
    }

    {
      await createUser({ url: servers[0].url, accessToken: servers[0].accessToken, username: 'toto', password: 'password' })
      const accessToken = await userLogin(servers[0], { username: 'toto', password: 'password' })

      const res = await getMyUserInformation(servers[0].url, accessToken)
      const videoChannel = res.body.videoChannels[0]
      expect(videoChannel.name).to.match(/[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}/)
    }
  })

  it('Should report correct channel views per days', async function () {
    this.timeout(10000)

    {
      const { data } = await servers[0].channelsCommand.listByAccount({ accountName, withStats: true })

      for (const channel of data) {
        expect(channel).to.haveOwnProperty('viewsPerDay')
        expect(channel.viewsPerDay).to.have.length(30 + 1) // daysPrior + today

        for (const v of channel.viewsPerDay) {
          expect(v.date).to.be.an('string')
          expect(v.views).to.equal(0)
        }
      }
    }

    {
      // video has been posted on channel servers[0].videoChannel.id since last update
      await viewVideo(servers[0].url, videoUUID, 204, '0.0.0.1,127.0.0.1')
      await viewVideo(servers[0].url, videoUUID, 204, '0.0.0.2,127.0.0.1')

      // Wait the repeatable job
      await wait(8000)

      const { data } = await servers[0].channelsCommand.listByAccount({ accountName, withStats: true })
      const channelWithView = data.find(channel => channel.id === servers[0].videoChannel.id)
      expect(channelWithView.viewsPerDay.slice(-1)[0].views).to.equal(2)
    }
  })

  it('Should report correct videos count', async function () {
    const { data } = await servers[0].channelsCommand.listByAccount({ accountName, withStats: true })

    const totoChannel = data.find(c => c.name === 'toto_channel')
    const rootChannel = data.find(c => c.name === 'root_channel')

    expect(rootChannel.videosCount).to.equal(1)
    expect(totoChannel.videosCount).to.equal(0)
  })

  it('Should search among account video channels', async function () {
    {
      const body = await servers[0].channelsCommand.listByAccount({ accountName, search: 'root' })
      expect(body.total).to.equal(1)

      const channels = body.data
      expect(channels).to.have.lengthOf(1)
    }

    {
      const body = await servers[0].channelsCommand.listByAccount({ accountName, search: 'does not exist' })
      expect(body.total).to.equal(0)

      const channels = body.data
      expect(channels).to.have.lengthOf(0)
    }
  })

  it('Should list channels by updatedAt desc if a video has been uploaded', async function () {
    this.timeout(30000)

    await uploadVideo(servers[0].url, servers[0].accessToken, { channelId: totoChannel })
    await waitJobs(servers)

    for (const server of servers) {
      const { data } = await server.channelsCommand.listByAccount({ accountName, sort: '-updatedAt' })

      expect(data[0].name).to.equal('toto_channel')
      expect(data[1].name).to.equal('root_channel')
    }

    await uploadVideo(servers[0].url, servers[0].accessToken, { channelId: servers[0].videoChannel.id })
    await waitJobs(servers)

    for (const server of servers) {
      const { data } = await server.channelsCommand.listByAccount({ accountName, sort: '-updatedAt' })

      expect(data[0].name).to.equal('root_channel')
      expect(data[1].name).to.equal('toto_channel')
    }
  })

  after(async function () {
    await cleanupTests(servers)
  })
})