jinjasql icon indicating copy to clipboard operation
jinjasql copied to clipboard

Template Language for SQL with Automatic Bind Parameter Extraction

Results 21 jinjasql issues
Sort by recently updated
recently updated
newest added

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...

question

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'); ```

question

Older version of bind_in_clause was resulting in error due to parentheses used.