⚡ Sangsakala Proxy 🏠 Home
Skip to content

Missing adaptation of parameters in query() and query_prepared() #28

Open

Description

@Cito

In the pgdb module and the query_formatted() and higher level methods of the pg module such as update(), input parameters are adapted automatically, e.g. converting Python lists to PostgreSQL arrays.

However, the lower level query() and query_prepared() methods of the pg module pass parameters in raw form. This is not well documented, and there is no help on what to do in this case. We should explain how and when to manually adapt the parameters. Maybe also provide alternative low level methods with the Postgres parameter syntax or improve the low level methods so that they automatically adapt parameters as well if that's possible without loss of performance or backward compatibility.

(copied from Trac ticket 81, created 2019-06-07)

Activity

  1. added this to the 5.2 milestone on Feb 15, 2020
  2. modified the milestones: 5.2, 5.3 on Jun 20, 2020
  3. modified the milestones: 5.3, 6.1 on Aug 27, 2023
  4. modified the milestones: 6.1, 6.2 on Dec 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions