PHP FabrikWorker::bigSelects方法代码示例

 /**
  * Get a database object
  *
  * Returns the global {@link JDatabase} object, only creating it
  * if it doesn't already exist.
  *
  * @param   bool  $loadJoomlaDb Force (if true) the loading of the main J database,
  *                              needed in admin to connect to J db whilst still using fab db drivers "{package}"
  *                              replacement text
  *
  * @param   mixed $cnnId        If null then loads the fabrik default connection, if an int then loads the
  *                              specified connection by its id
  *
  * @return  JDatabaseDriver object
  */
 public static function getDbo($loadJoomlaDb = false, $cnnId = null)
 {
     $sig = (int) $loadJoomlaDb . '.' . $cnnId;
     if (!self::$database) {
         self::$database = array();
     }
     if (!array_key_exists($sig, self::$database)) {
         JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_fabrik/tables');
         $conf = JFactory::getConfig();
         if (!$loadJoomlaDb) {
             $cnModel = JModelLegacy::getInstance('Connection', 'FabrikFEModel');
             $cn = $cnModel->getConnection($cnnId);
             $host = $cn->host;
             $user = $cn->user;
             $password = $cn->password;
             $database = $cn->database;
         } else {
             $host = $conf->get('host');
             $user = $conf->get('user');
             $password = $conf->get('password');
             $database = $conf->get('db');
         }
         $dbPrefix = $conf->get('dbprefix');
         $driver = $conf->get('dbtype');
         // Test for swapping db table names
         $driver .= '_fab';
         $options = array('driver' => $driver, 'host' => $host, 'user' => $user, 'password' => $password, 'database' => $database, 'prefix' => $dbPrefix);
         $version = new JVersion();
         self::$database[$sig] = $version->RELEASE > 2.5 ? JDatabaseDriver::getInstance($options) : JDatabase::getInstance($options);
         FabrikWorker::bigSelects(self::$database[$sig]);
     }
     return self::$database[$sig];
 }

 /**
  * Once we have a few table joins, our select statements are
  * getting big enough to hit default select length max in MySQL.
  * Added per-list setting to enable_big_selects.
  *
  * 03/10/2012 - Should preserve any old list settings, but this is now set in the global config
  * We set it on the main J db in the system plugin setBigSelects() but should do here as well as we
  * may not be dealing with the same db.
  *
  * 2012-10-19 - $$$ hugh - trouble with preserving old list settings is there is no way to change them, without
  * directly poking around in the params in the database.  Commenting out the per-list checking.
  *
  * @deprecated   now handled in FabrikHelper::getDbo(), as it needs to apply to all queries, including internal / default connection ones.
  * @since   3/16/2010
  *
  * @return  void
  */
 public function setBigSelects()
 {
     $fabrikDb = $this->getDb();
     FabrikWorker::bigSelects($fabrikDb);
 }

 /**
  * From Global configuration setting, set big select for main J database
  *
  * @since    3.0.7
  *
  * @return  void
  */
 protected function setBigSelects()
 {
     $db = JFactory::getDbo();
     FabrikWorker::bigSelects($db);
 }