class SqliteDateSql
Same name in other branches
- 8.9.x core/modules/views/src/Plugin/views/query/SqliteDateSql.php \Drupal\views\Plugin\views\query\SqliteDateSql
- 10 core/modules/views/src/Plugin/views/query/SqliteDateSql.php \Drupal\views\Plugin\views\query\SqliteDateSql
- 11.x core/modules/views/src/Plugin/views/query/SqliteDateSql.php \Drupal\views\Plugin\views\query\SqliteDateSql
SQLite-specific date handling.
@internal This class should only be used by the Views SQL query plugin.
Hierarchy
- class \Drupal\views\Plugin\views\query\SqliteDateSql implements \Drupal\views\Plugin\views\query\DateSqlInterface uses \Drupal\Core\DependencyInjection\DependencySerializationTrait
Expanded class hierarchy of SqliteDateSql
See also
\Drupal\views\Plugin\views\query\Sql
1 file declares its use of SqliteDateSql
- SqliteDateSqlTest.php in core/
modules/ views/ tests/ src/ Unit/ Plugin/ views/ query/ SqliteDateSqlTest.php
1 string reference to 'SqliteDateSql'
- views.services.yml in core/
modules/ views/ views.services.yml - core/modules/views/views.services.yml
1 service uses SqliteDateSql
- sqlite.views.date_sql in core/
modules/ views/ views.services.yml - Drupal\views\Plugin\views\query\SqliteDateSql
File
-
core/
modules/ views/ src/ Plugin/ views/ query/ SqliteDateSql.php, line 16
Namespace
Drupal\views\Plugin\views\queryView source
class SqliteDateSql implements DateSqlInterface {
use DependencySerializationTrait;
/**
* The database connection.
*
* @var \Drupal\Core\Database\Connection
*/
protected $database;
/**
* An array of PHP-to-SQLite date replacement patterns.
*
* @var array
*/
protected static $replace = [
'Y' => '%Y',
// No format for 2 digit year number.
'y' => '%Y',
// No format for 3 letter month name.
'M' => '%m',
'm' => '%m',
// No format for month number without leading zeros.
'n' => '%m',
// No format for full month name.
'F' => '%m',
// No format for 3 letter day name.
'D' => '%d',
'd' => '%d',
// No format for full day name.
'l' => '%d',
// no format for day of month number without leading zeros.
'j' => '%d',
'W' => '%W',
'H' => '%H',
// No format for 12 hour with leading zeros.
'h' => '%H',
'i' => '%M',
's' => '%S',
// No format for AM/PM.
'A' => '',
];
/**
* Constructs the SQLite-specific date sql class.
*
* @param \Drupal\Core\Database\Connection $database
* The database connection.
*/
public function __construct(Connection $database) {
$this->database = $database;
}
/**
* {@inheritdoc}
*/
public function getDateField($field, $string_date) {
if ($string_date) {
$field = "strftime('%s', {$field})";
}
return $field;
}
/**
* {@inheritdoc}
*/
public function getDateFormat($field, $format) {
$format = strtr($format, static::$replace);
// SQLite does not have an ISO week substitution string, so it needs special
// handling.
// @see http://wikipedia.org/wiki/ISO_week_date#Calculation
// @see http://stackoverflow.com/a/15511864/1499564
if ($format === '%W') {
$expression = "((strftime('%j', date(strftime('%Y-%m-%d', {$field}, 'unixepoch'), '-3 days', 'weekday 4')) - 1) / 7 + 1)";
}
else {
$expression = "strftime('{$format}', {$field}, 'unixepoch')";
}
// The expression yields a string, but the comparison value is an integer in
// case the comparison value is a float, integer, or numeric. All of the
// above SQLite format tokens only produce integers. However, the given
// $format may contain 'Y-m-d', which results in a string.
// @see \Drupal\sqlite\Driver\Database\sqlite\Connection::expandArguments()
// @see http://www.sqlite.org/lang_datefunc.html
// @see http://www.sqlite.org/lang_expr.html#castexpr
if (preg_match('/^(?:%\\w)+$/', $format)) {
$expression = "CAST({$expression} AS NUMERIC)";
}
return $expression;
}
/**
* {@inheritdoc}
*/
public function setTimezoneOffset($offset) {
// Nothing to do here.
}
/**
* {@inheritdoc}
*/
public function setFieldTimezoneOffset(&$field, $offset, $string_date = FALSE) {
if (!empty($offset)) {
$field = "({$field} + {$offset})";
}
}
}
Members
Title Sort descending | Modifiers | Object type | Summary | Overriden Title | Overrides |
---|---|---|---|---|---|
DependencySerializationTrait::$_entityStorages | protected | property | |||
DependencySerializationTrait::$_serviceIds | protected | property | |||
DependencySerializationTrait::__sleep | public | function | 1 | ||
DependencySerializationTrait::__wakeup | public | function | 2 | ||
SqliteDateSql::$database | protected | property | The database connection. | ||
SqliteDateSql::$replace | protected static | property | An array of PHP-to-SQLite date replacement patterns. | ||
SqliteDateSql::getDateField | public | function | Returns a native database expression for a given field. | Overrides DateSqlInterface::getDateField | |
SqliteDateSql::getDateFormat | public | function | Creates a native database date formatting. | Overrides DateSqlInterface::getDateFormat | |
SqliteDateSql::setFieldTimezoneOffset | public | function | Applies the given offset to the given field. | Overrides DateSqlInterface::setFieldTimezoneOffset | |
SqliteDateSql::setTimezoneOffset | public | function | Set the database to the given timezone. | Overrides DateSqlInterface::setTimezoneOffset | |
SqliteDateSql::__construct | public | function | Constructs the SQLite-specific date sql class. |
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.