Slick for play using native SQL queries and stitching SQL

It's cool to manipulate the database on play with functional framework slick. But sometimes, because of some special scenarios, you have to use native SQL. Fortunately slick support this notation, you can look at slick official documents, slick Plain SQL queries

Http://slick.lightbend.com/doc/3.1.1/sql-to-slick.html#slick-plain-sql-queries

Here is my scene, one of my system has a table, because this system is also a technical staff, in order to facilitate directly on the table open a SQL query box, used to do conditional filtering. When the user enters the SQL where after the condition, need to put the conditions behind SQL, this is the use of slick native SQL execution mode.

The code is as follows:

Implicit val gethostresult = GetResult (r = = Host (r.<<, r.<<, r.<<, r.<<, r.<<, r.<< ;, r.<<, r.<<, r.<<, r.<<, r.<<= Db.run ((sql "SELECT * from Ops_host where 1=1 # $con Dition ". As[host]))

Note that Gethostresult is very important, it is used to convert the results returned by the SQL query, if you do not define Gethostresult, then the results can not be resolved, resulting in an error.

Another thing to be aware of is the # $condition

$ is used to pass a variable, but the value passed in will be enclosed in single quotes and will be escaped, that is, if you pass and Name= ' Lemontea ' will become ' and name=\ ' lemontea\ '

So in order not to be escaped, just add the # to the front.

Original articles, reproduced please indicate the source.

Slick for play using native SQL queries and stitching SQL