[VCL-428] Make get_*_info() subroutines consistent and improve queries

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2
• Fix Version/s: 2.4
• Component/s: vcld (backend)
• Assignee: Unassigned
• Reporter: Andrew Kurth
• Created: 05/Jan/11 17:01
• Updated: 23/Jan/15 21:56
• Resolved: 23/Jan/15 21:56

Description

The various get_*_info() subroutines in utils.pm are not consistent in how they query or return data. Some return hashes. Some return hash references. It will also be beneficial to improve the queries to convert WHERE conditions to JOIN where possible. This will allow a query to succeed even if pieces of the data that used to be in the WHERE condition are null.