PHP Schema::model方法代码示例

 public function init()
 {
     // Add ordering
     $criteria = new CDbCriteria();
     $criteria->order = "SCHEMA_NAME ASC";
     $schemata = Schema::model()->findAll($criteria);
     $dbSeperator = "_";
     $items = $root = $children = $items = array();
     foreach ($schemata as $schema) {
         // Find prefix in name
         if ($position = strpos($schema->SCHEMA_NAME, $dbSeperator)) {
             $prefix = substr($schema->SCHEMA_NAME, 0, $position);
             $root[$prefix] = $prefix;
             $children[$prefix][] = substr($schema->SCHEMA_NAME, $position + 1);
         } else {
             $root[] = $schema->SCHEMA_NAME;
         }
     }
     $i = 0;
     foreach ($root as $key => $item) {
         $childs = array();
         $childrenCount = count($children[$item]);
         if ($childrenCount > 1) {
             foreach ($children[$item] as $child) {
                 $childs[] = array('text' => CHtml::link($child, SchemaController::createUrl("/schema/" . $item . $dbSeperator . $child)));
             }
         } else {
             if ($childrenCount == 1) {
                 $name = $item . $dbSeperator . $children[$item][0];
             } else {
                 $name = $item;
             }
             $items[] = array('text' => CHtml::link($name, SchemaController::createUrl("/schema/" . $name)));
             $i++;
             continue;
         }
         $items[] = array('text' => $childrenCount == 0 ? CHtml::link($item, SchemaController::createUrl("/schema/" . $item)) : $item, 'expanded' => $i == 0 ? true : false, 'children' => $childs);
         $i++;
     }
     $this->data = $items;
     parent::init();
 }

 /**
  * Tests to drop a database.
  */
 public function testDrop()
 {
     // Load schema
     $schema = Schema::model()->findByPk('schematest2');
     // Drop
     $this->assertEquals(true, $schema->delete());
     // Load again
     $this->assertEquals(null, Schema::model()->findByPk('schematest2'));
 }

 /**
  * Loads the current schema.
  *
  * @return	Schema
  */
 public function loadSchema()
 {
     if (is_null($this->_schema)) {
         $this->_schema = Schema::model()->findByPk($this->schema);
         if (is_null($this->_schema)) {
             throw new CHttpException(500, 'The requested schema does not exist.');
         }
     }
     return $this->_schema;
 }

 /**
  * Runs the form.
  */
 private function runForm()
 {
     // @todo: Load all exporters
     $exporterNames = array('SqlExporter', 'CsvExporter');
     // Instantiate supported exporters
     $this->exporters = array();
     foreach ($exporterNames as $exporter) {
         $supported = call_user_func(array($exporter, 'getSupportedModes'));
         if (in_array($this->mode, $supported)) {
             $this->exporters[] = new $exporter($this->mode);
         }
     }
     // Create the object list
     $this->objects = array();
     if ($this->mode == 'objects') {
         // Load schema
         $schema = Schema::model()->findByPk($this->schema);
         // Tables
         $tables = $schema->tables;
         if (count($tables) > 0) {
             $data = array();
             foreach ($tables as $table) {
                 $data['t:' . $table->TABLE_NAME] = $table->TABLE_NAME;
             }
             $this->objects[Yii::t('core', 'tables')] = $data;
         }
         // Views
         $views = $schema->views;
         if (count($views) > 0) {
             $data = array();
             foreach ($views as $view) {
                 $data['v:' . $view->TABLE_NAME] = $view->TABLE_NAME;
             }
             $this->objects[Yii::t('core', 'views')] = $data;
         }
         // Routines
         $routines = $schema->routines;
         if (count($routines) > 0) {
             $data = array();
             foreach ($routines as $routine) {
                 $data['r:' . $routine->ROUTINE_NAME] = $routine->ROUTINE_NAME;
             }
             $this->objects[Yii::t('core', 'routines')] = $data;
         }
     }
 }

 public function actionCreateSchema()
 {
     $schema = new SchemaPrivilege();
     $schema->User = $this->user;
     $schema->Host = $this->host;
     if (isset($_POST['SchemaPrivilege'])) {
         $schema->attributes = $_POST['SchemaPrivilege'];
         if ($sql = $schema->save()) {
             $response = new AjaxResponse();
             $response->addNotification('success', Yii::t('core', 'successAddSchemaSpecificPrivileges', array('{user}' => $schema->User, '{host}' => $schema->Host, '{schema}' => $schema->Db)), null);
             $response->refresh = true;
             $this->sendJSON($response);
         }
     }
     // Prepare all schemata
     $schemata = $existing = array();
     $allSchemata = Schema::model()->findAll();
     $allExisting = SchemaPrivilege::model()->findAllByAttributes(array('User' => $this->user, 'Host' => $this->host));
     foreach ($allExisting as $existing1) {
         $existing[] = $existing1->Db;
     }
     foreach ($allSchemata as $schema1) {
         if (array_search($schema1->SCHEMA_NAME, $existing) === false) {
             $schemata[$schema1->SCHEMA_NAME] = $schema1->SCHEMA_NAME;
         }
     }
     $this->render('schemaPrivilegeForm', array('schema' => $schema, 'schemata' => $schemata));
 }