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 #1

Updated by Gerrit Code Review 9 months ago

  • Status changed from New to Under Review

Patch set 7 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83209

Actions #2

Updated by Gerrit Code Review 9 months ago

Patch set 8 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83209

Actions #3

Updated by Gerrit Code Review 9 months ago

Patch set 9 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83209

Actions #4

Updated by Gerrit Code Review 9 months ago

Patch set 10 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83209

Actions #5

Updated by Gerrit Code Review 9 months ago

Patch set 11 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83209

Actions #6

Updated by Gerrit Code Review 9 months ago

Patch set 12 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83209

Actions #7

Updated by Gerrit Code Review 9 months ago

Patch set 13 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83209

Actions #8

Updated by Gerrit Code Review 9 months ago

Patch set 14 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83209

Actions #9

Updated by Gerrit Code Review 9 months ago

Patch set 15 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83209

Actions #10

Updated by Stefan Bürk 9 months ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #11

Updated by Stefan Bürk 9 months ago

  • Related to Task #103343: Replace sql int casts with `ExpressionBuilder::castInt()` added
Actions #12

Updated by Benni Mack 5 months ago

  • Status changed from Resolved to Closed
Actions #13

Updated by Christian Kuhn 4 months ago

Actions #14

Updated by Stefan Bürk 4 months ago

  • Related to Task #104493: Add `castText()` expression support to `ExpressionBuilder` added
Actions

Also available in: Atom PDF