DavidBruchmann

Combining composer, git repositories and pear

Problem

Pear is the the old PHP-packagemanager, but most 'packages' are nowadays managed with composer on base of git-repositories.
Adding pear-packages to a composer based installation is a little challenge that shall be explained below.

Solution

Prerequisites

DavidBruchmann

# Handle line endings automatically for files detected as text
# and leave all files detected as binary untouched.
* text=auto

# Force the following filetypes to have unix eols, so Windows does not break them
*.* text eol=lf

# Windows forced line-endings
/.idea/* text eol=crlf

DavidBruchmann

Repos with string or tag "TCA" related to TYPO3

• https://github.com/Nemo64/typo3api
  An api-wrapper around typo3 functionality (currently only tca)
• https://github.com/IchHabRecht/formengine_example
  This is an example, how to add an own TCA field type for TYPO3
• https://github.com/wouter90/tca_analyzer
  Analyzer for TCA changes done in ext_tables.php of installed extensions
• https://github.com/bitpatroon/typo3_tca2
  Allows additional function like conditions to if in pageTSConfig

DavidBruchmann

<?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

DavidBruchmann

$hex = '';
$result = '';
$encoded = substr($hex, 2);
while(strlen($encoded)) {
    $current = substr($encoded, 0, 2);
    $encoded = substr($encoded, 2);
    $result .= chr(hexDec($current));
}
echo $result;

DavidBruchmann

## THIS IS ONLY TO TRUNCATE A TABLE COMPLETELY

$tablename = 'xyz'

$driver = new \Doctrine\DBAL\Driver\Mysqli\Driver;
$queryBuilder = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(
    \TYPO3\CMS\Core\Database\Query\QueryBuilder::class,
    \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(
        \TYPO3\CMS\Core\Database\Connection::class, $GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default'], $driver
    )

DavidBruchmann

"scripts":{
        "command": [
            "echo \"EVENT: command\\n\"",
            "VENDOR\\build\\command::myClassMethod"
        ],
        "pre-command-run": [
            "echo \"EVENT: pre-command-run\\n\"",
            "VENDOR\\build\\preCommandRun::myClassMethod"
        ],

DavidBruchmann

@echo off
cd /D %~dp0
echo Diese Eingabeforderung nicht waehrend des Running beenden
echo Bitte erst bei einem gewollten Shutdown schliessen
echo Please close this command only for Shutdown
echo Apache 2 is starting ...

SET OPENSSL_CONF=F:\___XAMPP___\xampp-portable-win32-5.6.31-0-VC11\apache\conf\openssl.cnf
REM IF EXIST F:\___XAMPP___\xampp-portable-win32-5.6.31-0-VC11\apache\bin
SET PATH=%PATH%;F:\___XAMPP___\xampp-portable-win32-5.6.31-0-VC11\apache\bin

DavidBruchmann

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

DavidBruchmann

/** @var ObjectManager $objm */
$dbParser = $this->objectManager->get(\TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbQueryParser::class);

$doctrineQueryBuilder = $dbParser->convertQueryToDoctrineQueryBuilder($query);
$sql = $doctrineQueryBuilder->getSQL();
$parameters = $doctrineQueryBuilder->getParameters();
\TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump(['sql' => $sql, 'parameters' => $parameters], __METHOD__ . ':' . __LINE__);