Basic Jinja2 workflow

new_gist_file

import jinja2

templateLoader = jinja2.FileSystemLoader(searchpath="templates")
templateEnv = jinja2.Environment(loader=templateLoader)
templateEnv.trim_blocks = True
template = templateEnv.get_template(TEMPLATE_FILE)

templateVars = {
        "nombre_tabla": "ubicaciones",
        "lista_campos": campos,
        "inserts": inserts
    }

output = template.render(templateVars)

with open((os.path.join(DIR_OUTPUT_SQL, 'datos.sql')), 'w') as f:
  f.write(output.encode('utf-8'))