Class: GrafanaReporter::Asciidoctor::PanelQueryTableIncludeProcessor

Inherits:
Asciidoctor::Extensions::IncludeProcessor
  • Object
show all
Includes:
ProcessorMixin
Defined in:
lib/grafana_reporter/asciidoctor/panel_query_table_include_processor.rb

Overview

Implements the hook

include::grafana_panel_query_table:<panel_id>[<options>]

Returns the results of the SQL query as a asciidoctor table.

Used document parameters

grafana_default_instance - name of grafana instance, ‘default’ if not specified

grafana_default_dashboard - uid of grafana default dashboard to use

from - ‘from’ time for the sql query

to - ‘to’ time for the sql query

All other variables starting with var- will be used to replace grafana templating strings in the given SQL query.

Supported options

query - query letter, which shall be used, e.g. C (mandatory)

instance - name of grafana instance, ‘default’ if not specified

dashboard - uid of grafana dashboard to use

from - ‘from’ time for the sql query

to - ‘to’ time for the sql query

format - see GrafanaReporter::AbstractQuery#format_columns

replace_values - see GrafanaReporter::AbstractQuery#replace_values

filter_columns - see GrafanaReporter::AbstractQuery#filter_columns

Instance Method Summary collapse

Methods included from ProcessorMixin

#build_attribute_hash, #current_report

Instance Method Details

#build_demo_entry(panel) ⇒ Object

See Also:



81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
 
# File 'lib/grafana_reporter/asciidoctor/panel_query_table_include_processor.rb', line 81

def build_demo_entry(panel)
  return nil unless panel
  return nil unless panel.model['type'].include?('table')

  ref_id = nil
  panel.model['targets'].each do |item|
    if !item['hide'] && !panel.query(item['refId']).to_s.empty?
      ref_id = item['refId']
      break
    end
  end
  return nil unless ref_id

  "|===\ninclude::grafana_panel_query_table:#{panel.id}[query=\"#{ref_id}\",filter_columns=\"time\","\
  "dashboard=\"#{panel.dashboard.id}\"]\n|==="
end

#handles?(target) ⇒ Boolean

:nodoc:

Returns:

  • (Boolean) 


44
45
46
 
# File 'lib/grafana_reporter/asciidoctor/panel_query_table_include_processor.rb', line 44

def handles?(target)
  target.start_with? 'grafana_panel_query_table:'
end

#process(doc, reader, target, attrs) ⇒ Object

:nodoc:



49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
 
# File 'lib/grafana_reporter/asciidoctor/panel_query_table_include_processor.rb', line 49

def process(doc, reader, target, attrs)
  return if @report.cancel

  @report.next_step
  panel_id = target.split(':')[1]
  instance = attrs['instance'] || doc.attr('grafana_default_instance') || 'default'
  dashboard = attrs['dashboard'] || doc.attr('grafana_default_dashboard')
  attrs['result_type'] = 'panel_table'
  @report.logger.debug("Processing PanelQueryTableIncludeProcessor (instance: #{instance}, "\
                       "dashboard: #{dashboard}, panel: #{panel_id}, query: #{attrs['query']})")

  begin
    panel = @report.grafana(instance).dashboard(dashboard).panel(panel_id)
    vars = { 'table_formatter' => 'adoc_plain' }.merge(build_attribute_hash(doc.attributes, attrs))
    query = QueryValueQuery.new(panel, variables: vars)

    reader.unshift_lines query.execute.split("\n")
  rescue Grafana::GrafanaError => e
    @report.logger.error(e.message)
    reader.unshift_line "|#{e.message}"
  rescue GrafanaReporterError => e
    @report.logger.error(e.message)
    reader.unshift_line "|#{e.message}"
  rescue StandardError => e
    @report.logger.fatal("#{e.message}\n#{e.backtrace.join("\n")}")
    reader.unshift_line "|#{e.message}\n#{e.backtrace.join("\n")}"
  end

  reader
end