dbsimple.php

来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· PHP 代码 · 共 410 行 · 第 1/2 页

<?php
//
// +----------------------------------------------------------------------+
// | PHP Version 4                                                        |
// +----------------------------------------------------------------------+
// | Copyright (c) 1997-2003 The PHP Group                                |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.02 of the PHP license,      |
// | that is bundled with this package in the file LICENSE, and is        |
// | available at through the world-wide-web at                           |
// | http://www.php.net/license/2_02.txt.                                 |
// | If you did not receive a copy of the PHP license and are unable to   |
// | obtain it through the world-wide-web, please send a note to          |
// | [e-mail] so we can mail you a copy immediately.               |
// +----------------------------------------------------------------------+
// | Authors: Wolfram Kriesing <[e-mail]>                      |
// +----------------------------------------------------------------------+
//
//  $Id: DBsimple.php,v 1.11 2003/01/18 15:36:50 cain Exp $

require_once('Tree/OptionsDB.php');
require_once('Tree/Error.php');

/**
*   the DB interface to the tree class
*
*   @access     public
*   @author     Wolfram Kriesing <[e-mail]>
*   @version    2001/06/27
*   @package    Tree
*/
class Tree_Memory_DBsimple extends Tree_OptionsDB
// FIXXME should actually extend Tree_Common, to use the methods provided in there... but we need to connect
// to the db here, so we extend optionsDB for now, may be use "aggregate" function to fix that
{

    /**
    *   @access public
    *   @var    array   saves the options passed to the constructor
    */
    var $options =  array(  'order'     =>'',   // which column to order by when reading the data from the DB, this sorts the data even inside every level
                            'whereAddOn'=>'',   // add on for the where clause, this string is simply added behind the WHERE in the select
                                                // so you better make sure its correct SQL :-), i.e. 'uid=3'
                                                // this is needed i.e. when you are saving many trees for different user
                                                // in one table where each entry has a uid (user id)
                            'table'     =>'',   //
                            // the column-name maps are used for the "as" in the select queries
                            // so you can use any column name in the table and "map" it to the name that shall be used in the
                            // internal array, that is built, see the examples (in comments)
                            'columnNameMaps'=>array(
                                   /*           'id'            =>  'tree_id',   // use "tree_id" as "id"
                                                'parentId'      =>  'parent_id',
                                                'prevId'        =>  'previous_id',
                                                'name'          =>  'nodeName'
                                   */
                                                ),
                            );

    /**
    *   @access public
    *   @var    string  the table where to read the tree data from
    *                   can also be set using the DSN in the constructor
    */
    var $table;

    /**
    *   @access private
    *   @var    object  $dbh    the handle to the DB-object
    */
//    var $dbh;

    /**
    *   set up this object
    *
    *   @version    2001/06/27
    *   @access     public
    *   @author     Wolfram Kriesing <[e-mail]>
    *   @param      string  $dsn    this is a DSN of the for that PEAR::DB uses it
    *                               only that additionally you can add parameters like ...?table=test_table
    *                               to define the table it shall work on
    *   @param      array   $options  additional options you can set
    */
    function Tree_Memory_DBsimple( $dsn , $options=array() )
    {
        $this->Tree_OptionsDB( $dsn , $options ); // instanciate DB
        if( is_string($options) )                  // just to be backward compatible, or to make the second paramter shorter
        {
            $this->setOption( 'order' , $options );
        }

        $this->table = $this->getOption('table');

    } // end of function

    /**
    *   retreive all the navigation data from the db and call build to build the
    *   tree in the array data and structure
    *
    *   @version    2001/11/20
    *   @access     public
    *   @author     Wolfram Kriesing <[e-mail]>
    *   @return     boolean     true on success
    */
    function setup()
    {
// TODO sort by prevId (parentId,prevId $addQuery) too if it exists in the table, or the root might be wrong
// TODO  since the prevId of the root should be 0

        //
        $whereAddOn = '';
        if( $this->options['whereAddOn'] )
        {
            $whereAddOn = 'WHERE '.$this->getOption('whereAddOn');
        }

        //
        $orderBy = '';
        if( $this->options['order'] )
        {
            $orderBy = ",".$this->options['order'];
        }

        $map = $this->getOption('columnNameMaps');
        if( isset($map['parentId']) )
        {
            $orderBy = $map['parentId'].$orderBy;
        }
        else
        {
            $orderBy = 'parentId'.$orderBy;
        }

        // build the query this way, that the root, which has no parent (parentId=0)
        // and no previous (prevId=0) is in first place (in case prevId is given)
        $query = sprintf(   "SELECT * FROM %s %s ORDER BY %s",
                            $this->table,
                            $whereAddOn,
                            $orderBy); //,prevId !!!!
        if( DB::isError( $res = $this->dbh->getAll( $query ) ) )
        {
// FIXXME remove print use debug mode instead
            printf("ERROR - Tree::setup - %s - %s<br>",DB::errormessage($res),$query);
            return $this->_throwError($res->getMessage(),__LINE__);
        }

        // if the db-column names need to be mapped to different names
// FIXXME somehow we should be able to do this in the query, but i dont know how to select
// only those columns, use "as" on them and select the rest, without getting those columns again :-(
        if( $map )
        foreach( $res as $id=>$aResult )    // map each result
        {
            foreach( $map as $key=>$columnName )
            {
                $res[$id][$key] = $res[$id][$columnName];
                unset($res[$id][$columnName]);
            }
        }

        return $res;
    }

    /**
    *   adds _one_ new element in the tree under the given parent
    *   the values' keys given have to match the db-columns, because the
    *   value gets inserted in the db directly
    *   to add an entire node containing children and so on see 'addNode()'
    *
    *   to ba compatible, to the DBnested u can also give the parent and previd as the second and third parameter
    *
    *   @see        addNode()
    *   @version    2001/10/09
    *   @access     public
    *   @author     Wolfram Kriesing <[e-mail]>
    *   @param      array   $newValues  this array contains the values that shall be inserted in the db-table
    *                                   the key for each element is the name of the column
    *   @return     mixed   either boolean false on failure or the id of the inserted row
    */
    function add( $newValues , $parentId=0 )
    {
// FIXXME use $this->dbh->tableInfo to check which columns exist
// so only data for which a column exist is inserted
        if( $parentId )
            $newValues['parentId'] = $parentId;

        $newData = array();
        foreach( $newValues as $key=>$value )       // quote the values, as needed for the insert
        {
            $newData[$this->_getColName($key)] = $this->dbh->quote($value);
        }

        // use sequences to create a new id in the db-table
        $nextId = $this->dbh->nextId($this->table);
        $query = sprintf("INSERT INTO %s (%s,%s) VALUES (%s,%s)",
                            $this->table ,
                            $this->_getColName('id'),
                            implode( ',' , array_keys($newData) ) ,
                            $nextId,
                            implode( ',' , $newData ) );
        if( DB::isError( $res = $this->dbh->query( $query ) ) )
        {
            // TODO raise PEAR error
            printf("ERROR - Tree::add - %s - %s<br>",DB::errormessage($res),$query);
            return false;
        }