lmedinar-va

SELECT 
    CASE 
        WHEN request_url LIKE '%/vetSearch' THEN '/vetSearch'
        WHEN request_url LIKE '%/bulkVetSearch/%' THEN '/bulkVetSearch/*'
    END as endpoint,
    COUNT(*) as request_count
FROM prod_ecs_alb
WHERE (
        request_url LIKE '%/api/squares/v1/bulkVetSearch%'
        OR request_url LIKE '%/api/squares/v1/vetSearch'

lmedinar-va

#!/usr/bin/env python3
"""
JSON Environment Variable Replacer for Spring Boot Properties Files

Usage: python json_env_replacer.py <json_env_file> <properties_file>

This script reads environment variables from a JSON file and replaces
${VARIABLE_NAME} placeholders in a properties file with their actual values.
"""