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_effort(raw)	Return the effort provided as a parameter to the encoder.
extract_enc_scenario(raw)	Return the unique string specific to the encoding scenario.
extract_encoder(raw)	Return the name of the encoder.
extract_frames(raw)	Return the metadata of each frame.
extract_height(raw)	Return the height of images in pixels.
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_ssim(raw)	Return the Structural Similarity (SSIM).
extract_ssim_comp(raw)	Return the complementary of Structural Similarity (1-SSIM).
extract_threads(raw)	Return the number of threads provided as a parameter to the encoder.
extract_video_duration(raw)	Return the video duration in seconds.
extract_video_name(raw)	Return the input video name.
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_dec_decode
JOIN t_act_activity
    ON t_dec_decode.dec_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

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_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_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

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_dec_decode
JOIN t_act_activity
    ON t_dec_decode.dec_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

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_dec_decode
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.

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

Return the unique string specific to the encoding scenario.

SELECT t_enc_encode.enc_cmd, t_enc_encode.enc_vid_id, 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_enc_encode.enc_cmd, t_enc_encode.enc_vid_id, 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
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.

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_dec_decode
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.

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_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_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_met_metric
JOIN t_vid_video
    ON t_met_metric.met_dis_vid_id = t_vid_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_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_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

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_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_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
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_vid_video
JOIN t_met_metric
    ON t_vid_video.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_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_lpips_alex
FROM t_enc_encode
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_vid_video
JOIN t_met_metric
    ON t_vid_video.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_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_lpips_vgg
FROM t_enc_encode
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_vid_video
JOIN t_met_metric
    ON t_vid_video.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_vbr
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_vbr
FROM t_dec_decode
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.

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_dec_decode
JOIN t_act_activity
    ON t_dec_decode.dec_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

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_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_psnr
FROM t_enc_encode
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_vid_video
JOIN t_met_metric
    ON t_vid_video.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_dec_decode
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.

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_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_ssim
FROM t_enc_encode
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_vid_video
JOIN t_met_metric
    ON t_vid_video.vid_id = t_met_metric.met_dis_vid_id

Parameters

rawdict[str]

The result line of select request.

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

Return the complementary of Structural Similarity (1-SSIM).

SELECT t_met_metric.met_ssim
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_ssim
FROM t_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_ssim
FROM t_enc_encode
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_vid_video
JOIN t_met_metric
    ON t_vid_video.vid_id = t_met_metric.met_dis_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_dec_decode
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.

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

Return the video duration in seconds.

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

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

Parameters

rawdict[str]

The result line of select request.

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

Return the input video name.

SELECT t_ref_video.vid_name AS ref_vid_name
FROM t_dec_decode
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

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

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_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_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

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_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_vmaf
FROM t_enc_encode
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_vid_video
JOIN t_met_metric
    ON t_vid_video.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_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_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

Parameters

rawdict[str]

The result line of select request.

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

Perform few verifications.