PHP DBManager::getOne方法代码示例

 /**
  * Fetch the next job in the queue and mark it running
  * @param string $clientID ID of the client requesting the job
  * @return SugarJob
  */
 public function nextJob($clientID)
 {
     $now = $this->db->now();
     $queued = SchedulersJob::JOB_STATUS_QUEUED;
     $try = $this->jobTries;
     while ($try--) {
         // TODO: tranaction start?
         $id = $this->db->getOne("SELECT id FROM {$this->job_queue_table} WHERE execute_time <= {$now} AND status = '{$queued}' ORDER BY date_entered ASC");
         if (empty($id)) {
             return null;
         }
         $job = new SchedulersJob();
         $job->retrieve($id);
         if (empty($job->id)) {
             return null;
         }
         $job->status = SchedulersJob::JOB_STATUS_RUNNING;
         $job->client = $clientID;
         $client = $this->db->quote($clientID);
         // using direct query here to be able to fetch affected count
         // if count is 0 this means somebody changed the job status and we have to try again
         $res = $this->db->query("UPDATE {$this->job_queue_table} SET status='{$job->status}', date_modified={$now}, client='{$client}' WHERE id='{$job->id}' AND status='{$queued}'");
         if ($this->db->getAffectedRowCount($res) == 0) {
             // somebody stole our job, try again
             continue;
         } else {
             // to update dates & possible hooks
             $job->save();
             break;
         }
         // TODO: commit/check?
     }
     return $job;
 }

 /**
  * Returns Latest tracker id dictionary
  *
  * @return array
  */
 public function getLatestTrackerIdInfo()
 {
     $info = array();
     $query = "SELECT id FROM tracker ORDER BY date_modified desc";
     $id = $this->db->getOne($query, false, 'fetching most recent tracker entry');
     $info['latest_tracker_id'] = (int) $id;
     return $info;
 }

 public function testDBGuidGeneration()
 {
     $guids = array();
     $sql = "SELECT {$this->_db->getGuidSQL()} {$this->_db->getFromDummyTable()}";
     for ($i = 0; $i < 1000; $i++) {
         $newguid = $this->_db->getOne($sql);
         $this->assertFalse(in_array($newguid, $guids), "'{$newguid}' already existed in the array of GUIDs!");
         $guids[] = $newguid;
     }
 }

 public function testGetOne()
 {
     $beanIds = $this->_createRecords(1);
     $id = $this->_db->getOne("SELECT id From contacts where last_name = 'foobar'");
     $this->assertEquals($id, $beanIds[0]);
     // bug 38994
     if ($this->_db instanceof MysqlManager) {
         $id = $this->_db->getOne($this->_db->limitQuerySql("SELECT id From contacts where last_name = 'foobar'", 0, 1));
         $this->assertEquals($id, $beanIds[0]);
     }
     $this->_removeRecords($beanIds);
 }

 /**
  * updateRate
  *
  * execute the standard sql query for updating rates.
  * to use a specific query, override doCustomUpdateRate()
  * in your extended class and make your own.
  *
  * @access protected
  * @param  string $table
  * @param  string $column
  * @param  string $currencyId
  * @return Object database result object
  */
 protected function updateRate($table, $column, $currencyId)
 {
     // get the conversion rate
     $rate = $this->db->getOne(sprintf("SELECT conversion_rate FROM currencies WHERE id = '%s'", $currencyId));
     if (empty($rate)) {
         $GLOBALS['log']->error(string_format($GLOBALS['app_strings']['ERR_DB_QUERY'], array('CurrencyRateUpdate', 'unknown currency: ' . $currencyId)));
         return false;
     }
     // setup SQL statement
     $query = sprintf("UPDATE %s SET %s = %s WHERE currency_id = '%s'", $table, $column, $rate, $currencyId);
     // execute
     return $this->db->query($query, true, string_format($GLOBALS['app_strings']['ERR_DB_QUERY'], array('CurrencyRateUpdate', $query)));
 }

 /**
  * Initialize Sugar environment
  */
 protected function initSugar()
 {
     if ($this->sugar_initialized) {
         return;
     }
     // BR-385 - This fixes the issues around SugarThemeRegistry fatals.  The cache needs rebuild on stage-post init of sugar
     if ($this->current_stage == 'post') {
         $this->cleanFileCache();
     }
     if (!defined('sugarEntry')) {
         define('sugarEntry', true);
     }
     $this->log("Initializing SugarCRM environment");
     global $beanFiles, $beanList, $objectList, $timedate, $moduleList, $modInvisList, $sugar_config, $locale, $sugar_version, $sugar_flavor, $sugar_build, $sugar_db_version, $sugar_timestamp, $db, $locale, $installing, $bwcModules, $app_list_strings, $modules_exempt_from_availability_check;
     $installing = true;
     include 'include/entryPoint.php';
     $installing = false;
     $GLOBALS['current_language'] = $this->config['default_language'];
     if (empty($GLOBALS['current_language'])) {
         $GLOBALS['current_language'] = 'en_us';
     }
     $GLOBALS['log'] = LoggerManager::getLogger('SugarCRM');
     $this->db = $GLOBALS['db'] = DBManagerFactory::getInstance();
     //Once we have a DB, we can do a full cache clear
     if ($this->current_stage == 'post') {
         $this->cleanCaches();
     }
     SugarApplication::preLoadLanguages();
     $timedate = TimeDate::getInstance();
     if (empty($locale)) {
         if (method_exists('Localization', 'getObject')) {
             $locale = Localization::getObject();
         } else {
             $locale = new Localization();
         }
     }
     if (!isset($_SERVER['REQUEST_URI'])) {
         $_SERVER['REQUEST_URI'] = '';
     }
     // Load user
     $GLOBALS['current_user'] = $this->getUser();
     // Prepare DB
     if ($this->config['dbconfig']['db_type'] == 'mysql') {
         //Change the db wait_timeout for this session
         $now_timeout = $this->db->getOne("select @@wait_timeout");
         $this->db->query("set wait_timeout=28800");
         $now_timeout = $this->db->getOne("select @@wait_timeout");
         $this->log("DB timeout set to {$now_timeout}");
     }
     // stop trackers
     $trackerManager = TrackerManager::getInstance(true);
     $trackerManager->pause();
     $trackerManager->unsetMonitors();
     $this->sugar_initialized = true;
     $this->loadStrings();
     $GLOBALS['app_list_strings'] = return_app_list_strings_language($GLOBALS['current_language']);
     $this->log("Done initializing SugarCRM environment");
 }

 /**
  * Process the save action for sugar bean custom fields.
  *
  * @param bool $isUpdate
  */
 public function save($isUpdate)
 {
     if ($this->bean->hasCustomFields() && isset($this->bean->id)) {
         $query = '';
         if ($isUpdate) {
             $query = 'UPDATE ' . $this->bean->table_name . '_cstm SET ';
         }
         $queryInsert = 'INSERT INTO ' . $this->bean->table_name . '_cstm (id_c';
         $values = "('" . $this->bean->id . "'";
         $first = true;
         foreach ($this->bean->field_defs as $name => $field) {
             if (empty($field['source']) || $field['source'] != 'custom_fields') {
                 continue;
             }
             if ($field['type'] == 'html' || $field['type'] == 'parent') {
                 continue;
             }
             if (isset($this->bean->{$name})) {
                 $quote = "'";
                 if (in_array($field['type'], array('int', 'float', 'double', 'uint', 'ulong', 'long', 'short', 'tinyint', 'currency', 'decimal'))) {
                     $quote = '';
                     if (!isset($this->bean->{$name}) || !is_numeric($this->bean->{$name})) {
                         if ($field['required']) {
                             $this->bean->{$name} = 0;
                         } else {
                             $this->bean->{$name} = 'NULL';
                         }
                     }
                 }
                 if ($field['type'] == 'bool') {
                     if ($this->bean->{$name} === false) {
                         $this->bean->{$name} = '0';
                     } elseif ($this->bean->{$name} === true) {
                         $this->bean->{$name} = '1';
                     }
                 }
                 $val = $this->bean->{$name};
                 if (($field['type'] == 'date' || $field['type'] == 'datetimecombo') && (empty($this->bean->{$name}) || $this->bean->{$name} == '1900-01-01')) {
                     $quote = '';
                     $val = 'NULL';
                     $this->bean->{$name} = '';
                     // do not set it to string 'NULL'
                 }
                 if ($isUpdate) {
                     if ($first) {
                         $query .= " {$name}={$quote}" . $this->db->quote($val) . "{$quote}";
                     } else {
                         $query .= " ,{$name}={$quote}" . $this->db->quote($val) . "{$quote}";
                     }
                 }
                 $first = false;
                 $queryInsert .= " ,{$name}";
                 $values .= " ,{$quote}" . $this->db->quote($val) . "{$quote}";
             }
         }
         if ($isUpdate) {
             $query .= " WHERE id_c='" . $this->bean->id . "'";
         }
         $queryInsert .= " ) VALUES {$values} )";
         if (!$first) {
             if (!$isUpdate) {
                 $this->db->query($queryInsert);
             } else {
                 $checkQuery = "SELECT id_c FROM {$this->bean->table_name}_cstm WHERE id_c = '{$this->bean->id}'";
                 if ($this->db->getOne($checkQuery)) {
                     $this->db->query($query);
                 } else {
                     $this->db->query($queryInsert);
                 }
             }
         }
     }
 }