Project

General

Profile

Actions
Copy link

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:
Stefan Bürk
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 open — 1 closed)

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

Actions
Actions
Copy link
 #1

Updated by Gerrit Code Review 2 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
Copy link
 #2

Updated by Gerrit Code Review 2 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
Copy link
 #3

Updated by Gerrit Code Review 2 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
Copy link
 #4

Updated by Gerrit Code Review 2 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
Copy link
 #5

Updated by Gerrit Code Review 2 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
Copy link
 #6

Updated by Gerrit Code Review 2 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
Copy link
 #7

Updated by Gerrit Code Review 2 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
Copy link
 #8

Updated by Gerrit Code Review 2 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
Copy link
 #9

Updated by Gerrit Code Review 2 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
Copy link
 #10

Updated by Stefan Bürk 2 months ago

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

Updated by Stefan Bürk 2 months ago

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

Also available in: Atom PDF