mysql-json
=========
Simple Node.js mysql module using mysql
Installation
npm install mysql-json
Declaration
var MysqlJson = ; var mysqlJson = options; // Takes mysql package options
Methods
All methods take a callback which is called with 2 parameters (err, response)
// Used to return a mysql connection mysqlJson;
// Used to launch a query to mysql server mysqlJson;
// Used to find a row by primary key mysqlJson;
// Used to insert a new row with JSON data mysqlJson;
// Used to update some row(s) matching with JSON conditions mysqlJson;
// Used to delete some row(s) matching with JSON conditions mysqlJson;
Condition Objects has to be build with this schema :
column1: operator:'=' value:'test' column2: operator:'>' value:29
Usage
// Initialization var MysqlJson = ; var mysqlJson = host:'127.0.0.1' user:'root' password:'root' database:'myDatabase' ;
// Query method mysqlJson;
// Find a document where Primary Key = 1 mysqlJson;
// Insert new document with login=root, firstname=John, lastName=Doe, Age=45 mysqlJson;
// Update any documents and set lastname=foo, age=47 where login=root mysqlJson;
// Delete any documents where login=root mysqlJson;
Contributing
In lieu of a formal styleguide, take care to maintain the existing coding style. Add unit tests for any new or changed functionality. Lint and test your code.
Release History
- 0.1.0 Initial release