jinjasql
jinjasql copied to clipboard
Template Language for SQL with Automatic Bind Parameter Extraction
Jinja2 moved deprecated objects to Markupsafe. This is causing 'import jinjasql' to break. If possible, could you please - update the dependencies - update the code to use the relocated...
Set `MarkupSafe`'s version range to prevent `ImportError`. ## Background ```bash $ pip install -r requirements.txt ... Installing collected packages: pyodbc, Django, cx-Oracle, certifi, wrapt, websocket-client, urllib3, PyYAML, pyparsing, pymysql, psycopg2-binary,...
Ref : https://github.com/python/cpython/pull/28382 https://github.com/sripathikrishnan/jinjasql/blob/d7fdc7af1979a155da48bb5fe845c9466520db52/tests/__init__.py#L8-L10
Is there an example showing how to use macros with this library? I want to build a CLI that renders the SQL with template SQL + variable. Macros would be...
JinjaSQL makes the assumption that any iterable is going to be used in a IN clause. PostgreSQL has an array data type and arrays can actually be binded. This PR...
Currently, table names and field names can be used with the `sqlsafe` filter. Would it be possible to introduce a new filter to handle escaping for table names and field...
Just based on this section: > JinjaSQL is not meant to replace your ORM. ORMs like those provided by SQLAlchemy or Django are great for a variety of use cases,...
Would like to have an example which documents how to perform bulk insert ### Desired output ```sql INSERT INTO links (url, name) VALUES ('https://www.google.com','Google'), ('https://www.yahoo.com','Yahoo'), ('https://www.bing.com','Bing'); ```
Older version of bind_in_clause was resulting in error due to parentheses used.