Can I get an example of this module being used in a Flask app? about jinjasql HOT 1 CLOSED

from flask import current_app
from jinjasql import JinjaSql
import jinja2

def _get_template(self, name):
    j_sql = JinjaSql(env=current_app.jinja_env, param_style='pyformat')
    try:
        sql_template = j_sql.env.get_template(f'{self.TEMPLATES_FOLDER}/{name}')
    except jinja2.exceptions.TemplateNotFound:
        raise
    return sql_template

def run_report(self, extract_definition):
    sql_template = self._get_template('run_report.sql')
    data = {
        'dataset': self.client.dataset,
        'selected_table': extract_definition.selected_table.name,
        'time_period_column': extract_definition.time_period_type.upper(),
        'time_values': [time_value.name for time_value in extract_definition.time_values]
    }
    query, bind_params = jsql.prepare_query(sql_template, data)
    return self.engine.execute(query % bind_params).fetchall()