To 1: With Auto-popup you mean the Code completion Right? Yes there should be an Option to Change this. Atm every supported language has this Option (Code completion on ‚.‘ or whenever it is possible)
To 2: Yes, I don’t know whether the warning is in the Bottom of the statusbar, but I don’t think so. For me I would switch from the dialog to a notification. Then we have it in the Status bar. And if someone removes it, it can come up after a delay Maybe of 10 min to give him a hint (should be optional) To 3: Yes Please wait…should not be used for if the Connection is lost. More the normal info like „no items available“. Don’t know the exact wording. But it should be as consistent as possible compared to the other languages. Cheers Chris Von: Pete Whelpton Gesendet: Dienstag, 31. März 2020 12:48 An: [email protected] Betreff: Re: Auto completion support for Database languages. Thanks for the background, Chris! As well as the warning dialog pop-up about no SQL connection, I believe Netbeans also logs the message to the status bar at the bottom? I think the ideal solution would be support for multiple SQL dialects (with ability to add more via plugin), with the option to chose which dialect is parsed from a drop-down on the SQL editor (similar to a SQL plugin I've seen for IntelliJ) That seems a lot of work though, so a quick win to get the already included SQL completion more visible / usable might be: 1) Change the auto pop-up logic so it pops up after first character typed (and filters on this), rather than only after . 2) Remove the dialog about no SQL connection popping up, so the error is just on the status bar at the bottom of NB? 3) Just klimming to code, I've got a feeling the code completion will hang on completion (with the Please wait... message) after a . if no SQL connection is made. So that should be handled gracefully. Thoughts, anyone? P On Tue, 31 Mar 2020, 11:33 Christian Lenz, <[email protected]> wrote: > Hey Pete, > > I think your ticket https://issues.apache.org/jira/browse/NETBEANS-188 is > dependent from the other with the missing Connection > https://issues.apache.org/jira/browse/NETBEANS-189. So the Problem is, if > 189 is not resolved, 188 doesn’t make sense. Because, as often as you type, > and the Code completion Comes up immediately, it Shows you the Dialog of > missing Connection, when you have a simple SQL file w/o a Connection to a > DB which is annoying. > > > Cheers > > Chris > > > > > Von: Pete Whelpton > Gesendet: Dienstag, 31. März 2020 11:51 > An: [email protected] > Betreff: Re: Auto completion support for Database languages. > > One thing I noticed about the basic SQL completion in Netbeans, the > getAutoQueryTypes(JTextComponent component, String typedText) method > of SQLCompletionProvider.java starts with the following: > > if (!".".equals(typedText)) { > return 0; > } > > which means the Code Completion dialog won't pop-up automatically, > except after a . character. So it will offer auto-completion for > things like column names for fully qualified columns ([table].[column] > etc.), but not SQL keywords - which can make it appear that Netbeans > has no SQL completion at all! Code completion dialog, including SQL > keywords, will still pop-up when hitting Ctrl-Space though... > > Chris L logged a Jira about it: > https://issues.apache.org/jira/browse/NETBEANS-188 > > I assumed that code was there for a reason, so was hesitant to remove > it. But if there is no good reason to suppress the Code Completion > dialog, perhaps that code should be removed? I'd be happy to do the > PR. > > > Also, the list of supported SQL keywords is very basic, and based on > the SQL-99 Complete book. See > /ide/dbapi/src/org/netbeans/modules/db/api/sql/SQLKeywords.java > > Hope that helps! > > P > > > On Tue, Mar 31, 2020 at 12:42 AM Tim Boudreau <[email protected]> wrote: > > > > Well, that shows how often I do SQL in anything other than a text console > > :-) > > > > -Tim > > > > On Mon, Mar 30, 2020 at 4:04 PM Matthias Bläsing < > [email protected]> > > wrote: > > > > > Hi, > > > > > > Am Montag, den 30.03.2020, 21:04 +0600 schrieb Brain Rebooting: > > > > Is there any possibility that Netbeans will support autocompletion > for > > > > database language like IntelliJ Idea in the near future? > > > > > > there already is. Create a ".sql" file and connect to a DB. You will > > > get SQL completion and syntax highlighting. > > > > > > It is currently tied to a connected DB, but it could be improved. An > > > issue is already filed for this: > > > > > > https://issues.apache.org/jira/browse/NETBEANS-189 > > > > > > Greetings > > > > > > Matthias > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [email protected] > > > For additional commands, e-mail: [email protected] > > > > > > For further information about the NetBeans mailing lists, visit: > > > https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists > > > > > > > > > > > > -- > > http://timboudreau.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > For further information about the NetBeans mailing lists, visit: > https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists > > > > >
