mysql-easy-model
MySQL Easy Model is a MySQL object modeling tool designed to work in an asynchronous environment.
Installation
Install from npm package:
npm install mysql-easy-model
Or install from git:
npm install git://github.com/rudolfoborges/mysql-easy-model.git
Usage
Connecting to MySQL
First, we need to define a connection.
var mysqlEasyModel = ; mysqlEasyModel;
Defining a Model
Models are defined through the name and options object. var User = mysqlEasyModel.model(name, options)
var User = mysqlEasyModel;
Accessing a Model
After define a model, we can access it through the same function. The argument is the name of the your model.
var User = mysqlEasyModel;
Find
Model.find(selector, callback) Selector and callback are optional.
User
Find with filter
Model.find(selector, callback) Selector and callback are optional.
User
Read a model
model.load(callback) Callback is optional.
var user = ;userid = 1;user;
Find with dynamic query
Model.query(sql, params, callback)
User;
Create a new Model
var user = name: 'John Smith' email: 'js@gmail.com';user;
Find one and update
User;
Update without find
You can set the primary key value and update without finding.
var user = id: 1 name: 'John Smith';user;
or
var user = ;userid = 1;username = 'John Smith';user;
Find one and destroy
User;
Destroy without find
You can set the primary key value and delete without finding
var user = id: 1;user;
or
var user = ;userid = 1;user;
Examples
Contains runnable sample mysql-easy-model programs.
Bugs
If you'd like to leave feedback, please open an issue on GitHub.
License
mysql-easy-model is released under MIT license.
Credits
mysql-easy-model was created by Rudolfo Borges.