favorite.js

var express = require('express')
, _ = require('underscore')
, sqlHelper = require("../lib/sqlHelper");

exports.create = function(req,res) {
  res.set('Content-Type', 'text/json');
  if(sqlHelper.requestHas(req.body,["fUserID"])) {
    clientPool.acquire(function(err,mysql) {
      if(err){
        console.log(err);
        res.send(500);
        return false;
      }
      sqlHelper.insert(mysql,"favorite",{userID:req.session.userID,fUserID:req.body.fUserID},function(err,results) {
        if(err){
          console.log(err);
          res.send(500);
          clientPool.releaseConnection(mysql);
          return false;
        }
        res.send({status:"success"});
      });
    });
  } else {
    res.send(500,"bad request");
  }
}

exports.delete = function(req,res) {
  res.set('Content-Type', 'text/json');
  if(sqlHelper.requestHas(req.body,["favoriteID"])) {
    clientPool.acquire(function(err,mysql) {
      if(err){
        console.log(err);
        res.send(500);
        return false;
      }
      sqlHelper.delete(mysql,"favorite",{favoriteID:req.body.favoriteID},function(err) {
        if(err){
          console.log(err);
          res.send(500);
          clientPool.releaseConnection(mysql);
          return false;
        }
        res.send({status:"success"});
      });
    });
  } else {
    res.send(500,"bad request");
  }
}

exports.list = function(req,res) {
  res.set('Content-Type', 'text/html');
  clientPool.acquire(function(err,mysql) {
    if(err){
      console.log(err);
      res.send(500);
      return false;
    }
    mysql.query(
      "SELECT * FROM `favorite`,`user` WHERE `favorite`.`userID` = ? AND `favorite`.`fUserID` = `user`.`userID` ",
      [req.session.userID],
      function(err,users){
        if(err){
          console.log(err);
          res.send(500);
          clientPool.releaseConnection(mysql);
          return false;
        }
        clientPool.releaseConnection(mysql);
        res.render("favorites",{
          _:_,
          users:users
        });
      }
    );
  });
}