mendevi.database.extract.extract_reference_video_stem¶

mendevi.database.extract.extract_reference_video_stem(raw: dict[str]) → str[source]¶

Return the input video compact stem.

SELECT t_ref_video.vid_name AS ref_vid_name
FROM t_vid_video
JOIN t_vid_video AS t_ref_video
    ON t_vid_video.vid_id = t_ref_video.vid_id

or, alternativaly

SELECT t_ref_video.vid_name AS ref_vid_name
FROM t_met_metric
JOIN t_vid_video AS t_ref_video
    ON t_met_metric.met_ref_vid_id = t_ref_video.vid_id

or, alternativaly

SELECT 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

or, alternativaly

SELECT t_ref_video.vid_name AS ref_vid_name
FROM t_dec_decode
JOIN (
    SELECT t_enc_encode.enc_dst_vid_id, MIN(enc_id) AS enc_id_min
    FROM t_enc_encode
    GROUP BY enc_dst_vid_id
) AS t_enc_encode_single_dst_vid_id_from_dec
    ON t_dec_decode.dec_vid_id = t_enc_encode_single_dst_vid_id_from_dec.enc_dst_vid_id
JOIN t_enc_encode AS t_enc_from_dec
    ON t_enc_from_dec.enc_id = t_enc_encode_single_dst_vid_id_from_dec.enc_id_min
JOIN t_vid_video AS t_ref_video
    ON t_enc_from_dec.enc_src_vid_id = t_ref_video.vid_id

Parameters¶

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