From f1c217d2e6ff2e195e7374605878c7a347a074c7 Mon Sep 17 00:00:00 2001 From: kseniya Date: Thu, 21 Sep 2017 16:17:49 +0700 Subject: Fix slick query builder bug --- src/main/scala/xyz/driver/pdsuicommon/db/SlickQueryBuilder.scala | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) (limited to 'src/main/scala/xyz/driver/pdsuicommon/db/SlickQueryBuilder.scala') diff --git a/src/main/scala/xyz/driver/pdsuicommon/db/SlickQueryBuilder.scala b/src/main/scala/xyz/driver/pdsuicommon/db/SlickQueryBuilder.scala index 79cb114..ab2757b 100644 --- a/src/main/scala/xyz/driver/pdsuicommon/db/SlickQueryBuilder.scala +++ b/src/main/scala/xyz/driver/pdsuicommon/db/SlickQueryBuilder.scala @@ -203,7 +203,7 @@ sealed trait SlickQueryBuilderParameters { val operator = op match { case Eq => sql"=" case NotEq => sql"!=" - case Like => sql"like" + case Like => sql" like " case Gt => sql">" case GtEq => sql">=" case Lt => sql"<" @@ -213,12 +213,13 @@ sealed trait SlickQueryBuilderParameters { case Atom.NAry(dimension, op, values) => val sqlOp = op match { - case SearchFilterNAryOperation.In => sql"in" - case SearchFilterNAryOperation.NotIn => sql"not in" + case SearchFilterNAryOperation.In => sql" in " + case SearchFilterNAryOperation.NotIn => sql" not in " } val formattedValues = if (values.nonEmpty) { - sql"${values.mkString(",")}" + val condition = s"(${values.map(v => "'" + v.toString + "'").mkString(",")})" + sql"#${condition}" } else sql"NULL" sql"#${escapeDimension(dimension)}" concat sqlOp concat formattedValues -- cgit v1.2.3