Slick 3.1 - Printing SQL from DBIOAction (insert statements)

Question

In Slick 3.1, with the complete redesign of the new API, it seems to be impossible to view the generated SQL statements when doing an insert.

If you have something like this

val action = DBIO.seq(
  SomeTables ++= Seq(TableData(1,"First"),TableData(2,"Second"))
)

It doesn't seem you are actually able to see the generated SQL from the action. The result method doesn't actually exist, and variations of statements just print ? in place of the actual values if you don't use DBIO.seq, if you are using DBIO.seq the statements method doesn't actually exist.

Even when using methods such as .transactionally or .withPinnedSession, it doesn't seem to make a difference (however I don't know how this should help).

From observation of all of the methods, it appears that this is impossible?

Same here, tried to find a way to print the sql from DBIOAction but with no luck. Hope someone here point us towards correct direction. It prints "?" because it is defaulting to Prepared Statement? — suraj_fale, Feb 12 '19 at 19:51
there is a way in the documentation : http://slick.lightbend.com/doc/3.0.0/queries.html#querying — SyMo7amed, Mar 14 '19 at 16:26
New feature added to 3.2. and then add to log4j this is working as expected. — Somnath Sarode, Dec 03 '19 at 12:07

score 1 · Answer 1 · answered Feb 06 '20 at 09:46

This is not handle by Slick 3.1 you can see the source code, but you can get this feature available into Slick 3.2 version.

If you a have a larger code base & can't upgrade to 3.2 in that case you can just add this commit to 3.1 source code, build & use it. Make sure you import the necessary things required for the commit.

Slick 3.1 - Printing SQL from DBIOAction (insert statements)

1 Answers1

Linked