mendevi.database.extract.extract_encode_cmd

mendevi.database.extract.extract_encode_cmd(raw: dict[str]) → str[source]

Return the ffmpeg command used for encoding.

SELECT
    t_dst_video.vid_name AS dst_vid_name,
    t_enc_encode.enc_cmd,
    t_ref_video.vid_name AS ref_vid_name
FROM t_enc_encode
JOIN t_vid_video AS t_ref_video
    ON t_enc_encode.enc_src_vid_id = t_ref_video.vid_id
JOIN t_vid_video AS t_dst_video
    ON t_enc_encode.enc_dst_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT
    t_dst_video.vid_name AS dst_vid_name,
    t_enc_encode.enc_cmd,
    t_ref_video.vid_name AS ref_vid_name
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id
JOIN t_enc_encode AS t_enc_from_dec
    ON t_dec_decode.dec_vid_id = t_enc_from_dec.enc_dst_vid_id JOIN t_vid_video AS t_ref_video
    ON t_enc_from_dec.enc_src_vid_id = t_ref_video.vid_id
JOIN t_enc_encode
    ON t_dec_decode.dec_vid_id = t_enc_encode.enc_dst_vid_id

Parameters

rawdict[str]: The result line of select request.