mendevi.database.extract.extract_power

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

Return the average power consumption in Watts.

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.