// register
// POST
var registerPost = function(req, res, next) {
   var user = req.body;
   var usernamePromise = null;
   usernamePromise = new Model.User({username: user.username}).fetch();

   return usernamePromise.then(function(model) {
      if(model) {
         res.render('register', {title: 'register', errorMessage: 'username already exists'});
      } else {
         //****************************************************//
         // MORE VALIDATION GOES HERE(E.G. PASSWORD VALIDATION)
         //****************************************************//
         var password = user.password;
         var hash = bcrypt.hashSync(password);

         var apiKey = user.apiKey;

         var registerUser = new Model.User({username: user.username, password: hash, apiKey: user.apiKey});

         registerUser.save().then(function(model) {
            // sign in the newly registered user
            signInPost(req, res, next);
         });
      }
   });
};

usernamePromise = new Model.User({username: user.username}).fetch();

var DB = require('./db').DB;

var User = DB.Model.extend({
   tableName: 'sotlUsers',
   idAttribute: 'userId',
});

module.exports = {
   User: User
};

var Bookshelf = require('bookshelf');

var config = {
   host: 'localhost',
   user: 'root',
   password: 'password',
   database: 'database',
   charset: 'UTF8_GENERAL_CI'
};

var DB = Bookshelf.initialize({
   client: 'mysql',
   connection: config
});

module.exports.DB = DB;