Method UpdateLastUsed

database/api_key.go:272–281

UpdateLastUsed updates the last_used_at timestamp for an API key to the current time. This function is typically called during authentication to track API key usage patterns. Note: This does NOT invalidate the cache to avoid performance overhead on every request. The cached version will still work f

(ctx context.Context, id string)

// Returns:
// - error: An error if the database update operation fails.
func (s *Datasource) UpdateLastUsed(ctx context.Context, id string) error {
	query := `
		UPDATE ledgerforge.api_keys
		SET last_used_at = $1
		WHERE api_key_id = $2
	`

	_, err := s.Conn.ExecContext(ctx, query, time.Now(), id)
	return err
}

// ListAPIKeys retrieves all API keys belonging to a specific owner from the database.
// The results are ordered by creation date in descending order (newest first).