WARNING: Be aware of SQL injection vulnerability.
Returns an optional SQLSyntax which is flatten (from option array) and joined with 'and'.
Returns an optional SQLSyntax which is flatten (from option array) and joined with 'and'.
val (id, name) = (123, "Alice") val cond: Option[SQLSyntax] = SQLSyntax.toAndConditionOpt(Some(sqls"id = ${id}"), None, Some(sqls"name = ${name} or name is null")) cond.get.value // "id = ? and (name = ? or name is null)" cond.get.parameters // Seq(123, "Alice")
Returns an optional SQLSyntax which is flatten (from option array) and joined with 'or'.
Returns an optional SQLSyntax which is flatten (from option array) and joined with 'or'.
val (id, name) = (123, "Alice") val cond: Option[SQLSyntax] = SQLSyntax.toOrConditionOpt(Some(sqls"id = ${id}"), None, Some(sqls"name = ${name} or name is null")) cond.get.value // "id = ? or (name = ? or name is null)" cond.get.parameters // Seq(123, "Alice")