/**
  * Get XML tree
  *
  * @return  xml.Tree
  */
 public function getTree()
 {
     $indexes = array();
     // Attributes
     with($t = $this->doc->root()->nodeAt(0));
     if ($attr = $this->table->getFirstAttribute()) {
         do {
             $a = $t->addChild(new Node('attribute', NULL, array('name' => trim($attr->getName()), 'type' => $attr->getTypeString(), 'identity' => $attr->isIdentity() ? 'true' : 'false', 'typename' => $attr->typeName(), 'nullable' => $attr->isNullable() ? 'true' : 'false')));
             // Only add length attribute if length is set - "bool" does not
             // have a length, whereas varchar(255) does.
             $attr->getLength() && $a->setAttribute('length', $attr->getLength());
         } while ($attr = $this->table->getNextAttribute());
     }
     // Indexes
     if ($index = $this->table->getFirstIndex()) {
         do {
             $n = $t->addChild(new Node('index', NULL, array('name' => trim($index->getName()), 'unique' => $index->isUnique() ? 'true' : 'false', 'primary' => $index->isPrimaryKey() ? 'true' : 'false')));
             foreach ($index->getKeys() as $key) {
                 $n->addChild(new Node('key', $key));
             }
             if (isset($indexes[implode('|', $index->getKeys())]) && $this->cat) {
                 $this->cat->warn('(' . implode('|', $index->getKeys()) . ')', 'has been indexed twice');
             }
             $indexes[implode('|', $index->getKeys())] = TRUE;
         } while ($index = $this->table->getNextIndex());
     }
     // constraints
     $constKeyList = array();
     if ($constraint = $this->table->getFirstForeignKeyConstraint()) {
         do {
             if (isset($constKeyList[$this->constraintKey($constraint)])) {
                 $this->cat && $this->cat->warn($this->table->name, 'has a double constraint' . "\n" . xp::stringOf($constraint));
                 continue;
             }
             $constKeyList[$this->constraintKey($constraint)] = true;
             $cn = $t->addChild(new Node('constraint', NULL, array('name' => trim($constraint->getName()))));
             $fgn = $cn->addChild(new Node('reference', NULL, array('table' => $constraint->getSource(), 'role' => DBXMLNamingContext::foreignKeyConstraintName($this->table, $constraint))));
             foreach ($constraint->getKeys() as $attribute => $sourceattribute) {
                 $fgn->addChild(new Node('key', NULL, array('attribute' => $attribute, 'sourceattribute' => $sourceattribute)));
             }
         } while ($constraint = $this->table->getNextForeignKeyConstraint());
     }
     return $this->doc;
 }
Esempio n. 2
0
 /**
  * Constructor
  *
  * @param   util.cmd.ParamString args
  */
 public function __construct(ParamString $args)
 {
     $dsn = new DSN($args->value(0));
     $this->adapter = self::$adapters[$dsn->getDriver()]->newInstance(DriverManager::getInstance()->getConnection($dsn->dsn));
     $this->package = $args->value('package', 'p', 'db');
     $this->host = $args->value('host', 'h', $dsn->getHost());
     $this->naming = $args->value('nstrategy', 'n', '');
     if ('' != $this->naming) {
         DBXMLNamingContext::setStrategy(XPClass::forName($this->naming)->newInstance());
     }
     $this->prefix = $args->value('prefix', 'pv', '');
     $this->ptargets = explode('|', $args->value('ptargets', 'pt', ''));
     $this->pexclude = $args->value('pexclude', 'pe', FALSE);
     $xsls = array();
     $lang = $args->value('lang', 'l', 'xp5.php');
     if ($this->getClass()->getPackage()->providesPackage(strtr($lang, '.', '_'))) {
         $resources = $this->getClass()->getPackage()->getPackage(strtr($lang, '.', '_'))->getResources();
         foreach ($resources as $resource) {
             $filename = substr($resource, strrpos($resource, DIRECTORY_SEPARATOR) + 1);
             if (substr($filename, -8, 8) !== '.php.xsl') {
                 continue;
             }
             $xsls[] = $resource;
         }
     } else {
         $packagepath = strtr($this->getClass()->getPackage()->getName(), '.', DIRECTORY_SEPARATOR);
         $xsls[] = $packagepath . DIRECTORY_SEPARATOR . $lang . '.xsl';
     }
     foreach ($xsls as $resource) {
         $processor = new DomXSLProcessor();
         $processor->setBase(__DIR__);
         $processor->setXSLBuf(ClassLoader::getDefault()->getResource($resource));
         $processor->setParam('package', $this->package);
         if ($this->prefix) {
             $processor->setParam('prefix', $this->prefix);
             $processor->setParam($this->pexclude ? 'exprefix' : 'incprefix', implode(',', $this->ptargets));
         }
         $this->processor[] = $processor;
     }
 }
 /**
  * Get XML tree
  *
  * @return  xml.Tree
  */
 public function getTree()
 {
     foreach ($this->tables as $t) {
         $constKeyList = array();
         $tn = $this->doc->root()->nodeAt(0)->addChild(new Node('table', NULL, array('name' => $t->name)));
         if ($constraint = $t->getFirstForeignKeyConstraint()) {
             do {
                 if (isset($constKeyList[$this->constraintKey($constraint)])) {
                     $this->cat && $this->cat->warn($t->name, 'has a double constraint' . "\n" . xp::stringOf($constraint));
                     continue;
                 }
                 $constKeyList[$this->constraintKey($constraint)] = true;
                 $cn = $tn->addChild(new Node('constraint', NULL, array('name' => trim($constraint->getName()))));
                 $fgn = $cn->addChild(new Node('reference', NULL, array('table' => $constraint->getSource(), 'role' => DBXMLNamingContext::referencingForeignKeyConstraintName($t, $constraint))));
                 foreach ($constraint->getKeys() as $attribute => $sourceattribute) {
                     $fgn->addChild(new Node('key', NULL, array('attribute' => $attribute, 'sourceattribute' => $sourceattribute)));
                 }
             } while ($constraint = $t->getNextForeignKeyConstraint());
         }
     }
     return $this->doc;
 }
Esempio n. 4
0
 /**
  * Constructor
  *
  * @param   util.cmd.ParamString args
  */
 public function __construct(ParamString $args)
 {
     $dsn = new DSN($args->value(0));
     $this->adapter = self::$adapters[$dsn->getDriver()]->newInstance(DriverManager::getInstance()->getConnection($dsn->dsn));
     $this->package = $args->value('package', 'p', 'db');
     $this->host = $args->value('host', 'h', $dsn->getHost());
     $this->naming = $args->value('nstrategy', 'n', '');
     if ('' != $this->naming) {
         DBXMLNamingContext::setStrategy(XPClass::forName($this->naming)->newInstance());
     }
     $this->prefix = $args->value('prefix', 'pv', '');
     $this->ptargets = explode('|', $args->value('ptargets', 'pt', ''));
     $this->pexclude = $args->value('pexclude', 'pe', FALSE);
     // Setup generator
     $this->processor = new DomXSLProcessor();
     $this->processor->setXSLBuf($this->getClass()->getPackage()->getResource($args->value('lang', 'l', 'xp5.php') . '.xsl'));
     $this->processor->setParam('package', $this->package);
     if ($this->prefix) {
         $this->processor->setParam('prefix', $this->prefix);
         $this->processor->setParam($this->pexclude ? 'exprefix' : 'incprefix', implode(',', $this->ptargets));
     }
 }
 /**
  * set strategy
  *
  * @param   rdbms.DBXMLNamingStrategy s
  */
 static function setStrategy(DBXMLNamingStrategy $s)
 {
     self::$strategy = $s;
 }