public static function delete($table, $whereCondition) { Trace::addMessage(__CLASS__, sprintf('Delete from table:"%s", condition:"%s" ', $table, print_r($whereCondition, true))); $result = parent::delete($table, $whereCondition); Trace::addMessage(__CLASS__, 'deletion from "' . $table . '" finished'); return $result; }
public function cleanup($period = 0) { if (!empty($period)) { DBSimple::delete(self::TableName, array(sprintf('`actionDate` <= NOW() - INTERVAL %s', $period))); } else { $sql = sprintf('truncate %s ', self::TableName); DB::post($sql); } }
protected function storeValue() { $userId = $this->document->id->getValue(); if (empty($userId)) { return; } DBSimple::delete(self::UIDTable, array('user_id' => $userId)); foreach ($this->aValue as $network => $uid) { $network = Network::getByName($network); DBSimple::insert(self::UIDTable, array('date' => date('Y-m-d H:i:s'), 'network_id' => $network->id->getValue(), 'user_id' => $this->document->id->getValue(), 'uid' => $uid)); } }
protected static function storeExtraRecords() { \CMSLog::addMessage(__CLASS__, 'Cleaning log table'); $found = DBSimple::select(Record::tableName, array(), sprintf('id desc limit %d,1', self::$maximumLogLength)); if (empty($found)) { return; } $data = DBSimple::select(Record::tableName, '1', sprintf('id asc limit 0,%d', self::$maximumLogLength)); if (!empty($data)) { $lastId = $data[sizeof($data) - 1]['id']; $fileName = sprintf('%s%s%s.log', SYS_ROOT, self::OutputDir, date('Y-m-d H:i:s')); file_put_contents($fileName, json_encode($data)); DBSimple::delete(Record::tableName, array(sprintf('id <= %d', $lastId))); \CMSLog::addMessage(__CLASS__, 'Extra messages exported in local folder: ' . $fileName); } }
<?php use Faid\DBSimple; use Extasy\Schedule\Job; DBSimple::delete(Job::TableName, array('class' => '\\Extasy\\Users\\Tasks\\CleanLoginAttempts')); $model = new \Extasy\Users\login\LoginAttempt(); $model->createDatabaseTable(true);
public function clean() { // cleanup table remove all messages older than month DBSimple::delete(\UsersLogin::LoginAttemptsTable, array('`date` < NOW() - interval 1 month ')); }
public static function deleteAliasById($id, $aliasId) { DBSimple::delete(SITEMAP_HISTORY_TABLE, ['page_id' => IntegerHelper::toNatural($id), 'id' => IntegerHelper::toNatural($aliasId)]); }
public function onDelete(\Extasy\ORM\QueryBuilder $queryBuilder) { DBSimple::delete($this->tableName, array($this->innerKey => $this->document->id->getValue())); }
protected static function removeChild($el) { // Получаем дочерние элементы $childList = DBSimple::select(ACL_TABLE, array('parentId' => $el['id'])); foreach ($childList as $row) { // Вызов удаления для дочерних self::removeChild($row); } // Удаляем гранты на текущие элементы DBSimple::delete(ACL_GRANT_TABLE, array('actionId' => $el['id'])); // Удаляем саму запись DBSimple::delete(ACL_TABLE, array('id' => $el['id'])); }
protected function deleteOldRows() { DBSimple::delete(Job::TableName, array(sprintf('`actionDate` <= NOW() - INTERVAL %s', static::DeletePeriod))); }