Socket
Socket
Sign inDemoInstall

csv-builder-m

Package Overview
Dependencies
2
Maintainers
1
Versions
1
Alerts
File Explorer

Advanced tools

Install Socket

Detect and block malicious and high-risk dependencies

Install

    csv-builder-m

Create csv formated streams from Arrays of Objects.


Version published
0
Maintainers
1
Install size
843 kB
Created
Weekly downloads
 

Readme

Source

Csvbuilder

Create csv formated streams from Arrays of Objects. CsvBuilder is one of many Csv stream/generator implementations on npm. The goal of CsvBuilder is to create Schema's for csv output and let the consumer spawn as many streams as needed from a single instance to maintain a specific format. This means the user gets control of the headers, the order of the headers, how the headers correspond to consumed objects, virtual properties, value delimiters, and line terminators.

Getting Started


var CsvBuilder = require('csv-builder');

// assuming we have an array of objects that's
// in the format of {fullname: String, email: String, zip: Number}
// but we need csv formated as such: Firstname, Lastname, Email

var usersBuilder = new CsvBuilder({
	// define headers and order of headers
	headers: 'Firstname Lastname Email',
	// define object to header correspondance
	constraints: {
		// Header: property
		'Email': 'email'
		// correspond with a virtual property
		'Lastname': 'lastname'
	}
})
// create virtual 'Firstname'
.virtual('Firstname', function(obj) {
	return obj.name.split(' ')[0];
})
// virtual properties are treated like any propery,
// if it is not defined in the headers, it still needs a constraint
.virtual('lastname', function(obj) {
	return obj.name.split(' ')[1];
});

// From the `usersBuilder` instance we can now spawn readable or tranform streams.

// pipe into a newly created duplex
Model.find().stream()
	.pipe(usersBuilder.createTransformStream())
	.pipe(fs.createWriteStream('output.csv'));

// Create a readable stream from an Array<Object> payload
usersBuilder.createReadStream(payload)
	.pipe(fs.createWriteStream('output.csv'));

Installation

$ npm install csv-builder

Usage

CsvBuilder([options])
  • headers String|Array Space separated headers, or array of headers (required)
  • delimiter String The value delimiter. Default ','
  • terminator String The line terminator. Default '\n'
  • mutate Boolean Mutate incoming objects when creating virtuals. Default true
  • constraints Object {"header": "prop"}

Methods

CsvBuilder#headers(headers)
  • headers String|Array Space separated headers, or array of headers
CsvBuilder#set(header, prop)

Set single or multiple contraints. If header is an object, it will extend any existing constraints, not replace.

  • header String|Object Either object {"header": "property"} Or a string "Header"
  • prop String Property to correspond to header, omit if using object.
CsvBuilder#virtual(prop, fn)

Create a virtual property. Virtual properties are treated the same as normal properties, so if no header matches the virtual property name, or no constraint is set the virtual property will be omitted.

  • prop String Virtual property name
  • fn Function Returns virtual value, takes the object to be created/mutated as the only argument.
CsvBuilder#createReadStream(payload)

Create's a readable stream and consumes the payload.

  • payload Array
    CsvBuilder#createTransformStream()

    Create's a transform stream. The stream expects either Objects or JSON.

Keywords

FAQs

Last updated on 19 Dec 2016

Did you know?

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc