/Cities-API

API Rest de consulta de cidades do Brasil com dados comparativos calculando a distância entre cidades. Feito durante o bootcamp EverisQA na plataforma DigitalInnovationOne | Java/Spring/Postgre.

Primary LanguageJava

Cities API

Requisitos

  • Linux
  • Git
  • Java 8
  • Docker
  • IntelliJ Community
  • Heroku CLI
  • Travis CLI

DataBase

Postgres

Rode esse container.
docker run --name cities-db -d -p 5432:5432 -e POSTGRES_USER=postgres_user_city -e POSTGRES_PASSWORD=super_password -e POSTGRES_DB=cities postgres

Inserindo dados no Postgres.

cd ~/workspace/sql-paises-estados-cidades/PostgreSQL

docker run -it --rm --net=host -v $PWD:/tmp postgres /bin/bash

psql -h localhost -U postgres_user_city cities -f /tmp/pais.sql
psql -h localhost -U postgres_user_city cities -f /tmp/estado.sql
psql -h localhost -U postgres_user_city cities -f /tmp/cidade.sql

psql -h localhost -U postgres_user_city cities

CREATE EXTENSION cube; 
CREATE EXTENSION earthdistance;

Acesso

docker exec -it cities-db /bin/bash

psql -U postgres_user_city cities

Query Calculo de distância

Point

select ((select lat_lon from cidade where id = 4929) <@> (select lat_lon from cidade where id=5254)) as distance;

Cube

select earth_distance(
    ll_to_earth(-21.95840072631836,-47.98820114135742), 
    ll_to_earth(-22.01740074157715,-47.88600158691406)
) as distance;

Heroku

heroku create dio-cities-api --addons=heroku-postgresql

extra