pub const SESSION_SQL: &str = "DO $install$\nDECLARE\n _sch text := COALESCE(current_schema(), \'public\');\nBEGIN\n EXECUTE format($sql$\nCREATE OR REPLACE FUNCTION set_heer_node_id(node_id INTEGER)\nRETURNS void\nLANGUAGE plpgsql\nSET search_path = %I, pg_catalog\nAS $func$\nDECLARE\n validated_node_id INTEGER;\nBEGIN\n IF node_id IS NULL THEN\n RAISE EXCEPTION \'node_id cannot be null\';\n END IF;\n\n IF node_id < 0 OR node_id > 511 THEN\n RAISE EXCEPTION \'node_id %% is out of range for HeerId\', node_id;\n END IF;\n\n SELECT n.node_id\n INTO validated_node_id\n FROM heer_nodes AS n\n WHERE n.node_id = set_heer_node_id.node_id\n AND n.is_active = true;\n\n IF validated_node_id IS NULL THEN\n RAISE EXCEPTION \'node_id %% is not registered as an active Heer node\', node_id;\n END IF;\n\n PERFORM set_config(\'heer.node_id\', node_id::text, false);\nEND;\n$func$;\n$sql$, _sch);\nEND;\n$install$;\n\nDO $install$\nDECLARE\n _sch text := COALESCE(current_schema(), \'public\');\nBEGIN\n EXECUTE format($sql$\nCREATE OR REPLACE FUNCTION current_heer_node_id()\nRETURNS INTEGER\nLANGUAGE plpgsql\nSET search_path = %I, pg_catalog\nAS $func$\nDECLARE\n configured_node_id TEXT;\n parsed_node_id INTEGER;\nBEGIN\n configured_node_id := current_setting(\'heer.node_id\', true);\n\n IF configured_node_id IS NULL OR configured_node_id = \'\' THEN\n RAISE EXCEPTION \'heer.node_id is not set for this session\';\n END IF;\n\n parsed_node_id := configured_node_id::INTEGER;\n PERFORM set_heer_node_id(parsed_node_id);\n RETURN parsed_node_id;\nEND;\n$func$;\n$sql$, _sch);\nEND;\n$install$;\n\nDO $install$\nDECLARE\n _sch text := COALESCE(current_schema(), \'public\');\nBEGIN\n EXECUTE format($sql$\nCREATE OR REPLACE FUNCTION set_heer_ranj_node_id(node_id INTEGER)\nRETURNS void\nLANGUAGE plpgsql\nSET search_path = %I, pg_catalog\nAS $func$\nDECLARE\n validated_node_id INTEGER;\nBEGIN\n IF node_id IS NULL THEN\n RAISE EXCEPTION \'node_id cannot be null\';\n END IF;\n\n IF node_id < 0 OR node_id > 32767 THEN\n RAISE EXCEPTION \'node_id %% is out of range for RanjId\', node_id;\n END IF;\n\n SELECT n.node_id\n INTO validated_node_id\n FROM heer_nodes AS n\n WHERE n.node_id = set_heer_ranj_node_id.node_id\n AND n.is_active = true;\n\n IF validated_node_id IS NULL THEN\n RAISE EXCEPTION \'node_id %% is not registered as an active Heer node\', node_id;\n END IF;\n\n PERFORM set_config(\'heer.ranj_node_id\', node_id::text, false);\nEND;\n$func$;\n$sql$, _sch);\nEND;\n$install$;\n\nDO $install$\nDECLARE\n _sch text := COALESCE(current_schema(), \'public\');\nBEGIN\n EXECUTE format($sql$\nCREATE OR REPLACE FUNCTION current_heer_ranj_node_id()\nRETURNS INTEGER\nLANGUAGE plpgsql\nSET search_path = %I, pg_catalog\nAS $func$\nDECLARE\n configured_node_id TEXT;\n parsed_node_id INTEGER;\nBEGIN\n configured_node_id := current_setting(\'heer.ranj_node_id\', true);\n\n IF configured_node_id IS NULL OR configured_node_id = \'\' THEN\n RAISE EXCEPTION \'heer.ranj_node_id is not set for this session\';\n END IF;\n\n parsed_node_id := configured_node_id::INTEGER;\n PERFORM set_heer_ranj_node_id(parsed_node_id);\n RETURN parsed_node_id;\nEND;\n$func$;\n$sql$, _sch);\nEND;\n$install$;\n";