package postgres import ( "context" "time" ) const operationalStatusSQL = ` SELECT (SELECT COUNT(*) FROM question_table_exports WHERE tenant_key = $1 AND status IN ('pending','exporting')), (SELECT COUNT(*) FROM question_table_exports WHERE tenant_key = $1 AND status = 'export_failed'), (SELECT MAX(exported_at) FROM question_table_exports WHERE tenant_key = $1 AND status = 'exported'), (SELECT COUNT(*) FROM support_cases WHERE tenant_key = $1 AND faq_export_status IN ('pending','exporting')), (SELECT COUNT(*) FROM support_cases WHERE tenant_key = $1 AND faq_export_status = 'export_failed'), (SELECT MAX(faq_exported_at) FROM support_cases WHERE tenant_key = $1 AND faq_export_status = 'exported'), (SELECT COUNT(*) FROM support_cases WHERE tenant_key = $1 AND status IN ('pending','notifying') AND faq_export_status = 'exported'), (SELECT COUNT(*) FROM support_cases WHERE tenant_key = $1 AND status = 'notification_failed'), (SELECT MAX(notified_at) FROM support_cases WHERE tenant_key = $1 AND status = 'notified')` type OperationalMetrics struct { QuestionPending, QuestionFailed int FAQPending, FAQFailed int SupportPending, SupportFailed int LastQuestionSuccess time.Time LastFAQSuccess time.Time LastSupportSuccess time.Time } func (s *Store) Ping(ctx context.Context) error { if s == nil || s.pool == nil { return context.Canceled } return s.pool.Ping(ctx) } func (s *Store) ReadOperationalMetrics(ctx context.Context, tenant string) (OperationalMetrics, error) { var value OperationalMetrics var questionSuccess, faqSuccess, supportSuccess *time.Time err := s.pool.QueryRow(ctx, operationalStatusSQL, tenant).Scan( &value.QuestionPending, &value.QuestionFailed, &questionSuccess, &value.FAQPending, &value.FAQFailed, &faqSuccess, &value.SupportPending, &value.SupportFailed, &supportSuccess, ) if questionSuccess != nil { value.LastQuestionSuccess = *questionSuccess } if faqSuccess != nil { value.LastFAQSuccess = *faqSuccess } if supportSuccess != nil { value.LastSupportSuccess = *supportSuccess } return value, err }