/**
  * {@inheritdoc}
  */
 public function submitForm(array &$form, FormStateInterface $form_state)
 {
     $_SESSION['dblog_overview_filter'] = array();
     $this->connection->delete('watchdog')->execute();
     drupal_set_message($this->t('Database log cleared.'));
     $form_state->setRedirectUrl($this->getCancelUrl());
 }
 /**
  * @param DrupalStyle $io
  * @param $eventType
  * @param $eventSeverity
  * @param $userId
  * @return bool
  */
 protected function clearEvents(DrupalStyle $io, $eventType, $eventSeverity, $userId)
 {
     $severity = RfcLogLevel::getLevels();
     $query = $this->database->delete('watchdog');
     if ($eventType) {
         $query->condition('type', $eventType);
     }
     if ($eventSeverity) {
         if (!in_array($eventSeverity, $severity)) {
             $io->error(sprintf($this->trans('commands.database.log.clear.messages.invalid-severity'), $eventSeverity));
             return false;
         }
         $query->condition('severity', array_search($eventSeverity, $severity));
     }
     if ($userId) {
         $query->condition('uid', $userId);
     }
     $result = $query->execute();
     if (!$result) {
         $io->error($this->trans('commands.database.log.clear.messages.clear-error'));
         return false;
     }
     $io->success($this->trans('commands.database.log.clear.messages.clear-sucess'));
     return true;
 }
 /**
  * {@inheritdoc}
  */
 public function submitForm(array &$form, array &$form_state)
 {
     $_SESSION['dblog_overview_filter'] = array();
     $this->connection->delete('watchdog')->execute();
     drupal_set_message($this->t('Database log cleared.'));
     $form_state['redirect_route'] = $this->getCancelRoute();
 }
 /**
  * {@inheritdoc}
  */
 public function delete($conditions)
 {
     $path = $this->load($conditions);
     $query = $this->connection->delete('url_alias');
     foreach ($conditions as $field => $value) {
         $query->condition($field, $value);
     }
     $deleted = $query->execute();
     // @todo Switch to using an event for this instead of a hook.
     $this->moduleHandler->invokeAll('path_delete', array($path));
     return $deleted;
 }
Exemple #5
0
 /**
  * {@inheritdoc}
  */
 public function delete($module = NULL, $uid = NULL, $name = NULL)
 {
     $query = $this->connection->delete('users_data');
     // Cast scalars to array so we can consistently use an IN condition.
     if (isset($module)) {
         $query->condition('module', (array) $module, 'IN');
     }
     if (isset($uid)) {
         $query->condition('uid', (array) $uid, 'IN');
     }
     if (isset($name)) {
         $query->condition('name', (array) $name, 'IN');
     }
     $query->execute();
 }
 /**
  * {@inheritdoc}
  */
 protected function doDelete($entities)
 {
     $ids = array_keys($entities);
     $this->database->delete($this->entityType->getBaseTable())->condition($this->idKey, $ids, 'IN')->execute();
     // Reset the cache as soon as the changes have been applied.
     $this->resetCache($ids);
 }
 /**
  * {@inheritdoc}
  */
 protected function execute(InputInterface $input, OutputInterface $output)
 {
     $io = new DrupalStyle($input, $output);
     $uid = $input->getArgument('uid');
     $account = User::load($uid);
     if (!$account) {
         // Error loading User entity.
         $io->error(sprintf($this->trans('commands.user.login.clear.attempts.errors.invalid-user'), $uid));
         return 1;
     }
     // Define event name and identifier.
     $event = 'user.failed_login_user';
     // Identifier is created by uid and IP address,
     // Then we defined a generic identifier.
     $identifier = "{$account->id()}-";
     // Retrieve current database connection.
     $schema = $this->database->schema();
     $flood = $schema->findTables('flood');
     if (!$flood) {
         $io->error($this->trans('commands.user.login.clear.attempts.errors.no-flood'));
         return 1;
     }
     // Clear login attempts.
     $this->database->delete('flood')->condition('event', $event)->condition('identifier', $this->database->escapeLike($identifier) . '%', 'LIKE')->execute();
     // Command executed successful.
     $io->success(sprintf($this->trans('commands.user.login.clear.attempts.messages.successful'), $uid));
 }
Exemple #8
0
 /**
  * {@inheritdoc}
  */
 public function delete($uid)
 {
     // Nothing to do if we are not allowed to change the session.
     if (!$this->writeSafeHandler->isSessionWritable() || $this->isCli()) {
         return;
     }
     $this->connection->delete('sessions')->condition('uid', $uid)->execute();
 }
 /**
  * Creates delete query.
  *
  * @param string $table
  *   The table name.
  * @param array $keys
  *   Array with object keys indexed by field name.
  *
  * @return \Drupal\Core\Database\Query\Delete
  *   Returns a new Delete object for the injected database connection.
  */
 protected function dbDelete($table, $keys)
 {
     $query = $this->connection->delete($table, $this->options);
     foreach ($keys as $field => $value) {
         $query->condition($field, $value);
     }
     return $query;
 }
 /**
  * {@inheritdoc}
  */
 public function garbageCollection()
 {
     try {
         $return = $this->connection->delete(static::TABLE_NAME)->condition('expiration', REQUEST_TIME, '<')->execute();
     } catch (\Exception $e) {
         $this->catchException($e);
     }
 }
 /**
  * {@inheritdoc}
  */
 public function cleanup()
 {
     try {
         // Cleanup the batch table and the queue for failed batches.
         $this->connection->delete('batch')->condition('timestamp', REQUEST_TIME - 864000, '<')->execute();
     } catch (\Exception $e) {
         $this->catchException($e);
     }
 }
 /**
  * Responds to entity DELETE requests.
  *
  * @param int $id
  *   The ID of the record.
  *
  * @return \Drupal\rest\ModifiedResourceResponse
  *   The HTTP response object.
  *
  * @throws \Symfony\Component\HttpKernel\Exception\HttpException
  */
 public function delete($id)
 {
     // Make sure the record still exists.
     $this->loadRecord($id);
     $this->dbConnection->delete('example_foo')->condition('id', $id)->execute();
     $this->logger->notice('Deleted record with ID %id.');
     // Deleted responses have an empty body.
     return new ModifiedResourceResponse(NULL, 204);
 }
 /**
  * {@inheritdoc}
  */
 public function deleteAll($prefix = '')
 {
     try {
         $options = array('return' => Database::RETURN_AFFECTED) + $this->options;
         return (bool) $this->connection->delete($this->table, $options)->condition('name', $prefix . '%', 'LIKE')->condition('collection', $this->collection)->execute();
     } catch (\Exception $e) {
         return FALSE;
     }
 }
 /**
  * Implements Drupal\Core\Cache\CacheBackendInterface::garbageCollection().
  */
 public function garbageCollection()
 {
     try {
         $this->connection->delete($this->bin)->condition('expire', Cache::PERMANENT, '<>')->condition('expire', REQUEST_TIME, '<')->execute();
     } catch (\Exception $e) {
         // If the table does not exist, it surely does not have garbage in it.
         // If the table exists, the next garbage collection will clean up.
         // There is nothing to do.
     }
 }
 /**
  * {@inheritdoc}
  */
 public function gc($lifetime)
 {
     // Be sure to adjust 'php_value session.gc_maxlifetime' to a large enough
     // value. For example, if you want user sessions to stay in your database
     // for three weeks before deleting them, you need to set gc_maxlifetime
     // to '1814400'. At that value, only after a user doesn't log in after
     // three weeks (1814400 seconds) will his/her session be removed.
     $this->connection->delete('sessions')->condition('timestamp', REQUEST_TIME - $lifetime, '<')->execute();
     return TRUE;
 }
 /**
  * {@inheritdoc}
  */
 public function releaseAll($lock_id = NULL)
 {
     // Only attempt to release locks if any were acquired.
     if (!empty($this->locks)) {
         $this->locks = array();
         if (empty($lock_id)) {
             $lock_id = $this->getLockId();
         }
         $this->database->delete('semaphore')->condition('value', $lock_id)->execute();
     }
 }
Exemple #17
0
 /**
  * {@inheritdoc}
  */
 public function garbageCollection()
 {
     try {
         // Clean up the queue for failed batches.
         $this->connection->delete(static::TABLE_NAME)->condition('created', REQUEST_TIME - 864000, '<')->condition('name', 'drupal_batch:%', 'LIKE')->execute();
         // Reset expired items in the default queue implementation table. If that's
         // not used, this will simply be a no-op.
         $this->connection->update(static::TABLE_NAME)->fields(array('expire' => 0))->condition('expire', 0, '<>')->condition('expire', REQUEST_TIME, '<')->execute();
     } catch (\Exception $e) {
         $this->catchException($e);
     }
 }
 /**
  * Implements Drupal\file\FileUsage\FileUsageInterface::delete().
  */
 public function delete(FileInterface $file, $module, $type = NULL, $id = NULL, $count = 1)
 {
     // Delete rows that have a exact or less value to prevent empty rows.
     $query = $this->connection->delete($this->tableName)->condition('module', $module)->condition('fid', $file->id());
     if ($type && $id) {
         $query->condition('type', $type)->condition('id', $id);
     }
     if ($count) {
         $query->condition('count', $count, '<=');
     }
     $result = $query->execute();
     // If the row has more than the specified count decrement it by that number.
     if (!$result && $count > 0) {
         $query = $this->connection->update($this->tableName)->condition('module', $module)->condition('fid', $file->id());
         if ($type && $id) {
             $query->condition('type', $type)->condition('id', $id);
         }
         $query->expression('count', 'count - :count', array(':count' => $count));
         $query->execute();
     }
     parent::delete($file, $module, $type, $id, $count);
 }
Exemple #19
0
 /**
  * {@inheritdoc}
  */
 public function delete(array $ids = NULL, ServerInterface $server = NULL, $index = NULL) {
   $delete = $this->database->delete('search_api_task');
   if ($ids) {
     $delete->condition('id', $ids, 'IN');
   }
   if ($server) {
     $delete->condition('server_id', $server->id());
   }
   if ($index) {
     $delete->condition('index_id', $index instanceof IndexInterface ? $index->id() : $index);
   }
   $delete->execute();
 }
Exemple #20
0
 /**
  * Dumps a set of routes to the router table in the database.
  *
  * Available options:
  * - provider: The route grouping that is being dumped. All existing
  *   routes with this provider will be deleted on dump.
  * - base_class: The base class name.
  *
  * @param array $options
  *   An array of options.
  */
 public function dump(array $options = array())
 {
     // Convert all of the routes into database records.
     // Accumulate the menu masks on top of any we found before.
     $masks = array_flip($this->state->get('routing.menu_masks.' . $this->tableName, array()));
     // Delete any old records first, then insert the new ones. That avoids
     // stale data. The transaction makes it atomic to avoid unstable router
     // states due to random failures.
     $transaction = $this->connection->startTransaction();
     try {
         // We don't use truncate, because it is not guaranteed to be transaction
         // safe.
         try {
             $this->connection->delete($this->tableName)->execute();
         } catch (\Exception $e) {
             $this->ensureTableExists();
         }
         // Split the routes into chunks to avoid big INSERT queries.
         $route_chunks = array_chunk($this->routes->all(), 50, TRUE);
         foreach ($route_chunks as $routes) {
             $insert = $this->connection->insert($this->tableName)->fields(array('name', 'fit', 'path', 'pattern_outline', 'number_parts', 'route'));
             $names = array();
             foreach ($routes as $name => $route) {
                 /** @var \Symfony\Component\Routing\Route $route */
                 $route->setOption('compiler_class', '\\Drupal\\Core\\Routing\\RouteCompiler');
                 /** @var \Drupal\Core\Routing\CompiledRoute $compiled */
                 $compiled = $route->compile();
                 // The fit value is a binary number which has 1 at every fixed path
                 // position and 0 where there is a wildcard. We keep track of all such
                 // patterns that exist so that we can minimize the number of path
                 // patterns we need to check in the RouteProvider.
                 $masks[$compiled->getFit()] = 1;
                 $names[] = $name;
                 $values = array('name' => $name, 'fit' => $compiled->getFit(), 'path' => $route->getPath(), 'pattern_outline' => $compiled->getPatternOutline(), 'number_parts' => $compiled->getNumParts(), 'route' => serialize($route));
                 $insert->values($values);
             }
             // Insert all new routes.
             $insert->execute();
         }
     } catch (\Exception $e) {
         $transaction->rollback();
         watchdog_exception('Routing', $e);
         throw $e;
     }
     // Sort the masks so they are in order of descending fit.
     $masks = array_keys($masks);
     rsort($masks);
     $this->state->set('routing.menu_masks.' . $this->tableName, $masks);
     $this->routes = NULL;
 }
 /**
  * {@inheritdoc}
  */
 public function deleteMails(array $conditions)
 {
     // Continue to support 'nid'.
     if (!empty($conditions['nid'])) {
         $conditions['entity_type'] = 'node';
         $conditions['entity_id'] = $conditions['nid'];
         unset($conditions['nid']);
     }
     $query = $this->connection->delete('simplenews_mail_spool');
     foreach ($conditions as $condition => $value) {
         $query->condition($condition, $value);
     }
     return $query->execute();
 }
 /**
  * Implements \Drupal\user\UserDataInterface::delete().
  */
 public function delete($module = NULL, $uid = NULL, $name = NULL)
 {
     $query = $this->connection->delete('users_data');
     if (isset($module)) {
         $query->condition('module', $module);
     }
     if (isset($uid)) {
         $query->condition('uid', $uid);
     }
     if (isset($name)) {
         $query->condition('name', $name);
     }
     $query->execute();
 }
 /**
  * {@inheritdoc}
  */
 public function deleteItems(IndexInterface $index, array $item_ids)
 {
     try {
         if (empty($this->configuration['field_tables'][$index->id()])) {
             return;
         }
         foreach ($this->configuration['field_tables'][$index->id()] as $field) {
             $this->database->delete($field['table'])->condition('item_id', $item_ids, 'IN')->execute();
         }
         // Delete the denormalized field data.
         $this->database->delete($this->configuration['index_tables'][$index->id()])->condition('item_id', $item_ids, 'IN')->execute();
     } catch (\Exception $e) {
         throw new SearchApiException($e->getMessage(), $e->getCode(), $e);
     }
 }
  /**
   * Deletes all of a flag's count entries.
   *
   * @param \Drupal\flag\event\FlagResetEvent $event
   *   The flag reset event.
   */
  public function resetFlagCounts(FlagResetEvent $event) {
    /* @var \Drupal\flag\FlaggingInterface flag */
    $flag = $event->getFlag();

    $this->connection->delete('flag_counts')
      ->condition('flag_id', $flag->id())
      ->execute();

    // Reset statically cached counts.
    $this->entityCounts = [];
    $this->flagCounts = [];
    $this->flagEntityCounts = [];
    $this->userFlagCounts = [];

  }
Exemple #25
0
 /**
  * {@inheritdoc}
  */
 public function deleteFromBook($nid)
 {
     $original = $this->loadBookLink($nid, FALSE);
     $this->connection->delete('book')->condition('nid', $nid)->execute();
     if ($nid == $original['bid']) {
         // Handle deletion of a top-level post.
         $result = $this->connection->query("SELECT * FROM {book} WHERE pid = :nid", array(':nid' => $nid))->fetchAllAssoc('nid', \PDO::FETCH_ASSOC);
         foreach ($result as $child) {
             $child['bid'] = $child['nid'];
             $this->updateOutline($child);
         }
     }
     $this->updateOriginalParent($original);
     $this->books = NULL;
     \Drupal::cache('data')->deleteTags(array('bid' => $original['bid']));
 }
Exemple #26
0
 /**
  * Delete a phonebook entry.
  *
  * @param \Drupal\Core\Routing\RouteMatch $routeMatch
  */
 public function delete(RouteMatch $routeMatch)
 {
     // CSRF is already checked by the routing system, so we're only making sure
     // that an existing item is being deleted.
     $pbid = $routeMatch->getParameter('phonebook');
     $query = $this->connection->select('phonebook', 'p')->fields('p', ['name']);
     $query->condition('pbid', $pbid);
     $entry = $query->execute()->fetchObject();
     if (!$entry) {
         // Return a 404 if the entry is not found.
         throw new NotFoundHttpException();
     }
     $this->connection->delete('phonebook')->condition('pbid', $pbid)->execute();
     drupal_set_message($this->t('Deleted entry for %name.', ['%name' => $entry->name]));
     return new RedirectResponse('/phonebook');
 }
Exemple #27
0
 /**
  * {@inheritdoc}
  */
 public function deleteItems(IndexInterface $index, array $item_ids)
 {
     try {
         $db_info = $this->getIndexDbInfo($index);
         if (empty($db_info['field_tables'])) {
             return;
         }
         foreach ($db_info['field_tables'] as $field) {
             $this->database->delete($field['table'])->condition('item_id', $item_ids, 'IN')->execute();
         }
         // Delete the denormalized field data.
         $this->database->delete($db_info['index_table'])->condition('item_id', $item_ids, 'IN')->execute();
     } catch (\Exception $e) {
         // The database operations might throw PDO or other exceptions, so we
         // catch them all and re-wrap them appropriately.
         throw new SearchApiException($e->getMessage(), $e->getCode(), $e);
     }
 }
Exemple #28
0
 /**
  * {@inheritdoc}
  */
 public function delete($conditions)
 {
     $path = $this->load($conditions);
     $query = $this->connection->delete('url_alias');
     foreach ($conditions as $field => $value) {
         if ($field == 'source' || $field == 'alias') {
             // Use LIKE for case-insensitive matching.
             $query->condition($field, $this->connection->escapeLike($value), 'LIKE');
         } else {
             $query->condition($field, $value);
         }
     }
     $deleted = $query->execute();
     // @todo Switch to using an event for this instead of a hook.
     $this->moduleHandler->invokeAll('path_delete', array($path));
     Cache::invalidateTags(['route_match']);
     return $deleted;
 }
 /**
  * {@inheritdoc}
  */
 public function delete($id)
 {
     // Children get re-attached to the menu link's parent.
     $item = $this->loadFull($id);
     // It's possible the link is already deleted.
     if ($item) {
         $parent = $item['parent'];
         $children = $this->loadByProperties(array('parent' => $id));
         foreach ($children as $child) {
             $child['parent'] = $parent;
             $this->save($child);
         }
         $this->connection->delete($this->table, $this->options)->condition('id', $id)->execute();
         $this->updateParentalStatus($item);
         // Many children may have moved.
         $this->resetDefinitions();
         Cache::invalidateTags(array('menu:' . $item['menu_name']));
     }
 }
 /**
  * {@inheritdoc}
  */
 public function deleteNodeRecords(array $nids)
 {
     $this->database->delete('node_access')->condition('nid', $nids, 'IN')->execute();
 }