Project

General

Profile

Actions

Feature #103309

closed

Add more expression methods to ExpressionBuilder

Added by Stefan Bürk 2 months ago. Updated 2 months ago.

Status:
Resolved
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 1 (0 open1 closed)

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

Actions
Actions

Also available in: Atom PDF