complete source code generation about jinjasql HOT 4 OPEN

I am not sure if there is a specific feature request described here, and the link to moban doesn't really provide any insight. Do you mind providing some additional details for us to consider?

from jinjasql.

Sorry, the link should have been to @moremoban

Unfortunately a long time has passed since I created this issue, and the exact use-case I had has now escaped my brain.

The main part of it that I remember was I was trying to process a python file which contained several queries in it.

I didnt want to run jinjaSQL at runtime - I wanted instead to run it at build time, to convert a template into a database specific python file.

Processing a template with multiple queries was the key problem - especially the variable binding was problematic, perhaps because it was using %s instead of {name} ... ?

from jinjasql.

I think I understand the idea here: applying the templates in a build step and generating rendered .sql queries, similar to Frozen-Flask generating static HTML from templates + data.

Frozen-Flask is an instructive example though in that I think this usecase would probably be best as a separate tool that uses JinjaSQL, as opposed to being built into JinjaSQL itself. This article illustrates some of the steps that could get you there, specifically the section entitled "From a template to the final SQL query."

from jinjasql.

.. rendered .sql queries ..

Well the key is that the input files, .sqljj2 ? ;-), would contain multiple queries, or DDL/DML. Using pyformat, like you did in apply_sql_template, probably makes this easier.

from jinjasql.