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.

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

Execute SQL might support allowing users to drag and drop from DBSchema so they don't have to type the names of variables. #119

Closed
rajivnarayana opened this issue Oct 1, 2014 · 8 comments
Assignees

Comments

@rajivnarayana
Copy link

@rajivnarayana rajivnarayana commented Oct 1, 2014

No description provided.

@justinclift
Copy link
Member

@justinclift justinclift commented Oct 1, 2014

Interesting idea. Could be the start of a visual query builder. 😉

@Z4us
Copy link

@Z4us Z4us commented Oct 5, 2014

Yes, Justin,

We can even build a DataDictionary like e.g. Oracle has: http://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm

@justinclift
Copy link
Member

@justinclift justinclift commented Oct 6, 2014

Tab completion of variable names and keywords in the Execute SQL window would be nice too. Unsure what it would take to implement though...

@Z4us
Copy link

@Z4us Z4us commented Oct 6, 2014

Great idea, enough to type s for 'select', 'u' for update, 'd' for delete, 'i' for insert etc.

@mgrojo
Copy link
Member

@mgrojo mgrojo commented Dec 2, 2017

In fact you can click on the Name column press Ctrl+C and then paste in the SQL editor, but drag and drop should also work. I haven't found in a quick review where it can be implemented 😄

@mgrojo mgrojo self-assigned this Dec 2, 2017
mgrojo added a commit that referenced this issue Dec 3, 2017
This is the first attempt to provide the functionality described in #119.

Drag in the dock is enabled (it was only enabled in the Database Structure
tab). Then the fields are enabled for dragging and finally the MIME data
exported for the drag and drop is tailored for exporting only the escaped
field identifier.

This may interfere to other uses of drag&drop in the Database Structure.
mgrojo added a commit that referenced this issue Dec 24, 2017
By allowing extended selections of individual items in the dock version,
we let users select what they want to drag and drop. When dragging a list
of items from the Name column, a list of escaped identifiers with commas is
exported, making easier the composition of SELECT and other statements.

In this way, every item name can be dropped, without loosing the ability
of exporting the SQL statement for the item. It will just depend on which
column is selected.

For the DB Structure tab, the original behaviour of single row selection
is maintained. In that case, only the SQL column is exported, as before.

See issue #119.
MKleusberg added a commit that referenced this issue Jan 1, 2018
)

* Allow users to drag and drop fields from DB Schema dock to editor

This is the first attempt to provide the functionality described in #119.

Drag in the dock is enabled (it was only enabled in the Database Structure
tab). Then the fields are enabled for dragging and finally the MIME data
exported for the drag and drop is tailored for exporting only the escaped
field identifier.

This may interfere to other uses of drag&drop in the Database Structure.

* Allow the user to drag individual items from the DB Schema dock

By allowing extended selections of individual items in the dock version,
we let users select what they want to drag and drop. When dragging a list
of items from the Name column, a list of escaped identifiers with commas is
exported, making easier the composition of SELECT and other statements.

In this way, every item name can be dropped, without loosing the ability
of exporting the SQL statement for the item. It will just depend on which
column is selected.

For the DB Structure tab, the original behaviour of single row selection
is maintained. In that case, only the SQL column is exported, as before.

See issue #119.
@mgrojo
Copy link
Member

@mgrojo mgrojo commented Jan 7, 2018

@rajivnarayana We have implemented this feature. If you'd like to try it, you can install one of our nightly builds: https://nightlies.sqlitebrowser.org/latest

@justinclift
Copy link
Member

@justinclift justinclift commented Jan 7, 2018

@rajivnarayana If you're still interested in this, please do. It'd really help. 😄

@mgrojo
Copy link
Member

@mgrojo mgrojo commented Jun 30, 2018

@rajivnarayana I'll close this, but you can still comment on the report if you'd like to.

@mgrojo mgrojo closed this Jun 30, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
4 participants