CODEWITHSUNDEEP
scalaslick
notan3xit
notan3xit

Reputation: 2436

Count rows with Slick 1.0.0

I'm trying to create a query with Slick 1.0.0 that returns a row count equivalent to the following SQL statement:

SELECT COUNT(*) FROM table;

What I have so far is:

val query = for {
  row <- Table
} yield row
println(query.length)

This prints scala.slick.ast.FunctionSymbol$$anon$1@6860991f. Also, query.length appears to be of type scala.slick.lifted.Column. I cannot find a way to execute the query. All examples that I can find in the documentation and anywhere else do not operate on Column or are for ScalaQuery and do not work anymore.

What can I do to execute this?

Upvotes: 8

Views: 4408

Answers (3)

fickludd
fickludd

Reputation: 1157

Although I wasn't able to check the resulting sql, you could get shorter source by dropping .list:

Query(MyTable.length).first

Upvotes: 4

Jack
Jack

Reputation: 16728

Any of these should do the trick:

Query(MyTable).list.length

or

(for{mt <- MyTable} yield mt).list.length

or

(for{mt <- MyTable} yield mt.count).first

Update:

Printing the H2 database log shows this for the last query, which looks optimal:

 03:31:26.560 [main] DEBUG h2database - jdbc[2]
 /**/PreparedStatement prep10 = conn1.prepareStatement("select select count(1) from \"MYTABLE\" s5", 1003, 1007);

Upvotes: 4

thikonom
thikonom

Reputation: 4267

Use:

val query = for(row <- Table) yield row 
println(Query(query.count).first)

The count is equivalent to "SELECT COUNT(*) FROM Table". In order to get the first and only row you have to use first to get the count.

Upvotes: 2

Related Questions