/** * * @param Revision $revision * @param array $data * @return boolean */ protected function saveData(RdsRevision $revision, $data) { $columns = array(self::DATA_REVISION, self::DATA_SUBJECT, self::DATA_PREDICATE, self::DATA_OBJECT, self::DATA_LANGUAGE); $multipleInsertQueryHelper = $this->persistence->getPlatForm()->getMultipleInsertsSqlQueryHelper(); $query = $multipleInsertQueryHelper->getFirstStaticPart(self::DATA_TABLE_NAME, $columns); foreach ($data as $triple) { $query .= $multipleInsertQueryHelper->getValuePart(self::DATA_TABLE_NAME, $columns, array(self::DATA_REVISION => $this->persistence->quote($revision->getId()), self::DATA_SUBJECT => $this->persistence->quote($triple->subject), self::DATA_PREDICATE => $this->persistence->quote($triple->predicate), self::DATA_OBJECT => $this->persistence->quote($triple->object), self::DATA_LANGUAGE => $this->persistence->quote($triple->lg))); } $query = substr($query, 0, strlen($query) - 1); $query .= $multipleInsertQueryHelper->getEndStaticPart(); $success = $this->persistence->exec($query); return $success; }
public static function buildLanguagePattern(common_persistence_SqlPersistence $persistence, $lang = '') { $languagePattern = ''; if (empty($lang) === false) { $sqlEmpty = $persistence->quote(''); $sqlLang = $persistence->quote($lang); $languagePattern = "l_language = {$sqlEmpty} OR l_language = {$sqlLang}"; } return $languagePattern; }
/** * Convenience access to platForm quote. * * @author Jerome Bogaerts, <*****@*****.**> * @param string $parameter The parameter to quote. * @param int $parameter_type A PDO PARAM_XX constant. * @return string The quoted string. */ public function quote($parameter) { return $this->persistence->quote($parameter); }