71 lines
2.4 KiB
JavaScript
71 lines
2.4 KiB
JavaScript
var should = require("should");
|
|
var helper = require("node-red-node-test-helper");
|
|
var bookNode = require("../book.js");
|
|
var sheetNode = require("../sheet.js");
|
|
var fs = require("fs");
|
|
|
|
helper.init(require.resolve('node-red'));
|
|
|
|
describe('sheet Node', function () {
|
|
|
|
before(function (done) {
|
|
helper.startServer(done);
|
|
});
|
|
|
|
after(function (done) {
|
|
helper.stopServer(done);
|
|
});
|
|
|
|
afterEach(function () {
|
|
helper.unload();
|
|
});
|
|
|
|
it('should be loaded', function (done) {
|
|
var flow = [{ id: "n1", type: "sheet", name: "sheet1" }];
|
|
helper.load(sheetNode, flow, function () {
|
|
var n1 = helper.getNode("n1");
|
|
n1.should.have.property('name', 'sheet1');
|
|
done();
|
|
});
|
|
});
|
|
|
|
it('should pick the sheet object specified in node config', function (done) {
|
|
var flow = [
|
|
{ id: "n1", type: "book", name: "book1", wires: [["n2"]] },
|
|
{ id: "n2", type: "sheet", name: "sheet1", wires: [["n3"]], sheetName: "Sheet1" },
|
|
{ id: "n3", type: "helper" }
|
|
];
|
|
helper.load([bookNode, sheetNode], flow, function () {
|
|
var n3 = helper.getNode("n3");
|
|
n3.on("input", function (msg) {
|
|
msg.should.have.propertyByPath('payload', '!ref').eql("A1:C3");
|
|
msg.should.have.property('selectedSheetName', "Sheet1");
|
|
done();
|
|
});
|
|
var n1 = helper.getNode("n1");
|
|
var data = fs.readFileSync(__dirname + "/example.xlsx");
|
|
n1.receive({ payload: data });
|
|
});
|
|
});
|
|
|
|
it('should pick the sheet object specified in msg object', function (done) {
|
|
var flow = [
|
|
{ id: "n1", type: "book", name: "book1", wires: [["n2"]] },
|
|
{ id: "n2", type: "sheet", name: "sheet1", wires: [["n3"]], sheetName: "" },
|
|
{ id: "n3", type: "helper" }
|
|
];
|
|
helper.load([bookNode, sheetNode], flow, function () {
|
|
var n3 = helper.getNode("n3");
|
|
n3.on("input", function (msg) {
|
|
msg.should.have.propertyByPath('payload', '!ref').eql("A1:C3");
|
|
msg.should.have.property('selectedSheetName', "Sheet1");
|
|
done();
|
|
});
|
|
var n1 = helper.getNode("n1");
|
|
var data = fs.readFileSync(__dirname + "/example.xlsx");
|
|
n1.receive({ payload: data, selectSheetName: "Sheet1" });
|
|
});
|
|
});
|
|
|
|
});
|