node package manager
Stop writing boring code. Discover, share, and reuse within your team. Create a free org »

knex-csv-seeder

knex-csv-seeder

npm version Build Status codecov.io Dependency Status

Basic usage

Create a seed file for Knex.

knex seed:make seed_name

Change the code to import the data from CSV.
Please refer to the link format of the file.

import seeder from 'knex-csv-seeder';
 
exports.seed = seeder({
  table: 'users',
  file: '/path/to/users.csv',
  // recordsPerQuery: 100, 
  // encoding: 'utf8' default encoding 
  // parser: { 
  //   delimiter: ',', 
  //   quote: '"', 
  //   escape: '\\' 
  // } 
});

Execute the seed files.

knex seed:run