Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
MySql data type validation
JavaScript
tag: 0.1.2

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
lib
test
.gitignore
LICENSE
README.md
package.json

README.md

MySql Validator

Validates web forms input against mysql database.

Installation

$ npm install mysql-validator

API

var validator = require('mysql-validator');

validator.check('doh winning!', 'varchar(45)', function (err) {
  if (err) {
    console.log(err.message);
  }
});

The first parameter is the posted input data and the second is the mysql data type of the field in your database.

Obtaining data types

The best way to pass the corresponding data type for your input field is to query the database for it.

describe `table-name`;

All you need to look for is the Type column. This is the string that the validator expects to see as a second parameter.

This will give you an idea of what object is constructed after the data type string have been parsed. This object is used internally by the validator.

$ mocha test/data-type.js

You can type in your data types manually without querying the database, just make sure you don't mess them up.

Express 3.x example

Suppose you have a form like this.

<form method="post" action="/save">
    <input type="text" name="name" />
    <input type="text" name="cache" />
    <input type="text" name="date" />
    <input type="submit" value="Save" />
</form>

Then your router may look like this.

app.post('/save', function (req, res) {
  // all submitted field names
  var keys = Object.keys(req.body);
  // we'll store all validation errors here
  var errors = [];
  // our handy field-type mapping (this may be the result of 'describe table')
  var types = {
    name: 'varchar(10)',
    cache: 'decimal(6,2) unsigned',
    date: 'datetime'
  }
  // loop through the submitted fields and validate them
  function loop (i, cb) {
    if (i == keys.length) return cb();
    validator.check(req.body[keys[i]], type[keys[i]], function (err) {
      // store the error's message and the field name
      if (err) errors.push({ name: keys[i], error: err.message });
      loop(++i, cb);
    });
  }
  loop(0, function () {
    if (errors.length) {
      // now that we have all errors we can notify the user about them
      res.render('template', { err: errors, other: 'params...' });
    } else {
      // we can safely store the user's input into the database
    }        
  });
});

Tests

Before you can run the tests you must create the test user and give him rights to the test database.

create user 'liolio'@'localhost' identified by 'karamba';
grant all on `mysql-validator`.* to 'liolio'@'localhost';

Then run this test.

$ mocha test/mysql.js

If it pass then you're good to go.

There are a various tests for each data type.

$ mocha test/index.js

The output is pretty verbose. The yellow column show what the test input is. The left column show what mysql store in it's database for this input. The right column show whether the validator think it should be valid or not.

Something went wrong with that request. Please try again.