util

util / MsSqlServer / 0.1.0

README.md

Overview

Query a MS SQL Server Database which has been preconfigured via util/MsSqlServerConfig

Usage

Input: bare query string

Any valid SQL query (note that BLOBs or very long result sets may return too much data to transfer). Separate USE statement with ;

"USE employees; SELECT firstname, lastname FROM employees"

Input: query

ParameterDescription
queryAny valid SQL
{
	"query": "USE employees; SELECT firstname, lastname FROM employees"
}

Input: query on a specific namespace

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

ParameterDescription
namespaceAlphanumeric namespace defined in via MsSqlServerConfig
queryAny valid SQL
{
	"namespace": "staging",
	"query": "USE employees; SELECT firstname, lastname FROM employees"
}

Output

Query results as multidimensional Array

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