v0.3.0

Commits

• da94373: Add files via upload (40728714)
• f225feb: Add files via upload (40728714)
• ab44512: Merge branch 'feature/8-population-by-geography' of https://github.com/ikindadoesstuff/WorldStatistics into feature/8-population-by-geography (Devyon Lozano)
• e5f9efb: Delete sql files (Devyon Lozano)
• c25db3b: Update pom.xml version (Devyon Lozano)
• 659fc46: Update getColumnString in Urbanization record (Devyon Lozano)
• f0db69d: Merge remote-tracking branch 'origin/feature/7-urbanization' into develop (Devyon Lozano)
• d2a39ff: Add Population DatabaseObject record (Devyon Lozano)
• ffe0494: Make sure countryName is passed to city reports in unit tests (Devyon Lozano)
• 156356f: Add basic layout of generatePopulationReport (Devyon Lozano)
• 74f4aa8: Add verifyScopeName method (Devyon Lozano)
• e08402a: Change to returning switch expression rather than assigning to variable using switch statement. Also add uppercase conversion to remove more code (Devyon Lozano)
• 0cf0dee: Update specific population queries (Devyon Lozano)
• a5d2f5a: Explicitly return true for world case (Devyon Lozano)
• 3d2ca01: Check for null scope and scopeName in verifyScopeName (Devyon Lozano)
• dd29a8e: Replace verification logic with verifyScopeName (Devyon Lozano)
• feffb01: Remove unnecessary toUpperCase() calls (Devyon Lozano)
• eb703cf: Fix unit tests by changing assertThrows nullPointerException to asserNull (Devyon Lozano)
• 21d7ff2: Removed explicit Population type from generatePopulationReport return (Devyon Lozano)
• 867efc5: Fix strings (Devyon Lozano)
• 1560dfc: Add integration tests for generatePopulationReport (Devyon Lozano)
• 78ba708: Call generatePopulationReport in main (Devyon Lozano)
• da1235d: Make : the consistent ending of the title of reports, rather than . (Devyon Lozano)
• eb2b3fa: Fix Scope in report call (Devyon Lozano)
• 30331b1: Update queries (Devyon Lozano)
• b1efa71: Fix population queries (Devyon Lozano)
• 5f96e1c: Add generatePopulationReport unit tests (Devyon Lozano)
• 2321355: Remove unnecessary toString calls in testGenerateUrbanizationReport (Devyon Lozano)
• 87b42fb: Merge branch 'feature/8-specific-population' into develop (Devyon Lozano)
• ad53e5d: Merge branch 'develop' into release (Devyon Lozano)
• 90bbe89: Update pom.xml version (Devyon Lozano)
• 84e9a9e: Create language DatabaseObject record (Devyon Lozano)
• a71303b: Fix query (Devyon Lozano)
• 0b3528a: Add generateTop5LanguagesReport (Devyon Lozano)
• 14ee1b0: Fix generateTop5LanguageReport return value (Devyon Lozano)
• a5a6b29: Change print to println on language report header (Devyon Lozano)
• 90001d2: Remove redundant toUpperCase call in verifyScopeName (Devyon Lozano)
• 4600c9d: Add Integration test for generateTop5LanguageReport (Devyon Lozano)
• 5348353: Add unit test for each DatabaseObject record type (Devyon Lozano)
• 9327ab8: private databaseConnection field in DatabaseConnectionTest (Devyon Lozano)
• 6dfcce9: App generateTop5LanguageReport() call to main (Devyon Lozano)
• aad3063: Fix Urbanization column padding (Devyon Lozano)
• 672c34c: Fix Language column padding (Devyon Lozano)
• 4f57ef1: Merge branch 'develop' into release (Devyon Lozano)

v0.2.2

Commits

• da94373: Add files via upload (40728714)
• f225feb: Add files via upload (40728714)
• ab44512: Merge branch 'feature/8-population-by-geography' of https://github.com/ikindadoesstuff/WorldStatistics into feature/8-population-by-geography (Devyon Lozano)
• e5f9efb: Delete sql files (Devyon Lozano)
• c25db3b: Update pom.xml version (Devyon Lozano)
• 659fc46: Update getColumnString in Urbanization record (Devyon Lozano)
• f0db69d: Merge remote-tracking branch 'origin/feature/7-urbanization' into develop (Devyon Lozano)
• d2a39ff: Add Population DatabaseObject record (Devyon Lozano)
• ffe0494: Make sure countryName is passed to city reports in unit tests (Devyon Lozano)
• 156356f: Add basic layout of generatePopulationReport (Devyon Lozano)
• 74f4aa8: Add verifyScopeName method (Devyon Lozano)
• e08402a: Change to returning switch expression rather than assigning to variable using switch statement. Also add uppercase conversion to remove more code (Devyon Lozano)
• 0cf0dee: Update specific population queries (Devyon Lozano)
• a5d2f5a: Explicitly return true for world case (Devyon Lozano)
• 3d2ca01: Check for null scope and scopeName in verifyScopeName (Devyon Lozano)
• dd29a8e: Replace verification logic with verifyScopeName (Devyon Lozano)
• feffb01: Remove unnecessary toUpperCase() calls (Devyon Lozano)
• eb703cf: Fix unit tests by changing assertThrows nullPointerException to asserNull (Devyon Lozano)
• 21d7ff2: Removed explicit Population type from generatePopulationReport return (Devyon Lozano)
• 867efc5: Fix strings (Devyon Lozano)
• 1560dfc: Add integration tests for generatePopulationReport (Devyon Lozano)
• 78ba708: Call generatePopulationReport in main (Devyon Lozano)
• da1235d: Make : the consistent ending of the title of reports, rather than . (Devyon Lozano)
• eb2b3fa: Fix Scope in report call (Devyon Lozano)
• 30331b1: Update queries (Devyon Lozano)
• b1efa71: Fix population queries (Devyon Lozano)
• 5f96e1c: Add generatePopulationReport unit tests (Devyon Lozano)
• 2321355: Remove unnecessary toString calls in testGenerateUrbanizationReport (Devyon Lozano)
• 87b42fb: Merge branch 'feature/8-specific-population' into develop (Devyon Lozano)
• ad53e5d: Merge branch 'develop' into release (Devyon Lozano)

v0.2.1

Commits

• ac51921: Update all DatabaseObject javadocs (Devyon Lozano)
• 0c4710b: Add Urbanization DatabaseObject (Devyon Lozano)
• 8b92588: Add percentages to Urbanization (Devyon Lozano)
• 0259214: Fix comments in ReportGenerator (Devyon Lozano)
• 92c5b0b: Add generateUrbanizationReport method (Devyon Lozano)
• 9cb32f1: Remove initialization of query string (Devyon Lozano)
• c9bebfd: Remove unnecessary stringName parameter (Devyon Lozano)
• 795d583: Call generateUrbanizationReport in main (Devyon Lozano)
• 937e615: Update columns in Urbanization (Devyon Lozano)
• d4c902a: Add integration test for urbanization (Devyon Lozano)
• 5f61a9f: Add row to generateUrbanizationReport assertion messages (Devyon Lozano)
• 051e3f2: Fix incorrect assignment (Devyon Lozano)
• 23b660d: Handle database discrepancies in Urbanization record (Devyon Lozano)
• acf4891: Catch NullPointer exceptions for null connections in ReportGenerator (Devyon Lozano)
• ee155a8: Add v to version name in build.yml (Devyon Lozano)
• d69079a: Add parameterized test for generateUrbanizationReport (Devyon Lozano)
• 9233b1a: Replace assertThrow tests with assertNull as null pointer exceptions have been caught (Devyon Lozano)
• afab6b6: Consolidate certain tests into parameterized tests (Devyon Lozano)
• 548e0e5: Pretty-up comments (Devyon Lozano)
• 2069c21: Further consolidate WORLD scope tests in _AllScopes tests (Devyon Lozano)
• 77f50cc: Comment out Thread.sleep() code (Devyon Lozano)
• 73e0443: Merge remote-tracking branch 'origin/feature/7-urbanization' into develop (Devyon Lozano)
• 5d19d7d: Update version in pom.xml (Devyon Lozano)
• 8f5fe05: Merge branch 'develop' into release (Devyon Lozano)

v0.2.0

Commits

• d92e37e: Add generateTopNCityReport methods (Devyon Lozano)
• c2ed3c8: Call top N cities reports (Devyon Lozano)
• fad8707: Update mysql connector version in pom.xml due to security vulnerability alert (Devyon Lozano)
• 1820801: Add junit testing dependency to pom.xml (Devyon Lozano)
• ee4dd36: Merge branch 'feature/4-top-n-city-population' into develop (Devyon Lozano)
• d570680: Add junit testing plugin to pom.xml (Devyon Lozano)
• 160aaa9: Change Main class name to App (Devyon Lozano)
• 6f42b80: Add AppTest file (Devyon Lozano)
• 4f260b1: Change report methods to return null upon failure (Devyon Lozano)
• a7fd490: Add unit test for printReport method in AppTest (Devyon Lozano)
• 3f7a9f3: Add default DatabaseConnection constructor (Devyon Lozano)
• f3de947: Reduce tries from 30 to 5 (Devyon Lozano)
• 4029e2a: Separate setting connection and scope name fetching from ReportGenerator constructor into separate methods. (Devyon Lozano)
• fa2b088: Add JUnit tests (Devyon Lozano)
• 9f54e48: Add mockito mocking and tests (Devyon Lozano)
• 309681c: Remove mockito (Devyon Lozano)
• b883850: Add setup for ReportGeneratorTest (Devyon Lozano)
• a3e844e: Catch empty row in printReport (Devyon Lozano)
• 459b9d9: Check for empty results in fetch scope name methods (Devyon Lozano)
• 5bb0cf2: Check for null N value in top N reports (Devyon Lozano)
• 58c3621: Remove redundant null in fetchScopeNames (Devyon Lozano)
• 5449cce: Move connect retries to method parameter rather than local variable (Devyon Lozano)
• 33940ab: Check for null args and null element in args in DatabaseConnection constructor (Devyon Lozano)
• a404c3a: Add additional ReportGenerator unit tests (Devyon Lozano)
• 3a4f311: Add DatabaseConnection unit tests (Devyon Lozano)
• 8973656: Fix testDatabaseConnection_NullArgsElement() test (Devyon Lozano)
• 0dfd445: Add DatabaseConnection setup in test (Devyon Lozano)
• 15c1e0b: Add additional DatabaseConnection tests (Devyon Lozano)
• 4d508be: Uncomment App test (Devyon Lozano)
• a8b2007: Refactor report generator parameter names (Devyon Lozano)
• fd8eaac: Add assertions to DatabaseConnectionTest (Devyon Lozano)
• b085162: Remove unused imports (Devyon Lozano)
• 5419708: Remove public access modifiers from JUnit test classes (Devyon Lozano)
• 73a7bee: Implement loose coupling; Change ArrayList declarations to List (Devyon Lozano)
• 02731b5: Add override annotation to Records extending DatabaseObject (Devyon Lozano)
• 1200734: Check for invalid Scope passed to report generator methods (Devyon Lozano)
• 8dd1372: separate print report tests into different possible reports (Devyon Lozano)
• ff9362d: Fixed error catching differences in fetch methods (Devyon Lozano)
• cb81337: Add assert messages to tests (Devyon Lozano)
• 7e6b802: Add additional asserts to tests (Devyon Lozano)
• d287027: Remove AppTest unit test class (Devyon Lozano)
• e8374dd: Fixed testConnect_ConnectionFail and getConnection_NullConn tests (Devyon Lozano)
• 5d34fd3: Remove unused import (Devyon Lozano)
• 3fa8f41: Change retries (Devyon Lozano)
• 349f92e: Uncomment reports (Devyon Lozano)
• 09425ea: Fix negative N in method call (Devyon Lozano)
• 3b72245: Add newline to the end of error messages to help with readability (Devyon Lozano)
• 3ec51e8: Update build.yml to add unit testing (Devyon Lozano)
• 7f99a70: Ensure tests are skipped in maven packaging stage (Devyon Lozano)
• 00a24c1: Add --no-transfer-progress to hide maven downloading percentages (Devyon Lozano)
• 7ce5165: Add additional text to separate connection success from start of reports (Devyon Lozano)
• 57831ed: Separate unit test and build jobs in action (Devyon Lozano)
• ad75a28: Cleanup database connection messages (Devyon Lozano)
• af7f917: Add --no-transfer-progress to mvn package for cleaner logs (Devyon Lozano)
• 9b27687: Rename test methods to be more semantically correct (Devyon Lozano)
• 3984f5f: Update ReportGenerator() javadoc (Devyon Lozano)
• b73a21b: Update test method name to be semantically correct (Devyon Lozano)
• d4d8f9c: Update printReport to show number of rows (Devyon Lozano)
• 397055c: Update printReport to show number of rows (Devyon Lozano)
• 10c4a5e: Add integration tests for generateSortedCountryReport (Devyon Lozano)
• dc96d45: Add top N country integration tests (Devyon Lozano)
• 61d911a: Add integration test config to GitHub actions file (Devyon Lozano)
• 94474f5: Fix integration test setup (Devyon Lozano)
• 8c69e43: Fix integration test class name and hide transfer progress (Devyon Lozano)
• 6dd2f00: Remove view logs from test jobs (Devyon Lozano)
• 8f51db8: Fix names in Destroy Database Image phase (Devyon Lozano)
• e1ec305: Add jacoco plugin for code coverage (Devyon Lozano)
• b7390d1: Add codecov action to build.yml (Devyon Lozano)
• ebe3e2c: Update jacoco version (Devyon Lozano)
• 5246af4: Update codecov action (Devyon Lozano)
• 4c1122e: Add codecov action to unit tests (Devyon Lozano)
• b22ec11: Add main method integration test (Devyon Lozano)
• fa8dc3b: Add some city report tests (Devyon Lozano)
• fd82fed: Add JUnit Jupiter Params to pom.xml (Devyon Lozano)
• 39b10e8: Add Parameterized Tests for first 4 reports (Devyon Lozano)
• 0046562: Lower JUnit Jupiter Params version for compatibility (Devyon Lozano)
• 6d0a5d3: Fix Integration test parameters (Devyon Lozano)
• 6920794: Update README.md with additional badges (Devyon Lozano)
• 196bfec: Update badge styles (Devyon Lozano)
• 3092757: Update README.md (Devyon Lozano)
• ed931ab: Add javadoc comment to DatabaseConnection (Devyon Lozano)
• 3b04569: Add comments where necessary (Devyon Lozano)
• e4b1846: Private variables (Devyon Lozano)
• 1d799d5: Make fields local variables (Devyon Lozano)
• ab7a9b8: Private reportGenerator object in ReportGeneratorTest (Devyon Lozano)
• 7169858: Add javadoc comments to test class fields (Devyon Lozano)
• a45c0d0: Add Capital DatabaseObject (Devyon Lozano)
• 9e4a2f7: Add generateSortedCapitalsReport method (Devyon Lozano)
• 02f728b: Fix comments (Devyon Lozano)
• 427b193: Add calls to generatedSortedCapitalsReport (Devyon Lozano)
• 05e6b2b: Fix error getting column name (Devyon Lozano)
• 52dd179: Remove plural from method name (Devyon Lozano)
• 80e3bae: Add testGenerateSortedCapitalReport integration test (Devyon Lozano)
• 00e7981: Add testGenerateSortedCapitalReport unit tests (Devyon Lozano)
• b5c6637: Fix method name pluralization in call (Devyon Lozano)
• e1bee7d: Make AppIntegrationTest package access (Devyon Lozano)
• d4184ca: Merge branch 'feature/5-capitals-sorted' into develop (Devyon Lozano)
• 3f416f8: Add Deploy stage to Actions which creates a release only if the previous stages succeed and push is to the release branch (Devyon Lozano)
• 6a9cb8e: Add Maven help plugin (Devyon Lozano)
• 4e460cf: Use maven help plugin to get project version and use that version as the release tag name (Devyon Lozano)
• 0be9e92: Fix getting project version (Devyon Lozano)
• c98bddb: Fix output syntax (Devyon Lozano)
• 48bb6cb: Move logs before deployment (Devyon Lozano)
• 3382471: build.yml commits (Devyon Lozano)
• eee6153: Add code annotation to javadocs (Devyon Lozano)
• 7a0d1dc: Call generateTopNCapitalReport (Devyon Lozano)
• 6bcd8cc: Add generateTopNCountryReport method (Devyon Lozano)
• d24d0b4: Add generateTopNCountryReport integration test (Devyon Lozano)
• b3b9061: Update generateTopNCountryReport integration test arguments (Devyon Lozano)
• 52b8641: Add generateTopNCountryReport unit tests (Devyon Lozano)
• 4d1c4f8: Uncomment App (Devyon Lozano)
• 5d9e639: Merge branch 'feature/6-top-n-capitals' into develop (Devyon Lozano)
• d1b1ce0: Update version in pom.xml to 0.2.0 (Devyon Lozano)
• 700ee86: Merge branch 'develop' into release (Devyon Lozano)
• 8c31cd5: Add write permissions to build job (Devyon Lozano)

v0.1.0

Issue 1

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.

Issue 2

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.

Issue 3

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.

v0.0.2

Generate reports with the following data:

• 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.

v0.0.1

Removed redundant null values