Method: Inspec::Resources::MssqlSession#query

Defined in:
lib/resources/mssql_session.rb

#query(q) ⇒ Object



22
23
24
25
26
27
# File 'lib/resources/mssql_session.rb', line 22

def query(q)
  escaped_query = q.gsub(/\\/, '\\\\').gsub(/"/, '\\"').gsub(/\$/, '\\$').gsub(/\@/, '`@')
  cmd = inspec.command("sqlcmd -U #{@user} -P #{@pass} -Q \"#{escaped_query}\"")

  cmd
end