xperseguers

Following structure is expected for your TYPO3 project (adapt script if it differs):

.
├── composer.json
├── composer.lock
├── patches
│   ├── ...
│   └── ...
└── scripts

peterkraume

#!/bin/bash

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

SSH_CREDENTIALS="[email protected]"

PRODUCTION_DB_USER="user"
PRODUCTION_DB_PASSWORD="pw"

tlayh

#!/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

pumatertion

$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);

georgringer

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;

sorenmalling

10 = COA
10 {
	10 = TEXT
	10 {
		value = http://www.gravatar.com/avatar/
	}
	20 = TEXT
	20 {
		value = [email protected]
		hash = md5