Security News
PyPI’s New Archival Feature Closes a Major Security Gap
PyPI now allows maintainers to archive projects, improving security and helping users make informed decisions about their dependencies.
knex-to-csv
Advanced tools
Adds the .toStreamCSV() function to Knex's query builder to stream rows from Knex in CSV format to a writable stream.
Adds the .toStreamCSV() function to Knex's query builder to stream rows from Knex in CSV format to a writable stream.
$ npm i knex-to-csv --save
Import and call the attachToStreamCSV()
function after importing Knex:
const knex = require('knex');
const {attachToStreamCSV} = require('knex-to-csv');
attachToStreamCSV();
Export Knex rows to a CSV file:
const fs = require('fs')
csvWriter = fs.createWriteStream('/tmp/export.csv');
await knex.select().from('users').toStreamCSV(csvWriter)
// or with promise
knex.select().from('users').toStreamCSV(csvWriter)
.then(() => {
console.log('CSV exported successfully!');
})
.catch(e => {
console.log(e);
})
Specify CSV options and export Knex result rows to a CSV file:
const fs = require('fs')
csvWriter = fs.createWriteStream('/tmp/export.csv');
await knex.select().from('users').toStreamCSV(csvWriter, {csv: {separator: '|', newline: '\n'}})
From Knex.js documentation:
If you wish to use streams with PostgreSQL, you must also install the pg-query-stream module. If you wish to use streams with the pgnative dialect, please be aware that the results will not be streamed as they are received, but rather streamed after the entire result set has returned. On an HTTP server, make sure to manually close your streams if a request is aborted.
toStreamCSV(writableStream, options?): Promise<number>
Any writable stream or Duplex stream that implements the stream.Writable class such as fs
write streams, http
ServerResponse, TCP sockets, Zlib streams, etc.
Type: object
Default: {}
Keys: path
, csv
path
Type: any
Default: undefined
A path for JSONStream.parse
csv
Type: object
Default: {separator: ',', newline: '\n', headers: undefined, sendHeaders: true}
Options to pass to csv-write-stream
This library was inspired from the following libraries:
FAQs
Adds the .toStreamCSV() function to Knex's query builder to stream rows from Knex in CSV format to a writable stream.
The npm package knex-to-csv receives a total of 70 weekly downloads. As such, knex-to-csv popularity was classified as not popular.
We found that knex-to-csv demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
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.
Security News
PyPI now allows maintainers to archive projects, improving security and helping users make informed decisions about their dependencies.
Research
Security News
Malicious npm package postcss-optimizer delivers BeaverTail malware, targeting developer systems; similarities to past campaigns suggest a North Korean connection.
Security News
CISA's KEV data is now on GitHub, offering easier access, API integration, commit history tracking, and automated updates for security teams and researchers.