def selectComponents(customerIdx: String)
(implicit session: DBSession):
List[(Int, Array[String], String)] = {
val nodeTypeId = NodeType.predefComponent.id
//noinspection RedundantBlock
val sql: SQL[Nothing, NoExtractor] = sql"""
SELECT id, path, text_id FROM eden2.node
WHERE node_type_id = ${nodeTypeId}
"""
//add? JOIN FleetDataSet fdsx ON cx.index = fdsx.customer_index
val triples = sql.map(rs ⇒
(rs.int("id"), rs.string("path").split("\\."), rs.string("text_id"))
).list().apply()
triples
}
Comments
0 B
|0 👍
/0 👎
0 B
|👍
/👎