var express = require('express');
var router = express.Router();
var co = require('co');
var thunkify = require('thunkify');
var crypto = require('crypto');


// ... post

var selectUserBase = function() {
  var query = "SELECT EXISTS(SELECT * FROM user_base WHERE user_email = '" + user_email + "')";
  var result = dbClient.query(query);
  var o = {};
  if (result._result.rowCount != null) {
    o.message = 'Email already exists.';
    o.existsInUserBase = true;
  } else {
    o.existsInUserBase = false;
  }

  return o;
}

var selectUserPendingBase = function() {
  var query = "SELECT EXISTS(SELECT * FROM user_pending_base WHERE user_pending_email = '" + user_email + "')";
  var result = dbClient.query(query);
  var o = {};
  if (result._result.rowCount != null) {
    o.message = 'Email send again.';
    o.existsInUserPendingBase = true;
  } else {
    o.message = 'Email send.';
    o.existsInUserPendingBase = false;
  }

  return o;
}

var generateToken = function() {
  var buf = crypto.randomBytes(48);
  var token = buf.toString('hex');

  return token;
}


// setTimeout(function() {

// }, 3000);

var selectUserBaseResult = selectUserBase();

if (selectUserBaseResult.existsInUserBase == true) {
  var teststr = selectUserBaseResult.message;
} else {
  var selectUserPendingBaseResult = selectUserPendingBase();
  var teststr = selectUserPendingBaseResult.message;

  var token = generateToken();
  teststr += token;
}


res.render('Register/Index', {
  teststr: teststr,
  partials: {
    Content: 'Register/Content',
  }
});

var selectUserBase = function() {
  var o = {};
  dbClient.popup_user.query(query, function(err, result) {
    if ...

    else ...

    return o;  ??
  });
});