Seederalize NPM

Seederalize

Generates how many seed files you want for Sequelize from existing databases in less than a second. Supported db engines till now:

PostgreSQL
MySQL

Installation

Global module

To install module globally simply type npm i -g seederalize in your console.

Local module

or use it directly in your project with npm install seederalize

Usage

There are two ways to use this utility:

Use step by step wizard which will guide you though the process - just type npx seederalize in your console.
Provide all parameters through command line(examples below)

Usage:

const { createFile } = require('seederalize')

createFile({
    count: 5,
    output : 'test-seed',
    username: 'username',
    password: 'password',
    database: 'seederalize',
    host: 'localhost',
    dialect: 'postgres',
    logging: false,
    port: 5432
  })

Use npx seederalize --desc to see all available parameters with their descriptions. Some basic parameters below:

Usage: seederalize -h <host> -d <database> -p [port] -u <user> -x
[password] -e [engine]

Options:
  --desc                 Show help command line options
  -v                     Show version number
  -h, --host             IP address/Hostname for database server
                                                          [default: "127.0.0.1" or "localhost"]
  -d, --database         Database name                             [required]
  -u, --user             Username for database server              [required]
  -x, --pass             Password for database server              [required]
  -p, --port             Port number for database server           [default: 5432]
  -e, --engine           Database engine
                                    [choices: "postgres", "mysql"]  [default: "postgres"]
  -o, --output           Where to place generated models   [default: "./db"]
  -l, --logging          logging option when composing a query object   [default: false] [boolean]

Examples

Creating seed from local Postgres database

Global module

seederalize -h localhost -d postgres -u postgres -x !Passw0rd -e postgres -o .

Npx Way

npx seederalize -h localhost -d postgres -u postgres -x !Passw0rd -e postgres -o .

Hashing passwords

you can see how we hash passwords using md5 package like below:

function hashPass(rawPassword, { salt = 15, rounds = 10 }) {

  let hashed = md5(rawPassword + salt);
  for (let i = 0; i <= rounds; i++) {
    hashed = md5(hashed);
  }

  return `${salt}$${rounds}$${hashed}`;
}

if you want to use it in your code to compare passwords, here you are:

function compare(rawPassword, hashedPassword) {
  try {
    const [ salt, rounds ] = hashedPassword.split('$');

    const hashedRawPassword = hashPass(rawPassword, { salt, rounds });
    return hashedPassword === hashedRawPassword;
  } catch (error) {
    throw Error(error.message);
  }
}