Slick recursive insert example:

Test of recursive insert with help of Slick

The project demonstrate the recursive insert of records in a table in order to model the persistence of a query WHERE clause such as:

 ... WHERE field1 eq val1 AND field2 lt val2 AND (field3 gt val3 OR field4 eq val4)

which is equivalent to:

and(  and(eq(val1,field1), lt(field2,val2)) , or(gt(field3,val3), eq(field4,val4))  )

To be inserted the data must be in DFS (Deep First Search) order considering a "tree" formed by the WHERE clause.

The above clause data may be supplied as follow:

 Seq(
   (AND,    None  ,   None)
   (AND,    None  ,   None)
   (EQ ,    field1,   val1)
   (LT ,    field2,   val2)
   (OR ,    None  ,   None)
   (GT ,    field4,   val4)
   (EQ ,    field5,   val5)
 )