package com.ard.sample.media.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ard.sample.media.model.MediaFileEntity;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author sean
 * @version 0.2
 * @date 2021/12/9
 */
public interface IFileMapper extends BaseMapper<MediaFileEntity> {

    @Select("SELECT m.* ,j.name as 'job_name'" +
            "FROM media_file m " +
            "left join wayline_job j on j.job_id = m.job_id " +
            "${ew.customSqlSegment.replace('job_id', 'm.job_id')}")
    <P extends IPage<MediaFileEntity>> P selectPage(P page, @Param("ew") Wrapper<MediaFileEntity> queryWrapper);
}