Function get_featured_sql

api/app/api/utils/cached_queries/featured_queries.py:36–64

(input_str, scope="USA")

    return related_tables

def get_featured_sql(input_str, scope="USA"):
    
        if not EVENTS_ENGINE:
            return False
        
        params = {
            "input_text": input_str,
            "scope": scope
        }
        query = text("""
            SELECT * FROM featured_queries
            WHERE input_text ilike :input_text
            AND app = :scope
        """)

        try:
            with EVENTS_ENGINE.connect() as conn:
                result = conn.execute(query, params)
                conn.commit()
                res = result.fetchall()
        except Exception as e:
            return False

        if len(res) == 0:
            return False
    
        related_sql = res[0][2]
    
        return related_sql