mendevi.database.extract.extract_powers

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.