jinjasql_parameterized_query_template_with_variable_binding.py

1from jinjasql import JinjaSql
2
3# Initialize JinjaSql
4j = JinjaSql()
5
6# Define the template with Jinja2 syntax
7template = """
8    SELECT project_name, description 
9    FROM project
10    WHERE category = {{ category }}
11    {% if region %}
12    AND region = {{ region }}
13    {% endif %}
14"""
15
16# Define the data to be bound
17data = {
18    "category": "Open Source",
19    "region": "India"
20}
21
22# Prepare the query and the bind parameters
23query, bind_params = j.prepare_query(template, data)
24
25# Output the query and the bind parameters
26print(f"SQL Query: {query}")
27print(f"Bind Parameters: {bind_params}")