Asciidoctor textql extension example

a-input.adoc

[textql%header, "select name, title, length(name) from tbl where title like 'C%'", "Name,Title,Length of Name"]
....
id,name,title
1,Paul,CEO
2,Jeff,CTO
3,Dmitri,Vice President
....

Note	In a real scenario, the CSV data would be read from an include directive.

b-extension.rb

require 'asciidoctor'
require 'asciidoctor/extensions'

include ::Asciidoctor

Extensions.register do
  block :textql do
    on_contexts :literal
    parse_content_as :raw
    map_attributes ['query', 'header']
    process do |parent, reader, attrs|
      input_header = (attrs.has_key? 'header-option') ? reader.lines.first : nil
      output_header = (attrs.has_key? 'header') ? attrs['header'] : input_header
      cmd = %(echo "#{reader.source}" | /home/dallen/opt/gocode/bin/textql#{input_header ? ' -header' : nil} -sql "#{attrs['query']}")
      result_lines = %x(#{cmd}).chomp.split "\n"
      if output_header
        result_lines.unshift ''
        result_lines.unshift output_header
      end
      result_lines.unshift ",==="
      result_lines << ",==="

      container = create_open_block parent, nil, nil, :content_model => :compound
      Lexer.parse_blocks((Reader.new result_lines), container)
      container
    end
  end
end

Asciidoctor.render_file 'sample.adoc', :in_place => true

c-effective-output.adoc

Name	Title	Name Length
Paul	CEO	4
Jeff	CTO	4