var User;
module.exports = User = require('sand-mysql-simple').Model.extend({
table: 'user',
values: function() {
return {
user_id: 1,
email_address: 'test@test.com'
}
},
getById: function(id, callback) {
sand.mysqlSimple.models.User.global().selectRow('user_id', id, function(err, row) {
if (err) {
return callback(err);
}
var userModel = sand.mysqlSimple.models.User.global().createFromRow(row);
callback(null, userModel);
});
},
save: function(callback) {
var insert = this.getInsert();
sand.mysql.query(insert.query, insert.values, function(err, result) {
if (err) {
return callback(err);
}
callback(null, result);
});
},
createFromRow: function(row) {
var user = new User;
user.id = row.user_id;
user.email = row.email_address;
return user;
}
});
var mysqlSimple = require('sand-mysql-simple');
var sand = require('sand')();
sand
.use(mysqlSimple, {modelsPath: __dirname + '/models'})
.start();
var myUserId = 1;
sand.mysqlSimple.models.User.getById(myUserId, sand.log);