[PHP-CVS] cvs: php-src /ext/sqlite/tests sqlite_oo_031.phpt

[Marcus Boerger]

helly           Sun Jan 18 15:57:43 2004 EDT

  Added files:                 
    /php-src/ext/sqlite/tests   sqlite_oo_031.phpt 
  Log:
  Add spl interaction test.
  
  

Index: php-src/ext/sqlite/tests/sqlite_oo_031.phpt
+++ php-src/ext/sqlite/tests/sqlite_oo_031.phpt
--TEST--
sqlite-oo: and spl
--SKIPIF--
<?php # vim:ft=php
if (!extension_loaded("sqlite")) print "skip"; 
if (!extension_loaded("spl")) print "skip SPL is not present"; 
?>
--FILE--
<?php
include "blankdb_oo.inc";

$db->query("CREATE TABLE menu(id_l int, id_r int, key VARCHAR(10))");
$db->query("INSERT INTO menu VALUES( 1, 12, 'A')"); 
$db->query("INSERT INTO menu VALUES( 2,  9, 'B')"); 
$db->query("INSERT INTO menu VALUES(10, 11, 'F')"); 
$db->query("INSERT INTO menu VALUES( 3,  6, 'C')"); 
$db->query("INSERT INTO menu VALUES( 7,  8, 'E')"); 
$db->query("INSERT INTO menu VALUES( 4,  5, 'D')"); 

class SqliteNestedsetElement
{
        protected $id_l;
        protected $id_r;
        protected $key;

        function __construct($db)
        {
                $this->db = $db;
        }
        
        function getLeft()
        {
                return $this->id_l;
        }
        
        function getRight()
        {
                return $this->id_r;
        }
        
        function __toString()
        {
                return $this->key;
        }

        function key()
        {
                return $this->key;
        }
}

class SqliteNestedset implements RecursiveIterator
{
        protected $id;
        protected $id_l;
        protected $id_r;
        protected $entry;

        function __construct($db, $id_l = 1, $id_r = 0)
        {
                $this->db = $db;
                $this->id_l = $id_l;
                $this->id_r = $id_r ? $id_r : $this->db->single_query('SELECT 
max(id_r) FROM menu', 1);
                $this->id = $id_l;
        }
        
        function rewind()
        {
                $this->id = $this->id_l;
                $this->fetch();
        }

        function hasMore()
        {
                return is_object($this->entry);
        }
        
        function current()
        {
                return (string)$this->entry;
        }
        
        function key()
        {
                return $this->entry->key();;
        }
        
        function next()
        {
                $this->id = $this->entry->getRight() + 1;
                $this->fetch();
        }

        protected function fetch()
        {
                $res = $this->db->unbuffered_query('SELECT * FROM menu WHERE 
id_l='.$this->id);
                $this->entry = $res->fetch_object('SqliteNestedsetElement', 
array(&$this->db));
                unset($res);
        }
        
        function hasChildren()
        {
                return $this->entry->getLeft() + 1 < $this->entry->getRight();
        }
        
        function getChildren()
        {
                return new SqliteNestedset($this->db, $this->entry->getLeft() + 1, 
$this->entry->getRight() - 1);
        }
}

$menu_iterator = new RecursiveIteratorIterator(new SqliteNestedset($db), 
RIT_SELF_FIRST);
foreach($menu_iterator as $entry) {
        echo $menu_iterator->getDepth() . $entry . "\n";
}
?>
===DONE===
--EXPECT--
0A
1B
2C
3D
2E
1F
===DONE===

-- 
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php