christophlehmann/typo3-datahandler-cli

Use CLI commands to modify database records with the TYPO3 DataHandler. A lowlevel way for mass changes.

dev-main 2024-08-29 22:02 UTC

Requires

• typo3/cms-core: ^12.4 || ^13.2

GPL-2.0-or-later

• Christoph Lehmann

• cli
• workspace
• datahandler

README

Use CLI commands to modify database records with the TYPO3 DataHandler. A lowlevel way for mass changes.

Pages with title Detail should not be included in search

./bin/typo3 datahandler:patch \
    --table pages \
    --whereClause 'title="Detail"' \
    --jsonPatch '{"no_search": 1}'

Page #2 should become an external link to typo3.org

./bin/typo3 datahandler:patch \
    --table pages \
    --records 2 \
    --jsonPatch '{"doktype": 3, "url": "https://typo3.org"}'

Delete page #100 and #200

./bin/typo3 datahandler:delete \
    --table pages \
    --records 100,200

With --workspace changes can be applied in a workspace.

Status

It's very alpha, so use with care.