Project

General

Profile

Actions

Feature #103309

closed

Add more expression methods to ExpressionBuilder

Added by Stefan Bürk 9 months ago. Updated 5 months ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2024-03-06
Due date:
% Done:

100%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

The ExpressionBuilder provides methods to build
database query expression parts for all supported
database vendors. A relativly conservative set has
been provided since a couple of TYPO3 and Doctrine
DBAL versions.

Additional expression methods should be added to
the ExpressionBuilder to pave the way for using
Common Table Expressions along with a to implement
CTE Builder API.

Following expressions should be implemented in a
cross database compatible way:

  • CONCAT
  • RIGHT
  • REPEAT
  • SPACE
  • LPAD
  • RPAD

where even more expression may be added at a later
point.


Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Task #103343: Replace sql int casts with `ExpressionBuilder::castInt()`ClosedStefan Bürk2024-03-08

Actions
Related to TYPO3 Core - Feature #104482: Add IF / CASE to ExpressionBuilderClosed2024-07-25

Actions
Related to TYPO3 Core - Task #104493: Add `castText()` expression support to `ExpressionBuilder`ClosedStefan Bürk2024-07-28

Actions
Actions

Also available in: Atom PDF