Select in scalikejdbc

  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
  }