JSPM

  • ESM via JSPM
  • ES Module Entrypoint
  • Export Map
  • Keywords
  • License
  • Repository URL
  • TypeScript Types
  • README
  • Created
  • Published
  • 0
  • Score
    100M100P100Q41507F
  • License ISC

simple package to create the SQL needed to populate your database

Package Exports

  • mass-db-seed

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (mass-db-seed) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

mass-db-seed

Helps generate seed data for a SQL database using the faker library.

Installing


npm install mass-db-seed
yarn add mass-db-seed

Example


Note: the attributes variable is a string composed of the faker library's attribute and subattributes.

E.g: if you wanted to use faker.name.firstName as a value, you would include "name.firstName".

const massDbSeed = require("mass-db-seed");

// name of the database table
const tableName = "users";
// number of rows to generate info for
const numRows = 2;
// name of the database fields (columns)
const fields = ["first_name", "last_name", "job_title", "random_number"];
// attribute.subAttribute taken from the faker library
const attributes = ["name.firstName", "name.lastName", "name.jobTitle", "random.number"];

// returns the string and console logs the string
massDbSeed(tableName, numRows, fields, attributes);
//Example output:
INSERT INTO users (first_name, last_name, job_title, random_number) VALUES ('Giovanna', 'Leannon', 'Central Intranet Officer', 76167), ('Brianne', 'Nitzsche', 'Regional Web Executive', 94287)

References


Faker Library

TO DO


  • create CI/CD
  • more examples
  • create table of contents