How to calculate the time between records-events in the database?

Question

MySQL

Hello everyone,

help me write a sql query and python code.

There is a mysql database that stores events like 1, 2 (fell asleep, woke up)

id - dt - event
9 - 2020-05-07 00:26:40.000000 - 1
10 - 2020- 05-07 00:30:02.000000 - 2

Help me write a script that will calculate sleep time per day / week / month?

Answer 1

https://stackoverflow.com/questions/18272625/calcu...

Answer 2

If you cannot fall asleep twice in a row without waking up, or, conversely, wake up twice without falling asleep, then window functions will help you. Here , I specifically looked, they are in MySQL.
You need to filter out only alternating falling asleep / waking up from events, the window size should cover two neighboring records, if the first one is "falling asleep", then this will be a sleep period, if "waking up", then a wakefulness period.
It seems to be exactly what you need.
How to make a request from python you will find in every first example found through Google .