mendevi.database.extract.extract_temp

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

Return the average temperature in C.

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.