/cities
/countries
/countries/{id}
/states
/distances/by-cube
/distances/by-points
- Spring Initializr
- Project: Gradle Project
- Language: Java
- Spring Boot: 2.4.1
- Group: com.github.lucasrmagalhaes
- Artifact: cities-api
- Name: cities-api
- Description: Demo Project for Spring Boot
- Package name: com.github.lucasrmagalhaes.cities-api
- Packaging: Jar
- Java: 8
- Spring Web
- Spring Data JPA
- PostgreSQL Driver
docker pull postgres
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
git clone git@github.com:chinnonsantos/sql-paises-estados-cidades.git
cd sql-paises-estados-cidades/
cd PostgreSQL/
cd ~/workspace/sql-paises-estados-cidades/PostgreSQL
winpty docker run -it --rm --net=host -v $PWD:/tmp postgres /bin/bash
docker run -it --rm --net=host -v c:\Users\Lucas\Desktop\Workspace\cities_api-java\sql-paises-estados-cidades\PostgreSQL:/tmp postgres /bin/bash
psql -h localhost -U postgres_user_city cities
\d pais;
select * from pais;
http://localhost:8080/countries
http://localhost:8080/countries?page=0&size=10&sort=name,asc
http://localhost:8080/countries?page=0&size=10&sort=name,desc
http://localhost:8080/countries?page=0&size=50&sort=id,asc
http://localhost:8080/countries/1
http://localhost:8080/countries/255
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
\d cidade;
select * from cidade;
select * from estado;
\d estado;
http://localhost:8080/states
\d cidade;
http://localhost:8080/cities
CREATE EXTENSION cube;
CREATE EXTENSION earthdistance;
select ((select lat_lon from cidade where id = 4929) <@> (select lat_lon from cidade where id=5254)) as distance;
select lat_lon from cidade where id=5254;
select earth_distance(
ll_to_earth(-21.95840072631836,-47.98820114135742),
ll_to_earth(-22.01740074157715,-47.88600158691406)
) as distance;
http://localhost:8080/distances/by-points?from=4929&to=5254
http://localhost:8080/distances/by-cube?from=4929&to=5254
heroku create
git remote -v
git push heroku master
heroku addons:create heroku-postgresql
docker run -it --rm --net=host -v c:\Users\Lucas\Desktop\cities_api-java\sql-paises-estados-cidades\PostgreSQL:/tmp postgres /bin/bash
psql -h host -U user database -f /tmp/pais.sql
psql -h host -U user database -f /tmp/estado.sql
psql -h host -U user database -f /tmp/cidade.sql
psql -h host -U user database
CREATE EXTENSION cube;
CREATE EXTENSION earthdistance;
heroku logs --tail
git push heroku master