CODEWITHSUNDEEP
datagrip
user123
user123

Reputation: 78

DataGrip current statement highlighting

I installed DataGrip and spent a couple hours getting rid of bells and whistles that distract me from editing sql, like the lightbulb. I'm down to this one that for my life I can't figure, so when I move around with the caret, the editor comes up with what it thinks is the current statement and draws a thin border around it, say if it's a line ending in a semicolon, it will border just that line, but if I have several statements each not ending in semicolon, it will think they all make up a single one and draw the rectangle around the whole thing. This in itself is distracting, plus if I hit Enter within the border, it will indent differently according to what it thinks the whole thing is. I just want Enter to go to a new line at the 0, leftmost position.

Is there any way to turn the whole feature off completely?

Apart from that, does anyone know if it's possible to get DataGrip to display the number of rows affected after an INSERT or UPDATE, like most other tools do?

I'm using it with Postgresql. Thank you in advance!

Upvotes: 1

Views: 1648

Answers (1)

moscas
moscas

Reputation: 10335

cpp_developer! (By the way, what do you think about CLion? :) There are several questions in one, let's get answers one by one.

  1. Lightbulb: there is no UI for getting rid of it, but there is the way. It is described in this ticket: https://youtrack.jetbrains.com/issue/IDEA-94381 TLDR:

Following line should be added to the $IDE_CONFIG_HOME/options/editor.xml then: 

<option name="SHOW_INTENTION_BULB" value="false" />

  1. Line showing the current statement.

It can be removed, like any other color/font thing: A small helpful action. For now it is only present in the Find Action menu (Ctrl/Cmd+Shift+A), but as usual, you can assign any shortcut to it.

enter image description here

This action will navigate you to the settings which are relevant to the context under the caret. If there are several of them, just choose one. In your case "Statement to execute". Then remove it or make white.

enter image description here

  1. Smart indenting. Just turn this off: enter image description here

  2. Number of INSERTed and UPDATEd rows can be found in Output tab. But please, run them in batch mode -> context menu "Run %your_console%.sql" enter image description here

Upvotes: 3

Related Questions