Mysql-active-record NPM

mysql-active-record

Introduction

This is an abstraction framework that leverages the node-mysql module for node.js. It was inspired by CodeIgniter's ActiveRecord class for building SQL queries - former PHP developers will likely recognize this.

Completely written in JavaScript, does not require compiling, and is 100% MIT licensed.

Here is an example on how to use it:

Installation

$ npm install mysql-active-record

Usage

var MysqlActiveRecord = require('mysql-active-record');

var config = {
  host: 'localhost',
  user: 'user',
  password: 'password',
  database: 'database_name'
}

//confirm connection
var activeRecord = new MysqlActiveRecord(config);

//will produce SELECT * FROM table1;
activeRecord.get('table1', function(results) {
  if (!results.error) {
    if (results.numResults > 0) {
        console.log(results.rows); // actual records
        console.log(results.fields); //fields returned
        console.log(results.numResults); //number of results
        console.log(results.queryExecuted); //sql statement executed
    } else {
        console.log(results.queryExecuted);
    }
  } else {
        console.log(results.error); //any errors returned
        console.log(results.queryExecuted);
  }

});

Note:

config options are the same as the ones passed into the node-mysql module
connection is implicitly created when a query is run and ended immediately after.