• Home
• com.lihaoyi
• scalasql-operations_2.13
• 0.1.9
• source code

×

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.

calasql-operations_2.13.0.1.9.source-code.ExprStringOps.scala Maven / Gradle / Ivy

package scalasql.operations

import scalasql.core.Expr
import scalasql.core.SqlStr.SqlStringSyntax

trait ExprStringOps[T] {
  protected def v: Expr[T]

  /** Removes leading and trailing whitespace characters from a character string. */
  def trim: Expr[T] = Expr { implicit ctx => sql"TRIM($v)" }

  /** Removes leading whitespace characters from a character string. */
  def ltrim: Expr[T] = Expr { implicit ctx => sql"LTRIM($v)" }

  /** Removes trailing whitespace characters from a character string. */
  def rtrim: Expr[T] = Expr { implicit ctx => sql"RTRIM($v)" }

  /**
   * The replace(X,Y,Z) function returns a string formed by substituting string Z
   * for every occurrence of string Y in string X
   */
  def replace(y: Expr[T], z: Expr[T]): Expr[T] = Expr { implicit ctx =>
    sql"REPLACE($v, $y, $z)"
  }

}