1.1.2 • Published 10 years ago
aa-mysql v1.1.2
A simple and flexible MySql library for node.
Installation
$ npm install aa-mysql
Usage
// insert amoa400
conn.table('user').insert({name: 'amoa400'});
// find amoa400
conn.table('user').where({name: 'amoa400'}).find();
// rename amoa400 to cai0715
conn.table('user').where({name: 'amoa400'}).update({name: 'cai0715'});
// delete cai0715
conn.table('user').where({name: 'cai0715'}).delete();
// select users whose id is less than 2 or greater than 3, limit 10
conn.table('user').where({id: [2, '<']}, {id: [3, '>']}, 'OR').limit(10).select();
Example
var aamysql = require('aa-mysql');
// config
aamysql.config({
host: 'localhost',
port: 3306,
user: 'root',
pass: '',
prefix: 'aa_',
db: 'aa-mysql',
connLimit: 20
});
// use single connection to query
// you can also use connection pool, and it is recommended
var conn = aamysql.create();
conn.connect(function(err) {
if (err) {
console.log(err);
return;
}
// select
conn.table('user').select(function(err, res) {
if (err) {
console.log(err);
return;
}
console.log(res);
});
// transaction
conn.transaction([
conn.table('user').option({get: true}).insert({name: 'amoa400'}),
conn.table('user').option({get: true}).insert({id: 'hi', name: 'cai0715'})
// will cause rollback, because id must be number
], function(err, res) {
if (err) {
console.log(err);
return;
}
console.log(res);
});
});
Dependency
Docs
Users
1.1.2
10 years ago
1.1.1
10 years ago
1.1.0
10 years ago
1.0.9
10 years ago
1.0.7
11 years ago
1.0.6
11 years ago
1.0.5
11 years ago
1.0.4
11 years ago
1.0.3
11 years ago
1.0.2
11 years ago
1.0.1
11 years ago
1.0.0
11 years ago
0.1.6
11 years ago
0.1.5
11 years ago
0.1.4
11 years ago
0.1.3
11 years ago
0.1.2
11 years ago
0.1.1
11 years ago
0.1.0
11 years ago