AndresHerrera/geosura-test

GEOSURA test

GEOSURA-test

DEMO Web App

https://geosura-test.herokuapp.com/

Local installation

Requeriments

• Spring Boot - 2.2.6
• JDK - 1.8 or later
• Spring Framework - 5.2.5
• Hibernate
• JPA
• Apache Maven - 3.6
• PostgreSQL 10.2
• PostGIS 2.5

Clone this repo.

git clone https://github.com/AndresHerrera/geosura-test.git

cd geosura-test

Configuring Spring Boot to use PostgreSQL

Needed to configure postgresql connectivity into application.properties:

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
spring.jpa.hibernate.ddl-auto=none
spring.jpa.hibernate.show-sql=true
spring.datasource.url=jdbc:postgresql://localhost:5432/geosuradb
spring.datasource.username=postgres
spring.datasource.password=postgres

Create Database

CREATE DATABASE geosuradb;

Database Schema

CREATE TABLE IF NOT EXISTS public.vehicles(
  id SERIAL  NOT NULL ,
  lon double precision, 
  lat double precision,
  licence_plate VARCHAR(8)
 );	
 ALTER TABLE public.vehicles ADD CONSTRAINT vehicles_pk PRIMARY KEY(id);
 SELECT AddGeometryColumn('public','vehicles','the_geom',4326,'POINT',2);

Enable PostGIS Extension

CREATE EXTENSION IF NOT exists postgis;

Data samples

INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.53249,3.40570, 'AAA-000');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.50503,3.43372, 'BBB-111');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.51568,3.44997, 'CCC-222');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.49494,3.48135, 'DDD-333');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.52585,3.37757, 'EEE-444');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.53886,3.38145, 'FFF-555');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.54631,3.40942, 'GGG-666');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.51512,3.46005, 'HHH-777');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.52797,3.48456, 'III-888');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.46759,3.43351, 'OOO-089');
INSERT INTO public.vehicles(lon,lat,licence_plate) VALUES(-76.50262,3.39943, 'UUU-456');
UPDATE public.vehicles set the_geom = st_setsrid(st_makepoint(lon,lat),4326);

Compile and Run the application

mvn spring-boot:run

CRUD RESTFul API for vehicles

API Name	HTTP Method	Path	Status Code	Description
GET Vehicles	GET	/api/v1/vehicles	200 (OK)	All Vehicle resources are fetched
POST Vehicle	POST	/api/v1/vehicles	201 (Created)	A new Vehicle resource is fetched
GET Vehicle	GET	/api/v1/vehicles/{id}	200 (OK)	One vehicle resource is fetched
PUT Vehicle	PUT	/api/v1/vehicles/{id}	200 (OK)	Vehicle resource is updated
DELETE Vehicle	DELETE	/api/v1/vehicles/{id}	204 (No Content)	Vehicle resource is deleted

DEMO RESTFul API

https://geosura-test.herokuapp.com:8080/api/v1/

API Examples

Get all Vehicles REST API

• HTTP Method: GET
• Request URL: http://localhost:8080/api/v1/vehicles

curl --location --request GET 'http://localhost:8080/api/v1/vehicles' --data-raw ''

Create Vehicle REST API

• HTTP Method: POST
• Request URL: https://localhost:8080/api/v1/vehicles

curl --location --request POST 'http://localhost:8080/api/v1/vehicles' \
--header 'Content-Type: application/json' \
--data-raw '{
    "licencePlate": "BBB-666",
    "longitude": -76.50305,
    "latitude": 3.43372
}'

Get Vehicle by ID REST API

• HTTP Method: GET
• Request URL: http://localhost:8080/api/v1/vehicles/2

curl --location --request GET 'http://localhost:8080/api/v1/vehicles/2' \
--header 'Content-Type: application/json' \
--data-raw ''

Update Vehicle REST API

• HTTP Method: GET
• Request URL: http://localhost:8080/api/v1/vehicles/2

curl --location --request PUT 'http://localhost:8080/api/v1/vehicles/2' \
--header 'Content-Type: application/json' \
--data-raw '{"licencePlate":"MMM-999","longitude":-76.50503,"latitude":3.43372}'

Delete Vehicle REST API

• HTTP Method: DELETE
• Request URL: http://localhost:8080/api/v1/vehicles/1

curl --location --request DELETE 'http://localhost:8080/api/v1/vehicles/1' --data-raw ''

Screen shots

inspired on

[1] https://github.com/RameshMF/spring-boot-tutorial/tree/master/springboot2-postgresql-jpa-hibernate-crud-example