christophlehmann

#!/bin/bash -e

print_help() {
    cat <<EOF
Usage: cat versions.txt | $0 [OPTIONS]

Options:
  --major             Output major version of the latest semver
  --minor             Output minor version of the latest semver
  --patch             Output patch version of the latest semver

christophlehmann

prototypes:
  standard:
    formElementsDefinition:
      Form:
        formEditor:
          propertyCollections:
            finishers:
              # SaveToDatabase
              80:
                editors:

christophlehmann

#!/bin/bash

trap 'mysql -e "SET GLOBAL general_log=0"; exit' SIGINT SIGQUIT

log_file="$(mysql -N -e 'SHOW VARIABLES WHERE variable_name="general_log_file"' | awk '{print $2}')"
test -f $log_file && rm $log_file
mysql -e "SET GLOBAL general_log=1"
tail -f $log_file

christophlehmann

<?php

namespace My\Site\Utility;

use TYPO3\CMS\Backend\Utility\BackendUtility;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\DataHandling\Model\RecordStateFactory;
use TYPO3\CMS\Core\DataHandling\SlugHelper;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Extbase\DomainObject\DomainObjectInterface;

christophlehmann

<?php declare(strict_types=1);
namespace My\Site\Query\Modifier;

use ApacheSolrForTypo3\Solr\ConnectionManager;
use ApacheSolrForTypo3\Solr\Domain\Search\Query\QueryBuilder;
use ApacheSolrForTypo3\Solr\Domain\Search\Query\Query;
use ApacheSolrForTypo3\Solr\Query\Modifier\Modifier;
use ApacheSolrForTypo3\Solr\System\Configuration\TypoScriptConfiguration;
use ApacheSolrForTypo3\Solr\Util;
use TYPO3\CMS\Core\Utility\GeneralUtility;

christophlehmann

<?php

namespace Lemming\SiteExtension\Routing;

use TYPO3\CMS\Core\Cache\CacheManager;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Database\Query\QueryBuilder;
use TYPO3\CMS\Core\Routing\RouteCollection;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Extbase\Routing\ExtbasePluginEnhancer;

christophlehmann

#!/bin/bash

# 2 weeks
warn_in_seconds=1209600

for namespace in $(kubectl get ns | grep -v ^NAME | awk '{print $1}')
do
  for secret in $(kubectl -n $namespace get secrets | grep kubernetes.io/tls | awk '{print $1}')
  do
    cert=$(kubectl -n $namespace get secret $secret -o json | jq -r '.data["tls.crt"]')

christophlehmann

<?php
namespace Lemming\Extension\Command;

use TYPO3\CMS\Core\Database\DatabaseConnection;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Frontend\Page\CacheHashCalculator;

class CacheHashCommandController extends \TYPO3\CMS\Extbase\Mvc\Controller\CommandController
{
    const TABLE = 'tx_realurl_urldata';

christophlehmann

[Definition]

failregex = ^<HOST> .*UNION%%20SELECT%%20CHAR.*HTTP
            ^<HOST> .*select\*from.*HTTP
            ^<HOST> .*select%%20name_const.*HTTP

# Dev notes
#
# % must be escaped with '%'

christophlehmann

# First install prometheus-operator: 
# 
# helm install coreos/prometheus-operator --name prometheus-operator
#

apiVersion: monitoring.coreos.com/v1
kind: ServiceMonitor
metadata:
  name: node-exporter
  # Namespace of prometheus operator