00-input-sanitization

[petrubraha]

We need to ensure that users will have a predetermined list of locations (countries, cities) from where they can choose from. Specifically in the Report form (being the only source of input for citizens connected to MySql), the country text field must be changed to a select tag using radio input.

A subsequent task still related to input sanitization is to perform the same transformation in the same form for the city field. the cities available to select must be reflected by the country selected.

The development of this feature must not create technical debt, and must be non-breaking. In other terms the autocompletion of the form must still work as expected based on the location of the user.

Lastly, the server code must reject any other input that does not resembles the fixed list of options.
This issue involves having a list of options on both client (for actually displaying the options) and server (for validation before inserting in database).

[petrubraha]

Some progress has already been implemented. We downloaded a local small database (up to 4MB), and we will treat it as a single source of truth. This file is read by both frontend and backend, called from now on "ends".

The ends will store in RAM a hash map, where keys will be the country nams, and the values will be a set of connected cities.