mendevi.database.extract.extract_act_duration¶

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

Return the video processing activity duration in seconds.

SELECT t_act_activity.act_duration
FROM t_met_metric
JOIN t_vid_video AS t_dis_video
    ON t_met_metric.met_dis_vid_id = t_dis_video.vid_id JOIN t_enc_encode AS t_met_encode
    ON t_dis_video.vid_id = t_met_encode.enc_dst_vid_id JOIN t_act_activity
    ON t_met_encode.enc_act_id = t_act_activity.act_id

or, alternativaly

SELECT t_act_activity.act_duration
FROM t_enc_encode
JOIN t_act_activity
    ON t_enc_encode.enc_act_id = t_act_activity.act_id

or, alternativaly

SELECT t_act_activity.act_duration
FROM t_dec_decode
JOIN t_act_activity
    ON t_dec_decode.dec_act_id = t_act_activity.act_id

Parameters¶

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