tedious.coffee

config     = require '../config'

Connection = require('tedious').Connection
Request    = require('tedious').Request
async      = require('async')
  #
  # # If no error, then good to go...
  # contributionReport()
  # return

contributionReport  = "SELECT COUNT(QueryInstanceId) FROM ReportRuns (nolock) WHERE ReportType = 'Contribution Report'"
pledgeReport        = "SELECT COUNT(QueryInstanceId) FROM ReportRuns (nolock) WHERE ReportType = 'Pledge Report'"

class Tedious

  constructor: (cb) ->
    @refreshData (err, content) -> cb err, content

  refreshData: (cb) ->
    async.waterfall [
      @getContributionReport,
      @getPledgeReport
    ], (err, content) =>
      cb err, content

  getContributionReport: (cb) ->
    connection = new Connection(config.tedious)
    connection.on 'connect', (err) =>
      request = new Request contributionReport, (err, rowCount, rows) ->
        console.log err
        cb err if err
        request.on 'row', (columns) ->
          columns.forEach (column) ->
            console.log column.value
        console.log rows
        cb err, rows[0][0].value
      connection.execSql request

  getPledgeReport: (cb) ->
    connection = new Connection(config.tedious)
    connection.on 'connect', (err) =>
      request = new Request pledgeReport, (err, rowCount, rows) ->
        console.log err
        cb err if err
        request.on 'row', (columns) ->
          columns.forEach (column) ->
            console.log column.value
        console.log rows
        cb err, rows[0][0].value
      connection.execSql request

    # request.on 'row', (columns) ->
    #   columns.forEach (column) ->
    #     contributionReport = column.value
    #     #console.log column.value
    #     return
    #   return
    # return

module.exports = Tedious