This is the 7º tutorial of a complete series of building a production “NodeJS API using Express, MySQL and Sequelize”.

Full source code of this class is available at GitHub Martial Arts API Part 7

EDITING OUR ROUTE

First of all, we will simply edit our rote so it handle every case of CRUD (Create, Read, Read By Id, Update, Delete). Each request will call a specific method in our controller.

If you forgot our drawing, you check it again to remember how helpful it is.

EDITING OUR CONTROLLER

Before editing our controller we just need to understand where the body, query, parameters and another…

This is the 6º tutorial of a complete series of building a production “NodeJS API using Express, MySQL and Sequelize”.

Full source code of this class is available at GitHub Martial Arts API Part 6

SETTING UP MYSQL

Before starting, we will configure our MySQL database. As this is not a MySQL tutorial, we will not go deep on this subject, if you have any problems I suggest you to take a course or just google your error.

This is the 5º tutorial of a complete series of building a production “NodeJS API using Express, MySQL and Sequelize”.

Full source code of this class is available at GitHub Martial Arts API Part 5

UNDERSTANDING THE PROBLEM

Our project is not too big, but we already have 36 lines and a single endpoint. In a real application where we could have +100 endpoints our app.js would be a really mess.

To avoid that we will structure our app in Models/Controllers/Routes. In the most informal way these will mean.

Model: A representation of our table columns.

Routes: This will tell…

This is the 4º tutorial of a complete series of building a production “NodeJS API using Express, MySQL and Sequelize”.

Full source code of this class is available at GitHub Martial Arts API Part 4

This particular class is thanks to Academind Building a Restful API with NodeJS. Awesome teacher! :)

ADDING HEADER MIDDLEWARE

Another thing that will be great in our project is to add some configuration headers to our application. To do so, we need to add it using express middleware, otherwise, we would need to add the same headers to every single request.

CONCLUSION

If you want to go deeper on this subject I recommend you to watch Parsing the Body & Handling CORS | Creating a REST API with Node.js.

Full source code of this class is available at GitHub Martial Arts API Part 4

This is the 3º tutorial of a complete series of building a production “NodeJS API using Express, MySQL and Sequelize”.

Full source code of this class is available at GitHub Martial Arts API Part 3

UNDERSTANDING THE PROBLEM

As you could see in the past tutorials, if you type localhost:8000/dojos you will get a JSON Object with one dojo (gym).

But if you type localhost:8000/ , localhost:8000/students or any other endpoint you will not get a meaningfull response.

It would be good to send Not Found to the user in case he typed something we do not support, for that we are going…

This is the 2º tutorial of a complete series of building a production “NodeJS API using Express, MySQL and Sequelize”.

Full source code of this class is available at GitHub Martial Arts API Part 2

RETURNING SOME JSON DATA

Now we will return some data in our server, for that you just need to modify a bit your app.js file so it will look like this.

If you restart your server using Ctrl+C (to exit) and then node app.js (to start). Go to your browser and type http://localhost:8000/dojos .

This is the 1º tutorial of a complete series of building a production “NodeJS API using Express, MySQL and Sequelize”.

Full source code of this class is available at GitHub Martial Arts API Part 1

Before we begin you should install the following things on your computer.

• Visual Studio Code
• NodeJS or How to install NodeJS MacOS or How to install NodeJS Windows
• MySQL for windows or MySQL for MacOS

If you get stuck in any of the installation you can google it to keep going with the tutorial.

NOTE: This tutorial will cover all the API being built based…

Incluir exportação para o Excel no seu software é uma máquina muito poderosa e rápida. Para o seu cliente que gosta de Excel é só ele exportar e continuar trabalhando por lá se quiser acrescentar algo.

Direto para o Código

No código vou utilizar TFDQuery e TDBGrid porém você pode fazer o mesmo com qualquer TClientDataSet ou outra maneira que você está utlizando.

1. Uses clauses

A principais uses clauses são:

uses
  System.Win.ComObj, Vcl.DBGrids, FireDAC.Comp.Client, Datasnap.DBClient ...;

Para o Excel é apenas a ComObj , as outras são para os dados.

2. Criar o Objeto

Esse código cria o Objeto Excel.Application e adiciona a primeira página do excel.

procedure GerarExcel(AQuery: TFDQuery)…