pugsql
pugsql copied to clipboard
mcfunley
A HugSQL-inspired database library for Python
pugsql raises the following error if there are any normal comments in the sql code (unless they are between the :name special comment and the actual sql query. ValueError: Statement...
I am using sqlalchemy core and pugsql, my use case is to use sqlalchemy core's Table and Column classes to create tables and manage migrations via alembic while puqsql will...
I am trying to inject a sorting field and a sort direction (ascending or descending) to an sql statement. Are raw sql parameters supported?
**Enhancement Request**: Currently, to make existing `.sql` files usable by pugSQL, one needs to "corrupt" them by injecting `:myVar` references into the SQL queries, thus invalidating them as usable `.sql`...
Hello people! I'm starting a small project with [starlette][st] and I'd like to try pugsql, I found it super interesting, it's great project! But [starlette][st] is async and I'd like...
Create Schema and Create Table queries will not be committed until you call theme inside a transaction!
After importing pugsql, calling sqlalchemy's has_table method causes an infinite recursive loop. This may happen when any BindParameter is used but I am not sure. To reproduce: -Import pugsql -Create...
PostgreSQL (psycopg2 driver) uses `list` to pass integer array type (`integer[]`), but pugsql expands `list` params not only for the `IN` clause, but also in other places: https://github.com/mcfunley/pugsql/blob/b41998717d33e9d9b0319602e848dbd26057baca/pugsql/statement.py#L26-L38 For example:...
We can probably give a pugsql-specific error when this happens. Currently you get something like: ```sqlalchemy.exc.ResourceClosedError: This result object does not return rows. It has been closed automatically.``` (Might be...
Working on a React / Flask project where everything reloads when files are touched except for pugsql. It'd be nice of modules had a debug mode that stat'd source files...