import moment from 'moment'
//Load in data
import ConnectionData from '../../Data/Connections.csv';

//Process Data
var dates = [];
var totalConnectionsPerMonth = [];
function csvJSON(csvInput){
  let csvToJson = require('convert-csv-to-json');
  csvToJson.fieldDelimiter(',');
  return csvToJson.getJsonFromCsv(csvInput);
}

let connections = csvJSON(ConnectionData);

connections.forEach(function(connection) {
    let stri = (connection.FirstName).split(' ');

    if (stri[0] in totalConnectionsPerMonth)
    {
        totalConnectionsPerMonth[stri[0]] += 1;
    }
    else
    {
        totalConnectionsPerMonth[stri[0]] = 1;
    }
    
});
console.log(totalConnectionsPerMonth);
dates = Object.keys(totalConnectionsPerMonth);
var totalConnections = Object.values(totalConnectionsPerMonth);

dates.reverse();
totalConnections.reverse();

const data = {
    labels: dates,
    datasets: [
      {
        label: '# of Connections',
        lineTension: 0.1,
        backgroundColor: 'rgba(252,48,120,0.2)',
        borderColor: 'rgba(252,48,120,1)',
        borderCapStyle: 'butt',
        borderDash: [],
        borderDashOffset: 0.0,
        borderJoinStyle: 'miter',
        pointHitRadius: 10,
        data: totalConnections,
      }
    ],
  };
  
  export { data };