Skip to content

Instantly share code, notes, and snippets.

@csandeep
Created June 30, 2015 17:03
Show Gist options
  • Save csandeep/cda440882f4324a63d41 to your computer and use it in GitHub Desktop.
Save csandeep/cda440882f4324a63d41 to your computer and use it in GitHub Desktop.
sqlizer_test
var sqlizr = require('sqlizr');
var Sequelize = require('sequelize');
var passportLocalSequelize = require('passport-local-sequelize');
var sequelize = new Sequelize("sqlizer_test","","",{
dialect: 'sqlite',
storage: './sqlizer_test.sqlite3'
}
);
// /*
var db = sqlizr(sequelize, 'models/**/*.js')
var User = db.User;
// */
// uncomment this block , comment out the above block and the User.authenticate() works
/*
var User = passportLocalSequelize.defineUser(sequelize, {
favoriteColor: Sequelize.STRING
});
*/
sequelize
.sync({ force: true })
.then(function(err) {
//passport-local-sequelize will
User.authenticate()("test@example.com", "password", function (err, user, message) {
console.log('It worked!');
if (err) {
console.error(err);
return;
}
if (user) {
consle.log(user);
}
});
}, function (err) {
console.log('An error occurred while creating the table:', err);
});
var passportLocalSequelize = require('passport-local-sequelize');
module.exports = function(sequelize, DataTypes) {
var User = passportLocalSequelize.defineUser(sequelize, {
favoriteColor: Sequelize.STRING
});
return User;
};
{
"name": "sqlizer_test",
"version": "1.0.0",
"description": "Testing SQLizer",
"main": "index.js",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1"
},
"author": "",
"license": "ISC",
"dependencies": {
"passport-local-sequelize": "^0.6.0",
"sequelize": "^3.3.2",
"sqlite3": "^3.0.8",
"sqlizr": "^1.1.0"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment