mendevi.database.extract.extract_psnr¶

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

Return the Peak Signal to Noise Ratio (PSNR).

SELECT t_met_metric.met_psnr
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_psnr
FROM t_vid_video
LEFT JOIN t_met_metric
    ON t_vid_video.vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_psnr
FROM t_enc_encode
LEFT JOIN t_met_metric
    ON t_enc_encode.enc_dst_vid_id = t_met_metric.met_dis_vid_id AND t_enc_encode.enc_src_vid_id = t_met_metric.met_ref_vid_id

or, alternativaly

SELECT t_met_metric.met_psnr
FROM t_dec_decode
LEFT JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

Parameters¶

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