1

How can I run a statement in the sql query console in manual mode on datagrip and see their effect on the table locally in order to make sure it has the intended effect before committing it to the database?

modernNeo
  • 137
  • 9

2 Answers2

1

From DataGrip 2020.2 you can review the query that represents your changes in the data editor.

DML button is active if there are pending changes: DML Preview

Vasilii Chernov
  • 1,169
  • 8
  • 17
  • I went to the table, right-clicked on it and jumped to a query console, set my mode to manual and then executed all the statements. but when I went back to the table view tab, my DML was still grayed out. My console view of that same table indicates there are pending changes and the green check mark for committing is active but when I go the table view, the DML button is still grayed out. – modernNeo Sep 18 '20 at 15:44
  • Could you file an issue in DataGrip bug tracker https://youtrack.jetbrains.com/issues/DBE and attach a screen cast with the problem? – Vasilii Chernov Sep 21 '20 at 12:43
  • can't seem to load that page. just got blank, these are the console message if relevant https://imgur.com/a/e5Lzl3Z – modernNeo Sep 29 '20 at 22:12
  • Kinda strange, let's try this one https://youtrack.jetbrains.com/newIssue?project=DBE – Vasilii Chernov Sep 30 '20 at 08:34
  • let it load for 20 minutes and same deal. this is all I could see https://imgur.com/a/3XcgYJz . is that normal? – modernNeo Sep 30 '20 at 18:03
  • never mind, its working now. wonder what was going on there before – modernNeo Oct 01 '20 at 16:11
  • ah, the issue is that I was running a slightly older version of firefox on one of my machines. – modernNeo Oct 01 '20 at 16:23
  • So, what about the issue? – Vasilii Chernov Oct 02 '20 at 14:20
  • apparently what I had wanted was actually a context action. an intellij rep responded and said `There is a context action "Preview update" (right click > show context actions)` – modernNeo Oct 07 '20 at 20:38
0

There is a context action "Preview update". (right click on statement > show context actions)

modernNeo
  • 137
  • 9