/**
* Constructor
*
* @return void
*/
public function __construct()
{
$this->db = Centreon_Db_Manager::factory('centreon');
$res = $this->db->query("SELECT `value` FROM informations WHERE `key` = 'version'");
$row = $res->fetch();
$this->version = $row['value'];
$this->params = array();
$this->insertParams = array();
$this->exportExcludedParams = array();
$this->action = "";
$this->delim = ";";
}
/**
* check if user exists already in dbmail user table
*
* @param Tinebase_Model_FullUser $_user
*/
protected function _userExists(Tinebase_Model_FullUser $_user)
{
$userId = $_user->getId();
$select = $this->_getSelect();
$select->where($this->_db->quoteIdentifier($this->_propertyMapping['emailUserId']) . ' = ?', $this->_hasTine20Userid === true ? $userId : $this->_convertToInt($userId));
if (Tinebase_Core::isLogLevel(Zend_Log::TRACE)) {
Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . ' ' . $select->__toString());
}
// Perferom query - retrieve user from database
$stmt = $this->_db->query($select);
$queryResult = $stmt->fetch();
$stmt->closeCursor();
if (!$queryResult) {
return false;
}
return true;
}
/**
* Runs the sql query
*
* @param string $sqlQuery
*/
public function runSetup($sqlQuery)
{
$this->dbAdapter->query($sqlQuery);
}
/**
* check if user exists already in dovecot user table
*
* @param Tinebase_Model_FullUser $_user
*/
protected function _userExists(Tinebase_Model_FullUser $_user)
{
$select = $this->_getSelect();
$select->where($this->_db->quoteIdentifier($this->_userTable . '.' . $this->_propertyMapping['emailUserId']) . ' = ?', $_user->getId());
#if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' ' . $select->__toString());
// Perferom query - retrieve user from database
$stmt = $this->_db->query($select);
$queryResult = $stmt->fetch();
$stmt->closeCursor();
if (!$queryResult) {
return false;
}
return true;
}
