ctigeek/DbSync — pull request #1 by benjaminmicucci (2014-10-01 16:17:46+00:00)
Title: DbSync Report Creation

## Description

This PR is for allowing a Report to be created via a command argument. It utilizes the Nuget Package [RestSharp](http://restsharp.org/) and the [Mailgun Api](http://www.mailgun.com/) for sending the Report via Email. An individual email is sent for each unique mapping in the TableMap.json file.

The body of the email includes the following information:
+ Whether or not row counts of each table within the unique mapping are equal from the Source & Destination schema.
+ A report of the comparison of data from the `sync_changes` table to check that both the Source & Destination table's records have correct synchronized data, if not, which Primary Key is off, & the column that is mismatched.

*Note: in order to obtain an api key & base url, a Mailgun account is required.*
Currently, the Base Url, Api Key, Sender, & Recipient for the Report messaging are located as `string const` in `SyncStatusReport.cs` class variables, so the empty strings will need to be replaced with the user's unique values. There are plans to relocate these values to a configuration file.

*Also: the full command is:* 'DbSyncService.exe report'