Scala/Slick普通SQL:以地图形式检索结果 [英] Scala/Slick plain SQL: retrieve result as a map

问题描述

我有一个简单的方法可以使用Sclick纯SQL方法从数据库中检索用户:

I have a simple method to retrieve a user from a db with Sclick plain SQL method:

object Data {

    implicit val getListStringResult = GetResult[List[String]] (
        prs => (1 to prs.numColumns).map(_ => prs.nextString).toList
    )

    def getUser(id: Int): Option[List[String]] = DB.withSession {
        sql"""SELECT * FROM "user" WHERE "id" = $id""".as[List[String]].firstOption
    }

}

结果是List[String]，但我希望它像Map[String, String]一样-列名和值对映射.这可能吗?如果可以，怎么办?

The result is List[String] but I would like it to be something like Map[String, String] - column name and value pair map. Is this possible? If so, how?

我的堆栈是Play Framework 2.2.1，Slick 1.0.1，Scala 2.10.3，Java 8 64bit

My stack is Play Framework 2.2.1, Slick 1.0.1, Scala 2.10.3, Java 8 64bit

推荐答案

import scala.slick.jdbc.meta._
val columns = MTable.getTables(None, None, None, None)
                    .list.filter(_.name.name == "USER") // <- upper case table name
                    .head.getColumns.list.map(_.column)
val user = sql"""SELECT * FROM "user" WHERE "id" = $id""".as[List[String]].firstOption
                                                         .map( columns zip _ toMap )

这篇关于Scala/Slick普通SQL:以地图形式检索结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！