var vows = require(“vows”),
load = require("../load"), assert = require("../assert");
var suite = vows.describe(“d3.csv”);
suite.addBatch({
"csv": { topic: load("dsv/csv").expression("d3.csv").document(), "on a sample file": { topic: function(csv) { csv("test/data/sample.csv", this.callback); }, "invokes the callback with the parsed CSV": function(csv) { assert.deepEqual(csv, [{"Hello":"42","World":"\"fish\""}]); }, "overrides the mime type to text/csv": function(csv) { assert.equal(XMLHttpRequest._last._info.mimeType, "text/csv"); } }, "when specifying a row conversion function": { topic: function(csv) { csv("test/data/sample.csv", function(row) { row.Hello = -row.Hello; return row; }, this.callback); }, "invokes the callback with the parsed CSV": function(csv) { assert.strictEqual(csv[0].Hello, -42); } }, "when loading a file that does not exist": { topic: function(csv) { var callback = this.callback; csv("//does/not/exist.csv", function(error, csv) { callback(null, csv); }); }, "invokes the callback with undefined": function(csv) { assert.isUndefined(csv); } }, "parse": { topic: function(csv) { return csv.parse; }, "returns an array of objects": function(parse) { assert.deepEqual(parse("a,b,c\n1,2,3\n"), [{a: "1", b: "2", c: "3"}]); }, "does not strip whitespace": function(parse) { assert.deepEqual(parse("a,b,c\n 1, 2,3\n"), [{a: " 1", b: " 2", c: "3"}]); }, "parses quoted values": function(parse) { assert.deepEqual(parse("a,b,c\n\"1\",2,3"), [{a: "1", b: "2", c: "3"}]); assert.deepEqual(parse("a,b,c\n\"1\",2,3\n"), [{a: "1", b: "2", c: "3"}]); }, "parses quoted values with quotes": function(parse) { assert.deepEqual(parse("a\n\"\"\"hello\"\"\""), [{a: "\"hello\""}]); }, "parses quoted values with newlines": function(parse) { assert.deepEqual(parse("a\n\"new\nline\""), [{a: "new\nline"}]); assert.deepEqual(parse("a\n\"new\rline\""), [{a: "new\rline"}]); assert.deepEqual(parse("a\n\"new\r\nline\""), [{a: "new\r\nline"}]); }, "parses unix newlines": function(parse) { assert.deepEqual(parse("a,b,c\n1,2,3\n4,5,\"6\"\n7,8,9"), [ {a: "1", b: "2", c: "3"}, {a: "4", b: "5", c: "6"}, {a: "7", b: "8", c: "9"} ]); }, "parses mac newlines": function(parse) { assert.deepEqual(parse("a,b,c\r1,2,3\r4,5,\"6\"\r7,8,9"), [ {a: "1", b: "2", c: "3"}, {a: "4", b: "5", c: "6"}, {a: "7", b: "8", c: "9"} ]); }, "parses dos newlines": function(parse) { assert.deepEqual(parse("a,b,c\r\n1,2,3\r\n4,5,\"6\"\r\n7,8,9"), [ {a: "1", b: "2", c: "3"}, {a: "4", b: "5", c: "6"}, {a: "7", b: "8", c: "9"} ]); } }, "parse with row function": { "invokes the row function for every row in order": function(csv) { var rows = []; csv.parse("a\n1\n2\n3\n4", function(d, i) { rows.push({d: d, i: i}); }); assert.deepEqual(rows, [ {d: {a: "1"}, i: 0}, {d: {a: "2"}, i: 1}, {d: {a: "3"}, i: 2}, {d: {a: "4"}, i: 3} ]); }, "returns an array of the row function return values": function(csv) { assert.deepEqual(csv.parse("a,b,c\n1,2,3\n", function(row) { return row; }), [{a: "1", b: "2", c: "3"}]); }, "skips rows if the row function returns null or undefined": function(csv) { assert.deepEqual(csv.parse("a,b,c\n1,2,3\n2,3,4", function(row) { return row.a & 1 ? null : row; }), [{a: "2", b: "3", c: "4"}]); assert.deepEqual(csv.parse("a,b,c\n1,2,3\n2,3,4", function(row) { return row.a & 1 ? undefined : row; }), [{a: "2", b: "3", c: "4"}]); } }, "parseRows": { topic: function(csv) { return csv.parseRows; }, "returns an array of arrays": function(parse) { assert.deepEqual(parse("a,b,c\n"), [["a", "b", "c"]]); }, "parses quoted values": function(parse) { assert.deepEqual(parse("\"1\",2,3\n"), [["1", "2", "3"]]); assert.deepEqual(parse("\"hello\""), [["hello"]]); }, "parses quoted values with quotes": function(parse) { assert.deepEqual(parse("\"\"\"hello\"\"\""), [["\"hello\""]]); }, "parses quoted values with newlines": function(parse) { assert.deepEqual(parse("\"new\nline\""), [["new\nline"]]); assert.deepEqual(parse("\"new\rline\""), [["new\rline"]]); assert.deepEqual(parse("\"new\r\nline\""), [["new\r\nline"]]); }, "parses unix newlines": function(parse) { assert.deepEqual(parse("a,b,c\n1,2,3\n4,5,\"6\"\n7,8,9"), [ ["a", "b", "c"], ["1", "2", "3"], ["4", "5", "6"], ["7", "8", "9"] ]); }, "parses mac newlines": function(parse) { assert.deepEqual(parse("a,b,c\r1,2,3\r4,5,\"6\"\r7,8,9"), [ ["a", "b", "c"], ["1", "2", "3"], ["4", "5", "6"], ["7", "8", "9"] ]); }, "parses dos newlines": function(parse) { assert.deepEqual(parse("a,b,c\r\n1,2,3\r\n4,5,\"6\"\r\n7,8,9"), [ ["a", "b", "c"], ["1", "2", "3"], ["4", "5", "6"], ["7", "8", "9"] ]); } }, "format": { topic: function(csv) { return csv.format; }, "takes an array of objects as input": function(format) { assert.equal(format([{a: 1, b: 2, c: 3}]), "a,b,c\n1,2,3"); }, "escapes field names containing special characters": function(format) { assert.equal(format([{"foo,bar": true}]), "\"foo,bar\"\ntrue"); }, "computes the union of all fields": function(format) { assert.equal(format([ {a: 1}, {a: 1, b: 2}, {a: 1, b: 2, c: 3}, {b: 1, c: 2}, {c: 1} ]), "a,b,c\n1,,\n1,2,\n1,2,3\n,1,2\n,,1"); }, "orders field by first-seen": function(format) { assert.equal(format([ {a: 1, b: 2}, {c: 3, b: 4}, {c: 5, a: 1, b: 2} ]), "a,b,c\n1,2,\n,4,3\n1,2,5"); } }, "formatRows": { topic: function(csv) { return csv.formatRows; }, "takes an array of arrays as input": function(format) { assert.equal(format([["a", "b", "c"], ["1", "2", "3"]]), "a,b,c\n1,2,3"); }, "separates lines using unix newline": function(format) { assert.equal(format([[], []]), "\n"); }, "does not strip whitespace": function(format) { assert.equal(format([["a ", " b", "c"], ["1", "2", "3 "]]), "a , b,c\n1,2,3 "); }, "does not quote simple values": function(format) { assert.equal(format([["a"], [1]]), "a\n1"); }, "escapes double quotes": function(format) { assert.equal(format([["\"fish\""]]), "\"\"\"fish\"\"\""); }, "escapes unix newlines": function(format) { assert.equal(format([["new\nline"]]), "\"new\nline\""); }, "escapes commas": function(format) { assert.equal(format([["oxford,comma"]]), "\"oxford,comma\""); } } }
});
suite.export(module);