Scala 字符串插值: s插值

val pageLevelId = 3
val pageLevelName = "entrance"
val funnel = Map(2 -> List(11111), 4 -> List(7), 3 -> List(402, 403), 5 -> List(1572, 1574))
val bg = s"$pageLevelName.page_id = 254" :: s"$pageLevelName.page_value in('%s')".format(funnel(pageLevelId).mkString("','")) :: s"page_level_id = $pageLevelId" :: Nil
println(bg)


val pageValues = 2
val sqlStr = s"""select
        |date as date_id,           
        |site_id,
        |terminal_id,
        |cate_level1_id,
        |from dw.fct_ordr_path_off
        |where date = '%s'
        |and $pageValues
        |group by
        |date,
        |site_id,
        |terminal_id,
        |cate_level1_id,
        |cate_level2_id,
        |cate_level3_id;""".stripMargin
val sql = String.format(sqlStr, "{$date}")
println(sql)