Method: Inspec::Resources::PostgresSession#query

Defined in:
lib/resources/postgres_session.rb

#query(query, db = []) ⇒ Object



50
51
52
53
54
55
56
57
58
59
# File 'lib/resources/postgres_session.rb', line 50

def query(query, db = [])
  psql_cmd = create_psql_cmd(query, db)
  cmd = inspec.command(psql_cmd)
  out = cmd.stdout + "\n" + cmd.stderr
  if cmd.exit_status != 0 || out =~ /could not connect to .*/ || out.downcase =~ /^error:.*/
    Lines.new(out, "PostgreSQL query with errors: #{query}")
  else
    Lines.new(cmd.stdout.strip, "PostgreSQL query: #{query}")
  end
end