'user strict';
var sql = require('./../db.js');

//User object constructor
var User = function(user){
    this.email = user.email;
    this.name = user.name;
    this.gender = user.gender;
    this.profileImageType = user.profileImageType;
    this.profileImage = user.profileImage;
    this.accountType = user.accountType;
    this.createdAt = new Date();
};
User.getCountByEmail = function (email, result) {
    console.log("entering user.getCountByEmail with")
    console.log(email)
        sql.query("Select COUNT(*) AS userCount from users where email = ? ", email, function (err, res) {
                if(err) {
                    console.log("error: ", err);
                    return result(err, null);
                }
                else{
                    console.log("user getCountByEmail returns")
                    console.log(res)
                    return result(null, res);
                }
            });
};

'use strict';

var User = require('./user.js');

exports.list_all_users = function(req,res){
    User.getAll(function(err,user){
        console.log('controller')
        if (err){
            res.send(err);
        }else{
            console.log('res', user)
            res.send(user)
        }
    });
};
exports.getCountByEmail = function(email,res){
    User.getCountByEmail(email, function(err,user){
      if (err){
          console.log('error', err)
          return res.send(err)
      }else{
          console.log('res', user)
          console.log(user)
          return user;
      }
    });
};

var userController = require('./../model/userController.js');
      userController.getCountByEmail("miow@email.com",res,function(err,result) {
        if (err){
          console.log("34 err")
          console.log(err)
        }else{
          console.log("imin userCount: " + result)
        }
      });

function(err,result) {
            if (err){
              console.log("34 err")
              console.log(err)
            }else{
              console.log("imin userCount: " + result)
            }

res [ RowDataPacket { userCount: 1 } ]
imin
[ RowDataPacket { userCount: 1 } ]