Tomas Norre Mikkelsen tomasnorre

## README.md

      
              2 files
            
          
              0 forks
            
          
              5 comments
            
          
              9 stars
            
          
                xperseguers
                / README.md
            
            
              Last active
              March 23, 2024 18:21
            
              
                Create composer patch from a pending TYPO3 patch on Gerrit
              
          
    Following structure is expected for your TYPO3 project (adapt script if it differs):
.
├── composer.json
├── composer.lock
├── patches
│   ├── ...
│   └── ...
└── scripts


## import-production-data
#!/bin/bash

## Description: Fetch and import production data
## Usage: import-production-data
## Example: "ddev import-production-data"

SSH_CREDENTIALS="user@domain.tld"

PRODUCTION_DB_USER="user"
PRODUCTION_DB_PASSWORD="pw"

## searchIds.sh
#!/bin/bash


files=$( find $1 -name "*xlf" )

for file in $files; do

	list=$(cat $file | grep "id=" | cut -d '"' -f2)

	for i in `echo $list`; do

## debug.php

$query = $this->createQuery();

/**
 * @var \Doctrine\ORM\QueryBuilder $queryBuilder
 */
$queryBuilder = \TYPO3\Flow\Reflection\ObjectAccess::getProperty($query, 'queryBuilder', TRUE);

\TYPO3\Flow\var_dump($queryBuilder->getQuery()->getSQL(), __CLASS__ . '#' . __LINE__, FALSE, FALSE);

## DbFileSize
SELECT table_name AS Tables,
round(((data_length + index_length) / 1024 / 1024), 2) AS SizeInMB
FROM information_schema.TABLES
WHERE table_schema = "DBNAME" ORDER BY SizeInMB DESC;

## gist:5421328
10 = COA
10 {
	10 = TEXT
	10 {
		value = http://www.gravatar.com/avatar/
	}
	20 = TEXT
	20 {
		value = soren.malling@gmail.com
		hash = md5
	#!/bin/bash

	## Description: Fetch and import production data
	## Usage: import-production-data
	## Example: "ddev import-production-data"

	SSH_CREDENTIALS="user@domain.tld"

	PRODUCTION_DB_USER="user"
	PRODUCTION_DB_PASSWORD="pw"
	#!/bin/bash


	files=$( find $1 -name "*xlf" )

	for file in $files; do

	list=$(cat $file \| grep "id=" \| cut -d '"' -f2)

	for i in `echo $list`; do

	$query = $this->createQuery();

	/**
	* @var \Doctrine\ORM\QueryBuilder $queryBuilder
	*/
	$queryBuilder = \TYPO3\Flow\Reflection\ObjectAccess::getProperty($query, 'queryBuilder', TRUE);

	\TYPO3\Flow\var_dump($queryBuilder->getQuery()->getSQL(), __CLASS__ . '#' . __LINE__, FALSE, FALSE);
	SELECT table_name AS Tables,
	round(((data_length + index_length) / 1024 / 1024), 2) AS SizeInMB
	FROM information_schema.TABLES
	WHERE table_schema = "DBNAME" ORDER BY SizeInMB DESC;
	10 = COA
	10 {
	10 = TEXT
	10 {
	value = http://www.gravatar.com/avatar/
	}
	20 = TEXT
	20 {
	value = soren.malling@gmail.com
	hash = md5