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 }