README.md
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
Parameter | Description |
---|---|
query | Any valid SQL |
{
"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
Parameter | Description |
---|---|
namespace | Alphanumeric namespace defined in via MySqlConfig |
query | Any valid SQL |
{
"namespace": "staging",
"query": "Select Firstname, Lastname from Employees LIMIT 100"
}
Output
Query results as multidimensional Array
[
["Jane", "Doe"],
["Jon", "Doe"]
]
Contents