Sql query with anorm. Can not use pattern matching

Question

The code snippet shown below is supposed to be used to retrieve some data from database.

import anorm._

object Instruction {

 def findAll(date:String):List[RealTimeInstruction]={

    query = SQL("""
                select * from instructions where date > {dd}
                """).on("dd"->date)
 }

}

Then I would like to use pattern matching to execute the query and process the results. However, when I attemp to use query.map(...) I get the following:

value map is not a member of anorm SimpleSql.

How can I do it?

queryis just an SQL query. You first have to execute it. Then you can pattern match results or use the parser to create the objects you want. The usage depends on what you are trying to do. You should perhaps read again the anorm tutorial. If it's not clear for you, you should edit your code snippet to explain your goal. — paradigmatic
– paradigmatic, Commented May 14, 2012 at 13:36

stew · Accepted Answer · 2012-05-14 13:35:01Z

1

You need to create a ResultSetParser to parse the result set into somehting you can pattern match on. perhaps something like

val rowParser : RowParser[String~Date] = get[String]("instructions.name")~get[Date]("instructions.date")
val resultSetParser = rowParser *
(query as resultSetParser) map { case name~date => ... }

answered May 14, 2012 at 13:35

stew

11.4k39 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql query with anorm. Can not use pattern matching

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related