"use strict";

var Hapi = require('hapi');
var Bcrypt = require('bcryptjs');
var Boom = require('boom');
var Joi = require('joi');
var mysql = require('mysql');
var async = require('async');
const fs = require('fs');
var BasicAuth = require('hapi-auth-basic');
var options = require('../config/config.js');


//mysql connection
var connection = mysql.createConnection({
    host: options.host,
    user: options.user,
    password: options.password,
    database: options.database,
    port: options.port

});

if (process.env.JAWSDB_URL) {
    connection = mysql.createConnection(process.env.JAWSDB_URL);
}

connection.connect();

function rowsToJS(theArray) {
    var temp = JSON.stringify(theArray);
    temp = JSON.parse(temp);
    //console.log(temp);
    return temp;
}

module.exports.searchResources = {
    handler: function(request, reply) {
            getQueryAndReturnResults("resources", request, (err, results) => {
                if (err) { return reply(Boom.badRequest("error getting query and returning results from resources")); }
                return reply(results);
            });
        } //end handler
};

function getQueryAndReturnResults(whichTable, request, callback) {

	//receiving in body:
	/*

	{
		"query": "<query_text_here>"
	}

	*/

	var query = connection.query(`SELECT * FROM ${whichTable} WHERE name = ?`, [request.payload.query], (err, rows, fields) => {
		if (err) { return callback(true, null); }
		if (rows.length <= 0) { return callback(true, null); }
		//1. Stem query


		//2. Get name, author, type, website, description, paren (no JSON cols for now) from ALL APPROVED resources

		//3.

	});


	//do stuff
	//...
	return callback(null, toReturn);
}