import BaseController from '../../base/BaseController';
import models from '../../models/sql';

class UserController extends BaseController {

  /**
   * Define your routes in this action.
   * The middlewares can be defined inside `flows`
  */
  get actions(){
    return [
      /** 
       * GET /users
       * #query 
       * Add query middleware at this route. 
       * Url will be converted into sequelize query that can be accessed via `req.dbQuery`
       * If query error the error value can be accesed via `req.err`
       * 
       * #respose
       * Wrap response object into exseq's response format
      */
      {method: 'GET', endpoint: '/', 
        flows: ['query', 'getUsers', 'response']},

      /** 
       * GET /users/:id
       * #respose
       * Wrap response object into exseq's response format
      */
      {method: 'GET', endpoint: '/:id', 
        flows: ['getUser', 'response']},
      
      /** 
       * POST /users
       * #bodyValidation
       * Check request json body is empty or not. If empty return error message that can be accessed via `req.err`
       * 
       * #respose
       * Wrap response object into exseq's response format
      */
      {method: 'POST', endpoint: '/', 
        flows: ['bodyValidation', 'addUser', 'response']},

      /** 
         * PUT /users/:id
         * #bodyValidation
         * Check request json body is empty or not. If empty return error message that can be accessed via `req.err`
         * 
         * #respose
         * Wrap response object into exseq's response format
        */
      {method: 'PUT', endpoint: '/:id', 
        flows: ['bodyValidation', 'updateUser', 'response']},
      
  /** 
       * DELETE /users/:id
       * #respose
       * Wrap response object into exseq's response format
      */
      {method: 'DELETE', endpoint: '/:id', 
        flows: ['removeUser', 'response']},
    ];
  }

  async getUsers(req, res, next){
    if(res.err) // if error show the error message
      return next();

    /**
     * #query 
     * You can use sequelize query here via `req.dbQuery`
    */
    const users = await models.User.findAll(req.dbQuery);
    /**
     * #response
     * Wrap your json response into exseq's json format by pass data value into `res.results`
    */
    res.results = users; 
    res.status(200);
    next();
  }

  async getUser(req, res, next){
    if(res.err) // if error show the error message
      return next();

    const user = await models.User.findById(req.params.id);
    if(!user){
      /** 
       * #response
       * If you want throw error, you should overwrite error response at `response middleware` by pass value into `res.errorCode`
       * default value set on `./config/setting.json`
      */
      res.errorCode = 404; 
      throw Error('Not found'); // throw error, show error message
    }
    /**
     * #response
     * Wrap your json response into exseq's json format by pass data value into `res.results`
    */
    res.results = user;
    res.status(200);
    next();
  }

  async addUser(req, res, next){
    if(res.err) // if error show the error message
      return next();

    const [data, isCreated] = await models.User.findOrCreate({
      where: req.body,
      default: req.body
    });
    /**
     * #response
     * Wrap your json response into exseq's json format by pass data value into `res.results`
    */
    res.results = data,
    res.status(200);
    if(isCreated)
      res.status(201);
    next();
  }

  async updateUser(req, res, next){
    if(res.err) // if error show the error message
      return next();

    const affected = await models.User.update(
      req.body,
      {where: {id: req.params.id}}
    );
    /**
     * #response
     * Wrap your json response into exseq's json format by pass data value into `res.results`
     * `affected` is integer
    */
    res.results = affected;
    res.status(200);
    next();
  }

  async removeUser(req, res, next){
    if(res.err) // if error show the error message
      return next();
    
    const affected = await models.User.destroy({
      where: {id: req.params.id}
    });
    /**
     * #response
     * Wrap your json response into exseq's json format by pass data value into `res.results`
     * `affected` is integer
    */
    res.results = affected;
    res.status(200);
    next();
  }

}

export default {path: '/users', router: new UserController().router};

{
  // format for date range query at query url
  "dateFormatUrl": "YYYY-MM-DD_HH:mm:ss",
  "dateFormat": "YYYY-MM-DD HH:mm:ss",
  
  // resource path index is used by `response` middleware
  // eg: localhost:3000/<<resource>> => resourcePath: 1
  // if you want to change your endpoint to: 
  // eg: localhost:3000/api/v1/<<resource>> => change resourcePath to `resourcePath: 3`
  "resourcePath": 1,
  "defaultErrorCode": 500
}