Skip to content

Instantly share code, notes, and snippets.

@Jigarsolanki
Jigarsolanki / routes.js
Created December 8, 2012 20:41
A file that maps urls to the controller
var authHandler = require('./handlers/auth'),
petHandler = require('./handlers/pet');
exports.init = function (app) {
app.post('/auth', authHandler.generateToken);
app.post('/pet', authHandler.authorize, petHandler.addPet);
};
@Jigarsolanki
Jigarsolanki / auth.js
Created December 8, 2012 20:42
user/auth handler
exports.generateToken = function(req, res) {
var username, password;
username = req.param('username');
password = req.param('password');
if(username === 'foo' && password === 'bar') {
res.send(200, {'token': "ABC123"});
} else {
exports.addPet = function (req, res) {
//Do something to save the data for a new pet
res.send(200, {'result': 'success'});
}
var Sequelize = require('sequelize');
var sequelize = new Sequelize('userpets', 'dbuser', 'dbpassword', {
host: 'localhost', //mysql host name
port: 3306 //default mysql port
});
var User = sequelize.define(
'User',
{
@Jigarsolanki
Jigarsolanki / model.js
Created December 9, 2012 06:21
Try adding record without sync
var Sequelize = require('sequelize');
var sequelize = new Sequelize('userpets', 'dbuser', 'dbpassword', {
host: 'localhost', //mysql host name
port: 3306 //default mysql port
});
var User = sequelize.define(
'User',
{
@Jigarsolanki
Jigarsolanki / terminal.log
Created December 9, 2012 06:24
error without syncing db
Executing: INSERT INTO `Users` (`firstName`,`lastName`,`password`,`numberOfPets`,`id`,`createdAt`,`updatedAt`) VALUES ('foo','bar','asdfasdf',0,NULL,'2012-12-09 01:20:25','2012-12-09 01:20:25');
Error: ER_NO_SUCH_TABLE: Table 'userpets.users' doesn't exist
@Jigarsolanki
Jigarsolanki / model.js
Created December 9, 2012 06:27
adding sync
var Sequelize = require('sequelize');
var sequelize = new Sequelize('userpets', 'dbuser', 'dbpassword', {
host: 'localhost', //mysql host name
port: 3306 //default mysql port
});
var User = sequelize.define(
'User',
{
mysql> select * from Users;
+-----------+----------+----------+--------------+----+---------------------+---------------------+
| firstName | lastName | password | numberOfPets | id | createdAt | updatedAt |
+-----------+----------+----------+--------------+----+---------------------+---------------------+
| foo | bar | asdfasdf | 0 | 1 | 2012-12-09 01:30:15 | 2012-12-09 01:30:15 |
+-----------+----------+----------+--------------+----+---------------------+---------------------+
2 rows in set (0.00 sec)
@Jigarsolanki
Jigarsolanki / model.js
Created December 9, 2012 06:53
sync in async way
var Sequelize = require('sequelize');
var sequelize = new Sequelize('userpets', 'dbuser', 'dbpassword', {
host: 'localhost', //mysql host name
port: 3306 //default mysql port
});
var User = sequelize.define(
'User',
{
@Jigarsolanki
Jigarsolanki / model.js
Created December 9, 2012 07:18
Pet definition
// ......
var Pet = sequelize.define(
'Pet',
{
name: { type: Sequelize.STRING },
type: { type: Sequelize.STRING }
}
);