You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We were discussing how to add a project fact that tracks the number of recent restarts as an indicator of quality recently. It would be trivial to implement if we had a way to periodically run
SELECTCOUNT(o.id)
FROMv1.operations_logAS o
WHEREo.project_id= %(project_id)s
ANDo.change_type='Restarted'ANDo.recorded_at>CURRENT_TIMESTAMP- INTERVAL '14d'
and assign the value to the Recent Restart Count fact.
This shouldn't be too difficult to implement... without thinking too hard about it:
add a new fact type named query -- current values are enum, range, & free-form
create v1.project_fact_types_query to hold the query and frequency
add a periodic task somewhere that runs queries for projects with a "query" fact type -- pgcron?
add necessary CRUD to the Admin UI
The text was updated successfully, but these errors were encountered:
We were discussing how to add a project fact that tracks the number of recent restarts as an indicator of quality recently. It would be trivial to implement if we had a way to periodically run
and assign the value to the
Recent Restart Count
fact.This shouldn't be too difficult to implement... without thinking too hard about it:
query
-- current values are enum, range, & free-formv1.project_fact_types_query
to hold the query and frequencyThe text was updated successfully, but these errors were encountered: