PHP Package::installDB方法代碼示例

 public function refresh_database_schema()
 {
     if ($this->token->validate("refresh_database_schema")) {
         $msg = '';
         if ($this->post('refresh_global_schema')) {
             // refresh concrete/config/db.xml and all installed blocks
             $cnt = Loader::controller("/upgrade");
             try {
                 $cnt->refresh_schema();
                 $msg .= t('Core database files and installed blocks refreshed.');
             } catch (Exception $e) {
                 $this->set('error', $e);
             }
         }
         if ($this->post('refresh_local_schema')) {
             // refresh concrete/config/db.xml and all installed blocks
             if (file_exists('config/' . FILENAME_LOCAL_DB)) {
                 try {
                     Package::installDB(DIR_BASE . '/config/' . FILENAME_LOCAL_DB);
                     $msg .= ' ' . t('Local database file refreshed.');
                 } catch (Exception $e) {
                     $this->set('error', $e);
                 }
             }
         }
         $msg = trim($msg);
         $this->set('message', $msg);
     } else {
         $this->set('error', array($this->token->getErrorMessage()));
     }
 }

 public function prepare()
 {
     // we install the updated schema just for tables that matter
     Package::installDB(dirname(__FILE__) . '/db/version_540.xml');
     $db = Loader::db();
     $db->Execute('alter table CollectionVersionBlockStyles drop primary key');
     $db->Execute('alter table CollectionVersionBlockStyles add primary key (cID, bID, cvID, arHandle)');
 }

 public function upgrade()
 {
     Package::installDB($this->getPackagePath() . '/' . FILENAME_PACKAGE_DB);
     // now we refresh all blocks
     $items = $this->getPackageItems();
     if (is_array($items['block_types'])) {
         foreach ($items['block_types'] as $item) {
             $item->refresh();
         }
     }
 }

	public static function add($atHandle, $atName, $pkg = false) {
		$pkgID = 0;
		if (is_object($pkg)) {
			$pkgID = $pkg->getPackageID();
		}
		$db = Loader::db();
		$db->Execute('insert into AttributeTypes (atHandle, atName, pkgID) values (?, ?, ?)', array($atHandle, $atName, $pkgID));
		$id = $db->Insert_ID();
		$est = AttributeType::getByID($id);
		
		$path = $est->getAttributeTypeFilePath(FILENAME_ATTRIBUTE_DB);
		if ($path) {
			Package::installDB($path);
		}
		return $est;
	}

 public function install_database()
 {
     $db = Loader::db();
     $installDirectory = DIR_BASE_CORE . '/config';
     try {
         Database::ensureEncoding();
         Package::installDB($installDirectory . '/db.xml');
     } catch (Exception $e) {
         throw new Exception(t('Unable to install database: %s', $db->ErrorMsg()));
     }
 }

	public function prepare() {
		$db = Loader::db();
		Package::installDB(dirname(__FILE__) . '/db/version_5331.xml');
	}

 public function refresh_schema()
 {
     if ($this->upgrade_db) {
         $installDirectory = DIR_BASE_CORE . '/config';
         $file = $installDirectory . '/db.xml';
         if (!file_exists($file)) {
             throw new Exception(t('Unable to locate database import file.'));
         }
         $err = Package::installDB($file);
         // now we refresh the block schema
         $btl = new BlockTypeList();
         $btArray = $btl->getInstalledList();
         foreach ($btArray as $bt) {
             $bt->refresh();
         }
         $this->upgrade_db = false;
     }
 }

 /**
  * Installs the current block's DB xml file. If a block needs to do more than this, this should be overridden.
  * <code>
  * public function install($path) {
  *     $this->doMySpecialInstallMethod();
  *     $this->doSecondSpecialInstallMethod();
  *     parent::install($path);
  * }
  * </code>
  *
  * There are several different possible return values:
  *  Returns FALSE if $btTable is set but no db.xml file exists.
  *  Otherwise returns object with two properties: ->result (a boolean), and ->message (a string).
  *  If ->result is true, the installation was successful
  *  (although the db.xml file might only have one field declared which will cause C5 to have problems later on, so you you will want to check for that separately).
  *  If ->result is false, the installation failed and you can check ->message for the explanation
  *  (usually -- sometimes ->message will be blank, in which case there's either a malformed db.xml file or an "unknown database error").
  * See concrete/models/block_types.php::doInstallBlockType() for usage example.
  *
  * @param string $path
  * @return mixed boolean or object having ->result (boolean) and ->message (string) properties
  */
 function install($path)
 {
     // passed path is the path to this block (try saying that ten times fast)
     // create the necessary table
     if (!$this->btTable) {
         $r = new stdClass();
         $r->result = true;
         return $r;
     }
     $ret = Package::installDB($path . '/' . $this->dbFile);
     return $ret;
 }

	public function prepare() {
		// we install the updated schema just for tables that matter
		Package::installDB(dirname(__FILE__) . '/db/version_542.xml');
	}

 /**
  * Installs the current block's DB xml file. If a block needs to do more than this, this should be overridden.
  * <code>
  * public function install($path) {
  *     $this->doMySpecialInstallMethod();
  *     $this->doSecondSpecialInstallMethod();
  *     parent::install($path);
  * }
  * </code>
  * @param string $path
  * @return bool $didInstallCorrectly
  */
 function install($path)
 {
     // passed path is the path to this block (try saying that ten times fast)
     // create the necessary table
     $ret = Package::installDB($path . '/' . $this->dbFile);
     return $ret;
 }

 protected function refreshDatabaseTables($tables)
 {
     $dbxml = simplexml_load_file(DIR_BASE_CORE . '/config/db.xml');
     $output = new SimpleXMLElement("<schema></schema>");
     $output->addAttribute('version', '0.3');
     foreach ($dbxml->table as $t) {
         $name = (string) $t['name'];
         if (in_array($name, $tables)) {
             $this->xmlAppend($output, $t);
         }
     }
     $xml = $output->asXML();
     if ($xml) {
         $file = Loader::helper('file')->getTemporaryDirectory() . '/tmpupgrade_' . time() . '.xml';
         @file_put_contents($file, $xml);
         if (file_exists($file)) {
             Package::installDB($file);
             @unlink($file);
         } else {
             throw new Exception(t('Unable to create temporary db xml file: %s', $file));
         }
     }
 }