• Home
• com.github.seratch
• csvquery_2.10
• 0.2
• source code
• CSV.scala

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

csvquery.CSV.scala Maven / Gradle / Ivy

package csvquery

import scalikejdbc._

case class CSV(filepath: String, columns: Seq[String], charset: String = "UTF-8") {

  def toTable: SQLSyntax = {
    val file = sqls"'${unsafe(filepath)}'"
    val csv = sqls"'${unsafe(columns.map(_.toUpperCase).mkString(","))}'"
    val c = sqls"'${unsafe(charset)}'"
    sqls"csvread($file, $csv, $c)"
  }

  private[this] def unsafe(v: String): SQLSyntax = SQLSyntax.createUnsafely(v)
}