mendevi.database.extract

Define the functions that enable values to be extracted from a select query.

Classes

SqlLinker(*select)

Allow you to add an SQL query to an extractor.

Functions

extract_act_duration(raw)	Return the video processing activity duration in seconds.
extract_codec(raw)	Return the codec name.
extract_cores(raw)	Return the average cumulative utilisation rate of logical cores.
extract_decode_cmd(raw)	Return the ffmpeg command used for decoding.
extract_decoder(raw)	Return name of the decoder.
extract_effort(raw)	Return the effort provided as a parameter to the encoder.
extract_encode_cmd(raw)	Return the ffmpeg command used for encoding.
extract_encoder(raw)	Return the name of the encoder.
extract_frames(raw)	Return the metadata of each frame.
extract_gamut(raw)	Return the tristimulus primaries colors name.
extract_height(raw)	Return the height of images in pixels.
extract_hostname(raw)	Return the machine name.
extract_lpips(raw)	Return the Learned Perceptual Image Patch Similarity (LPIPS) with alex.
extract_lpips_alex(raw)	Return the Learned Perceptual Image Patch Similarity (LPIPS) with alex.
extract_lpips_vgg(raw)	Return the Learned Perceptual Image Patch Similarity (LPIPS) with vgg.
extract_mode(raw)	Return the bitrate mode, constant (cbr) or variable (vbr).
extract_powers(raw)	Return the interval duration and the average power in each intervals.
extract_psnr(raw)	Return the Peak Signal to Noise Ratio (PSNR).
extract_quality(raw)	Return the quality level passed to the encoder.
extract_range(raw)	Return the video encoding color range, 'tv' or 'pc'.
extract_reference_video_stem(raw)	Return the input video compact stem.
extract_rms_sobel(raw)	Return the spatial root mean square sobel gradient complexity.
extract_rms_time_diff(raw)	Return the temporal root means square time difference complexity.
extract_spatial_dct(raw)	Return the spatial dct complexity.
extract_ssim(raw)	Return the Structural Similarity (SSIM).
extract_temp(raw)	Return the average temperature in C.
extract_temporal_dct(raw)	Return the temporal dct complexity.
extract_threads(raw)	Return the number of threads provided as a parameter to the encoder.
extract_transfer(raw)	Return the non-linear transfer function name.
extract_video_duration(raw)	Return the video duration in seconds.
extract_video_hash(raw)	Return the hexadecimal md5 video file checksum.
extract_video_name(raw)	Return the full video basename.
extract_video_size(raw)	Return the total video file size in bytes.
extract_vmaf(raw)	Return the Video Multi-Method Assessment Fusion (VMAF).
extract_width(raw)	Return the width of images in pixels.
verif(func)	Perform few verifications.

Details

class mendevi.database.extract.SqlLinker(*select: str)

Allow you to add an SQL query to an extractor.

Initialise the linker.

Parameters

selectargs[str]

The fields to be returned (juste after SELECT), with the optional alias.

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

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.

mendevi.database.extract.extract_codec(raw: dict[str]) → str

Return the codec name.

SELECT t_dst_video.vid_codec
FROM t_vid_video
JOIN t_vid_video AS t_dst_video
    ON t_vid_video.vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_codec
FROM t_met_metric
JOIN t_vid_video AS t_dst_video
    ON t_met_metric.met_dis_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_codec
FROM t_enc_encode
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_codec
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_cores(raw: dict[str]) → float

Return the average cumulative utilisation rate of logical cores.

SELECT t_act_activity.act_ps_core, t_act_activity.act_ps_dt
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_ps_core, t_act_activity.act_ps_dt
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_ps_core, t_act_activity.act_ps_dt
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.

mendevi.database.extract.extract_decode_cmd(raw: dict[str]) → str

Return the ffmpeg command used for decoding.

SELECT t_dec_decode.dec_cmd, t_vid_video.vid_name
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_dec_decode.dec_cmd, t_vid_video.vid_name
FROM t_enc_encode
JOIN t_dec_decode
    ON t_enc_encode.enc_dst_vid_id = t_dec_decode.dec_vid_id
JOIN t_vid_video
    ON t_enc_encode.enc_dst_vid_id = t_vid_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_decoder(raw: dict[str]) → str

Return name of the decoder.

SELECT t_dec_decode.dec_decoder
FROM t_dec_decode

or, alternativaly

SELECT t_dec_decode.dec_decoder
FROM t_enc_encode
JOIN t_dec_decode
    ON t_enc_encode.enc_dst_vid_id = t_dec_decode.dec_vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_effort(raw: dict[str]) → str

Return the effort provided as a parameter to the encoder.

SELECT t_enc_encode.enc_effort
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_effort
FROM t_met_metric
JOIN t_enc_encode
    ON t_act_activity.act_id = t_enc_encode.enc_act_id

or, alternativaly

SELECT t_enc_encode.enc_effort
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
    ON t_dec_decode.dec_vid_id = t_enc_encode_single_dst_vid_id.enc_dst_vid_id
JOIN t_enc_encode
    ON t_enc_encode.enc_id = t_enc_encode_single_dst_vid_id.enc_id_min

Parameters

rawdict[str]

The result line of select request.

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

Return the ffmpeg command used for encoding.

SELECT t_enc_encode.enc_cmd
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_cmd
FROM t_met_metric
JOIN t_enc_encode
    ON t_act_activity.act_id = t_enc_encode.enc_act_id

or, alternativaly

SELECT t_enc_encode.enc_cmd
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
    ON t_dec_decode.dec_vid_id = t_enc_encode_single_dst_vid_id.enc_dst_vid_id
JOIN t_enc_encode
    ON t_enc_encode.enc_id = t_enc_encode_single_dst_vid_id.enc_id_min

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_encoder(raw: dict[str]) → str

Return the name of the encoder.

SELECT t_enc_encode.enc_encoder
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_encoder
FROM t_met_metric
JOIN t_enc_encode
    ON t_act_activity.act_id = t_enc_encode.enc_act_id

or, alternativaly

SELECT t_enc_encode.enc_encoder
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
    ON t_dec_decode.dec_vid_id = t_enc_encode_single_dst_vid_id.enc_dst_vid_id
JOIN t_enc_encode
    ON t_enc_encode.enc_id = t_enc_encode_single_dst_vid_id.enc_id_min

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_frames(raw: dict[str]) → list[dict]

Return the metadata of each frame.

SELECT t_vid_video.vid_frames
FROM t_vid_video

or, alternativaly

SELECT t_vid_video.vid_frames
FROM t_met_metric
JOIN t_vid_video
    ON t_met_metric.met_dis_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_frames
FROM t_enc_encode
JOIN t_vid_video
    ON t_enc_encode.enc_dst_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_frames
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_gamut(raw: dict[str]) → str

Return the tristimulus primaries colors name.

SELECT t_dst_video.vid_gamut
FROM t_vid_video
JOIN t_vid_video AS t_dst_video
    ON t_vid_video.vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_gamut
FROM t_met_metric
JOIN t_vid_video AS t_dst_video
    ON t_met_metric.met_dis_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_gamut
FROM t_enc_encode
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_gamut
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_height(raw: dict[str]) → int

Return the height of images in pixels.

SELECT t_dst_video.vid_height
FROM t_vid_video
JOIN t_vid_video AS t_dst_video
    ON t_vid_video.vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_height
FROM t_met_metric
JOIN t_vid_video AS t_dst_video
    ON t_met_metric.met_dis_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_height
FROM t_enc_encode
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_height
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_hostname(raw: dict[str]) → str

Return the machine name.

SELECT t_env_environment.env_hostname
FROM t_env_environment

or, alternativaly

SELECT t_env_environment.env_hostname
FROM t_enc_encode
JOIN t_env_environment
    ON t_enc_encode.enc_env_id = t_env_environment.env_id

or, alternativaly

SELECT t_env_environment.env_hostname
FROM t_dec_decode
JOIN t_env_environment
    ON t_dec_decode.dec_env_id = t_env_environment.env_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_lpips(raw: dict[str]) → float

Return the Learned Perceptual Image Patch Similarity (LPIPS) with alex.

SELECT t_met_metric.met_lpips_alex, t_met_metric.met_lpips_vgg
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_lpips_alex, t_met_metric.met_lpips_vgg
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_lpips_alex, t_met_metric.met_lpips_vgg
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_lpips_alex, t_met_metric.met_lpips_vgg
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.

mendevi.database.extract.extract_lpips_alex(raw: dict[str]) → float

Return the Learned Perceptual Image Patch Similarity (LPIPS) with alex.

SELECT t_met_metric.met_lpips_alex
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_lpips_alex
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_lpips_alex
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_lpips_alex
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.

mendevi.database.extract.extract_lpips_vgg(raw: dict[str]) → float

Return the Learned Perceptual Image Patch Similarity (LPIPS) with vgg.

SELECT t_met_metric.met_lpips_vgg
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_lpips_vgg
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_lpips_vgg
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_lpips_vgg
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.

mendevi.database.extract.extract_mode(raw: dict[str]) → str

Return the bitrate mode, constant (cbr) or variable (vbr).

SELECT t_enc_encode.enc_mode
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_mode
FROM t_met_metric
JOIN t_enc_encode
    ON t_act_activity.act_id = t_enc_encode.enc_act_id

or, alternativaly

SELECT t_enc_encode.enc_mode
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
    ON t_dec_decode.dec_vid_id = t_enc_encode_single_dst_vid_id.enc_dst_vid_id
JOIN t_enc_encode
    ON t_enc_encode.enc_id = t_enc_encode_single_dst_vid_id.enc_id_min

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_powers(raw: dict[str]) → tuple

Return the interval duration and the average power in each intervals.

SELECT
    t_act_activity.act_rapl_dt,
    t_act_activity.act_rapl_power,
    t_act_activity.act_wattmeter_dt,
    t_act_activity.act_wattmeter_power
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_rapl_dt,
    t_act_activity.act_rapl_power,
    t_act_activity.act_wattmeter_dt,
    t_act_activity.act_wattmeter_power
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_rapl_dt,
    t_act_activity.act_rapl_power,
    t_act_activity.act_wattmeter_dt,
    t_act_activity.act_wattmeter_power
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.

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

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.

mendevi.database.extract.extract_quality(raw: dict[str]) → float

Return the quality level passed to the encoder.

SELECT t_enc_encode.enc_quality
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_quality
FROM t_met_metric
JOIN t_enc_encode
    ON t_act_activity.act_id = t_enc_encode.enc_act_id

or, alternativaly

SELECT t_enc_encode.enc_quality
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
    ON t_dec_decode.dec_vid_id = t_enc_encode_single_dst_vid_id.enc_dst_vid_id
JOIN t_enc_encode
    ON t_enc_encode.enc_id = t_enc_encode_single_dst_vid_id.enc_id_min

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_range(raw: dict[str]) → str

Return the video encoding color range, ‘tv’ or ‘pc’.

SELECT t_dst_video.vid_range
FROM t_vid_video
JOIN t_vid_video AS t_dst_video
    ON t_vid_video.vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_range
FROM t_met_metric
JOIN t_vid_video AS t_dst_video
    ON t_met_metric.met_dis_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_range
FROM t_enc_encode
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_range
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id

Parameters

rawdict[str]

The result line of select request.

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

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.

mendevi.database.extract.extract_rms_sobel(raw: dict[str]) → str

Return the spatial root mean square sobel gradient complexity.

SELECT t_vid_video.vid_rms_sobel
FROM t_vid_video

or, alternativaly

SELECT t_vid_video.vid_rms_sobel
FROM t_met_metric
JOIN t_vid_video
    ON t_met_metric.met_dis_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_rms_sobel
FROM t_enc_encode
JOIN t_vid_video
    ON t_enc_encode.enc_dst_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_rms_sobel
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_rms_time_diff(raw: dict[str]) → str

Return the temporal root means square time difference complexity.

SELECT t_vid_video.vid_rms_time_diff
FROM t_vid_video

or, alternativaly

SELECT t_vid_video.vid_rms_time_diff
FROM t_met_metric
JOIN t_vid_video
    ON t_met_metric.met_dis_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_rms_time_diff
FROM t_enc_encode
JOIN t_vid_video
    ON t_enc_encode.enc_dst_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_rms_time_diff
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_spatial_dct(raw: dict[str]) → str

Return the spatial dct complexity.

SELECT t_vid_video.vid_spatial_dct
FROM t_vid_video

or, alternativaly

SELECT t_vid_video.vid_spatial_dct
FROM t_met_metric
JOIN t_vid_video
    ON t_met_metric.met_dis_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_spatial_dct
FROM t_enc_encode
JOIN t_vid_video
    ON t_enc_encode.enc_dst_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_spatial_dct
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_ssim(raw: dict[str]) → float

Return the Structural Similarity (SSIM).

SELECT t_met_metric.met_ssim
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_ssim
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_ssim
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_ssim
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.

mendevi.database.extract.extract_temp(raw: dict[str]) → float

Return the average temperature in C.

SELECT t_act_activity.act_ps_dt, t_act_activity.act_ps_temp
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_ps_dt, t_act_activity.act_ps_temp
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_ps_dt, t_act_activity.act_ps_temp
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.

mendevi.database.extract.extract_temporal_dct(raw: dict[str]) → str

Return the temporal dct complexity.

SELECT t_vid_video.vid_temporal_dct
FROM t_vid_video

or, alternativaly

SELECT t_vid_video.vid_temporal_dct
FROM t_met_metric
JOIN t_vid_video
    ON t_met_metric.met_dis_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_temporal_dct
FROM t_enc_encode
JOIN t_vid_video
    ON t_enc_encode.enc_dst_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_temporal_dct
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_threads(raw: dict[str]) → int

Return the number of threads provided as a parameter to the encoder.

SELECT t_enc_encode.enc_threads
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_threads
FROM t_met_metric
JOIN t_enc_encode
    ON t_act_activity.act_id = t_enc_encode.enc_act_id

or, alternativaly

SELECT t_enc_encode.enc_threads
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
    ON t_dec_decode.dec_vid_id = t_enc_encode_single_dst_vid_id.enc_dst_vid_id
JOIN t_enc_encode
    ON t_enc_encode.enc_id = t_enc_encode_single_dst_vid_id.enc_id_min

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_transfer(raw: dict[str]) → str

Return the non-linear transfer function name.

SELECT t_dst_video.vid_eotf
FROM t_vid_video
JOIN t_vid_video AS t_dst_video
    ON t_vid_video.vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_eotf
FROM t_met_metric
JOIN t_vid_video AS t_dst_video
    ON t_met_metric.met_dis_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_eotf
FROM t_enc_encode
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_eotf
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_video_duration(raw: dict[str]) → float

Return the video duration in seconds.

SELECT t_dst_video.vid_duration
FROM t_vid_video
JOIN t_vid_video AS t_dst_video
    ON t_vid_video.vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_duration
FROM t_met_metric
JOIN t_vid_video AS t_dst_video
    ON t_met_metric.met_dis_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_duration
FROM t_enc_encode
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_duration
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_video_hash(raw: dict[str]) → str

Return the hexadecimal md5 video file checksum.

SELECT t_vid_video.vid_id
FROM t_vid_video

or, alternativaly

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

or, alternativaly

SELECT t_vid_video.vid_id
FROM t_enc_encode
JOIN t_vid_video
    ON t_enc_encode.enc_dst_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_id
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_video_name(raw: dict[str]) → str

Return the full video basename.

SELECT t_vid_video.vid_name
FROM t_vid_video

or, alternativaly

SELECT t_vid_video.vid_name
FROM t_met_metric
JOIN t_vid_video
    ON t_met_metric.met_dis_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_name
FROM t_enc_encode
JOIN t_vid_video
    ON t_enc_encode.enc_dst_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_name
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_video_size(raw: dict[str]) → int

Return the total video file size in bytes.

SELECT t_dst_video.vid_size
FROM t_vid_video
JOIN t_vid_video AS t_dst_video
    ON t_vid_video.vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_size
FROM t_met_metric
JOIN t_vid_video AS t_dst_video
    ON t_met_metric.met_dis_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_size
FROM t_enc_encode
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_size
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.extract_vmaf(raw: dict[str]) → float

Return the Video Multi-Method Assessment Fusion (VMAF).

SELECT t_met_metric.met_vmaf
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_vmaf
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_vmaf
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_vmaf
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.

mendevi.database.extract.extract_width(raw: dict[str]) → int

Return the width of images in pixels.

SELECT t_dst_video.vid_width
FROM t_vid_video
JOIN t_vid_video AS t_dst_video
    ON t_vid_video.vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_width
FROM t_met_metric
JOIN t_vid_video AS t_dst_video
    ON t_met_metric.met_dis_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_width
FROM t_enc_encode
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_width
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id

Parameters

rawdict[str]

The result line of select request.

mendevi.database.extract.verif(func: Callable) → Callable

Perform few verifications.