Run query with parameters
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
In my Python-code (with sqlalchemy and psycopg2), I have queries like:
```sql
INSERT INTO my_table(title, isbn, copy_nr)
VALUES(:title, :isbn, 1)
```
the parts `:title` and `:isbn` are parameters which are supplied by code.
I would be very handy, when parameters are detected, Postico would pop-up a window to enter values for those parameters (types would be needed to be specified too). Ideally, Postico would recognise if the same query was run, so it could remember the entered values and provide them as default values.
I've used this behaviour in TOAD, and it makes a developers life a little better :-)
Not sure if this fits in your philosophy about Postico.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files, tests, or entry points are named. Start by locating Postico's query execution and parameter handling, then determine how :title-style parameters, value types, and saved defaults would fit together. Done means a query can prompt for parameter values, execute with them, and reuse defaults for the same query.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python, sqlalchemy
- Domain
- database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100