class ConnectorQueries:

    @staticmethod
    def get_connectors():
        return f"""
            SELECT connector.external_id AS id,
                   connector.name AS schema_name,
                   connector.platform AS platform,
                   connector.created_at :: DATE AS date_created,
                   connector.owner_id AS user_id,
                   connector.label_id AS decibel_label_id,
                   CASE
                       WHEN connector.status = 1 THEN TRUE
                       ELSE FALSE
                   END is_active,
                   connector.last_synced_at AS last_sync_at,
                   manager.email AS manager
            FROM "Connector" connector
            JOIN "User" owner ON connector.owner_id = owner.id
            LEFT JOIN "User" manager ON owner.manager_id = manager.id
        """