@@ 723-731 (lines=9) @@ | ||
720 | return !Yii::app()->db->createCommand('SELECT COUNT(`id`) FROM `NestedSet` WHERE MOD(`lft`-`level`,2);')->queryScalar(); |
|
721 | } |
|
722 | ||
723 | private function checkTree4() |
|
724 | { |
|
725 | $row=Yii::app()->db->createCommand('SELECT MIN(`lft`),MAX(`rgt`),COUNT(`id`) FROM `NestedSet`;')->queryRow(false); |
|
726 | ||
727 | if($row[0]!=1 || $row[1]!=$row[2]*2) |
|
728 | return false; |
|
729 | ||
730 | return true; |
|
731 | } |
|
732 | ||
733 | private function checkArray($array) |
|
734 | { |
|
@@ 824-835 (lines=12) @@ | ||
821 | return !Yii::app()->db->createCommand('SELECT COUNT(`id`) FROM `NestedSetWithManyRoots` WHERE MOD(`lft`-`level`,2) GROUP BY `root`;')->query()->getRowCount(); |
|
822 | } |
|
823 | ||
824 | private function checkTreeWithManyRoots4() |
|
825 | { |
|
826 | $rows=Yii::app()->db->createCommand('SELECT MIN(`lft`),MAX(`rgt`),COUNT(`id`) FROM `NestedSetWithManyRoots` GROUP BY `root`;')->queryAll(false); |
|
827 | ||
828 | foreach($rows as $row) |
|
829 | { |
|
830 | if($row[0]!=1 || $row[1]!=$row[2]*2) |
|
831 | return false; |
|
832 | } |
|
833 | ||
834 | return true; |
|
835 | } |
|
836 | ||
837 | private function checkArrayWithManyRoots($array) |
|
838 | { |