text: const connection = require('../database/connection');
  
  module.exports = {
  	async index(request, response) {
  		const { page = 1 } = request.query;
  
  		const [count] = await connection('incidents').count();
  
  
  		const incidents = await connection('incidents')
  		.join('ongs', 'ongs.id', '=', 'incidents.ong_id')
  		.limit(5)
  		.offset((page - 1) * 5)
  		.select(['incidents.*', 
  			'ongs.name',
  			'ongs.email',
  			'ongs.whatsapp',
  			'ongs.city',
  			'ongs.uf'
  		]);
  
  		response.header('X-Total-Count', count['count(*)'])
  		
  		return response.json(incidents);
  	},
  	
  	async create(request, response) {
  		const { title, description, value } = request.body;
  		const ong_id = request.headers.authorization;
  		
  		const [id] = await connection('incidents').insert({
  			title,
  			description,
  			value,
  			ong_id,
  		});
  		
  		return response.json({ id });
  	},
  	
  	async delete(request, response){
  		const { id } = request.params;
  		const ong_id = request.headers.authorization;
  		
  		const incident = await connection('incidents')
  		.where('id', id)
  		.select('ong_id')
  		.first();
  		
  		if(incident.ong_id !== ong_id) {
  			return response.status(401).json({ error: 'Operation not permitted.' });
  		}
  		
  		await connection('incidents').where('id', id).delete();
  		
  		return response.status(204).send();
  	}
  };