4.2 Deliverable Summary

General Approach

• How and what data we store
• SPARQL and APIs
• Spring Boot and Backend Libraries (Hibernate - ORM, MySQL, Swagger, Unirest, Jackson and Mockito)
• Unit testing
• AWS and automation

DevOps

• Swagger Interface
• Environment Variables for Passwords etc
• Building Docker images
• Automated test running through Maven with report dumps
• Automatic Update of docker images/layers
• Swagger Auto Generated Documentation
• Discord Github intergration
• Travis
• Expo

Backend

• Finding data and fetching data in a coordinate bounding box
• Finding the coordinate bounding box
• Thread safe entity manager
• Static data aggregation and separate processing
• Converting normalised values to colours
• Mocking in unit tests
• Thread wrapper - Hikari pool fix
• Dynamic SQL Postcode aggregation
• SPARQL Query generation
• Heatmap size generation
• Normalisation
• Database update script (pre-processing)
• Phone userKey generation
• Query optimisation

Frontend

• Rendering and the ReactNative Life cycle
• Issues with dynamic sizing of circles
• Transparency/Opaque trade-off
• Test data and the Google api
• Load button vs automatic loading

Software Process

• Branching Format/Rules
• Clang formatter
• Reviewable
• Code Review Checklist
• Sonar Qube / cloud
• Pull Request templates
• Building Documentation

Demo