This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
namespace HenrikZiegenhain\MyExt\DataProcessor; | |
/*************************************************************** | |
* Copyright notice | |
* | |
* (c) 2018 Henrik Ziegenhain <[email protected]> | |
* All rights reserved | |
* | |
* This script is part of the TYPO3 project. The TYPO3 project is |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Just copy all tables from plural to singular naming | |
create table tx_powermail_domain_model_form LIKE tx_powermail_domain_model_forms; | |
insert tx_powermail_domain_model_form select * from tx_powermail_domain_model_forms; | |
create table tx_powermail_domain_model_page LIKE tx_powermail_domain_model_pages; | |
insert tx_powermail_domain_model_page select * from tx_powermail_domain_model_pages; | |
create table tx_powermail_domain_model_field LIKE tx_powermail_domain_model_fields; | |
insert tx_powermail_domain_model_field select * from tx_powermail_domain_model_fields; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** @var ObjectManager $objm */ | |
$dbParser = $this->objectManager->get(Typo3DbQueryParser::class); | |
$sql = $dbParser->convertQueryToDoctrineQueryBuilder($query)->getSQL(); | |
DebuggerUtility::var_dump($sql); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$sql = '...'; | |
$stmt = $conn->prepare($sql); | |
try { | |
$stmt->execute(); | |
} catch (\Doctrine\DBAL\DBALException $e) { | |
$previous = $e->getPrevious(); |