class OptimizedbListTablesForm in OptimizeDB 8

Operations with tables.

Hierarchy

class \Drupal\Core\Form\FormBase implements ContainerInjectionInterface, FormInterface uses DependencySerializationTrait, LoggerChannelTrait, MessengerTrait, LinkGeneratorTrait, RedirectDestinationTrait, UrlGeneratorTrait, StringTranslationTrait
- class \Drupal\optimizedb\Form\OptimizedbListTablesForm

Expanded class hierarchy of OptimizedbListTablesForm

1 string reference to 'OptimizedbListTablesForm'

optimizedb.routing.yml in ./optimizedb.routing.yml: optimizedb.routing.yml

File

src/Form/OptimizedbListTablesForm.php, line 15

Namespace

Drupal\optimizedb\Form

View source

class OptimizedbListTablesForm extends FormBase {

  /**
   * The request stack used for testing.
   *
   * @var \Symfony\Component\HttpFoundation\RequestStack
   */
  protected $requestStack;

  /**
   * The database connection used.
   *
   * @var \Drupal\Core\Database\Connection
   */
  protected $database;

  /**
   * Constructs a new FileTransferAuthorizeForm object.
   *
   * @param \Symfony\Component\HttpFoundation\RequestStack $requestStack
   *   The request stack.
   * @param \Drupal\Core\Database\Connection $database
   *   The database service.
   */
  public function __construct(RequestStack $requestStack, Connection $database) {
    $this->requestStack = $requestStack;
    $this->database = $database;
  }

  /**
   * {@inheritdoc}
   */
  public static function create(ContainerInterface $container) {
    return new static($container
      ->get('request_stack'), $container
      ->get('database'));
  }

  /**
   * {@inheritdoc}
   */
  public function getFormId() {
    return 'optimizedb_list_tables_form';
  }

  /**
   * {@inheritdoc}
   */
  public function buildForm(array $form, FormStateInterface $form_state) {
    $headers = [
      'name' => [
        'data' => $this
          ->t('Table name'),
      ],
      'size' => [
        'data' => $this
          ->t('Table size'),
        'field' => 'size',
        'sort' => 'desc',
      ],
    ];
    $tables = _optimizedb_tables_list();
    $sort = TableSort::getSort($headers, $this->requestStack
      ->getCurrentRequest());
    usort($tables, function ($a, $b) use ($sort) {
      if ($sort == 'asc') {
        return $a['size_byte'] > $b['size_byte'];
      }
      return $a['size_byte'] < $b['size_byte'];
    });
    $rows = [];

    // Messages status execute operation.
    optimizedb_operation_messages($form);
    foreach ($tables as $table) {

      // Parameter "size_byte" is only needed to sort, now this unit to remove.
      unset($table['size_byte']);
      $rows[$table['name']] = $table;
    }
    if ($this->database
      ->driver() == 'mysql') {
      $form['operations'] = [
        '#type' => 'fieldset',
        '#title' => $this
          ->t('Operations with tables:'),
      ];
      $form['operations']['check_tables'] = [
        '#type' => 'submit',
        '#value' => $this
          ->t('Check tables'),
      ];
      $form['operations']['repair_tables'] = [
        '#type' => 'submit',
        '#value' => $this
          ->t('Repair tables'),
      ];
      $form['operations']['optimize_tables'] = [
        '#type' => 'submit',
        '#value' => $this
          ->t('Optimize tables'),
      ];
    }
    $form['tables'] = [
      '#type' => 'tableselect',
      '#header' => $headers,
      '#options' => $rows,
      '#empty' => $this
        ->t('No content available.'),
    ];
    return $form;
  }

  /**
   * {@inheritdoc}
   */
  public function submitForm(array &$form, FormStateInterface $form_state) {
    $tables = $form_state
      ->getValue('tables');
    $operation = '';
    $op = (string) $form_state
      ->getValue('op');
    switch ($op) {

      // Checking the selected tables to find errors.
      case $this
        ->t('Check tables'):
        $operation = 'CHECK TABLE';
        break;

      // Repair selected tables.
      case $this
        ->t('Repair tables'):
        $operation = 'REPAIR TABLE';
        break;

      // Optimization of the selected tables.
      case $this
        ->t('Optimize tables'):
        $operation = 'OPTIMIZE TABLE';
        break;
    }
    _optimizedb_list_tables_operation_execute($tables, $operation);
  }

}

Members

Name	Modifiers	Type	Description	Overrides
DependencySerializationTrait::$_entityStorages	protected	property	An array of entity type IDs keyed by the property name of their storages.
DependencySerializationTrait::$_serviceIds	protected	property	An array of service IDs keyed by property name used for serialization.
DependencySerializationTrait::__sleep	public	function		1
DependencySerializationTrait::__wakeup	public	function		2
FormBase::$configFactory	protected	property	The config factory.	1
FormBase::$routeMatch	protected	property	The route match.
FormBase::config	protected	function	Retrieves a configuration object.
FormBase::configFactory	protected	function	Gets the config factory for this form.	1
FormBase::container	private	function	Returns the service container.
FormBase::currentUser	protected	function	Gets the current user.
FormBase::getRequest	protected	function	Gets the request object.
FormBase::getRouteMatch	protected	function	Gets the route match.
FormBase::logger	protected	function	Gets the logger for a specific channel.
FormBase::redirect	protected	function	Returns a redirect response object for the specified route. Overrides UrlGeneratorTrait::redirect
FormBase::resetConfigFactory	public	function	Resets the configuration factory.
FormBase::setConfigFactory	public	function	Sets the config factory for this form.
FormBase::setRequestStack	public	function	Sets the request stack object to use.
FormBase::validateForm	public	function	Form validation handler. Overrides FormInterface::validateForm	62
LinkGeneratorTrait::$linkGenerator	protected	property	The link generator.	1
LinkGeneratorTrait::getLinkGenerator Deprecated	protected	function	Returns the link generator.
LinkGeneratorTrait::l Deprecated	protected	function	Renders a link to a route given a route name and its parameters.
LinkGeneratorTrait::setLinkGenerator Deprecated	public	function	Sets the link generator service.
LoggerChannelTrait::$loggerFactory	protected	property	The logger channel factory service.
LoggerChannelTrait::getLogger	protected	function	Gets the logger for a specific channel.
LoggerChannelTrait::setLoggerFactory	public	function	Injects the logger channel factory.
MessengerTrait::$messenger	protected	property	The messenger.	29
MessengerTrait::messenger	public	function	Gets the messenger.	29
MessengerTrait::setMessenger	public	function	Sets the messenger.
OptimizedbListTablesForm::$database	protected	property	The database connection used.
OptimizedbListTablesForm::$requestStack	protected	property	The request stack used for testing. Overrides FormBase::$requestStack
OptimizedbListTablesForm::buildForm	public	function	Form constructor. Overrides FormInterface::buildForm
OptimizedbListTablesForm::create	public static	function	Instantiates a new instance of this class. Overrides FormBase::create
OptimizedbListTablesForm::getFormId	public	function	Returns a unique string identifying the form. Overrides FormInterface::getFormId
OptimizedbListTablesForm::submitForm	public	function	Form submission handler. Overrides FormInterface::submitForm
OptimizedbListTablesForm::__construct	public	function	Constructs a new FileTransferAuthorizeForm object.
RedirectDestinationTrait::$redirectDestination	protected	property	The redirect destination service.	1
RedirectDestinationTrait::getDestinationArray	protected	function	Prepares a 'destination' URL query parameter for use with \Drupal\Core\Url.
RedirectDestinationTrait::getRedirectDestination	protected	function	Returns the redirect destination service.
RedirectDestinationTrait::setRedirectDestination	public	function	Sets the redirect destination service.
StringTranslationTrait::$stringTranslation	protected	property	The string translation service.	1
StringTranslationTrait::formatPlural	protected	function	Formats a string containing a count of items.
StringTranslationTrait::getNumberOfPlurals	protected	function	Returns the number of plurals supported by a given language.
StringTranslationTrait::getStringTranslation	protected	function	Gets the string translation service.
StringTranslationTrait::setStringTranslation	public	function	Sets the string translation service to use.	2
StringTranslationTrait::t	protected	function	Translates a string to the current language or to a given language.
UrlGeneratorTrait::$urlGenerator	protected	property	The url generator.
UrlGeneratorTrait::getUrlGenerator Deprecated	protected	function	Returns the URL generator service.
UrlGeneratorTrait::setUrlGenerator Deprecated	public	function	Sets the URL generator service.
UrlGeneratorTrait::url Deprecated	protected	function	Generates a URL or path for a specific route based on the given parameters.

You are here

class OptimizedbListTablesForm in OptimizeDB 8

Hierarchy

File

Namespace

Members

API Navigation