observing_capabilities_handler.py

from web.helpers.db import Db


class ObservingCapabilitiesHandler:
    @staticmethod
    def handle():
        sql = """
            SELECT oc.*,
                ptv.label as process_type_name,
                rnv.label as result_nature_name
            FROM observing_capabilities oc
                left join sampling_points sp on oc.sampling_point_id = sp.id
                left join eea_processtypevalues ptv on lower(oc.process_type) = lower(ptv.id)
                left join eea_resultnaturevalues rnv on lower(oc.result_nature) = lower(rnv.id)
        """

        sql = sql + Db.add_network_ids_requirement()

        observingCapabilities = Db.fetchall(sql)
        return observingCapabilities