PHP ADODB_Active_Record类代码示例

 protected function importAdditionalData($b, $blockNode)
 {
     if (isset($blockNode->data)) {
         foreach ($blockNode->data as $data) {
             if ($data['table'] != $this->getBlockTypeDatabaseTable()) {
                 $table = (string) $data['table'];
                 if (isset($data->record)) {
                     foreach ($data->record as $record) {
                         $aar = new ADODB_Active_Record($table);
                         $aar->bID = $b->getBlockID();
                         foreach ($record->children() as $node) {
                             $nodeName = $node->getName();
                             $aar->{$nodeName} = (string) $node;
                         }
                         if ($table == 'btFormQuestions') {
                             $db = Loader::db();
                             $aar->questionSetId = $db->GetOne('select questionSetId from btForm where bID = ?', array($b->getBlockID()));
                             $aar->qID = null;
                         }
                         $aar->Save();
                     }
                 }
             }
         }
     }
 }

 function __construct($table = false, $pkeyarr = false, $db = false)
 {
     global $ADODB_ASSOC_CASE, $_ADODB_ACTIVE_DBS;
     if ($db == false && is_object($pkeyarr)) {
         $db = $pkeyarr;
         $pkeyarr = false;
     }
     if (!$table) {
         $table = $this->_pluralize(get_class($this));
     }
     if ($db) {
         $this->_dbat = ADODB_Active_Record::SetDatabaseAdapter($db);
     } else {
         $this->_dbat = sizeof($_ADODB_ACTIVE_DBS) - 1;
     }
     if ($this->_dbat < 0) {
         $this->Error("No database connection set; use ADOdb_Active_Record::SetDatabaseAdapter(\$db)", 'ADODB_Active_Record::__constructor');
     }
     $this->_table = $table;
     $this->_tableat = $table;
     # reserved for setting the assoc value to a non-table name, eg. the sql string in future
     $this->UpdateActiveTable($pkeyarr);
 }

 function belongsTo($foreignRef, $foreignKey = false, $parentKey = '')
 {
     global $inflector;
     $ar = new ADODB_Active_Record($this->_pluralize($foreignRef));
     $ar->foreignName = $foreignRef;
     $ar->parentKey = $parentKey;
     $ar->UpdateActiveTable();
     $ar->foreignKey = $foreignKey ? $foreignKey : $foreignRef . ADODB_Active_Record::$_foreignSuffix;
     $table =& $this->TableInfo();
     $table->_belongsTo[$foreignRef] = $ar;
     #	$this->$foreignRef = $this->_belongsTo[$foreignRef];
 }

 /** 
  * Duplicates an attribute key 
  */
 public function duplicate($args = array())
 {
     $ar = new ADODB_Active_Record('AttributeKeys');
     $ar->Load('akID=?', array($this->akID));
     $ar2 = clone $ar;
     $ar2->akID = null;
     foreach ($args as $key => $value) {
         $ar2->{$key} = $value;
     }
     $ar2->Insert();
     $db = Loader::db();
     $ak = new AttributeKey();
     $ak->load($db->Insert_ID());
     // now we duplicate the specific category fields
     $this->getController()->duplicateKey($ak);
     return $ak;
 }

<?php

// using ActiveRecord to load and change record
include "adodb/adodb.inc.php";
include 'adodb/adodb-active-record.inc.php';
$conn = ADONewConnection('mysql');
$conn->connect("localhost", "user", "password", "test");
ADODB_Active_Record::setDatabaseAdapter($conn);
class User extends ADODB_Active_Record
{
}
$user = new User();
$user->load("id=10");
//load the record where the id is 10
echo $user->name;
$user->name = "Afif Mohiuddin";
//now update
$user->save();
//and save the previously loaded record

 protected function importAdditionalData($b, $blockNode)
 {
     if (isset($blockNode->data)) {
         foreach ($blockNode->data as $data) {
             if (strtoupper($data['table']) != strtoupper($this->getBlockTypeDatabaseTable())) {
                 $table = (string) $data['table'];
                 if (isset($data->record)) {
                     foreach ($data->record as $record) {
                         $aar = new ADODB_Active_Record($table);
                         $aar->bID = $b->getBlockID();
                         foreach ($record->children() as $node) {
                             $nodeName = $node->getName();
                             $aar->{$nodeName} = ContentImporter::getValue((string) $node);
                         }
                         $aar->Save();
                     }
                 }
             }
         }
     }
 }

 * Class for mt_blog (website)
 */
class Website extends Blog
{
    function Save()
    {
        if (empty($this->blog_class)) {
            $this->blog_class = 'website';
        }
        return parent::Save();
    }
    function blogs()
    {
        $where = "blog_parent_id = " . $this->id;
        require_once 'class.mt_blog.php';
        $blog = new Blog();
        $blogs = $blog->Find($where);
        return $blogs;
    }
    function site_path()
    {
        return $this->blog_site_path;
    }
    function site_url()
    {
        return $this->blog_site_url;
    }
}
// Relations
ADODB_Active_Record::ClassHasMany('Website', 'mt_blog_meta', 'blog_meta_blog_id');

# Movable Type (r) (C) 2001-2015 Six Apart, Ltd. All Rights Reserved.
# This code cannot be redistributed without permission from www.sixapart.com.
# For more information, consult your Movable Type license.
#
# $Id$
require_once "class.baseobject.php";
/***
 * Class for mt_tbping
 */
class TBPing extends BaseObject
{
    public $_table = 'mt_tbping';
    protected $_prefix = "tbping_";
    protected $_has_meta = true;
    public function trackback()
    {
        $col_name = "tbping_tb_id";
        ${$tb} = null;
        if (isset($this->{$col_name}) && is_numeric($this->{$col_name})) {
            $tb_id = $this->{$col_name};
            require_once 'class.mt_trackback.php';
            $tb = new Trackback();
            $tb->Load("trackback_id = {$tb_id}");
        }
        return $tb;
    }
}
// Relations
ADODB_Active_Record::ClassHasMany('TBPing', 'mt_tbping_meta', 'tbping_meta_tbping_id');

<?php

class Document extends ADOdb_Active_Record
{
    //
    // Callback function hook for when document gets a 'created' status from document_callback.php
    //
    function createdCallback($http_body)
    {
        error_log("Document {$this->id} created");
        $xml = simplexml_load_string($http_body);
    }
    //
    // Callback function hook for when document gets a 'viewed' status from document_callback.php
    //
    function viewedCallback($http_body)
    {
        error_log("Document {$this->id} viewed");
        $xml = simplexml_load_string($http_body);
    }
    //
    // Callback function hook for when document gets a 'signed' status from document_callback.php
    //
    function completedCallback($http_body)
    {
        error_log("Document {$this->id} completed");
        $xml = simplexml_load_string($http_body);
    }
}
ADODB_Active_Record::ClassBelongsTo('document', 'user', 'user_id', 'id');

 static function TableKeyHasMany($table, $tablePKey, $foreignRef, $foreignKey = false, $foreignClass = 'ADODB_Active_Record')
 {
     if (!is_array($tablePKey)) {
         $tablePKey = array($tablePKey);
     }
     $ar = new ADODB_Active_Record($table, $tablePKey);
     $ar->hasMany($foreignRef, $foreignKey, $foreignClass);
 }

<?php

class Template extends ADOdb_Active_Record
{
}
ADODB_Active_Record::ClassHasMany('template', 'templates', 'user_id');

$person->favorite_color = 'lavender';
$person->save();
// this save will perform an INSERT successfully
$person2 = new person();
$person2->Load('id=1');
$c = $person2->children;
if (is_array($c) && sizeof($c) == 3 && $c[0]->name_first == 'Jill' && $c[1]->name_first == 'Joan' && $c[2]->name_first == 'JAMIE') {
    echo "OK Loaded HasMany</br>";
} else {
    var_dump($c);
    echo "error loading hasMany should have 3 array elements Jill Joan Jamie<br>";
}
class child extends ADOdb_Active_Record
{
}
ADODB_Active_Record::TableBelongsTo('children', 'person', 'person_id', 'id');
$ch = new Child('children', array('id'));
$ch->Load('id=1');
if ($ch->name_first !== 'Jill') {
    echo "error in Loading Child<br>";
}
$p = $ch->person;
if (!$p || $p->name_first != 'John') {
    echo "Error loading belongsTo<br>";
} else {
    echo "OK loading BelongTo<br>";
}
if ($p) {
    #$p->HasMany('children','person_id');  ## this is affects all other instances of Person
    $p->LoadRelations('children', 'order by id', 1, 2);
    if (sizeof($p->children) == 2 && $p->children[1]->name_first == 'JAMIE') {

        }
        require_once 'class.mt_trackback.php';
        $trackback = new Trackback();
        $loaded = $trackback->Load("trackback_entry_id = " . $this->entry_id);
        if (!$loaded) {
            $trackback = null;
        }
        return $trackback;
    }
    public function pings()
    {
        $pings = array();
        $tb = $this->trackback();
        if (!empty($tb)) {
            require_once 'class.mt_tbping.php';
            $tbping = new TBPing();
            $pings = $tbping->Find("tbping_tb_id = " . $tb->id);
        }
        return $pings;
    }
    function Save()
    {
        if (empty($this->entry_class)) {
            $this->class = 'entry';
        }
        return parent::Save();
    }
}
// Relations
ADODB_Active_Record::ClassHasMany('Entry', 'mt_entry_meta', 'entry_meta_entry_id');

 public function Save()
 {
     parent::Save();
     if ($this->supporting_docs_links != null) {
         $this->supporting_docs_links->Save();
     }
 }

 function Save()
 {
     // Agregar el generador a la llave primaria en insercion
     // el generador debe llamarse GEN_(Campo PK)
     if (App::$base->driver == 'firebird') {
         $ids = $this->DB()->MetaPrimaryKeys($this->_table);
         // PK
         $id = count($ids) > 0 ? $ids[0] : '';
         if (!$this->_saved && $id != '') {
             $id = strtolower($id);
             $gen = 'GEN_' . strtoupper($id);
             $this->{$id} = $this->DB()->GenID($gen);
         }
     }
     if (App::$base->driver == 'postgres' || App::$base->driver == 'postgres8') {
         $ids = $this->DB()->MetaPrimaryKeys($this->_table);
         // PK
         $id = count($ids) > 0 ? $ids[0] : '';
         if (!$this->_saved && $id != '') {
             $gen = $this->_table . '_' . $id . '_seq';
             //formato: tbl_nombretabla_id_campoid_seq
             $gen = strtolower($gen);
             $this->{$id} = $this->DB()->GenID($gen);
         }
     }
     parent::Save();
     return $this;
 }