[sqlite] Modified Preorder Tree Traversal Algorithm

[Andrea Giammarchi]

Hi, I am trying to develop a php class that should implement MPTTA on 
SQLITE and results are great!!

BUT, I'm not finding any way to move a branch under another , I' ve just 
moved successfully a unique branch on same level on another but anymore ...

On MYSQL someone use this sintax
|SELECT      n1.root_id,
           n1.name n1name, n1.lft n1lft, n1.rgt n1rgt,
           n2.name n2name, n2.lft n2lft, n2.rgt n2rgt
FROM        table AS n1
LEFT OUTER JOIN
   table AS n2
   ON (
       n1.lft = (n2.rgt+1)
       AND
       n1.rgt > n2.rgt
       AND
       n1.root_id = n2.root_id
   )
WHERE    n1.id=$id
and then
||UPDATE     ||table ||
               SET        lft=lft + 
IF(lft<".$nodes["n1lft"].",$inc,-$desc),
                       rgt=rgt + IF(rgt<".$nodes["n1lft"].",$inc,-$desc)
               WHERE    root_id=$root_id
                       AND
                       lft>=".$nodes["n2lft"]."
                       AND
                       rgt<=".$nodes["n1rgt"]."

But on SQLITE there's not IF statement ... than should anyone tell me if 
there's a way to simulate nodemovement procedures on SQLITE ?

Thank you
|