calasql-query_3.0.1.5.source-code.InsertColumns.scala Maven / Gradle / Ivy
package scalasql.query
import scalasql.core.{Context, DialectTypeMappers, Queryable, Expr, SqlStr, WithSqlExpr}
import scalasql.core.SqlStr.{Renderable, SqlStringSyntax}
/**
* A SQL `INSERT VALUES` query
*/
trait InsertColumns[V[_[_]], R]
extends Returning.InsertBase[V[Column]]
with Query.ExecuteUpdate[Int] {
def columns: Seq[Column[?]]
def valuesLists: Seq[Seq[Expr[?]]]
}
object InsertColumns {
class Impl[V[_[_]], R](
insert: Insert[V, R],
val columns: Seq[Column[?]],
val valuesLists: Seq[Seq[Expr[?]]]
)(implicit val qr: Queryable[V[Column], R], dialect: DialectTypeMappers)
extends InsertColumns[V, R] {
import dialect.{dialectSelf => _, _}
def table = insert.table
protected def expr: V[Column] = WithSqlExpr.get(insert)
private[scalasql] override def renderSql(ctx: Context) =
new Renderer(columns, ctx, valuesLists, Table.name(table.value)).render()
override protected def queryConstruct(args: Queryable.ResultSetIterator): Int =
args.get(IntType)
}
class Renderer(
columns0: Seq[Column[?]],
prevContext: Context,
valuesLists: Seq[Seq[Expr[?]]],
tableName: String
) {
implicit lazy val ctx: Context = prevContext
lazy val columns = SqlStr
.join(columns0.map(c => SqlStr.raw(ctx.config.columnNameMapper(c.name))), SqlStr.commaSep)
lazy val values = SqlStr.join(
valuesLists
.map(values =>
sql"(" + SqlStr.join(values.map(Renderable.renderSql(_)), SqlStr.commaSep) + sql")"
),
SqlStr.commaSep
)
def render() = {
sql"INSERT INTO ${SqlStr.raw(ctx.config.tableNameMapper(tableName))} ($columns) VALUES $values"
}
}
}