当前位置: 首页>>代码示例>>PHP>>正文


PHP MDB2_Driver_Common::getOption方法代码示例

本文整理汇总了PHP中MDB2_Driver_Common::getOption方法的典型用法代码示例。如果您正苦于以下问题:PHP MDB2_Driver_Common::getOption方法的具体用法?PHP MDB2_Driver_Common::getOption怎么用?PHP MDB2_Driver_Common::getOption使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在MDB2_Driver_Common的用法示例。


在下文中一共展示了MDB2_Driver_Common::getOption方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: switch

 function _setupSQLStatements()
 {
     switch ($this->oDBH->dbsyntax) {
         case 'mysql':
             $engine = $this->oDBH->getOption('default_table_type');
             $this->aSQLStatements['table_copy_all'] = "INSERT IGNORE INTO %s SELECT * FROM %s";
             //$this->aSQLStatements['table_copy_cols'] = "INSERT IGNORE INTO (%s %s) VALUES (SELECT %s FROM %s)";
             $this->aSQLStatements['table_update_col'] = "UPDATE IGNORE %s SET %s = %s.%s";
             $this->aSQLStatements['table_copy'] = "CREATE TABLE %s ENGINE={$engine} (SELECT * FROM %s)";
             $this->aSQLStatements['table_copy_temp'] = "CREATE TEMPORARY TABLE %s ENGINE={$engine} (SELECT * FROM %s)";
             $this->aSQLStatements['table_rename'] = "RENAME TABLE %s TO %s";
             $this->aSQLStatements['table_select'] = 'SELECT %s FROM %s';
             $this->aSQLStatements['table_insert'] = 'INSERT INTO %s (%s) VALUES %s';
             break;
         case 'pgsql':
             $this->aSQLStatements['table_copy_all'] = 'INSERT INTO "%s" SELECT * FROM "%s"';
             $this->aSQLStatements['table_update_col'] = 'UPDATE "%s" SET %s = "%s".%s';
             $this->aSQLStatements['table_copy'] = 'CREATE TABLE "%1$s" (LIKE "%2$s" INCLUDING DEFAULTS); INSERT INTO "%1$s" SELECT * FROM "%2$s"';
             $this->aSQLStatements['table_copy_temp'] = 'CREATE TABLE "%1$s" (LIKE "%2$s" INCLUDING DEFAULTS); INSERT INTO "%1$s" SELECT * FROM "%2$s"';
             $this->aSQLStatements['table_rename'] = 'ALTER TABLE "%s" RENAME TO "%s"';
             $this->aSQLStatements['table_select'] = 'SELECT %s FROM "%s"';
             $this->aSQLStatements['table_insert'] = 'INSERT INTO "%s" (%s) VALUES %s';
             break;
         default:
             '';
             break;
     }
 }
开发者ID:Spark-Eleven,项目名称:revive-adserver,代码行数:28,代码来源:Migration.php


注:本文中的MDB2_Driver_Common::getOption方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。