Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL console in QGIS Browser can't run just the selected part of an SQL statement (unlike DB Manager SQL console) #57202

Closed
2 tasks done
gioman opened this issue Apr 20, 2024 · 3 comments · Fixed by #57211
Closed
2 tasks done

SQL console in QGIS Browser can't run just the selected part of an SQL statement (unlike DB Manager SQL console) #57202

gioman opened this issue Apr 20, 2024 · 3 comments · Fixed by #57211
Labels
Feature Request QGIS Browser

Comments

@gioman
Copy link
Contributor

gioman commented Apr 20, 2024

What is the bug or the crash?

Title says it all. Also notice that the "clear" and "execute" buttons are not placed where expected... I find myself all the time pressing "clear" instead of "execute", and the damn thing does not even support undo (when pressing "clear").

Steps to reproduce the issue

Title says it all.

Versions

3.34.5

Supported QGIS version

  • I'm running a supported QGIS version according to the roadmap.

New profile

Additional context

No response
@gioman gioman added Bug Either a bug report, or a bug fix. Let's hope for the latter! QGIS Browser labels Apr 20, 2024
@gioman
Copy link
Contributor Author

gioman commented Apr 20, 2024

I find myself all the time pressing "clear" instead of "execute"

because of course in DB Manager that we all use since ages, that buttons order is inverted.

@agiudiceandrea agiudiceandrea mentioned this issue Apr 21, 2024
Merged
@elpaso elpaso added Feature Request and removed Bug Either a bug report, or a bug fix. Let's hope for the latter! labels Apr 22, 2024
@gioman
Copy link
Contributor Author

gioman commented Apr 22, 2024

My bad, definitively a feature request and not a bug. Also apologies for the harsh comment: I had just wiped out a very complex query and just found there was no UNDO.

@nyalldawson
Copy link
Collaborator

nyalldawson commented Apr 22, 2024 •
edited

@gioman

I had just wiped out a very complex query and just found there was no UNDO.

Try this (from the qgis python console):

w=QgsHistoryWidget("dbquery")
w.show()

Should give you a dialog listing a (seachable) history of all sql executed from the browser 👍 Double click an entry to re-open it in the sql dialog.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Feature Request QGIS Browser
Projects
None yet
Milestone
No milestone
3 participants
@elpaso @nyalldawson @gioman