* Use Doctrine instead of legacy db connection
* Add types to variables and returns
* Simplify functions
* Remove unused code