List of problems and new features
Whlie using the tool I've collected few problems and possible features which would make the tool even better.
Problem list:
p1) "Narrow down on typing" when using option "Surround With"
If you have several live templates that starts with the same name 0xdbe automatically grabs the first one. In the picture bellow when typing letter 's' the first item will be evaluated.
p2) Detailed error description
Error descriptions returning from the engine are really scarce and sometimes I have to run the query in sql developer to get more information about it. Example of a locked account in 0xdbe can be seen in the pic.
p3) "Split vertically" refreshes both views (oracle package development)
If developing directly on the database it can happen that you can lose uncommitted changes if "Split vertically" is selected. Reason for that is that 0xdbe refreshes both objects/views.
p4) Painful development with oracle procedures
Static code analysis in most cases does not detect any issues which often leads to corrupted packages (no errors detected, scarce error descriptions, etc..)
Feature list:
f1) Basic calculations on selected numeric field in data viewer (picture example from excel)
f2) Show number of columns in the result set of the data viewer for the executed query
f3) Highlight different cells comparing previous and current row
This feature comes very handy when dealing with loads of columns
f4) Execute query at cursor level
This option would be useful when dealing with several nested queries but executing just some of them. Currently I am solving this issue by expanding the selection and using a shortcut for "execute selected". The drawback is that I have to expand the selection 7 times before covering the desired result. The square in the bellow pic shows the query that I want to run. Cursor is marked in yellow.
f5) Visual distinction between private and public procedures
In sql developer distinction is done by obscuring private methods
Attachment(s):
f3_diff.png
p1_narrow_down.png
p2_error_desc..png
p3_split.png
f4_curs_level_exec.png
请先登录再写评论。
Picture for the first feature.
Attachment(s):
f1_basic_stats.png
Any feedback on this?
Another strange behaviour occurs with bookmarks. I do not know how but I managed to bookmark a line twice (one reference is probably null). After 0xdbe was restarted the problem has gone.
Attachment(s):
p5.png
Hello,
Thank you for your feedback very much! Sorry for deplayed reply, please see below.
It looks like you are using custom "Surround With" **live template**. In this case you can choose it(your own live template) via dedicated shortcut for Live Templates: Crel+Alt+J, then you will be given menu with only Live Templates and will be able to choose needed template without conflict. If you want to choose action from "Surround With" menu use corresponding mnemonics: 1, 2, 3 etc. Other solution is no select **Disable mnemonics in menu** and **Disable mnemonics in controls** options in Settings | Appearance & Behaviour | Appearance menu or change live template abbreviation.
See also related threads in there YouTrack tickets:
https://youtrack.jetbrains.com/issue/IDEA-127318
https://youtrack.jetbrains.com/issue/IDEA-101364 - feel free to vote for this one
IDE returns the error codes (and associated text from the server). Can you please give examples of the same error in 0xDBE and SQL Developer for some situation? I will file an enchantment requests in out tracker.
Thank you, created the https://youtrack.jetbrains.com/issue/DBE-1330 . Please vote (see https://intellij-support.jetbrains.com/entries/23368682 if you are not familiar with YouTrack)
Please file YouTrack issue for specific cases providing the example so that we could fix each one. Thanks.
Thank you! Created the https://youtrack.jetbrains.com/issue/DBE-1331 . Please vote.
Do you mean the number of each column? When this functionality would be needed for you? Note that you can choose to display column names here https://db.tt/asQmqtPx
Do you mean some specific selection feature only for rows next to each other or just to be able to select any cell?
Please vote for https://youtrack.jetbrains.com/issue/DBE-297 for executing current statement under cursor.
Please vote https://youtrack.jetbrains.com/issue/DBE-1332
This is know issue, please follow the https://youtrack.jetbrains.com/issue/IDEA-98718
Hi,
here are some additional informations about the issues:
p1) Like I could read from the link "speed search" would provide ambiguity so I will try to use mnemonics instead.
p2) Example in the attachment is from sql developer. The difference is that sql developer shows the cause of the error too. Maybe a feature of setting a level of logging would come handy.
f2) Here I was thinking just about a simple count of total number of column in the query that would be located in the data viewer area near the slider displaying row range. Hiding elements from data viewer that you do not use frequently would be nice to have too.
f3) Comparison would take previous and current row and then compare cells in their correspodning columns. Cell from the current row that has different value in a previous row would be collored.
Attachment(s):
p2_error_details_sql_developer.png
p2_error_details_0xdbe.png
Thanks for your feedback.
>p2)
Created the https://youtrack.jetbrains.com/issue/DBE-1599 . Please vote for the request.
>f2)
See http://i.imgur.com/oTdz3es.png . Does it help?
>f3)
Please vote for https://youtrack.jetbrains.com/issue/DBE-1105
f2) yes that would help but probably its position would bring some confusion in combination with arrows for row pagination?
You are very welcome to file a suggestion at https://youtrack.jetbrains.com/issues?q=%23DBE+ for the best way of implementing this.