mendevi.database.extract.extract_energy

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

Return the total energy consumption in Joules.

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.