A bit of code to import some annoying data to parse

import_some_data_to_parse.js

const http = require('http');

function pushme(mydata,mytable) {

  var postData = JSON.stringify( mydata );

  var options = {
    hostname: 'localhost',
    port: 1337,
    path: '/parse/classes/'+mytable,
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      'Content-Length': Buffer.byteLength(postData),
      'X-Parse-Application-Id':'APPLICATION_ID',
    }
  };

  var req = http.request(options, (res) => {
    console.log(`STATUS: ${res.statusCode}`);
    console.log(`HEADERS: ${JSON.stringify(res.headers)}`);
    res.setEncoding('utf8');
    res.on('data', (chunk) => {
      console.log(`BODY: ${chunk}`);
    });
    res.on('end', () => {
      console.log('No more data in response.');
    });
  });

  req.on('error', (e) => {
    console.log(`problem with request: ${e.message}`);
  });

  req.write(postData);
  req.end();
}

//////////////////////////////////////////////////////////////////////////////////////////////////////
/*
// try use request to post

var request = require('request');
var url = "http://localhost:1337/parse/classes/GameScore";
var mydata = { score:1234, playerName:'fuck off and die',cheatMode:false};
var args = {
    data: mydata,
    headers: { "Content-Type": "application/json", "X-Parse-Application-Id": "APPLICATION_ID" }
};

request.post(url,args, function (error, response, body) {
  console.log(body);
  console.log(response);
  console.log(error);
});
*/
//////////////////////////////////////////////////////////////////////////////////////////////////////

/*

var options = {
  host: "http://localhost",
  port: 1337,
  path: '/parse/classes/GameScore',
  method: 'POST',
  headers: { "Content-Type": "application/json", "X-Parse-Application-Id": "APPLICATION_ID" },
  data: mydata,
};

http.request(options, function(res) {
  console.log('STATUS: ' + res.statusCode);
  console.log('HEADERS: ' + JSON.stringify(res.headers));
  res.setEncoding('utf8');
  res.on('data', function (chunk) {
    console.log('BODY: ' + chunk);
  });
}).end();

*/

//////////////////////////////////////////////////////////////////////////////////////////////////////

/*

// this does not work - i have to have a separate rest api for some reason - would love to talk to pare-server directly darnit

var Parse = require('node-parse-api').Parse;
var RestParse = new Parse("APPLICATION_ID", "MASTER_KEY");

console.log("attempting to insert something");

RestParse.insert(
  'GameScore',
   { score:1234, playerName:"the thing",cheatMode:false},
   function (err, response) {
     console.log("response was " + response + " " + err );
   }
);

// thisneeds to specify the app id... does not work

var Client = require('node-rest-client').Client;
var client = new Client();
client.post(url, args, function (data, response) {
    console.log(data);
    console.log(response);
});
console.log("done posting");
*/


//////////////////////////////////////////////////////////////////////////////////////////////////////
// Return array of string values, or NULL if CSV string not well formed.
function CSVtoArray(text) {
    var re_valid = /^\s*(?:'[^'\\]*(?:\\[\S\s][^'\\]*)*'|"[^"\\]*(?:\\[\S\s][^"\\]*)*"|[^,'"\s\\]*(?:\s+[^,'"\s\\]+)*)\s*(?:,\s*(?:'[^'\\]*(?:\\[\S\s][^'\\]*)*'|"[^"\\]*(?:\\[\S\s][^"\\]*)*"|[^,'"\s\\]*(?:\s+[^,'"\s\\]+)*)\s*)*$/;
    var re_value = /(?!\s*$)\s*(?:'([^'\\]*(?:\\[\S\s][^'\\]*)*)'|"([^"\\]*(?:\\[\S\s][^"\\]*)*)"|([^,'"\s\\]*(?:\s+[^,'"\s\\]+)*))\s*(?:,|$)/g;
    // Return NULL if input string is not well formed CSV string.
    if (!re_valid.test(text)) return null;
    var a = [];                     // Initialize array to receive values.
    text.replace(re_value, // "Walk" the string using replace with callback.
        function(m0, m1, m2, m3) {
            // Remove backslash from \' in single quoted values.
            if      (m1 !== undefined) a.push(m1.replace(/\\'/g, "'"));
            // Remove backslash from \" in double quoted values.
            else if (m2 !== undefined) a.push(m2.replace(/\\"/g, '"'));
            else if (m3 !== undefined) a.push(m3);
            return ''; // Return empty string.
        });
    // Handle special case of empty last value.
    if (/,\s*$/.test(text)) a.push('');
    return a;
};

//////////////////////////////////////////////////////////////////////////////////////////////////////

// try dump out some tables

fs = require('fs');

var lineReader = require('readline').createInterface({
  input: require('fs').createReadStream('aa.csv')
});

var badlines = [];

lineReader.on('line', function (line) {
  var parts = CSVtoArray(line); // line.split(",");

  if(parts == null) {
     // if cannot parse then keep building up line
     badlines.push(line);
     if(badlines.length < 2) {
       return;
     }
     line = badlines.join('');
     parts = CSVtoArray(line);
     if(parts == null) {
       return;
     }
     badlines = [];
  }
  if(badlines.length > 0) {
    console.log("************** problem with *********** " + badlines.join(""));
    badlines = [];
  }

  // Name,AC,,Type of Entity,Location,City,County,Contact,URL^M

  var name = parts[0];      if(!name || typeof name == undefined) return;
  var ac = parts[1];        if(!ac || typeof ac == undefined) ac = "none";
  var entity = parts[3];    if(!entity || typeof entity == undefined) entity = "error";
  var loc = parts[4];       if(!loc || typeof loc == undefined) loc = "none";
  var city = parts[5];      if(!city || typeof city == undefined) city = "none";
  var county = parts[6];    if(!county || typeof count == undefined) county = "none";
  var contact = parts[7];   if(!contact || typeof contact == undefined) contact = "none";
  var url = parts[8];       if(!url || typeof url == undefined) url = "none";

  var blob = { name:name, entity:entity, address:loc, city:city, contact:contact, url:url };

  console.log("...........................................");
  console.log("name:"+name);
  console.log("address:"+loc);
  console.log("contact:"+contact);
  console.log("url:"+url);

  pushme(blob,"Venue");

});