Utility to save the output of a sql query to a json file
C#
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
SQL2JSON.Tests
SQL2JSON
packages
.gitattributes
.gitignore
LICENSE
README.md
SQL2JSON.sln

README.md

SQL2JSON v1.0

SQL2JSON is a Apache2 Licensed command line utility that captures execution of a sql query to a json file.

Requirements

SQL2JSON requires .NET v4.0 framework.

Usage

Suppose you have a table called "users" with the following records:

user_id first_name last_name
1 john johnson
2 scott scottson
3 paul paulson

Example #1 - Simplest Case

sql2json.exe -cs="Data Source=.;Initial Catalog=DB1;User Id=usr;Password=pwd;" -sql="select * from users" -output="users.json"

users.json:

[
	{ "user_id": 1, "first_name": "john", "last_name": "johnson"},
	{ "user_id": 2, "first_name": "scott", "last_name": "scottson"},
	{ "user_id": 3, "first_name": "paul", "last_name": "paulson"}
]

Example #2 - Nested Objects

This example demonstrates the use of delimiters to build a json string containing nested objects

sql2json.exe -cs="Data Source=.;Initial Catalog=DB1;User Id=usr;Password=pwd;" -sql="select user_id, first_name as 'name::first', last_name as 'name::last' from users" -output="users.json"

users.json:

[
	{
		"user_id": 1,
		"name": { "first": "john", "last": "johnson" }
	},
	{
		"user_id": 2,
		"name": { "first": "scott", "last": "scottson" }
	},
	{
		"user_id": 3,
		"name": { "first": "paul", "last": "paulson" }
	}
]

Advanced Scenarios

If you need include calculations or aggregations in your JSON objects you can either precalculate them in your sql query, or if you are more adventurous, you can write your own implementation of ITransformer to execute the required logic.