class DatabaseTestController
Same name in other branches
- 9 core/modules/system/tests/modules/database_test/src/Controller/DatabaseTestController.php \Drupal\database_test\Controller\DatabaseTestController
- 8.9.x core/modules/system/tests/modules/database_test/src/Controller/DatabaseTestController.php \Drupal\database_test\Controller\DatabaseTestController
- 11.x core/modules/system/tests/modules/database_test/src/Controller/DatabaseTestController.php \Drupal\database_test\Controller\DatabaseTestController
Controller routines for database_test routes.
Hierarchy
- class \Drupal\Core\Controller\ControllerBase implements \Drupal\Core\DependencyInjection\ContainerInjectionInterface uses \Drupal\Core\DependencyInjection\AutowireTrait, \Drupal\Core\Logger\LoggerChannelTrait, \Drupal\Core\Messenger\MessengerTrait, \Drupal\Core\Routing\RedirectDestinationTrait, \Drupal\Core\StringTranslation\StringTranslationTrait
- class \Drupal\database_test\Controller\DatabaseTestController extends \Drupal\Core\Controller\ControllerBase
Expanded class hierarchy of DatabaseTestController
File
-
core/
modules/ system/ tests/ modules/ database_test/ src/ Controller/ DatabaseTestController.php, line 15
Namespace
Drupal\database_test\ControllerView source
class DatabaseTestController extends ControllerBase {
/**
* The database connection.
*
* @var \Drupal\Core\Database\Connection
*/
protected $connection;
/**
* Constructs a DatabaseTestController object.
*
* @param \Drupal\Core\Database\Connection $connection
* A database connection.
*/
public function __construct(Connection $connection) {
$this->connection = $connection;
}
/**
* {@inheritdoc}
*/
public static function create(ContainerInterface $container) {
return new static($container->get('database'));
}
/**
* Runs a pager query and returns the results.
*
* This function does care about the page GET parameter, as set by the
* test HTTP call.
*
* @return \Symfony\Component\HttpFoundation\JsonResponse
*/
public function pagerQueryEven($limit) {
$query = $this->connection
->select('test', 't');
$query->fields('t', [
'name',
])
->orderBy('age');
// This should result in 2 pages of results.
$query = $query->extend(PagerSelectExtender::class)
->limit($limit);
$names = $query->execute()
->fetchCol();
return new JsonResponse([
'names' => $names,
]);
}
/**
* Runs a pager query and returns the results.
*
* This function does care about the page GET parameter, as set by the
* test HTTP call.
*
* @return \Symfony\Component\HttpFoundation\JsonResponse
*/
public function pagerQueryOdd($limit) {
$query = $this->connection
->select('test_task', 't');
$query->fields('t', [
'task',
])
->orderBy('pid');
// This should result in 4 pages of results.
$query = $query->extend(PagerSelectExtender::class)
->limit($limit);
$names = $query->execute()
->fetchCol();
return new JsonResponse([
'names' => $names,
]);
}
/**
* Runs a tablesort query and returns the results.
*
* This function does care about the page GET parameter, as set by the
* test HTTP call.
*
* @return \Symfony\Component\HttpFoundation\JsonResponse
*/
public function testTablesort() {
$header = [
'tid' => [
'data' => t('Task ID'),
'field' => 'tid',
'sort' => 'desc',
],
'pid' => [
'data' => t('Person ID'),
'field' => 'pid',
],
'task' => [
'data' => t('Task'),
'field' => 'task',
],
'priority' => [
'data' => t('Priority'),
'field' => 'priority',
],
];
$query = $this->connection
->select('test_task', 't');
$query->fields('t', [
'tid',
'pid',
'task',
'priority',
]);
$query = $query->extend(TableSortExtender::class)
->orderByHeader($header);
// We need all the results at once to check the sort.
$tasks = $query->execute()
->fetchAll();
return new JsonResponse([
'tasks' => $tasks,
]);
}
/**
* Runs a tablesort query with a second order_by after and returns the results.
*
* This function does care about the page GET parameter, as set by the
* test HTTP call.
*
* @return \Symfony\Component\HttpFoundation\JsonResponse
*/
public function testTablesortFirst() {
$header = [
'tid' => [
'data' => t('Task ID'),
'field' => 'tid',
'sort' => 'desc',
],
'pid' => [
'data' => t('Person ID'),
'field' => 'pid',
],
'task' => [
'data' => t('Task'),
'field' => 'task',
],
'priority' => [
'data' => t('Priority'),
'field' => 'priority',
],
];
$query = $this->connection
->select('test_task', 't');
$query->fields('t', [
'tid',
'pid',
'task',
'priority',
]);
$query = $query->extend(TableSortExtender::class)
->orderByHeader($header)
->orderBy('priority');
// We need all the results at once to check the sort.
$tasks = $query->execute()
->fetchAll();
return new JsonResponse([
'tasks' => $tasks,
]);
}
}
Members
Title Sort descending | Modifiers | Object type | Summary | Overriden Title | Overrides |
---|---|---|---|---|---|
ControllerBase::$configFactory | protected | property | The configuration factory. | ||
ControllerBase::$currentUser | protected | property | The current user service. | 2 | |
ControllerBase::$entityFormBuilder | protected | property | The entity form builder. | ||
ControllerBase::$entityTypeManager | protected | property | The entity type manager. | ||
ControllerBase::$formBuilder | protected | property | The form builder. | 1 | |
ControllerBase::$keyValue | protected | property | The key-value storage. | 1 | |
ControllerBase::$languageManager | protected | property | The language manager. | 1 | |
ControllerBase::$moduleHandler | protected | property | The module handler. | 1 | |
ControllerBase::$stateService | protected | property | The state service. | ||
ControllerBase::cache | protected | function | Returns the requested cache bin. | ||
ControllerBase::config | protected | function | Retrieves a configuration object. | ||
ControllerBase::container | private | function | Returns the service container. | ||
ControllerBase::currentUser | protected | function | Returns the current user. | 2 | |
ControllerBase::entityFormBuilder | protected | function | Retrieves the entity form builder. | ||
ControllerBase::entityTypeManager | protected | function | Retrieves the entity type manager. | ||
ControllerBase::formBuilder | protected | function | Returns the form builder service. | 1 | |
ControllerBase::keyValue | protected | function | Returns a key/value storage collection. | 1 | |
ControllerBase::languageManager | protected | function | Returns the language manager service. | 1 | |
ControllerBase::moduleHandler | protected | function | Returns the module handler. | 1 | |
ControllerBase::redirect | protected | function | Returns a redirect response object for the specified route. | ||
ControllerBase::state | protected | function | Returns the state storage service. | ||
DatabaseTestController::$connection | protected | property | The database connection. | ||
DatabaseTestController::create | public static | function | Instantiates a new instance of the implementing class using autowiring. | Overrides AutowireTrait::create | |
DatabaseTestController::pagerQueryEven | public | function | Runs a pager query and returns the results. | ||
DatabaseTestController::pagerQueryOdd | public | function | Runs a pager query and returns the results. | ||
DatabaseTestController::testTablesort | public | function | Runs a tablesort query and returns the results. | ||
DatabaseTestController::testTablesortFirst | public | function | Runs a tablesort query with a second order_by after and returns the results. | ||
DatabaseTestController::__construct | public | function | Constructs a DatabaseTestController object. | ||
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. | 16 | |
MessengerTrait::messenger | public | function | Gets the messenger. | 16 | |
MessengerTrait::setMessenger | public | function | Sets the messenger. | ||
RedirectDestinationTrait::$redirectDestination | protected | property | The redirect destination service. | 2 | |
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. | 3 | |
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. |
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.