Population reports App Complete

Live Application

The system is available for use at:
Population Reports Application

---

Features

The system generates the following types of reports:

Country Report

• All the countries in the world organised by largest population to smallest.
• All the countries in a continent organised by largest population to smallest.
• All the countries in a region organised by largest population to smallest.
• The top N populated countries in the world where N is provided by the user.
• The top N populated countries in a continent where N is provided by the user.
• The top N populated countries in a region where N is provided by the user.

Field	Description
Code	ISO country code
Name	Country name
Continent	Continent name
Region	Geographical region
Population	Total population
Capital	Capital city name

City Report

• All the cities in the world organised by largest population to smallest.
• All the cities in a continent organised by largest population to smallest.
• All the cities in a region organised by largest population to smallest.
• All the cities in a country organised by largest population to smallest.
• All the cities in a district organised by largest population to smallest.
• The top N populated cities in the world where N is provided by the user.
• The top N populated cities in a continent where N is provided by the user.
• The top N populated cities in a region where N is provided by the user.
• The top N populated cities in a country where N is provided by the user.
• The top N populated cities in a district where N is provided by the user.

Field	Description
Name	City name
Country	Country name
District	District name
Population	City population

Capital City Report

• All the capital cities in the world organised by largest population to smallest.
• All the capital cities in a continent organised by largest population to smallest.
• All the capital cities in a region organised by largest to smallest.
• The top N populated capital cities in the world where N is provided by the user.
• The top N populated capital cities in a continent where N is provided by the user.
• The top N populated capital cities in a region where N is provided by the user.

Field	Description
Name	Capital city name
Country	Country name
Population	Population of capital

Population Report

• The population of people, people living in cities, and people not living in cities in each continent.
• The population of people, people living in cities, and people not living in cities in each region.
• The population of people, people living in cities, and people not living in cities in each country.

Field	Description
Continent/Region/Country	Name of the entity
Total Population	Total population
Population in Cities	Number and percentage living in cities
Population Outside Cities	Number and percentage not living in cities

Additionally, the following information is accessible:

• The population of the world.
• The population of a continent.
• The population of a region.
• The population of a country.
• The population of a district.
• The population of a city.

Finally, the number of people who speak the following languages from greatest number to smallest, including the percentage of the world population is accessible:

• Chinese.
• English.
• Hindi.
• Spanish.
• Arabic.

---

v0.2.0

What's Changed

• chore: upload use-cases by @Shvoruk in #12
• add missing changes to dev by @Shvoruk in #52
• final version, both containers start up, app connects to a db. by @Shvoruk in #53

Full Changelog: v0.1.0...v0.2.0

v0.1.0

🚀 First Release - Version 0.1.0

Overview
This is the first official release of the Spring Boot application. The application runs inside a Docker container and connects seamlessly to a MySQL database, also running in Docker, through a defined Docker network. Continuous Integration (CI) has been successfully integrated with GitHub Actions to automate the build and testing process.

Key Features:

Dockerized Spring Boot Application:

The application is containerized and packaged using Docker for ease of deployment and scalability.
The Dockerfile sets up the Spring Boot application to run in a lightweight Java 17 JDK Alpine environment.

MySQL Database Integration:

The application connects to a MySQL database, also running in a Docker container.

Network Configuration:

Docker Compose manages the containers, ensuring that the app and database can communicate over a shared network.

GitHub CI Integration:

A GitHub Actions workflow has been set up to automatically build and test the application on every push to the repository.
The workflow uses Maven to package the Spring Boot app and Docker Compose to run integration tests.
Database and app services are run in detached mode (docker-compose up -d) to allow for continuous testing.