Nodejs Validation Schema Rules

Automatically generate basic validation rules based on your database table schema effortlessly!

This tool generates preliminary validation rules for popular libraries such as JOI, ValidatorJS and @vinejs/vine. These rules serve as a convenient starting point, allowing you to refine and enhance them to suit your specific needs.

Installation

npm install @tasmidur/nodejs-validation-schema-rules
yarn add @tasmidur/nodejs-validation-schema-rules

Then run nodeSchema init if you install the package globally otherwise npm run nodeSchema init for ".schema-config.js"

   nodeSchema init
   npm run nodeSchema init

Modify the ".schema-config.js"

require("dotenv").config();
const schemaConfig = {
  defaultDatabase: 'sqlite',
  databases: {
    postgres: {
      host: 'localhost',
      port: 5432,
      user: 'postgres',
      password: '123456',
      database: 'testing'
    },
    mysql: {
      host: 'localhost',
      port: 3306,
      user: 'root',
      password: '123456',
      database: 'schema_builder'
    },
    sqlite: { database: './schema_builder.db' }
  },
  skipColumns: [ 'created_at', 'updated_at', 'deleted_at' ],
  validationSchemaType: 'joi'
};
module.exports = schemaConfig;

Usage

The nodeSchema make-rules -t my_table -db mysql -c column1,column2 -st joi command generates validation rules for a specified database table and its columns. It creates a request validation file based on the chosen validation library (choices: "joi", "validatorjs", "vine"). The generated rules can be used to enforce data integrity and validate incoming requests in your application.

Options:

• -db, --database: Specify the type of database (e.g., "mysql", "postgres", "sqlite").
• -t, --table: Specify the name of the database table for which rules should be generated.
• -c, --columns: Specify the column names of the table to generate rules for.
• -st, --schema-type: Specify the type of schema to generate (default is "joi").
• -h, --help: Display help for the command.

Examples:

• Generate rules for a MySQL table named "users" with columns "id" and "name":

     npm run nodeSchema make-rules -t users -db mysql -c id,name

• Generate rules for a PostgreSQL table named "users" with a request validation file using "validatorjs":

  npm run nodeSchema make-rules -t users -db mysql -c id,name -st validatorjs

as same as for sqlite.

Let's say you've the table structure:

CREATE TABLE data_types (
    id INTEGER PRIMARY KEY,
    name TEXT,
    age INTEGER,
    height REAL,
    is_student BOOLEAN,
    birthdate DATE,
    registration_timestamp TIMESTAMP,
    description BLOB
    created_at TIMESTAMP,
    updated_at TIMESTAMP
);

Generate rules for a whole table

Now if you run:

  npm run nodeSchema make-rules -db sqlite -t data_types

You'll get:

🚀 Schema Base Validation rules for "joi" generated! 🚀
Copy and paste these rules into your validation location, such as controller, form request, or any applicable place 😊
______________________________________________________________________________________________________________________


{ 
  name: Joi.string().required(),
  age: Joi.integer().min(-9223372036854775808).max(9223372036854775807).required(),
  height: Joi.number().required(),
  is_student: Joi.required(),
  birthdate: Joi.date().required(),
  registration_timestamp: Joi.required(),
  description: Joi.required(), 
}

Generate rules for specific columns

You can also explicitly specify the columns:

npm run nodeSchema make-rules -db sqlite -t data_types -c name,age

Which gives you:

🚀 Schema Base Validation rules for "joi" generated! 🚀
Copy and paste these rules into your validation location, such as controller, form request, or any applicable place 😊
______________________________________________________________________________________________________________________

{ 
  name: Joi.string().required(),
  age: Joi.integer().min(-9223372036854775808).max(9223372036854775807).required(), 
}

Always skip columns

To always skip columns add it in the ".schema-config.js" file, under skipColumns attribute.

skipColumns: (process.env.SKIP_COLUMNS || 'created_at,updated_at,deleted_at').split(',')

Supported Drivers

Supported database drivers are MySQL, PostgreSQL, and SQLite.

Validation rules may vary based on the selected driver due to differences in supported data types and range specifications.

Testing

npm run test

👤 Md Tasmidur Rahman

• Linkedin: @tasmidur
• Github: @tasmidur
• Medium: @tasmidur

🤝 Contributing

Contributions, issues and feature requests are welcome!
Feel free to check issues page

Show your support

Give a ⭐️ if this project helped you!

License

The MIT License (MIT). Please see License File for more information.