How to Use the Local API

This section explains how to access and test the product management API using two approaches: directly through the H2 database or via HTTP requests.

Accessing the H2 database

The project uses an in-memory H2 Database, which allows you to view and manipulate data directly through the browser.

Steps to access:

1. Open your browser and go to:
   http://localhost:8080/h2-console

2. Configure the connection:

• JDBC URL: jdbc:h2:mem:testdb
• Username: sa
• Password: (leave empty)

3. Click on "Connect".

4. You can run SQL queries directly, for example:

INSERT INTO PRODUTO (PRECO, NOME) VALUES ('Teclado', 50)

5. Select data:

SLECT * FROM PRODUTO;

6. Query a specific product by ID:

SLECT * FROM PRODUTO id = 1;

7. Update data:

UPDATE PRODUTO SET PRECO = 4000.00 WHERE id = 1;

8. Delete data:

DELETE FROM PRODUTO WHERE id = 1;

How to Use the Web API

Access the URL

The web API is hosted on Azure, and you can interact with it by making HTTP requests to the provided endpoints.

URL Azure

1. Azure https://ca-bootcamp-gmcpg9ggcddbhug3.brazilsouth-01.azurewebsites.net

2. Swagger https://ca-bootcamp-gmcpg9ggcddbhug3.brazilsouth-01.azurewebsites.net/swagger-ui.html