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 = ; // name of the database tableconst tableName = "users";// number of rows to generate info forconst numRows = 2;// name of the database fields (columns)const fields = "first_name" "last_name" "job_title" "random_number";// attribute.subAttribute taken from the faker libraryconst attributes = "name.firstName" "name.lastName" "name.jobTitle" "random.number"; // returns the string and console logs the string;
//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