NextLevelWeek

PointsController.ts

import {Request, Response} from 'express';
import knex from '../database/connection';

class PointsController {
    async create (request: Request, response: Response)  {
        const {
            name,
            email,
            whatsapp,
            latitude,
            longitude,
            city,
            uf,
            items
        } = request.body;
    
        const trx = await knex.transaction();

        const point = {
            image: 'image-fake',
            name,
            email,
            whatsapp,
            latitude,
            longitude,
            city,
            uf
        }
    
        const insertIds = await trx('points').insert(point);
    
        const point_id = insertIds[0];
    
        const pointItems = items.map((item_id: Number) => {
            return {
                item_id,
                point_id,
            }
        })
    
        await trx('point_items').insert(pointItems);
    
        return response.json({
            id:point_id,
            ...point, });
    }

};

export default PointsController;

routes.ts

import express, { request, response } from 'express';
import knex from './database/connection';

import PointsController from './controllers/PointsController';

const routes = express.Router();
const pointsController = new PointsController();

routes.get('/items', async (request, response) => {
    const items = await knex('items').select('*');


    const serializedItems = items.map(item => {
        return {
            id : item.id,
            title: item.title,
            image_url: `http://localhost:3333/uploads/${item.image}`,
        };
    })

    return response.json(serializedItems);
});

routes.post('/points', pointsController.create);

export default routes;