Store an update_time in the host table each time the host checks in, and use this instead of the session update_time.
~~WIP~~ ~~I still need to fix some unit tests~~
1 new commit added
fix unit tests
Added https://pagure.io/koji/issue/3789
worth an index?
migration script
conflicts with session.update_time:
session.update_time
psycopg2.errors.AmbiguousColumn: column reference "update_time" is ambiguous LINE 11: AND (update_time > NOW() - '5 minutes'::interval)
avoid ambiguous columns refs
Because in this PR is change in schema.sql, we should add it to upgrade-schema sql also, or not? Tomas mentioned it also in comments.
Added in #3819
Pull-Request has been closed by tkopecek
Store an update_time in the host table each time the host checks in, and use this instead of the session update_time.