Overview

Query a MySql Database which has been preconfigured via util/MySqlConfig

Usage

Input: bare query string

Any valid SQL query (note that BLOBs or very long result sets may return too much data to transfer; use of LIMIT is encouraged)

"Select Firstname, Lastname from Employees LIMIT 100"

Input: query

{
	"query": "Select Firstname, Lastname from Employees LIMIT 100"
}

Input: query on a specific namespace

util/MySqlConfig supports storing different configuration files, referred to as namespaces

{
	"namespace": "staging",
	"query": "Select Firstname, Lastname from Employees LIMIT 100"
}

Output

Query results as multidimensional Array

[
  ["Jane", "Doe"],
  ["Jon", "Doe"]
]