portal/patient/fwk/libs/verysimple/DB/Reflection/DBSchema.php

   1 <?php
   2 /** @package    verysimple::DB::Reflection */
   3
   4 /**
   5  * import supporting libraries
   6  */
   7 require_once("DBTable.php");
   8
   9 /**
  10  * DBSchema is an object representation of a MySQL Schema/Database
  11  *
  12  * @package verysimple::DB::Reflection
  13  * @author Jason Hinkle
  14  * @copyright 1997-2007 VerySimple, Inc.
  15  * @license http://www.gnu.org/licenses/lgpl.html LGPL
  16  * @version 1.0
  17  */
  18 class DBSchema
  19 {
  20     public $Server;
  21     public $Name;
  22     public $Tables;
  23
  24     /**
  25      * Instantiate new DBSchema
  26      *
  27      * @access public
  28      * @param DBServer $server
  29      * @param string $name
  30      *          name of schema to parse
  31      */
  32     function __construct($server)
  33     {
  34         $this->Server = & $server;
  35         $this->Name = $server->Connection->DBName;
  36         $this->Tables = array ();
  37
  38         $this->Load();
  39
  40         // print "<pre>"; print_r($this->Tables["ticket"]); die();
  41     }
  42
  43     /**
  44      * Inspects the current schema and loads all tables, keys, etc.
  45      *
  46      * @access public
  47      */
  48     private function Load()
  49     {
  50         $sql = "show tables";
  51         $rs = $this->Server->Connection->Select($sql);
  52
  53         // first pass load all the tables. this will initialize each object. we have to
  54         // do this first so that we can correctly determine and store "Set" information
  55         while ($row = $this->Server->Connection->Next($rs)) {
  56             $this->Tables [$row ["Tables_in_" . $this->Name]] = new DBTable($this, $row);
  57         }
  58
  59         // now load all the keys and constraints for each table
  60         foreach ($this->Tables as $table) {
  61             $table->LoadKeys();
  62         }
  63
  64         $this->Server->Connection->Release($rs);
  65
  66         $sql = "show table status from `" . $this->Name . "`";
  67         $rs2 = $this->Server->Connection->Select($sql);
  68
  69         // load the extra data
  70         while ($row = $this->Server->Connection->Next($rs2)) {
  71             $this->Tables [$row ["Name"]]->Engine = $row ["Engine"];
  72             $this->Tables [$row ["Name"]]->Comment = $row ["Comment"];
  73         }
  74
  75         $this->Server->Connection->Release($rs2);
  76     }
  77 }