pugsql icon indicating copy to clipboard operation
pugsql copied to clipboard

A HugSQL-inspired database library for Python

Results 24 pugsql issues
Sort by recently updated
recently updated
newest added

Is it possible to use it without SQLAlchemy, I'm using PooleDB for handling my connections and I'm using the drivers directly, I'd love to either use these DBAPI drivers or...

Bumps [nokogiri](https://github.com/sparklemotion/nokogiri) from 1.13.3 to 1.14.3. Release notes Sourced from nokogiri's releases. 1.14.3 / 2023-04-11 Security [CRuby] Vendored libxml2 is updated to address CVE-2023-29469, CVE-2023-28484, and one other security-related issue....

dependencies
ruby

AttributeError: 'Engine' object has no attribute 'execute' Recent breaking change on SQLAlchemy 2.0 https://stackoverflow.com/questions/75316741/attributeerror-engine-object-has-no-attribute-execute-when-trying-to-run-sq

Example: ```sql UPDATE names SET name = vals.name FROM (VALUES (1, "Bob"), (2, "Mary"), (3, "Jane")) AS vals (id, name) WHERE names.id = vals.id; ``` See https://www.postgresql.org/docs/9.5/queries-values.html Is there a...

enhancement
question

Bumps [activesupport](https://github.com/rails/rails) from 6.0.3.2 to 6.0.6.1. Release notes Sourced from activesupport's releases. v6.0.6.1 Active Support No changes. Active Model No changes. Active Record Make sanitize_as_sql_comment more strict Though this method...

dependencies
ruby

Bumps [mako](https://github.com/sqlalchemy/mako) from 1.2.0 to 1.2.2. Release notes Sourced from mako's releases. 1.2.2 Released: Mon Aug 29 2022 bug [bug] [lexer] Fixed issue in lexer where the regexp used to...

dependencies
python

After running a script using pugsql, the following error messages are (always) in my database logs: ``` 2021-01-01T05:50:02.596129Z 177181 [Note] Aborted connection 177181 to db: 'pmx' user: 'devv' host: '127.0.0.1'...

I'm trying to write an INSERT RETURNING query which works on both Postgres and SQLite: ``` -- :name test_insert :insert INSERT INTO table (foo) VALUES (:bar) RETURNING id; ``` This...

Bumps [tzinfo](https://github.com/tzinfo/tzinfo) from 1.2.7 to 1.2.10. Release notes Sourced from tzinfo's releases. v1.2.10 Fixed a relative path traversal bug that could cause arbitrary files to be loaded with require when...

dependencies
ruby