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

Go to download
Show more of this group Show more artifacts with this name
Show all versions of scalasql-operations_2.13 Show documentation
scalasql-operations
The newest version!
package scalasql.operations

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

class ExprNumericOps[T: Numeric](v: Expr[T])(implicit val m: TypeMapper[T]) {

  /** Addition */
  def +[V: Numeric](x: Expr[V]): Expr[T] = Expr { implicit ctx => sql"($v + $x)" }

  /** Subtraction */
  def -[V: Numeric](x: Expr[V]): Expr[T] = Expr { implicit ctx => sql"($v - $x)" }

  /** Multiplication */
  def *[V: Numeric](x: Expr[V]): Expr[T] = Expr { implicit ctx => sql"($v * $x)" }

  /** Division */
  def /[V: Numeric](x: Expr[V]): Expr[T] = Expr { implicit ctx => sql"($v / $x)" }

  /** Remainder */
  def %[V: Numeric](x: Expr[V]): Expr[T] = Expr { implicit ctx => sql"MOD($v, $x)" }

  /** Bitwise AND */
  def &[V: Numeric](x: Expr[V]): Expr[T] = Expr { implicit ctx => sql"($v & $x)" }

  /** Bitwise OR */
  def |[V: Numeric](x: Expr[V]): Expr[T] = Expr { implicit ctx => sql"($v | $x)" }

  /** Bitwise XOR */
  def ^[V: Numeric](x: Expr[V]): Expr[T] = Expr { implicit ctx => sql"($v ^ $x)" }

  /** TRUE if the operand is within a range */
  def between(x: Expr[Int], y: Expr[Int]): Expr[Boolean] = Expr { implicit ctx =>
    sql"$v BETWEEN $x AND $y"
  }

  /** Unary Positive Operator */
  def unary_+ : Expr[T] = Expr { implicit ctx => sql"+$v" }

  /** Unary Negation Operator */
  def unary_- : Expr[T] = Expr { implicit ctx => sql"-$v" }

  /** Unary Bitwise NOT Operator */
  def unary_~ : Expr[T] = Expr { implicit ctx => sql"~$v" }

  /** Returns the absolute value of a number. */
  def abs: Expr[T] = Expr { implicit ctx => sql"ABS($v)" }

  /** Returns the remainder of one number divided into another. */
  def mod[V: Numeric](x: Expr[V]): Expr[T] = Expr { implicit ctx => sql"MOD($v, $x)" }

  /** Rounds a noninteger value upwards to the next greatest integer. Returns an integer value unchanged. */
  def ceil: Expr[T] = Expr { implicit ctx => sql"CEIL($v)" }

  /** Rounds a noninteger value downwards to the next least integer. Returns an integer value unchanged. */
  def floor: Expr[T] = Expr { implicit ctx => sql"FLOOR($v)" }

  /**
   * The sign(X) function returns -1, 0, or +1 if the argument X is a numeric
   * value that is negative, zero, or positive, respectively. If the argument to sign(X)
   * is NULL or is a string or blob that cannot be losslessly converted into a number,
   * then sign(X) returns NULL.
   */
  def sign: Expr[T] = Expr { implicit ctx => sql"SIGN($v)" }
}